public static string verifyLot(string ITEM, string LOT) { Ent_twhcol130131 MyObj = new Ent_twhcol130131(); Ent_twhltc100 data100 = new Ent_twhltc100() { item = ITEM, clot = LOT }; var DTLot = dal100.listaRegistro_Clot(ref data100, ref strError); if (DTLot.Rows.Count > 0) { var MyObjDT = DTLot.Rows[0]; MyObj.Error = false; MyObj.errorMsg = string.Empty; MyObj.TipeMsgJs = string.Empty; } else { MyObj.Error = true; MyObj.errorMsg = Lotcodedoesntexist; MyObj.TipeMsgJs = "Label"; } return(JsonConvert.SerializeObject(MyObj)); }
public DataTable listaRegistro_Clot(ref Ent_twhltc100 Parametros, ref string strError) { method = MethodBase.GetCurrentMethod(); paramList = new Dictionary <string, object>(); paramList.Add(":T$CLOT", Parametros.clot.Trim()); paramList.Add(":T$ITEM", Parametros.item.Trim()); strSQL = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList); try { consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSQL, ref parametersOut, null, true); if (consulta.Rows.Count < 1) { strError = "That Lot doesn't be Asociated to the Item."; } } catch (Exception ex) { strError = "Error to the search sequence [twhltc100]. Try again or contact your administrator \n "; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(consulta); }
public DataTable listaRegistros_ObtieneItem(ref Ent_twhltc100 Parametros, ref string strError) { DataTable retorno; try { retorno = dal.listaRegistros_ObtieneItem(ref Parametros, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(ex.InnerException.ToString()); } }
protected void btnConsultar_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 = txtLot.Text.Trim().ToUpper(); if (string.IsNullOrEmpty(txtLot.Text.Trim().ToUpper()) == true) { Session["Lot"] = string.Empty; } else { Session["Lot"] = txtLot.Text.Trim().ToUpper(); } Ent_ttcibd001 data001 = new Ent_ttcibd001() { item = item }; _validaItem = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError); if (_validaItem.Rows.Count < 1) { lblError.Text = mensajes("itemnotexists"); return; } var kltc = Convert.ToInt32(_validaItem.Rows[0]["KLTC"].ToString()); manejalote = kltc; _validaWarehouse = _idalttcmcs003.findRecordByCwar(ref warehouse, ref strError); if (_validaWarehouse.Rows.Count < 1) { lblError.Text = mensajes("warehousenotexists"); return; } Ent_twhwmd200 data200 = new Ent_twhwmd200() { cwar = warehouse }; var manejoUbicacionAlmacen = Convert.ToInt32(_idaltwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref data200, ref strError).Rows[0]["LOC"]); manejaubicacion = manejoUbicacionAlmacen; if (manejoUbicacionAlmacen == 1) { _validaUbicacion = _idaltwhwmd300.validateExistsLocation(ref location, ref warehouse, ref strError); if (_validaUbicacion.Rows.Count < 1) { lblError.Text = mensajes("Location doesn't exist."); return; } } if (kltc == 1) { Ent_twhltc100 data100 = new Ent_twhltc100() { item = item, clot = lot }; _validaItemLote = _idaltwhltc100.listaRegistro_Clot(ref data100, ref strError); if (_validaItemLote.Rows.Count < 1) { lblError.Text = mensajes("lotnotexists"); return; } } var consultaCantidad = new DataTable(); if (manejoUbicacionAlmacen == 1) { if (kltc == 1) { consultaCantidad = _idaltwhinr140.consultaPorAlmacenItemUbicacionLote(ref warehouse, ref item, ref location, ref lot, ref strError); } else { consultaCantidad = _idaltwhinr140.consultaPorAlmacenItemUbicacion(ref warehouse, ref item, ref location, ref strError); } } else { if (kltc == 1) { consultaCantidad = _idaltwhinr140.consultaPorAlmacenItemLote(ref warehouse, ref item, ref lot, ref strError); } else { consultaCantidad = _idaltwhinr140.consultaCantidadItemLote(ref warehouse, ref item, ref strError); } } //_stock = (Decimal)0; if (consultaCantidad.Rows.Count > 0) { //_stock = Convert.ToDecimal(consultaCantidad.Rows[0]["STKS"].ToString()); _stock = consultaCantidad.Rows[0]["STKS"].ToString(); } //if (_stock == 0) if (_stock == "0") { lblError.Text = mensajes("notstock"); return; } divBotones.Visible = false; divLabel.Visible = false; divBtnGuardar.Visible = true; makeTable(); }
protected void btnGuardar_Click(object sender, EventArgs e) { var pdno = txtWorkOrder.Text.Trim().ToUpper(); var machine = " "; var seqn = 1; var item = slItems.SelectedValue.Trim().ToUpper(); var clot = slLot.SelectedValue.Trim().ToUpper(); var reason = slReason.SelectedValue.Trim().ToUpper(); var rejectType = slRejectType.SelectedValue.Trim().ToUpper(); var qtyr = double.Parse(txtQty.Text.Trim(), CultureInfo.InvariantCulture.NumberFormat); if (item == string.Empty) { lblError.Text = TheItemcantbeempty; return; } if (reason == string.Empty) { lblError.Text = TheReasoncantbeempty; return; } if (rejectType == string.Empty) { lblError.Text = TheRejectTypecantbeempty; return; } if (qtyr.ToString() == string.Empty) { lblError.Text = TheCantcantbeempty; return; } var consultaMaquina = _idaltticol011.findRecordByPdno(ref pdno, ref strError); if (consultaMaquina.Rows.Count > 0) { machine = consultaMaquina.Rows[0]["MCNO"].ToString().Trim(); } var registroItem = _consultaInformacionPedido.AsEnumerable().Where(x => x["SITM"].ToString().Trim() == item).FirstOrDefault(); var kltc = registroItem["KLTC"].ToString(); var pono = registroItem["PONO"].ToString(); if (kltc == "1") { if (clot == string.Empty) { lblError.Text = Thelotcantbeempty; return; } Ent_twhltc100 data100 = new Ent_twhltc100() { item = item, clot = clot }; var validaLote = _idaltwhltc100.listaRegistro_Clot(ref data100, ref strError); if (validaLote.Rows.Count < 0) { lblError.Text = mensajes("lotnotexists"); return; } } var consultaSecuencia = _idaltticol100.findMaxSeqnByPdnoPono(ref pdno, ref pono, ref strError); if (consultaSecuencia.Rows.Count > 0) { seqn = Convert.ToInt32(consultaSecuencia.Rows[0]["SEQN"]) + 1; } Ent_tticol100 dataticol100 = new Ent_tticol100() { //dsca = .Text, pdno = pdno, pono = Convert.ToInt32(pono), seqn = seqn, mcno = machine, item = item, qtyr = qtyr, shif = txtShift.Text.Trim().ToUpper(), cdis = slReason.SelectedValue.Trim().ToUpper(), rejt = Convert.ToInt32(slRejectType.SelectedValue), clot = slLot.SelectedValue == "" ? " " : slLot.SelectedValue.Trim().ToUpper(), obse = txtExactReasons.InnerText, logr = HttpContext.Current.Session["user"].ToString(), disp = 4, proc = 1, Unit = txtUnit.Text, logn = HttpContext.Current.Session["user"].ToString(), mess = "0" }; var validaInsert = _idaltticol100.insertRecord(ref dataticol100, ref strError); if (validaInsert > 0) { lblError.Text = String.Empty; lblConfirm.Text = mensajes("msjsave"); divTable.Visible = false; divBtnGuardar.Visible = false; txtWorkOrder.Text = String.Empty; MakeLabel(dataticol100); divLabel.Visible = true; divBotones.Visible = true; } else { lblError.Text = mensajes("errorsave"); return; } }
protected void btnConsultar_Click(object sender, EventArgs e) { lblConfirm.Text = String.Empty; lblError.Text = String.Empty; if (txtItem.Text.Trim() != String.Empty) { var withLot = true; var consultaInformacion = new DataTable(); var ITEM = txtItem.Text.Trim().ToUpper(); var CLOT = txtNumeroLote.Text.Trim().ToUpper(); Ent_twhltc100 data = new Ent_twhltc100() { item = ITEM, clot = CLOT }; Ent_tticol127 dataticol127 = new Ent_tticol127() { user = HttpContext.Current.Session["user"].ToString() }; var validaAlmacenUsuario = _idaltticol127.listaRegistro_ObtieneAlmacen(ref dataticol127, ref strError); if (validaAlmacenUsuario.Rows.Count < 1) { lblError.Text = mensajes("Usuario no tiene definido el almacen, por favor comuniquese con el administrador."); return; } if (txtNumeroLote.Text.Trim() != String.Empty) { var validaItem = _idaltwhltc100.listaRegistro_Clot(ref data, ref strError); if (validaItem.Rows.Count > 0) { consultaInformacion = _idalttcibd001.findRecordTransfers(ref ITEM, ref withLot, ref strError); } } else { withLot = false; consultaInformacion = _idalttcibd001.findRecordTransfers(ref ITEM, ref withLot, ref strError); } if (consultaInformacion.Rows.Count > 0) { hdfUnidad.Value = consultaInformacion.Rows[0]["CUNI"].ToString(); hdfFactor.Value = consultaInformacion.Rows[0]["CONV"].ToString(); txtSourceLocation.Text = validaAlmacenUsuario.Rows[0]["BODEGA"].ToString(); txtDescription.Text = consultaInformacion.Rows[0]["DSCA"].ToString(); txtNumeroLote.Text = txtNumeroLote.Text.Trim().ToUpper(); txtNumeroLote.Enabled = false; txtItem.Text = txtItem.Text.Trim().ToUpper(); txtItem.Enabled = false; trDescription.Visible = true; trSource.Visible = true; trUbicacion.Visible = true; btnConsultar.Visible = false; btnConsultarSource.Visible = true; } else { txtNumeroLote.Text = txtNumeroLote.Text.Trim().ToUpper(); txtNumeroLote.Enabled = true; txtItem.Text = txtItem.Text.Trim().ToUpper(); txtItem.Enabled = true; trDescription.Visible = false; trSource.Visible = false; trUbicacion.Visible = false; btnConsultar.Visible = true; btnConsultarSource.Visible = false; lblError.Text = withLot ? mensajes("lotitemincorrect") : mensajes("itemincorrect"); return; } } else { lblError.Text = mensajes("itemblank"); return; } }