private void SetDataSource(ReportDocument Report)
{
long 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();
SOReturns clsSOReturns = new SOReturns();
MySqlDataReader myreader = clsSOReturns.List(iID, "CreditMemoID", SortOption.Ascending);
while (myreader.Read())
{
DataRow drNew = rptds.SOReturns.NewRow();
foreach (DataColumn dc in rptds.SOReturns.Columns)
{
drNew[dc] = "" + myreader[dc.ColumnName];
}
rptds.SOReturns.Rows.Add(drNew);
}
myreader.Close();
SOReturnItems clsSOReturnItems = new SOReturnItems(clsSOReturns.Connection, clsSOReturns.Transaction);
System.Data.DataTable dt = clsSOReturnItems.ListAsDataTable(iID);
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SOReturnItems.NewRow();
foreach (DataColumn dc in rptds.SOReturnItems.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.SOReturnItems.Rows.Add(drNew);
}
clsSOReturns.CommitAndDispose();
Report.SetDataSource(rptds);
SetParameters(Report);
}