public void ReportView()
{
try
{
if (Session["dsReporte"] != null)
{
var dsDiseño = new dsReception();
var dsEjecucion = (DataSet)Session["dsReporte"];
for (var i = 0; i < dsEjecucion.Tables[0].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_RECEPTION_HEADER.NewRow();
row[0] = Convert.ToString(Session["IDINCOME"]);
row[1] = dsEjecucion.Tables[0].Rows[i]["NAME_CLASSIFICATION"];
row[2] = dsEjecucion.Tables[0].Rows[i]["NAME_PROVIDER"];
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_RECEPTION_HEADER.Rows.Add(row);
}
for (var i = 0; i < dsEjecucion.Tables[1].Rows.Count; i++)
{
var row = dsDiseño.SWIFT_RECEPTION_DETAIL.NewRow();
row[0] = dsEjecucion.Tables[1].Rows[i]["CODE_SKU"];
row[1] = dsEjecucion.Tables[1].Rows[i]["DESCRIPTION_SKU"];
row[2] = dsEjecucion.Tables[1].Rows[i]["EXPECTED"];
row[3] = dsEjecucion.Tables[1].Rows[i]["RESULT"];
row[4] = dsEjecucion.Tables[1].Rows[i]["SCANNED"];
row[5] = dsEjecucion.Tables[1].Rows[i]["DIFFERENCE"];
dsDiseño.SWIFT_RECEPTION_DETAIL.Rows.Add(row);
}
var reporte = new Report.ReportReception {
DataSource = dsDiseño
};
Session["DSDISEÑO"] = 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 (Session["connectionString"] == null || Session["USER"] == null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Logoff", "LogOff();", true);
//Response.Redirect("Login.aspx");
}
else
{
try
{
var reporte = new Report.ReportReception {
DataSource = Session["DSDISEÑO"]
};
ASPxDocumentViewer1.Report = reporte;
ASPxDocumentViewer1.DataBind();
if (!Page.IsPostBack)
{
try
{
if (Request.QueryString["codigo"] == null)
{
_codeIncome = 0;
_estatus = string.Empty;
}
else
{
_codeIncome = Convert.ToInt32(Request.QueryString["codigo"]);
ASPxSpinEdit2.Number = _codeIncome;
_estatus = Convert.ToString(Request.QueryString["ESTATUS"]);
if (_estatus == "CLOSED")
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Esta Recepcion ya se encuentra Finalizada');", true);
ASPxMenu1.Items[0].Visible = false;
ASPxCheckBox1.Enabled = false;
ASPxMemo1.ReadOnly = true;
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
GetClassificationReception(Session["connectionString"].ToString());
GetProvider(Session["connectionString"].ToString());
GetOperator(Session["connectionString"].ToString());
Session["IDINCOME"] = _codeIncome;
}
LoadGridView(Convert.ToInt32(Session["IDINCOME"]));
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
}