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