public int insertarRegistro(ref Ent_tticol032 parametros, ref string strError)
{
int retorno = -1;
try
{
retorno = dal.insertarRegistro(ref parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol032 parametros, bool blnUsarPRetorno = false)
{
string param = string.Empty;
List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();
try
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OORG", DbType.Int32, Convert.ToInt32(parametros.oorg));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.orno);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SQNB", DbType.String, parametros.sqnb);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OSET", DbType.Int32, Convert.ToInt32(parametros.oset));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PONO", DbType.Int32, Convert.ToInt32(parametros.pono));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$SEQN", DbType.Int32, Convert.ToInt32(parametros.seqn));
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$CWAR", DbType.String, parametros.cwar);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTDL", DbType.Decimal, Convert.ToDecimal(parametros.qtdl).ToString("#.##0,0000"));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$USER", DbType.String, parametros.user);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.String, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.String, 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)
{
throw (ex);
}
return(parameterCollection);
}
public int insertarRegistro(ref Ent_tticol032 parametros, 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(parametros);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
return(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
strError = "Error when inserting data [tticol032]. Try again or contact your administrator";
log.escribirError(strError + Console.Out.NewLine + ex.Message, method.Module.Name, method.Name, method.ReflectedType.Name);
}
return(Convert.ToInt32(retorno));
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
lblError.Text = String.Empty;
lblConfirm.Text = String.Empty;
if (txtLocation.Text.Trim() == String.Empty || lblValueLocation2.Text.Trim() == String.Empty)
{
lblError.Text = mensajes("locationblank");
return;
}
if (float.Parse(lblValueQuantity.Text) < 1)
{
lblError.Text = mensajes("quantityzero");
return;
}
//Valida la ubicacion del producto (INS o REC)
var item = lblValueArticulo.Text.Split('-')[0].Trim().ToUpper() + "-" + lblValueArticulo.Text.Split('-')[1].Trim().ToUpper();
var origen = slOrigen.SelectedValue;
var dsca = lblValueArticulo.Text.Split('-')[2].Trim().ToUpper();
var validaUbicacion = _idaltqmptc011.findRecordByItemConOrigen(ref item, ref origen, ref strError);
var location = validaUbicacion.Rows.Count > 0 ? "INS" : "REC";
//Valida si el articulo maneja lote
Ent_ttcibd001 data001 = new Ent_ttcibd001()
{
item = item
};
var validaArticulo = _idalttcibd001.listaRegistro_ObtieneDescripcionUnidad(ref data001, ref strError);
var consultaOrden = new DataTable();
var numeroOrden = lblValueOrden.Text.Trim();
var numeroOrdenPallet = txtNumeroOrden.Text.Trim().ToUpper();
var clot = validaArticulo.Rows[0]["KLTC"].ToString();
var cwar = _validaAlmacen.Rows[0]["ALM"].ToString();
if (clot != "1")
{
consultaOrden = _idaltwhcol124.findBySqnbPdnoNoClot(ref location, ref cwar, ref numeroOrdenPallet, ref strError);
}
else
{
consultaOrden = _idaltwhcol124.findBySqnbPdnoYesClot(ref location, ref cwar, ref numeroOrdenPallet, ref strError);
}
if (consultaOrden.Rows.Count > 0)
{
var QTYPEND = float.Parse(consultaOrden.Rows[0]["QTYPEND"].ToString()).ToString("0.00");
var QTDL = float.Parse(lblValueQuantity.Text == "" ? "0" : lblValueQuantity.Text).ToString("0.00");
var STRQDPU = float.Parse((float.Parse(QTYPEND) - float.Parse(lblValuePorAprobar.Text.Trim())).ToString()).ToString("0.00");
var CWAR = consultaOrden.Rows[0]["CWAR"].ToString();
var LOTE = consultaOrden.Rows[0]["CLOT"].ToString();
//Validar que el almacen sea el mismo de la orden
if (CWAR != cwar)
{
lblError.Text = String.Format(mensajes("diferentcwar"), txtLocation.Text.ToUpper(), CWAR);
return;
}
//Validar que exista ubicacion, que sea tipo 5-carga y que no este bloqueado
Ent_twhwmd300 data300 = new Ent_twhwmd300()
{
loca = txtLocation.Text.Trim(),
cwar = cwar
};
var validarUbicacionTipo = _idaltwhwmd300.listaRegistro_AlmacenUbicaion(ref data300, ref strError);
if (validarUbicacionTipo.Rows.Count > 0)
{
if (float.Parse(QTDL) > float.Parse(QTYPEND))
{
lblError.Text = String.Format(mensajes("suggestedquantityannounced"), QTDL, QTYPEND);
return;
}
//
//Validar que la cantidad ingresada no sea mayor a la cantidad disponible por ubicar
if (float.Parse(QTDL) > float.Parse(STRQDPU))
{
lblError.Text = String.Format(mensajes("suggestedquantityavailable"), numeroOrden, QTDL, STRQDPU);
return;
}
//Verificar si ya existe un registro para esta orden
//var consecutivo = _idaltticol032.consultarConsecutivoRegistro(ref numeroOrden, ref strError);
//consecutivo = consecutivo + 1;
Ent_twhinh210 datawhinh210 = new Ent_twhinh210()
{
orno = lblValueOrden.Text,
oorg = origen,
item = item,
clot = LOTE
};
var consultaDatosOrden = _idaltwhinh210.findByOrderNumberAndOrigin(ref datawhinh210, ref strError);
if (consultaDatosOrden.Rows.Count < 1)
{
lblError.Text = mensajes("210empty");
return;
}
//T$OORG AS OORG, T$ORNO AS ORNO, T$OSET AS OSET, T$PONO AS PONO, T$SEQN AS SEQN
var oorg = consultaDatosOrden.Rows[0]["OORG"].ToString();
var orno = consultaDatosOrden.Rows[0]["ORNO"].ToString();
var oset = consultaDatosOrden.Rows[0]["OSET"].ToString();
var pono = consultaDatosOrden.Rows[0]["PONO"].ToString();
var seqn = consultaDatosOrden.Rows[0]["SEQN"].ToString();
Ent_tticol032 dataticol032 = new Ent_tticol032()
{
oorg = Convert.ToInt32(oorg),
orno = orno,
sqnb = numeroOrdenPallet,
oset = Convert.ToInt32(oset),
pono = Convert.ToInt32(pono),
seqn = Convert.ToInt32(seqn),
mitm = item.Trim(),
dsca = dsca,
cwar = cwar,
loca = lblValueLocation2.Text,
qtdl = Convert.ToDecimal(QTDL),
cuni = lblValueUnit.Text,
mess = " ",
user = HttpContext.Current.Session["user"].ToString(),
refcntd = 0,
refcntu = 0
};
var validSave = _idaltticol032.insertarRegistro(ref dataticol032, ref strError);
if (validSave > 0)
{
lblConfirm.Text = mensajes("msjsave");
divTable.Visible = false;
txtNumeroOrden.Enabled = true;
txtNumeroOrden.Text = String.Empty;
return;
}
else
{
lblError.Text = mensajes("errorsave");
return;
}
}
else
{
lblError.Text = String.Format(mensajes("locationnotexist"), data300.loca);
return;
}
}
else
{
lblError.Text = mensajes("orderemptytwo");
}
}
