protected void PageViewerPopup_CustomJSProperties(object sender, DevExpress.Web.CustomJSPropertiesEventArgs e)
{
var reportTypes = Enum.GetValues(typeof(ReportType)).OfType <ReportType>();
e.Properties["cpReportDisplayNames"] = reportTypes.ToDictionary(r => r.ToString(), r => HicomReportUtil.GetReportDisplayName(r));
}
protected void Page_Load(object sender, EventArgs e)
{
XtraReport mainReport;
var query = Request.QueryString[LoadReportArgsKey];
ArrayList paymentIds = new ArrayList();
// If sale order
if (query.Contains("Sale_Order_Product"))
{
var args = SPlanetUtil.DeserializeCallbackArgs(query);
DataSet dsSaleOrderData;
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@sale_order_no", SqlDbType.VarChar, 20)
{
Value = args[1].ToString()
},
};
conn.Open();
dsSaleOrderData = SqlHelper.ExecuteDataset(conn, "sp_sale_order_list_data_by_no", arrParm.ToArray());
conn.Close();
}
if (dsSaleOrderData.Tables.Count > 0)
{
#region SaleOrder Payment
// Quotation Notification
foreach (var row in dsSaleOrderData.Tables[3].AsEnumerable())
{
paymentIds.Add(Convert.IsDBNull(row["id"]) ? 0 : Convert.ToInt32(row["id"]));
}
#endregion SaleOrder Payment
if (paymentIds.Count == 0)
{
paymentIds.Add(0);
}
}
mainReport = new XtraReport();
for (int i = 0; i < paymentIds.Count; i++)
{
var report = HicomReportUtil.CreateReport(query + "|" + paymentIds[i] + "|" + (i + 1));
if (report != null)
{
//DocumentViewerControl.Report = report;
report.CreateDocument();
mainReport.Pages.AddRange(report.Pages);
}
}
}
else
{
mainReport = HicomReportUtil.CreateReport(query);
}
DocumentViewerControl.Report = mainReport;
var isTableLayout = true;
if (query.Contains("Stock_Card") ||
query.Contains("Stock_Inventory_Products")
)
{
isTableLayout = false;
}
DocumentViewerControl.SettingsReportViewer.TableLayout = isTableLayout;
DocumentViewerControl.Report.RequestParameters = false;
//DocumentViewerControl.Report.par
//DocumentViewerControl.Report.Parameters.
}
