private void SetDataSource(ReportDocument Report)
{
string TransactionNo = Session["tranno"].ToString();
ReportDataset rptds = new ReportDataset();
Stock clsStock = new Stock();
DataTable dt = clsStock.Search(TransactionNo);
clsStock.CommitAndDispose();
long StockID = Convert.ToInt64(dt.Rows[0]["StockID"].ToString());
StockItem clsStockItem = new StockItem();
DataTable dtItems = clsStockItem.ListAsDataTable(StockID);
clsStockItem.CommitAndDispose();
foreach(DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Stocks.NewRow();
foreach (DataColumn dc in rptds.Stocks.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Stocks.Rows.Add(drNew);
}
foreach(DataRow dr in dtItems.Rows)
{
DataRow drNew = rptds.StockItems.NewRow();
foreach (DataColumn dc in rptds.StockItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.StockItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void LoadItems()
{
DataClass clsDataClass = new DataClass();
StockItem clsStockItem = new StockItem();
lstItem.DataSource = clsStockItem.ListAsDataTable(Convert.ToInt64(lblStockID.Text)).DefaultView;
lstItem.DataBind();
clsStockItem.CommitAndDispose();
ComputeAmount();
}
