public void GetEmailListJSON(int _thispage, int _pagesize, string _wherestr1, string _userId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", _userId); string str = string.Concat(dbOperHandler.GetField("N_User", "ParentId")); dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("N_UserEmail"); string sql = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid," + str + " as parentid,dbo.f_GetUserName(SendId) as SendName,dbo.f_GetUserName(ReceiveId) as ReceiveName,*", "N_UserEmail", "STime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = string.Concat(new string[] { "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"", PageBar.GetPageBar(80, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);"), "\",", dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)), "}" }); dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON2(int _thispage, int _pagesize, string _wherestr1, string orderby, string order, string pid, string uid, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("V_User"); string sql = SqlHelp.GetSql0(pid + " as pid,*", "V_User", order, _pagesize, _thispage, orderby, _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = string.Concat(new string[] { "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"nav\" :\"", this.GetUserNav(pid, uid), "\",\"pagebar\" :\"", PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);"), "\",", dtHelp.DT2JSON(dataTable, _pagesize * (_thispage - 1)), "}" }); dataTable.Clear(); dataTable.Dispose(); } }
public void GetListCount(string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int num = dbOperHandler.Count("N_UserEmail"); _jsonstr = "{\"result\" :\"1\",\"count\" :\"" + num + "\"}"; } }
public void GetListIndexJSONFlex(int _thispage, int _pagesize, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = " IsUsed=1 and IsIndex=1"; string sql0 = SqlHelp.GetSql0(dbOperHandler.Count("Sys_News").ToString() + " as totalcount,row_number() over (order by STime desc) as rowid,Convert(varchar(10),STime,120) as shortTime,substring(title,0,18)+'...' as shortTitle,*", "Sys_News", "STime", _pagesize, _thispage, "desc", " IsUsed=1 and IsIndex=1"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON2(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public void GetListUpChargeJSON(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_UserChargeLog"); string sql0 = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,dbo.f_GetUserName(UserId) as UserName,dbo.f_GetUserName(ToUserId) as ToUserName,*", "N_UserChargeLog", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"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_ZHDetail(int _thispage, int _pagesize, string _wherestr1, string _wherestr2, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("V_UserBetZhDetail"); string sql0 = SqlHelp.GetSql0("row_number() over (order by IssueNum asc) as rowid,*,substring(Convert(varchar(20),STime2,120),6,11) as ShortTime", "V_UserBetZhDetail", "IssueNum", _pagesize, _thispage, "asc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxZhList(<#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("Sys_News"); string sql0 = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid,Convert(varchar(10),STime,120) as shortTime,substring(title,0,18)+'...' as shortTitle,Substring(Convert(varchar(10),STime,120),6,2) as tmonth,Substring(Convert(varchar(10),STime,120),9,2) as tday,*", "Sys_News", "STime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(6, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSON(dataTable) + "}"; 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("Log_UserLogin"); string sql0 = SqlHelp.GetSql0("*", "Log_UserLogin", "LoginTime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"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, string _wherestr2, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Flex_UserBet"); string sql0 = SqlHelp.GetSql0(_wherestr2 + "as isme,row_number() over (order by Id desc) as rowid,Id,SsId,UserId,UserName,UserMoney,PlayId,PlayName,PlayCode,LotteryId,LotteryName,IssueNum,SingleMoney,moshi,Times,Num,DX,DS,cast(Times*Total as decimal(15,4)) as Total,Point,PointMoney,Bonus,Bonus2,WinNum,WinBonus,RealGet,Pos,STime,STime2,substring(Convert(varchar(20),STime2,120),6,11) as ShortTime,IsOpen,State,IsWin,number,poslen", "Flex_UserBet", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"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 sql0 = 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 = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"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_ActiveRecord(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Act_ActiveRecord"); string sql0 = SqlHelp.GetSql0("Id,UserId,dbo.f_GetUserName(UserId) as UserName,ActiveType,ActiveName,InMoney,Remark,STime", "Act_ActiveRecord", "STime", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"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 GetUserLoginListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Log_UserLogin"); string sql0 = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,*", "Log_UserLogin", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\",\"pagebar\" :\"" + PageBar.GetPageBar(80, "js", 2, totalCount, _pagesize, _thispage, "javascript:ajaxList(<#page#>);") + "\"," + dtHelp.DT2JSONNOHTML(dataTable, 0, "recordcount", "table", true) + "}"; dataTable.Clear(); dataTable.Dispose(); } }
public void GetListJSON_ZH(int _thispage, int _pagesize, string _wherestr1, string _wherestr2, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; int totalCount = dbOperHandler.Count("Flex_UserBetZh"); string sql = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid,*,substring(Convert(varchar(20),STime,120),6,11) as ShortTime", "Flex_UserBetZh", "STime", _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 GetHisStoryJSON(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_History"); string sql = SqlHelp.GetSql0("row_number() over (order by Id desc) as rowid,*", "Flex_History", "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(80, "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("V_UserMoneyStatAllPoint"); string sql = SqlHelp.GetSql0("row_number() over (order by STime desc) as rowid,[UserId],dbo.f_GetUserName(UserId) as UserName,STime,Point", "V_UserMoneyStatAllPoint", "STime", _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), "}" }); dataTable.Clear(); dataTable.Dispose(); } }
public void GetActive7Money(string userId, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Code=@Code"; dbOperHandler.AddConditionParameter("@Code", "Active7"); object[] fields = dbOperHandler.GetFields("Act_ActiveSet", "StartTime,EndTime,IsUse"); if (Convert.ToInt32(fields[2]) == 1) { if (new DateTimePubDAL().GetDateTime() >= Convert.ToDateTime(fields[0]) && new DateTimePubDAL().GetDateTime() <= Convert.ToDateTime(fields[1])) { Random random = new Random(); decimal num = random.Next(this.site.SignMinTotal, this.site.SignMaxTotal); SysActiveRecordDAL sysActiveRecordDAL = new SysActiveRecordDAL(); string clientIP = IPHelp.ClientIP; dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "ActiveType='Active7' and datediff(d,STime,getdate())=0"; int num2 = dbOperHandler.Count("Act_ActiveRecord"); if (num2 <= this.site.SignNum) { if (!sysActiveRecordDAL.Exists("UserId=" + userId + " and ActiveType='Active7' and datediff(d,STime,getdate())=0")) { if (!sysActiveRecordDAL.Exists("CheckIp='" + clientIP + "' and ActiveType='Active7' and datediff(d,STime,getdate())=0")) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + userId; int num3 = dbOperHandler.Count("N_UserBank"); if (num3 > 0) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "UserId=" + userId + " and state=0"; int num4 = dbOperHandler.Count("N_UserBet"); if (num4 > 0) { _jsonstr = "您还有未开奖的订单,请开奖后再领取!"; } else { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select Bet,Cancellation from N_UserMoneyStatAll where UserId=" + userId + " and datediff(d,STime,getdate())=0"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { if (Convert.ToDecimal(dataTable.Rows[0]["Bet"]) - Convert.ToDecimal(dataTable.Rows[0]["Cancellation"]) < 50m) { _jsonstr = "签到领现失败,您的流水未得到50元!"; } else { sysActiveRecordDAL.SaveLog(userId, "Active7", "签到领现", num, "您签到领取了" + num + "元"); _jsonstr = "签到领现成功" + num + "元"; new LogSysDAL().Save("系统活动", string.Concat(new object[] { userId, "领取签到佣金", num, "元" })); } } else { _jsonstr = "签到领现失败,您的流水未得到50元!"; } } } else { _jsonstr = "签到领现失败,您未绑定银行!"; } } else { _jsonstr = "签到领现失败,您当前IP今天已领取!"; } } else { _jsonstr = "签到领现失败,您今天已领取!"; } } else { _jsonstr = "签到领现失败,今天领取已得到名额!"; } } else { _jsonstr = "领取失败,活动时间已过!"; } } else { _jsonstr = "领取失败,活动已关闭!"; } } }