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