private void SetDataSource(ReportDocument Report) { Int64 iID = 0; try { if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["retid"].ToString() != null) { iID = Convert.ToInt64(Request.QueryString["retid"].ToString()); } else { iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["retid"].ToString(), Session.SessionID)); } lblReferrer.ToolTip = iID.ToString(); } catch { iID = long.Parse(lblReferrer.ToolTip); } ReportDataset rptds = new ReportDataset(); POReturns clsPOReturns = new POReturns(); System.Data.DataTable dt = clsPOReturns.ListAsDataTable(DebitMemoID: iID); POReturnItems clsPOReturnItems = new POReturnItems(clsPOReturns.Connection, clsPOReturns.Transaction); System.Data.DataTable dtitems = clsPOReturnItems.ListAsDataTable(iID); clsPOReturns.CommitAndDispose(); foreach (System.Data.DataRow dr in dt.Rows) { DataRow drNew = rptds.POReturns.NewRow(); foreach (DataColumn dc in rptds.POReturns.Columns) { drNew[dc] = dr[dc.ColumnName]; } rptds.POReturns.Rows.Add(drNew); } foreach (System.Data.DataRow dr in dtitems.Rows) { DataRow drNew = rptds.POReturnItems.NewRow(); foreach (DataColumn dc in rptds.POReturnItems.Columns) { drNew[dc] = dr[dc.ColumnName]; } rptds.POReturnItems.Rows.Add(drNew); } Report.SetDataSource(rptds); SetParameters(Report); }
private void LoadItems() { DataClass clsDataClass = new DataClass(); POReturnItems clsPOReturnItems = new POReturnItems(); lstItem.DataSource = clsPOReturnItems.ListAsDataTable(Convert.ToInt64(lblDebitMemoID.Text), SortField: "DebitMemoItemID", SortOrder: SortOption.Ascending).DefaultView; lstItem.DataBind(); clsPOReturnItems.CommitAndDispose(); }