public static bool UpdateLotteryTicket(LotteryTicketInfo info) { string str = JsonConvert.SerializeObject(info.PrizeSettingList); info.PrizeSetting = str; return new LotteryActivityDao().UpdateLotteryTicket(info); }
public int SaveLotteryTicket(LotteryTicketInfo info) { int num; StringBuilder builder = new StringBuilder(); builder.Append("insert into Vshop_LotteryActivity("); builder.Append("ActivityName,ActivityType,StartTime,OpenTime,EndTime,ActivityDesc,ActivityPic,ActivityKey,PrizeSetting,GradeIds,MinValue,InvitationCode,IsOpened)"); builder.Append(" values ("); builder.Append("@ActivityName,@ActivityType,@StartTime,@OpenTime,@EndTime,@ActivityDesc,@ActivityPic,@ActivityKey,@PrizeSetting,@GradeIds,@MinValue,@InvitationCode,@IsOpened)"); builder.Append(";select @@IDENTITY"); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString()); this.database.AddInParameter(sqlStringCommand, "ActivityName", DbType.String, info.ActivityName); this.database.AddInParameter(sqlStringCommand, "ActivityType", DbType.Int32, info.ActivityType); this.database.AddInParameter(sqlStringCommand, "StartTime", DbType.DateTime, info.StartTime); this.database.AddInParameter(sqlStringCommand, "OpenTime", DbType.DateTime, info.OpenTime); this.database.AddInParameter(sqlStringCommand, "EndTime", DbType.DateTime, info.EndTime); this.database.AddInParameter(sqlStringCommand, "ActivityDesc", DbType.String, info.ActivityDesc); this.database.AddInParameter(sqlStringCommand, "ActivityPic", DbType.String, info.ActivityPic); this.database.AddInParameter(sqlStringCommand, "ActivityKey", DbType.String, info.ActivityKey); this.database.AddInParameter(sqlStringCommand, "PrizeSetting", DbType.String, info.PrizeSetting); this.database.AddInParameter(sqlStringCommand, "GradeIds", DbType.String, info.GradeIds); this.database.AddInParameter(sqlStringCommand, "MinValue", DbType.Int32, info.MinValue); this.database.AddInParameter(sqlStringCommand, "InvitationCode", DbType.String, info.InvitationCode); this.database.AddInParameter(sqlStringCommand, "IsOpened", DbType.Boolean, info.IsOpened); if (!int.TryParse(this.database.ExecuteScalar(sqlStringCommand).ToString(), out num)) { return 0; } return num; }
public bool UpdateLotteryTicket(LotteryTicketInfo info) { StringBuilder builder = new StringBuilder(); builder.Append("update Vshop_LotteryActivity set "); builder.Append("ActivityName=@ActivityName,"); builder.Append("ActivityType=@ActivityType,"); builder.Append("StartTime=@StartTime,"); builder.Append("OpenTime=@OpenTime,"); builder.Append("EndTime=@EndTime,"); builder.Append("ActivityDesc=@ActivityDesc,"); builder.Append("ActivityPic=@ActivityPic,"); builder.Append("ActivityKey=@ActivityKey,"); builder.Append("PrizeSetting=@PrizeSetting,"); builder.Append("GradeIds=@GradeIds,"); builder.Append("MinValue=@MinValue,"); builder.Append("InvitationCode=@InvitationCode,"); builder.Append("IsOpened=@IsOpened"); builder.Append(" where ActivityId=@ActivityId "); builder.Append(";UPDATE vshop_Reply SET Keys = @ActivityKey WHERE ActivityId = @ActivityId AND [ReplyType] = @ReplyType"); string str = ((LotteryActivityType) info.ActivityType).ToString(); object obj2 = Enum.Parse(typeof(ReplyType), str); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString()); this.database.AddInParameter(sqlStringCommand, "ActivityId", DbType.Int32, info.ActivityId); this.database.AddInParameter(sqlStringCommand, "ActivityName", DbType.String, info.ActivityName); this.database.AddInParameter(sqlStringCommand, "ActivityType", DbType.Int32, info.ActivityType); this.database.AddInParameter(sqlStringCommand, "StartTime", DbType.DateTime, info.StartTime); this.database.AddInParameter(sqlStringCommand, "OpenTime", DbType.DateTime, info.OpenTime); this.database.AddInParameter(sqlStringCommand, "EndTime", DbType.DateTime, info.EndTime); this.database.AddInParameter(sqlStringCommand, "ReplyType", DbType.Int32, (int) obj2); this.database.AddInParameter(sqlStringCommand, "ActivityDesc", DbType.String, info.ActivityDesc); this.database.AddInParameter(sqlStringCommand, "ActivityPic", DbType.String, info.ActivityPic); this.database.AddInParameter(sqlStringCommand, "ActivityKey", DbType.String, info.ActivityKey); this.database.AddInParameter(sqlStringCommand, "PrizeSetting", DbType.String, info.PrizeSetting); this.database.AddInParameter(sqlStringCommand, "GradeIds", DbType.String, info.GradeIds); this.database.AddInParameter(sqlStringCommand, "MinValue", DbType.Int32, info.MinValue); this.database.AddInParameter(sqlStringCommand, "InvitationCode", DbType.String, info.InvitationCode); this.database.AddInParameter(sqlStringCommand, "IsOpened", DbType.Boolean, info.IsOpened); return (this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
protected void btnAddActivity_Click(object sender, EventArgs e) { if (ReplyHelper.HasReplyKey(this.txtKeyword.Text.Trim())) { this.ShowMsg("关键字重复!", false); } else if (!this.calendarStartDate.SelectedDate.HasValue) { this.ShowMsg("请选择活动开始时间", false); } else if (!this.calendarOpenDate.SelectedDate.HasValue) { this.ShowMsg("请选择抽奖开始时间", false); } else if (!this.calendarEndDate.SelectedDate.HasValue) { this.ShowMsg("请选择活动结束时间", false); } else { string str = string.Empty; if (this.fileUpload.HasFile) { try { str = VShopHelper.UploadTopicImage(this.fileUpload.PostedFile); } catch { this.ShowMsg("图片上传失败,您选择的不是图片类型的文件,或者网站的虚拟目录没有写入文件的权限", false); return; } } string str2 = string.Empty; for (int i = 0; i < this.cbList.Items.Count; i++) { if (this.cbList.Items[i].Selected) { str2 = str2 + "," + this.cbList.Items[i].Value; } } if (!string.IsNullOrEmpty(str2)) { LotteryTicketInfo info = new LotteryTicketInfo { GradeIds = str2, MinValue = Convert.ToInt32(this.txtMinValue.Text), InvitationCode = this.txtCode.Text.Trim(), ActivityName = this.txtActiveName.Text, ActivityKey = this.txtKeyword.Text, ActivityDesc = this.txtdesc.Text, ActivityPic = str, ActivityType = 4, StartTime = this.calendarStartDate.SelectedDate.Value, OpenTime = this.calendarOpenDate.SelectedDate.Value.AddHours((double) this.ddlHours.SelectedIndex), EndTime = this.calendarEndDate.SelectedDate.Value, PrizeSettingList = new List<PrizeSetting>() }; try { PrizeSetting item = new PrizeSetting { PrizeName = this.txtPrize1.Text, PrizeNum = Convert.ToInt32(this.txtPrize1Num.Text), PrizeLevel = "一等奖" }; info.PrizeSettingList.Add(item); PrizeSetting setting2 = new PrizeSetting { PrizeName = this.txtPrize2.Text, PrizeNum = Convert.ToInt32(this.txtPrize2Num.Text), PrizeLevel = "二等奖" }; info.PrizeSettingList.Add(setting2); PrizeSetting setting3 = new PrizeSetting { PrizeName = this.txtPrize3.Text, PrizeNum = Convert.ToInt32(this.txtPrize3Num.Text), PrizeLevel = "三等奖" }; info.PrizeSettingList.Add(setting3); } catch (FormatException) { this.ShowMsg("奖品数量格式错误", false); return; } if (this.ChkOpen.Checked) { try { PrizeSetting setting4 = new PrizeSetting { PrizeName = this.txtPrize4.Text, PrizeNum = Convert.ToInt32(this.txtPrize4Num.Text), PrizeLevel = "四等奖" }; info.PrizeSettingList.Add(setting4); PrizeSetting setting5 = new PrizeSetting { PrizeName = this.txtPrize5.Text, PrizeNum = Convert.ToInt32(this.txtPrize5Num.Text), PrizeLevel = "五等奖" }; info.PrizeSettingList.Add(setting5); PrizeSetting setting6 = new PrizeSetting { PrizeName = this.txtPrize6.Text, PrizeNum = Convert.ToInt32(this.txtPrize6Num.Text), PrizeLevel = "六等奖" }; info.PrizeSettingList.Add(setting6); } catch (FormatException) { this.ShowMsg("奖品数量格式错误", false); return; } } int num2 = VShopHelper.SaveLotteryTicket(info); if (num2 > 0) { ReplyInfo reply = new TextReplyInfo { Keys = info.ActivityKey, MatchType = MatchType.Equal, MessageType = MessageType.Text, ReplyType = ReplyType.Ticket, ActivityId = num2 }; ReplyHelper.SaveReply(reply); base.Response.Redirect("ManageLotteryTicket.aspx"); } } else { this.ShowMsg("请选择活动会员等级", false); } } }