//添加 public void addquestionmenu(int questionId, string name, int pass, int ismust) { try { Exam.Entity.tb_QuestionClsEntity model = new Exam.Entity.tb_QuestionClsEntity(); UserIdentity identity = User.Identity as UserIdentity; if (identity != null) { model.SchoolId = 0;//identity._schoolID; model.ParentId = questionId; model.Name = name; model.Description = name; model.Status = 1; model.Addtime = DateTime.Now; model.Updatetime = DateTime.Now; model.IsMust = ismust; model.Score = pass; Exam.BLL.tb_QuestionClsBLL.GetInstance().Insert(model); Response.Write("1"); } } catch (Exception ex) { Jnwf.Utils.Log.Logger.Log4Net.Error("data.aspx.cs,addquestionmenu,ex:" + ex.Message + "|" + ex.StackTrace); Response.Write("error"); } }
protected void btnexcel_Click(object sender, EventArgs e) { if (identity != null) { string where = ""; if (hid.Text.Trim() != "") { Exam.Entity.tb_QuestionClsEntity model = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(int.Parse(hid.Text.Trim())); if (model.ParentId != 0) { where += " and ParentId =" + hid.Text.Trim(); DataSet tds = Exam.BLL.tb_QuestionBLL.GetInstance().GetList("schoolid=" + 0 + where); gvlistbrary.DataSource = tds; gvlistbrary.DataBind(); if (gvlistbrary.Rows.Count > 0) { //调用导出方法 GridViewToExcel(gvlistbrary, DateTime.Now.Ticks + ".xls"); } return; } } if (!string.IsNullOrEmpty(hid.Text.Trim())) { where += " and QuestionClsId =" + hid.Text.Trim(); } //难度 if (int.Parse(dllharde.SelectedItem.Value) != -1) { where += " and Isdifficulty =" + dllharde.SelectedValue; } //状态 if (int.Parse(dllstatus.SelectedItem.Value) != -1) { where += " and Status=" + dllstatus.SelectedValue; } //单选 if (int.Parse(dlltype.SelectedItem.Value) != -1) { where += " and Type=" + dlltype.SelectedValue; } DataSet ds = Exam.BLL.tb_QuestionBLL.GetInstance().GetList("schoolid=" + 0 + where); gvlistbrary.DataSource = ds; gvlistbrary.DataBind(); if (gvlistbrary.Rows.Count > 0) { //调用导出方法 GridViewToExcel(gvlistbrary, DateTime.Now.Ticks + ".xls"); } else { MessageBox.Show(this, "没有数据可导出,请先查询数据!"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Exam.Entity.tb_QuestionClsEntity model = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(tkid); if (model != null) { name = model.Name; IList <Exam.Entity.tb_QuestionClsEntity> list = Exam.BLL.tb_QuestionClsBLL.GetInstance().Gettb_QuestionClsListParentIdTow(model.QuestionClsId); if (list != null && list.Count > 0) { listboxManage.DataSource = list; listboxManage.DataTextField = "name"; listboxManage.DataValueField = "questionclsid"; listboxManage.DataBind(); } } } }
//修改 public void enditquestionmenu(int questionId, string name, int pass, int ismust) { try { Exam.Entity.tb_QuestionClsEntity model = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(questionId); if (model != null) { model.IsMust = ismust; model.Score = pass; model.Name = name; Exam.BLL.tb_QuestionClsBLL.GetInstance().Update(model); Response.Write("1"); } } catch (Exception ex) { Jnwf.Utils.Log.Logger.Log4Net.Error("data.aspx.cs,enditquestionmenu,ex:" + ex.Message + "|" + ex.StackTrace); Response.Write("error"); } }
private void BindData() { try { UserIdentity identity = User.Identity as UserIdentity; if (identity != null) { Exam.Entity.tb_QuestionEntity model = Exam.BLL.tb_QuestionBLL.GetInstance().GetAdminSingle(questionid); model.SchoolId = identity._schoolID; if (model != null) { //在修改题库时隐藏上面的两个按钮 this.divn.Style.Add("display", "none"); this.divnn.Style.Add("display", "none"); hidid.Text = model.Type.ToString(); questionclsid = model.QuestionClsId; Exam.Entity.tb_QuestionClsEntity temp = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(model.QuestionClsId); if (temp != null) { name = temp.Name; } this.ddlFirst.SelectedValue = model.Type.ToString(); this.ddlharder.SelectedValue = model.Isdifficulty.ToString(); this.ddlstatus.SelectedValue = model.Status.ToString(); //试题描述 this.contenms = model.Title.Replace("\"", "':"); //单选 if (int.Parse(this.ddlFirst.SelectedValue) == 1) { this.contenA = model.A.ToString(); this.contenB = model.B.ToString(); this.contenC = model.C.ToString(); this.contenD = model.D.ToString(); this.contenE = model.E.ToString(); this.contenF = model.F.ToString(); this.contenG = model.G.ToString(); this.contenH = model.H.ToString(); if (model.Answer.ToUpper() == "A") { raidaA.Checked = true; } if (model.Answer.ToUpper() == "B") { raidaB.Checked = true; } if (model.Answer.ToUpper() == "C") { raidaC.Checked = true; } if (model.Answer.ToUpper() == "D") { raidaD.Checked = true; } if (model.Answer.ToUpper() == "E") { raidaE.Checked = true; } if (model.Answer.ToUpper() == "F") { raidaF.Checked = true; } if (model.Answer.ToUpper() == "G") { raidaG.Checked = true; } if (model.Answer.ToUpper() == "H") { raidaH.Checked = true; } } //多选 if (int.Parse(this.ddlFirst.SelectedValue) == 2) { this.contenAA = model.A.ToString(); this.contenBB = model.B.ToString(); this.contenCC = model.C.ToString(); this.contenDD = model.D.ToString(); this.contenEE = model.E.ToString(); this.contenFF = model.F.ToString(); this.contenGG = model.G.ToString(); this.contenHH = model.H.ToString(); string str = model.Answer; string[] arr = str.Split(','); foreach (string answer in arr) { if (answer == "A") { ckdA.Checked = true; } if (answer == "B") { ckdB.Checked = true; } if (answer == "C") { ckdC.Checked = true; } if (answer == "D") { ckdD.Checked = true; } if (answer == "E") { ckdE.Checked = true; } if (answer == "F") { ckdF.Checked = true; } if (answer == "G") { ckdG.Checked = true; } if (answer == "H") { ckdH.Checked = true; } } } //判断 if (int.Parse(this.ddlFirst.SelectedValue) == 3) { if (model.Answer.ToUpper() == "1") { raidzq.Checked = true; } if (model.Answer.ToUpper() == "0") { raidcw.Checked = true; } } //填空 if (int.Parse(this.ddlFirst.SelectedValue) == 4) { this.txttk.Text = model.Answer; } //试题解析 this.contenjx = model.Interpretation.Replace("\"", "':"); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (exampaperId > 0) { Exam.Entity.tb_ExampaperEntity model = Exam.BLL.tb_ExampaperBLL.GetInstance().GetAdminSingle(exampaperId); if (model != null) { Exam.Entity.tb_QuestionClsEntity question = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(model.ExampaperClsId); if (question != null) { namek = question.Name; } txthid.Text = model.ExampaperClsId.ToString(); exampaperclsd = model.ExampaperClsId; txthidname.Text = model.Name; ddlstatus.SelectedValue = model.Status.ToString(); ddltype.SelectedIndex = model.Type; txttime.Text = model.Duration.ToString(); txtscore.Text = model.Pass.ToString(); } IList <Exam.Entity.tb_ExampaperExtEntity> list = Exam.BLL.tb_ExampaperExtBLL.GetInstance().GetListByExampaperId(exampaperId); System.Text.StringBuilder strb = new System.Text.StringBuilder(); if (list.Count > 0 && list != null) { int id = 0; foreach (Exam.Entity.tb_ExampaperExtEntity temp in list) { string tempStr2 = "\"num1\":\"" + temp.Number + "\",\"num2\":\"" + temp.Diff + "\""; Exam.Entity.tb_QuestionClsEntity question = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(temp.tb_QuestionClsId); if (temp.Type == 1) { id++; strb.Append("<tr class=\"tr\" id=\"tr" + id + "\">" + "<td ><img src=\"../images/substract.png\" onclick=\"deleteTxt(" + id + ")\" /></td>" + "<td ><input id=\"txttype" + id + "\" type=\"text\" style=\"display:none\" value=\"1\" /><span>单选</span></td>" + "<td ><span id=\"num" + id + "\">" + (temp.Number + temp.Diff) + "</span></td>" + "<td ><input id=\"txttile" + id + "\" Value=\"" + temp.Title + "\" type=\"text\" style=\"width:200px\" /></td><td ><input id=\"txtnum" + id + "\" Value=\"" + temp.Score + "\" type=\"text\" style=\"width:50px\" /></td>" + "<td><a href=\"javascript:selectExam(" + id + ")\" style=\"text-decoration:none\"><span id=\"select" + id + "\">" + question.Name + "</span><img src=\"../images/icon6.gif\" style=\"margin-bottom:2px;margin-left:5px\" /></a><input type=\"text\" style=\"display:none\" value=\"" + temp.tb_QuestionClsId + "\" id=parentid" + id + " /></td>" + "<td><a href=\"javascript:extractNum(1," + id + ")\" style=\"text-decoration:none\">抽取数量</a> <input type=\"text\" style=\"display:none\" value='" + tempStr2 + "' id=hid" + id + " /></td></tr>"); } else if (temp.Type == 2) { id++; strb.Append("<tr class=\"tr\" id=\"tr" + id + "\">" + "<td ><img src=\"../images/substract.png\" onclick=\"deleteTxt(" + id + ")\" /></td>" + "<td ><input id=\"txttype" + id + "\" type=\"text\" style=\"display:none\" value=\"2\" /><span>多选</span></td>" + "<td ><span id=\"num" + id + "\">" + (temp.Number + temp.Diff) + "</span></td>" + "<td ><input id=\"txttile" + id + "\" Value=\"" + temp.Title + "\" type=\"text\" style=\"width:200px\" /></td><td ><input id=\"txtnum" + id + "\" Value=\"" + temp.Score + "\" type=\"text\" style=\"width:50px\" /></td>" + "<td><a href=\"javascript:selectExam(" + id + ")\" style=\"text-decoration:none\"><span id=\"select" + id + "\">" + question.Name + "</span><img src=\"../images/icon6.gif\" style=\"margin-bottom:2px;margin-left:5px\" /></a><input type=\"text\" style=\"display:none\" value=\"" + temp.tb_QuestionClsId + "\" id=parentid" + id + " /></td>" + "<td><a href=\"javascript:extractNum(2," + id + ")\" style=\"text-decoration:none\">抽取数量</a> <input type=\"text\" style=\"display:none\" value='" + tempStr2 + "' id=hid" + id + " /></td></tr>"); } else if (temp.Type == 3) { id++; strb.Append("<tr class=\"tr\" id=\"tr" + id + "\">" + "<td ><img src=\"../images/substract.png\" onclick=\"deleteTxt(" + id + ")\" /></td>" + "<td ><input id=\"txttype" + id + "\" type=\"text\" style=\"display:none\" value=\"3\" /><span>判断</span></td>" + "<td ><span id=\"num" + id + "\">" + (temp.Number + temp.Diff) + "</span></td>" + "<td ><input id=\"txttile" + id + "\" Value=\"" + temp.Title + "\" type=\"text\" style=\"width:200px\" /></td><td ><input id=\"txtnum" + id + "\" Value=\"" + temp.Score + "\" type=\"text\" style=\"width:50px\" /></td>" + "<td><a href=\"javascript:selectExam(" + id + ")\" style=\"text-decoration:none\"><span id=\"select" + id + "\">" + question.Name + "</span><img src=\"../images/icon6.gif\" style=\"margin-bottom:2px;margin-left:5px\" /></a><input type=\"text\" style=\"display:none\" value=\"" + temp.tb_QuestionClsId + "\" id=parentid" + id + " /></td>" + "<td><a href=\"javascript:extractNum(3," + id + ")\" style=\"text-decoration:none\">抽取数量</a> <input type=\"text\" style=\"display:none\" value='" + tempStr2 + "' id=hid" + id + " /></td></tr>"); } else { id++; strb.Append("<tr class=\"tr\" id=\"tr" + id + "\">" + "<td ><img src=\"../images/substract.png\" onclick=\"deleteTxt(" + id + ")\" /></td>" + "<td ><input id=\"txttype" + id + "\" type=\"text\" style=\"display:none\" value=\"4\" /><span>填空</span></td>" + "<td ><span id=\"num" + id + "\">" + (temp.Number + temp.Diff) + "</span></td>" + "<td ><input id=\"txttile" + id + "\" Value=\"" + temp.Title + "\" type=\"text\" style=\"width:200px\" /></td><td ><input id=\"txtnum" + id + "\" Value=\"" + temp.Score + "\" type=\"text\" style=\"width:50px\" /></td>" + "<td><a href=\"javascript:selectExam(" + id + ")\" style=\"text-decoration:none\"><span id=\"select" + id + "\">" + question.Name + "</span><img src=\"../images/icon6.gif\" style=\"margin-bottom:2px;margin-left:5px\" /></a><input type=\"text\" style=\"display:none\" value=\"" + temp.tb_QuestionClsId + "\" id=parentid" + id + " /></td>" + "<td><a href=\"javascript:extractNum(4," + id + ")\" style=\"text-decoration:none\">抽取数量</a> <input type=\"text\" style=\"display:none\" value='" + tempStr2 + "' id=hid" + id + " /></td></tr>"); } } tempstr = strb.ToString(); } Exam.Entity.tb_QuestionClsEntity tempQuestion = Exam.BLL.tb_QuestionClsBLL.GetInstance().GetAdminSingle(exampaperclsd); if (tempQuestion != null) { namek = tempQuestion.Name; } } } }