public void ClearUser() { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5"; if (dbOperHandler.Exist("N_User")) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5"; dbOperHandler.AddFieldItem("IsOnline", "0"); dbOperHandler.AddFieldItem("SessionId", Guid.NewGuid().ToString().Replace("-", "")); dbOperHandler.Update("N_User"); } } }
public void SaveUserRegLink(string UserId, decimal Point, string YxTime, string Times, string Url) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = string.Concat(new object[] { "UserId=", UserId, " and Point=", Point }); if (dbOperHandler.Exist("N_UserRegLink")) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = string.Concat(new object[] { "UserId=", UserId, " and Point=", Point }); dbOperHandler.AddFieldItem("UserId", UserId); dbOperHandler.AddFieldItem("Point", Point); dbOperHandler.AddFieldItem("YxTime", YxTime); dbOperHandler.AddFieldItem("Times", Times); dbOperHandler.AddFieldItem("Url", Url); dbOperHandler.Update("N_UserRegLink"); } else { dbOperHandler.Reset(); dbOperHandler.AddFieldItem("UserId", UserId); dbOperHandler.AddFieldItem("Point", Point); dbOperHandler.AddFieldItem("YxTime", YxTime); dbOperHandler.AddFieldItem("Times", Times); dbOperHandler.AddFieldItem("Url", Url); dbOperHandler.Insert("N_UserRegLink"); } } }
public bool ChangePayPassword(string _userid, string _oldPassword, string _newPassword) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_userid); object field = dbOperHandler.GetField("N_User", "PayPass"); if (field == null || !(field.ToString().ToLower() == MD5.Last64(_oldPassword))) { return(false); } dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_userid); dbOperHandler.AddFieldItem("PayPass", (object)MD5.Last64(_newPassword)); dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp); dbOperHandler.Update("N_User"); return(true); } }
public bool SaveMobile(string _userid, string _name) { bool result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", _userid); dbOperHandler.AddFieldItem("Mobile", _name); if (dbOperHandler.Update("N_User") > 0) { result = true; } else { result = false; } } return(result); }
public string ChkAutoLoginWebApp(string _Id, string _sessionId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select top 1 UserName,Point,sessionId from N_User with(nolock) where Id={0}", _Id); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (!string.IsNullOrEmpty(string.Concat(dataTable.Rows[0]["sessionId"]))) { NameValueCollection nameValueCollection = new NameValueCollection(); nameValueCollection.Add("id", _Id); nameValueCollection.Add("name", dataTable.Rows[0]["UserName"].ToString()); nameValueCollection.Add("cookiess", dataTable.Rows[0]["sessionId"].ToString()); nameValueCollection.Add("point", dataTable.Rows[0]["Point"].ToString()); Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, nameValueCollection, this.site.CookieDomain, this.site.CookiePath); } else { string text = Guid.NewGuid().ToString().Replace("-", ""); dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", _Id); dbOperHandler.AddFieldItem("sessionId", text); dbOperHandler.Update("N_User"); dbOperHandler.Dispose(); NameValueCollection nameValueCollection2 = new NameValueCollection(); nameValueCollection2.Add("id", _Id); nameValueCollection2.Add("name", dataTable.Rows[0]["UserName"].ToString()); nameValueCollection2.Add("cookiess", text); nameValueCollection2.Add("point", dataTable.Rows[0]["Point"].ToString()); Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, nameValueCollection2, this.site.CookieDomain, this.site.CookiePath); } } } return(_Id); }
public string ChkAutoLoginWebApp(string _Id, string _sessionId, int iExpires) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select top 1 UserName,Point,sessionId from N_User with(nolock) where Id={0}", (object)_Id); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (!string.IsNullOrEmpty(string.Concat(dataTable.Rows[0]["sessionId"]))) { Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, new NameValueCollection() { { "id", _Id }, { "name", dataTable.Rows[0]["UserName"].ToString() }, { "cookiess", dataTable.Rows[0]["sessionId"].ToString() }, { "point", dataTable.Rows[0]["Point"].ToString() } }, "www.youle1288.com;youle1288.com;www.youle2888.com;youle2888.com,feifan1188.com,www.feifan1188.com", this.site.CookiePath); } else { string str = Guid.NewGuid().ToString().Replace("-", ""); dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)_Id); dbOperHandler.AddFieldItem("sessionId", (object)str); dbOperHandler.Update("N_User"); dbOperHandler.Dispose(); Cookie.SetObj(this.site.CookiePrev + "WebApp", 1, new NameValueCollection() { { "id", _Id }, { "name", dataTable.Rows[0]["UserName"].ToString() }, { "cookiess", str }, { "point", dataTable.Rows[0]["Point"].ToString() } }, "www.youle1288.com;youle1288.com;www.youle2888.com;youle2888.com,feifan1188.com,www.feifan1188.com", this.site.CookiePath); } } return(_Id); } }