private List <M_Exam_Type> GetTypeBySql(string sql) { List <M_Exam_Type> mqts; DataSet ds = SqlHelper.ExecuteDataSet(CommandType.Text, sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { mqts = new List <M_Exam_Type>(); foreach (DataRow dr in ds.Tables[0].Rows) { M_Exam_Type mqt = new M_Exam_Type(); mqt.t_id = DataConverter.CLng(dr["t_id"].ToString()); mqt.t_name = dr["t_name"].ToString(); mqt.t_type = DataConverter.CLng(dr["t_type"].ToString()); mqt.t_remark = dr["t_remark"].ToString(); mqt.t_createtime = DataConverter.CDate(dr["t_createtime"].ToString()); mqt.t_creatuser = DataConverter.CLng(dr["t_creatuser"].ToString()); mqts.Add(mqt); } return(mqts); } else { return(new List <M_Exam_Type>()); } }
protected void ddlType_SelectedIndexChanged(object sender, EventArgs e) { Tips.Text = "<font color='red'>请输入个数</font>"; int type = DataConverter.CLng(ddlType.SelectedValue); tip.Visible = false; M_Exam_Type mqt = bqt.GetSelectById(type); //单选,多选,判断,填空,问答,组合 switch (mqt.t_type) { case 1: ddlNumber1.SelectedValue = "4"; break; case 2: ddlNumber1.SelectedValue = "4"; break; case 4: ddlNumber1.SelectedValue = "1"; tip.Visible = true; break; default: break; } option(); }
protected void EBtnSubmit_Click(object sender, EventArgs e) { int id = DataConverter.CLng(hftid.Value); M_Exam_Type mqt = bqt.GetSelectById(id); mqt.t_type = DataConverter.CLng(ddType.SelectedValue); mqt.t_remark = txtRemark.Text; mqt.t_name = txt_name.Text; mqt.t_creatuser = badmin.GetAdminLogin().AdminId; if (id > 0) { bool result = bqt.GetUpdate(mqt); if (result) { function.WriteSuccessMsg("修改成功!", "QuestionTypeManage.aspx"); } else { function.WriteErrMsg("修改失败!"); } } else { mqt.t_createtime = DateTime.Now; int ids = bqt.GetAdd(mqt); if (ids > 0) { function.WriteSuccessMsg("添加成功!", "QuestionTypeManage.aspx"); } else { function.WriteErrMsg("添加失败!"); } } }
/// <summary> /// 获取内容 /// </summary> /// <returns></returns> private string[] GetContent() { string[] result = new string[2]; int type = DataConverter.CLng(ddlType.SelectedValue); M_Exam_Type mqt = bqt.GetSelectById(type); int num = DataConverter.CLng(ddlNumber1.SelectedValue); //单选,多选,判断,填空,问答,组合 switch (mqt.t_type) { case 1: result[0] = Request.Form["option"]; result[1] = Request.Form["anws"]; break; case 2: result[0] = Request.Form["option"]; result[1] = Request.Form["anws"]; break; case 3: result[0] = ""; result[1] = Request.Form["anws"]; break; case 4: result[0] = ""; result[1] = Request.Form["amws"] + "&" + Request.Form["curse"]; break; case 5: result[0] = ""; result[1] = Request.Form["option"] + "&" + Request.Form["key"] + "&" + Request.Form["course"]; break; case 6: break; } return(result); }
protected void Page_Load(object sender, EventArgs e) { function.AccessRulo(); if (!IsPostBack) { int id = DataConverter.CLng(Request.QueryString["id"]); if (id > 0) { liQuestionType.Text = "修改题型"; Label1.Text = "修改题型"; hftid.Value = id.ToString(); M_Exam_Type mqt = bqt.GetSelectById(id); txt_name.Text = mqt.t_name; txtRemark.Text = mqt.t_remark; ddType.SelectedValue = mqt.t_type.ToString(); } else { liQuestionType.Text = "添加题型"; Label1.Text = "添加题型"; } Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li> <li><a href='Papers_System_Manage.aspx'>教育模块</a></li> <li><a href='QuestionManage.aspx'>考试管理</a></li> <li><a href='QuestionTypeManage.aspx'>题型管理</a></li><li>修改题型</li>"); } }
/// <summary> /// 试题题型选择:页面显示 /// </summary> private void option() { string option = hfoption.Value; string answer = hfanw.Value; int type = DataConverter.CLng(ddlType.SelectedValue); string[] str = { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J" }; M_Exam_Type mqt = bqt.GetSelectById(type); int num = DataConverter.CLng(ddlNumber1.SelectedValue); string[] options = option.Split(','); string[] answers = answer.Split(','); string opt = ""; string anws = ""; //单选,多选,判断,填空,问答,组合 switch (mqt.t_type) { case 1: //单选 ddlNumber1.Visible = true; Tips.Visible = true; optionDiv.Visible = true; anwDiv.Visible = true; optionDiv.InnerHtml = ""; anwDiv.InnerHtml = ""; Tips.Text += "<font color='red'> 注意:以下信息请不要输入','(逗号)</font>"; for (int i = 0; i < num; i++) { if (i < options.Length) { opt = options[i]; } else { opt = ""; } optionDiv.InnerHtml += str[i] + ": <textarea name='option' id='option" + i + "' style='width:400px;height:43px'>" + opt + "</textarea><br/>"; if (str[i] == answer) { anws = "checked='checked'"; } else { anws = ""; } anwDiv.InnerHtml += str[i] + "<input type='radio' id='anw" + i + "' name='anws' value='" + str[i] + "' " + anws + " />"; } break; case 2: //多选 ddlNumber1.Visible = true; Tips.Visible = true; Tips.Text += "<font color='red'> 注意:以下信息请不要输入','(逗号)</font>"; optionDiv.Visible = true; anwDiv.Visible = true; optionDiv.InnerHtml = ""; anwDiv.InnerHtml = ""; for (int i = 0; i < num; i++) { if (i < options.Length) { opt = options[i]; } else { opt = ""; } optionDiv.InnerHtml += str[i] + ": <textarea name='option' id='option" + i + "' style='width:400px;height:43px' >" + opt + "</textarea><br/>"; if (answer.IndexOf(str[i]) > -1) { anws = "checked='checked'"; } else { anws = ""; } anwDiv.InnerHtml += str[i] + "<input type='checkbox' id='anw" + i + "' name='anws' value='" + str[i] + "' " + anws + "/> "; } break; case 3: //判段 ddlNumber1.Visible = false; Tips.Visible = false; optionDiv.Visible = false; anwDiv.Visible = true; if (answer == "0") { anwDiv.InnerHtml = "<input type='radio' id='anw1' name='anws' value='0' checked='checked'/>错误 <input type='radio' id='anw2' name='anws' value='1' />正确 "; } else { anwDiv.InnerHtml = "<input type='radio' id='anw1' name='anws' value='0' />错误 <input type='radio' id='anw2' name='anws' value='1' checked='checked' />正确 "; } break; default: break; } }
/// <summary> /// 修改题型 /// </summary> /// <param name="mqt"></param> /// <returns></returns> public bool GetUpdate(M_Exam_Type model) { return(DBCenter.UpdateByID(model, model.t_id)); }
/// <summary> /// 添加 /// </summary> /// <param name="mqt"></param> /// <returns></returns> public int GetAdd(M_Exam_Type model) { return(DBCenter.Insert(model)); }