public static TuVanTinhTrang getFromReader(IDataReader rd) { var Item = new TuVanTinhTrang(); if (rd.FieldExists("TTDV_ID")) { Item.ID = (Guid)(rd["TTDV_ID"]); } if (rd.FieldExists("TTDV_TV_ID")) { Item.TV_ID = (Guid)(rd["TTDV_TV_ID"]); } if (rd.FieldExists("TTDV_TT_ID")) { Item.TT_ID = (Guid)(rd["TTDV_TT_ID"]); } if (rd.FieldExists("TTDV_ThuTu")) { Item.ThuTu = (Int32)(rd["TTDV_ThuTu"]); } if (rd.FieldExists("TTDV_NgayTao")) { Item.NgayTao = (DateTime)(rd["TTDV_NgayTao"]); } Item._DanhMuc = DanhMucDal.getFromReader(rd); return(Item); }
public static TuVanTinhTrang Update(TuVanTinhTrang item) { var Item = new TuVanTinhTrang(); var obj = new SqlParameter[5]; obj[0] = new SqlParameter("TTDV_ID", item.ID); obj[1] = new SqlParameter("TTDV_TV_ID", item.TV_ID); obj[2] = new SqlParameter("TTDV_TT_ID", item.TT_ID); obj[3] = new SqlParameter("TTDV_ThuTu", item.ThuTu); if (item.NgayTao > DateTime.MinValue) { obj[4] = new SqlParameter("TTDV_NgayTao", item.NgayTao); } else { obj[4] = new SqlParameter("TTDV_NgayTao", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanTinhTrang_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static TuVanTinhTrang SelectById(Guid TTDV_ID) { var Item = new TuVanTinhTrang(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("TTDV_ID", TTDV_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TuVanTinhTrang_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }