public List<SupplierPaymentReport> GetSupplierPaymentReportBetweenDate(DateTime fromdate, DateTime todate) { List<SupplierPaymentReport> aPaymentReports=new List<SupplierPaymentReport>(); try { this.OpenConnection(); string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetSupplierPaymentReportBetweenDate),fromdate,todate); IDataReader aReader = this.ExecuteReader(sqlComm); if(aReader!=null) { while(aReader.Read()) { SupplierPaymentReport aReport=new SupplierPaymentReport(); aReport = ReaderToReadSupplierPaymentReport(aReader); aPaymentReports.Add(aReport); } } } catch (Exception ex) { throw new Exception("GetSupplierPaymentReportBetweenDate()",ex); } finally { CloseConnection(); } return aPaymentReports; }
//"select a.supplier_payment_id, a.total_amount, a.paid_amount, a.paid_type, //a.date, a.user_name ,b.supplier_name from supplier_payment_report a, //supplier b where a.supplier_id=b.supplier_id and a.date>='{0}' and a.date<='{1}'"; private SupplierPaymentReport ReaderToReadSupplierPaymentReport(IDataReader aReader) { SupplierPaymentReport aReport = new SupplierPaymentReport(); try { aReport.SupplierPaymentReportId = Convert.ToInt32(aReader["supplier_payment_id"]); } catch { } try { aReport.TotalAmount = Convert.ToDouble(aReader["total_amount"]); } catch { } try { aReport.PaidAmount = Convert.ToDouble(aReader["paid_amount"]); } catch { } try { aReport.PaymentType = (aReader["paid_type"]).ToString(); } catch { } try { aReport.UserName= (aReader["user_name"]).ToString(); } catch { } try { aReport.SupplierName = (aReader["supplier_name"]).ToString(); } catch { } try { aReport.PaymentDate=Convert.ToDateTime(aReader["date"]); } catch { } return aReport; }