private void LlenarListaDocErp()
{
try
{
var pResult = "";
var ds = _wscalled.GetDocErpIncome(ref pResult, Session["connectionString"].ToString());
if (pResult == "OK")
{
Session["LIST_DOC_ERP_PICKING"] = ds;
UiListaPedidosErp.DataSource = Session["LIST_DOC_ERP_PICKING"];
UiListaPedidosErp.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + ex.Message + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
if (Session["SAP_RECEPTION_DATA"] != null)
{
GridSap.DataSource = Session["SAP_RECEPTION_DATA"];
GridSap.DataBind();
}
//Validacion de insercion de datos HEADER en tabla temporal
if (Request["__EVENTARGUMENT"] == "KeyPress")
{
_cs = Session["connectionString"].ToString();
_wscalled.InsertIncomeTemp(Convert.ToString(CbType.Value), Convert.ToString(GrLookProvider.Value), Convert.ToString(GrLookUser.Text), TxtReference.Text, SpinSap.Text, Session["USER"].ToString(), Session["connectionString"].ToString(), DateAssignedDate.Date, Convert.ToInt32(CbPriority.Value));
Session["INGRESO_HEADER"] = "TRUE";
}
//Validacion de insercion de datos en Detail en tabla Temporal
if (Request["__EVENTARGUMENT"] == "KeyPressSpE")
{
if ((string)Session["UPDATE_TEMP"] == "true")
{
_wscalled.UpdateDetail((int)Session["RECEPTION_DETAIL_TEMP"], Convert.ToString(GrLookSku.Value), Convert.ToString(GrLookSku.Text), Convert.ToInt32(SpinSku.Number), Session["connectionString"].ToString());
Session["UPDATE_TEMP"] = "false";
Session["EXPECTED"] = Convert.ToInt32(SpinSku.Number);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else if ((string)Session["INGRESO_HEADER"] == "TRUE")
{
var dsNumber = _wscalled.GetNumberHeader(Session["connectionString"].ToString());
Session["Header"] = Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]);
_wscalled.InsertIncomeDetail(Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]), Convert.ToString(GrLookSku.Value), Convert.ToDecimal(SpinSku.Number), Session["connectionString"].ToString(), GrLookSku.Text);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
SpinSku.Number = 0;
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
//?Actualizar o insertar en base a la variable de sesion que lo indica
if ((string)Session["UPDATE_TEMP"] == "true")
{
_wscalled.UpdateDetail((int)Session["RECEPTION_DETAIL_TEMP"], Convert.ToString(GrLookSku.Value), Convert.ToString(GrLookSku.Text), Convert.ToInt32(SpinSku.Number), Session["connectionString"].ToString());
Session["UPDATE_TEMP"] = "false";
Session["EXPECTED"] = Convert.ToInt32(SpinSku.Number);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
else
{
_wscalled.InsertIncomeTemp(Convert.ToString(CbType.Value), Convert.ToString(GrLookProvider.Value), Convert.ToString(GrLookUser.Text), TxtReference.Text, SpinSap.Text, Session["USER"].ToString(), Session["connectionString"].ToString(), DateAssignedDate.Date, Convert.ToInt32(CbPriority.Value));
Session["INGRESO_HEADER"] = "TRUE";
var dsNumber = _wscalled.GetNumberHeader(Session["connectionString"].ToString());
Session["Header"] = Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]);
_wscalled.InsertIncomeDetail(Convert.ToInt32(dsNumber.Tables[0].Rows[0]["RECEPTION_HEADER"]), Convert.ToString(GrLookSku.Value), Convert.ToDecimal(SpinSku.Number), Session["connectionString"].ToString(), GrLookSku.Text);
var pResult = "";
var dsDetail = _wscalled.GetIncomeDetailForIncomeHeader((int)Session["Header"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
GridReception.DataSource = dsDetail;
GridReception.DataBind();
SpinSku.Number = 0;
Session["dsReception"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
}
}
_cs = (string)Session["connectionString"];
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
if (!Page.IsPostBack)
{
try
{
Session["SAP_RECEPTION_TYPE"] = null;
Session["LIST_DOC_ERP_PICKING"] = null;
Session["SAP_RECEPTION_DATA"] = null;
GridSap.DataSource = null;
GridSap.DataBind();
DateAssignedDate.Date = DateTime.Today;
Session["INGRESO_HEADER"] = "false";
Session["SaveReception"] = "false";
Session["dsReception"] = null;
//
LlenarListaDocErp();
//Carga de Tipos de clasificacion Recepcion
GetClassificationReception();
//Carga de Proveedores
GetProvider("");
//Carga de Operadores
GetOperator();
//Carga de SKU
if (Session["SKU"] != null)
{
var ds = (DataSet)Session["SKU"];
if (ds.Tables[0].Rows.Count > 0)
{
GrLookSku.DataSource = ds;
GrLookSku.DataBind();
Session["SKU"] = ds;
}
}
else
{
GetSku();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
try
{
if (Session["LIST_DOC_ERP_PICKING"] != null)
{
UiListaPedidosErp.DataSource = Session["LIST_DOC_ERP_PICKING"];
UiListaPedidosErp.DataBind();
}
GetSkuIngrid();
GrLookUser.DataSource = Session["OPERATOR"];
GrLookUser.DataBind();
GrLookProvider.DataSource = Session["PROVIDER"];
GrLookProvider.DataBind();
GrLookSku.DataSource = Session["SKU"];
GrLookSku.DataBind();
GridReception.DataSource = Session["dsReception"];
GridReception.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
ReportView();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
if (!IsPostBack)
{
Session["SAP_PICKING_DATA"] = null;
}
if (Session["SAP_PICKING_DATA"] != null)
{
ASPxGridView2.DataSource = Session["SAP_PICKING_DATA"];
ASPxGridView2.DataBind();
}
ASPxGridLookup1.GridView.Width = 200;
ASPxGridLookup3.GridView.Width = 250;
ASPxGridLookup2.GridView.Width = 200;
if (Request["__EVENTARGUMENT"] == "KeyPressSpE")
{
try
{
if ((string)Session["UPDATE_TEMP_PICKING"] == "true")
{
_result = _wscalled.UpdateDetailPicking((int)Session["PICKING_DETAIL"], Convert.ToString(ASPxGridLookup3.Value), Convert.ToString(ASPxGridLookup3.Text), Convert.ToInt32(ASPxSpinEdit1.Number), Session["connectionString"].ToString());
Session["UPDATE_TEMP_PICKING"] = "false";
Session["DISPATCH"] = ASPxSpinEdit1.Number;
var pResult = "";
var dsDetail = _wscalled.GetPickingDetailForPickingHeader((int)Session["Header_picking"],
Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
ASPxGridView1.DataSource = dsDetail;
ASPxGridView1.DataBind();
Session["dsPicking"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
ASPxSpinEdit1.Number = 0;
ASPxGridLookup3.Text = "";
}
else if ((string)Session["INGRESO_HEADER_PICKING"] == "TRUE")
{
_result = _wscalled.InsertPickingetail((int)Session["Header_picking"], Convert.ToString(ASPxGridLookup3.Value), Convert.ToDecimal(ASPxSpinEdit1.Number), Session["connectionString"].ToString(), ASPxGridLookup3.Text);
var pResult = "";
var dsDetail = _wscalled.GetPickingDetailForPickingHeader((int)Session["Header_picking"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
ASPxGridView1.DataSource = dsDetail;
ASPxGridView1.DataBind();
Session["dsPicking"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
ASPxSpinEdit1.Number = 0;
ASPxGridLookup3.Text = "";
}
else
{
if ((string)Session["UPDATE_TEMP_PICKING"] == "true")
{
_result = _wscalled.UpdateDetailPicking((int)Session["PICKING_DETAIL"], Convert.ToString(ASPxGridLookup3.Value), Convert.ToString(ASPxGridLookup3.Text), Convert.ToInt32(ASPxSpinEdit1.Number), Session["connectionString"].ToString());
Session["UPDATE_TEMP_PICKING"] = "false";
Session["DISPATCH"] = ASPxSpinEdit1.Number;
var pResult = "";
var dsDetail = _wscalled.GetPickingDetailForPickingHeader((int)Session["Header_picking"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
ASPxGridView1.DataSource = dsDetail;
ASPxGridView1.DataBind();
Session["dsPicking"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
ASPxSpinEdit1.Number = 0;
ASPxGridLookup3.Text = "";
}
else
{
_result = _wscalled.InsertPickingTemp(Convert.ToString(ASPxComboBox1.Value), Convert.ToString(ASPxGridLookup1.Value), Convert.ToString(ASPxGridLookup2.Text), ASPxSpinEdit2.Text, ASPxSpinEdit3.Text, Session["USER"].ToString(), Session["connectionString"].ToString(), ASPxDateEdit1.Date, Convert.ToInt32(ASPxComboBox2.Value));
Session["INGRESO_HEADER_PICKING"] = "TRUE";
var pResult = "";
var dsNumber = _wscalled.GetNumberHeaderPicking(Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
Session["Header_picking"] =
Convert.ToInt32(dsNumber.Tables[0].Rows[0]["PICKING_HEADER"]);
_wscalled.InsertPickingetail(
Convert.ToInt32(dsNumber.Tables[0].Rows[0]["PICKING_HEADER"]),
Convert.ToString(ASPxGridLookup3.Value), Convert.ToDecimal(ASPxSpinEdit1.Number),
Session["connectionString"].ToString(), ASPxGridLookup3.Text);
var pResult2 = "";
var dsDetail =
_wscalled.GetPickingDetailForPickingHeader((int)Session["Header_picking"],
Session["connectionString"].ToString(), ref pResult2);
if (pResult2 == "")
{
ASPxGridView1.DataSource = dsDetail;
ASPxGridView1.DataBind();
Session["dsPicking"] = dsDetail;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult2 + "');", true);
}
ASPxSpinEdit1.Number = 0;
ASPxGridLookup3.Text = "";
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
if (!Page.IsPostBack)
{
try
{
Session["LIST_DOC_ERP_PICKING"] = null;
Session["UiListaBodega"] = null;
Session["CODE_WAREHOUSE"] = "";
ASPxDateEdit1.Date = DateTime.Now;
Session["INGRESO_HEADER_PICKING"] = "FALSE";
GetClassificationPicking();
GetAllCostumers();
GetOperator();
GetSku();
Session["SavePicking"] = "false";
Session["dsPicking"] = null;
LlenarListaDocErp();
LlenarListaBodegas();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
try
{
GetSku();
ASPxGridLookup2.DataSource = Session["OPERATOR"];
ASPxGridLookup2.DataBind();
ASPxGridLookup1.DataSource = Session["CUSTOMER"];
ASPxGridLookup1.DataBind();
ASPxGridView1.DataSource = Session["dsPicking"];
ASPxGridView1.DataBind();
if (Session["LIST_DOC_ERP_PICKING"] != null)
{
UiListaPedidosErp.DataSource = Session["LIST_DOC_ERP_PICKING"];
UiListaPedidosErp.DataBind();
}
if (!string.IsNullOrEmpty(Session["CODE_WAREHOUSE"].ToString()))
{
LlenarListaBodegas();
UiListaBodega.Enabled = true;
UiListaBodegaErp.Enabled = true;
UiListaBodega.Value = Session["CODE_WAREHOUSE"];
UiListaBodegaErp.Value = Session["CODE_WAREHOUSE"];
UiListaBodega.Enabled = false;
UiListaBodegaErp.Enabled = false;
}
else
{
LlenarListaBodegas();
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
ReportView();
}
