public string UpdateContractState(string UserId, string state) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Type=2 and UserId=@UserId"; dbOperHandler.AddConditionParameter("@UserId", (object)UserId); dbOperHandler.AddFieldItem("IsUsed", (object)state); dbOperHandler.AddFieldItem("STime2", (object)DateTime.Now); if (dbOperHandler.Update("N_UserContract") > 0) { return(this.JsonResult(1, "契约签订成功!")); } } return(this.JsonResult(0, "契约签订失败!")); }
public string UpdateInfo(string UserId, string QQ, string Email, string Mobile) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + UserId; dbOperHandler.AddFieldItem("QQ", (object)QQ); dbOperHandler.AddFieldItem("Email", (object)Email); dbOperHandler.AddFieldItem("Mobile", (object)Mobile); if (dbOperHandler.Update("N_User") > 0) { return(this.GetJsonResult(1, "基本信息保存成功!")); } return(this.GetJsonResult(0, "基本信息保存失败!")); } }
public string ClearUserPassword(string _userid, string Password) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_userid); dbOperHandler.AddFieldItem("PassWord", (object)MD5.Last64(MD5.Lower32(Password))); dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp); if (dbOperHandler.Update("N_User") > 0) { return(this.GetJsonResult(1, "重置密码成功!")); } return(this.GetJsonResult(0, "重置密码失败!")); } }
public string Register(string _ParentId, string _UserGroup, string _UserName, string _Password, string _Point) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT Id FROM [N_User] WHERE [UserName]='" + _UserName.ToLower() + "'"; if (dbOperHandler.GetDataTable().Rows.Count > 0) { return(this.GetJsonResult(0, "账号已存在,请更换一个账号!")); } string str = MD5.Last64(MD5.Lower32(_Password)); object[,] _vFields1 = new object[2, 6] { { "ParentId", "UserGroup", "UserName", "Password", "Point", "PayPass" }, { _ParentId, _UserGroup, _UserName.ToLower(), str, _Point, MD5.Last64(MD5.Lower32("123456")) } }; dbOperHandler.Reset(); dbOperHandler.AddFieldItems(_vFields1); int num = dbOperHandler.Insert("N_User"); if (num <= 0) { return(this.GetJsonResult(0, "添加会员失败!")); } dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_ParentId); object field = dbOperHandler.GetField("N_User", "UserCode"); dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + (object)num; dbOperHandler.AddFieldItem("UserCode", (object)(field.ToString() + Strings.PadLeft(num.ToString()))); dbOperHandler.Update("N_User"); object[,] _vFields2 = new object[2, 2] { { "UserId", "Change" }, { num, 0 } }; dbOperHandler.Reset(); dbOperHandler.AddFieldItems(_vFields2); dbOperHandler.Insert("N_UserMoneyStatAll"); return(this.GetJsonResult(1, "添加会员成功!")); } }
public string ChangePayPassword(string _userid, string _oldPassword, string _newPassword) { string jsonResult; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", _userid); object field = dbOperHandler.GetField("N_User", "PayPass"); if (field != null) { if (field.ToString().ToLower() == MD5.Last64(MD5.Lower32(_oldPassword))) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", _userid); dbOperHandler.AddFieldItem("PayPass", MD5.Last64(MD5.Lower32(_newPassword))); dbOperHandler.AddFieldItem("IP", Const.GetUserIp); if (dbOperHandler.Update("N_User") > 0) { jsonResult = base.GetJsonResult(1, "取款密码修改成功!"); } else { jsonResult = base.GetJsonResult(0, "取款密码修改失败!"); } } else { jsonResult = base.GetJsonResult(0, "原取款密码错误!"); } } else { jsonResult = base.GetJsonResult(0, "原取款密码错误!"); } } return(jsonResult); }
public string UpdateInfo(string UserId, string QQ, string Email, string Mobile) { string jsonResult; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + UserId; dbOperHandler.AddFieldItem("QQ", QQ); dbOperHandler.AddFieldItem("Email", Email); dbOperHandler.AddFieldItem("Mobile", Mobile); if (dbOperHandler.Update("N_User") > 0) { jsonResult = base.GetJsonResult(1, "基本信息保存成功!"); } else { jsonResult = base.GetJsonResult(0, "基本信息保存失败!"); } } return(jsonResult); }
public void GetMsgJSON(string UserId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 Id,title,Msg from N_UserMessage with(nolock) where IsRead=0 and UserId=" + UserId + " order by Id desc"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)dataTable.Rows[0]["Id"].ToString()); dbOperHandler.AddFieldItem("IsRead", (object)"1"); dbOperHandler.Update("N_UserMessage"); _jsonstr = this.ConverTableToJSON(dataTable); } else { _jsonstr = "[{\"title\":\"0\",\"msg\":\"0\"}]"; } dataTable.Clear(); dataTable.Dispose(); } }
public string Register(string _ParentId, string _UserGroup, string _UserName, string _Password, string _Point) { string jsonResult; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT Id FROM [N_User] WHERE [UserName]='" + _UserName.ToLower() + "'"; if (dbOperHandler.GetDataTable().Rows.Count > 0) { jsonResult = base.GetJsonResult(0, "账号已存在,请更换一个账号!"); } else { string text = MD5.Last64(MD5.Lower32(_Password)); object[,] array = new object[2, 6]; array[0, 0] = "ParentId"; array[0, 1] = "UserGroup"; array[0, 2] = "UserName"; array[0, 3] = "Password"; array[0, 4] = "Point"; array[0, 5] = "PayPass"; array[1, 0] = _ParentId; array[1, 1] = _UserGroup; array[1, 2] = _UserName.ToLower(); array[1, 3] = text; array[1, 4] = _Point; array[1, 5] = MD5.Last64(MD5.Lower32("123456")); object[,] vFields = array; dbOperHandler.Reset(); dbOperHandler.AddFieldItems(vFields); int num = dbOperHandler.Insert("N_User"); if (num > 0) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", _ParentId); object field = dbOperHandler.GetField("N_User", "UserCode"); dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + num; dbOperHandler.AddFieldItem("UserCode", field + Strings.PadLeft(num.ToString())); dbOperHandler.Update("N_User"); object[,] array2 = new object[2, 2]; array2[0, 0] = "UserId"; array2[0, 1] = "Change"; array2[1, 0] = num; array2[1, 1] = 0; object[,] vFields2 = array2; dbOperHandler.Reset(); dbOperHandler.AddFieldItems(vFields2); dbOperHandler.Insert("N_UserMoneyStatAll"); jsonResult = base.GetJsonResult(1, "添加会员成功!"); } else { jsonResult = base.GetJsonResult(0, "添加会员失败!"); } } } return(jsonResult); }