/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.UserBetLottery model)
{
if (model == null)
{
return(-1);
}
string cmdText = "insert into [UserBetLottery] (UserID,RunLotteryID,TotalPointNum,ItemAppend,BetNumAppend,WinPointNum,LastUpdatedDate) values (@UserID,@RunLotteryID,@TotalPointNum,@ItemAppend,@BetNumAppend,@WinPointNum,@LastUpdatedDate)";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@UserID", SqlDbType.UniqueIdentifier),
new SqlParameter("@RunLotteryID", SqlDbType.UniqueIdentifier),
new SqlParameter("@TotalPointNum", SqlDbType.Decimal),
new SqlParameter("@ItemAppend", SqlDbType.NVarChar, 100),
new SqlParameter("@BetNumAppend", SqlDbType.NVarChar, 200),
new SqlParameter("@WinPointNum", SqlDbType.Decimal),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = Guid.Parse(model.UserID.ToString());
parms[1].Value = Guid.Parse(model.RunLotteryID.ToString());
parms[2].Value = model.TotalPointNum;
parms[3].Value = model.ItemAppend;
parms[4].Value = model.BetNumAppend;
parms[5].Value = model.WinPointNum;
parms[6].Value = model.LastUpdatedDate;
//执行数据库操作
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.UserBetLottery model)
{
if (model == null)
{
return(-1);
}
//定义查询命令
string cmdText = @"update [UserBetLottery] set UserID = @UserID,RunLotteryID = @RunLotteryID,TotalPointNum = @TotalPointNum,ItemAppend = @ItemAppend,BetNumAppend = @BetNumAppend,WinPointNum = @WinPointNum,LastUpdatedDate = @LastUpdatedDate where NumberID = @NumberID";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserID", SqlDbType.UniqueIdentifier),
new SqlParameter("@RunLotteryID", SqlDbType.UniqueIdentifier),
new SqlParameter("@TotalPointNum", SqlDbType.Decimal),
new SqlParameter("@ItemAppend", SqlDbType.NVarChar, 100),
new SqlParameter("@BetNumAppend", SqlDbType.NVarChar, 200),
new SqlParameter("@WinPointNum", SqlDbType.Decimal),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = Guid.Parse(model.NumberID.ToString());
parms[1].Value = Guid.Parse(model.UserID.ToString());
parms[2].Value = Guid.Parse(model.RunLotteryID.ToString());
parms[3].Value = model.TotalPointNum;
parms[4].Value = model.ItemAppend;
parms[5].Value = model.BetNumAppend;
parms[6].Value = model.WinPointNum;
parms[7].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="numberId"></param>
/// <returns></returns>
public Model.UserBetLottery GetModel(string numberId)
{
Model.UserBetLottery model = null;
string cmdText = @"select top 1 NumberID,UserID,RunLotteryID,TotalPointNum,ItemAppend,BetNumAppend,WinPointNum,LastUpdatedDate from [UserBetLottery] where NumberID = @NumberID order by LastUpdatedDate desc ";
SqlParameter parm = new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(numberId);
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new Model.UserBetLottery();
model.NumberID = reader["NumberID"].ToString();
model.UserID = reader["UserID"].ToString();
model.RunLotteryID = reader["RunLotteryID"].ToString();
model.TotalPointNum = decimal.Parse(reader["TotalPointNum"].ToString());
model.ItemAppend = reader["ItemAppend"].ToString();
model.BetNumAppend = reader["BetNumAppend"].ToString();
model.WinPointNum = decimal.Parse(reader["WinPointNum"].ToString());
model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString());
}
}
}
return(model);
}
/// <summary>
/// 获取数据分页列表，并返回所有记录数
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <param name="sqlWhere"></param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public List <Model.UserBetLottery> GetList(int pageIndex, int pageSize, out int totalCount, string sqlWhere, params SqlParameter[] commandParameters)
{
//获取数据集总数
string cmdText = "select count(*) from [UserBetLottery] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
totalCount = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters);
//返回分页数据
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = @"select * from(select row_number() over(order by t1.LastUpdatedDate desc) as RowNumber,t1.NumberID,t1.UserID,t1.RunLotteryID,t1.TotalPointNum,t1.ItemAppend,t1.BetNumAppend,t1.WinPointNum,t1.LastUpdatedDate from [UserBetLottery] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
List <Model.UserBetLottery> list = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.UserBetLottery>();
while (reader.Read())
{
Model.UserBetLottery model = new Model.UserBetLottery();
model.NumberID = reader["NumberID"].ToString();
model.UserID = reader["UserID"].ToString();
model.RunLotteryID = reader["RunLotteryID"].ToString();
model.TotalPointNum = decimal.Parse(reader["TotalPointNum"].ToString());
model.ItemAppend = reader["ItemAppend"].ToString();
model.BetNumAppend = reader["BetNumAppend"].ToString();
model.WinPointNum = decimal.Parse(reader["WinPointNum"].ToString());
model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString());
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.UserBetLottery model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.UserBetLottery model)
{
return(dal.Insert(model));
}
private void OnSave()
{
string sItemAppend = hItemAppend.Value.Trim();
if (string.IsNullOrEmpty(sItemAppend))
{
WebHelper.MessageBox.Messager(this.Page, lbtnSave, "投注项不能为空", "错误提示");
return;
}
string[] items = sItemAppend.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (items.Length < 1)
{
return;
}
BLL.RunLottery rlBll = new BLL.RunLottery();
Model.RunLottery rlModel = rlBll.GetModel(nId);
if (rlModel == null)
{
WebHelper.MessageBox.Messager(this.Page, lbtnSave, "不存在的开奖期，非法操作", "错误提示");
return;
}
DateTime runDate = rlModel.RunDate;
TimeSpan ts = runDate - DateTime.Now;
if ((ts.TotalMilliseconds - 8000) < 0)
{
WebHelper.MessageBox.Messager(this.Page, lbtnSave, "当前第" + rlModel.Period + "期，已停止投注", "温馨提示");
return;
}
string[] itemArr = items[0].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
int totalBetNum = Int32.Parse(itemArr[1]);
if (totalBetNum <= 0)
{
return;
}
object userId = WebHelper.Common.GetUserId();
//获取当前用户的棋子数
BLL.UserPoint uBll = new BLL.UserPoint();
Model.UserPoint uModel = uBll.GetModelByUser(userId);
if (uModel == null)
{
WebHelper.MessageBox.Messager(this.Page, lbtnSave, "您的棋子数不足，不能进行投注！", "系统提示");
return;
}
if ((uModel.PointNum - totalBetNum) < 0)
{
WebHelper.MessageBox.Messager(this.Page, lbtnSave, "您的棋子数不足，不能进行投注！", "系统提示");
return;
}
string itemAppend = string.Empty;
string betNumAppend = string.Empty;
int index = 0;
foreach (string s in items)
{
index++;
if (index > 1)
{
string[] nvArr = s.Split('|');
itemAppend += nvArr[0] + ",";
betNumAppend += nvArr[1] + ",";
}
}
BLL.Order ublBll = new BLL.Order();
Model.UserBetLottery ublModel = new Model.UserBetLottery();
ublModel.LastUpdatedDate = DateTime.Now;
ublModel.UserID = userId;
ublModel.RunLotteryID = rlModel.NumberID;
ublModel.TotalPointNum = totalBetNum;
ublModel.ItemAppend = itemAppend.Trim(',');
ublModel.BetNumAppend = betNumAppend.Trim(',');
ublModel.WinPointNum = 0;
int effectCount = -1;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
uModel.PointNum = uModel.PointNum - totalBetNum;
if (uBll.Update(uModel) > 0)
{
ublBll.Insert(ublModel);
effectCount = 1;
}
scope.Complete();
}
if (effectCount > 0)
{
WebHelper.MessageBox.Show(this.Page, lbtnSave, "当前第" + rlModel.Period + "期，投注成功！", Request.Url.ToString());
}
else
{
WebHelper.MessageBox.Messager(this.Page, lbtnSave, "当前第" + rlModel.Period + "期，投注失败，请检查", "系统提示");
}
}
public void Insert(Model.UserBetLottery model)
{
dal.Insert(model);
}
public void Insert(Model.UserBetLottery model)
{
asynchOrder.Send(model);
}
public void Insert(Model.UserBetLottery model)
{
orderInsertStrategy.Insert(model);
}
/// <summary>
/// Method to send asynchronous order to Pet Shop Message Queue
/// </summary>
/// <param name="orderMessage">All information for an order</param>
public void Send(Model.UserBetLottery model)
{
// This method does not involve in distributed transaction and optimizes performance using Single type
base.transactionType = MessageQueueTransactionType.Single;
base.Send(model);
}
