public static ThuChiReportCollection SelectTuNgayDenNgay(string TuNgay, string DenNgay) { var List = new ThuChiReportCollection(); var obj = new SqlParameter[2]; if (!string.IsNullOrEmpty(DenNgay)) { obj[0] = new SqlParameter("DenNgay", DenNgay); } else { obj[0] = new SqlParameter("DenNgay", DBNull.Value); } if (!string.IsNullOrEmpty(TuNgay)) { obj[1] = new SqlParameter("TuNgay", TuNgay); } else { obj[1] = new SqlParameter("TuNgay", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_rpt_ThuChiTuNgayDenNgay", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static ThuChiReportCollection SelectAll() { var List = new ThuChiReportCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblThuChiReport_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }