public void ReportView() { try { if (Session["DATA_TASK"] != null) { var dsDiseño = new dsTasks(); var dsEjecucion = (DataSet)Session["DATA_TASK"]; for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++) { var row = dsDiseño.SWIFT_TASKS.NewRow(); row[0] = dsEjecucion.Tables[0].Rows[i]["TASK_ID"]; row[1] = dsEjecucion.Tables[0].Rows[i]["FECHA"]; row[2] = dsEjecucion.Tables[0].Rows[i]["DESCRIPCION"]; row[3] = dsEjecucion.Tables[0].Rows[i]["REFERENCIA"]; row[4] = dsEjecucion.Tables[0].Rows[i]["CLPR"]; row[5] = dsEjecucion.Tables[0].Rows[i]["CODIGO_SKU"]; row[6] = dsEjecucion.Tables[0].Rows[i]["DESCRIPCION_SKU"]; row[7] = dsEjecucion.Tables[0].Rows[i]["CANTIDAD"]; row[8] = dsEjecucion.Tables[0].Rows[i]["ESTATUS"]; row[9] = dsEjecucion.Tables[0].Rows[i]["ACTION"]; dsDiseño.SWIFT_TASKS.Rows.Add(row); } var reporte = new Report.ReportTask { DataSource = dsDiseño }; Session["DSDISEÑO_TASK"] = dsDiseño; ASPxDocumentViewer1.Report = reporte; ASPxDocumentViewer1.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
protected void Page_Load(object sender, EventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } if (!Page.IsPostBack) { try { ASPxDateEdit1.Date = DateTime.Now; ASPxDateEdit2.Date = DateTime.Now; ASPxDateEdit3.Date = DateTime.Now; ASPxDateEdit4.Date = DateTime.Now; ASPxGridLookup1.GridView.Width = 250; var pResult = ""; var pResult2 = ""; var ds = _objTask.GetAllTask(Session["connectionString"].ToString(), ASPxDateEdit2.Date, ASPxDateEdit1.Date, ref pResult); if (pResult == "") { if (ds.Tables[0].Rows.Count > 0) { ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); Session["DATA_TASK"] = ds; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } var ds2 = _objTask.GetAllTaskStatus(Session["connectionString"].ToString(), ASPxDateEdit4.Date, ASPxDateEdit3.Date, ref pResult2); if (pResult2 == "") { if (ds2.Tables[0].Rows.Count > 0) { ASPxGridView2.DataSource = ds2; ASPxGridView2.DataBind(); Session["DATA_TASK2"] = ds2; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult2 + "');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } } try { CargarOperador(); if (Session["DSDISEÑO_TASK"] != null) { var reporte = new Report.ReportTask { DataSource = Session["DSDISEÑO_TASK"] }; ASPxDocumentViewer1.Report = reporte; ASPxDocumentViewer1.DataBind(); } if (Session["DATA_TASK"] != null) { ASPxGridView1.DataSource = Session["DATA_TASK"]; ASPxGridView1.DataBind(); } if (Session["DATA_TASK2"] != null) { ASPxGridView2.DataSource = Session["DATA_TASK2"]; ASPxGridView2.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }