public Model_HW_TestPaper DataRowToModel(DataRow row)
{
Model_HW_TestPaper paper = new Model_HW_TestPaper();
if (row != null)
{
if (row["HW_TestPaper_Id"] != null)
{
paper.HW_TestPaper_Id = row["HW_TestPaper_Id"].ToString();
}
if (row["TestPaper_Path"] != null)
{
paper.TestPaper_Path = row["TestPaper_Path"].ToString();
}
if (row["TestPaper_Status"] != null)
{
paper.TestPaper_Status = row["TestPaper_Status"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
paper.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
return(paper);
}
public bool Add(Model_HW_TestPaper model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into HW_TestPaper(");
builder.Append("HW_TestPaper_Id,TestPaper_Path,TestPaper_Status,CreateTime)");
builder.Append(" values (");
builder.Append("@HW_TestPaper_Id,@TestPaper_Path,@TestPaper_Status,@CreateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@HW_TestPaper_Id", SqlDbType.Char, 0x24), new SqlParameter("@TestPaper_Path", SqlDbType.VarChar, 500), new SqlParameter("@TestPaper_Status", SqlDbType.Char, 1), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.HW_TestPaper_Id;
cmdParms[1].Value = model.TestPaper_Path;
cmdParms[2].Value = model.TestPaper_Status;
cmdParms[3].Value = model.CreateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(Model_HW_TestPaper model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update HW_TestPaper set ");
builder.Append("TestPaper_Path=@TestPaper_Path,");
builder.Append("TestPaper_Status=@TestPaper_Status,");
builder.Append("CreateTime=@CreateTime");
builder.Append(" where HW_TestPaper_Id=@HW_TestPaper_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@TestPaper_Path", SqlDbType.VarChar, 500), new SqlParameter("@TestPaper_Status", SqlDbType.Char, 1), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@HW_TestPaper_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.TestPaper_Path;
cmdParms[1].Value = model.TestPaper_Status;
cmdParms[2].Value = model.CreateTime;
cmdParms[3].Value = model.HW_TestPaper_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public List <Model_HW_TestPaper> DataTableToList(DataTable dt)
{
List <Model_HW_TestPaper> list = new List <Model_HW_TestPaper>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_HW_TestPaper item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_HW_TestPaper model)
{
return(this.dal.Add(model));
}
public bool Update(Model_HW_TestPaper model)
{
return(this.dal.Update(model));
}
