private void CheckLotteryNumberCountForCustomChase()//检查追号套餐中随机选号的号码是否少
{
DataTable dt = Shove.Database.MSSQL.Select(ConnectionString, "select ID,LotteryID,Nums,Counts from (select ID,LotteryID,Nums,Cast(Money as int)/(Multiple*Nums*Price) - (select count(ID) as NumberCount from T_ChaseLotteryNumber where ChaseID = a.ID) as Counts from T_Chases a where BetType = 1 and QuashStatus = 0 and Money > 0)a where Counts > 0");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
int LotteryID = 0;
string lotteryNumber;
int IsuseCount = 0;
int Nums = 0;
foreach (DataRow dr in dt.Rows)
{
LotteryID = Shove._Convert.StrToInt(dr["LotteryID"].ToString(), 0);
IsuseCount = Shove._Convert.StrToInt(dr["Counts"].ToString(), 0);
Nums = Shove._Convert.StrToInt(dr["Nums"].ToString(), 0);
for (int i = 0; i < IsuseCount; i++)
{
if (LotteryID == 5)
{
lotteryNumber = new Lottery()[5].BuildNumber(6, 1, Nums);
}
else if (LotteryID == 39)
{
lotteryNumber = new Lottery()[39].BuildNumber(5, 2, Nums);
}
else
{
lotteryNumber = new Lottery()[LotteryID].BuildNumber(Nums);
}
DAL.Tables.T_ChaseLotteryNumber t = new DAL.Tables.T_ChaseLotteryNumber();
t.ChaseID.Value = dr["ID"].ToString();
t.LotteryNumber.Value = lotteryNumber;
t.Insert(ConnectionString);
}
}
}
private void CheckLotteryNumberCountForCustomChase()//检查追号套餐中随机选号的号码是否少
{
DataTable dt = Shove.Database.MSSQL.Select(ConnectionString, "select ID,LotteryID,Nums,Counts from (select ID,LotteryID,Nums,Cast(Money as int)/(Multiple*Nums*Price) - (select count(ID) as NumberCount from T_ChaseLotteryNumber where ChaseID = a.ID) as Counts from T_Chases a where BetType = 1 and QuashStatus = 0 and Money > 0)a where Counts > 0");
if (dt == null || dt.Rows.Count == 0)
{
return;
}
int LotteryID = 0;
string lotteryNumber;
int IsuseCount = 0;
int Nums = 0;
foreach (DataRow dr in dt.Rows)
{
LotteryID = Shove._Convert.StrToInt(dr["LotteryID"].ToString(), 0);
IsuseCount = Shove._Convert.StrToInt(dr["Counts"].ToString(), 0);
Nums = Shove._Convert.StrToInt(dr["Nums"].ToString(), 0);
for (int i = 0; i < IsuseCount; i++)
{
if (LotteryID == 5)
{
lotteryNumber = new Lottery()[5].BuildNumber(6, 1, Nums);
}
else if (LotteryID == 39)
{
lotteryNumber = new Lottery()[39].BuildNumber(5, 2, Nums);
}
else
{
lotteryNumber = new Lottery()[LotteryID].BuildNumber(Nums);
}
DAL.Tables.T_ChaseLotteryNumber t = new DAL.Tables.T_ChaseLotteryNumber();
t.ChaseID.Value = dr["ID"].ToString();
t.LotteryNumber.Value = lotteryNumber;
t.Insert(ConnectionString);
}
}
}