public void GetSku() { try { var pResult = ""; var ds = _wscalled.GetSku(_cs, ref pResult); if (pResult == "") { if (ds.Tables[0].Rows.Count <= 0) { return; } GrLookSku.DataSource = ds; GrLookSku.DataBind(); Session["SKU"] = ds; } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } 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; } 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(); }