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;    }}

}