private void FillTPihutang(string PiHutangStatus, string likeValue, DateTime DateFrom, DateTime DateTo) { if (string.IsNullOrEmpty(likeValue)) { likeValue = "%%"; } IList listPiHutang = DataMaster.GetListBetweenEqLikeValue(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangDate, DateFrom, DateTo, TPiHutang.ColumnNames.PiHutangStatus, PiHutangStatus, TPiHutang.ColumnNames.PiHutangPic, likeValue); bs = new BindingSource(); bs.DataSource = listPiHutang; reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TPiHutang", bs)); TPiHutang pihut; IList listTrans = new List <VTotalTransactionDetail>(); for (int i = 0; i < listPiHutang.Count; i++) { pihut = (TPiHutang)listPiHutang[i]; IList listTemp = DataMaster.GetListEq(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionId, pihut.TransactionId); for (int j = 0; j < listTemp.Count; j++) { listTrans.Add((VTotalTransactionDetail)listTemp[j]); } } bs = new BindingSource(); bs.DataSource = listTrans; reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs)); }
public void BindData(object sender, EventArgs e) { string myKeyWord = "%" + txt_SearchById.Text.Trim() + "%"; if (txt_SearchById.Text.Equals("<Cari Berdasar No Faktur>")) { myKeyWord = "%%"; } bindingSource_Search.Clear(); IList listSearch = null; if (trans_Type == ListOfTransaction.Sales) { listSearch = new List <TTransaction>(); IList listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord); TTransaction trans; for (int i = 0; i < listTemp.Count; i++) { trans = (TTransaction)listTemp[i]; listSearch.Add(trans); } listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord); for (int i = 0; i < listTemp.Count; i++) { trans = (TTransaction)listTemp[i]; listSearch.Add(trans); } } else { listSearch = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, trans_Type.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord); } if (trans_Type == ListOfTransaction.SalesVIP || trans_Type == ListOfTransaction.Sales || trans_Type == ListOfTransaction.ReturSales || trans_Type == ListOfTransaction.ReturSalesVIP) { for (int i = 0; i < listSearch.Count; i++) { TTransaction t = listSearch[i] as TTransaction; t.TransactionByName = AppCode.GetCustomerName(t.TransactionBy, true); } } else { for (int i = 0; i < listSearch.Count; i++) { TTransaction t = listSearch[i] as TTransaction; t.TransactionByName = AppCode.GetSupplierName(t.TransactionBy); } } if (listSearch.Count > 0) { bindingSource_Search.DataSource = listSearch; } }
private void FillVTotalTransactionServiceDataSource(string TransactionStatus, DateTime DateFrom, DateTime DateTo, string likeProperty, string likeValue) { if (string.IsNullOrEmpty(likeValue)) { likeValue = "%%"; } bs = new BindingSource(); bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionService), VTotalTransactionService.ColumnNames.TransactionDate, DateFrom, DateTo, VTotalTransactionService.ColumnNames.TransactionStatus, TransactionStatus, likeProperty, likeValue); reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionService", bs)); }
private void FillVTransactionDetailWithBankAccSource(string transStatus, DateTime from, DateTime to, ReportBy reportBy, string ItemOrPIC, bool isAdd) { IList listTemp = null; string ItemOrPIC_Temp = ItemOrPIC; if (ItemOrPIC_Temp.Equals("")) { ItemOrPIC_Temp = "%%"; } bs = new BindingSource(); bs.Clear(); //if (!transStatus.Equals(lbl_Param1.Name)) switch (reportBy) { case ReportBy.PIC: listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetailWithBankAcc), VTotalTransactionDetailWithBankAcc.ColumnNames.TransactionDate, from, to, VTotalTransactionDetailWithBankAcc.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetailWithBankAcc.ColumnNames.TransactionBy, ItemOrPIC_Temp); break; default: break; } //else // bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTransactionWithBankAcc), VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to); if (listVTransactionDetailWithBankAcc == null) { listVTransactionDetailWithBankAcc = new List <VTotalTransactionDetailWithBankAcc>(); } for (int i = 0; i < listTemp.Count; i++) { listVTransactionDetailWithBankAcc.Add(listTemp[i]); } bs.DataSource = listVTransactionDetailWithBankAcc; reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetailWithBankAcc", bs)); }