void BindVoteItem(VoteInfo vote) { int num = 0; if (vote != null) { this.lblVoteName.Text = vote.VoteName; IList<VoteItemInfo> voteItems = CommentBrowser.GetVoteItems(this.voteId); for (int i = 0; i < voteItems.Count; i++) { if (vote.VoteCounts != 0) { voteItems[i].Percentage = (voteItems[i].ItemCount / vote.VoteCounts) * 100M; num += voteItems[i].ItemCount; } else { voteItems[i].Percentage = 0M; } } this.rptVoteItem.DataSource = voteItems; this.rptVoteItem.DataBind(); if (this.lblTotal != null) { this.lblTotal.Text = num.ToString(); } } }
public static int CreateVote(VoteInfo vote) { int num = 0; VoteDao dao = new VoteDao(); long num2 = dao.CreateVote(vote); if (num2 > 0L) { ReplyInfo reply = new TextReplyInfo { Keys = vote.Keys, MatchType = MatchType.Equal, ReplyType = ReplyType.Vote, ActivityId = Convert.ToInt32(num2) }; new ReplyDao().SaveReply(reply); num = 1; if (vote.VoteItems == null) { return num; } foreach (VoteItemInfo info2 in vote.VoteItems) { info2.VoteId = num2; info2.ItemCount = 0; num += dao.CreateVoteItem(info2, null); } } return num; }
private void btnEditVote_Click(object sender, EventArgs e) { if (SubsiteStoreHelper.GetVoteCounts(voteId) > 0) { ShowMsg("投票已经开始,不能再对投票选项进行任何操作", false); } else { int num; VoteInfo vote = new VoteInfo(); vote.VoteName = Globals.HtmlEncode(txtAddVoteName.Text.Trim()); vote.VoteId = voteId; vote.IsBackup = checkIsBackup.Checked; if (int.TryParse(txtMaxCheck.Text.Trim(), out num)) { vote.MaxCheck = num; } else { vote.MaxCheck = -2147483648; } IList<VoteItemInfo> list = null; if (!string.IsNullOrEmpty(txtValues.Text.Trim())) { list = new List<VoteItemInfo>(); string[] strArray = txtValues.Text.Trim().Replace("\r\n", "\n").Replace("\n", "*").Split(new char[] { '*' }); for (int i = 0; i < strArray.Length; i++) { VoteItemInfo item = new VoteItemInfo(); if (strArray[i].Length > 60) { ShowMsg("投票选项长度限制在60个字符以内", false); return; } item.VoteItemName = Globals.HtmlEncode(strArray[i]); list.Add(item); } } else { ShowMsg("投票选项不能为空", false); return; } vote.VoteItems = list; if (ValidationVote(vote)) { if (SubsiteStoreHelper.UpdateVote(vote)) { ShowMsg("修改投票成功", true); } else { ShowMsg("修改投票失败", false); } } } }
private bool ValidationVote(VoteInfo vote) { ValidationResults results = Hishop.Components.Validation.Validation.Validate<VoteInfo>(vote, new string[] { "ValVote" }); string msg = string.Empty; if (!results.IsValid) { foreach (ValidationResult result in (IEnumerable<ValidationResult>)results) { msg = msg + Formatter.FormatErrorMessage(result.Message); } ShowMsg(msg, false); } return results.IsValid; }
public override long CreateVote(VoteInfo vote) { DbCommand storedProcCommand = database.GetStoredProcCommand("cp_Votes_Create"); database.AddInParameter(storedProcCommand, "VoteName", DbType.String, vote.VoteName); database.AddInParameter(storedProcCommand, "IsBackup", DbType.Boolean, vote.IsBackup); database.AddInParameter(storedProcCommand, "MaxCheck", DbType.Int32, vote.MaxCheck); database.AddOutParameter(storedProcCommand, "VoteId", DbType.Int64, 8); long parameterValue = 0; if (database.ExecuteNonQuery(storedProcCommand) > 0) { parameterValue = (long)database.GetParameterValue(storedProcCommand, "VoteId"); } return parameterValue; }
public long CreateVote(VoteInfo vote) { DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_Votes_Create"); this.database.AddInParameter(storedProcCommand, "VoteName", DbType.String, vote.VoteName); this.database.AddInParameter(storedProcCommand, "IsBackup", DbType.Boolean, vote.IsBackup); this.database.AddInParameter(storedProcCommand, "MaxCheck", DbType.Int32, vote.MaxCheck); this.database.AddInParameter(storedProcCommand, "ImageUrl", DbType.String, vote.ImageUrl); this.database.AddInParameter(storedProcCommand, "StartDate", DbType.DateTime, vote.StartDate); this.database.AddInParameter(storedProcCommand, "EndDate", DbType.DateTime, vote.EndDate); this.database.AddInParameter(storedProcCommand, "Keys", DbType.String, vote.Keys); this.database.AddOutParameter(storedProcCommand, "VoteId", DbType.Int64, 8); long parameterValue = 0L; if (this.database.ExecuteNonQuery(storedProcCommand) > 0) { parameterValue = (long) this.database.GetParameterValue(storedProcCommand, "VoteId"); } return parameterValue; }
public static int CreateVote(VoteInfo vote) { int num = 0; long num2 = StoreProvider.Instance().CreateVote(vote); if (num2 > 0) { num = 1; if (vote.VoteItems == null) { return num; } foreach (VoteItemInfo info in vote.VoteItems) { info.VoteId = num2; info.ItemCount = 0; num += StoreProvider.Instance().CreateVoteItem(info, null); } } return num; }
public bool UpdateVote(VoteInfo vote, DbTransaction dbTran) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE Hishop_Votes SET VoteName = @VoteName, MaxCheck = @MaxCheck, ImageUrl=@ImageUrl, StartDate=@StartDate, EndDate=@EndDate WHERE VoteId = @VoteId; UPDATE vshop_Reply SET Keys = @Keys WHERE ActivityId = @VoteId AND [ReplyType] = @ReplyType"); this.database.AddInParameter(sqlStringCommand, "VoteName", DbType.String, vote.VoteName); this.database.AddInParameter(sqlStringCommand, "MaxCheck", DbType.Int32, vote.MaxCheck); this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, vote.ImageUrl); this.database.AddInParameter(sqlStringCommand, "StartDate", DbType.DateTime, vote.StartDate); this.database.AddInParameter(sqlStringCommand, "EndDate", DbType.DateTime, vote.EndDate); this.database.AddInParameter(sqlStringCommand, "Keys", DbType.String, vote.Keys); this.database.AddInParameter(sqlStringCommand, "ReplyType", DbType.Int32, 0x80); this.database.AddInParameter(sqlStringCommand, "VoteId", DbType.Int64, vote.VoteId); return (this.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0); }
public static VoteInfo PopulateVote(IDataRecord reader) { VoteInfo info = new VoteInfo { VoteId = (long) reader["VoteId"], VoteName = (string) reader["VoteName"], IsBackup = (bool) reader["IsBackup"], MaxCheck = (int) reader["MaxCheck"] }; if (reader["ImageUrl"] != DBNull.Value) { info.ImageUrl = (string) reader["ImageUrl"]; } info.StartDate = (DateTime) reader["StartDate"]; info.EndDate = (DateTime) reader["EndDate"]; info.VoteCounts = (int) reader["VoteCounts"]; if (reader["Keys"] != DBNull.Value) { info.Keys = (string) reader["Keys"]; } return info; }
public static bool UpdateVote(VoteInfo vote) { bool flag; using (DbConnection connection = DatabaseFactory.CreateDatabase().CreateConnection()) { connection.Open(); DbTransaction dbTran = connection.BeginTransaction(); try { if (!StoreProvider.Instance().UpdateVote(vote, dbTran)) { dbTran.Rollback(); return false; } if (!StoreProvider.Instance().DeleteVoteItem(vote.VoteId, dbTran)) { dbTran.Rollback(); return false; } int num = 0; if (vote.VoteItems != null) { foreach (VoteItemInfo info in vote.VoteItems) { info.VoteId = vote.VoteId; info.ItemCount = 0; num += StoreProvider.Instance().CreateVoteItem(info, dbTran); } if (num < vote.VoteItems.Count) { dbTran.Rollback(); return false; } } dbTran.Commit(); flag = true; } catch { dbTran.Rollback(); flag = false; } finally { connection.Close(); } } return flag; }
public abstract bool UpdateVote(VoteInfo vote, DbTransaction dbTran);
public abstract long CreateVote(VoteInfo vote);
public static VoteInfo PopulateVote(IDataRecord reader) { VoteInfo info = new VoteInfo(); info.VoteId = (long) reader["VoteId"]; info.VoteName = (string) reader["VoteName"]; info.IsBackup = (bool) reader["IsBackup"]; info.MaxCheck = (int) reader["MaxCheck"]; info.VoteCounts = (int) reader["VoteCounts"]; return info; }
void Vote(VoteInfo vote) { HttpCookie cookie = HiContext.Current.Context.Request.Cookies[this.voteId.ToString()]; if (cookie == null) { if (this.Page.Request.Params["VoteItemId"] != null) { string str = this.Page.Request.Params["VoteItemId"]; if (!string.IsNullOrEmpty(str)) { string[] strArray = str.Split(new char[] { ',' }); for (int i = 0; i < strArray.Length; i++) { if (!string.IsNullOrEmpty(strArray[i]) && ((i + 1) <= vote.MaxCheck)) { long voteItemId = Convert.ToInt64(strArray[i]); VoteItemInfo voteItemById = CommentBrowser.GetVoteItemById(voteItemId); if (vote.VoteId == voteItemById.VoteId) { CommentBrowser.Vote(voteItemId); } } } cookie = new HttpCookie(this.voteId.ToString()); cookie.Expires = DateTime.Now.AddYears(100); cookie.Value = this.voteId.ToString(); HiContext.Current.Context.Response.Cookies.Add(cookie); this.ShowMessage("投票成功", true); } } } else if ((cookie != null) && !string.IsNullOrEmpty(this.Page.Request.QueryString["VoteItemId"].ToString())) { this.ShowMessage("该用户已经投过票了", false); } }
public override bool UpdateVote(VoteInfo vote, DbTransaction dbTran) { DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE distro_Votes SET VoteName = @VoteName, IsBackup = @IsBackup, MaxCheck = @MaxCheck WHERE VoteId = @VoteId AND DistributorUserId=@DistributorUserId"); database.AddInParameter(sqlStringCommand, "VoteName", DbType.String, vote.VoteName); database.AddInParameter(sqlStringCommand, "IsBackup", DbType.Boolean, vote.IsBackup); database.AddInParameter(sqlStringCommand, "MaxCheck", DbType.Int32, vote.MaxCheck); database.AddInParameter(sqlStringCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId); database.AddInParameter(sqlStringCommand, "VoteId", DbType.Int64, vote.VoteId); return (database.ExecuteNonQuery(sqlStringCommand, dbTran) == 1); }
private void btnAddVote_Click(object sender, EventArgs e) { if (ReplyHelper.HasReplyKey(this.txtKeys.Text.Trim())) { this.ShowMsg("关键字重复!", false); } else { string str = string.Empty; if (!this.fileUpload.HasFile) { this.ShowMsg("请上传一张封面图", false); } else { try { str = StoreHelper.UploadVoteImage(this.fileUpload.PostedFile); } catch { this.ShowMsg("图片上传失败,您选择的不是图片类型的文件,或者网站的虚拟目录没有写入文件的权限", false); return; } if (this.calendarStartDate.SelectedDate.HasValue) { if (!this.calendarEndDate.SelectedDate.HasValue) { this.ShowMsg("请选择活动结束时间", false); } else { VoteInfo vote = new VoteInfo { VoteName = Globals.HtmlEncode(this.txtAddVoteName.Text.Trim()), Keys = this.txtKeys.Text.Trim(), IsBackup = this.checkIsBackup.Checked }; int result = 1; if (int.TryParse(this.txtMaxCheck.Text.Trim(), out result)) { vote.MaxCheck = result; } vote.ImageUrl = str; vote.StartDate = this.calendarStartDate.SelectedDate.Value; vote.EndDate = this.calendarEndDate.SelectedDate.Value; IList<VoteItemInfo> list = null; if (!string.IsNullOrEmpty(this.txtValues.Text.Trim())) { list = new List<VoteItemInfo>(); string[] strArray = this.txtValues.Text.Trim().Replace("\r\n", "\n").Replace("\n", "*").Split(new char[] { '*' }); for (int i = 0; i < strArray.Length; i++) { VoteItemInfo item = new VoteItemInfo(); if (strArray[i].Length > 60) { this.ShowMsg("投票选项长度限制在60个字符以内", false); return; } item.VoteItemName = Globals.HtmlEncode(strArray[i]); list.Add(item); } } else { this.ShowMsg("投票选项不能为空", false); return; } vote.VoteItems = list; if (this.ValidationVote(vote)) { if (StoreHelper.CreateVote(vote) > 0) { this.ShowMsg("成功的添加了一个投票", true); this.txtAddVoteName.Text = string.Empty; this.checkIsBackup.Checked = false; this.txtMaxCheck.Text = string.Empty; this.txtValues.Text = string.Empty; } else { this.ShowMsg("添加投票失败", false); } } } } else { this.ShowMsg("请选择活动开始时间", false); } } } }
public override bool UpdateVote(VoteInfo vote, DbTransaction dbTran) { DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_Votes SET VoteName = @VoteName, MaxCheck = @MaxCheck WHERE VoteId = @VoteId"); database.AddInParameter(sqlStringCommand, "VoteName", DbType.String, vote.VoteName); database.AddInParameter(sqlStringCommand, "MaxCheck", DbType.Int32, vote.MaxCheck); database.AddInParameter(sqlStringCommand, "VoteId", DbType.Int64, vote.VoteId); return (database.ExecuteNonQuery(sqlStringCommand, dbTran) == 1); }