private void LoginInfo(HttpContext context, DataTable dtlogin, string OWNER_address) { RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal(); string AdminHotelid = dtlogin.Rows[0]["AdminHotelid"].ToString(); string user_Account = dtlogin.Rows[0]["User_Account"].ToString(); //账户 user_idao.SysLoginLog(1, 1, user_Account, "1", OWNER_address, dtlogin.Rows[0]["User_ID"].ToString(), AdminHotelid); SessionUser user = new SessionUser(); user.UserId = dtlogin.Rows[0]["User_ID"].ToString(); user.UserAccount = dtlogin.Rows[0]["User_Account"].ToString(); user.UserName = dtlogin.Rows[0]["User_Name"].ToString(); user.UserPwd = dtlogin.Rows[0]["User_Pwd"].ToString(); user.AdminHotelid = dtlogin.Rows[0]["AdminHotelid"].ToString(); user.Hotelid = dtlogin.Rows[0]["Hotelid"].ToString(); user.HotelListId = dtlogin.Rows[0]["HotelListId"].ToString(); string IsAdmin = dtlogin.Rows[0]["IsAdmin"].ToString(); user.IsAdmin = IsAdmin; string roleName = ""; if (IsAdmin == "0") { roleName = "管理员"; } else if (IsAdmin == "1") { roleName = "管理员"; } else { roleName = dtlogin.Rows[0]["Roles_Name"].ToString(); } user.RoleName = roleName; RequestSession.ClearAllSession(); RequestSession.AddSessionUser(user); HttpCookie cookies = new HttpCookie("LoginUser_CK"); cookies.Values.Clear(); cookies.Expires = DateTime.Now.AddDays(1); cookies.Values.Add("User_ID", user.UserId.ToString()); cookies.Values.Add("User_Account", user.UserAccount.ToString()); cookies.Values.Add("AdminHotelid", user.AdminHotelid.ToString()); cookies.Values.Add("Hotelid", user.Hotelid.ToString()); cookies.Values.Add("User_Name", user.UserName.ToString()); cookies.Values.Add("UserPwd", user.UserPwd.ToString()); cookies.Values.Add("HotelListId", user.HotelListId.ToString()); cookies.Values.Add("IsAdmin", user.IsAdmin.ToString()); cookies.Values.Add("RoleName", user.RoleName.ToString()); context.Response.AppendCookie(cookies); }
public void login(HttpContext context) { string user_Account = context.Request["user_Account"]; //账户 string userPwd = context.Request["userPwd"]; //密码 string jizhu = context.Request["jizhu"]; //是否记住密码 string fhz = "5"; string sql = string.Format(@"SELECT id,User_Account,User_Pwd,User_Name,User_ID FROM dbo.ABase_UserInfo WHERE DeleteMark=1 and User_Account=@User_Account and User_Pwd=@User_Pwd"); SqlParam[] pamm = new SqlParam[] { new SqlParam("@User_Account", user_Account), new SqlParam("@User_Pwd", Md5Helper.MD5(userPwd, 32)) }; DataTable ds = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sql), pamm); if (ds != null) { if (ds.Rows.Count > 0) { RequestSession.ClearAllSession(); IPScanerHelper objScan = new IPScanerHelper(); objScan.DataPath = context.Server.MapPath("/Themes/IPScaner/QQWry.Dat"); objScan.IP = RequestHelper.GetIP(); Hashtable hs = new Hashtable(); hs["SYS_LOGINLOG_IP"] = RequestHelper.GetIP(); hs["SYS_LOGINLOG_TIME"] = DateTime.Now; hs["User_Account"] = user_Account; hs["SYS_LOGINLOG_STATUS"] = 1; hs["OWNER_address"] = objScan.IPLocation(); hs["Base_UserInfo_ID"] = ds.Rows[0]["User_ID"].ToString(); DataFactory.SqlDataBase().InsertByHashtable("ABase_SysLoginlog", hs); HttpCookie cookie = new HttpCookie("admin_cookie"); cookie.Expires = DateTime.Now.AddDays(30); if (jizhu == "1") { cookie.Values.Add("UserName", user_Account); cookie.Values.Add("PassWord", userPwd); context.Response.AppendCookie(cookie); } else { cookie.Values.Clear(); } HttpCookie cookies = new HttpCookie("dladmin_COOKIE"); cookies.Expires = DateTime.Now.AddDays(1); cookies.Values.Add("User_ID", ds.Rows[0]["User_ID"].ToString()); cookies.Values.Add("User_Account", user_Account); cookies.Values.Add("User_Name", ds.Rows[0]["User_Name"].ToString()); cookies.Values.Add("User_Pwd", ds.Rows[0]["User_Pwd"].ToString()); context.Response.AppendCookie(cookies); fhz = "3"; } else { fhz = "4";//账户或者密码有错误! } } else { fhz = "5"; } context.Response.Write(fhz);//服务连接不上! }