private void FillTransactionTotalSource(string transStatus, DateTime from, DateTime to, ReportBy reportBy, string ItemOrPIC)
{
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.Item:
NHibernate.Expression.ICriterion[] expArray = new NHibernate.Expression.ICriterion[3];
expArray[0] = NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp);
expArray[1] = NHibernate.Expression.Expression.Between(VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
expArray[2] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString()));
bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDetail), expArray, null);
//bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp);
break;
case ReportBy.PIC:
expArray = new NHibernate.Expression.ICriterion[3];
expArray[0] = NHibernate.Expression.Expression.InsensitiveLike(VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp);
expArray[1] = NHibernate.Expression.Expression.Between(VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
expArray[2] = NHibernate.Expression.Expression.Or(NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString()), NHibernate.Expression.Expression.Eq(VTotalTransactionDetail.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString()));
bs.DataSource = DataMaster.GetList(typeof(VTotalTransactionDetail), expArray, null);
//bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp);
break;
default:
break;
}
//else
// bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs));
try
{
ReportParameter[] parameters = new ReportParameter[2];
parameters[0] = new ReportParameter("Report_Parameter_DateFrom", from.ToString(AppCode.DateTimeFormat));
parameters[1] = new ReportParameter("Report_Parameter_DateTo", to.ToString(AppCode.DateTimeFormat));
reportViewer1.LocalReport.SetParameters(parameters);
}
catch (Exception)
{
}
}
private void FillVTransactionWithBankAccSource(string transStatus, DateTime from, DateTime to, ReportBy reportBy, string ItemOrPIC)
{
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:
bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTransactionWithBankAcc), VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to, VTransactionWithBankAcc.ColumnNames.TransactionStatus, transStatus, VTransactionWithBankAcc.ColumnNames.TransactionBy, ItemOrPIC_Temp);
break;
default:
break;
}
//else
// bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTransactionWithBankAcc), VTransactionWithBankAcc.ColumnNames.TransactionDate, from, to);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTransactionWithBankAcc", bs));
}
private void FillTransactionTotalSource(string transStatus, DateTime from, DateTime to, ReportBy reportBy, string ItemOrPIC)
{
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.Item:
bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.ItemId, ItemOrPIC_Temp);
break;
case ReportBy.PIC:
bs.DataSource = DataMaster.GetListBetweenEqLikeValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to, VTotalTransactionDetail.ColumnNames.TransactionStatus, transStatus, VTotalTransactionDetail.ColumnNames.TransactionBy, ItemOrPIC_Temp);
break;
default:
break;
}
//else
// bs.DataSource = DataMaster.GetListBetweenValue(typeof(VTotalTransactionDetail), VTotalTransactionDetail.ColumnNames.TransactionDate, from, to);
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_VTotalTransactionDetail", bs));
try
{
ReportParameter[] parameters = new ReportParameter[4];
parameters[0] = new ReportParameter("Report_Parameter_DateFrom", from.ToString("f"));
parameters[1] = new ReportParameter("Report_Parameter_DateTo", to.ToString("f"));
parameters[2] = new ReportParameter("Report_Parameter_Status", transStatus);
parameters[3] = new ReportParameter("Report_Parameter_PIC", ItemOrPIC_Temp);
reportViewer1.LocalReport.SetParameters(parameters);
}
catch (Exception)
{
}
}
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));
}
