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