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 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) { return(this.GetJsonResult(0, "原取款密码错误!")); } if (!(field.ToString().ToLower() == MD5.Last64(MD5.Lower32(_oldPassword)))) { return(this.GetJsonResult(0, "原取款密码错误!")); } dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_userid); dbOperHandler.AddFieldItem("PayPass", (object)MD5.Last64(MD5.Lower32(_newPassword))); dbOperHandler.AddFieldItem("IP", (object)Const.GetUserIp); if (dbOperHandler.Update("N_User") > 0) { return(this.GetJsonResult(1, "取款密码修改成功!")); } return(this.GetJsonResult(0, "取款密码修改失败!")); } }
public int UpdateInfo(string UserId, string Question, string Answer) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + UserId; dbOperHandler.AddFieldItem(nameof(Question), (object)Question); dbOperHandler.AddFieldItem(nameof(Answer), (object)Answer); return(dbOperHandler.Update("N_User")); } }
public int DeletesByUserReceive(string UserId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "ReceiveId=@UserId"; dbOperHandler.AddConditionParameter("@UserId", (object)UserId); dbOperHandler.AddFieldItem("IsRead", (object)"1"); dbOperHandler.AddFieldItem("IsDelReceive", (object)"1"); return(dbOperHandler.Update("N_UserEmail")); } }
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName) { if (this.Exists(" PayAccount='" + PayAccount + "'")) { return(this.GetJsonResult(0, "绑定失败,一张银行卡只能绑一个帐户!")); } if (this.Exists(" UserId=" + userId) && !this.Exists(" PayName='" + PayName + "' and UserId=" + userId)) { return(this.GetJsonResult(0, "绑定失败,同一账户下只能绑定相同的开户名卡号!")); } using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.AddFieldItem("UserId", (object)userId); dbOperHandler.AddFieldItem(nameof(PayMethod), (object)PayMethod); dbOperHandler.AddFieldItem(nameof(PayBank), (object)PayBank); dbOperHandler.AddFieldItem(nameof(PayBankAddress), (object)PayBankAddress); dbOperHandler.AddFieldItem(nameof(PayAccount), (object)PayAccount); dbOperHandler.AddFieldItem(nameof(PayName), (object)PayName); dbOperHandler.AddFieldItem("AddTime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IsLock", (object)1); if (dbOperHandler.Insert("N_UserBank") > 0) { return(this.GetJsonResult(1, "银行资料绑定成功!")); } return(this.GetJsonResult(0, "银行资料绑定失败!")); } }
public int UpdateInfo(string UserId, string Question, string Answer) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + UserId; dbOperHandler.AddFieldItem("Question", Question); dbOperHandler.AddFieldItem("Answer", Answer); result = dbOperHandler.Update("N_User"); } return(result); }
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName, string Question, string Answer) { if (this.Exists(" PayAccount='" + PayAccount + "'")) { return(base.GetJsonResult(0, "绑定失败,一张银行卡只能绑一个帐户!")); } string jsonResult; if (this.Exists(" UserId=" + userId)) { if (!this.Exists(" PayName='" + PayName + "' and UserId=" + userId)) { return(base.GetJsonResult(0, "绑定失败,同一账户下只能绑定相同的开户名卡号!")); } using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + userId; dbOperHandler.AddFieldItem("PayMethod", PayMethod); dbOperHandler.AddFieldItem("PayBank", PayBank); dbOperHandler.AddFieldItem("PayBankAddress", PayBankAddress); dbOperHandler.AddFieldItem("PayAccount", PayAccount); dbOperHandler.AddFieldItem("PayName", PayName); dbOperHandler.AddFieldItem("AddTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IsLock", 1); if (dbOperHandler.Update("N_UserBank") > 0) { new UserDAL().UpdateInfo(userId, Question, Answer); jsonResult = base.GetJsonResult(1, "银行资料绑定成功!"); return(jsonResult); } jsonResult = base.GetJsonResult(0, "银行资料绑定失败!"); return(jsonResult); } } using (DbOperHandler dbOperHandler2 = new ComData().Doh()) { dbOperHandler2.Reset(); dbOperHandler2.AddFieldItem("UserId", userId); dbOperHandler2.AddFieldItem("PayMethod", PayMethod); dbOperHandler2.AddFieldItem("PayBank", PayBank); dbOperHandler2.AddFieldItem("PayBankAddress", PayBankAddress); dbOperHandler2.AddFieldItem("PayAccount", PayAccount); dbOperHandler2.AddFieldItem("PayName", PayName); dbOperHandler2.AddFieldItem("AddTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler2.AddFieldItem("IsLock", 1); if (dbOperHandler2.Insert("N_UserBank") > 0) { new UserDAL().UpdateInfo(userId, Question, Answer); jsonResult = base.GetJsonResult(1, "银行资料绑定成功!"); } else { jsonResult = base.GetJsonResult(0, "银行资料绑定失败!"); } } return(jsonResult); }
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(nameof(QQ), (object)QQ); dbOperHandler.AddFieldItem(nameof(Email), (object)Email); dbOperHandler.AddFieldItem(nameof(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 UpdateContractState(string UserId, string state) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Type=1 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 SaveContract(string ParentId, string UserId, decimal money, decimal per) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + UserId; dbOperHandler.Delete("Act_UserFHDetail"); dbOperHandler.Reset(); dbOperHandler.AddFieldItem("ParentId", ParentId); dbOperHandler.AddFieldItem("UserId", UserId); dbOperHandler.AddFieldItem("MinMoney", money); dbOperHandler.AddFieldItem("Group3", per); dbOperHandler.AddFieldItem("IsUsed", 1); dbOperHandler.Insert("Act_UserFHDetail"); } return(base.JsonResult(1, "分配契约成功!")); }
public string SaveContract(string ParentId, string UserId, Decimal money, Decimal per) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + UserId; dbOperHandler.Delete("Act_UserFHDetail"); dbOperHandler.Reset(); dbOperHandler.AddFieldItem(nameof(ParentId), (object)ParentId); dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId); dbOperHandler.AddFieldItem("MinMoney", (object)money); dbOperHandler.AddFieldItem("Group3", (object)per); dbOperHandler.AddFieldItem("IsUsed", (object)1); dbOperHandler.Insert("Act_UserFHDetail"); } return(this.JsonResult(1, "分配契约成功!")); }
public int Save(string userId, string bankId, string checkCode, Decimal money) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { int num = 0; if (bankId == "888") { num = 1; } dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 * from Sys_Info"; DataTable dataTable = dbOperHandler.GetDataTable(); if (Convert.ToDecimal(money) < Convert.ToDecimal(dataTable.Rows[0]["MinCharge"].ToString())) { return(-1); } dbOperHandler.Reset(); dbOperHandler.AddFieldItem("SsId", (object)SsId.Charge); dbOperHandler.AddFieldItem("UserId", (object)userId); dbOperHandler.AddFieldItem("BankId", (object)bankId); dbOperHandler.AddFieldItem("CheckCode", (object)checkCode); dbOperHandler.AddFieldItem("InMoney", (object)money); dbOperHandler.AddFieldItem("STime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("State", (object)num); return(dbOperHandler.Insert("N_UserCharge")); } }
public int UpdatePoint(string UserId, string Point) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + UserId; dbOperHandler.AddFieldItem(nameof(Point), (object)Point); return(dbOperHandler.Update("N_User")); } }
public void UpdateState(string _id) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_id); dbOperHandler.AddFieldItem("IsRead", (object)"1"); dbOperHandler.Update("N_UserEmail"); } }
public int DeletesSend(string _id) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)_id); dbOperHandler.AddFieldItem("IsDelSend", (object)"1"); return(dbOperHandler.Update("N_UserEmail")); } }
public int UpdateMessageIsRead(string Id) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)Id); dbOperHandler.AddFieldItem("IsRead", (object)"1"); return(dbOperHandler.Update("N_UserMessage")); } }
public string ChangeUserPassword(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", "PassWord"); if (field != null) { if (field.ToString().ToLower() == MD5.Last64(MD5.Lower32(_oldPassword))) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", _userid); dbOperHandler.AddFieldItem("PassWord", 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 int UpdatePoint(string UserId, string Point) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=" + UserId; dbOperHandler.AddFieldItem("Point", Point); result = dbOperHandler.Update("N_User"); } return(result); }
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); }
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 int ReadedUserMessage(string UserId) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=@UserId"; dbOperHandler.AddConditionParameter("@UserId", UserId); dbOperHandler.AddFieldItem("IsRead", "1"); result = dbOperHandler.Update("N_UserMessage"); } return(result); }
public int UpdateIsRead(string Id) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", Id); dbOperHandler.AddFieldItem("IsRead", "1"); result = dbOperHandler.Update("N_UserEmail"); } return(result); }
public int DeletesByUserSend(string UserId) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=@UserId"; dbOperHandler.AddConditionParameter("@SendId", UserId); dbOperHandler.AddFieldItem("IsDelSend", "1"); result = dbOperHandler.Update("N_UserEmail"); } return(result); }
public int DeletesReceive(string _id) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", _id); dbOperHandler.AddFieldItem("IsDelReceive", "1"); result = dbOperHandler.Update("N_UserEmail"); } return(result); }
public string SaveContractState(string UserId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=@UserId"; dbOperHandler.AddConditionParameter("@UserId", UserId); dbOperHandler.AddFieldItem("IsUsed", 0); if (dbOperHandler.Update("Act_UserFHDetail") > 0) { return(base.GetJsonResult(1, "契约签订成功!")); } } return(base.GetJsonResult(0, "契约签订失败!")); }
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName, string strPwd) { if (this.Exists(" PayAccount='" + PayAccount + "'")) { return(base.GetJsonResult(0, "绑定失败,一张银行卡只能绑一个帐户!")); } if (this.Exists(" UserId=" + userId) && !this.Exists(" PayName='" + PayName + "' and UserId=" + userId)) { return(base.GetJsonResult(0, "绑定失败,同一账户下只能绑定相同的开户名卡号!")); } 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 (!MD5.Last64(strPwd).Equals(field.ToString())) { jsonResult = base.GetJsonResult(0, "绑定失败,您的提现密码错误!"); } else { dbOperHandler.Reset(); dbOperHandler.AddFieldItem("UserId", userId); dbOperHandler.AddFieldItem("PayMethod", PayMethod); dbOperHandler.AddFieldItem("PayBank", PayBank); dbOperHandler.AddFieldItem("PayBankAddress", PayBankAddress); dbOperHandler.AddFieldItem("PayAccount", PayAccount); dbOperHandler.AddFieldItem("PayName", PayName); dbOperHandler.AddFieldItem("AddTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IsLock", 1); if (dbOperHandler.Insert("N_UserBank") > 0) { jsonResult = base.GetJsonResult(1, "银行资料绑定成功!"); } else { jsonResult = base.GetJsonResult(0, "银行资料绑定失败!"); } } } return(jsonResult); }
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 int SaveChargeInfo(string SsId, string UserId, string BankId, string CheckCode, Decimal Money) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { int num = 0; if (BankId == "888") { num = 1; } dbOperHandler.Reset(); dbOperHandler.AddFieldItem(nameof(SsId), (object)SsId); dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId); dbOperHandler.AddFieldItem(nameof(BankId), (object)BankId); dbOperHandler.AddFieldItem(nameof(CheckCode), (object)CheckCode); dbOperHandler.AddFieldItem("InMoney", (object)Money); dbOperHandler.AddFieldItem("STime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("State", (object)num); return(dbOperHandler.Insert("N_UserCharge")); } }
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(); } }