public void IsTestQuestion(string ContentText, string TargetText, string ComplexityText, string Two_WayChecklistDetail_Id) { try { string TestPaper_Frame_Id = string.Empty; Model_Two_WayChecklist model = new BLL_Two_WayChecklist().GetModel(Two_WayChecklist_Id); if (model != null) { TestPaper_Frame_Id = model.ParentId; } //所有试题对应知识点,测量目标,难易度 string sql = @" select distinct tq.TestQuestions_Id,tqs.ContentText,tqs.TargetText,tqs.ComplexityText,tf.TestPaper_FrameDetail_Id from TestQuestions tq left join TestQuestions_Score tqs on tqs.TestQuestions_Id=tq.TestQuestions_Id inner join TestPaper_FrameDetailToTestQuestions tf on tf.TestQuestions_Id=tq.TestQuestions_Id where tq.[type]='simple' and tf.TestPaper_Frame_Id='" + TestPaper_Frame_Id + @"' union select distinct tq.TestQuestions_Id,tqs.ContentText,tqs.TargetText,tqs.ComplexityText,tf.TestPaper_FrameDetail_Id from TestQuestions tq2 inner join TestPaper_FrameDetailToTestQuestions tf on tf.TestQuestions_Id=tq2.TestQuestions_Id inner join TestQuestions tq on tq.Parent_Id<>'0' and tq.[type]='complex' and tq.Parent_Id=tq2.TestQuestions_Id inner join TestQuestions_Score tqs on tqs.TestQuestions_Id=tq.TestQuestions_Id where tq2.Parent_Id='0' and tq2.[type]='complex' and tf.TestPaper_Frame_Id='" + TestPaper_Frame_Id + "'"; DataTable dtTestQuestion = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0]; if (dtTestQuestion.Rows.Count > 0) { } } catch (Exception ex) { } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(Two_WayChecklist_Id)) { Model_Two_WayChecklist model = new Model_Two_WayChecklist(); BLL_Two_WayChecklist bll = new BLL_Two_WayChecklist(); model = bll.GetModel(Two_WayChecklist_Id); model.ParticularYear = Convert.ToInt32(ddlYear.SelectedValue); model.GradeTerm = ddlGradeTerm.SelectedValue; model.Resource_Version = ddlResource_Version.SelectedValue; model.Subject = ddlSubject.SelectedValue; model.Two_WayChecklist_Name = txtTwo_WayChecklist_Name.Text.TrimEnd(); model.Remark = txtRemark.Text.TrimEnd(); if (bll.Update(model)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index)});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败!',{ time: 2000,icon:2});</script>"); return; } } else { Model_Two_WayChecklist model = new Model_Two_WayChecklist(); BLL_Two_WayChecklist bll = new BLL_Two_WayChecklist(); model.Two_WayChecklist_Id = Guid.NewGuid().ToString(); model.ParticularYear = Convert.ToInt32(ddlYear.SelectedValue); model.GradeTerm = ddlGradeTerm.SelectedValue; model.Resource_Version = ddlResource_Version.SelectedValue; model.Subject = ddlSubject.SelectedValue; model.Two_WayChecklist_Name = txtTwo_WayChecklist_Name.Text.TrimEnd(); model.Remark = txtRemark.Text.TrimEnd(); model.CreateUser = loginUser.SysUser_ID; model.CreateTime = DateTime.Now; if (bll.Add(model)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index)});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败!',{ time: 2000,icon:2});</script>"); return; } } } catch (Exception ex) { throw; } }
public void LoadData() { try { Model_Two_WayChecklist model = new Model_Two_WayChecklist(); BLL_Two_WayChecklist bll = new BLL_Two_WayChecklist(); model = bll.GetModel(Two_WayChecklist_Id); if (model != null) { ddlYear.SelectedValue = model.ParticularYear.ToString(); ddlGradeTerm.SelectedValue = model.GradeTerm; ddlResource_Version.SelectedValue = model.Resource_Version; ddlSubject.SelectedValue = model.Subject; txtRemark.Text = model.Remark; txtTwo_WayChecklist_Name.Text = model.Two_WayChecklist_Name; } } catch (Exception ex) { } }