public bool Add(Model_Two_WayChecklistDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Two_WayChecklistDetail(");
builder.Append("Two_WayChecklistDetail_Id,Two_WayChecklist_Id,ParentId,TestQuestions_Num,TestQuestions_NumStr,TestQuestions_Type,TargetText,ComplexityText,KnowledgePoint,Score,Remark,Two_WayChecklistType,CreateUser,CreateTime,TestPaper_FrameDetail_Id)");
builder.Append(" values (");
builder.Append("@Two_WayChecklistDetail_Id,@Two_WayChecklist_Id,@ParentId,@TestQuestions_Num,@TestQuestions_NumStr,@TestQuestions_Type,@TargetText,@ComplexityText,@KnowledgePoint,@Score,@Remark,@Two_WayChecklistType,@CreateUser,@CreateTime,@TestPaper_FrameDetail_Id)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Two_WayChecklistDetail_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ParentId", SqlDbType.Char, 0x24), new SqlParameter("@TestQuestions_Num", SqlDbType.Int, 4), new SqlParameter("@TestQuestions_NumStr", SqlDbType.VarChar, 500), new SqlParameter("@TestQuestions_Type", SqlDbType.NVarChar, 50), new SqlParameter("@TargetText", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@ComplexityText", SqlDbType.NVarChar, 50), new SqlParameter("@KnowledgePoint", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@Score", SqlDbType.Decimal, 5), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@Two_WayChecklistType", SqlDbType.NVarChar, 50), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@TestPaper_FrameDetail_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.Two_WayChecklistDetail_Id;
cmdParms[1].Value = model.Two_WayChecklist_Id;
cmdParms[2].Value = model.ParentId;
cmdParms[3].Value = model.TestQuestions_Num;
cmdParms[4].Value = model.TestQuestions_NumStr;
cmdParms[5].Value = model.TestQuestions_Type;
cmdParms[6].Value = model.TargetText;
cmdParms[7].Value = model.ComplexityText;
cmdParms[8].Value = model.KnowledgePoint;
cmdParms[9].Value = model.Score;
cmdParms[10].Value = model.Remark;
cmdParms[11].Value = model.Two_WayChecklistType;
cmdParms[12].Value = model.CreateUser;
cmdParms[13].Value = model.CreateTime;
cmdParms[14].Value = model.TestPaper_FrameDetail_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (new BLL_Two_WayChecklistToTestpaper().GetRecordCount("Two_WayChecklist_Id='" + Two_WayChecklist_Id + "'") > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败,此双向细目表已关联试卷无法操作。',{ time: 2000,icon:2});</script>");
return;
}
if (!string.IsNullOrEmpty(Two_WayChecklistDetail_Id))
{
Model_Two_WayChecklistDetail model = new BLL_Two_WayChecklistDetail().GetModel(Two_WayChecklistDetail_Id);
if (model != null)
{
//model.Remark = txtRemark.Text.TrimEnd();
model.TestQuestions_NumStr = txtBigNum.Text.TrimEnd();
model.TestQuestions_Num = Convert.ToInt32(txtSort.Text.TrimEnd());
//model.TestQuestions_Type = ddlTestQuestions_Type.SelectedValue;
if (new BLL_Two_WayChecklistDetail().Update(model))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData('" + Two_WayChecklist_Id + "');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_WayChecklistDetail model = new Model_Two_WayChecklistDetail();
model.Two_WayChecklistDetail_Id = Guid.NewGuid().ToString();
model.Two_WayChecklist_Id = Two_WayChecklist_Id;
//model.Remark = txtRemark.Text.TrimEnd();
model.TestQuestions_NumStr = txtBigNum.Text.TrimEnd();
model.TestQuestions_Num = Convert.ToInt32(txtSort.Text.TrimEnd());
model.ParentId = "0";
model.CreateUser = FloginUser.UserId;
model.CreateTime = DateTime.Now;
//model.TestQuestions_Type = ddlTestQuestions_Type.SelectedValue;
if (new BLL_Two_WayChecklistDetail().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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Two_WayChecklistDetail_Id = Request["Two_WayChecklistDetail_Id"].Filter();
Two_WayChecklist_Id = Request["Two_WayChecklist_Id"].Filter();
type = Request["type"].Filter();
if (!IsPostBack)
{
//InitInfo();
Model_Two_WayChecklistDetail model = new Model_Two_WayChecklistDetail();
model = new BLL_Two_WayChecklistDetail().GetModel(Two_WayChecklistDetail_Id);
///ddlTestQuestions_Type.Enabled = false;
LoadData();
}
}
public List <Model_Two_WayChecklistDetail> DataTableToList(DataTable dt)
{
List <Model_Two_WayChecklistDetail> list = new List <Model_Two_WayChecklistDetail>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_Two_WayChecklistDetail item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Update(Model_Two_WayChecklistDetail model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Two_WayChecklistDetail set ");
builder.Append("Two_WayChecklist_Id=@Two_WayChecklist_Id,");
builder.Append("ParentId=@ParentId,");
builder.Append("TestQuestions_Num=@TestQuestions_Num,");
builder.Append("TestQuestions_NumStr=@TestQuestions_NumStr,");
builder.Append("TestQuestions_Type=@TestQuestions_Type,");
builder.Append("TargetText=@TargetText,");
builder.Append("ComplexityText=@ComplexityText,");
builder.Append("KnowledgePoint=@KnowledgePoint,");
builder.Append("Score=@Score,");
builder.Append("Remark=@Remark,");
builder.Append("Two_WayChecklistType=@Two_WayChecklistType,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("TestPaper_FrameDetail_Id=@TestPaper_FrameDetail_Id");
builder.Append(" where Two_WayChecklistDetail_Id=@Two_WayChecklistDetail_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ParentId", SqlDbType.Char, 0x24), new SqlParameter("@TestQuestions_Num", SqlDbType.Int, 4), new SqlParameter("@TestQuestions_NumStr", SqlDbType.VarChar, 500), new SqlParameter("@TestQuestions_Type", SqlDbType.NVarChar, 50), new SqlParameter("@TargetText", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@ComplexityText", SqlDbType.NVarChar, 50), new SqlParameter("@KnowledgePoint", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@Score", SqlDbType.Decimal, 5), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@Two_WayChecklistType", SqlDbType.NVarChar, 50), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@TestPaper_FrameDetail_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklistDetail_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.Two_WayChecklist_Id;
cmdParms[1].Value = model.ParentId;
cmdParms[2].Value = model.TestQuestions_Num;
cmdParms[3].Value = model.TestQuestions_NumStr;
cmdParms[4].Value = model.TestQuestions_Type;
cmdParms[5].Value = model.TargetText;
cmdParms[6].Value = model.ComplexityText;
cmdParms[7].Value = model.KnowledgePoint;
cmdParms[8].Value = model.Score;
cmdParms[9].Value = model.Remark;
cmdParms[10].Value = model.Two_WayChecklistType;
cmdParms[11].Value = model.CreateUser;
cmdParms[12].Value = model.CreateTime;
cmdParms[13].Value = model.TestPaper_FrameDetail_Id;
cmdParms[14].Value = model.Two_WayChecklistDetail_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_Two_WayChecklistDetail model)
{
return(this.dal.Add(model));
}
public bool Update(Model_Two_WayChecklistDetail model)
{
return(this.dal.Update(model));
}
public Model_Two_WayChecklistDetail DataRowToModel(DataRow row)
{
Model_Two_WayChecklistDetail detail = new Model_Two_WayChecklistDetail();
if (row != null)
{
if (row["Two_WayChecklistDetail_Id"] != null)
{
detail.Two_WayChecklistDetail_Id = row["Two_WayChecklistDetail_Id"].ToString();
}
if (row["Two_WayChecklist_Id"] != null)
{
detail.Two_WayChecklist_Id = row["Two_WayChecklist_Id"].ToString();
}
if (row["ParentId"] != null)
{
detail.ParentId = row["ParentId"].ToString();
}
if ((row["TestQuestions_Num"] != null) && (row["TestQuestions_Num"].ToString() != ""))
{
detail.TestQuestions_Num = new int?(int.Parse(row["TestQuestions_Num"].ToString()));
}
if (row["TestQuestions_NumStr"] != null)
{
detail.TestQuestions_NumStr = row["TestQuestions_NumStr"].ToString();
}
if (row["TestQuestions_Type"] != null)
{
detail.TestQuestions_Type = row["TestQuestions_Type"].ToString();
}
if (row["TargetText"] != null)
{
detail.TargetText = row["TargetText"].ToString();
}
if (row["ComplexityText"] != null)
{
detail.ComplexityText = row["ComplexityText"].ToString();
}
if (row["KnowledgePoint"] != null)
{
detail.KnowledgePoint = row["KnowledgePoint"].ToString();
}
if ((row["Score"] != null) && (row["Score"].ToString() != ""))
{
detail.Score = new decimal?(decimal.Parse(row["Score"].ToString()));
}
if (row["Remark"] != null)
{
detail.Remark = row["Remark"].ToString();
}
if (row["Two_WayChecklistType"] != null)
{
detail.Two_WayChecklistType = row["Two_WayChecklistType"].ToString();
}
if (row["CreateUser"] != null)
{
detail.CreateUser = row["CreateUser"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
detail.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["TestPaper_FrameDetail_Id"] != null)
{
detail.TestPaper_FrameDetail_Id = row["TestPaper_FrameDetail_Id"].ToString();
}
}
return(detail);
}
