public bool CreatLuckNum(string Pid, int UserId, string ActivityId, int BuyNum)
{
List <LuckInfo> infoList = new List <LuckInfo>();
bool flag = false;
lock (LuckNumObj)
{
int maxLuckNum = this.GetMaxLuckNum(ActivityId);
for (int i = 1; i <= BuyNum; i++)
{
LuckInfo info2 = new LuckInfo
{
UserId = UserId,
ActivityId = ActivityId,
Pid = Pid
};
info2.PrizeNum = (maxLuckNum + i).ToString();
LuckInfo item = info2;
infoList.Add(item);
}
if ((infoList.Count > 0) && this.AddLuckInfo(infoList))
{
flag = true;
}
}
return(flag);
}
public bool AddLuckInfo(LuckInfo info)
{
StringBuilder builder = new StringBuilder("INSERT INTO Vshop_OneyuanTao_WinningRecord(UserId,ActivityId,Pid,PrizeNum,IsWin)VALUES");
builder.Append("(@UserId,@ActivityId,@Pid,@PrizeNum,@IsWin)");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.AddInParameter(sqlStringCommand, "ActivityId", DbType.String, info.ActivityId);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Boolean, info.UserId);
this.database.AddInParameter(sqlStringCommand, "Pid", DbType.String, info.Pid);
this.database.AddInParameter(sqlStringCommand, "PrizeNum", DbType.String, info.PrizeNum);
this.database.AddInParameter(sqlStringCommand, "IsWin", DbType.Boolean, false);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public static bool AddLuckInfo(LuckInfo info)
{
return(new OneyuanTaoDao().AddLuckInfo(info));
}
