public Model_Two_WayChecklistToTestpaper DataRowToModel(DataRow row)
{
Model_Two_WayChecklistToTestpaper testpaper = new Model_Two_WayChecklistToTestpaper();
if (row != null)
{
if (row["Two_WayChecklistToTestpaper_Id"] != null)
{
testpaper.Two_WayChecklistToTestpaper_Id = row["Two_WayChecklistToTestpaper_Id"].ToString();
}
if (row["Two_WayChecklist_Id"] != null)
{
testpaper.Two_WayChecklist_Id = row["Two_WayChecklist_Id"].ToString();
}
if (row["ResourceToResourceFolder_Id"] != null)
{
testpaper.ResourceToResourceFolder_Id = row["ResourceToResourceFolder_Id"].ToString();
}
if (row["CreateUser"] != null)
{
testpaper.CreateUser = row["CreateUser"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
testpaper.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
return(testpaper);
}
public bool Add(Model_Two_WayChecklistToTestpaper model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Two_WayChecklistToTestpaper(");
builder.Append("Two_WayChecklistToTestpaper_Id,Two_WayChecklist_Id,ResourceToResourceFolder_Id,CreateUser,CreateTime)");
builder.Append(" values (");
builder.Append("@Two_WayChecklistToTestpaper_Id,@Two_WayChecklist_Id,@ResourceToResourceFolder_Id,@CreateUser,@CreateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Two_WayChecklistToTestpaper_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.Two_WayChecklistToTestpaper_Id;
cmdParms[1].Value = model.Two_WayChecklist_Id;
cmdParms[2].Value = model.ResourceToResourceFolder_Id;
cmdParms[3].Value = model.CreateUser;
cmdParms[4].Value = model.CreateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int AddRelationPaper(Model_Two_WayChecklistToTestpaper model, List <Model_Two_WayChecklistDetailToTestQuestions> listModel)
{
Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>();
StringBuilder builder = new StringBuilder();
builder = new StringBuilder();
builder.Append("insert into Two_WayChecklistToTestpaper(");
builder.Append("Two_WayChecklistToTestpaper_Id,Two_WayChecklist_Id,ResourceToResourceFolder_Id,CreateUser,CreateTime)");
builder.Append(" values (");
builder.Append("@Two_WayChecklistToTestpaper_Id,@Two_WayChecklist_Id,@ResourceToResourceFolder_Id,@CreateUser,@CreateTime)");
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@Two_WayChecklistToTestpaper_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
parameterArray[0].Value = model.Two_WayChecklistToTestpaper_Id;
parameterArray[1].Value = model.Two_WayChecklist_Id;
parameterArray[2].Value = model.ResourceToResourceFolder_Id;
parameterArray[3].Value = model.CreateUser;
parameterArray[4].Value = model.CreateTime;
dictionary.Add(builder.ToString(), parameterArray);
int num = 0;
foreach (Model_Two_WayChecklistDetailToTestQuestions questions in listModel)
{
num++;
builder = new StringBuilder();
builder.AppendFormat("select {0}; ", num);
builder.Append("insert into Two_WayChecklistDetailToTestQuestions(");
builder.Append("Two_WayChecklistDetailToTestQuestions_Id,Two_WayChecklist_Id,Two_WayChecklistDetail_Id,ResourceToResourceFolder_Id,TestQuestions_Id,CreateUser,CreateTime)");
builder.Append(" values (");
builder.Append("@Two_WayChecklistDetailToTestQuestions_Id,@Two_WayChecklist_Id,@Two_WayChecklistDetail_Id,@ResourceToResourceFolder_Id,@TestQuestions_Id,@CreateUser,@CreateTime)");
SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@Two_WayChecklistDetailToTestQuestions_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@Two_WayChecklistDetail_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@TestQuestions_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
parameterArray2[0].Value = questions.Two_WayChecklistDetailToTestQuestions_Id;
parameterArray2[1].Value = questions.Two_WayChecklist_Id;
parameterArray2[2].Value = questions.Two_WayChecklistDetail_Id;
parameterArray2[3].Value = questions.ResourceToResourceFolder_Id;
parameterArray2[4].Value = questions.TestQuestions_Id;
parameterArray2[5].Value = questions.CreateUser;
parameterArray2[6].Value = questions.CreateTime;
dictionary.Add(builder.ToString(), parameterArray2);
}
int num2 = DbHelperSQL.ExecuteSqlTran(dictionary);
if (num2 > 0)
{
return(num2);
}
return(0);
}
public List <Model_Two_WayChecklistToTestpaper> DataTableToList(DataTable dt)
{
List <Model_Two_WayChecklistToTestpaper> list = new List <Model_Two_WayChecklistToTestpaper>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_Two_WayChecklistToTestpaper item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Update(Model_Two_WayChecklistToTestpaper model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Two_WayChecklistToTestpaper set ");
builder.Append("Two_WayChecklist_Id=@Two_WayChecklist_Id,");
builder.Append("ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("CreateTime=@CreateTime");
builder.Append(" where Two_WayChecklistToTestpaper_Id=@Two_WayChecklistToTestpaper_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Two_WayChecklist_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Two_WayChecklistToTestpaper_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.Two_WayChecklist_Id;
cmdParms[1].Value = model.ResourceToResourceFolder_Id;
cmdParms[2].Value = model.CreateUser;
cmdParms[3].Value = model.CreateTime;
cmdParms[4].Value = model.Two_WayChecklistToTestpaper_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int AddRelationPaper(Model_Two_WayChecklistToTestpaper model, List <Model_Two_WayChecklistDetailToTestQuestions> listModel)
{
return(this.dal.AddRelationPaper(model, listModel));
}
public bool Add(Model_Two_WayChecklistToTestpaper model)
{
return(this.dal.Add(model));
}
public bool Update(Model_Two_WayChecklistToTestpaper model)
{
return(this.dal.Update(model));
}
