public int insertarRegistro(ref Ent_twhcol010 parametrosIn, ref string strError) { int retorno = -1; try { retorno = dal.insertarRegistro(ref parametrosIn, ref strError); return(retorno); } catch (Exception ex) { throw new Exception(strError += "\nPila: " + ex.Message); } }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol010 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CLOT", DbType.String, parametros.clot); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.Int32, parametros.sqnb); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, parametros.mitm); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DSCA", DbType.String, parametros.dsca); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWOR", DbType.String, parametros.cwor); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOOR", DbType.String, parametros.loor); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWDE", DbType.String, parametros.cwde); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LODE", DbType.String, parametros.lode); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDL", DbType.Double, Convert.ToDecimal(parametros.qtdl)); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [301]. 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(parameterCollection); }
public int insertarRegistro(ref Ent_twhcol010 parametro, ref string strError) { method = MethodBase.GetCurrentMethod(); bool retorno = false; try { strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla); parametrosIn = AdicionaParametrosComunes(parametro); retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false); return(Convert.ToInt32(retorno)); } catch (Exception ex) { strError = ex.InnerException != null ? ex.Message + " (" + ex.InnerException + ")" : ex.Message; } return(Convert.ToInt32(retorno)); }
protected void btnActualizar_Click(object sender, EventArgs e) { lblConfirm.Text = String.Empty; lblError.Text = String.Empty; var txtCantidadTransferir = txtCantidadTrasnferir.Text.Trim(); var ubicacionDestino = txtUbicacionDestino.Text.Trim().ToUpper(); var cwar = txtSourceLocation.Text.Trim().ToUpper(); var clot = txtNumeroLote.Text.Trim().ToUpper(); if (txtCantidadTransferir == String.Empty || ubicacionDestino == String.Empty) { lblError.Text = mensajes("formempty"); return; } var cantidadTransferir = double.Parse(txtCantidadTransferir, CultureInfo.InvariantCulture.NumberFormat); if (cantidadTransferir == 0) { lblError.Text = mensajes("quantityzero"); return; } if (ubicacionDestino == txtSourceLocation.Text.Trim().ToUpper()) { lblError.Text = mensajes("differentlocation"); return; } var validaUbicacion = _idaltwhwmd300.validateExistsLocation(ref ubicacionDestino, ref cwar, ref strError).Rows; if (validaUbicacion.Count > 0) { var loct = Convert.ToInt32(validaUbicacion[0]["LOCT"].ToString()); var btrr = Convert.ToInt32(validaUbicacion[0]["BTRR"].ToString()); var cantdisponible = double.Parse(txtCantidad.Text.Trim(), CultureInfo.InvariantCulture.NumberFormat); if (loct != 5) { lblError.Text = String.Format(mensajes("locationdesnotload"), ubicacionDestino); return; } if (btrr != 2) { lblError.Text = String.Format(mensajes("locationdesblocked"), ubicacionDestino);; return; } if (cantidadTransferir > cantdisponible) { lblError.Text = String.Format(mensajes("quantitytransfer"), cantidadTransferir, cantdisponible); return; } var consecutivo = _idaltwhcol010.consultarConsecutivoRegistro(ref clot, ref strError); consecutivo = consecutivo + 1; Ent_twhcol010 data010 = new Ent_twhcol010() { clot = clot, sqnb = consecutivo, mitm = txtItem.Text.Trim().ToUpper(), dsca = txtDescription.Text.Trim().ToUpper(), cwor = txtSourceLocation.Text.Trim().ToUpper(), loor = txtUbicacion.Text.Trim().ToUpper(), cwde = txtSourceLocation.Text.Trim().ToUpper(), lode = txtUbicacionDestino.Text.Trim().ToUpper(), qtdl = double.Parse(txtCantidadTrasnferir.Text.Trim(), CultureInfo.InvariantCulture.NumberFormat), cuni = txtCantidadUnidad.Text.Split('-').Last().Trim(), user = HttpContext.Current.Session["user"].ToString(), refcntd = 0, refcntu = 0 }; var validSave = _idaltwhcol010.insertarRegistro(ref data010, ref strError); if (validSave > 0) { lblConfirm.Text = mensajes("msjsave"); trDescription.Visible = false; trSource.Visible = false; trUbicacion.Visible = false; trCantidadUnidad.Visible = false; trCantidad.Visible = false; trDestination.Visible = false; trCantidadTransferir.Visible = false; txtNumeroLote.Enabled = true; txtItem.Enabled = true; txtNumeroLote.Text = String.Empty; txtItem.Text = String.Empty; btnConsultar.Visible = true; btnConsultarSource.Visible = false; btnActualizar.Visible = false; return; } else { lblError.Text = mensajes("errorsave"); return; } } else { lblError.Text = mensajes("locationnotexists"); return; } }
protected void btnTransfer_Click(object sender, EventArgs e) { if (txtItem.Text.Trim() == String.Empty || txtTargetLocation.Text.Trim() == String.Empty || txtTargetQty.Text.Trim() == String.Empty) { lblError.Text = mensajes("formempty"); return; } if (_tipoFormulario == "TO" && slPlant.SelectedValue.Trim() == String.Empty) { lblError.Text = mensajes("formempty"); return; } var item = txtItem.Text.Trim().ToUpper(); var loca = txtTargetLocation.Text.Trim().ToUpper(); var qtdl = double.Parse(txtTargetQty.Text.Trim(), CultureInfo.InvariantCulture.NumberFormat); //Buscar datos del articulo Ent_ttcibd001 data001 = new Ent_ttcibd001() { item = item }; var datosArticulo = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError); if (datosArticulo.Rows.Count <= 0) { lblError.Text = mensajes("itemnotexists"); return; } var dscaitem = datosArticulo.Rows[0]["DESCRIPCION"].ToString(); var cuni = datosArticulo.Rows[0]["UNID"].ToString(); //Buscar almacen de la ubicación+ var loct = "5"; var btrr = "2"; var datosUbicacion = _idaltwhwmd300.findLocationByLoctAndBtrr(ref loct, ref btrr, ref loca, ref strError); if (datosUbicacion.Rows.Count <= 0) { lblError.Text = String.Format(mensajes("targetlocation"), loca); return; } var cwar = datosUbicacion.Rows[0]["CWAR"].ToString(); //Valida si ya existe registro var consecutivo = _tipoFormulario == "TO" ? _idaltwhcol010.consultarConsecutivoMaximo(ref strError) : _idaltwhcol010.consultarConsecutivoMaximo(ref strError); //_idaltwhcol010.consultarConsecutivoRegistroPorItem(ref item, ref loca, ref strError); consecutivo = consecutivo + 1; Ent_twhcol010 data010 = new Ent_twhcol010() { clot = " ", sqnb = consecutivo, mitm = item, dsca = dscaitem, cwor = _tipoFormulario == "TO" ? slPlant.SelectedValue.Trim().ToUpper() : cwar, loor = " ", cwde = cwar, lode = loca, qtdl = qtdl, cuni = cuni, user = HttpContext.Current.Session["user"].ToString(), refcntd = 0, refcntu = 0 }; var validInsert = _idaltwhcol010.insertarRegistro(ref data010, ref strError); if (validInsert > 0) { lblError.Text = String.Empty; lblConfirm.Text = mensajes("msjsave"); txtItem.Text = String.Empty; txtTargetLocation.Text = String.Empty; txtTargetQty.Text = String.Empty; return; } else { lblError.Text = mensajes("errorsave"); return; } }