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)
{
}
}
