public static ThuChiReport Update(ThuChiReport item) { var Item = new ThuChiReport(); var obj = new SqlParameter[19]; obj[0] = new SqlParameter("TC_ma", item.ma); obj[1] = new SqlParameter("TC_sophieu", item.sophieu); obj[2] = new SqlParameter("TC_diengiai", item.diengiai); obj[3] = new SqlParameter("TC_thu_tk", item.thu_tk); obj[4] = new SqlParameter("TC_thu_tm", item.thu_tm); obj[5] = new SqlParameter("TC_thu_t", item.thu_t); obj[6] = new SqlParameter("TC_chi_tk", item.chi_tk); obj[7] = new SqlParameter("TC_chi_tm", item.chi_tm); obj[8] = new SqlParameter("TC_chi_t", item.chi_t); obj[9] = new SqlParameter("TC_tt_tk", item.tt_tk); obj[10] = new SqlParameter("TC_tt_tm", item.tt_tm); obj[11] = new SqlParameter("TC_tt_t", item.tt_t); obj[12] = new SqlParameter("TC_sodu_tk", item.sodu_tk); obj[13] = new SqlParameter("TC_sodu_tm", item.sodu_tm); obj[14] = new SqlParameter("TC_sodu_t", item.sodu_t); obj[15] = new SqlParameter("TC_loaiquy", item.loaiquy); obj[16] = new SqlParameter("TC_isthu", item.isthu); obj[17] = new SqlParameter("TC_isCandoi", item.isCandoi); obj[18] = new SqlParameter("TC_ngay", item.ngay); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblThuChiReport_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static ThuChiReport SelectById(Guid TC_ma) { var Item = new ThuChiReport(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("TC_ma", TC_ma); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblThuChiReport_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static ThuChiReport getFromReader(IDataReader rd) { var Item = new ThuChiReport(); if (rd.FieldExists("ma")) { Item.ma = (Guid)(rd["ma"]); } if (rd.FieldExists("sophieu")) { Item.sophieu = (String)(rd["sophieu"]); } if (rd.FieldExists("diengiai")) { Item.diengiai = (String)(rd["diengiai"]); } if (rd.FieldExists("thu_tk")) { Item.thu_tk = (Double)(rd["thu_tk"]); } if (rd.FieldExists("thu_tm")) { Item.thu_tm = (Double)(rd["thu_tm"]); } if (rd.FieldExists("thu_t")) { Item.thu_t = (Double)(rd["thu_t"]); } if (rd.FieldExists("chi_tk")) { Item.chi_tk = (Double)(rd["chi_tk"]); } if (rd.FieldExists("chi_tm")) { Item.chi_tm = (Double)(rd["chi_tm"]); } if (rd.FieldExists("chi_t")) { Item.chi_t = (Double)(rd["chi_t"]); } if (rd.FieldExists("tt_tk")) { Item.tt_tk = (Double)(rd["tt_tk"]); } if (rd.FieldExists("tt_tm")) { Item.tt_tm = (Double)(rd["tt_tm"]); } if (rd.FieldExists("tt_t")) { Item.tt_t = (Double)(rd["tt_t"]); } if (rd.FieldExists("sodu_tk")) { Item.sodu_tk = (Double)(rd["sodu_tk"]); } if (rd.FieldExists("sodu_tm")) { Item.sodu_tm = (Double)(rd["sodu_tm"]); } if (rd.FieldExists("sodu_t")) { Item.sodu_t = (Double)(rd["sodu_t"]); } if (rd.FieldExists("loaiquy")) { Item.loaiquy = (Int32)(rd["loaiquy"]); } if (rd.FieldExists("isthu")) { Item.isthu = (Boolean)(rd["isthu"]); } if (rd.FieldExists("isCandoi")) { Item.isCandoi = (Boolean)(rd["isCandoi"]); } if (rd.FieldExists("ngay")) { Item.ngay = (String)(rd["ngay"]); } if (rd.FieldExists("NguoiTao_Ten")) { Item.NguoiTao = (String)(rd["NguoiTao_Ten"]); } if (rd.FieldExists("NDTC_Ten")) { Item.NDTC_Ten = (String)(rd["NDTC_Ten"]); } Item._ThuChi = ThuChiDal.getFromReader(rd); return(Item); }