/// <summary> /// 获取对应的数据 /// </summary> /// <param name="numberId"></param> /// <returns></returns> public Model.PrizeTicket GetModel(string numberId) { Model.PrizeTicket model = null; string cmdText = @"select top 1 NumberID,CategoryID,TicketName,PointNum,ImageUrl,LastUpdatedDate,TicketDescr,FlowDescr,PNum,StockNum from [PrizeTicket] 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.PrizeTicket(); model.NumberID = reader["NumberID"].ToString(); model.CategoryID = reader["CategoryID"].ToString(); model.TicketName = reader["TicketName"].ToString(); model.PointNum = decimal.Parse(reader["PointNum"].ToString()); model.ImageUrl = reader["ImageUrl"].ToString(); model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString()); model.TicketDescr = reader["TicketDescr"].ToString(); model.FlowDescr = reader["FlowDescr"].ToString(); model.PNum = reader["PNum"].ToString(); model.StockNum = Int32.Parse(reader["StockNum"].ToString()); } } } return(model); }
/// <summary> /// 绑定奖品列表 /// </summary> private void BindTicket() { if (!string.IsNullOrEmpty(nId)) { BLL.PrizeTicket ptBll = new BLL.PrizeTicket(); Model.PrizeTicket model = ptBll.GetModel(nId); List <Model.PrizeTicket> list = new List <Model.PrizeTicket>(); list.Add(model); rpData.DataSource = list; rpData.DataBind(); } }
/// <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.PrizeTicket> GetList(int pageIndex, int pageSize, out int totalCount, string sqlWhere, params SqlParameter[] commandParameters) { //获取数据集总数 string cmdText = "select count(*) from [PrizeTicket] 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.CategoryID,t1.TicketName,t1.PointNum,t1.ImageUrl,t1.LastUpdatedDate,t1.TicketDescr,t1.FlowDescr,t1.PNum,t1.StockNum from [PrizeTicket] t1 "; if (!string.IsNullOrEmpty(sqlWhere)) { cmdText += "where 1=1 " + sqlWhere; } cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " "; List <Model.PrizeTicket> list = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, commandParameters)) { if (reader != null && reader.HasRows) { list = new List <Model.PrizeTicket>(); while (reader.Read()) { Model.PrizeTicket model = new Model.PrizeTicket(); model.NumberID = reader["NumberID"].ToString(); model.CategoryID = reader["CategoryID"].ToString(); model.TicketName = reader["TicketName"].ToString(); model.PointNum = decimal.Parse(reader["PointNum"].ToString()); model.ImageUrl = reader["ImageUrl"].ToString(); model.LastUpdatedDate = DateTime.Parse(reader["LastUpdatedDate"].ToString()); model.TicketDescr = reader["TicketDescr"].ToString(); model.FlowDescr = reader["FlowDescr"].ToString(); model.PNum = reader["PNum"].ToString(); model.StockNum = Int32.Parse(reader["StockNum"].ToString()); list.Add(model); } } } return(list); }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.PrizeTicket model) { if (model == null) { return(-1); } if (IsExist(model.TicketName, model.CategoryID, model.NumberID)) { return(110); } //定义查询命令 string cmdText = @"update [PrizeTicket] set CategoryID = @CategoryID,TicketName = @TicketName,PointNum = @PointNum,ImageUrl = @ImageUrl,TicketDescr = @TicketDescr,FlowDescr = @FlowDescr,PNum = @PNum,StockNum = @StockNum, LastUpdatedDate = @LastUpdatedDate where NumberID = @NumberID"; //创建查询命令参数集 SqlParameter[] parms = { new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier), new SqlParameter("@CategoryID", SqlDbType.UniqueIdentifier), new SqlParameter("@TicketName", SqlDbType.NVarChar, 50), new SqlParameter("@PointNum", SqlDbType.Decimal), new SqlParameter("@ImageUrl", SqlDbType.NVarChar, 300), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime), new SqlParameter("@TicketDescr", SqlDbType.NVarChar, 1000), new SqlParameter("@FlowDescr", SqlDbType.NVarChar, 1000), new SqlParameter("@PNum", SqlDbType.VarChar, 30), new SqlParameter("@StockNum", SqlDbType.Int) }; parms[0].Value = Guid.Parse(model.NumberID.ToString()); parms[1].Value = Guid.Parse(model.CategoryID.ToString()); parms[2].Value = model.TicketName; parms[3].Value = model.PointNum; parms[4].Value = model.ImageUrl; parms[5].Value = model.LastUpdatedDate; parms[6].Value = model.TicketDescr; parms[7].Value = model.FlowDescr; parms[8].Value = model.PNum; parms[9].Value = model.StockNum; return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(Model.PrizeTicket model) { if (model == null) { return(-1); } //判断当前记录是否存在,如果存在则返回; if (IsExist(model.TicketName, model.CategoryID, "")) { return(110); } string cmdText = "insert into [PrizeTicket] (CategoryID,TicketName,PointNum,ImageUrl,LastUpdatedDate,TicketDescr,FlowDescr,PNum) values (@CategoryID,@TicketName,@PointNum,@ImageUrl,@LastUpdatedDate,@TicketDescr,@FlowDescr,@PNum)"; //创建查询命令参数集 SqlParameter[] parms = { new SqlParameter("@CategoryID", SqlDbType.UniqueIdentifier), new SqlParameter("@TicketName", SqlDbType.NVarChar, 50), new SqlParameter("@PointNum", SqlDbType.Decimal), new SqlParameter("@ImageUrl", SqlDbType.NVarChar, 300), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime), new SqlParameter("@TicketDescr", SqlDbType.NVarChar, 1000), new SqlParameter("@FlowDescr", SqlDbType.NVarChar, 1000), new SqlParameter("@PNum", SqlDbType.VarChar, 30) }; parms[0].Value = Guid.Parse(model.CategoryID.ToString()); parms[1].Value = model.TicketName; parms[2].Value = model.PointNum; parms[3].Value = model.ImageUrl; parms[4].Value = model.LastUpdatedDate; parms[5].Value = model.TicketDescr; parms[6].Value = model.FlowDescr; parms[7].Value = model.PNum; //执行数据库操作 return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms)); }
private void Bind() { if (!string.IsNullOrEmpty(nId)) { if (bll == null) { bll = new BLL.PrizeTicket(); } Model.PrizeTicket model = bll.GetModel(nId); if (model != null) { txtCategory.Value = model.CategoryID.ToString(); txtName.Value = model.TicketName; txtPieceNum.Value = model.PointNum.ToString(); txtImageUrl.Value = model.ImageUrl; txtPNum.Value = model.PNum; txtStock.Value = model.StockNum.ToString(); txtDescr.Value = model.TicketDescr; txtFlow.Value = model.FlowDescr; } } }
private void OnSave(object nId) { BLL.PrizeTicket ptBll = new BLL.PrizeTicket(); Model.PrizeTicket ptModel = ptBll.GetModel(nId.ToString()); if (ptModel == null) { WebHelper.MessageBox.Messager(this.Page, rpData.Controls[0], "没有找到相关奖品"); return; } decimal pointNum = ptModel.PointNum; BLL.UserPoint uBll = new BLL.UserPoint(); object userId = WebHelper.Common.GetUserId(); DateTime currTime = DateTime.Now; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { Model.UserPoint uModel = uBll.GetModelByUser(userId); if (uModel == null) { WebHelper.MessageBox.Messager(this.Page, rpData.Controls[0], "您的棋子数额不足,无法兑换"); return; } decimal userPointNum = uModel.PointNum; decimal currPointNum = userPointNum - pointNum; if (currPointNum < 0) { WebHelper.MessageBox.Messager(this.Page, rpData.Controls[0], "您的棋子数额不足,无法兑换"); return; } Model.UserTicket utModel = new Model.UserTicket(); utModel.PrizeTicketID = ptModel.NumberID; utModel.UserID = userId; utModel.Status = 0; utModel.LastUpdatedDate = currTime; BLL.UserTicket utBll = new BLL.UserTicket(); if (utBll.Insert(utModel) > 0) { uModel.PointNum = currPointNum; uModel.LastUpdatedDate = currTime; if (uBll.Update(uModel) > 0) { //操作成功,提交事务 scope.Complete(); Response.Redirect("/u/ta.html"); } else { WebHelper.MessageBox.Messager(this.Page, rpData.Controls[0], "奖品兑换失败,无法兑换", "系统异常"); return; } } else { WebHelper.MessageBox.Messager(this.Page, rpData.Controls[0], "奖品兑换失败,无法兑换", "系统异常"); return; } } }
private void OnSave() { Guid categoryId = Guid.Empty; string sCategory = txtCategory.Value.Trim(); if (!string.IsNullOrEmpty(sCategory)) { if (!Guid.TryParse(sCategory, out categoryId)) { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "所属分类ID格式不正确,请检查", "错误提醒", "error"); return; } } string sName = txtName.Value.Trim(); if (string.IsNullOrEmpty(sName)) { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "名称不能为空,请检查", "错误提醒", "error"); return; } string sPieceNum = txtPieceNum.Value.Trim(); if (string.IsNullOrEmpty(sPieceNum)) { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "棋子数不能为空,请检查", "错误提醒", "error"); return; } decimal pointNum = 0; if (!decimal.TryParse(sPieceNum, out pointNum)) { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "棋子数输入格式不正确,请检查", "错误提醒", "error"); return; } string sImageUrl = txtImageUrl.Value.Trim(); if (string.IsNullOrEmpty(sImageUrl)) { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "图片不能为空,请检查", "错误提醒", "error"); return; } string sPNum = txtPNum.Value.Trim(); string sStockNum = txtStock.Value.Trim(); int stockNum = 0; if (!string.IsNullOrEmpty(sStockNum)) { Int32.TryParse(sStockNum, out stockNum); } if (bll == null) { bll = new BLL.PrizeTicket(); } Model.PrizeTicket model = new Model.PrizeTicket(); model.CategoryID = categoryId; model.TicketName = sName; model.PointNum = pointNum; model.ImageUrl = sImageUrl; model.LastUpdatedDate = DateTime.Now; model.PNum = sPNum; model.StockNum = stockNum; model.TicketDescr = txtDescr.Value.Trim(); model.FlowDescr = txtFlow.Value.Trim(); int effectCount = -1; if (!string.IsNullOrEmpty(nId)) { model.NumberID = nId; effectCount = bll.Update(model); } else { effectCount = bll.Insert(model); } if (effectCount == 110) { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "已存在相同记录", "温馨提醒", "error"); return; } if (effectCount > 0) { WebHelper.MessageBox.MessagerShow(this.Page, lbtnPostBack, "操作成功"); } else { WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "操作失败"); } }
/// <summary> /// 修改数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.PrizeTicket model) { return(dal.Update(model)); }
/// <summary> /// 添加数据到数据库 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Insert(Model.PrizeTicket model) { return(dal.Insert(model)); }