public DsReports.SalesInvListDataTable GetSalesReportByDate(DateTime d1,DateTime d2)
{
var ds = new DsReports().SalesInvList;
try
{
var ta = new DsReportsTableAdapters.taSalesInvList { Connection = { ConnectionString = _constr } };
ta.FillByTrandate(ds, false, d1, d2);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return ds;
}
public DsReports.SalesInvListDataTable GetSalesReport(string invno = null)
{
var ta = new DsReportsTableAdapters.taSalesInvList {Connection = {ConnectionString = _constr}};
var ds = new DsReports().SalesInvList;
if (invno == null)
ta.Fill(ds, false);
else
{
ta.FillBySalesInv(ds, true, false, invno);
}
return ds;
}
