public int SaveChargeInfo(string SsId, string UserId, string BankId, string CheckCode, decimal Money) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { int num = 0; if (BankId == "888") { num = 1; } dbOperHandler.Reset(); dbOperHandler.AddFieldItem("SsId", SsId); dbOperHandler.AddFieldItem("UserId", UserId); dbOperHandler.AddFieldItem("BankId", BankId); dbOperHandler.AddFieldItem("CheckCode", CheckCode); dbOperHandler.AddFieldItem("InMoney", Money); dbOperHandler.AddFieldItem("STime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("State", num); result = dbOperHandler.Insert("N_UserCharge"); } return(result); }
public string Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName, string strPwd) { 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.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)userId); object field = dbOperHandler.GetField("N_User", "PayPass"); if (!MD5.Last64(strPwd).Equals(field.ToString())) { return(this.GetJsonResult(0, "绑定失败,您的提现密码错误!")); } 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 string Save(string code, string SendId, string ReceiveId, string Title, string Contents) { string str1 = ""; ArrayList arrayList = new ArrayList(); using (DbOperHandler dbOperHandler = new ComData().Doh()) { if (!string.IsNullOrEmpty(ReceiveId)) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserName=@UserName"; dbOperHandler.AddConditionParameter("@UserName", (object)ReceiveId); ReceiveId = string.Concat(dbOperHandler.GetField("N_User", "Id")); arrayList.Add((object)ReceiveId); } else { switch (code) { case "0": dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)SendId); string str2 = string.Concat(dbOperHandler.GetField("N_User", "ParentId")); if (str2.Equals("0")) { str1 = "您没有上级不能发送!"; break; } arrayList.Add((object)str2); break; case "1": dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select Id from N_User where ParentId={0}", (object)SendId); DataTable dataTable1 = dbOperHandler.GetDataTable(); if (dataTable1.Rows.Count < 1) { str1 = "您没有直属下级不能发送!"; break; } for (int index = 0; index < dataTable1.Rows.Count; ++index) { arrayList.Add((object)dataTable1.Rows[index]["Id"].ToString()); } break; case "2": dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select Id from N_User where UserCode like '%{0}%' and Id<>{0}", (object)Strings.PadLeft(SendId)); DataTable dataTable2 = dbOperHandler.GetDataTable(); if (dataTable2.Rows.Count < 1) { str1 = "您没有下级不能发送!"; break; } for (int index = 0; index < dataTable2.Rows.Count; ++index) { arrayList.Add((object)dataTable2.Rows[index]["Id"].ToString()); } break; } } foreach (string str3 in arrayList) { dbOperHandler.Reset(); dbOperHandler.AddFieldItem("SendId", (object)SendId); dbOperHandler.AddFieldItem("ReceiveId", (object)str3); dbOperHandler.AddFieldItem("Title", (object)Title); dbOperHandler.AddFieldItem("Contents", (object)Contents); dbOperHandler.AddFieldItem("STime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IsRead", (object)"0"); str1 = dbOperHandler.Insert("N_UserEmail") <= 0 ? "发送失败!" : "发送成功!"; } return(str1); } }
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] { { (object)"ParentId", (object)"UserGroup", (object)"UserName", (object)"Password", (object)"Point", (object)"PayPass" }, { (object)_ParentId, (object)_UserGroup, (object)_UserName.ToLower(), (object)str, (object)_Point, (object)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] { { (object)"UserId", (object)"Change" }, { (object)num, (object)0 } }; dbOperHandler.Reset(); dbOperHandler.AddFieldItems(_vFields2); dbOperHandler.Insert("N_UserMoneyStatAll"); return(this.GetJsonResult(1, "添加会员成功!")); } }
public string Save(string code, string SendId, string ReceiveId, string Title, string Contents) { string text = ""; ArrayList arrayList = new ArrayList(); string result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { if (!string.IsNullOrEmpty(ReceiveId)) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserName=@UserName"; dbOperHandler.AddConditionParameter("@UserName", ReceiveId); ReceiveId = string.Concat(dbOperHandler.GetField("N_User", "Id")); arrayList.Add(ReceiveId); } else if (code != null) { if (!(code == "0")) { if (!(code == "1")) { if (code == "2") { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select Id from N_User where UserCode like '%{0}%' and Id<>{0}", Strings.PadLeft(SendId)); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count < 1) { text = "您没有下级不能发送!"; } else { for (int i = 0; i < dataTable.Rows.Count; i++) { arrayList.Add(dataTable.Rows[i]["Id"].ToString()); } } } } else { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select Id from N_User where ParentId={0}", SendId); DataTable dataTable2 = dbOperHandler.GetDataTable(); if (dataTable2.Rows.Count < 1) { text = "您没有直属下级不能发送!"; } else { for (int j = 0; j < dataTable2.Rows.Count; j++) { arrayList.Add(dataTable2.Rows[j]["Id"].ToString()); } } } } else { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", SendId); string text2 = string.Concat(dbOperHandler.GetField("N_User", "ParentId")); if (text2.Equals("0")) { text = "您没有上级不能发送!"; } else { arrayList.Add(text2); } } } foreach (string fieldValue in arrayList) { dbOperHandler.Reset(); dbOperHandler.AddFieldItem("SendId", SendId); dbOperHandler.AddFieldItem("ReceiveId", fieldValue); dbOperHandler.AddFieldItem("Title", Title); dbOperHandler.AddFieldItem("Contents", Contents); dbOperHandler.AddFieldItem("STime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("IsRead", "0"); if (dbOperHandler.Insert("N_UserEmail") > 0) { text = "发送成功!"; } else { text = "发送失败!"; } } result = text; } return(result); }
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); }