/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Questionary DataRowToModel(DataRow row)
{
Model.Questionary model = new Model.Questionary();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = long.Parse(row["ID"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["IsValid"] != null && row["IsValid"].ToString() != "")
{
if ((row["IsValid"].ToString() == "1") || (row["IsValid"].ToString().ToLower() == "true"))
{
model.IsValid = true;
}
else
{
model.IsValid = false;
}
}
}
return model;
}
protected void rbtnSubmit_Click(object sender, EventArgs e)
{
string title = RTB_Title.Text;
if (title.Trim().Equals(""))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉，标题不能为空！');", true);
return;
}
SmartLaw.Model.Questionary qnModel = new Model.Questionary();
List<SmartLaw.Model.Question> qsModelList = new List<Model.Question>();
if (!RadButton2.Checked)
{
qnModel.IsValid = true;
for (int i = 0; i < RadGrid1.Items.Count; i++)
{
SmartLaw.Model.Question qsM = new Model.Question();
qsM.Orders = i;
RadTextBox box = (RadTextBox)RadGrid1.Items[i].FindControl("content");
string Content = box.Text;
if (Content.Trim() == "")
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉，问题不能为空！');", true);
return;
}
qsM.Content = Content;
RadTextBox box1 = (RadTextBox)RadGrid1.Items[i].FindControl("answer1");
string Answer1 = box1.Text;
RadTextBox box2 = (RadTextBox)RadGrid1.Items[i].FindControl("answer2");
string Answer2 = box2.Text;
RadTextBox box3 = (RadTextBox)RadGrid1.Items[i].FindControl("answer3");
string Answer3 = box3.Text;
RadTextBox box4 = (RadTextBox)RadGrid1.Items[i].FindControl("answer4");
string Answer4 = box4.Text;
StringBuilder ansSb = new StringBuilder();
if (Answer1.Trim() != "")
{
ansSb.Append(Answer1.Trim() + "|");
}
if (Answer2.Trim() != "")
{
ansSb.Append(Answer2.Trim() + "|");
}
if (Answer3.Trim() != "")
{
ansSb.Append(Answer3.Trim() + "|");
}
if (Answer4.Trim() != "")
{
ansSb.Append(Answer4.Trim() + "|");
}
if (ansSb.ToString().Equals(""))
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c1", "OpenAlert('抱歉，一个问题至少有一个选项！');", true);
return;
}
string[] ans = ansSb.ToString().Substring(0, ansSb.ToString().Length - 1).Split('|');
qsM.Answer = ans;
RadButton rbt = RadGrid1.Items[i].FindControl("RadButton3") as RadButton;
qsM.IsSingle = rbt.Checked;
qsModelList.Add(qsM);
}
}
else
{
qnModel.IsValid = false;
}
SmartLaw.Model.Log logM = new Model.Log();
logM.OperationItem = "新增调查问卷";
logM.OperationDetail = "标题："+title;
logM.OperationTime = DateTime.Now;
logM.Operator = user.UserInfo.UserID;
logM.Memo = "";
long idAdd = 0;
try
{
qnModel.Title = title;
if (qnModel.IsValid)
{
idAdd = qn.AddQuestionary(qnModel, qsModelList.ToArray());
}
else
{
idAdd = qn.AddEmptyQuestionary(qnModel);
}
if (idAdd != 0)
{
logM.Memo += "成功";
}
else
{
logM.Memo += "失败";
}
}
catch (Exception ex)
{
logM.Memo += ex.Message;
}
finally
{
log.Add(logM);
if (idAdd!=0)
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c", "OpenAlert('恭喜！添加成功！');", true);
}
else
{
RadScriptManager.RegisterStartupScript(this.Page, this.GetType(), "c3", "OpenAlert('抱歉！添加失败！');", true);
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Questionary GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Title,IsValid from Questionary");
strSql.Append(" where ID=@ID limit 1");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.Int64),
};
parameters[0].Value = ID;
Model.Questionary model = new Model.Questionary();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
