/// <summary>
/// 获取指定调查下的所有主题
/// </summary>
/// <param name="voteId">调查Id</param>
/// <returns></returns>
public List<Model.VoteSubjectInfo> GetItemsByVoteId(int voteId)
{
string cmdText = "select * from XY_VoteSubject where voteId =@VoteId";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@VoteId",voteId)
};
List<Model.VoteSubjectInfo> list = new List<XYECOM.Model.VoteSubjectInfo>();
using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, cmdText, param))
{
while (reader.Read())
{
Model.VoteSubjectInfo info = new XYECOM.Model.VoteSubjectInfo();
info.SubjectId = XYECOM.Core.MyConvert.GetInt32(reader["SubjectId"].ToString());
info.Subject = reader["Subject"].ToString();
info.VoteId = XYECOM.Core.MyConvert.GetInt32(reader["VoteId"].ToString());
info.StrType = reader["type"].ToString();
list.Add(info);
}
}
return list;
}
/// <summary>
/// 获取问题信息
/// </summary>
/// <param name="subjectId">问题Id</param>
/// <returns></returns>
public Model.VoteSubjectInfo GetItem(int subjectId)
{
string cmdText = "select * from XY_VoteSubject where subjectId =@SubjectId";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@SubjectId",subjectId)
};
Model.VoteSubjectInfo info = null;
using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, cmdText, param))
{
if (reader.Read())
{
info = new XYECOM.Model.VoteSubjectInfo();
info.SubjectId = XYECOM.Core.MyConvert.GetInt32(reader["SubjectId"].ToString());
info.Subject = reader["Subject"].ToString();
info.StrType = reader["Type"].ToString();
info.VoteId = XYECOM.Core.MyConvert.GetInt32(reader["VoteId"].ToString());
}
}
return info;
}
protected void btnOK_Click(object sender, EventArgs e)
{
int voteId = XYECOM.Core.XYRequest.GetQueryInt("voteid", 0);
backURL = XYECOM.Core.XYRequest.GetString("backURL1");
if (voteId <= 0)
{
Alert("非法参数！", backURL);
}
Model.VoteSubjectInfo subject = new XYECOM.Model.VoteSubjectInfo();
subject.Subject = this.txtSubject.Text.Trim();
subject.StrType = this.rdolstType.SelectedValue;
subject.VoteId = voteId;
int subjectId = 0;
new Business.VoteSubject().Insert(subject, out subjectId);
if (subjectId > 0)
{
int optionTotal = Core.MyConvert.GetInt32(this.OptionTotal.Value);
Business.VoteOptions optionBLL = new XYECOM.Business.VoteOptions();
Model.VoteOptionsInfo 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.VoteOptionsInfo();
optionInfo.Text = option;
optionInfo.SubjectId = subjectId;
optionInfo.VoteTotal = 0;
optionBLL.Insert(optionInfo);
}
}
Response.Redirect(backURL);
}