public static TinhTrangDichVu SelectById(Guid TTDV_ID) { var Item = new TinhTrangDichVu(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("TTDV_ID", TTDV_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TinhTrangDichVu_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static TinhTrangDichVu Insert(TinhTrangDichVu item) { var Item = new TinhTrangDichVu(); var obj = new SqlParameter[12]; obj[0] = new SqlParameter("TTDV_ID", item.ID); obj[1] = new SqlParameter("TTDV_DM_ID", item.DM_ID); obj[2] = new SqlParameter("TTDV_DM_Ten", item.DM_Ten); obj[3] = new SqlParameter("TTDV_DV_ID", item.DV_ID); obj[4] = new SqlParameter("TTDV_DV_Ten", item.DV_Ten); obj[5] = new SqlParameter("TTDV_SoLuong", item.SoLuong); obj[6] = new SqlParameter("TTDV_ThuTu", item.ThuTu); obj[7] = new SqlParameter("TTDV_MoTa", item.MoTa); if (item.NgayTao > DateTime.MinValue) { obj[8] = new SqlParameter("TTDV_NgayTao", item.NgayTao); } else { obj[8] = new SqlParameter("TTDV_NgayTao", DBNull.Value); } obj[9] = new SqlParameter("TTDV_NguoiTao", item.NguoiTao); if (item.NgayCapNhat > DateTime.MinValue) { obj[10] = new SqlParameter("TTDV_NgayCapNhat", item.NgayCapNhat); } else { obj[10] = new SqlParameter("TTDV_NgayCapNhat", DBNull.Value); } obj[11] = new SqlParameter("TTDV_NguoiCapNhat", item.NguoiCapNhat); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_TinhTrangDichVu_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static TinhTrangDichVu getFromReader(IDataReader rd) { var Item = new TinhTrangDichVu(); if (rd.FieldExists("TTDV_ID")) { Item.ID = (Guid)(rd["TTDV_ID"]); } if (rd.FieldExists("TTDV_DM_ID")) { Item.DM_ID = (Guid)(rd["TTDV_DM_ID"]); } if (rd.FieldExists("TTDV_DM_Ten")) { Item.DM_Ten = (String)(rd["TTDV_DM_Ten"]); } if (rd.FieldExists("TTDV_DV_ID")) { Item.DV_ID = (Guid)(rd["TTDV_DV_ID"]); } if (rd.FieldExists("TTDV_DV_Ten")) { Item.DV_Ten = (String)(rd["TTDV_DV_Ten"]); } if (rd.FieldExists("TTDV_SoLuong")) { Item.SoLuong = (Int32)(rd["TTDV_SoLuong"]); } if (rd.FieldExists("TTDV_ThuTu")) { Item.ThuTu = (Int32)(rd["TTDV_ThuTu"]); } if (rd.FieldExists("TTDV_MoTa")) { Item.MoTa = (String)(rd["TTDV_MoTa"]); } if (rd.FieldExists("TTDV_NgayTao")) { Item.NgayTao = (DateTime)(rd["TTDV_NgayTao"]); } if (rd.FieldExists("TTDV_NguoiTao")) { Item.NguoiTao = (String)(rd["TTDV_NguoiTao"]); } if (rd.FieldExists("TTDV_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["TTDV_NgayCapNhat"]); } if (rd.FieldExists("TTDV_NguoiCapNhat")) { Item.NguoiCapNhat = (String)(rd["TTDV_NguoiCapNhat"]); } if (rd.FieldExists("DV_ThoiGian")) { Item.ThoiGian = (Int32)(rd["DV_ThoiGian"]); } if (rd.FieldExists("DV_Gia")) { Item.Gia = (Int32)(rd["DV_Gia"]); } Item.dvu = DichVuDal.getFromReader(rd); return(Item); }