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