C#三层架构的UserService类（注册登录使用）

1.结合DBHelper类使用
2.三层架构的使用详细说明

直接源码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

///
///UserService 的摘要说明
///
public class UserService
{
public UserService()
{
//
//TODO: 在此处添加构造函数逻辑
//
}

//登录查找
public static GP_User GetUserByName(string user_id)
{
    string sql = "select * from SYS_USER where USER_ID = '" + user_id + "'";
    DB db = new DB();
    int vaul = db.sqlEx(sql);
    int cot = db.reDt(sql).Rows.Count;
    if (vaul == 1 && cot > 0)
    {
        GP_User user = new GP_User();
        user.User_id = db.reDt(sql).Rows[0]["USER_ID"].ToString();
        user.User_pwd_inte = db.reDt(sql).Rows[0]["user_pwd_inte"].ToString();
        return user;
    }
    else
    {
        return null;
    }
}

/*//注册时候证件号不能相同*/

//注册增加数据
public static GP_User InsertYH(string pwd, string user_id, string user_code, string user_name, string mob_code, string email, string idcode, string sexcode, string guipeiclass)
{
    DateTime DT = System.DateTime.Now;
    string dt = System.DateTime.Now.ToString();
    string sql = "insert into SYS_USER (USER_ID,USER_CODE,USER_NAME,MOB_CODE,EMAIL,SEX,USER_PWD,DEPT_ID,ADD_USERID,ADD_DATE) VALUES ('" + user_id + "', '" + user_code + "','" + user_name + "','" + mob_code + "','" + email + "','" + sexcode + "','" + pwd + "','20050003','jxstar75593','" + dt + "')";
    string sql3 = "insert into base_user (base_user_id,userid,idno,username,idcode,sexcode,mobile,email,add_userid,add_date,dateupload,cultivate_style,auditcode,recruitcode,areacode) VALUES ('" + user_id + "','" + user_id + "', '" + user_code + "','" + user_name + "','" + idcode + "','" + sexcode + "','" + mob_code + "','" + email + "','" + user_id + "','" + dt + "','0','" + guipeiclass + "','0','2','440000')";
    string sql4 = "insert into SYS_USER_ROLE (USER_ROLE_ID,USER_ID,ROLE_ID,ADD_DATE) VALUES ('" + user_id + "','" + user_id + "','zh822185','" + dt + "')";
    string sql5 = "insert into SYS_USER_DATA (USER_DATA_ID,USER_ID,DTYPE_ID,ADD_USERID,ADD_DATE,DTYPE_DATA,HAS_SUB,DISPLAY) values ('" + user_id + "','" + user_id + "','jxstar3','administrator','" + dt + "','" + user_id + "','1','" + user_name + "');";
    string sange = @"[{""x"":10,""y"":10,""width"":340,""height"":240,""title"":""消息栏"",""iconCls"":""nav_msg"",""collapse"":""0"",""id"":""jxstar216928"",""typecode"":""portlet_send"",""objectid"":""""},{""x"":360,""y"":10,""width"":370,""height"":240,""title"":""待办工作"",""iconCls"":""nav_warn"",""collapse"":""0"",""id"":""jxstar110426"",""typecode"":""portlet_warn"",""objectid"":""""}]";
    string sql6 = "insert into PLET_TEMP_SET (TEMPLET_ID,EDIT_USERID,SET_TYPE,SET_ID,ADD_USERID,ADD_DATE,SET_CONFIG) VALUES ('jxstar2377','" + user_id + "','1','" + user_id + "','" + user_id + "','" + dt + "','" + sange + "')";

    string sqlnew1 = "insert into SYS_NEWS (STATE,CONT_TYPE,EDIT_DATE,EDIT_USER,EDIT_USERID,NEWS_ID,ADD_USERID,ADD_DATE,NEWS_CODE,NEWS_CONT)  VALUES ('1','0','" + dt + "','卫计委','" + user_id + "','" + user_id + "','administrator','" + dt + "','" + user_id + "','请完善你的信息！')";

    DB db = new DB();
    string sql2 = "select * from SYS_USER where USER_ID = '" + user_id + "'";
    string sql21 = "select * from base_user where userid = '" + user_id + "'";
    int cot = db.reDt(sql2).Rows.Count;
    int cot1 = db.reDt(sql21).Rows.Count;
    if (cot == 0 && cot1 == 0)
    {

        int reValue = db.sqlEx(sql);
        int rrr = db.sqlEx(sql4);
        int rr = db.sqlEx(sql3);
        int rrrr = db.sqlEx(sql5);
        int r6 = db.sqlEx(sql6);
        int new1 = db.sqlEx(sqlnew1);
        if (reValue == 1 && rrrr == 1 && rr == 1 && rrr == 1)
        {
            GP_User user = new GP_User();
            user.User_id = user_id;
            return user;
        }
        else
        {
            return null;
        }
    }
    else
    {
        return null;
    }
}


//注册检索手机号
public static bool GetUserPhone(string phone)
{
    string sql = "select mobile from base_user where mobile='" + phone + "'";
    DB db = new DB();
    int vaul = db.sqlEx(sql);
    int cot = db.reDt(sql).Rows.Count;
    if (cot > 1)
    {
        return true;
    }
    else
    {
        return false;
    }
}


//密码找回检查帐号信息
public static GP_User GetUserPwd(string user_id, string gname, string email)
{
    string sql = "select * from SYS_USER where USER_ID = '" + user_id + "' and USER_NAME ='" + gname + "' and EMAIL = '" + email + "'";
    DB db = new DB();
    int vaul = db.sqlEx(sql);
    int cot = db.reDt(sql).Rows.Count;
    if (vaul == 1 && cot > 0)
    {
        GP_User user = new GP_User();
        user.User_id = user_id;
        return user;
    }
    else
    {
        return null;
    }
}

//密码重置
public static GP_User RUserPwd(string user_id, string pwd)
{
    DB db = new DB();
    string pwdd = db.GetMD5(pwd);
    string sql = "update SYS_USER set USER_PWD='" + pwdd + "'  where USER_ID = '" + user_id + "' ";
    int vaul = db.sqlNonQuery(sql);
    //int cot = db.reDt(sql).Rows.Count;
    if (vaul > 0)
    {
        GP_User user = new GP_User();
        user.User_id = user_id;
        return user;
    }
    else
    {
        return null;
    }
}

}