public string UserInfo(string UserId, string SessionId) { if (!(UserId != "0") || !(SessionId != "0")) { return(this.GetJsonResult(0, "登陆已超时,请您重新登陆!")); } using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT '1' as result,Id,Money,IsDel,IsEnable,sessionId\r\n ,Convert(varchar(10),cast(round(Point/10.0,2) as numeric(10,2))) as Point\r\n ,'0' as email\r\n ,'0' as notice\r\n FROM [N_User] a where Id={0} and sessionId='{1}'", (object)UserId, (object)SessionId); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (dataTable.Rows[0]["IsDel"].Equals((object)"1") || dataTable.Rows[0]["IsEnable"].Equals((object)"1")) { return(this.GetJsonResult(0, "您的账户存在未知问题,请于客服联系!")); } dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)UserId); dbOperHandler.AddFieldItem("ontime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IsOnline", (object)1); dbOperHandler.Update("N_User"); dbOperHandler.Dispose(); return(this.ConverTableToJSON(dataTable)); } dbOperHandler.Dispose(); return(this.GetJsonResult(0, "登陆已超时,请您重新登陆")); } }
public string Login(string UserName, string UserPass) { UserName = UserName.ToLower().Replace("'", ""); UserPass = MD5.Last64(MD5.Lower32(UserPass)); string text = Guid.NewGuid().ToString().Replace("-", ""); string result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT TOP 1 '1' as result,a.Id,ParentId,UserGroup,Convert(varchar(10),cast(round(Point/10.0,2) as numeric(10,2))) as Point,\r\n UserName,Money,'{0}' as SessionId,LastTime,OnTime,IP,a.IsEnable,IsGetCash,IsBet,IsTranAcc,EnableSeason,LoginId,\r\n case when b.Id is null then '0' else '1' end as IsBank,'0' as email,'0' as notice \r\n FROM N_User a left join N_UserBank b on a.Id=b.UserId\r\n where username='******' and password='******' and isDel=0", text, UserName, UserPass); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 1) { result = base.GetJsonResult(0, "您的账户存在未知问题,请于客服联系!"); } else if (Convert.ToInt32(dataTable.Rows[0]["IsEnable"].ToString()) == 2) { result = base.GetJsonResult(0, "对不起,您的网络不稳定,请重新登录!!"); } else { this.ClearSession(); Cookie.SetObj("UserId", dataTable.Rows[0]["Id"].ToString()); Cookie.SetObj("UserName", UserName); Cookie.SetObj("UserPoint", dataTable.Rows[0]["Point"].ToString()); Cookie.SetObj("SessionId", text); string clientIP = IPHelp.ClientIP; dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", dataTable.Rows[0]["Id"].ToString()); dbOperHandler.AddFieldItem("LastTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("ontime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IP", clientIP); dbOperHandler.AddFieldItem("sessionId", text); dbOperHandler.AddFieldItem("IsOnline", 1); dbOperHandler.AddFieldItem("Source", 0); dbOperHandler.Update("N_User"); dbOperHandler.Dispose(); IPScaner iPScaner = new IPScaner(); iPScaner.DataPath = HttpContext.Current.Server.MapPath("Data/qqwry.dat"); iPScaner.IP = clientIP; string address = iPScaner.IPLocation() + iPScaner.ErrMsg; string browser = HttpContext.Current.Request.Browser.Browser + " " + HttpContext.Current.Request.Browser.Version; string oSNameByUserAgent = this.GetOSNameByUserAgent(HttpContext.Current.Request.UserAgent); new LogUserLoginDAL().Save(dataTable.Rows[0]["Id"].ToString(), address, browser, oSNameByUserAgent, clientIP); result = base.ConverTableToJSON(dataTable); } } else { dbOperHandler.Dispose(); result = base.GetJsonResult(0, "登录失败,用户名或密码错误!"); } } return(result); }