protected void CargarIdioma()
{
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
btnSend.Text = _textoLabels.readStatement(formName, _idioma, "btnSend");
lblRegrind.Text = _textoLabels.readStatement(formName, _idioma, "lblRegrind");
lblToIssue.Text = _textoLabels.readStatement(formName, _idioma, "lblToIssue");
lblMaxDigits.Text = _textoLabels.readStatement(formName, _idioma, "lblMaxDigits");
btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
minlenght.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularWorkOrder");
RequiredField.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "requiredWorkOrder");
OrderError.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "customWorkOrder");
validateReturn.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularQuantity");
}
protected void CargarIdioma()
{
lblDescWarehouse.Text = _textoLabels.readStatement(formName, _idioma, "lblDescWarehouse");
lblLocation.Text = _textoLabels.readStatement(formName, _idioma, "lblLocation");
lblItem.Text = _textoLabels.readStatement(formName, _idioma, "lblItem");
lblLot.Text = _textoLabels.readStatement(formName, _idioma, "lblLot");
lblQty.Text = _textoLabels.readStatement(formName, _idioma, "lblQty");
lblMaximumDigits.Text = _textoLabels.readStatement(formName, _idioma, "lblMaximumDigits");
lblUnit.Text = _textoLabels.readStatement(formName, _idioma, "lblUnit");
btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
btnContinue.Text = _textoLabels.readStatement(formName, _idioma, "btnContinue");
validateReturn.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularQuantity");
}
protected void CargarIdioma()
{
lblSugNumero.Text = _textoLabels.readStatement(formName, _idioma, "lblSugNumero");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
lblOrden.Text = _textoLabels.readStatement(formName, _idioma, "lblOrden");
lblArticulo.Text = _textoLabels.readStatement(formName, _idioma, "lblArticulo");
lblCantSugerida.Text = _textoLabels.readStatement(formName, _idioma, "lblCantSugerida");
lblUnidad.Text = _textoLabels.readStatement(formName, _idioma, "lblUnidad");
lblAlmacen.Text = _textoLabels.readStatement(formName, _idioma, "lblAlmacen");
lblUbicacion.Text = _textoLabels.readStatement(formName, _idioma, "lblUbicacion");
lblLote.Text = _textoLabels.readStatement(formName, _idioma, "lblLote");
btnGuardar.Text = _textoLabels.readStatement(formName, _idioma, "btnGuardar");
}
protected void CargarIdioma()
{
lblCover.Text = _textoLabels.readStatement(formName, _idioma, "lblCover");
lblMaster1.Text = _textoLabels.readStatement(formName, _idioma, "lblMaster1");
lblMaster2.Text = _textoLabels.readStatement(formName, _idioma, "lblMaster2");
lblMaster3.Text = _textoLabels.readStatement(formName, _idioma, "lblMaster3");
lblBox.Text = _textoLabels.readStatement(formName, _idioma, "lblBox");
btnContinue.Text = _textoLabels.readStatement(formName, _idioma, "btnContinue");
lblBarCode.Text = _textoLabels.readStatement(formName, _idioma, "lblBarCode");
lblItem.Text = _textoLabels.readStatement(formName, _idioma, "lblItem");
lblDescDescription.Text = _textoLabels.readStatement(formName, _idioma, "lblDescDescription");
lblDescQuantity.Text = _textoLabels.readStatement(formName, _idioma, "lblDescQuantity");
}
protected void CargarIdioma()
{
lblZoneCode.Text = _textoLabels.readStatement(formName, _idioma, "lblZoneCode");
btnSearchZone.Text = _textoLabels.readStatement(formName, _idioma, "btnSearchZone");
lblId.Text = _textoLabels.readStatement(formName, _idioma, "lblId");
btnSearch.Text = _textoLabels.readStatement(formName, _idioma, "btnSearch");
lblDescWarehouse.Text = _textoLabels.readStatement(formName, _idioma, "lblDescWarehouse");
lblDescItem.Text = _textoLabels.readStatement(formName, _idioma, "lblDescItem");
lblDescLotCode.Text = _textoLabels.readStatement(formName, _idioma, "lblDescLotCode");
lblDescQuantity.Text = _textoLabels.readStatement(formName, _idioma, "lblDescQuantity");
btnSend.Text = _textoLabels.readStatement(formName, _idioma, "btnSend");
validateReturn.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularQuantity");
}
protected void CargarIdioma()
{
//lblOrderNumber.Text = _textoLabels.readStatement(formName, _idioma, "lblOrderNumber");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
lblOrden.Text = _textoLabels.readStatement(formName, _idioma, "lblOrden");
lblArticulo.Text = _textoLabels.readStatement(formName, _idioma, "lblArticulo");
lblWareHouse.Text = _textoLabels.readStatement(formName, _idioma, "lblWareHouse");
lblTotal.Text = _textoLabels.readStatement(formName, _idioma, "lblTotal");
lblDelivered.Text = _textoLabels.readStatement(formName, _idioma, "lblDelivered");
lblPending.Text = _textoLabels.readStatement(formName, _idioma, "lblPending");
lblAnounced.Text = _textoLabels.readStatement(formName, _idioma, "lblAnounced");
lblUnit.Text = _textoLabels.readStatement(formName, _idioma, "lblUnit");
btnGuardar.Text = _textoLabels.readStatement(formName, _idioma, "btnGuardar");
}
protected void CargarIdioma()
{
lblNameForm.Text = _textoLabels.readStatement(formName, _idioma, "lblNameForm");
lblScan.Text = _textoLabels.readStatement(formName, _idioma, "lblScan");
lblPallet.Text = _textoLabels.readStatement(formName, _idioma, "lblPallet");
lblLocation.Text = _textoLabels.readStatement(formName, _idioma, "lblLocation");
lblItem.Text = _textoLabels.readStatement(formName, _idioma, "lblItem");
lblLot.Text = _textoLabels.readStatement(formName, _idioma, "lblLot");
lblQuantity.Text = _textoLabels.readStatement(formName, _idioma, "lblQuantity");
btnConfirmPalletLoad.Text = _textoLabels.readStatement(formName, _idioma, "btnConfirmPalletLoad");
btnConfirmPalletReceive.Text = _textoLabels.readStatement(formName, _idioma, "btnConfirmPalletReceive");
}
protected void CargarIdioma()
{
lblDescRegrindSequence.Text = _textoLabels.readStatement(formName, _idioma, "lblDescRegrindSequence");
btnQuery.Text = _textoLabels.readStatement(formName, _idioma, "btnQuery");
lblDescWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblDescWorkOrder");
lblDescRegrindSequence2.Text = _textoLabels.readStatement(formName, _idioma, "lblDescRegrindSequence");
lblDescRegrindCode.Text = _textoLabels.readStatement(formName, _idioma, "lblDescRegrindCode");
lblQuantityConfirm.Text = _textoLabels.readStatement(formName, _idioma, "lblQuantityConfirm");
lblLocation.Text = _textoLabels.readStatement(formName, _idioma, "lblLocation");
lblWarehouse.Text = _textoLabels.readStatement(formName, _idioma, "lblWarehouse");
btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
}
protected void CargarIdioma()
{
lblNameForm.Text = _textoLabels.readStatement(formName, _idioma, "lblNameForm");
lblScan.Text = _textoLabels.readStatement(formName, _idioma, "lblScan");
btnEndPicking.Text = _textoLabels.readStatement(formName, _idioma, "btnEndPicking");
btnEndReceipt.Text = _textoLabels.readStatement(formName, _idioma, "btnEndReceipt");
grdPalletsUID.Columns[0].HeaderText = _textoLabels.readStatement(formName, _idioma, "grdPallet");
grdPalletsUID.Columns[1].HeaderText = _textoLabels.readStatement(formName, _idioma, "grdItem");
grdPalletsUID.Columns[2].HeaderText = _textoLabels.readStatement(formName, _idioma, "grdLot");
grdPalletsUID.Columns[3].HeaderText = _textoLabels.readStatement(formName, _idioma, "grdQuantity");
grdPalletsUID.Columns[4].HeaderText = _textoLabels.readStatement(formName, _idioma, "grdLocation");
}
protected void CargarIdioma()
{
lblPalletId.Text = _textoLabels.readStatement(formName, _idioma, "lblPalletId");
btnSend.Text = _textoLabels.readStatement(formName, _idioma, "btnSend");
//btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
//// minlenght.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularWorkOrder");
// // RequiredFieldPallet.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "RequiredFieldPallet");
// // PalletError.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "customWorkOrder");
// grdRecords.Columns[0].HeaderText = _textoLabels.readStatement(formName, _idioma, "headPosition");
// grdRecords.Columns[1].HeaderText = _textoLabels.readStatement(formName, _idioma, "headItem");
// grdRecords.Columns[2].HeaderText = _textoLabels.readStatement(formName, _idioma, "headDescription");
// grdRecords.Columns[3].HeaderText = _textoLabels.readStatement(formName, _idioma, "headWarehouse");
// grdRecords.Columns[4].HeaderText = _textoLabels.readStatement(formName, _idioma, "headLot");
// grdRecords.Columns[5].HeaderText = _textoLabels.readStatement(formName, _idioma, "headPalletID");
// grdRecords.Columns[6].HeaderText = _textoLabels.readStatement(formName, _idioma, "headReturnQty");
// grdRecords.Columns[7].HeaderText = _textoLabels.readStatement(formName, _idioma, "headUnit");
// grdRecords.Columns[8].HeaderText = _textoLabels.readStatement(formName, _idioma, "headConfirmed");
//grdRecords.Columns[9].HeaderText = _textoLabels.readStatement(formName, _idioma, "headConfirmed");
}
protected static bool CargarIdioma()
{
LabelsText _textoLabels = new LabelsText();
string idioma = "INGLES";
string formName = "InventoryTakingByPalletIDWarehousesNotControlledByLocation.aspx";
Zonecodedoesntexist = _textoLabels.readStatement(formName, idioma, "Zonecodedoesntexist");
ThepaletteIDdoesnotexistorisnotlocated = _textoLabels.readStatement(formName, idioma, "ThepaletteIDdoesnotexistorisnotlocated");
Lotcodedoesntexist = _textoLabels.readStatement(formName, idioma, "Lotcodedoesntexist");
Locationblockedinbound = _textoLabels.readStatement(formName, idioma, "Locationblockedinbound");
Locationcodedoesntexist = _textoLabels.readStatement(formName, idioma, "Locationcodedoesntexist");
Registeredquantitycannotbelessthanorequaltozero = _textoLabels.readStatement(formName, idioma, "Registeredquantitycannotbelessthanorequaltozero");
CountWarehouseNotDefined = _textoLabels.readStatement(formName, idioma, "CountWarehouseNotDefined");
Warehousecodedoesntexist = _textoLabels.readStatement(formName, idioma, "Warehousecodedoesntexist");
Warehousenotequalzone = _textoLabels.readStatement(formName, idioma, "Warehousenotequalzone");
return(true);
}
protected void CargarIdioma()
{
lblRollNumber.Text = _textoLabels.readStatement(formName, _idioma, "lblRollNumber");
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
lblItem.Text = _textoLabels.readStatement(formName, _idioma, "lblItem");
lblLot.Text = _textoLabels.readStatement(formName, _idioma, "lblLot");
lblQuantity.Text = _textoLabels.readStatement(formName, _idioma, "lblQuantity");
btnRegister.Text = _textoLabels.readStatement(formName, _idioma, "btnRegister");
}
protected void CargarIdioma()
{
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
lblOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblOrder");
lblMachine.Text = _textoLabels.readStatement(formName, _idioma, "lblMachine");
lblStatus.Text = _textoLabels.readStatement(formName, _idioma, "lblStatus");
lblAction.Text = _textoLabels.readStatement(formName, _idioma, "lblAction");
btnSaveOrder.Text = _textoLabels.readStatement(formName, _idioma, "btnSaveOrder");
}
protected void CargarIdioma()
{
lblOrigenMovimiento.Text = _textoLabels.readStatement(formName, _idioma, "lblOrigenMovimiento");
lblNumeroRecepcion.Text = _textoLabels.readStatement(formName, _idioma, "lblNumeroRecepcion");
btnConsultarRecepcion.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultarRecepcion");
btnGuardarRecepcion.Text = _textoLabels.readStatement(formName, _idioma, "btnGuardarRecepcion");
ddlOrigenMovimiento.Items.Clear();
ddlOrigenMovimiento.Items.Insert(0, new ListItem("--Seleccione--", ""));
ddlOrigenMovimiento.Items.Insert(1, new ListItem(_textoLabels.readStatement(formName, _idioma, "ddlPurchases"), "2"));
ddlOrigenMovimiento.Items.Insert(2, new ListItem(_textoLabels.readStatement(formName, _idioma, "ddlSales"), "1"));
ddlOrigenMovimiento.Items.Insert(3, new ListItem(_textoLabels.readStatement(formName, _idioma, "ddlManufacture"), "4"));
ddlOrigenMovimiento.Items.Insert(4, new ListItem(_textoLabels.readStatement(formName, _idioma, "ddlTransfers"), "22"));
}
//protected void btnExit_Click(object sender, EventArgs e)
//{
// Response.Redirect("whInvMaterialPoOrderReturn.aspx");
//}
#endregion
#region Metodos
protected void CargarIdioma()
{
lblreturnorder.Text = _textoLabels.readStatement(formName, _idioma, "lblreturnorder");
btnSend.Text = _textoLabels.readStatement(formName, _idioma, "btnSend");
// btnSalir.Text = _textoLabels.readStatement(formName, _idioma, "btnSalir");
////printLabel.Text = _textoLabels.readStatement(formName, _idioma, "printLabel");
////btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
////minlenght.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularWorkOrder");
////RequiredField.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "requiredWorkOrder");
////OrderError.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "customWorkOrder");
//////validateReturn.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "btnSave");
//////validateQuantity.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "btnSave");
////grdRecords.Columns[0].HeaderText = _textoLabels.readStatement(formName, _idioma, "headPosition");
////grdRecords.Columns[1].HeaderText = _textoLabels.readStatement(formName, _idioma, "headItem");
////grdRecords.Columns[2].HeaderText = _textoLabels.readStatement(formName, _idioma, "headDescription");
////grdRecords.Columns[3].HeaderText = _textoLabels.readStatement(formName, _idioma, "headWarehouse");
////grdRecords.Columns[4].HeaderText = _textoLabels.readStatement(formName, _idioma, "headActualQty");
////grdRecords.Columns[5].HeaderText = _textoLabels.readStatement(formName, _idioma, "headUnit");
////grdRecords.Columns[6].HeaderText = _textoLabels.readStatement(formName, _idioma, "headToReturn");
////grdRecords.Columns[7].HeaderText = _textoLabels.readStatement(formName, _idioma, "headLot");
////grdRecords.Columns[8].HeaderText = _textoLabels.readStatement(formName, _idioma, "headLot");
}
protected void CargarIdioma()
{
lblDescUser.Text = _textoLabels.readStatement(formName, _idioma, "lblDescUser");
lblDescUsername.Text = _textoLabels.readStatement(formName, _idioma, "lblDescUsername");
btnMainMenu.Text = _textoLabels.readStatement(formName, _idioma, "btnMainMenu");
btnCloseSession.Text = _textoLabels.readStatement(formName, _idioma, "btnCloseSession");
lblDescDateSession.Text = _textoLabels.readStatement(formName, _idioma, "lblDescDateSession");
lblIdiom.Text = _textoLabels.readStatement(formName, _idioma, "lblIdiom");
}
protected void CargarIdioma()
{
lblPagina.Text = _textoLabels.readStatement(formName, _idioma, "lblPagina");
lblOperator.Text = _textoLabels.readStatement(formName, _idioma, "lblOperator");
lblTruck.Text = _textoLabels.readStatement(formName, _idioma, "lblTruck");
lblSource.Text = _textoLabels.readStatement(formName, _idioma, "lblSource");
lblDestination.Text = _textoLabels.readStatement(formName, _idioma, "lblDestination");
btnGenerateUI.Text = _textoLabels.readStatement(formName, _idioma, "btnGenerateUI");
}
public void CargarIdioma()
{
lblQuantityError = _textoLabels.readStatement(formName, _idioma, "lblQuantityError");
lblConvertionError = _textoLabels.readStatement(formName, _idioma, "lblConvertionError");
lblOrderError = _textoLabels.readStatement(formName, _idioma, "lblOrderError");
lblItemError = _textoLabels.readStatement(formName, _idioma, "lblItemError");
lblDateError = _textoLabels.readStatement(formName, _idioma, "lblDateError");
lblPositionError = _textoLabels.readStatement(formName, _idioma, "lblPositionError");
}
protected void CargarIdioma()
{
Pleaseselectrollwinder = _textoLabels.readStatement("whInvLabel.aspx", _idioma, "Pleaseselectrollwinder");
//JC 290422 Enviar Mensaje de tiempo de espera
Pleasewait = _textoLabels.readStatement("whInvLabel.aspx", _idioma, "Pleasewait");
lblMachine.Text = _textoLabels.readStatement("whInvLabel.aspx", _idioma, "lblMachine");
lblWeight.Text = _textoLabels.readStatement("whInvLabel.aspx", _idioma, "lblWeight");
lblRollWinder.Text = _textoLabels.readStatement("whInvLabel.aspx", _idioma, "lblRollWinder");
btnSend.Text = _textoLabels.readStatement("whInvLabel.aspx", _idioma, "btnSend");
}
protected void CargarIdioma()
{
lblMachine.Text = _textoLabels.readStatement(formName, _idioma, "lblMachine");
lblRegrind.Text = _textoLabels.readStatement(formName, _idioma, "lblRegrind");
lblToIssue.Text = _textoLabels.readStatement(formName, _idioma, "lblToIssue");
lblMaxDigits.Text = _textoLabels.readStatement(formName, _idioma, "lblMaxDigits");
btnChangeMac.Text = _textoLabels.readStatement(formName, _idioma, "btnChangeMac");
btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
//validateReturn.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularQuantity");
}
protected void CargarIdioma()
{
lblInformation.Text = _textoLabels.readStatement(formName, _idioma, "lblInformation");
lblEncLogin.Text = _textoLabels.readStatement(formName, _idioma, "lblEncLogin");
lblCurrentPassword.Text = _textoLabels.readStatement(formName, _idioma, "lblCurrentPassword");
lblNewPassword.Text = _textoLabels.readStatement(formName, _idioma, "lblNewPassword");
lblConfirmPassword.Text = _textoLabels.readStatement(formName, _idioma, "lblConfirmPassword");
LoginButton.Text = _textoLabels.readStatement(formName, _idioma, "LoginButton");
ddlIdioma.SelectedValue = _idioma;
}
protected void CargarIdioma()
{
WorkorderhasnotbeeninitiatedPOP = _textoLabels.readStatement(formName, _idioma, "WorkorderhasnotbeeninitiatedPOP");
lblOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblOrder");
lblSecuence.Text = _textoLabels.readStatement(formName, _idioma, "lblSecuence");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
lblMadeIn.Text = _textoLabels.readStatement(formName, _idioma, "lblMadeIn");
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
lblPalletNumber.Text = _textoLabels.readStatement(formName, _idioma, "lblPalletNumber");
lblInspectorInitial.Text = _textoLabels.readStatement(formName, _idioma, "lblInspectorInitial");
lblDate.Text = _textoLabels.readStatement(formName, _idioma, "lblDate");
lblShift.Text = _textoLabels.readStatement(formName, _idioma, "lblShift");
lblCasePerPallet.Text = _textoLabels.readStatement(formName, _idioma, "lblCasePerPallet");
linkPrint.InnerText = _textoLabels.readStatement(formName, _idioma, "linkPrint");
btnSalir.Text = _textoLabels.readStatement(formName, _idioma, "btnExit");
lblMsgMcnoActiveStr = _textoLabels.readStatement(formName, _idioma, "MachineLbl");
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
lblError.Text = String.Empty;
var item = txtItem.Text.Trim().ToUpper();
var warehouse = txtWarehouse.Text.Trim().ToUpper();
var location = txtLocation.Text.Trim().ToUpper();
var lot = Session["Lot"].ToString().ToUpper();
var cantidad = Convert.ToDouble(Request.Form["txtQuantity"].ToString().Trim(), CultureInfo.InvariantCulture.NumberFormat);
var cdis = Request.Form["slReasons"].ToString().Trim();
var obse = Request.Form["txtComments"].ToString().Trim();
var VariableAuxSuno = Request.Form["txtSupplier"].ToString().Trim();
var suno = string.IsNullOrEmpty(VariableAuxSuno) ? string.Empty : Request.Form["txtSupplier"].ToString().Trim();
var reasondesc = Request.Form["lblReasonDesc"];
if (lot == string.Empty)
{
lblError.Text = Thelotcantbeempty;
return;
}
if (reasondesc == null)
{
reasondesc = "Adhesion";
}
if (cantidad > Convert.ToDouble(_stock, CultureInfo.InvariantCulture.NumberFormat))
{
lblError.Text = mensajes("quantexceed");
return;
}
Ent_twhwmd300 data = new Ent_twhwmd300()
{
loca = location
};
var validaLocation = _idaltwhwmd300.listaRegistro_ObtieneAlmacen(ref data, ref strError);
if (txSloc.Value.ToString().Trim() == "1")
{
if (validaLocation.Rows.Count > 0)
{
if (Convert.ToInt32(validaLocation.Rows[0]["LOCT"]) != 5)
{
lblError.Text = mensajes("bulklocation");
return;
}
}
else
{
lblError.Text = mensajes("locationnotexists");
return;
}
}
var validarRegistro = _idaltticol116.findRecordByWarehouseItemLocation(ref item, ref warehouse, ref location, ref strError);
if (validarRegistro.Rows.Count > 0)
{
//var validarUpdate = _idaltticol116.updateRecordRejectedWarehouse(ref item, ref warehouse, ref location, ref cantidad, ref strError);
Ent_tticol116 data116 = new Ent_tticol116()
{
item = item,
cwar = warehouse,
loca = location == String.Empty ? " " : location,
clot = lot == String.Empty ? " " : lot,
qtyr = Convert.ToDouble(cantidad),
cdis = cdis,
obse = obse == String.Empty ? " " : obse,
logr = HttpContext.Current.Session["user"].ToString(),
suno = suno == String.Empty ? " " : suno
};
var validInsertaux = _idaltticol116.insertarRegistro(ref data116, ref strError);
if (validInsertaux > 0)
{
lblError.Text = String.Empty;
lblConfirm.Text = mensajes("msjupdate");
divTable.InnerHtml = String.Empty;
divBtnGuardar.Visible = false;
txtItem.Text = String.Empty;
txtWarehouse.Text = String.Empty;
txtLocation.Text = String.Empty;
txtLot.Text = String.Empty;
var rutaServ = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + item.Trim().ToUpper() + "&code=Code128&dpi=96";
imgCodeItem.Src = !string.IsNullOrEmpty(item) ? rutaServ : "";
var rutaServQty = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + cantidad.ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
imgQty.Src = !string.IsNullOrEmpty(cantidad.ToString()) ? rutaServQty : "";
lblValueDescription.Text = hdfDescItem.Value;
lblDescRejectQty.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblRejectedQty"), " ", cantidad);
lblDescPrintedBy.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblPrintedBy"), " ", HttpContext.Current.Session["user"].ToString());
lblValueLot.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblDescLot"), " ", lot);
lblComments.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblDescComments"), " ", obse);
lblValueReason.Text = reasondesc;
divLabel.Visible = true;
divBotones.Visible = true;
}
else
{
lblError.Text = mensajes("errorupdt");
return;
}
}
else
{
Ent_tticol116 data116 = new Ent_tticol116()
{
item = item,
cwar = warehouse,
loca = location == String.Empty ? " " : location,
clot = lot == String.Empty ? " " : lot,
qtyr = cantidad,
cdis = cdis,
obse = obse == String.Empty ? " " : obse,
logr = HttpContext.Current.Session["user"].ToString(),
suno = suno == String.Empty ? " " : suno
};
var validInsert = _idaltticol116.insertarRegistro(ref data116, ref strError);
if (validInsert > 0)
{
lblError.Text = String.Empty;
lblConfirm.Text = mensajes("msjsave");
divTable.InnerHtml = String.Empty;
divBtnGuardar.Visible = false;
txtItem.Text = String.Empty;
txtWarehouse.Text = String.Empty;
txtLocation.Text = String.Empty;
txtLot.Text = String.Empty;
var rutaServ = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + item.Trim().ToUpper() + "&code=Code128&dpi=96";
imgCodeItem.Src = !string.IsNullOrEmpty(item) ? rutaServ : "";
var rutaServQty = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + cantidad.ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
imgQty.Src = !string.IsNullOrEmpty(cantidad.ToString()) ? rutaServQty : "";
lblValueDescription.Text = hdfDescItem.Value;
lblDescRejectQty.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblRejectedQty"), " ", cantidad);
lblDescPrintedBy.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblPrintedBy"), " ", HttpContext.Current.Session["user"].ToString());
lblValueLot.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblDescLot"), " ", lot);
lblComments.Text = String.Concat(_textoLabels.readStatement(formName, _idioma, "lblDescComments"), " ", obse);
lblValueReason.Text = reasondesc;
divLabel.Visible = true;
divBotones.Visible = true;
}
else
{
lblError.Text = mensajes("errorsave");
return;
}
}
}
protected void CargarIdioma()
{
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
lblSequence.Text = _textoLabels.readStatement(formName, _idioma, "lblSequence");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
//lblDefectiveMaterial.Text = _textoLabels.readStatement(formName, _idioma, "lblDefectiveMaterial");
lblDefectiveMaterial2.Text = _textoLabels.readStatement(formName, _idioma, "lblDefectiveMaterial");
lblDmtNumber.Text = _textoLabels.readStatement(formName, _idioma, "lblDmtNumber");
lblDmtNumber2.Text = _textoLabels.readStatement(formName, _idioma, "lblDmtNumber");
//lblInhouse.Text = _textoLabels.readStatement(formName, _idioma, "lblInhouse");
lblPurchased.Text = _textoLabels.readStatement(formName, _idioma, "lblPurchased");
//lblOperCom.Text = _textoLabels.readStatement(formName, _idioma, "lblOperCom");
//lblProductCode.Text = _textoLabels.readStatement(formName, _idioma, "lblProductCode");
lblProductCode2.Text = _textoLabels.readStatement(formName, _idioma, "lblProductCode");
//lblTotalQty.Text = _textoLabels.readStatement(formName, _idioma, "lblTotalQty");
//lblWorkOrderFinish.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
lblWorkOrder2.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
//lblProductDescription.Text = _textoLabels.readStatement(formName, _idioma, "lblProductDescription");
lblProductDescription2.Text = _textoLabels.readStatement(formName, _idioma, "lblProductDescription");
//lblDate.Text = _textoLabels.readStatement(formName, _idioma, "lblDate");
lblDate2.Text = _textoLabels.readStatement(formName, _idioma, "lblDate");
lblPrintedBy.Text = _textoLabels.readStatement(formName, _idioma, "lblPrintedBy");
lblPrintedBy2.Text = _textoLabels.readStatement(formName, _idioma, "lblPrintedBy");
lblReason.Text = _textoLabels.readStatement(formName, _idioma, "lblReason");
lblReason2.Text = _textoLabels.readStatement(formName, _idioma, "lblReason");
lblInternalMaterial.Text = _textoLabels.readStatement(formName, _idioma, "lblInternalMaterial");
btnPrint.InnerText = _textoLabels.readStatement(formName, _idioma, "btnPrint");
///Lbl jc
lblDescription.Text = _textoLabels.readStatement(formName, _idioma, "lblValueDescripcion");
//-------------------------------------
lblMachineTitle.Text = _textoLabels.readStatement(formName, _idioma, "lblMachineTitle");
//LblMachineId.val();
//
lblRejected.Text = _textoLabels.readStatement(formName, _idioma, "lblRejected");
//--------------------------------------
LblDisposition.Text = _textoLabels.readStatement(formName, _idioma, "LblDisposition");
//LblDispositionValue.val();
//
LblWorkOrderTitle.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
//---------------------------------------
lblValueFecha.Text = _textoLabels.readStatement(formName, _idioma, "lblDate");
//---------------------------------------
lblReason.Text = _textoLabels.readStatement(formName, _idioma, "lblReason");
//---------------------------------------
lblComments.Text = _textoLabels.readStatement(formName, _idioma, "lblComments");
}
protected void CargarIdioma()
{
BaanFusionTittle = _textoLabels.readStatement(formName, _idioma, "BaanFusionTittle");
CommandnamenotrecogizedLoginFailure = _textoLabels.readStatement(formName, _idioma, "CommandnamenotrecogizedLoginFailure");
Incorrectuserorpassword = _textoLabels.readStatement(formName, _idioma, "Incorrectuserorpassword");
lblInformation.Text = _textoLabels.readStatement(formName, _idioma, "lblInformation");
lblEncLogin.Text = _textoLabels.readStatement(formName, _idioma, "lblEncLogin");
UserNameLabel.Text = _textoLabels.readStatement(formName, _idioma, "UserNameLabel");
PasswordLabel.Text = _textoLabels.readStatement(formName, _idioma, "PasswordLabel");
LoginButton.Text = _textoLabels.readStatement(formName, _idioma, "LoginButton");
lblInformation1.Text = _textoLabels.readStatement(formName, _idioma, "lblInformation1");
lblEncLogin1.Text = _textoLabels.readStatement(formName, _idioma, "lblEncLogin1");
ddlIdioma1.Text = _textoLabels.readStatement(formName, _idioma, "ddlIdioma1");
lblCurrentPassword.Text = _textoLabels.readStatement(formName, _idioma, "lblCurrentPassword");
lblNewPassword.Text = _textoLabels.readStatement(formName, _idioma, "lblNewPassword");
lblConfirmPassword.Text = _textoLabels.readStatement(formName, _idioma, "lblConfirmPassword");
btnChangePassword.Text = _textoLabels.readStatement(formName, _idioma, "btnChangePassword");
ddlIdioma.SelectedValue = _idioma;
}
protected void CargarIdioma()
{
lblNumeroOrden.Text = _textoLabels.readStatement(formName, _idioma, "lblNumeroOrden");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
lblOrden.Text = _textoLabels.readStatement(formName, _idioma, "lblOrden");
lblArticulo.Text = _textoLabels.readStatement(formName, _idioma, "lblArticulo");
lblWareHouse.Text = _textoLabels.readStatement(formName, _idioma, "lblWareHouse");
lblTotal.Text = _textoLabels.readStatement(formName, _idioma, "lblTotal");
lblDelivered.Text = _textoLabels.readStatement(formName, _idioma, "lblDelivered");
lblToReceive.Text = _textoLabels.readStatement(formName, _idioma, "lblToReceive");
lblConfirmed.Text = _textoLabels.readStatement(formName, _idioma, "lblConfirmed");
lblUnit.Text = _textoLabels.readStatement(formName, _idioma, "lblUnit");
btnGuardar.Text = _textoLabels.readStatement(formName, _idioma, "btnGuardar");
}
protected void CargarIdioma()
{
lblNumeroRecepcion.Text = _textoLabels.readStatement(formName, _idioma, "lblNumeroRecepcion");
btnConsultarRecepcion.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultarRecepcion");
btnGuardarRecepcion.Text = _textoLabels.readStatement(formName, _idioma, "btnGuardarRecepcion");
}
public DataTable listaRegistrosOrden_ParamMRB(ref Ent_tticol127 ParametrosIn, ref string strError, ref string strOrden, bool print = false)
{
//strSQL = "SELECT RTRIM(col127.t$cwar) waremrb FROM " + owner + ".tticol127" + env + " col127 " +
// "WHERE upper(col127.t$user) = '" + ParametrosIn.user + "'";
//Dictionary<string, object> parametersOut = new Dictionary<string, object>();
try
{
//consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true);
//if (consulta.Rows.Count < 1)
//{
// strError = "User doesn't have warehouse MRB Setting.";
//}
//else
//{
strwareh = ParametrosIn.cwar.ToUpper();
//Valido el item digitado
paramList = new Dictionary <string, object>();
paramList.Add(":T$ITEM", ParametrosIn.item.ToUpper());
//strSQL =
// "select ibd001.t$item AS item, ibd001.t$dsca AS descitem, ibd001.t$cuni AS unit, ibd001.t$cwar AS ware, ibd001.t$kltc as mlot, ipu001.t$otbp as proveedor, com100.t$nama as nombre,col020.t$pent AS factorkg " +
// " from " + owner + ".ttcibd001" + env + " ibd001 " +
// " left join " + owner + ".ttdipu001" + env + " ipu001 on ipu001.t$item = ibd001.t$item " +
// " left join " + owner + ".ttccom100" + env + " com100 on com100.t$bpid = ipu001.t$otbp " +
// " left join " + owner + ".ttccol020" + env + " col020 on col020.t$item = ibd001.t$item " +
// "where trim(ibd001.t$item)=TRIM('" + ParametrosIn.item.ToUpper() + "')";
//"select ibd001.t$item AS item, ibd001.t$dsca AS descitem, ibd001.t$cuni AS unit, ibd001.t$cwar AS ware, ibd001.t$kltc as mlot, ipu001.t$otbp as proveedor, com100.t$nama as nombre,col020.t$pent AS factorkg " +
//" from " + owner + ".ttcibd001" + env + " ibd001 " +
//" left join BAAN.ttdipu001140 ipu001 on ipu001.t$item = ibd001.t$item " +
//" left join BAAN.ttccom100140 com100 on com100.t$bpid = ipu001.t$otbp " +
//" left join BAAN.ttccol020140 col020 on col020.t$item = ibd001.t$item " +
//"where trim(ibd001.t$item)=TRIM('[:T$ITEM]')"
strSQL = recursos.readStatement(method.ReflectedType.Name, "listaRegistrosOrden_ParamMRB", ref owner, ref env, tabla, paramList);
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true);
if (string.IsNullOrEmpty(consulta.Rows[0]["factorkg"].ToString()))
{
strError = _textoLabels.readStatement(formName, _idioma, "lblFactorNull");
}
if (consulta.Rows.Count < 1)
{
strError = "Item doesn't Exist in Baan.";
}
else
{
if (consulta.Rows[0]["MLOT"].ToString() == "1")
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$ITEM", ParametrosIn.item.ToUpper());
paramList.Add(":T$CLOT", ParametrosIn.lote.ToUpper());
//Validar el lote digitado
//strSQL = "select ltc100.t$clot lot, ltc100.t$orno orden from " + owner + ".twhltc100" + env + " ltc100 " +
// "where trim(ltc100.t$item)='" + ParametrosIn.item.ToUpper() + "' " +
// "and trim(ltc100.t$clot)='" + ParametrosIn.lote.ToUpper() + "'";
//"select ltc100.t$clot lot, ltc100.t$orno orden from BAAN.twhltc100140 ltc100 " +
//"where trim(ltc100.t$item)='[:T$ITEM]' " +
//"and trim(ltc100.t$clot)='[:T$CLOT]'"
strSQL = recursos.readStatement(method.ReflectedType.Name, "selecttwhltc100", ref owner, ref env, tabla, paramList);
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Lot doesn't Exist.";
}
else
{
strOrden = consulta.Rows[0]["orden"].ToString();
//Validar Cantidad Item, Warehouse, Lot y bodega MRB
//strSQL = "select inr140.t$stks stock, inr140.t$cwar warehouse, inr140.t$item item, inr140.t$clot lot, ibd001.t$dsca desci, ibd001.t$cuni unidad, " +
// "ipu001.t$otbp proveedor, com100.t$nama nombre " +
// "from " + owner + ".twhinr140" + env + " inr140 " +
// "inner join " + owner + ".ttcibd001" + env + " ibd001 on ibd001.t$item = inr140.t$item " +
// "left join " + owner + ".ttdipu001" + env + " ipu001 on ipu001.t$item = ibd001.t$item " +
// "left join " + owner + ".ttccom100" + env + " com100 on com100.t$bpid = ipu001.t$otbp " +
// "where trim(inr140.t$item)=trim('" + ParametrosIn.item.ToUpper() + "') " +
// "and trim(inr140.t$clot)=trim('" + ParametrosIn.lote.ToUpper() + "') " +
// "and trim(inr140.t$cwar) = trim('" + strwareh.ToUpper() + "')";
paramList = new Dictionary <string, object>();
paramList.Add(":T$ITEM", ParametrosIn.item.ToUpper());
paramList.Add(":T$CLOT", ParametrosIn.lote.ToUpper());
paramList.Add(":T$CWAR", strwareh.ToUpper());
//"select inr140.t$stks stock, inr140.t$cwar warehouse, inr140.t$item item, inr140.t$clot lot, ibd001.t$dsca desci, ibd001.t$cuni unidad, " +
//"ipu001.t$otbp proveedor, com100.t$nama nombre " +
//"from baan.twhinr140140 inr140 " +
//"inner join bann.ttcibd001140 ibd001 on ibd001.t$item = inr140.t$item " +
//"left join bann.ttdipu001140 ipu001 on ipu001.t$item = ibd001.t$item " +
//"left join bann.ttccom100140 com100 on com100.t$bpid = ipu001.t$otbp " +
//"where trim(inr140.t$item)=trim('[:T$ITEM]') " +
//"and trim(inr140.t$clot)=trim('[:T$CLOT]') " +
//"and trim(inr140.t$cwar) = trim('[:T$CWAR]')";
strSQL = recursos.readStatement(method.ReflectedType.Name, "selecttwhinr140", ref owner, ref env, tabla, paramList);
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Item doesn't have stock on MRB Warehouse.";
}
}
return(consulta);
}
else
{
//Validar Cantidad Item, Warehouse y bodega MRB
paramList = new Dictionary <string, object>();
paramList.Add(":T$ITEM", ParametrosIn.item.ToUpper());
paramList.Add(":T$CWAR", strwareh.ToUpper());
//strSQL = "select inr140.t$stks stock, inr140.t$cwar warehouse, inr140.t$item item, inr140.t$clot lot, ibd001.t$dsca desci, ibd001.t$cuni unidad, " +
// "ipu001.t$otbp proveedor, com100.t$nama nombre " +
// "from " + owner + ".twhinr140" + env + " inr140 " +
// "inner join " + owner + ".ttcibd001" + env + " ibd001 on ibd001.t$item = inr140.t$item " +
// "left join " + owner + ".ttdipu001" + env + " ipu001 on ipu001.t$item = ibd001.t$item " +
// "left join " + owner + ".ttccom100" + env + " com100 on com100.t$bpid = ipu001.t$otbp " +
// "where trim(inr140.t$item)=trim('" + ParametrosIn.item.ToUpper() + "') " +
// "and trim(inr140.t$cwar) = trim('" + strwareh.ToUpper() + "')";
//select inr140.t$stks stock, inr140.t$cwar warehouse, inr140.t$item item, inr140.t$clot lot, ibd001.t$dsca desci, ibd001.t$cuni unidad,
//ipu001.t$otbp proveedor, com100.t$nama nombre
//from baan.twhinr140140 inr140
//inner join baan.ttcibd001140 ibd001 on ibd001.t$item = inr140.t$item
//left join baan.ttdipu001140 ipu001 on ipu001.t$item = ibd001.t$item
//left join baan.ttccom100140 com100 on com100.t$bpid = ipu001.t$otbp
//where trim(inr140.t$item)=trim('[:T$ITEM]')
//and trim(inr140.t$cwar) = trim('[:T$CWAR]')
strSQL = recursos.readStatement(method.ReflectedType.Name, "selecttwhinr140el", ref owner, ref env, tabla, paramList);
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Item doesn't have stock on MRB Warehouse.";
}
}
return(consulta);
}
//}
}
catch (Exception ex)
{ log.escribirError(strError + " - " + ex.Message, stackTrace.GetFrame(2).GetMethod().Name, metodo, method.ReflectedType.Name); }// throw ex;
return(consulta);
}
protected void CargarIdioma()
{
PalletIDdoesntexists = _textoLabels.readStatement(formName, _idioma, "PalletIDdoesntexists");
Returnedquantityhigherthanpalletsize = _textoLabels.readStatement(formName, _idioma, "Returnedquantityhigherthanpalletsize");
RecordswithoutIDpallet = _textoLabels.readStatement(formName, _idioma, "RecordswithoutIDpallet");
QuantitytoreturnmustbeequalorlessthanPalletIDquantityforpalletId = _textoLabels.readStatement(formName, _idioma, "QuantitytoreturnmustbeequalorlessthanPalletIDquantityforpalletId");
PalletIDstatusdoesntallowreturn = _textoLabels.readStatement(formName, _idioma, "PalletIDstatusdoesntallowreturn");
Theamounttoreturnisinvalid = _textoLabels.readStatement(formName, _idioma, "Theamounttoreturnisinvalid");
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
btnSend.Text = _textoLabels.readStatement(formName, _idioma, "btnSend");
printLabel.Text = _textoLabels.readStatement(formName, _idioma, "printLabel");
btnSave.Text = _textoLabels.readStatement(formName, _idioma, "btnSave");
minlenght.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "regularWorkOrder");
RequiredField.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "requiredWorkOrder");
OrderError.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "customWorkOrder");
//validateReturn.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "btnSave");
//validateQuantity.ErrorMessage = _textoLabels.readStatement(formName, _idioma, "btnSave");
//JC 061221 Corregir los titulos ya que se quitaron dos columnas
//grdRecords.Columns[0].HeaderText = _textoLabels.readStatement(formName, _idioma, "headPosition");
grdRecords.Columns[0].HeaderText = _textoLabels.readStatement(formName, _idioma, "headItem");
grdRecords.Columns[1].HeaderText = _textoLabels.readStatement(formName, _idioma, "headDescription");
//grdRecords.Columns[3].HeaderText = _textoLabels.readStatement(formName, _idioma, "headWarehouse");
grdRecords.Columns[2].HeaderText = _textoLabels.readStatement(formName, _idioma, "headActualQty");
grdRecords.Columns[3].HeaderText = _textoLabels.readStatement(formName, _idioma, "headUnit");
grdRecords.Columns[4].HeaderText = _textoLabels.readStatement(formName, _idioma, "headToReturn");
grdRecords.Columns[5].HeaderText = _textoLabels.readStatement(formName, _idioma, "headLot");
grdRecords.Columns[6].HeaderText = _textoLabels.readStatement(formName, _idioma, "headLot");
}
protected void CargarIdioma()
{
lblWorkOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblWorkOrder");
btnConsultar.Text = _textoLabels.readStatement(formName, _idioma, "btnConsultar");
btnGuardar.Text = _textoLabels.readStatement(formName, _idioma, "btnGuardar");
lblOrder.Text = _textoLabels.readStatement(formName, _idioma, "lblOrder");
lblDescription.Text = _textoLabels.readStatement(formName, _idioma, "lblDescription");
lblQty.Text = _textoLabels.readStatement(formName, _idioma, "lblQty");
lblUnit.Text = _textoLabels.readStatement(formName, _idioma, "lblUnit");
lblLot.Text = _textoLabels.readStatement(formName, _idioma, "lblLot");
lblShift.Text = _textoLabels.readStatement(formName, _idioma, "lblShift");
lblReason.Text = _textoLabels.readStatement(formName, _idioma, "lblReason");
lblRejectedType.Text = _textoLabels.readStatement(formName, _idioma, "lblRejectedType");
lblExactReason.Text = _textoLabels.readStatement(formName, _idioma, "lblExactReason");
lblItem.Text = _textoLabels.readStatement(formName, _idioma, "lblItem");
TheItemcantbeempty = mensajes("TheItemcantbeempty");
TheReasoncantbeempty = mensajes("TheReasoncantbeempty");
TheRejectTypecantbeempty = mensajes("TheRejectTypecantbeempty");
TheCantcantbeempty = mensajes("TheCantcantbeempty");
Thelotcantbeempty = mensajes("Thelotcantbeempty");
}