public int UpdateMessageIsRead(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_UserMessage"); } return(result); }
public int ReadedUserReceive(string UserId) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "ReceiveId=@UserId"; dbOperHandler.AddConditionParameter("@UserId", UserId); 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 UserTranAcc(string Type, string UserId, string ToUserId, string Money, string PassWord) { if (Convert.ToDecimal(Money) < 0m) { return(base.GetJsonResult(0, "转账金额不正确!")); } string jsonResult; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", UserId); object[] fields = dbOperHandler.GetFields("N_User", "Money,PayPass"); if (fields.Length > 0) { if (Convert.ToDecimal(Money) > Convert.ToDecimal(fields[0])) { jsonResult = base.GetJsonResult(0, "您的可用余额不足"); } else if (!MD5.Last64(MD5.Lower32(PassWord)).Equals(fields[1].ToString())) { jsonResult = base.GetJsonResult(0, "您的取款密码错误"); } else if (new UserChargeDAL().SaveUpCharge(Type, UserId, ToUserId, Convert.ToDecimal(Money)) > 0) { new LogSysDAL().Save("会员管理", string.Concat(new string[] { "Id为", UserId, "的会员转账给Id为", ToUserId, "的会员!" })); jsonResult = base.GetJsonResult(1, "转账成功!"); } else { jsonResult = base.GetJsonResult(0, "转账失败!"); } } else { jsonResult = base.GetJsonResult(0, "账号出现问题,请您重新登陆!"); } } return(jsonResult); }
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 void getUserUpPointListJson(string UserId, string MinPoint, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)UserId); object field = dbOperHandler.GetField("N_User", "Point"); dbOperHandler.SqlCmd = "SELECT point,Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2)))+'%' as title FROM [N_UserLevel] where point<" + field + " and point>=" + (object)(Convert.ToDouble(MinPoint.Replace("%", "")) * 10.0); dbOperHandler.SqlCmd += " ORDER BY Bonus asc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public void getUserPointListJson(string UserId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", UserId); object field = dbOperHandler.GetField("N_User", "Point"); dbOperHandler.SqlCmd = "SELECT point,Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2)))+'%' as title FROM [N_UserLevel] where point>=100 and point<" + field; DbOperHandler expr_4B = dbOperHandler; expr_4B.SqlCmd += " ORDER BY Bonus desc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
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 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 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); }
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 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 UserGetCash(string UserId, string UserBankId, string BankId, string Money, string PassWord) { string result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 * from Sys_Bank where id=" + BankId; DataTable dataTable = dbOperHandler.GetDataTable(); if (Convert.ToInt32(dataTable.Rows[0]["IsUsed"]) == 1) { result = "取款失败,当前银行禁止取款!"; } else { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", UserId); object[] fields = dbOperHandler.GetFields("N_User", "Money,PayPass,IsGetCash,EnableSeason,UserGroup"); if (fields.Length > 0) { int num = Convert.ToInt32(fields[2]); fields[3].ToString(); if (num != 0) { result = "取款失败,您的帐号禁止取款!"; } else if (Convert.ToDecimal(Money) > Convert.ToDecimal(fields[0])) { result = "您的可用余额不足"; } else if (!MD5.Last64(MD5.Lower32(PassWord)).Equals(fields[1].ToString())) { result = "您的提现密码错误"; } else { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select STime from Act_ActiveRecord where UserId={0} and ActiveType='Charge' and Convert(varchar(10),STime,120)=Convert(varchar(10),Getdate(),120)", UserId); DataTable dataTable2 = dbOperHandler.GetDataTable(); if (dataTable2.Rows.Count > 0) { if (Convert.ToDecimal(fields[0]) - Convert.ToDecimal(Money) < 50m) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT cast(round(isnull(Sum(Total*Times),0),4) as numeric(20,4)) as bet FROM [N_UserBet]\r\n where UserId={0} and (state=2 or state=3) and STime>'{1}' ", UserId, dataTable2.Rows[0]["STime"].ToString()); dataTable2 = dbOperHandler.GetDataTable(); if (dataTable2.Rows.Count > 0 && Convert.ToDecimal(dataTable2.Rows[0]["bet"]) < 800m) { result = "首充佣金50元不能体现,您的消费未满800元!"; return(result); } } } else if (Convert.ToInt32(fields[4].ToString()) < 2) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT (isnull(sum(Bet),0)-isnull(sum(Cancellation),0)) as bet,isnull(sum(charge),0) as charge FROM [N_UserMoneyStatAll] with(nolock) where userId=" + UserId; DataTable dataTable3 = dbOperHandler.GetDataTable(); double num2 = Convert.ToDouble(dataTable3.Rows[0]["bet"].ToString()); double num3 = Convert.ToDouble(dataTable3.Rows[0]["charge"].ToString()); if (num3 > 0.0 && num2 * 100.0 / num3 < Convert.ToDouble(dataTable.Rows[0]["BetPerCheck"])) { result = "对不起,您未消费到充值的" + dataTable.Rows[0]["BetPerCheck"] + "%,不能提现!"; return(result); } } if (Convert.ToDecimal(Money) < Convert.ToDecimal(dataTable.Rows[0]["MinCharge"])) { result = "提现金额不能小于单笔最小金额"; } else if (Convert.ToDecimal(Money) > Convert.ToDecimal(dataTable.Rows[0]["MaxCharge"])) { result = "提现金额不能大于单笔最大金额"; } else { DateTime t = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " " + dataTable.Rows[0]["StartTime"]); DateTime t2 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " " + dataTable.Rows[0]["EndTime"]); DateTime now = DateTime.Now; if (t.Hour >= t2.Hour) { if (now < t && now > t2) { result = string.Concat(new object[] { "提现时间为", dataTable.Rows[0]["StartTime"], "至", dataTable.Rows[0]["EndTime"] }); return(result); } } else if (now < t || now > t2) { result = string.Concat(new object[] { "提现时间为", dataTable.Rows[0]["StartTime"], "至", dataTable.Rows[0]["EndTime"] }); return(result); } string value = "0"; dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select count(*) as txcs,isnull(sum(Money),0) as txje from N_UserGetCash where userId=" + UserId + " and datediff(d,STime,getdate())=0 and State<>2"; DataTable dataTable4 = dbOperHandler.GetDataTable(); if (dataTable4.Rows.Count > 0) { value = dataTable4.Rows[0]["txcs"].ToString(); dataTable4.Rows[0]["txje"].ToString(); } if (Convert.ToDecimal(value) > Convert.ToDecimal(dataTable.Rows[0]["MaxGetCash"])) { result = "今日提现已得到最大提现次数"; } else { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT [PayBank],[PayAccount],[PayName] FROM [N_UserBank] where UserId=" + UserId + " and Id=" + UserBankId; dataTable4 = dbOperHandler.GetDataTable(); if (dataTable4.Rows.Count > 0) { if (this.Save(UserId, UserBankId, dataTable4.Rows[0]["PayBank"].ToString(), dataTable4.Rows[0]["PayAccount"].ToString(), dataTable4.Rows[0]["PayName"].ToString(), Convert.ToDecimal(Money)) > 0) { new LogSysDAL().Save("会员管理", "Id为" + UserId + "的会员申请提现!"); result = "申请提现成功!"; } else { result = "申请提现失败!"; } } else { result = "申请提现失败!"; } } } } } else { result = "账号出现问题,请您重新登陆!"; } } } return(result); }
public string UserGetCash(string UserId, string UserBankId, string BankId, string Money, string PassWord) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 * from Sys_Bank where id=" + BankId; DataTable dataTable1 = dbOperHandler.GetDataTable(); //每日最大提款金额 decimal minCharge = Convert.ToDecimal(dataTable1.Rows[0]["MinCharge"]); decimal maxCharge = Convert.ToDecimal(dataTable1.Rows[0]["MaxCharge"]); maxCharge = maxCharge > 20000M ? 20000M : maxCharge; if (Convert.ToDecimal(Money) > maxCharge || Convert.ToDecimal(Money) < minCharge) { return(string.Format("提款金额最大{0}元,最小{0}元", maxCharge, minCharge)); } //每日最大提现次数 int maxCashCount = Convert.ToInt32(dataTable1.Rows[0]["MaxGetCash"]); maxCashCount = maxCashCount > 5 ? 5 : maxCashCount; //充值消费额度 double betPerCheck = Convert.ToDouble(dataTable1.Rows[0]["BetPerCheck"]); betPerCheck = betPerCheck < 50.0 ? 50.0 : betPerCheck; //绑卡时间提现期限, 至少绑定24小时,才能提现 int bindTime = Convert.ToInt32(dataTable1.Rows[0]["BindTime"]); bindTime = bindTime < 24 ? 24 : bindTime; //是否允许银行卡提现 if (Convert.ToInt32(dataTable1.Rows[0]["IsUsed"]) == 1) { return("取款失败,当前银行禁止取款!"); } //会员信息 dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "id=@id"; dbOperHandler.AddConditionParameter("@id", (object)UserId); object[] fields = dbOperHandler.GetFields("N_User", "Money,PayPass,IsGetCash,EnableSeason,UserGroup"); if (fields.Length <= 0) { return("账号出现问题,请您重新登陆!"); } //会员是否允许提现 int int32 = Convert.ToInt32(fields[2]); //IsGetCash if (int32 != 0) { return("取款失败,您的帐号禁止取款!"); } //提款金额是否大于会员余额 if (Convert.ToDecimal(Money) > Convert.ToDecimal(fields[0])) { return("您的可用余额不足"); } //提款密码是否正确 if (!MD5.Last64(MD5.Lower32(PassWord)).Equals(fields[1].ToString())) { return("您的提现密码错误"); } //会员银行卡信息 dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT [PayBank],[PayAccount],[PayName], AddTime FROM [N_UserBank] where UserId=" + UserId + " and Id=" + UserBankId; DataTable dataTable5 = dbOperHandler.GetDataTable(); if (dataTable5.Rows.Count <= 0) { return("您的银行卡无效"); } //检查绑定时间 DateTime addTime = Convert.ToDateTime(dataTable5.Rows[0]["AddTime"]); if ((DateTime.Now - addTime).TotalHours <= bindTime) { return(string.Format("您的银行卡绑定还未满{0}小时", bindTime)); } //今天的充值记录 dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format(@"select STime from Act_ActiveRecord where UserId={0} and ActiveType='Charge' and Convert(varchar(10),STime,120)=Convert(varchar(10),Getdate(),120)", (object)UserId); DataTable dataTable2 = dbOperHandler.GetDataTable(); if (dataTable2.Rows.Count > 0) { if (Convert.ToDecimal(fields[0]) - Convert.ToDecimal(Money) < new Decimal(50)) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT cast(round(isnull(Sum(Total*Times),0),4) as numeric(20,4)) as bet FROM [N_UserBet]\r\n where UserId={0} and (state=2 or state=3) and STime>'{1}' ", (object)UserId, (object)dataTable2.Rows[0]["STime"].ToString()); DataTable dataTable3 = dbOperHandler.GetDataTable(); if (dataTable3.Rows.Count > 0 && Convert.ToDecimal(dataTable3.Rows[0]["bet"]) < new Decimal(800)) { return("首充佣金50元不能体现,您的消费未满800元!"); } } } else if (Convert.ToInt32(fields[4].ToString()) < 2) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT (isnull(sum(Bet),0)-isnull(sum(Cancellation),0)) as bet,isnull(sum(charge),0) as charge FROM [N_UserMoneyStatAll] with(nolock) where userId=" + UserId; DataTable dataTable3 = dbOperHandler.GetDataTable(); double num1 = Convert.ToDouble(dataTable3.Rows[0]["bet"].ToString()); //消费金额, 下注金额 double num2 = Convert.ToDouble(dataTable3.Rows[0]["charge"].ToString()); //充值金额总数 if (num2 > 0.0 && num1 * 100.0 / num2 < betPerCheck) { return("对不起,您未消费到充值的" + betPerCheck + "%,不能提现!"); } } if (Convert.ToDecimal(Money) < Convert.ToDecimal(dataTable1.Rows[0]["MinCharge"])) { return("提现金额不能小于单笔最小金额"); } if (Convert.ToDecimal(Money) > Convert.ToDecimal(dataTable1.Rows[0]["MaxCharge"])) { return("提现金额不能大于单笔最大金额"); } DateTime dateTime1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " " + dataTable1.Rows[0]["StartTime"]); DateTime dateTime2 = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " " + dataTable1.Rows[0]["EndTime"]); DateTime now = DateTime.Now; if (dateTime1.Hour >= dateTime2.Hour) { if (now < dateTime1 && now > dateTime2) { return("提现时间为" + dataTable1.Rows[0]["StartTime"] + "至" + dataTable1.Rows[0]["EndTime"]); } } else if (now < dateTime1 || now > dateTime2) { return("提现时间为" + dataTable1.Rows[0]["StartTime"] + "至" + dataTable1.Rows[0]["EndTime"]); } int cashCount = 0; //已提现次数 dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select count(*) as txcs,isnull(sum(Money),0) as txje from N_UserGetCash where userId=" + UserId + " and datediff(d,STime,getdate())=0 and State<>2"; DataTable dataTable4 = dbOperHandler.GetDataTable(); if (dataTable4.Rows.Count > 0) { cashCount = Convert.ToInt32(dataTable4.Rows[0]["txcs"]); dataTable4.Rows[0]["txje"].ToString(); } if (cashCount > maxCashCount) { return(string.Format("今日提现已得到最大提现次数{0}次", maxCashCount)); } if (dataTable5.Rows.Count <= 0 || this.Save(UserId, UserBankId, dataTable5.Rows[0]["PayBank"].ToString(), dataTable5.Rows[0]["PayAccount"].ToString(), dataTable5.Rows[0]["PayName"].ToString(), Convert.ToDecimal(Money)) <= 0) { return("申请提现失败!"); } new LogSysDAL().Save("会员管理", "Id为" + UserId + "的会员申请提现!"); return("申请提现成功!"); } }