public void ReportView()
{
try
{
var dsEjecucion = (DataSet)Session["dsReporte"];
var dsDiseño = new dsPicking();
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_PICKING_HEADER.NewRow();
row[0] = Convert.ToString(Session["IDPICKING"]);
row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_CLASSIFICATION"];
row[2] = dsEjecucion.Tables[0].Rows[i]["NAME_CUSTOMER"];
row[3] = dsEjecucion.Tables[0].Rows[i]["LOGIN"];
row[4] = dsEjecucion.Tables[0].Rows[i]["REFERENCE"];
row[5] = dsEjecucion.Tables[0].Rows[i]["DOC_SAP_RECEPTION"];
dsDiseño.SWIFT_PICKING_HEADER.Rows.Add(row);
}
for (var i = 0; i < dsEjecucion.Tables[1].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_PICKING.NewRow();
row[0] = dsEjecucion.Tables[1].Rows[i]["PICKING_DETAIL"];
row[1] = dsEjecucion.Tables[1].Rows[i]["CODE_SKU"];
row[2] = dsEjecucion.Tables[1].Rows[i]["DESCRIPTION_SKU"];
row[3] = dsEjecucion.Tables[1].Rows[i]["DISPATCH"];
row[4] = dsEjecucion.Tables[1].Rows[i]["SCANNED"];
row[5] = dsEjecucion.Tables[1].Rows[i]["RESULT"];
row[6] = dsEjecucion.Tables[1].Rows[i]["DIFFERENCE"];
dsDiseño.SWIFT_PICKING.Rows.Add(row);
}
var reporte = new ReportPickingAudit {
DataSource = dsDiseño
};
Session["DSDISEÑO_PICKING_AUDIT"] = dsDiseño;
ASPxDocumentViewer1.DataBind();
ASPxDocumentViewer1.Report = reporte;
}
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 (Session["DSDISEÑO_PICKING_AUDIT"] != null)
{
var reporte = new ReportPickingAudit {
DataSource = Session["DSDISEÑO_PICKING_AUDIT"]
};
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
}
ASPxMenu1.Items.FindByName("btnBill").Visible = GeneraFactura();
if (!Page.IsPostBack)
{
try
{
if (Request.QueryString["codigo"] == null)
{
_codePicking = 0;
_status = string.Empty;
}
else
{
_codePicking = Convert.ToInt32(Request.QueryString["codigo"]);
ASPxSpinEdit1.Number = _codePicking;
_status = Convert.ToString(Request.QueryString["ESTATUS"]);
if (_status == "CLOSED")
{
ASPxMenu1.Items.FindByName("btnBill").Visible = false;
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Este Picking ya se encuentra Finalizado');", true);
ASPxMenu1.Items[0].Visible = false;
ASPxCheckBox1.Enabled = false;
ASPxMemo1.ReadOnly = true;
UiDesbloquear.Visible = true;
}
if (_status == "UNLOCKED")
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Este Picking se encuentra Desbloqueado');", true);
ASPxMenu1.Items[0].Visible = false;
ASPxCheckBox1.Enabled = false;
ASPxMemo1.ReadOnly = true;
BtnValidate.Visible = true;
ASPxTextBox2.Text = "";
ASPxTextBox2.Enabled = true;
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
GetClassificationPicking(Session["connectionString"].ToString());
GetClient(Session["connectionString"].ToString());
GetOperator(Session["connectionString"].ToString());
Session["IDPICKING"] = _codePicking;
}
LoadGridView(Convert.ToInt32(Session["IDPICKING"]));
}
