protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
if (Session["connectionString"] == null || Session["USER"] == null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Logoff", "LogOff();", true);
//Response.Redirect("Login.aspx");
}
if (!Page.IsPostBack)
{
try
{
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit2.Date = DateTime.Now;
ScriptManager.RegisterStartupScript(this, GetType(), "llamarCall", "DoCallback();", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
//getDelivery(ASPxDateEdit2.Date, ASPxDateEdit1.Date);
}
try
{
if (Session["DS_DISEÑO_MOVEMENT"] != null)
{
var reporte = new Report.ReportInventoryMovement();
reporte.DataSource = Session["DS_DISEÑO_MOVEMENT"];
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
if (Session["DATA_MOVEMENT"] != null)
{
ASPxGridView1.DataSource = Session["DATA_MOVEMENT"];
ASPxGridView1.DataBind();
//ScriptManager.RegisterStartupScript(this, this.GetType(), "llamarCall", "DoCallback();", true);
//getMovement(ASPxDateEdit2.Date, ASPxDateEdit1.Date);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void ReportView()
{
try
{
if (Session["DATA_MOVEMENT"] != null)
{
var dsDiseño = new DS.dsInventoryMovement();
var dsEjecucion = (DataSet)Session["DATA_MOVEMENT"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_INVENTORY_MOVEMENT.NewRow();
row[0] = dsEjecucion.Tables[0].Rows[i]["TXN_ID"];
row[1] = dsEjecucion.Tables[0].Rows[i]["TXN_CREATED_STAMP"];
row[2] = dsEjecucion.Tables[0].Rows[i]["TXN_TYPE"];
row[3] = dsEjecucion.Tables[0].Rows[i]["SKU"];
row[4] = dsEjecucion.Tables[0].Rows[i]["SKU_DESCRIPTION"];
row[5] = dsEjecucion.Tables[0].Rows[i]["QTY"];
row[6] = dsEjecucion.Tables[0].Rows[i]["SALDO_ANTERIOR"];
row[7] = dsEjecucion.Tables[0].Rows[i]["NUEVO_SALDO"];
row[8] = dsEjecucion.Tables[0].Rows[i]["PALLET_ID"];
row[9] = dsEjecucion.Tables[0].Rows[i]["BATCH_SUPPLIER"];
row[10] = (Convert.IsDBNull(dsEjecucion.Tables[0].Rows[i]["BATCH_SUPPLIER_EXPIRATION_DATE"])) ? "" : DateTime.Parse(dsEjecucion.Tables[0].Rows[i]["BATCH_SUPPLIER_EXPIRATION_DATE"].ToString()).ToString("dd/MM/yyyy");
dsDiseño.SWIFT_INVENTORY_MOVEMENT.Rows.Add(row);
}
var reporte = new Report.ReportInventoryMovement();
reporte.DataSource = dsDiseño;
Session["DS_DISEÑO_MOVEMENT"] = dsDiseño;
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
