public void ClearUser() { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5"; if (dbOperHandler.Exist("N_User")) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "datediff(minute,ontime ,getdate())>5"; dbOperHandler.AddFieldItem("IsOnline", "0"); dbOperHandler.AddFieldItem("SessionId", Guid.NewGuid().ToString().Replace("-", "")); dbOperHandler.Update("N_User"); } } }
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 Test(string _userid) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Format("select UserId,isnull(sum(inmoney),0) money from Act_ActiveRecord where CONVERT(varchar(10), STime, 120) = '{0}' group by UserId", _userid); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { dbOperHandler.Reset(); } } } }
public string GetLotteryNumber(int type, string title) { string result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = string.Concat(new object[] { "SELECT Number from Sys_LotteryData where Type=", type, " and title=", title }); DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { result = string.Concat(dataTable.Rows[0]["Number"]); } else { result = "0"; } } return(result); }
public void GetDnListJSON(int lotteryId, ref string _jsonstr) { DataTable table = new DataTable(); table.Columns.Add("Title"); table.Columns.Add("Number"); table.Columns.Add("Number1"); table.Columns.Add("Number2"); table.Columns.Add("Number3"); table.Columns.Add("Number4"); table.Columns.Add("Number5"); using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 18 * from Sys_LotteryData where Type=" + (object)lotteryId + " order by Title desc"; DataTable dataTable = dbOperHandler.GetDataTable(); for (int index = 0; index < dataTable.Rows.Count; ++index) { DataRow row = table.NewRow(); row["Title"] = (object)dataTable.Rows[index]["Title"].ToString(); row["Number"] = (object)(dataTable.Rows[index]["Number"].ToString() + "(" + CheckSSC_DN.CheckNNum(dataTable.Rows[index]["Number"].ToString()) + ")"); row["Number1"] = (object)(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 1) + "(" + CheckSSC_DN.CheckNNum(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 1)) + ")"); row["Number2"] = (object)(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 2) + "(" + CheckSSC_DN.CheckNNum(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 2)) + ")"); row["Number3"] = (object)(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 3) + "(" + CheckSSC_DN.CheckNNum(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 3)) + ")"); row["Number4"] = (object)(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 4) + "(" + CheckSSC_DN.CheckNNum(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 4)) + ")"); row["Number5"] = (object)(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 5) + "(" + CheckSSC_DN.CheckNNum(CheckSSC_DN.AddDnNum(dataTable.Rows[index]["Number"].ToString(), 5)) + ")"); table.Rows.Add(row); } _jsonstr = this.ConverTableToJSON(table); table.Clear(); table.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 int Save(string orderno, string userId, string bankId, string checkCode, decimal money) { int result; using (DbOperHandler dbOperHandler = new ComData().Doh()) { int num = 0; if (bankId == "888") { num = 1; } DateTime dateTime = new DateTimePubDAL().GetDateTime(); dbOperHandler.Reset(); dbOperHandler.AddFieldItem("SsId", orderno); dbOperHandler.AddFieldItem("UserId", userId); dbOperHandler.AddFieldItem("BankId", bankId); dbOperHandler.AddFieldItem("CheckCode", checkCode); dbOperHandler.AddFieldItem("InMoney", money); dbOperHandler.AddFieldItem("DzMoney", money); dbOperHandler.AddFieldItem("STime", dateTime.ToString("yyyy-MM-dd HH:mm:ss")); dbOperHandler.AddFieldItem("State", num); result = dbOperHandler.Insert("N_UserCharge"); } return(result); }
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 Create(int loid) { string text = ConfigurationManager.AppSettings["DataUrl"].ToString(); using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT top 1 [Title],[Number] FROM [Sys_LotteryData] where Type=" + loid + " order by Title desc"; DataTable dataTable = dbOperHandler.GetDataTable(); string text2 = "{\"title\": \"期号\",\"number\": \"号码\"}"; if (dataTable.Rows.Count > 0) { text2 = text2.Replace("期号", dataTable.Rows[0]["Title"].ToString()).Replace("号码", dataTable.Rows[0]["Number"].ToString()); } else { text2 = text2.Replace("期号", "").Replace("号码", ""); } dataTable.Clear(); dataTable.Dispose(); string text3 = string.Concat(new object[] { text, "EMindexData", loid, ".json" }); DirFile.CreateFolder(DirFile.GetFolderPath(false, text3)); StreamWriter streamWriter = new StreamWriter(text3, false, Encoding.UTF8); streamWriter.Write(text2); streamWriter.Close(); } }
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 GetListJSONFlex(int _thispage, int _pagesize, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = " IsUsed=1"; int num = dbOperHandler.Count("Sys_News"); string sql = SqlHelp.GetSql0(num + " 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"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = base.ConverTableToJSON2(dataTable); dataTable.Clear(); dataTable.Dispose(); } }
public string GetHisNumber(string ltype) { string str1 = ""; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT TOP 1000 [Number]\r\n FROM [Sys_LotteryData] where '" + ltype + "'=substring(Convert(varchar(10),type),1,1) order by STime asc"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 1) { Random random = new Random(); string str2 = dataTable.Rows[random.Next(0, dataTable.Rows.Count - 1)]["Number"].ToString(); int num = random.Next(0, 4); string[] strArray = str2.Split(','); for (int index = 0; index < strArray.Length; ++index) { str1 = index != num ? str1 + strArray[index] + "," : str1 + (object)random.Next(0, 9) + ","; } str1 = str1.Substring(0, str1.Length - 1); } else { str1 = NumberCode.CreateCode(5); } } return(str1); }
public string GetUserNav(string pid, string uid) { string str = "<span><a href='javascript:void(0);' onclick='ajaxSearchPid(" + uid + ")'>本级</a></span><span>></span>"; if (pid != "0") { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT UserCode FROM [N_User] WHERE [Id]=" + pid; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count > 0) { string[] strArray = dataTable.Rows[0]["UserCode"].ToString().Replace(",,", ",").Substring(1, dataTable.Rows[0]["UserCode"].ToString().Replace(",,", ",").Length - 2).Split(','); for (int index = 0; index < strArray.Length; ++index) { if (Convert.ToInt32(strArray[index]) > Convert.ToInt32(uid)) { str = str + "<span><a href='javascript:void(0);' onclick='ajaxSearchPid(" + strArray[index] + ")'>" + this.GetUserName(strArray[index]) + "</a></span><span>></span>"; } } } } } return(str); }
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 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 sql0 = SqlHelp.GetSql0(pid + " as pid,*", "V_User", order, _pagesize, _thispage, orderby, _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = "{\"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 int BetCancel(string betId) { using (SqlConnection sqlConnection = new SqlConnection(ComData.connectionString)) { sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = sqlConnection; try { object[] objArray = new object[6]; using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Id=@Id"; dbOperHandler.AddConditionParameter("@Id", (object)betId); objArray = dbOperHandler.GetFields("N_UserBet", "UserId,IssueNum,LotteryId,PlayId,Total,Times,ssid,STime"); } Decimal Money = Convert.ToDecimal(Convert.ToDecimal(objArray[4]) * Convert.ToDecimal(objArray[5])); if (new UserTotalTran().MoneyOpers(objArray[6].ToString(), objArray[0].ToString(), Money, Convert.ToInt32(objArray[2].ToString()), Convert.ToInt32(objArray[3].ToString()), Convert.ToInt32(betId), 6, 99, string.Empty, string.Empty, "会员撤单", objArray[7].ToString()) <= 0) { return(0); } sqlCommand.CommandText = "update N_UserBet set State=1 where Id=" + betId; sqlCommand.ExecuteNonQuery(); return(1); } catch (Exception ex) { new LogExceptionDAL().Save("系统异常", ex.Message); return(0); } } }
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("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 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 string GetCurrentSn(int loid) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { DateTime now = DateTime.Now; string str; if (loid == 3002 || loid == 3003) { DateTime dateTime = Convert.ToDateTime(now.Year.ToString() + "-01-01 20:30:00"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "','" + now.ToString("yyyy-MM-dd HH:mm:ss") + "') as d"; int Num = Convert.ToInt32(dbOperHandler.GetDataTable().Rows[0]["d"]) - 7; str = now.Year.ToString() + Func.AddZero(Num, 3); } else { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 Sn from Sys_LotteryTime where LotteryId=" + (object)loid + " and Time < '" + now.ToString("HH:mm:ss") + "' order by time desc"; DataTable dataTable = dbOperHandler.GetDataTable(); if (dataTable.Rows.Count < 1) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 Sn from Sys_LotteryTime where LotteryId=" + (object)loid + " order by time desc"; dataTable = dbOperHandler.GetDataTable(); str = now.AddDays(-1.0).ToString("yyyyMMdd") + "-" + dataTable.Rows[0]["Sn"].ToString(); } else { str = now.ToString("yyyyMMdd") + "-" + dataTable.Rows[0]["Sn"].ToString(); if (now > Convert.ToDateTime(now.ToString("yyyy-MM-dd") + " 00:00:00") && now < Convert.ToDateTime(now.ToString("yyyy-MM-dd") + " 10:00:01") && loid == 1003) { str = now.AddDays(-1.0).ToString("yyyyMMdd") + "-" + dataTable.Rows[0]["Sn"].ToString(); } } if (loid == 4001) { DateTime dateTime = Convert.ToDateTime("2016-01-01 00:00:00"); dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "','" + now.ToString("yyyy-MM-dd HH:mm:ss") + "') as d"; str = string.Concat((object)(530900 + (Convert.ToInt32(dbOperHandler.GetDataTable().Rows[0]["d"]) - 7) * 179 + Convert.ToInt32(dataTable.Rows[0]["Sn"].ToString()))); } dataTable.Clear(); dataTable.Dispose(); } return(str); } }
public int GetTsIssueNum(string lotteryId) { DateTime now = DateTime.Now; int num = 0; using (DbOperHandler dbOperHandler = new ComData().Doh()) { switch (lotteryId) { case "1010": case "3004": dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'2016-10-08',Convert(varchar(10),getdate(),120)) as d"; num = 1658122 + Convert.ToInt32(dbOperHandler.GetDataTable().Rows[0]["d"]) * 880; break; case "1017": dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'2016-10-08',Convert(varchar(10),getdate(),120)) as d"; num = 1658117 + Convert.ToInt32(dbOperHandler.GetDataTable().Rows[0]["d"]) * 880; break; case "1012": dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'2016-10-23',Convert(varchar(10),getdate(),120)) as d"; DataTable dataTable1 = dbOperHandler.GetDataTable(); num = !(now > Convert.ToDateTime(now.ToString("yyyy-MM-dd") + " 00:00:00")) || !(now < Convert.ToDateTime(now.ToString("yyyy-MM-dd") + " 00:01:45")) ? 2588087 + Convert.ToInt32(dataTable1.Rows[0]["d"]) * 660 : 2588087 + (Convert.ToInt32(dataTable1.Rows[0]["d"]) - 1) * 660; break; case "1013": dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'2017-01-01',Convert(varchar(10),getdate(),120)) as d"; DataTable dataTable2 = dbOperHandler.GetDataTable(); num = !(now > Convert.ToDateTime(now.ToString("yyyy-MM-dd") + " 00:00:00")) || !(now < Convert.ToDateTime(now.ToString("yyyy-MM-dd") + " 06:50:00")) ? 106000000 + Convert.ToInt32(dataTable2.Rows[0]["d"]) * 203 : 106000000 + (Convert.ToInt32(dataTable2.Rows[0]["d"]) - 1) * 203; break; case "4001": dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select datediff(d,'2017-02-10',Convert(varchar(10),getdate(),120)) as d"; DataTable dataTable3 = dbOperHandler.GetDataTable(); num = !(DateTime.Now > Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00")) || !(DateTime.Now < Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 09:07:01")) ? 601048 + Convert.ToInt32(dataTable3.Rows[0]["d"]) * 179 : 601048 + (Convert.ToInt32(dataTable3.Rows[0]["d"]) - 1) * 179; break; } } return(num); }
public DataTable GetAutoUrl(int lotteryId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select top 1 IsAuto,isnull((select Url from Sys_lotteryUrl where Id=a.AutoUrl),'0') as AutoUrl \r\n ,isnull((select Title from Sys_lotteryUrl where Id=a.AutoUrl),'0') as Title\r\n from Sys_lottery a where Id=" + (object)lotteryId; return(dbOperHandler.GetDataTable()); } }
public static Decimal GetCurRealGet(int lotteryId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT case isnull(sum(Total*Times),0) when 0 then 0 else isnull(-sum(realGet),-0)*100/isnull(sum(Total*Times),0) end as win FROM [N_UserBet] where state>=2 and DateDiff(dd,STime,getdate())=0 and lotteryId=" + (object)lotteryId; return(Convert.ToDecimal(dbOperHandler.GetDataTable().Rows[0]["win"])); } }
public DataTable GetTable() { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "select [Id],[LotteryId],[Sn],[Time],[Sort] from Sys_LotteryTime order by Id desc"; return(dbOperHandler.GetDataTable()); } }
public DataTable GetLotteryAutoMode() { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT top 1 [AutoLottery],[ProfitModel],[ProfitMargin] FROM [Sys_Info]"; return(dbOperHandler.GetDataTable()); } }
public void DeleteUserBetZh(string d1, string d2) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Stime<='" + d2 + "' and Stime>='" + d1 + "'"; dbOperHandler.Delete("N_UserBetZh"); } }
public void DeleteUserLogs(string d1, string d2) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "LoginTime<='" + d2 + "' and LoginTime>='" + d1 + "'"; dbOperHandler.Delete("Log_UserLogin"); } }
public void DeleteLotteryData(string d1, string d2) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "Stime<='" + d2 + "' and Stime>='" + d1 + "'"; dbOperHandler.Delete("Sys_LotteryData"); } }
public void Delete() { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "1=1"; dbOperHandler.Delete("N_UserMessage"); } }
public static DataTable GetLotteryCheck(int lotteryId) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.SqlCmd = "SELECT top 1 [CheckNum],[CheckPer] FROM [Sys_LotteryCheck] where Id=" + (object)lotteryId; return(dbOperHandler.GetDataTable()); } }