public void GetMessageListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int num = dbOperHandler.Count("N_UserMessage"); string sql = SqlHelp.GetSql0(num + " as totalcount,row_number() over (order by Id desc) as rowid,dbo.f_GetUserName(UserId) as UserName,*", "N_UserMessage", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON2(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON(int page, int PSize, string whereStr, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = whereStr; int num = dbOperHandler.Count("Flex_User"); string sql = SqlHelp.GetSql0(num + " as totalcount,row_number() over (order by Id asc) as rowid,*", "Flex_User", "Id", PSize, page, "asc", whereStr); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.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 void GetIphoneBankInfoJSON(string UserId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + UserId; dbOperHandler.Count("N_UserBank"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 3 * from V_UserBankInfo where UserId=" + UserId; DbOperHandler expr_46 = dbOperHandler; expr_46.SqlCmd += "order by Id desc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(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 static string GetBetDetail(string STime, string UserId, string BetId) { if (string.IsNullOrEmpty(BetDetailDAL.ReadContentFile(STime + "\\" + UserId + "\\" + BetId + ".js"))) { string str = ""; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select [Detail] from N_UserBet where Id=" + BetId; DataTable dataTable = dbOperHandler.GetDataTable(); str = string.Concat(dataTable.Rows[0]["Detail"]); dataTable.Clear(); dataTable.Dispose(); } return(BetDetailDAL.ReadContentFile(STime + "\\" + UserId + "\\" + str + ".js")); } return(BetDetailDAL.ReadContentFile(STime + "\\" + UserId + "\\" + BetId + ".js")); }
public void GetUserNameJSON(string UserName, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select '1' as result,Id,UserName,Question,Answer from N_User where UserName='******'"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { _jsonstr = base.ConverTableToJSON(dataTable); } else { _jsonstr = base.GetJsonResult(0, "用户不存在!"); } dataTable.Clear(); dataTable.Dispose(); } }
public void IsContract(string UserId, string strWhere, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT top 1 Id from N_UserContract where Type=2 and UserId=" + UserId + strWhere, new object[0]); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"}"; } else { _jsonstr = "{\"result\" :\"0\",\"returnval\" :\"操作成功\"}"; } dataTable.Clear(); dataTable.Dispose(); } }
public void GetContractInfo(string UserId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT top 1 UserGroup from N_User where Id=" + UserId); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 4) //招商 { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT 4 as [GroupId],[MinMoney],[Money],[IsUsed],[soft] FROM [Act_DayGzSet] where GroupId=4 and IsUsed=0"); dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 3) //特权直属 { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT 3 as [GroupId],[MinMoney],[Money],[IsUsed],[soft] FROM [Act_DayGzSet] where GroupId=3 and IsUsed=0"); dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) == 2) //直属 { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT 2 as [GroupId],[MinMoney],[Money],[IsUsed],[soft] FROM [Act_DayGzSet] where GroupId=2 and IsUsed=0"); dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } else if (Convert.ToInt32(dataTable.Rows[0]["UserGroup"]) >= 5) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("SELECT 5 as groupId"); dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } else //代理,会员 { dbOperHandler.Reset(); dbOperHandler.SqlCmd = @"SELECT 0 as groupId,[Type],[ParentId],[UserId],[IsUsed],[STime],b.* FROM [N_UserContract] a left join [N_UserContractDetail] b on a.Id=b.UcId where Type=2 and UserId=" + UserId; dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; } } dataTable.Clear(); dataTable.Dispose(); } }
public int GetIphoneChargeSetByCode(string code) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { int chargeSetId = 0; dbOperHandler.SqlCmd = "SELECT * from Sys_ChargeSet where UCode in ('" + code + "')"; dbOperHandler.SqlCmd += " ORDER BY Id asc"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable != null && dataTable.Rows.Count > 0) { Int32.TryParse(dataTable.Rows[0]["id"].ToString(), out chargeSetId); } dataTable.Clear(); dataTable.Dispose(); return(chargeSetId); } }
public void getSysBankBinByIdJson(string BankId, string BankBin, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.SqlCmd = string.Concat(new string[] { "SELECT top 1 * from Sys_BankBinInfo where BankId=", BankId, " and BankBin='", BankBin, "'" }); DbOperHandler expr_3F = dbOperHandler; expr_3F.SqlCmd += " ORDER BY Id asc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
/// <summary> /// 获取用户最大提成百分比 /// </summary> /// <param name="userId">用户Id</param> /// <param name="type">提成类型</param> /// <returns></returns> public bool HasUsedContract(int userId, int type) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { bool hasContract = false; dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format(@"SELECT 1 FROM N_UserContract where [Type]={0} AND UserId={1} AND IsUsed=1", type, userId); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { hasContract = true; } dataTable.Clear(); dataTable.Dispose(); return(hasContract); } }
/// <summary> /// 是否是管理员用户 /// </summary> /// <param name="userId"></param> /// <returns></returns> public bool IsAdminUser(int userId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { bool isAdminUser = false; UserModel user = null; dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select 1 from N_User where IsNull(ParentId, 0)=0 AND UserGroup in (5,6) AND Id=" + userId; DataTable table = dbOperHandler.GetDataTable(); if (table != null && table.Rows.Count > 0) { isAdminUser = true; } table.Clear(); table.Dispose(); return(isAdminUser); } }
/// <summary> /// 获取用户最大提成百分比 /// </summary> /// <param name="userId">用户Id</param> /// <param name="type">提成类型</param> /// <returns></returns> public double GetMaxPercent(int userId, int type) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { double percent = 0; dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format(@"SELECT MAX([money]) AS MaxPer FROM N_UserContract A INNER JOIN N_UserContractDetail B ON A.Id = B.UcId WHERE A.[Type]={0} AND UserId={1}", type, userId); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { percent = Convert.IsDBNull(dataTable.Rows[0]["MaxPer"]) ? 0 : (double)dataTable.Rows[0]["MaxPer"]; } dataTable.Clear(); dataTable.Dispose(); return(percent); } }
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", UserId); object field = dbOperHandler.GetField("N_User", "Point"); dbOperHandler.SqlCmd = string.Concat(new object[] { "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>=", Convert.ToDouble(MinPoint.Replace("%", "")) * 10.0 }); DbOperHandler expr_88 = dbOperHandler; expr_88.SqlCmd += " ORDER BY Bonus asc"; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public void GetIphoneListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Flex_UserGetCash"); string sql = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,0.0000 as sxf,*", "Flex_UserGetCash", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = string.Concat(new string[] { "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"", PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);"), "\",", dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)), "}" }); dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("N_UserBank"); string sql = SqlHelp.GetSql0("row_number() over (order by Id asc) as rowid,'************'+substring(Payaccount,len(Payaccount)-3,4) as tPayaccount,substring(PayName,1,1)+'**' as tPayName,*", "N_UserBank", "Id", _pagesize, _thispage, "asc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = string.Concat(new string[] { "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"", PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);"), "\",", dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)), "}" }); dataTable.Clear(); dataTable.Dispose(); } }
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 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 void ajaxGetProListSub(string AdminId, int page, int PSize, string whereStr, string UserName, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { bool flag = true; if (!string.IsNullOrEmpty(UserName)) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Concat(new string[] { "select Id from N_User where UserName='******' and UserCode like (select UserCode from N_User where Id=", AdminId, ")+'%'" }); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { AdminId = dataTable.Rows[0]["Id"].ToString(); } else { flag = false; _jsonstr = "[]"; } } if (flag) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = " ParentId = " + AdminId + " or Id=" + AdminId; int num = dbOperHandler.Count("N_User"); string text = string.Format("select {1} as totalcount, {0} as UserID,\r\n (select Convert(varchar(10),cast(round([Point]/10.0,2) as numeric(5,2))) from N_User with(nolock) where Id={0} ) as userpoint,\r\n dbo.f_GetUserName({0}) as userName,\r\n (select isnull(sum(money),0) from N_User with(nolock) where Id = {0}) as money,\r\n isnull(sum(b.Charge),0) Charge,isnull(sum(b.GetCash),0) GetCash,isnull(sum(b.Bet),0)-isnull(sum(b.Cancellation),0) Bet,isnull(sum(b.Point),0) Point,isnull(sum(b.Win),0) Win,isnull(sum(b.Cancellation),0) Cancellation,isnull(sum(b.TranAccIn),0) TranAccIn,isnull(sum(b.TranAccOut),0) TranAccOut,isnull(sum(b.Give),0) Give,isnull(sum(b.Other),0) Other,isnull(sum(b.Change),0) Change,\r\n (isnull(sum(Win),0)+isnull(sum(Point),0)+isnull(sum(Change),0)+isnull(sum(Give),0)+isnull(sum(Cancellation),0))-isnull(sum(Bet),0) as total,\r\n (isnull(sum(Charge),0)-isnull(sum(getcash),0)) as moneytotal\r\n from Flex_UserMoneyStatAll b with(nolock)\r\n where {2} and UserId={0}", AdminId, num, whereStr); text += " union all "; dbOperHandler.Reset(); dbOperHandler.SqlCmd = SqlHelp.GetSql0("Id,UserName,Money,Point", "N_User", "ID", PSize, page, "asc", " ParentId = " + AdminId); DataTable dataTable = dbOperHandler.GetDataTable(); for (int i = 0; i < dataTable.Rows.Count; i++) { string text2 = whereStr + " and UserCode like '%" + Strings.PadLeft(dataTable.Rows[i]["Id"].ToString()) + "%'"; text += string.Format("select {0} as totalcount, {1} as UserID,\r\n Convert(varchar(10),cast(round({2}/10.0,2) as numeric(5,2))) as userpoint,\r\n '{3}' as userName,\r\n isnull(sum({4}),0) as money,\r\n isnull(sum(b.Charge),0) Charge,isnull(sum(b.GetCash),0) GetCash,isnull(sum(b.Bet),0)-isnull(sum(b.Cancellation),0) Bet,isnull(sum(b.Point),0) Point,isnull(sum(b.Win),0) Win,isnull(sum(b.Cancellation),0) Cancellation,isnull(sum(b.TranAccIn),0) TranAccIn,isnull(sum(b.TranAccOut),0) TranAccOut,isnull(sum(b.Give),0) Give,isnull(sum(b.Other),0) Other,isnull(sum(b.Change),0) Change,\r\n (isnull(sum(Win),0)+isnull(sum(Point),0)+isnull(sum(Change),0)+isnull(sum(Give),0)+isnull(sum(Cancellation),0))-isnull(sum(Bet),0) as total,\r\n (isnull(sum(Charge),0)-isnull(sum(getcash),0)) as moneytotal\r\n from Flex_UserMoneyStatAll b with(nolock)\r\n where {5}", new object[] { num, dataTable.Rows[i]["Id"].ToString(), dataTable.Rows[i]["Point"].ToString(), dataTable.Rows[i]["UserName"].ToString(), dataTable.Rows[i]["Money"].ToString(), text2 }); text += " union all "; } text += string.Format("select {2} as totalcount, '-1' as UserID,'合计' as userpoint,'' as userName,\r\n (select isnull(sum(money),0) from N_User with(nolock) where UserCode like '%,{0},%') as money,\r\n isnull(sum(b.Charge),0) Charge,isnull(sum(b.GetCash),0) GetCash,isnull(sum(b.Bet),0)-isnull(sum(b.Cancellation),0) Bet,isnull(sum(b.Point),0) Point,isnull(sum(b.Win),0) Win,isnull(sum(b.Cancellation),0) Cancellation,isnull(sum(b.TranAccIn),0) TranAccIn,isnull(sum(b.TranAccOut),0) TranAccOut,isnull(sum(b.Give),0) Give,isnull(sum(b.Other),0) Other,isnull(sum(b.Change),0) Change,\r\n (isnull(sum(Win),0)+isnull(sum(Point),0)+isnull(sum(Change),0)+isnull(sum(Give),0)+isnull(sum(Cancellation),0))-isnull(sum(Bet),0) as total,\r\n (isnull(sum(Charge),0)-isnull(sum(getcash),0)) as moneytotal\r\n FROM Flex_UserMoneyStatAll b with(nolock) where {1}", AdminId, whereStr + " and UserCode like '%" + Strings.PadLeft(AdminId) + "%'", num); dbOperHandler.Reset(); dbOperHandler.SqlCmd = text; dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } } }
public void GetListOnlineJSON(int page, int PSize, string whereStr, string UserId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = whereStr + " and UserCode like '%," + UserId + ",%'"; int num = dbOperHandler.Count("N_User"); string sql = SqlHelp.GetSql0(num + " as totalcount,ID,UserName,UserCode,Money,LastTime", "N_User", "Id", PSize, page, "asc", whereStr + " and UserCode like '%," + UserId + ",%'"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); string text = ""; if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { string text2 = string.Empty; string text3 = dataTable.Rows[i]["UserCode"].ToString().Replace(",,", "_").Replace(",", ""); text3 = text3.Substring(text3.IndexOf(UserId)); string[] array = text3.Split(new char[] { '_' }); if (array.Length > 0) { for (int j = 0; j < array.Length; j++) { if (!string.IsNullOrEmpty(array[j])) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=" + array[j]; text2 = text2 + dbOperHandler.GetField("N_User", "UserName") + ">"; } } text2 = text2.Substring(0, text2.Length - 1); if (i != 0) { text += " union all "; } object obj = text; text = string.Concat(new object[] { obj, " select ", num, " as totalcount,row_number() over (order by Id asc) as rowid,ID,UserName,UserCode,Money,'", text2, "' as CodeName,LastTime from N_User where Id=", dataTable.Rows[i]["Id"] }); } } dbOperHandler.Reset(); dbOperHandler.SqlCmd = text; dataTable = dbOperHandler.GetDataTable(); } _jsonstr = base.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
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 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 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("申请提现成功!"); } }