public bool updatetticol222(ref Ent_tticol022 parametro, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$SWAR", parametro.cwaf.Trim().ToUpper());
paramList.Add(":T$SQNB", parametro.sqnb.Trim().ToUpper());
paramList.Add(":ALOC", parametro.aclo.ToUpper());
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 = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
public static string Click_Query(string PAID)
{
if (active022 == true)
{
DataTable consultaOrden = tticol022DAL.ConsultaPorPalletID(ref PAID, ref strError);
Ent_tticol022 ObjTticol022 = new Ent_tticol022();
if (consultaOrden.Rows.Count > 0)
{
DataRow MyRow = consultaOrden.Rows[0];
ObjTticol022.proc = Convert.ToInt32(MyRow["PROC"].ToString());
ObjTticol022.mitm = MyRow["ITEM"].ToString();
ObjTticol022.dsca = MyRow["DSCA"].ToString();
ObjTticol022.qtdl = Convert.ToDecimal(MyRow["ACQT"].ToString() == String.Empty ? "0" : MyRow["ACQT"].ToString());
ObjTticol022.cuni = MyRow["CUNI"].ToString();
ObjTticol022.dele = Convert.ToInt32(MyRow["STAT"].ToString());
ObjTticol022.date = MyRow["DATEA"].ToString();
ObjTticol022.Error = false;
}
else
{
ObjTticol022.Error = true;
ObjTticol022.ErrorMsg = PalletidDoesnexist;
ObjTticol022.TypeMsgJs = "alert";
}
return(JsonConvert.SerializeObject(ObjTticol022));
}
else
{
DataTable consultaOrden = tticol042DAL.ConsultaPorPalletID(ref PAID, ref strError);
Ent_tticol042 ObjTticol042 = new Ent_tticol042();
if (consultaOrden.Rows.Count > 0)
{
DataRow MyRow = consultaOrden.Rows[0];
ObjTticol042.proc = Convert.ToInt32(MyRow["PROC"].ToString());
ObjTticol042.date = MyRow["DATEA"].ToString();
ObjTticol042.mitm = MyRow["ITEM"].ToString();
ObjTticol042.dsca = MyRow["DSCA"].ToString();
ObjTticol042.qtdl = Convert.ToDouble(MyRow["ACQT"].ToString() == String.Empty ? "0" : MyRow["ACQT"].ToString());
ObjTticol042.cuni = MyRow["CUNI"].ToString();
ObjTticol042.dele = Convert.ToInt32(MyRow["STAT"].ToString());
ObjTticol042.Error = false;
if (ObjTticol042.dele != 2)
{
ObjTticol042.Error = true;
ObjTticol042.ErrorMsg = RegrindPalletIDStatusdoesntallowdeleteit;
ObjTticol042.TypeMsgJs = "alert";
}
}
else
{
ObjTticol042.Error = true;
ObjTticol042.ErrorMsg = PalletidDoesnexist;
ObjTticol042.TypeMsgJs = "alert";
}
return(JsonConvert.SerializeObject(ObjTticol042));
}
}
public bool actualizaRegistroConfirmReceipt(ref Ent_tticol022 data, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$LOG1", data.log1.Trim().ToUpper());
paramList.Add(":T$QTD1", data.qtd1);
paramList.Add(":T$PDNO", data.pdno);
paramList.Add(":T$SQNB", data.sqnb);
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 = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
public string invLabel_generaSecuenciaOrden(ref Ent_tticol022 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
string strOrden = Parametros.pdno.Trim().ToUpperInvariant();
string strSecuencia = strOrden + "-001";
string strSentenciaS = string.Empty;
paramList = new Dictionary <string, object>();
paramList.Add("p1", strOrden);
strSentenciaS = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentenciaS, ref parametersOut, null, true);
if (consulta.Rows.Count > 0)
{
strSecuencia = strOrden + "-" + consulta.Rows[0]["SECUENCIA"].ToString();
}
}
catch (Exception ex)
{
strError = "Error al buscar secuencia [tticol022]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(strSecuencia);
}
public DataTable wrapValidation_listaRegistroSec_param(ref Ent_tticol022 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
string strSecuencia = Parametros.sqnb.Trim().ToUpperInvariant();;
paramList = new Dictionary <string, object>();
paramList.Add("p1", strSecuencia);
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Pallet doesn’t exist";
}
}
catch (Exception ex)
{
strError = "Error to the search sequence [tticol022]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol022 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$SQNB", DbType.String, parametros.sqnb);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.proc);
//if (!string.IsNullOrEmpty(parametros.logn.Trim()))
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.date);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MITM", DbType.String, " " + parametros.mitm);
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$LOG1", DbType.String, parametros.log1);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATC", DbType.String, parametros.datc);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD1", DbType.Int32, parametros.qtd1);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO1", DbType.Int32, parametros.pro1);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOG2", DbType.String, parametros.log2);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATU", DbType.String, parametros.datu);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QTD2", DbType.Int32, parametros.qtd2);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PRO2", DbType.Int32, parametros.pro2);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$NORP", DbType.Int32, parametros.norp);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DLRP", DbType.String, parametros.dlrp);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DELE", DbType.Int32, parametros.dele);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGD", DbType.String, parametros.logd);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATD", DbType.String, parametros.datd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$URPT", DbType.String, parametros.refcntu);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ACQT", DbType.Double, parametros.refcntu);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAF", DbType.String, parametros.refcntu);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAT", DbType.String, parametros.refcntu);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ACLO", 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)
{
strError = "Error when creating parameters [022]. 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 bool UpdateMasive222WrhQty(Ent_tticol022 MyObj022)
{
string strError = string.Empty;
try
{
bool retorno = dal.UpdateMasive222(MyObj022);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
//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);
}
}
public int InsertarRegistroTicol222(ref Ent_tticol022 data022, ref string strError)
{
int retorno = -1;
try
{
retorno = dal.InsertarRegistroTicol222(ref data022, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public int insertarRegistroSimple(ref Ent_tticol022 parametros, ref string strError)
{
int retorno = -1;
try
{
retorno = dal.insertarRegistroSimple(ref parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public bool actualizaRegistroAnuncioOrd(ref Ent_tticol022 data, ref string strError)
{
bool retorno = false;
try
{
retorno = dal.actualizaRegistroAnuncioOrd(ref data, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public bool updatetticol222(ref Ent_tticol022 parametro, ref string strError)
{
bool retorno = false;
try
{
retorno = dal.updatetticol222(ref parametro, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public static string Click_Update(string WARE)
{
string strError = string.Empty;
Ent_twhcol130 MyObj131 = new Ent_twhcol130();
Ent_tticol022 MyObj022 = new Ent_tticol022();
Ent_tticol042 MyObj042 = new Ent_tticol042();
MyObj042.Error = true;
MyObj042.cwat = WARE;
MyObj042.acqt = Convert.ToInt32(0);
MyObj042.dele = Convert.ToInt32(11);
if (ITticol042.UpdateMasiveStatus(MyObj042))
{
ITticol042.UpdateMasive242WrhQty(MyObj042);
MyObj042.Error = false;
}
MyObj022.cwat = WARE;
MyObj022.acqt = Convert.ToInt32(0);
MyObj022.dele = Convert.ToInt32(11);
if (ITticol022.UpdateMasiveStatus(MyObj022))
{
ITticol022.UpdateMasive222WrhQty(MyObj022);
MyObj042.Error = false;
}
MyObj131.CWAA = WARE;
MyObj131.QTYA = Convert.ToInt32(0);
MyObj131.STAT = Convert.ToInt32(9);
if (ITwhcol130.UpdateMasiveStaQty(MyObj131))
{
MyObj042.Error = false;
}
if (MyObj042.Error == false)
{
MyObj042.Error = false;
MyObj042.TypeMsgJs = "label";
MyObj042.ErrorMsg = "Data Updated";
}
else
{
MyObj042.Error = true;
MyObj042.TypeMsgJs = "label";
MyObj042.ErrorMsg = "No Data Updated";
}
return(JsonConvert.SerializeObject(MyObj042));
}
public bool ActualizarNorpTicol022(Ent_tticol022 Obj_tticol022)
{
string strError = string.Empty;
try
{
bool retorno = dal.ActualizarNorpTicol022(Obj_tticol022);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public bool invLabel_tiempoGrabacion(Ent_tticol022 Parametros, ref string strError)
{
//int retorno = -1;
bool retorno = false;
try
{
retorno = dal.invLabel_tiempoGrabacion(Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public DataTable wrapValidation_listaRegistroSec_param(ref Ent_tticol022 Parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.wrapValidation_listaRegistroSec_param(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public DataTable invLabel_registroImprimir_Param(ref Ent_tticol022 Parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.invLabel_registroImprimir_Param(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public string invLabel_generaSecuenciaOrden(ref Ent_tticol022 Parametros, ref string strError)
{
//int retorno = -1;
string retorno;
try
{
retorno = dal.invLabel_generaSecuenciaOrden(ref Parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
//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);
}
public bool invLabel_tiempoGrabacion(Ent_tticol022 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool blLibre = false;
bool convert = false;
decimal timeDelay = 0;
string strSentenciaS = string.Empty;
// Verificar la existencia de la clave para el tiempo de espera en el archivo config de la aplicación
if (ConfigurationManager.AppSettings.AllKeys.Contains("timeOutRollSave")) // Existe
{
convert = decimal.TryParse(ConfigurationManager.AppSettings["timeOutRollSave"].ToString(), out timeDelay);
}
else
{
strError = "Time delay to roll save not found";
} // No existe
if (convert && string.IsNullOrEmpty(strError))
{
paramList = new Dictionary <string, object>();
paramList.Add("p1", Parametros.pdno.Trim().ToUpperInvariant());
paramList.Add("p2", timeDelay.ToString());
strSentenciaS = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentenciaS, ref parametersOut, null, true);
if (consulta.Rows.Count > 0)
{
if (consulta.Rows[0]["ORDEN"].ToString() == "0")
{
blLibre = true;
}
else
{
strError = "Another Roll was announced " + timeDelay.ToString() + " minutes before.";
}
}
}
return(blLibre);
}
public static string VerificarPalletID(string PAID)
{
string strError = string.Empty;
DataTable DTticol022 = _idaltticol022.findRecordBySqnbRejectedPlant(ref PAID, ref strError);
Ent_tticol022 ObjTticol022 = new Ent_tticol022();
if (DTticol022.Rows.Count > 0)
{
ObjTticol022.pdno = DTticol022.Rows[0]["PDNO"].ToString();
ObjTticol022.sqnb = DTticol022.Rows[0]["SQNB"].ToString();
ObjTticol022.mitm = DTticol022.Rows[0]["MITM"].ToString();
VerificarItem(ObjTticol022.mitm, ObjTticol022.pdno);
ObjTticol022.dsca = DTticol022.Rows[0]["DSCA"].ToString();
ObjTticol022.cuni = DTticol022.Rows[0]["CUNI"].ToString();
ObjTticol022.qtdl = Convert.ToDecimal(DTticol022.Rows[0]["QTDL"].ToString());
ObjTticol022.dele = Convert.ToInt32(DTticol022.Rows[0]["DELE"].ToString());
ObjTticol022.pro1 = Convert.ToInt32(DTticol022.Rows[0]["PRO1"].ToString());
ObjTticol022.proc = Convert.ToInt32(DTticol022.Rows[0]["PROC"].ToString());
//PDNO, SQNB, MITM, DSCA, CUNI, QTDL, DELE, PRO1, PROC
ObjTticol022.Error = false;
if (DTticol022.Rows[0]["DELE"].ToString() != "7")
{
ObjTticol022.Error = true;
ObjTticol022.TypeMsgJs = "label";
ObjTticol022.ErrorMsg = PalletIDdoesntexist;
}
}
else
{
ObjTticol022.Error = true;
ObjTticol022.TypeMsgJs = "label";
ObjTticol022.ErrorMsg = PalletIDdoesntexist;
}
return(JsonConvert.SerializeObject(ObjTticol022));
}
private static bool UpdatePalletOriginTable(ref Ent_twhcol028 twhcol028)
{
bool res = false;
string separator = "-";
string SQNB = twhcol028.PAID.Substring(0,twhcol028.PAID.IndexOf(separator));
switch (HttpContext.Current.Session["TBL"].ToString())
{
case "ticol022":
Ent_tticol022 obj022 = new Ent_tticol022();
obj022.sqnb = twhcol028.PAID;
obj022.dele = 7;
obj022.cwaf = twhcol028.TWAR;
obj022.cwat = twhcol028.TWAR;
obj022.aclo = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;
res = dalticol100.updatetticol222(ref obj022,ref strError);
break;
case "ticol042":
Ent_tticol042 obj042 = new Ent_tticol042();
obj042.sqnb = twhcol028.PAID;
obj042.dele = 7;
obj042.cwaf = twhcol028.TWAR;
obj042.cwat = twhcol028.TWAR;
obj042.aclo = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;;
res = dalticol100.updatetticol242(ref obj042,ref strError);
break;
case "whcol131":
Ent_twhcol130131 MyObj131 = new Ent_twhcol130131();
MyObj131.PAID = twhcol028.PAID;
MyObj131.STAT = "3";
MyObj131.CWAR = twhcol028.TWAR;
MyObj131.LOCA = twhcol028.TLOC == string.Empty ? " " : twhcol028.TLOC;;
res = dalticol100.updatetwhcol131(ref MyObj131,ref strError);
break;
}
return(res);
}
public static string Click_Save(string PAID, string ORNO, string ITEM, string CWAR, string LOCA, string UNIT, string QTYS)
{
string strError = string.Empty;
_idaltticol022.ActualizacionPalletId(PAID, "7", strError);
Ent_tticol022 ObjTticol022 = new Ent_tticol022();
ObjTticol022.pdno = ORNO;
ObjTticol022.sqnb = PAID;
ObjTticol022.urpt = HttpContext.Current.Session["user"].ToString();
ObjTticol022.acqt = Convert.ToDecimal(QTYS);
ObjTticol022.cwaf = CWAR;
ObjTticol022.cwat = CWAR;
ObjTticol022.aclo = LOCA;
ObjTticol022.Error = false;
ObjTticol022.allo = 0;
int res = 1;//_idaltticol022.InsertarRegistroTicol222(ref ObjTticol022, ref strError);
if (res == 0)
{
_idaltticol022.ActualizarCantidadAlmacenRegistroTicol222(HttpContext.Current.Session["user"].ToString(), ObjTticol022.acqt, ObjTticol022.aclo, ObjTticol022.cwaf, ObjTticol022.sqnb);
}
HttpContext.Current.Session["MaterialDesc"] = ITEM;
HttpContext.Current.Session["codeMaterial"] = ITEM.Trim().ToUpper();
HttpContext.Current.Session["codePaid"] = PAID.Trim().ToUpper();
HttpContext.Current.Session["Lot"] = ORNO;
HttpContext.Current.Session["Quantity"] = QTYS.ToString() + " " + UNIT;
HttpContext.Current.Session["Date"] = DateTime.Now.ToString("MM/dd/yyyy");
HttpContext.Current.Session["Pallet"] = PAID.Trim().ToUpper();
HttpContext.Current.Session["Machine"] = idal022.getMachine(ORNO, ITEM.Trim().ToUpper(), ref strError);;;
HttpContext.Current.Session["Operator"] = HttpContext.Current.Session["user"].ToString();
HttpContext.Current.Session["Reprint"] = "no";
return(JsonConvert.SerializeObject(ObjTticol022));
}
public int insertarRegistroSimple(ref Ent_tticol022 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 = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(Convert.ToInt32(retorno));
}
public int insertarRegistro(ref List <Ent_tticol022> parametros, ref List <Ent_tticol020> parametros020, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla);
log.escribirError(strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
foreach (Ent_tticol022 reg in parametros)
{
if (!invLabel_tiempoGrabacion(reg, ref strError))
{
break;
}
// Inicia la insercion del registro
parametrosIn = AdicionaParametrosComunes(reg);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, parametrosIn, false);
if (retorno)
{
DAL.tticol020 dal020 = new tticol020();
int intRetorno = dal020.insertarRegistro(ref parametros020, ref strError);
Ent_tticol022 nreg = reg;
int retorno222 = InsertarRegistroTicol222(ref nreg, ref strError);
}
}
return(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
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(Convert.ToInt32(retorno));
}
public DataTable invLabel_registroImprimir_Param(ref Ent_tticol022 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
string strSentenciaS = string.Empty;
string strOrden = Parametros.pdno.Trim().ToUpperInvariant();
string strSecuencia = Parametros.sqnb.Trim().ToUpperInvariant();;
paramList = new Dictionary <string, object>();
paramList.Add("p1", strOrden);
paramList.Add("p2", strSecuencia);
strSentenciaS = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentenciaS, ref parametersOut, null, true);
}
catch (Exception ex)
{
strError = "Error to search information to print [tticol022]. Try again or contact your administrator \n " + strSentencia;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public bool ActualizarNorpTicol022(Ent_tticol022 Obj_tticol022)
{
method = MethodBase.GetCurrentMethod();
string strError = string.Empty;
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$NORP", Obj_tticol022.norp);
paramList.Add(":T$SQNB", Obj_tticol022.sqnb);
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla222, paramList);
DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(retorno);
}
public int InsertarRegistroTicol222(ref Ent_tticol022 parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
paramList = new Dictionary <string, object>();
paramList.Add(":T$PDNO", parametros.pdno.Trim().ToUpper());
paramList.Add(":T$SQNB", parametros.sqnb.Trim().ToUpper());
paramList.Add(":T$URPT", parametros.urpt.ToUpper());
paramList.Add(":T$ACQT", parametros.acqt.ToString().Contains(",") == true ? parametros.acqt.ToString().Replace(",", ".") : parametros.acqt.ToString().Replace(".", ","));
paramList.Add(":T$CWAF", parametros.cwaf.ToUpper().Trim());
paramList.Add(":T$CWAT", parametros.cwat.ToUpper().Trim() == string.Empty?" ":parametros.cwat.ToUpper().Trim());
paramList.Add(":T$ACLO", parametros.aclo.ToUpper());
paramList.Add(":T$ALLO", parametros.allo.ToString().Contains(",") == true ? parametros.allo.ToString().Replace(",", ".") : parametros.allo.ToString().Replace(".", ","));
try
{
strSentencia = recursos.readStatement("tticol222", method.Name, ref owner, ref env, tabla222, paramList);
log.escribirError("Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
parametrosIn = AdicionaParametrosComunes(parametros);
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("text", strSentencia, ref parametersOut, null, false);
return(Convert.ToInt32(retorno));
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
log.escribirError(strError + Console.Out.NewLine + ex.Message + "Sentencia SQL: " + strSentencia, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(Convert.ToInt32(retorno));
}
private static bool saveNewPalletOriginTable(ref Ent_twhcol028 twhcol028,string MaxSequence)
{
bool res = false;
string separator = "-";
twhcol028.PAID = recursos.GenerateNewPallet(MaxSequence,separator);
string SQNB = twhcol028.PAID.Substring(0,twhcol028.PAID.IndexOf(separator));
twhcol028.LOGN = HttpContext.Current.Session["user"].ToString();
twhcol028.DATR = DateTime.Now.ToString("MM/dd/yyyy");
switch (HttpContext.Current.Session["TBL"].ToString())
{
case "ticol022":
Ent_tticol022 obj022 = new Ent_tticol022();
List <Ent_tticol022> list022 = new List <Ent_tticol022>();
twhcol028.WHLOT = twhcol028.TLOT.Trim() == string.Empty ? " " : twhcol028.TLOT.Trim();
obj022.pdno = SQNB;
obj022.sqnb = twhcol028.PAID;
obj022.proc = 1;
obj022.logn = twhcol028.LOGN;
obj022.mitm = twhcol028.TITM;
//JC 210122 Grabar la cantidad Correcta si es un regrind
//obj022.cuni = twhcol028.UNIT;
//obj022.qtdl = Convert.ToDecimal(twhcol028.TQTY);
if (twhcol028.TYPE == "RET")
{
obj022.cuni = twhcol028.UNRG;
obj022.qtdl = Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)),4);
obj022.qtd1 = Convert.ToInt32((Convert.ToInt32(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462));
obj022.qtd2 = Convert.ToInt32((Convert.ToInt32(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462));
obj022.acqt = Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)),4);
}
else
{
obj022.cuni = twhcol028.UNIT;
obj022.qtdl = Convert.ToDecimal(twhcol028.TQTY);
obj022.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.acqt = Convert.ToDecimal(twhcol028.TQTY);
}
obj022.log1 = "NONE";
//obj022.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.pro1 = 1;
obj022.log2 = "NONE";
//obj022.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj022.pro2 = 2;
obj022.loca = " ";
obj022.norp = 1;
obj022.dele = 7;
obj022.logd = "NONE";
obj022.refcntd = 0;
obj022.refcntu = 0;
obj022.drpt = DateTime.Now;
obj022.urpt = twhcol028.LOGN;
//obj022.acqt = Convert.ToDecimal(twhcol028.TQTY);
obj022.cwaf = twhcol028.TWAR;
obj022.cwat = twhcol028.TWAR;
obj022.aclo = twhcol028.SLOC;
obj022.allo = 0;
list022.Add(obj022);
bool insert022 = Convert.ToBoolean(_idaltticol022.insertarRegistroSimple(ref obj022,ref strError));
bool insert222 = Convert.ToBoolean(_idaltticol022.InsertarRegistroTicol222(ref obj022,ref strError));
res = (insert222 == true && insert022 == true) ? true : false;
break;
case "ticol042":
Ent_tticol042 obj042 = new Ent_tticol042();
List <Ent_tticol042> list042 = new List <Ent_tticol042>();
twhcol028.WHLOT = twhcol028.TLOT;
obj042.pdno = SQNB;
obj042.sqnb = twhcol028.PAID;
obj042.proc = 1;
obj042.logn = twhcol028.LOGN;
obj042.mitm = twhcol028.TITM;
obj042.qtdl = Convert.ToDouble(twhcol028.TQTY);
obj042.cuni = twhcol028.UNIT;
obj042.log1 = "NONE";
obj042.qtd1 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj042.pro1 = 1;
obj042.log2 = "NONE";
obj042.qtd2 = Convert.ToInt32(Convert.ToDouble(twhcol028.TQTY));
obj042.pro2 = 2;
obj042.loca = " ";
obj042.norp = 1;
obj042.dele = 7;
obj042.logd = "NONE";
obj042.refcntd = 0;
obj042.refcntu = 0;
obj042.drpt = DateTime.Now;
obj042.urpt = twhcol028.LOGN;
obj042.acqt = Convert.ToDouble(twhcol028.TQTY);
obj042.cwaf = twhcol028.TWAR;
obj042.cwat = twhcol028.TWAR;
obj042.aclo = twhcol028.SLOC;
obj042.allo = 0;
list042.Add(obj042);
bool insert042 = Convert.ToBoolean(_idaltticol042.insertarRegistroSimple(ref obj042,ref strError));
bool insert242 = Convert.ToBoolean(_idaltticol042.InsertarRegistroTicol242(ref obj042,ref strError));
res = (insert242 == true && insert042 == true) ? true : false;
break;
case "whcol131":
Ent_twhcol130131 obj131 = new Ent_twhcol130131();
Ent_twhcol130131 MyObj131 = new Ent_twhcol130131();
twhcol028.WHLOT = twhcol028.PAID.Substring(0,(twhcol028.PAID.IndexOf("-")));
MyObj131.OORG = "4";
MyObj131.ORNO = SQNB.Trim().ToUpper();
MyObj131.ITEM = twhcol028.TITM;
MyObj131.PAID = twhcol028.PAID;
MyObj131.PONO = "0";
MyObj131.SEQN = "0";
MyObj131.CLOT = string.IsNullOrEmpty(twhcol028.TLOT) ? " " : twhcol028.TLOT.ToUpper();
MyObj131.CWAR = twhcol028.TWAR;
MyObj131.QTYS = twhcol028.TQTY; // cantidad escaneada view
MyObj131.QTYA = twhcol028.TQTY;
MyObj131.UNIT = twhcol028.UNIT;
MyObj131.QTYC = twhcol028.TQTY; //cantidad escaneada view aplicando factor
MyObj131.UNIC = twhcol028.UNIT;
MyObj131.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //fecha de confirmacion
MyObj131.CONF = "1";
MyObj131.RCNO = " "; //llena baan
MyObj131.DATR = "01/01/70"; //llena baan
MyObj131.LOCA = twhcol028.SLOC; // enviamos vacio
MyObj131.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llenar con fecha de hoy
MyObj131.PRNT = "1"; // llenar en 1
MyObj131.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(); //llena baan
MyObj131.NPRT = "1"; //conteo de reimpresiones
MyObj131.LOGN = twhcol028.LOGN; // nombre de ususario de la session
MyObj131.LOGT = " "; //llena baan
MyObj131.STAT = "3"; // LLENAR EN 1
MyObj131.DSCA = "0";
MyObj131.COTP = "0";
MyObj131.FIRE = "1";
MyObj131.PSLIP = " ";
MyObj131.ALLO = "0";
string StrError = string.Empty;
res = _idaltwhcol130.Insertartwhcol131(MyObj131,ref StrError);
break;
}
return(res);
}
protected void btnSend_Click(object sender, EventArgs e)
{
lblError.Visible = true;
obj022 = new Ent_tticol022();
strError = string.Empty;
obj022.sqnb = txtSQNB.Text.Trim().ToUpperInvariant(); //hidden.Value;
resultado = idal.wrapValidation_listaRegistroSec_param(ref obj022, ref strError);
if (resultado.Rows.Count < 1)
{
lblError.Text = "Not item's found for Sequence " + obj022.sqnb.Trim();
lblError.CssClass = "errorMsg";
return;
}
List <Ent_tticol020> parameterCollection020 = new List <Ent_tticol020>();
List <Ent_tticol022> parameterCollection022 = new List <Ent_tticol022>();
obj022.cuni = resultado.Rows[0]["UNIDAD"].ToString();
obj022.pdno = resultado.Rows[0]["ORDEN"].ToString().Trim();
obj022.sqnb = resultado.Rows[0]["SECUENCIA"].ToString().Trim();
obj022.mitm = resultado.Rows[0]["ITEM"].ToString().Trim();
obj022.qtdl = Decimal.Parse(resultado.Rows[0]["PESO"].ToString(), System.Globalization.CultureInfo.InvariantCulture);
obj022.logn = resultado.Rows[0]["USUARIO"].ToString().Trim(); //Session["user"].ToString();
obj022.proc = int.Parse(resultado.Rows[0]["T$PROC"].ToString());
obj022.pro1 = int.Parse(resultado.Rows[0]["T$PRO1"].ToString());
obj022.pro2 = int.Parse(resultado.Rows[0]["T$PRO2"].ToString());
obj022.log1 = resultado.Rows[0]["T$LOG1"].ToString();
obj022.log2 = resultado.Rows[0]["T$LOG2"].ToString();
obj022.logd = resultado.Rows[0]["T$LOGD"].ToString();
obj022.dele = 4;
obj022.qtd1 = int.Parse(resultado.Rows[0]["T$QTD1"].ToString());
obj022.norp = int.Parse(resultado.Rows[0]["T$NORP"].ToString());
obj022.loca = resultado.Rows[0]["T$LOCA"].ToString();
obj022.qtd2 = int.Parse(resultado.Rows[0]["T$QTD2"].ToString());
obj022.refcntd = 0;
obj022.refcntu = 0;
obj022.idrecord = resultado.Rows[0]["IDRECORD"].ToString();
parameterCollection022.Add(obj022);
int retorno = idal.actualizarRegistro_Param(ref parameterCollection022, ref strError);
if (!string.IsNullOrEmpty(strError))
{
lblError.Text = strError;
return;
}
if (retorno > 0)
{
lblError.Text = "Pallet was saved succesfully.";
}
txtSQNB.Text = string.Empty;
//StringBuilder script = new StringBuilder();
//script.Append("ventanaImp = window.open('../Labels/whInvLabel.aspx', ");
//script.Append("'ventanaImp', 'menubar=0,resizable=0,width=580,height=450');");
//script.Append("ventanaImp.moveTo(30, 0);");
////script.Append("setTimeout (ventanaImp.close(), 20000);");
//ScriptManager.RegisterStartupScript(this, this.GetType(), "printTag", script.ToString(), true);
}
