public static giaothuongHam Update(giaothuongHam Updated) { giaothuongHam Item = new giaothuongHam(); SqlParameter[] obj = new SqlParameter[17]; obj[0] = new SqlParameter("giaothuongHamID", Updated.giaothuongHamID); obj[1] = new SqlParameter("tieude", Updated.tieude); obj[2] = new SqlParameter("tieudeen", Updated.tieudeen); obj[3] = new SqlParameter("mota", Updated.mota); obj[4] = new SqlParameter("motaen", Updated.motaen); obj[5] = new SqlParameter("chitiet", Updated.chitiet); obj[6] = new SqlParameter("chitieten", Updated.chitieten); obj[7] = new SqlParameter("hinhanh", Updated.hinhanh); obj[8] = new SqlParameter("hinhanhlon", Updated.hinhanhlon); obj[9] = new SqlParameter("xuatxu", Updated.xuatxu); obj[10] = new SqlParameter("ngayhethan", Updated.ngayhethan); obj[11] = new SqlParameter("ngaydang", Updated.ngaydang); obj[12] = new SqlParameter("doanhnghiepID", Updated.doanhnghiepID); obj[13] = new SqlParameter("nhomID", Updated.nhomID); obj[14] = new SqlParameter("trangthai", Updated.trangthai); obj[15] = new SqlParameter("loaigiaothuongHamID", Updated.loaigiaothuongHamID); obj[16] = new SqlParameter("nhomconID", Updated.nhomconID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_giaothuongHam_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static giaothuongHam SelectById(Guid giaothuongHamID) { giaothuongHam Item = new giaothuongHam(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("giaothuongHamID", giaothuongHamID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_giaothuongHam_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static giaothuongHam getFromReader(IDataReader rd) { giaothuongHam Item = new giaothuongHam(); if (rd.FieldExists("giaothuongHamID")) { Item.giaothuongHamID = (Guid)(rd["giaothuongHamID"]); } if (rd.FieldExists("tieude")) { Item.tieude = (String)(rd["tieude"]); } if (rd.FieldExists("tieudeen")) { Item.tieudeen = (String)(rd["tieudeen"]); } if (rd.FieldExists("mota")) { Item.mota = (String)(rd["mota"]); } if (rd.FieldExists("motaen")) { Item.motaen = (String)(rd["motaen"]); } if (rd.FieldExists("chitiet")) { Item.chitiet = (String)(rd["chitiet"]); } if (rd.FieldExists("chitieten")) { Item.chitieten = (String)(rd["chitieten"]); } if (rd.FieldExists("hinhanh")) { Item.hinhanh = (String)(rd["hinhanh"]); } if (rd.FieldExists("hinhanhlon")) { Item.hinhanhlon = (String)(rd["hinhanhlon"]); } if (rd.FieldExists("xuatxu")) { Item.xuatxu = (String)(rd["xuatxu"]); } if (rd.FieldExists("ngayhethan")) { Item.ngayhethan = (DateTime)(rd["ngayhethan"]); } if (rd.FieldExists("ngaydang")) { Item.ngaydang = (DateTime)(rd["ngaydang"]); } if (rd.FieldExists("doanhnghiepID")) { Item.doanhnghiepID = (String)(rd["doanhnghiepID"]); } if (rd.FieldExists("nhomID")) { Item.nhomID = (String)(rd["nhomID"]); } if (rd.FieldExists("trangthai")) { Item.trangthai = (Int32)(rd["trangthai"]); } if (rd.FieldExists("loaigiaothuongHamID")) { Item.loaigiaothuongHamID = (Int16)(rd["loaigiaothuongHamID"]); } if (rd.FieldExists("nhomconID")) { Item.nhomconID = (String)(rd["nhomconID"]); } return(Item); }