public void AddAutoDrop(int gameplayway, double dropValue, decimal amount, CompanyType companyType)
{
//if (num.IsBatterNum() || num.IsRangeNum() || num.IsNumArray())
//{
// AddAutoDrop(GetRangeNum(num), gameplayway, dropValue, amount, companyType);
// return;
//}
var gpw = LotterySystem.Current.FindGamePlayWay(gameplayway);
//var drop = DaDropWater.GetDropWater(num, gameplayway, amount, DropType.Auto, (int)companyType);
var drop = DaDropWater.GetDropWater(gameplayway, amount, DropType.Auto, companyType);
if (drop != null)
throw new BusinessException(Resource.AlreadyExist);
drop = new DropWater
{
Num = GetNumArrange(gpw.GameType),
GamePlayWayId = gameplayway,
DropValue = dropValue,
Amount = amount,
DropType = DropType.Auto,
CompanyType = (int)companyType
};
DaDropWater.Insert(drop);
}
public void Insert(DropWater dropWater, int companyId)
{
string sql = string.Format(@"INSERT INTO {0} ({1},{2}) VALUES (@{1},@{2})", DropInCompany.TABLENAME, DropInCompany.DROPID, DropInCompany.COMPANYID);
base.ExecuteNonQuery(sql, new SqlParameter(DropInCompany.DROPID, dropWater.DropId),
new SqlParameter(DropInCompany.COMPANYID, companyId));
}
public void AddTodayDrop(string num, int gameplaywayId, double dropValue, decimal amount, params int[] companys)
{
if (num.IsRangeNum() || num.IsBatterNum() || num.IsNumArray() || num.IsStartBatterNum())
{
foreach (var n in Extended.GetRangeNum(num))
AddTodayDrop(n, gameplaywayId, dropValue, amount, companys);
return;
}
var dws = DaDropWater.ListDropWater(num, DateTime.Today);
var dw = dws.Find(it => it.Num == num && it.GamePlayWayId == gameplaywayId && it.Amount == amount && it.DropValue == dropValue && it.DropType == DropType.Manual);
foreach (var company in companys)
{
if (dw != null)
{
if (DaDropWater.CountDropWater(dw.DropId, company) > 0) //公司已添加该跌水的
throw new BusinessException(Resource.AlreadyExist);
DaDropWater.Insert(dw, company);
}
else
{
//同种玩法，同个跌水金额，不同跌水率
dw = dws.Find(it => it.Num == num && it.GamePlayWayId == gameplaywayId && it.Amount == amount && it.CompanyId == company);
if (dw != null)
{
throw new BusinessException(Resource.AlreadyExist);
}
dw = new DropWater
{
Num = num,
DropType = DropType.Manual,
DropValue = dropValue,
Amount = amount,
GamePlayWayId = gameplaywayId
};
DaDropWater.ExecuteWithTransaction(() =>
{
DaDropWater.Insert(dw);
DaDropWater.Insert(dw, company);
});
}
}
UpperLimitManager.GetManager().RefreshLimitNextLimit(num, gameplaywayId);
}
public void Insert(DropWater dropWater, DateTime date)
{
string sql = string.Format(@"INSERT INTO {0} ({1},{2},{3},{4},{5},{6},{7}) VALUES (@{1},@{2},@{3},@{4},@{5},@{6},@{7}) SELECT SCOPE_IDENTITY()",
DropWater.TABLENAME, DropWater.NUM, DropWater.GAMEPLAYWAYID, DropWater.DROPVALUE, DropWater.AMOUNT, DropWater.DROPTYPE, DropWater.COMPANYTYPE, DropWater.CREATETIME);
object id = base.ExecuteScalar(sql, new SqlParameter(DropWater.NUM, dropWater.Num),
new SqlParameter(DropWater.GAMEPLAYWAYID, dropWater.GamePlayWayId),
new SqlParameter(DropWater.DROPVALUE, dropWater.DropValue),
new SqlParameter(DropWater.AMOUNT, dropWater.Amount),
new SqlParameter(DropWater.DROPTYPE, (int)dropWater.DropType),
new SqlParameter(DropWater.COMPANYTYPE, dropWater.CompanyType ?? 0),
new SqlParameter(DropWater.CREATETIME, date));
dropWater.DropId = Convert.ToInt32(id);
}
