public bool UpdateActivityPrize(ActivityPrize activityPrize) { using (var connection = ProcessConnection.OpenGungnir) { return(dal.UpdateActivityPrize(connection, activityPrize)); } }
private void Bind() { //查询条件 GetSearchItem(); int totalRecords = 0; ActivityPrize bll = new ActivityPrize(); rpData.DataSource = bll.GetListOW(pageIndex, pageSize, out totalRecords, sqlWhere, parms == null ? null : parms.ToArray()); rpData.DataBind(); myDataAppend.Append("<div id=\"myDataForPage\" style=\"display:none;\">[{\"PageIndex\":\"" + pageIndex + "\",\"PageSize\":\"" + pageSize + "\",\"TotalRecord\":\"" + totalRecords + "\",\"QueryStr\":\"" + queryStr + "\"}]</div>"); }
public bool UpdateActivityPrize(SqlConnection conn, ActivityPrize activityPrize) { string strSql = "update Activity..tbl_ActivityPrize set Stock=Stock+@UpdateStock,SumStock=SumStock+@UpdateStock where PKID=@PKID"; List <SqlParameter> sqlparams = new List <SqlParameter>(); sqlparams.Add(new SqlParameter("@UpdateStock", activityPrize.UpdateStock)); sqlparams.Add(new SqlParameter("@PKID", activityPrize.PKID)); int rowaffected = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql, sqlparams.ToArray()); if (rowaffected >= 0) { return(true); } else { return(false); } }
private void Bind() { if (!Id.Equals(Guid.Empty)) { Page.Title = "编辑奖项"; ActivityPrize bll = new ActivityPrize(); DataSet ds = bll.GetModelOW(Id); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; txtPrizeName.Value = dt.Rows[0]["PrizeName"].ToString(); txtPrizeCount.Value = dt.Rows[0]["PrizeCount"].ToString(); imgSinglePicture.Src = dt.Rows[0]["PictureId"] is DBNull ? "../../Images/nopic.gif" : string.Format("{0}{1}/PC/{1}_1{2}", dt.Rows[0]["FileDirectory"], dt.Rows[0]["RandomFolder"], dt.Rows[0]["FileExtension"]); hImgSinglePictureId.Value = dt.Rows[0]["PictureId"].ToString(); txtSort.Value = dt.Rows[0]["Sort"].ToString(); txtPrizeContent.Value = dt.Rows[0]["PrizeContent"].ToString(); txtWinningTimes.Value = dt.Rows[0]["WinningTimes"].ToString(); txtBusinessName.Value = dt.Rows[0]["BusinessName"].ToString(); txtBusinessPhone.Value = dt.Rows[0]["BusinessPhone"].ToString(); txtBusinessAddress.Value = dt.Rows[0]["BusinessAddress"].ToString(); hId.Value = Id.ToString(); asId.Value = dt.Rows[0]["ActivityId"].ToString(); spanZS.InnerText = "(设置后第二天生效)"; if (Convert.ToBoolean(dt.Rows[0]["IsDisable"])) { rdFalse.Checked = false; rdTrue.Checked = true; } else { rdFalse.Checked = true; rdTrue.Checked = false; } } } else { asId.Value = Request["asId"]; } }
public async Task <JsonResult> InsertActivityPrize(ActivityPrize activityPrize) { GuessGameManager manager = new GuessGameManager(); bool savesuccess = manager.SaveActivityPrize(activityPrize); if (savesuccess) { using (var client = new ConfigLogClient()) { var response = client.InsertDefaultLogQueue("CommonConfigLog", JsonConvert.SerializeObject(new { ObjectId = activityPrize.PKID, ObjectType = "WorldCupConfigPrize", BeforeValue = "", AfterValue = "", Remark = "新增兑换物", Creator = User.Identity.Name, })); } } return(Json(savesuccess ? "" : "操作失败", JsonRequestBehavior.AllowGet)); }
public bool InsertActivityPrize(SqlConnection conn, ActivityPrize activityPrize) { // activityPrize.SumStock = activityPrize.Stock=activityPrize.UpdateStock; activityPrize.Stock = activityPrize.SumStock; int isdelete = Convert.ToInt32(activityPrize.IsDeleted); int isDisableSale = Convert.ToInt32(activityPrize.IsDisableSale); long activityid = 0; string activityidsql = @"select top 1 PKID from Activity..tbl_Activity where ActivityType=0"; object activityidobj = SqlHelper.ExecuteScalar(conn, CommandType.Text, activityidsql); if (activityidobj != null) { activityid = Convert.ToInt64(activityidobj); } string insertSql = @"insert into Activity..tbl_ActivityPrize(ActivityId,PID,ActivityPrizeName,PicUrl,CouponCount,Stock,SumStock,OnSale,GetRuleId,IsDeleted,IsDisableSale) values(" + activityid + "," + "N\'" + "\'" + "," + "N\'" + activityPrize.ActivityPrizeName + "\'" + "," + "N\'" + activityPrize.PicUrl + "\'" + "," + activityPrize.CouponCount + "," + activityPrize.Stock + "," + activityPrize.SumStock + "," + activityPrize.OnSale + "," + "N\'" + activityPrize.GetRuleId + "\'" + "," + isdelete + "," + isDisableSale + ");SELECT SCOPE_IDENTITY();"; object prizeobjid = SqlHelper.ExecuteScalar(conn, CommandType.Text, insertSql); if (prizeobjid != null) { activityPrize.PKID = Convert.ToInt64(prizeobjid); } return(true); }