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