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)); }