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));
}