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