public bool ActualizarTransferencia(Ent_twhcol020 objWhcol020)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$CWAR", objWhcol020.cwde.Trim().ToUpper() == "" ? " " : objWhcol020.cwde.Trim().ToUpper());
paramList.Add(":T$LOCA", objWhcol020.lode.Trim().ToUpper() == "" ? " " : objWhcol020.lode.Trim().ToUpper());
paramList.Add(":T$PAID", objWhcol020.sqnb.Trim().ToUpper());
switch (objWhcol020.tbl.Trim().ToLower())
{
//case "ticol022":
// strSentenciaAux = recursos.readStatement(method.ReflectedType.Name, "Actualizatticol022", ref owner, ref env, tabla, paramList);
// ActualizarTticol222(objWhcol020);
// break;
//case "whcol130":
// strSentenciaAux = recursos.readStatement(method.ReflectedType.Name, "Actualizatwhcol130", ref owner, ref env, tabla, paramList);
// break;
//case "whcol131":
// strSentenciaAux = recursos.readStatement(method.ReflectedType.Name, "Actualizatwhcol131", ref owner, ref env, tabla, paramList);
// break;
//case "ticol042":
// strSentenciaAux = recursos.readStatement(method.ReflectedType.Name, "Actualizatticol042", ref owner, ref env, tabla, paramList);
// ActualizarTticol242(objWhcol020);
// break;
//case "whcol016":
// strSentenciaAux = recursos.readStatement(method.ReflectedType.Name, "Actualizatwhcol016", ref owner, ref env, tabla, paramList);
// break;
}
return(DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentenciaAux, ref parametersOut, null, false));
}
public int insertarRegistro(ref Ent_twhcol020 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;
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(Convert.ToInt32(retorno));
}
//JC 171021 Validar Stock en Baan
public DataTable ValidarStockBaan(Ent_twhcol020 objWhcol020)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$CLOT", objWhcol020.clot.Trim().ToUpper());//objWhcol020.clot.Trim().ToUpper());
paramList.Add(":T$SQNB", objWhcol020.sqnb.Trim().ToUpper());
paramList.Add(":T$MITM", objWhcol020.mitm.ToUpper().Trim());
paramList.Add(":T$DSCA", objWhcol020.dsca.Trim().ToUpper());//objWhcol020.dsca.Trim().ToUpper());
paramList.Add(":T$CWOR", objWhcol020.cwor.Trim().ToUpper());
paramList.Add(":T$LOOR", objWhcol020.loor.Trim().ToUpper() == "" ? " " : objWhcol020.loor.Trim().ToUpper());
paramList.Add(":T$QTDL", objWhcol020.qtdl);
DataTable retorno = new DataTable();
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
retorno = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(retorno);
}
public static void Click_TransferP2(string QtyReal, string TargetCwar, string TargetLoca)
{
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
MyObj131Base.PAIDS_URLS.Clear();
MyObj131Base.PAIDS.Clear();
Ent_twhcol020 objWhcol020 = new Ent_twhcol020();
objWhcol020.tbl = "";
objWhcol020.clot = MyObj131Base.LOT == string.Empty ? " " : MyObj131Base.LOT;
objWhcol020.sqnb = MyObj131Base.PAID;
objWhcol020.mitm = MyObj131Base.ITEM;
objWhcol020.dsca = Transfers.DescripcionItem(objWhcol020.mitm);
//objWhcol020.cwor = MyObj131Base.CWAR; //JC 180522 La bodega no es la correcta.
objWhcol020.cwor = MyObj131Base.CWAA;
objWhcol020.loor = MyObj131Base.LOCA; //JC 180522 La ubicacion no es la correcta.
objWhcol020.cwde = TargetCwar;
objWhcol020.lode = TargetLoca;
objWhcol020.qtdl = Convert.ToDouble(QtyReal);
objWhcol020.cuni = MyObj131Base.UNIT;
objWhcol020.user = HttpContext.Current.Session["user"].ToString();
Transfers.InsertarTransferencia(objWhcol020);
//JC 22032022 Ajuste cantidad final
//_idaltwhcol131.Actualizartwhcol131CantEstado(MyObj131Base.PAID, 9, (Convert.ToDecimal(QtyReal) - Convert.ToDecimal(MyObj131Base.QTYS)));
_idaltwhcol131.Actualizartwhcol131CantEstado(MyObj131Base.PAID, 9, (Convert.ToDecimal(MyObj131Base.QTYT) - Convert.ToDecimal(QtyReal)));
}
public bool ActualizarTticol242(Ent_twhcol020 objWhcol020)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$CWAT", objWhcol020.cwde.Trim().ToUpper() == "" ? " " : objWhcol020.cwde.Trim().ToUpper());
paramList.Add(":T$ACLO", objWhcol020.lode.Trim().ToUpper() == "" ? " " : objWhcol020.lode.Trim().ToUpper());
paramList.Add(":T$SQNB", objWhcol020.sqnb.Trim().ToUpper());
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
return(DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false));
}
public int insertarRegistro(ref Ent_twhcol020 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);
}
}
public bool InsertarTransferencia(Ent_twhcol020 objWhcol020)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
//paramList.Add(":T$PAID", PAID.Trim().ToUpper());
paramList.Add(":T$CLOT", objWhcol020.clot.Trim().ToUpper());//objWhcol020.clot.Trim().ToUpper());
paramList.Add(":T$SQNB", objWhcol020.sqnb.Trim().ToUpper());
paramList.Add(":T$MITM", objWhcol020.mitm.ToUpper());
paramList.Add(":T$DSCA", objWhcol020.dsca.Trim().ToUpper());//objWhcol020.dsca.Trim().ToUpper());
paramList.Add(":T$CWOR", objWhcol020.cwor.Trim().ToUpper());
paramList.Add(":T$LOOR", objWhcol020.loor.Trim().ToUpper() == "" ? " " : objWhcol020.loor.Trim().ToUpper());
paramList.Add(":T$CWDE", objWhcol020.cwde.Trim().ToUpper() == "" ? " " : objWhcol020.cwde.Trim().ToUpper());
paramList.Add(":T$LODE", objWhcol020.lode.Trim().ToUpper() == "" ? " " : objWhcol020.lode.Trim().ToUpper());
paramList.Add(":T$QTDL", objWhcol020.qtdl);
paramList.Add(":T$CUNI", objWhcol020.cuni.Trim());
paramList.Add(":T$RCNO", " ");
paramList.Add(":T$DATE", ""); // objWhcol020.date.Trim().ToUpper());
paramList.Add(":T$MESS", " "); // objWhcol020.mess.Trim().ToUpper());
paramList.Add(":T$USER", objWhcol020.user.ToUpper());
paramList.Add(":T$REFCNTD", 0);
paramList.Add(":T$REFCNTU", 0);
bool retorno = false;
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
retorno = DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(retorno);
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_twhcol020 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.String, 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 static string clickTransfer(string PAID, string CurrentWarehouse, string CurrentSloc, string CurrentLocation, string TargetWarehouse, string TargetSloc, string TargetLocation, bool StartCurrentWarehouse = true, bool StartCurrentLocation = true)
{
Ent_twhcol020 objWhcol020 = new Ent_twhcol020();
DataTable Transferencias = Transfers.ConsultarRegistroTransferir(PAID);
bool LocationCurrent = false;
bool LocationTarget = false;
if (CurrentWarehouse != TargetWarehouse && CurrentLocation != TargetLocation || CurrentWarehouse == TargetWarehouse && CurrentLocation != TargetLocation || CurrentWarehouse != TargetWarehouse && CurrentLocation == TargetLocation || (CurrentWarehouse == TargetWarehouse && CurrentLocation == TargetLocation && CurrentSloc.Trim() != "1" && TargetSloc != "1"))
{
if (CurrentSloc.Trim() != "1")
{
LocationCurrent = true;
}
else
{
if (StartCurrentWarehouse == true && StartCurrentWarehouse == true)
{
LocationCurrent = true;
}
else if (StartCurrentWarehouse == true && StartCurrentWarehouse == false)
{
LocationCurrent = (Transfers.ConsultarLocation(CurrentWarehouse, CurrentLocation).Rows.Count > 0) ? true : false;
}
else if (StartCurrentWarehouse == false && StartCurrentWarehouse == true)
{
LocationCurrent = (Transfers.ConsultarLocation(CurrentWarehouse, CurrentLocation).Rows.Count > 0) ? true : false;
}
else if (StartCurrentWarehouse == false && StartCurrentWarehouse == false)
{
LocationCurrent = (Transfers.ConsultarLocation(CurrentWarehouse, CurrentLocation).Rows.Count > 0) ? true : false;
}
}
if (TargetSloc.Trim() != "1")
{
LocationTarget = true;
}
else
{
var DtCurrentLocation = Transfers.ConsultarLocation(TargetWarehouse, TargetLocation);
if (DtCurrentLocation.Rows.Count > 0)
{
string LOCT = DtCurrentLocation.Rows[0]["LOCT"].ToString().Trim();
string BINB = DtCurrentLocation.Rows[0]["BINB"].ToString().Trim();
if (LOCT != "5")
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = LocationTypeMustBulK;
objWhcol020.TipeMsgJs = "lbl";
return(JsonConvert.SerializeObject(objWhcol020));
}
else if (BINB != "2")
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = LocationBlockedTransfers;
objWhcol020.TipeMsgJs = "lbl";
return(JsonConvert.SerializeObject(objWhcol020));
}
else
{
LocationTarget = true;
}
}
}
if (LocationCurrent == true)
{
if (LocationTarget == true)
{
if (Transferencias.Rows.Count > 0)
{
objWhcol020.tbl = Transferencias.Rows[0]["TBL"].ToString().Trim();
objWhcol020.clot = Transferencias.Rows[0]["T$ORNO"].ToString().Trim();
objWhcol020.sqnb = Transferencias.Rows[0]["T$PAID"].ToString().Trim();
objWhcol020.mitm = Transferencias.Rows[0]["T$ITEM"].ToString();
objWhcol020.dsca = Transfers.DescripcionItem(objWhcol020.mitm);
objWhcol020.cwor = CurrentWarehouse;
objWhcol020.loor = CurrentLocation;
objWhcol020.cwde = TargetWarehouse;
objWhcol020.lode = TargetLocation;
objWhcol020.qtdl = Convert.ToDouble(Transferencias.Rows[0]["T$QTYC"].ToString().Trim());
objWhcol020.cuni = Transferencias.Rows[0]["T$CUNI"].ToString().Trim();
objWhcol020.user = HttpContext.Current.Session["user"].ToString();
DataTable ExistenciaTransfer = Transfers.ConsultaTransferencia(PAID);
if (ExistenciaTransfer.Rows.Count > 0)
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = PalletIdAlreadyTransferAndPendingToProcess;
objWhcol020.TipeMsgJs = "lbl";
//bool TransferenciasU = Transfers.ActualizarTransferencia(PAID, CurrentWarehouse, CurrentLocation, TargetWarehouse, TargetLocation, HttpContext.Current.Session["user"].ToString());
//if (TransferenciasU)
//{
// if (TransferenciasU)
// {
// objWhcol020.Success = true;
// objWhcol020.SuccessMsg = Thetransferwassuccessful;
// }
// else
// {
// objWhcol020.Error = true;
// objWhcol020.ErrorMsg = TransferNotUpdated;
// objWhcol020.TipeMsgJs = "lbl";
// }
//}
//else
//{
// objWhcol020.Error = true;
// objWhcol020.ErrorMsg = NotInserted;
// objWhcol020.TipeMsgJs = "lbl";
//}
}
else
{
DataTable StockBaan = Transfers.ValidarStockBaan(objWhcol020);
if (StockBaan.Rows.Count <= 0)
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = TranferQtynotenough;
objWhcol020.TipeMsgJs = "lbl";
}
else
{
bool TransferenciasI = Transfers.InsertarTransferencia(objWhcol020);
if (TransferenciasI)
{
if (/*TransferenciasU == */ true)
{
objWhcol020.Success = true;
objWhcol020.SuccessMsg = Thetransferwassuccessful;
objWhcol020.TipeMsgJs = "lbl";
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = TransferNotUpdated;
objWhcol020.TipeMsgJs = "lbl";
}
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = NotInserted;
objWhcol020.TipeMsgJs = "lbl";
}
}
}
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = PalletNotExist;
objWhcol020.TipeMsgJs = "lbl";
}
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = TargetLocationNotExist;
objWhcol020.TipeMsgJs = "lbl";
}
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = CurrentNotExist;
objWhcol020.TipeMsgJs = "lbl";
}
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = LocationTransfeCannotEqual;
objWhcol020.TipeMsgJs = "lbl";
}
return(JsonConvert.SerializeObject(objWhcol020));
}
public static string clickQuery(string PAID)
{
DataTable Transferencias = Transfers.ConsultarRegistroTransferir(PAID);
Ent_twhcol020 objWhcol020 = new Ent_twhcol020();
if (Transferencias.Rows.Count > 0)
{
//if (Transferencias.Rows[0]["SLOC"].ToString() == "1")
//{
if (Transferencias.Rows[0]["T$LOCA"].ToString().Trim() == string.Empty && Transferencias.Rows[0]["T$CWAR"].ToString().Trim() == string.Empty)
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = PalletNotLocate;
objWhcol020.TipeMsgJs = "lbl";
}
else
{
//JC 030222 Validar si el item es de RFID que el pallet este asociado a un RFID
//DataTable Rfid = Transfers.ConsultarRegistroTransferirRfid(Transferencias.Rows[0]["T$ITEM"].ToString().Trim());
//if (Rfid.Rows[0]["T$RFID"].ToString().Trim() =="1")
//{
//DataTable RfidPallet = Transfers.ConsultarRegistroTransferirRfidPallet(PAID);
//if (RfidPallet.Rows.Count > 0)
//{
// objWhcol020.tbl = Transferencias.Rows[0]["TBL"].ToString().Trim();
// objWhcol020.sloc = Transferencias.Rows[0]["SLOC"].ToString();
// objWhcol020.clot = Transferencias.Rows[0]["T$ORNO"].ToString().Trim();
// objWhcol020.sqnb = Transferencias.Rows[0]["T$PAID"].ToString().Trim();
// objWhcol020.mitm = Transferencias.Rows[0]["T$ITEM"].ToString().Trim();
// objWhcol020.dsca = Transfers.DescripcionItem(objWhcol020.mitm);
// objWhcol020.cwor = Transferencias.Rows[0]["T$CWAR"].ToString().Trim();
// objWhcol020.loor = Transferencias.Rows[0]["T$LOCA"].ToString().Trim();
// objWhcol020.qtdl = Convert.ToDouble(Transferencias.Rows[0]["T$QTYC"].ToString().Trim());
// objWhcol020.cuni = Transferencias.Rows[0]["T$CUNI"].ToString().Trim();
// objWhcol020.user = HttpContext.Current.Session["user"].ToString();
//}
//else
//{
// objWhcol020.Error = true;
// objWhcol020.ErrorMsg = PalletRfidNotExist;
// objWhcol020.TipeMsgJs = "lbl";
//}
//}
//else
//{
objWhcol020.tbl = Transferencias.Rows[0]["TBL"].ToString().Trim();
objWhcol020.sloc = Transferencias.Rows[0]["SLOC"].ToString();
objWhcol020.clot = Transferencias.Rows[0]["T$ORNO"].ToString().Trim();
objWhcol020.sqnb = Transferencias.Rows[0]["T$PAID"].ToString().Trim();
objWhcol020.mitm = Transferencias.Rows[0]["T$ITEM"].ToString().Trim();
objWhcol020.dsca = Transfers.DescripcionItem(objWhcol020.mitm);
objWhcol020.cwor = Transferencias.Rows[0]["T$CWAR"].ToString().Trim();
objWhcol020.loor = Transferencias.Rows[0]["T$LOCA"].ToString().Trim();
objWhcol020.qtdl = Convert.ToDouble(Transferencias.Rows[0]["T$QTYC"].ToString().Trim());
objWhcol020.cuni = Transferencias.Rows[0]["T$CUNI"].ToString().Trim();
objWhcol020.user = HttpContext.Current.Session["user"].ToString();
//}
}
//}
}
else
{
objWhcol020.Error = true;
objWhcol020.ErrorMsg = PalletNotExist;
objWhcol020.TipeMsgJs = "lbl";
}
return(JsonConvert.SerializeObject(objWhcol020));
}
public bool ActualizarTransferencia(Ent_twhcol020 objWhcol020)
{
return(dal.ActualizarTransferencia(objWhcol020));
}
public bool InsertarTransferencia(Ent_twhcol020 objWhcol020)
{
return(dal.InsertarTransferencia(objWhcol020));
}
public static string Click_Locate(string PAID, string CWAR, string LOCA)
{
HttpContext context = HttpContext.Current;
try
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
DataTable LocationExist = twhcol130DAL.ConsultarLocation(PAID, CWAR, LOCA);
if (LocationExist.Rows.Count > 0)
{
if (LocationExist.Rows[0]["LOCT"].ToString() != "5")
{
MyObj.errorMsg = TheLocationIsNotBulkType;
MyObj.error = true;
}
else if (LocationExist.Rows[0]["BINB"].ToString() != "2")
{
MyObj.errorMsg = TheLocationIsLockedForInbound;
MyObj.error = true;
}
else if (LocationExist.Rows[0]["LOCT"].ToString() == "5" && LocationExist.Rows[0]["BINB"].ToString() == "2")
{
List <Ent_twhcol130131> LstPallet = twhcol130DAL.ConsultarPorPalletID(PAID, "", string.Empty);
if (LstPallet.Count > 0)
{
if (LstPallet[0].LOCA.Trim() != LOCA)
{
bool UpdateSucces = twhcol130DAL.ActualizacionLocaWhcol130(PAID, LOCA, CWAR, context.Session["user"].ToString(), "3");
if (UpdateSucces == true)
{
LstPallet = twhcol130DAL.ConsultarPorPalletID(PAID, "", string.Empty);
string errorTwhcol020 = string.Empty;
string CLOT = LstPallet[0].ORNO;
DataTable PrioridadNativa = twhcol130DAL.ConsultarPrioridadNativa(LstPallet[0].CWAR.Trim());
DataTable LocationNativa = twhcol130DAL.ConsultarLocationNativa(LstPallet[0].CWAR.Trim(), PrioridadNativa.Rows[0]["T$PRIO"].ToString());
Ent_twhcol020 MyObj_twhcol020 = new Ent_twhcol020
{
clot = CLOT.Trim(),
sqnb = PAID, //ConsecutivoTwhcol020 + 1,
mitm = LstPallet[0].ITEM.Trim(),
dsca = LstPallet[0].DSCA, //Dato Quemado Por favor Cambiar
cwor = LstPallet[0].CWAR.Trim(),
loor = LocationNativa.Rows[0]["T$LOCA"].ToString(), //Dato Quemado Por favor Cambiar
cwde = CWAR, //LstPallet[0].CWAR.Trim(),
lode = LOCA, //LstPallet[0].LOCA.Trim(),
qtdl = Convert.ToDouble(LstPallet[0].QTYC.ToString()),
cuni = LstPallet[0].UNIC.Trim(),
date = DateTime.Now.ToString("dd / MM / aaaa"),
mess = string.Empty,
user = context.Session["user"].ToString(),
refcntd = 0,
refcntu = 0
};
string errorInsertTwhcol020 = string.Empty;
int InsertSuccsesTwhcol020 = twhcol020DAL.insertarRegistro(ref MyObj_twhcol020, ref errorInsertTwhcol020);
if (errorInsertTwhcol020 == string.Empty)
{
bool DeleteSucces = twhcol130DAL.Eliminartccol307(LstPallet[0].PAID, HttpContext.Current.Session["user"].ToString());
if (DeleteSucces == true)
{
MyObj = LstPallet[0];
}
else
{
MyObj.errorMsg = DeleteTccol307Error;
MyObj.error = true;
}
}
else
{
MyObj.errorMsg = ThePalletHasAlreadyBeLocated;
MyObj.error = true;
}
}
else
{
MyObj.errorMsg = UpdateTwhcol130Error;
MyObj.error = true;
}
}
else
{
MyObj.errorMsg = TheCurrentLocate;
MyObj.error = true;
}
}
else
{
MyObj.errorMsg = TheCurrentLocationCannotBeTheSameAsTheTargetLocation;
MyObj.error = true;
}
}
}
else
{
List <Ent_twhcol130131> LstPallet = twhcol130DAL.ConsultarPorPalletID(PAID, string.Empty, HttpContext.Current.Session["user"].ToString());
if (LstPallet.Count > 0)
{
MyObj = LstPallet[0];
}
;
if (MyObj.SLOC != "1")
{
bool UpdateSucces = twhcol130DAL.ActualizacionLocaWhcol130(PAID, LOCA = " ", CWAR, context.Session["user"].ToString(), "3");
if (UpdateSucces == true)
{
LstPallet = twhcol130DAL.ConsultarPorPalletID(PAID, "", string.Empty);
if (LstPallet.Count > 0)
{
MyObj = LstPallet[0];
}
bool Insert131 = twhcol130DAL.InsertarReseiptRawMaterial131(MyObj);
if (Insert131)
{
bool Delete130 = twhcol130DAL.Eliminartccol130(MyObj);
}
bool DeleteSucces = twhcol130DAL.Eliminartccol307(MyObj.PAID, HttpContext.Current.Session["user"].ToString());
if (DeleteSucces == true)
{
MyObj = LstPallet[0];
}
else
{
MyObj.errorMsg = DeleteTccol307Error;
MyObj.error = true;
}
}
else
{
MyObj.errorMsg = UpdateTwhcol130Error;
MyObj.error = true;
}
}
else
{
MyObj.errorMsg = TheLocationDoesNotExist;
MyObj.error = true;
}
}
return(JsonConvert.SerializeObject(MyObj));
}
catch (Exception e)
{
return(ThePalletIDdoesnotexist);
}
}
//JC 171021 Validar Stock en Baan
public DataTable ValidarStockBaan(Ent_twhcol020 objWhcol020)
{
return(dal.ValidarStockBaan(objWhcol020));
}
public static string Click_Transfer(string QtyReal, string Paids, string TargetCwar, string TargetLoca)
{
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
MyObj131Base.PAIDS_URLS.Clear();
MyObj131Base.PAIDS.Clear();
Ent_twhcol130131 MyObj = (Ent_twhcol130131)MyObj131Base.clone();
Double qtyReal = Convert.ToDouble(QtyReal);
Double QtyPallets = Convert.ToDouble(Paids.Trim() == string.Empty ? "1" : Paids.Trim());
Double Parcials = qtyReal / QtyPallets;
Decimal QUANTITY = 0;
//int CantPalletsComp = Convert.ToInt32(Parcials);
double CantPalletsComp = Math.Truncate(Parcials);
double CantParcPallets = Parcials - CantPalletsComp;
if (CantParcPallets == 0)
{
CantParcPallets = 0;
}
else
{
CantParcPallets = 1;
}
int inserts = 0;
int consecutivoPalletID = 0;
int QUANTITYAUX_COMPLETADA = 0;
Factor MyConvertionFactor = new Factor {
};
if (MyObj131Base.UNIT != "PLT")
{
MyConvertionFactor = FactorConversion(MyObj131Base.ITEM, MyObj131Base.UNIT, "PLT");
QUANTITY = (MyConvertionFactor.Tipo == "Div") ? Convert.ToDecimal((QUANTITY * MyConvertionFactor.FactorB) / MyConvertionFactor.FactorD) : Convert.ToDecimal((QUANTITY * MyConvertionFactor.FactorD) / MyConvertionFactor.FactorB);
}
for (int i = 0; i < CantPalletsComp; i++)
{
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol131(MyObj131Base.ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = consecutivoPalletID.ToString();
}
}
}
MyObj.PAID = MyObj131Base.ORNO + "-" + SecuenciaPallet;
MyObj.CWAR = TargetCwar;
MyObj.LOCA = TargetLoca;
MyObj.QTYS = QtyPallets.ToString();
MyObj.QTYC = QtyPallets.ToString();
MyObj.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString();
MyObj.DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString();;
MyObj.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString();
MyObj.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString();
MyObj.LOGN = HttpContext.Current.Session["user"].ToString();
MyObj.LOGT = " ";
MyObj.CWAA = TargetCwar;
MyObj.LOAA = TargetLoca;
MyObj.QTYA = QtyPallets.ToString();
MyObj.QTYAS.Add(MyObj.QTYA);
MyObj.PAIDS.Add(MyObj.PAID);
MyObj.PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.PAID + "&code=Code128&dpi=96";
MyObj.PAIDS_URLS.Add(MyObj.PAID_URL);
MyObj.ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.ORNO + "&code=Code128&dpi=96";
MyObj.ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.ITEM + "&code=Code128&dpi=96";
MyObj.CLOT_URL = MyObj.LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.CLOT + "&code=Code128&dpi=96" : "";
//MyObj.QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.QTYC.ToString("0.0000").Trim().ToUpper() + "&code=Code128&dpi=96";
MyObj.UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.UNIC.ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
string StrError = string.Empty;
if (twhcol130DAL.Insertartwhcol131(MyObj, ref StrError))
{
inserts++;
}
}
for (int p = 0; p < CantParcPallets; p++)
{
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol131(MyObj131Base.ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
if (consecutivoPalletID.ToString().Length == 1)
{
SecuenciaPallet = "00" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 2)
{
SecuenciaPallet = "0" + consecutivoPalletID;
}
if (consecutivoPalletID.ToString().Length == 3)
{
SecuenciaPallet = consecutivoPalletID.ToString();
}
}
}
MyObj.PAID = MyObj131Base.ORNO + "-" + SecuenciaPallet;
MyObj.CWAR = TargetCwar;
MyObj.LOCA = TargetLoca;
MyObj.QTYS = (qtyReal - (CantPalletsComp * QtyPallets)).ToString();
MyObj.QTYC = (qtyReal - (CantPalletsComp * QtyPallets)).ToString();
MyObj.DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString();
MyObj.DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString();;
MyObj.DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString();
MyObj.DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString();
MyObj.LOGN = HttpContext.Current.Session["user"].ToString();
MyObj.LOGT = " ";
MyObj.CWAA = TargetCwar;
MyObj.LOAA = TargetLoca;
MyObj.QTYA = (qtyReal - (CantPalletsComp * QtyPallets)).ToString();
MyObj.QTYAS.Add(MyObj.QTYA);
MyObj.PAIDS.Add(MyObj.PAID);
MyObj.PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.PAID + "&code=Code128&dpi=96";
MyObj.PAIDS_URLS.Add(MyObj.PAID_URL);
MyObj.ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.ORNO + "&code=Code128&dpi=96";
MyObj.ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.ITEM + "&code=Code128&dpi=96";
MyObj.CLOT_URL = MyObj.LOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.CLOT + "&code=Code128&dpi=96" : "";
//MyObj.QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.QTYC.ToString("0.0000").Trim().ToUpper() + "&code=Code128&dpi=96";
MyObj.UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.UNIC.ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
string StrError = string.Empty;
if (twhcol130DAL.Insertartwhcol131(MyObj, ref StrError))
{
inserts++;
}
}
if (inserts == CantPalletsComp + CantParcPallets)
{
Ent_twhcol020 objWhcol020 = new Ent_twhcol020();
objWhcol020.tbl = "";
objWhcol020.clot = MyObj131Base.LOT == string.Empty ? " " : MyObj131Base.LOT;
objWhcol020.sqnb = MyObj131Base.PAID;
objWhcol020.mitm = MyObj131Base.ITEM;
objWhcol020.dsca = Transfers.DescripcionItem(objWhcol020.mitm);
objWhcol020.cwor = MyObj131Base.CWAR;
objWhcol020.loor = MyObj131Base.LOCA;
objWhcol020.cwde = TargetCwar;
objWhcol020.lode = TargetLoca;
objWhcol020.qtdl = Convert.ToDouble(qtyReal);
objWhcol020.cuni = MyObj131Base.UNIT;
objWhcol020.user = HttpContext.Current.Session["user"].ToString();
Transfers.InsertarTransferencia(objWhcol020);
_idaltwhcol131.Actualizartwhcol131CantEstado(MyObj131Base.PAID, 9, (Convert.ToDecimal(QtyReal) - Convert.ToDecimal(MyObj131Base.QTYS)));
}
return(JsonConvert.SerializeObject(MyObj));
}
