/// <summary> /// ��ȡ��¼ /// </summary> /// <param name="optionId">ѡ��Id</param> /// <returns>���ݶ���</returns> public Model.PollOptionInfo GetItem(int optionId) { Model.PollOptionInfo info = null; string cmdText = "select OptionId,PollId,[Option],Total From XY_PollOption where OptionId= @OptionId"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@OptionId",optionId) }; using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, cmdText, param)) { while (reader.Read()) { info = new XYECOM.Model.PollOptionInfo(); info.OptionId = reader.GetInt32(0); info.PollId = reader.GetInt32(1); info.Option = reader.GetString(2); info.Total = reader.GetInt32(3); } } return info; }
protected void btnOK_Click(object sender, EventArgs e) { string labelName = "XY_POLL_" + txtName.Text.Trim(); string title = this.txtTitle.Text.Trim(); Model.PollInfo poll = new XYECOM.Model.PollInfo(); Business.Poll pollBLL = new XYECOM.Business.Poll(); poll.LabelName = labelName; poll.Title = title; poll.Mode = XYECOM.Model.PollMode.Single; if (rdoCheck.Checked) poll.Mode = XYECOM.Model.PollMode.Check; int lastPollId = 0; pollBLL.Insert(poll, out lastPollId); int optionTotal = Core.MyConvert.GetInt32(this.OptionTotal.Value); Business.PollOption optionBLL = new XYECOM.Business.PollOption(); Model.PollOptionInfo optionInfo = null; for (int i = 1; i <= optionTotal; i++) { string option = XYECOM.Core.XYRequest.GetFormString("option" + i).Trim(); if (string.IsNullOrEmpty(option)) continue; optionInfo = new XYECOM.Model.PollOptionInfo(); optionInfo.Option = option; optionInfo.PollId = lastPollId; optionBLL.Insert(optionInfo); } Response.Redirect("PollLabelList.aspx"); }
/// <summary> /// ��ȡָ��ͶƱ�µ�����ѡ�� /// </summary> /// <param name="pollId">ͶƱ��¼Id</param> /// <returns>���ݶ���</returns> public List<Model.PollOptionInfo> GetItems(int pollId) { List<Model.PollOptionInfo> list = new List<XYECOM.Model.PollOptionInfo>(); string cmdText = "select OptionId,PollId,[Option],Total From XY_PollOption " + " where PollId =@PollId" + " Order By OptionId asc"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PollId",pollId) }; Model.PollOptionInfo info = null; using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, cmdText, param)) { while (reader.Read()) { info = new XYECOM.Model.PollOptionInfo(); info.OptionId = reader.GetInt32(0); info.PollId = reader.GetInt32(1); info.Option = reader.GetString(2); info.Total = reader.GetInt32(3); list.Add(info); } } return list; }
protected void btnOK_Click(object sender, EventArgs e) { if (!XYECOM.Core.XYRequest.IsPost()) return; int pollId = XYECOM.Core.XYRequest.GetQueryInt("pollId", 0); if (pollId <= 0) return; Business.Poll pollBLL = new XYECOM.Business.Poll(); Model.PollInfo poll = pollBLL.GetItem(pollId); if (poll == null) return; poll.LabelName = "XY_POLL_" + this.txtName.Text.Trim(); poll.Title = this.txtTitle.Text.Trim(); poll.Mode = XYECOM.Model.PollMode.Single; if (rdoCheck.Checked) poll.Mode = XYECOM.Model.PollMode.Check; pollBLL.Update(poll); int total = XYECOM.Core.MyConvert.GetInt32(this.OptionTotal.Value.ToString()); Business.PollOption opBLL = new XYECOM.Business.PollOption(); Model.PollOptionInfo optionInfo = null; string option = "" ; int optionId = 0; for (int i = 1; i <= total; i++) { option = XYECOM.Core.XYRequest.GetFormString("option" + i).Trim(); if (string.IsNullOrEmpty(option)) continue; optionId = XYECOM.Core.XYRequest.GetInt("option_id_" + i,0); if (optionId > 0) { optionInfo = opBLL.GetItem(optionId); if (optionInfo != null) { optionInfo.Option = option; opBLL.Update(optionInfo); } else { optionInfo = new XYECOM.Model.PollOptionInfo(); optionInfo.Option = option; optionInfo.PollId = poll.PollId; opBLL.Insert(optionInfo); } } else { optionInfo = new XYECOM.Model.PollOptionInfo(); optionInfo.Option = option; optionInfo.PollId = poll.PollId; opBLL.Insert(optionInfo); } } string delIds = this.DelOptionIds.Value.ToString(); string[] ids = delIds.Split(','); foreach (string id in ids) { int _Id = Core.MyConvert.GetInt32(id); if (_Id <= 0) continue; opBLL.Delete(_Id); } Alert("�ijɹ���", "PollLabelList.aspx",true); }