/// <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); }