protected void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(this.txtName.Text))
{
MessageBox.ShowFailTip(this, Poll.ErrorOptionsNotNull);
}
else
{
string text = this.txtName.Text;
int num = int.Parse(this.lblTopicID.Text);
int num2 = this.chkisChecked.Checked ? 1 : 0;
Maticsoft.Model.Poll.Options model = new Maticsoft.Model.Poll.Options {
Name = text,
TopicID = new int?(num),
isChecked = new int?(num2),
SubmitNum = 0
};
if (this.blloption.Exists(num, text))
{
MessageBox.ShowFailTip(this, Poll.ErrorOptionsExists);
}
else
{
this.blloption.Add(model);
this.Session["strWhereOptions"] = " TopicID= " + this.lblTopicID.Text;
this.gridView.OnBind();
}
}
}
public Maticsoft.Model.Poll.Options GetModel(int ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 ID,Name,TopicID,isChecked,SubmitNum from Poll_Options ");
builder.Append(" where ID=@ID ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4) };
cmdParms[0].Value = ID;
Maticsoft.Model.Poll.Options options = new Maticsoft.Model.Poll.Options();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if (set.Tables[0].Rows[0]["ID"].ToString() != "")
{
options.ID = int.Parse(set.Tables[0].Rows[0]["ID"].ToString());
}
options.Name = set.Tables[0].Rows[0]["Name"].ToString();
if (set.Tables[0].Rows[0]["TopicID"].ToString() != "")
{
options.TopicID = new int?(int.Parse(set.Tables[0].Rows[0]["TopicID"].ToString()));
}
if (set.Tables[0].Rows[0]["isChecked"].ToString() != "")
{
options.isChecked = new int?(int.Parse(set.Tables[0].Rows[0]["isChecked"].ToString()));
}
if (set.Tables[0].Rows[0]["SubmitNum"].ToString() != "")
{
options.SubmitNum = new int?(int.Parse(set.Tables[0].Rows[0]["SubmitNum"].ToString()));
}
return options;
}