// my nuevo metodo
public bool insertarRegistroAux(Ent_tticol020 Objtticol020)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
paramList = new Dictionary <string, object>();
string strError = string.Empty;
paramList.Add(":T$PDNO", Objtticol020.pdno.Trim().ToUpper().ToString());
paramList.Add(":T$MITM", Objtticol020.mitm.ToUpper().ToString());
paramList.Add(":T$DSCA", Objtticol020.dsca.ToUpper().ToString());
paramList.Add(":T$QTDL", Objtticol020.qtdl.ToString());
paramList.Add(":T$CUNI", Objtticol020.cuni.ToString());
paramList.Add(":T$MESS", Objtticol020.mess.ToUpper().ToString());
paramList.Add(":T$USER", Objtticol020.user.ToUpper().ToString());
paramList.Add(":T$REFCNTD", Objtticol020.refcntd.ToString());
paramList.Add(":T$REFCNTU", Objtticol020.refcntu.ToString());
try
{
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
return(retorno);
}
catch (Exception ex)
{
strError = "Error when inserting data [col020]. Try again or contact your administrator";
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(retorno);
}
//public int insertarRegistro(ref List<Ent_tticol022> parametros, ref List<Ent_tticol020> parametros020, ref string strError, ref string anuncioautomatico)
//{
// int retorno = -1;
// try
// {
// retorno = dal.insertarRegistro(ref parametros, ref parametros020, ref strError, ref anuncioautomatico);
// return retorno;
// }
// catch (Exception ex)
// {
// throw new Exception(strError += "\nPila: " + ex.Message);
// }
//}
public bool insertarRegistroAux(Ent_tticol022 Objtticol022, Ent_tticol020 Objtticol020)
{
bool retorno = false;
try
{
retorno = dal.insertarRegistroAux(Objtticol022, Objtticol020);
return(retorno);
}
catch (Exception ex)
{
throw new Exception("\nPila: " + ex.Message);
}
}
//my nuevo metodo
public bool insertarRegistroAux(Ent_tticol022 Objtticol022, Ent_tticol020 Objtticol020)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
paramList = new Dictionary <string, object>();
paramList.Add(":T$PDNO", Objtticol022.pdno.Trim().ToUpper().ToString());
paramList.Add(":T$SQNB", Objtticol022.sqnb.ToUpper().ToString());
paramList.Add(":T$PROC", Objtticol022.proc.ToString());
paramList.Add(":T$LOGN", Objtticol022.logn.ToString());
paramList.Add(":T$MITM", Objtticol022.mitm.ToString());
paramList.Add(":T$QTDL", Objtticol022.qtdl.ToString());
paramList.Add(":T$CUNI", Objtticol022.cuni.ToUpper().ToString());
paramList.Add(":T$LOG1", Objtticol022.log1.ToUpper().ToString());
paramList.Add(":T$QTD1", Objtticol022.qtd1.ToString());
paramList.Add(":T$PRO1", Objtticol022.pro1.ToString());
paramList.Add(":T$LOG2", Objtticol022.log2.ToUpper().ToString());
paramList.Add(":T$QTD2", Objtticol022.qtd2.ToString());
paramList.Add(":T$PRO2", Objtticol022.pro2.ToString());
paramList.Add(":T$LOCA", Objtticol022.loca.ToUpper().ToString());
paramList.Add(":T$NORP", Objtticol022.norp.ToString());
paramList.Add(":T$DELE", Objtticol022.dele.ToString());
paramList.Add(":T$LOGD", Objtticol022.logd.ToUpper().ToString());
paramList.Add(":T$REFCNTD", "0");
paramList.Add(":T$REFCNTU", "0");
try
{
string strError = string.Empty;
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
if (retorno)
{
DAL.tticol020 dal020 = new tticol020();
bool intRetorno = dal020.insertarRegistroAux(Objtticol020);
Ent_tticol022 nreg = Objtticol022;
int retorno222 = InsertarRegistroTicol222(ref nreg, ref strError);
}
return(retorno);
}
catch (Exception ex)
{
string strError = "Error when inserting data [col022]. Try again or contact your administrator";
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(retorno);
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol020 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$PDNO", DbType.String, parametros.pdno);
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$QTDL", DbType.Decimal, parametros.qtdl);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUNI", DbType.String, parametros.cuni);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.date);
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.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 [020]. 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);
}
protected void btnSaveInformation_Click(object sender, EventArgs e)
{
var tipoFormulario = Request.QueryString["tipoFormulario"];
tipoFormulario = tipoFormulario != null?tipoFormulario.ToUpper() : "CREATE";
//Valida tipo de formulario y campos en blanco
if (tipoFormulario == "CONFIRM" ? txtConfirmado.Text.Trim() != String.Empty : txtAnunciado.Text != String.Empty)
{
var validateSave = 0;
if (tipoFormulario == "CONFIRM")
{
var orderNumber = txtNumeroOrden.Text.ToUpper();
var consec = 0;
var qtdltisfc001 = _qtdltisfc001;
var qtdlTotal = 0.0M;
//Suma valores QTDL
var sumQtdlticol025 = _idalticol025.sumQtdlByOrderNumber(ref orderNumber, ref strError);
if (sumQtdlticol025.Rows.Count > 0)
{
consec = Convert.ToInt32(sumQtdlticol025.Rows[0]["CONSEC"]) + 1;
var sum = sumQtdlticol025.Rows[0]["SUMQTDL"].ToString();
qtdlTotal = decimal.Parse(qtdltisfc001) + decimal.Parse(sum == "" ? "0" : sum);
}
//Valida que cantidad de confirmado no sea mayor que QTDL Total
if (decimal.Parse(txtConfirmado.Text.Trim().Replace(".", ",")) > qtdlTotal)
{
lblError.Text = mensajes("largerQuant");
return;
}
//Inserta en tabla ticol025
Ent_tticol025 dataticol025 = new Ent_tticol025()
{
pdno = lblOrdenFabricacion.Text.ToUpper(),
sqnb = consec,
mitm = lblItem.Text.ToUpper(),
dsca = lblDescripcionItem.Text.ToUpper(),
qtdl = float.Parse(txtConfirmado.Text.Trim(), CultureInfo.InvariantCulture.NumberFormat),
cuni = lblUnidad.Text.ToUpper(),
user = HttpContext.Current.Session["user"].ToString()
};
validateSave = _idalticol025.insertarRegistro(ref dataticol025, ref strError);
}
else
{
//Inserta en tabl ticol020
Ent_tticol020 dataticol020 = new Ent_tticol020()
{
pdno = lblOrdenFabricacion.Text.ToUpper(),
mitm = lblItem.Text.ToUpper().TrimStart(),
dsca = lblDescripcionItem.Text.ToUpper(),
qtdl = Convert.ToDecimal(txtAnunciado.Text.Trim()),
cuni = lblUnidad.Text.ToUpper(),
mess = " ",
user = HttpContext.Current.Session["user"].ToString()
};
List <Ent_tticol020> listData = new List <Ent_tticol020>();
listData.Add(dataticol020);
validateSave = _idalticol020.insertarRegistro(ref listData, ref strError);
}
//Valida que los procesos en BD sean correctos
if (validateSave > 0)
{
lblError.Text = "";
lblConfirm.Text = mensajes("save");
trDataAditional.Visible = false;
txtConfirmado.Text = "";
txtAnunciado.Text = "";
txtNumeroOrden.Text = "";
txtNumeroOrden.Focus();
return;
}
else
{
lblError.Text = mensajes("error");
return;
}
}
else
{
lblError.Text = mensajes("anunBlank");
return;
}
}
protected bool GuardaAnuncioAutomatico(string _sqnb, string _pdno, string quantannounced)
{
var item = _consultaInformacionOrden.Rows[0]["MITM"].ToString();
var descripcion = _consultaInformacionOrden.Rows[0]["DSCAITEM"].ToString();
var unidad = _consultaInformacionOrden.Rows[0]["CUNI"].ToString();
var pdno = _pdno;
var sqnb = _sqnb;
var qrdr = _consultaInformacionOrden.Rows[0]["QRDR"].ToString();
var qtyreh = Convert.ToDecimal(_consultaInformacionOrden.Rows[0]["QTYREH"].ToString());
var qtyord = Convert.ToDecimal(qrdr.Trim() == String.Empty ? 0.000 : Convert.ToDouble(qrdr) * calcAnuncioOrd);
var qtyrec = Convert.ToDecimal(_consultaInformacionOrden.Rows[0]["QTYREC"].ToString());
var enterqty = Convert.ToDecimal(quantannounced);
if (((qtyrec + enterqty) - qtyreh) > qtyord)
{
lblError.Text = String.Format(mensajes("exceedquantity"), (qtyrec + enterqty), qtyord);
lblConfirm.Text = string.Empty;
return(false);
}
if (enterqty <= 0)
{
lblError.Text = mensajes("quantzero");
lblConfirm.Text = string.Empty;
return(false);
}
var qtdl = "0";
var validarRegistro = _idaltticol022.findBySqnbPdnoAndQtdl(ref pdno, ref sqnb, ref qtdl, ref strError);
if (validarRegistro.Rows.Count > 0)
{
Ent_tticol022 data022 = new Ent_tticol022()
{
qtdl = enterqty,
pdno = pdno,
sqnb = sqnb,
acqt = Convert.ToDecimal(enterqty)
};
var validaUpdate = _idaltticol022.actualizaRegistroAnuncioOrd(ref data022, ref strError);
var validaUpdateCant = _idaltticol022.ActualizarCantidadRegistroTicol222(Convert.ToDecimal(data022.acqt), data022.sqnb);
if (validaUpdate)
{
var dsca = descripcion;
var cuni = unidad;
Ent_tticol020 data020 = new Ent_tticol020()
{
pdno = pdno,
mitm = item.Trim(),
dsca = dsca,
qtdl = enterqty,
cuni = cuni,
mess = " ",
user = _operator,
refcntd = 0,
refcntu = 0
};
List <Ent_tticol020> list = new List <Ent_tticol020>();
list.Add(data020);
var validaSave = _idaltticol020.insertarRegistro(ref list, ref strError);
if (validaSave > 0)
{
lblConfirm.Text = mensajes("msjsave");
lblError.Text = string.Empty;
return(true);
}
else
{
lblError.Text = mensajes("errorsave");
lblConfirm.Text = string.Empty;
return(false);
}
}
else
{
lblError.Text = mensajes("erroupdt");
lblConfirm.Text = string.Empty;
return(false);
}
}
else
{
lblError.Text = mensajes("orderproccesed");
lblConfirm.Text = string.Empty;
return(false);
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
if (_tipoFormulario == "QUANTITY" && txtAnounced.Text.Trim() == String.Empty)
{
lblError.Text = mensajes("formempty");
return;
}
var pdno = lblValueOrden.Text.Trim().ToUpper();
var sqnb = hdfSqnb.Value;
var qrdr = _consultaInformacionOrden.Rows[0]["QRDR"].ToString();
var qtyord = Convert.ToDecimal(qrdr.Trim() == String.Empty ? 0.000 : Convert.ToDouble(qrdr) * Convert.ToDouble(ConfigurationManager.AppSettings["calcAnuncioOrd"].ToString()));
var qtyrec = Convert.ToDecimal(_consultaInformacionOrden.Rows[0]["QTYREC"].ToString());
var enterqty = Convert.ToDecimal(_tipoFormulario == "QUANTITY" ? txtAnounced.Text.Trim() : lblValueAnounced.Text);
if ((qtyrec + enterqty) > qtyord)
{
lblError.Text = String.Format(mensajes("exceedquantity"), (qtyrec + enterqty), qtyord);
return;
}
if (enterqty <= 0)
{
lblError.Text = mensajes("quantzero");
return;
}
var qtdl = "0";
var validarRegistro = _tipoFormulario == "QUANTITY" ? _idaltticol022.selectDatesBySqnbPdno(ref pdno, ref sqnb, ref strError)
: _idaltticol022.findBySqnbPdnoAndQtdl(ref pdno, ref sqnb, ref qtdl, ref strError);
if (validarRegistro.Rows.Count > 0)
{
Ent_tticol022 data022 = new Ent_tticol022()
{
qtdl = enterqty,
pdno = pdno,
sqnb = sqnb
};
var validaUpdate = _idaltticol022.actualizaRegistroAnuncioOrd(ref data022, ref strError);
var validaUpdateCantidad = _idaltticol022.ActualizarCantidadRegistroTicol222(enterqty, sqnb);
if (validaUpdate)
{
var item = Session["item"].ToString();
var dsca = Session["descripcion"].ToString();
var cuni = lblValueUnit.Text;
Ent_tticol020 data020 = new Ent_tticol020()
{
pdno = pdno,
mitm = item,
dsca = dsca,
qtdl = enterqty,
cuni = cuni,
mess = " ",
user = HttpContext.Current.Session["user"].ToString(),
refcntd = 0,
refcntu = 0
};
List <Ent_tticol020> list = new List <Ent_tticol020>();
list.Add(data020);
var validaSave = _idaltticol020.insertarRegistro(ref list, ref strError);
if (validaSave > 0)
{
lblConfirm.Text = mensajes("msjsave");
divTable.Visible = false;
return;
}
else
{
lblError.Text = mensajes("errorsave");
return;
}
}
else
{
lblError.Text = mensajes("erroupdt");
return;
}
}
else
{
lblError.Text = mensajes("orderproccesed");
return;
}
}
