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")) ?
599795 + Convert.ToInt32(dataTable3.Rows[0]["d"]) * 179 :
599795 + (Convert.ToInt32(dataTable3.Rows[0]["d"]) - 1) * 179;
break;
}
}
return(num);
}
public void GetListJSON(string _wherestr1, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr1;
string sql0 = SqlHelp.GetSql0("title,[Content],[STime]", "Sys_News", "STime", 1, 1, "desc", _wherestr1);
dbOperHandler.Reset();
dbOperHandler.SqlCmd = sql0;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + dtHelp.DT2JSON(dataTable) + "}";
dataTable.Clear();
dataTable.Dispose();
}
}
public void AutoActiveOper(string AdminId, string ActiveCode, string ActiveName, string ProcName)
{
if (new ActiveAutoDAL().Exists(ActiveCode))
{
return;
}
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ExecuteProcActive(ProcName);
}
this.Add(ActiveCode);
new LogSysDAL().Save("系统自动", "活动补发" + ActiveName);
new LogAdminOperDAL().SaveLog(AdminId, "0", "活动管理", "手动补发" + ActiveName);
}
public void GetPlayTypeXml(ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT [Id],[TypeId],[Title] FROM [Sys_PlayBigType] where TypeId=2 and IsOpen=1 order by sort ";
DataTable dataTable1 = dbOperHandler.GetDataTable();
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT [Id]\r\n ,[Title0]\r\n ,[Title]\r\n ,[Title2]\r\n ,[Radio]\r\n FROM [Sys_PlaySmallType] \r\n where IsOpen=1 and flag=0 order by Id ";
DataTable dataTable2 = dbOperHandler.GetDataTable();
_jsonstr = this.ConverTableToXML(dataTable1, dataTable2);
dataTable1.Clear();
dataTable1.Dispose();
}
}
public bool UpdateBetNumber(int type, string title)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 1 Type,Title,Number from Sys_LotteryData where Id=" + title;
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
LotteryCheck.AdminRunOper(Convert.ToInt32(dataTable.Rows[0]["Type"].ToString()), dataTable.Rows[0]["Title"].ToString(), dataTable.Rows[0]["Number"].ToString());
return(true);
}
}
return(false);
}
public bool Exists(string _wherestr)
{
int num = 0;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = _wherestr;
if (dbOperHandler.Exist("Pay_temp"))
{
num = 1;
}
}
return(num == 1);
}
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 GetListJSON(string _wherestr1, ref string _jsonstr)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
string text = "select top 1 * from Act_ActiveSet where " + _wherestr1;
text += " order by Id asc";
dbOperHandler.Reset();
dbOperHandler.SqlCmd = text;
DataTable dataTable = dbOperHandler.GetDataTable();
_jsonstr = "{\"result\" :\"1\",\"returnval\" :\"操作成功\"," + 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 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 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 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 void DeleteUserLogs(string d1, string d2)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = string.Concat(new string[]
{
"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 = string.Concat(new string[]
{
"Stime<='",
d2,
"' and Stime>='",
d1,
"'"
});
dbOperHandler.Delete("Sys_LotteryData");
}
}
public void DeleteUserBet(string d1, string d2)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = string.Concat(new string[]
{
"Stime2<='",
d2,
"' and Stime2>='",
d1,
"'"
});
dbOperHandler.Delete("N_UserBet");
}
}
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 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 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(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_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 SiteModel CreateEntity()
{
SiteModel siteModel = new SiteModel();
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT * FROM [Sys_Info] where Id=1";
DataTable dataTable = dbOperHandler.GetDataTable();
DataRow dataRow = dataTable.Rows[0];
siteModel.Name = "时时彩";
siteModel.Dir = App.Path;
siteModel.WebIsOpen = Convert.ToInt32(dataRow["WebIsOpen"].ToString());
siteModel.WebCloseSeason = dataRow["WebCloseSeason"].ToString();
siteModel.ZHIsOpen = Convert.ToInt32(dataRow["ZHIsOpen"].ToString());
siteModel.RegIsOpen = Convert.ToInt32(dataRow["RegIsOpen"].ToString());
siteModel.BetIsOpen = Convert.ToInt32(dataRow["BetIsOpen"].ToString());
siteModel.CSUrl = dataRow["CSUrl"].ToString();
siteModel.SignMinTotal = Convert.ToInt32(dataRow["SignMinTotal"].ToString());
siteModel.SignMaxTotal = Convert.ToInt32(dataRow["SignMaxTotal"].ToString());
siteModel.SignNum = Convert.ToInt32(dataRow["SignNum"].ToString());
siteModel.WarnTotal = Convert.ToDecimal(dataRow["WarnTotal"].ToString());
siteModel.MaxBet = Convert.ToDecimal(dataRow["MaxBet"].ToString());
siteModel.MaxWin = Convert.ToDecimal(dataRow["MaxWin"].ToString());
siteModel.MaxWinFK = Convert.ToDecimal(dataRow["MaxWinFK"].ToString());
siteModel.MaxLevel = Convert.ToDecimal(dataRow["MaxLevel"].ToString());
siteModel.MinCharge = Convert.ToDecimal(dataRow["MinCharge"].ToString());
siteModel.Points = Convert.ToInt32(dataRow["Points"].ToString());
siteModel.PriceOutCheck = Convert.ToDecimal(dataRow["PriceOutCheck"].ToString());
siteModel.PriceOut = Convert.ToDecimal(dataRow["PriceOut"].ToString());
siteModel.PriceOut2 = Convert.ToDecimal(dataRow["PriceOut2"].ToString());
siteModel.PriceNum = Convert.ToInt32(dataRow["PriceNum"].ToString());
siteModel.PriceOutPerson = Convert.ToInt32(dataRow["PriceOutPerson"].ToString());
siteModel.AutoLottery = Convert.ToInt32(dataRow["AutoLottery"].ToString());
siteModel.ProfitModel = Convert.ToInt32(dataRow["ProfitModel"].ToString());
siteModel.ProfitMargin = Convert.ToInt32(dataRow["ProfitMargin"].ToString());
siteModel.AutoRanking = Convert.ToInt32(dataRow["AutoRanking"].ToString());
siteModel.PriceTime1 = dataRow["PriceTime1"].ToString();
siteModel.PriceTime2 = dataRow["PriceTime2"].ToString();
siteModel.BankTime = Convert.ToDecimal(dataRow["BankTime"].ToString());
siteModel.ClientVersion = dataRow["ClientVersion"].ToString();
siteModel.UpdateTime = Convert.ToDateTime(dataRow["UpdateTime"].ToString());
siteModel.NewsUpdateTime = Convert.ToDateTime(dataRow["NewsUpdateTime"].ToString());
siteModel.Version = dataRow["ClientVersion"].ToString();
}
return(siteModel);
}
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 bool Exists(string _type)
{
int num = 0;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "ActiveType=@ActiveType and STime=@STime";
dbOperHandler.AddConditionParameter("@ActiveType", _type);
dbOperHandler.AddConditionParameter("@STime", DateTime.Now.ToString("yyyy-MM-dd"));
if (dbOperHandler.Exist("Act_AutoRecord"))
{
num = 1;
}
}
return(num == 1);
}
public int Save(string SendId, string ReceiveId, string Title, string Contents)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("SendId", SendId);
dbOperHandler.AddFieldItem("ReceiveId", ReceiveId);
dbOperHandler.AddFieldItem("Title", Title);
dbOperHandler.AddFieldItem("Contents", Contents);
dbOperHandler.AddFieldItem("STime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsRead", "0");
result = dbOperHandler.Insert("N_UserEmail");
}
return(result);
}
public int Save(string userId, string PayMethod, string PayBank, string PayBankAddress, string PayAccount, string PayName)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
new DateTimePubDAL().GetDateTime();
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("UserId", (object)userId);
dbOperHandler.AddFieldItem(nameof(PayMethod), (object)PayMethod);
dbOperHandler.AddFieldItem(nameof(PayBank), (object)PayBank);
dbOperHandler.AddFieldItem(nameof(PayBankAddress), (object)PayBankAddress);
dbOperHandler.AddFieldItem(nameof(PayAccount), (object)PayAccount);
dbOperHandler.AddFieldItem(nameof(PayName), (object)PayName);
dbOperHandler.AddFieldItem("AddTime", (object)DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperHandler.AddFieldItem("IsLock", (object)0);
return(dbOperHandler.Insert("N_UserBank"));
}
}
public bool Exists(int _type, string _title)
{
int num = 0;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Title=@Title and Type=@Type";
dbOperHandler.AddConditionParameter("@Title", _title);
dbOperHandler.AddConditionParameter("@Type", _type);
if (dbOperHandler.Exist("Sys_LotteryData"))
{
num = 1;
}
}
return(num == 1);
}
public bool Exists(int _type, string _title, string _number)
{
int num = 0;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Type=@Type and NumberAll=@NumberAll";
dbOperHandler.AddConditionParameter("@Type", (object)_type);
dbOperHandler.AddConditionParameter("@NumberAll", (object)_number);
if (dbOperHandler.Exist("Sys_LotteryData"))
{
num = 1;
}
}
return(num == 1);
}
public bool UpdateAllBetNumber(int type)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "select top 1 Type,Title,Number from Sys_LotteryData where Type=" + (object)type + " order by Title desc";
DataTable dataTable = dbOperHandler.GetDataTable();
if (dataTable.Rows.Count > 0)
{
for (int index = 0; index < dataTable.Rows.Count; ++index)
{
LotteryCheck.AdminRunOper(Convert.ToInt32(dataTable.Rows[index]["Type"].ToString()), dataTable.Rows[index]["Title"].ToString(), dataTable.Rows[index]["Number"].ToString());
}
}
}
return(true);
}
