protected void Page_Load(object sender, EventArgs e) { if (ValidarConexionYUsuarioLogueado(sender)) { try { if (Session["DSDISEÑO_CLASSIFICATION"] != null) { var reporte = new Report.ReportClassification(); reporte.DataSource = Session["DSDISEÑO_CLASSIFICATION"]; ASPxDocumentViewer1.Report = reporte; ASPxDocumentViewer1.DataBind(); } if (!Page.IsPostBack) { Session["selectedClassification"] = "ALL"; } if (Session["selectedClassification"] != null) { GetClassification(Session["selectedClassification"].ToString()); } _user = Session["USER"].ToString(); Connection = Session["connectionString"].ToString(); if (Session["BANCOS"] != null) { if ((bool)Session["BANCOS"]) { GetBankNames(); } else { GetInferface(); } } else { GetInferface(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } } }
public void ReportView() { try { var pResult = ""; var dsEjecucion = _objClassification.GetAllClassification(Session["connectionString"].ToString(), ref pResult); var dsDiseño = new dsClassification(); if (pResult == "") { for (int i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++) { var row = dsDiseño.SWIFT_CLASSIFICATION.NewRow(); row[0] = dsEjecucion.Tables[0].Rows[i]["CLASSIFICATION"]; row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_CLASSIFICATION"]; row[2] = dsEjecucion.Tables[0].Rows[i]["PRIORITY_CLASSIFICATION"]; row[3] = dsEjecucion.Tables[0].Rows[i]["VALUE_TEXT_CLASSIFICATION"]; switch (dsEjecucion.Tables[0].Rows[i]["GROUP_CLASSIFICATION"].ToString()) { case "CUSTOMER": row[4] = "CLIENTE"; break; case "SKU": row[4] = "SKU"; break; case "PROVIDER": row[4] = "PROVEEDOR"; break; case "VEHICLE": row[4] = "VEHICULO"; break; case "RECEPTION": row[4] = "RECEPCION"; break; case "WEATHER": row[4] = "CLIMA"; break; case "LOCATION": row[4] = "UBICACION"; break; case "PICKING": row[4] = "PICKING"; break; case "DEVOLUTION": row[4] = "DEVOLUCION"; break; case "DISPATCH": row[4] = "DESPACHO"; break; case "LABEL": row[4] = "ETIQUETA"; break; case "MEASURE": row[4] = "UNIDAD DE MEDIDA"; break; case "DRIVER": row[4] = "EMPRESA TRANSPORTISTA"; break; } dsDiseño.SWIFT_CLASSIFICATION.Rows.Add(row); } var reporte = new Report.ReportClassification { DataSource = dsDiseño }; Session["DSDISEÑO_CLASSIFICATION"] = dsDiseño; ASPxDocumentViewer1.DataBind(); ASPxDocumentViewer1.Report = reporte; } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }