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);
}
}
