public static string verifyLot(string ITEM, string LOT)
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
Ent_twhltc100 data100 = new Ent_twhltc100()
{
item = ITEM, clot = LOT
};
var DTLot = dal100.listaRegistro_Clot(ref data100, ref strError);
if (DTLot.Rows.Count > 0)
{
var MyObjDT = DTLot.Rows[0];
MyObj.Error = false;
MyObj.errorMsg = string.Empty;
MyObj.TipeMsgJs = string.Empty;
}
else
{
MyObj.Error = true;
MyObj.errorMsg = Lotcodedoesntexist;
MyObj.TipeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(MyObj));
}
public static string Click_Query(string PAID)
{
try
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
List <Ent_twhcol130131> LstPallet = twhcol130DAL.ConsultarPorPalletID(PAID, "", HttpContext.Current.Session["user"].ToString());
if (LstPallet.Count > 0)
{
MyObj = LstPallet[0];
if (MyObj.LOGT.Trim() != string.Empty && MyObj.LOCA.Trim() != string.Empty)
{
MyObj.error = true;
MyObj.errorMsg = ThePalletHasAlreadyLocate;
}
}
else
{
MyObj.error = true;
MyObj.errorMsg = ThePalletIDDoesDotExistAssociated;
}
return(JsonConvert.SerializeObject(MyObj));
}
catch (Exception ex)
{
return(ThePalletIDdoesnotexist);
}
}
public bool updatetwhcol131(ref Ent_twhcol130131 parametro, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$SWAR", parametro.CWAR.Trim().ToUpper());
paramList.Add(":T$SQNB", parametro.PAID.Trim().ToUpper());
paramList.Add(":ACLO", parametro.LOCA.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 verifyWarehouse(string CWAR)
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
Ent_tticol100 myObj100 = new Ent_tticol100();
myObj100.cwar = CWAR.Trim().ToUpper();
DataTable DTWare = dalticol100.selecthandletwhwmd200(ref myObj100, ref strError);
if (DTWare.Rows.Count > 0)
{
var MyObjDT = DTWare.Rows[0];
MyObj.CWAR = MyObjDT["warehosue"].ToString();
MyObj.SLOC = MyObjDT["handle_locations"].ToString();
MyObj.Error = false;
MyObj.errorMsg = string.Empty;
MyObj.TipeMsgJs = string.Empty;
}
else
{
MyObj.Error = true;
MyObj.errorMsg = Warehousecodedoesntexist;
MyObj.TipeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(MyObj));
}
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 static bool saveOriginTable(Ent_twhcol028 twhcol028)
{
Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"];
bool ActalizacionExitosa = false;
Ent_tticol082 MyObj82 = new Ent_tticol082();
MyObj82.PAID = twhcol028.PAID;
MyObj82.STAT = "14";
MyObj82.QTYC = "0";
switch (MyOriginalPallet.TBL)
{
case "ticol022":
twhcolDAL.ActCausalTICOL022(MyObj82.PAID,14);
ActalizacionExitosa = Itticol082.Actualizartticol222Cant(MyObj82);
break;
case "ticol042":
twhcolDAL.ActCausalTICOL042(MyObj82.PAID,14);
ActalizacionExitosa = Itticol082.Actualizartticol242Cant(MyObj82);
break;
case "whcol131":
twhcolDAL.ActCausalcol131140(MyObj82.PAID,5);
ActalizacionExitosa = Itticol082.Actualizartwhcol131Cant(MyObj82);
break;
case "whcol130":
twhcolDAL.ActCausalcol131140(MyObj82.PAID,5);
ActalizacionExitosa = Itticol082.Actualizartwhcol131Cant(MyObj82);
break;
}
return(ActalizacionExitosa);
}
public static string GetItems()
{
Ent_ttwhcol016 obj016 = new Ent_ttwhcol016();
obj016.stat = "RET";
//JC 210122 Buscar los posibles regrind en la tabla ticol135
obj016.item = HttpContext.Current.Session["ITM"].ToString();
int i = 0;
DataTable DTItemt = dal016.GetItemsStat(ref obj016, ref strError);
List <Ent_twhcol130131> lstItems = new List <Ent_twhcol130131>();
if (DTItemt.Rows.Count > 0)
{
foreach (DataRow item in DTItemt.Rows)
{
if (i <= 50)
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
MyObj.KTLC = item["LOTE"].ToString();
MyObj.ITEM = item["T$ITEM"].ToString();
MyObj.DSCA = item["DESCRIPCION"].ToString();
MyObj.UNIT = item["UNIDAD"].ToString();
MyObj.Error = false;
MyObj.errorMsg = string.Empty;
MyObj.TipeMsgJs = string.Empty;
lstItems.Add(MyObj);
i++;
}
}
}
return(JsonConvert.SerializeObject(lstItems));;
}
public static string verifyLoca(string CWAR, string LOCA)
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
DataTable DTLoca = dalTransfer.ConsultarLocation(CWAR, LOCA);
if (DTLoca.Rows.Count > 0)
{
var MyObjDT = DTLoca.Rows[0];
if (MyObjDT["BINB"].ToString().Trim() != "2")
{
MyObj.Error = true;
MyObj.errorMsg = Locationblocked;
MyObj.TipeMsgJs = "Label";
}
else
{
MyObj.Error = false;
MyObj.errorMsg = string.Empty;
MyObj.TipeMsgJs = string.Empty;
}
}
else
{
MyObj.Error = true;
MyObj.errorMsg = Locationcodedoesntexist;
MyObj.TipeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(MyObj));
}
public static bool SaveQty(string qty, string paid)
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
MyObj.PAID = paid;
MyObj.QTYC = qty;
MyObj.QTYS = qty;
return(twhcol130DAL.Updateqtystwhcol131(MyObj));
}
public static string VerificarLocation(string CWAR, string LOCA)
{
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
string strError = string.Empty;
Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200();
Obj_twhwmd200.cwar = CWAR;
DataTable DtTransfer = Itransfer.ConsultarLocation(Obj_twhwmd200.cwar, LOCA);
if (DtTransfer.Rows.Count > 0)
{
if (DtTransfer.Rows[0]["LOCT"].ToString() == "5")
{
if (DtTransfer.Rows[0]["BINB"].ToString() == "2")
{
if (MyObj131Base.LOCA.ToUpper().Trim() != LOCA.ToUpper().Trim())
{
Obj_twhwmd200.Error = false;
Obj_twhwmd200.TypeMsgJs = "console";
Obj_twhwmd200.SuccessMsg = "Location Encontrado";
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = "Warehouse / Location can't be the same";
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = Locationblockedinbound;
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = Locationcodedoesntexist;
}
}
else
{
Obj_twhwmd200.Error = true;
Obj_twhwmd200.TypeMsgJs = "label";
Obj_twhwmd200.ErrorMsg = Locationcodedoesntexist;
}
return(JsonConvert.SerializeObject(Obj_twhwmd200));
}
public List <Ent_twhcol130131> ConsultarPorPalletIDReimpresion(string PAID, string LOGR, string PROG, string UrlBaseBarcode)
{
List <Ent_twhcol130131> Lstwhcol130 = new List <Ent_twhcol130131>();
DataTable DTwhcol130 = dal.ConsultarPorPalletIDReimpresion(PAID);
if (DTwhcol130.Rows.Count > 0)
{
if (PROG != "Picking")
{
dal.ActualizarConteoReimpresion(PAID, LOGR);
}
foreach (DataRow MyRow in DTwhcol130.Rows)
{
Ent_twhcol130131 MyObjet = new Ent_twhcol130131 {
OORG = MyRow["OORG"].ToString(),
ORNO = MyRow["ORNO"].ToString(),
ITEM = MyRow["ITEM"].ToString(),
PAID = MyRow["PAID"].ToString(),
PONO = MyRow["PONO"].ToString(),
SEQN = MyRow["SEQN"].ToString(),
CLOT = MyRow["CLOT"].ToString(),
CWAR = MyRow["CWAR"].ToString(),
QTYS = MyRow["QTYS"].ToString(),
UNIT = MyRow["UNIT"].ToString(),
QTYC = MyRow["QTYC"].ToString(),
UNIC = MyRow["UNIC"].ToString(),
DATE = MyRow["T$DATE"].ToString(),
CONF = MyRow["CONF"].ToString(),
RCNO = MyRow["RCNO"].ToString(),
DATR = MyRow["DATR"].ToString(),
LOCA = MyRow["LOCA"].ToString(),
DATL = MyRow["DATL"].ToString(),
PRNT = MyRow["PRNT"].ToString(),
DATP = MyRow["DATP"].ToString(),
NPRT = (Convert.ToInt32(MyRow["NPRT"])).ToString(),
LOGN = MyRow["LOGN"].ToString(),
LOGT = MyRow["LOGT"].ToString(),
STAT = MyRow["T$STAT"].ToString(),
DSCA = MyRow["DSCA"].ToString(),
NAMA = MyRow["T$NAMA"].ToString(),
PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + PAID + "&code=Code128&dpi=96",
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["OORG"].ToString() + "&code=Code128&dpi=96",
//ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["ITEM"].ToString() + "&code=Code128&dpi=96",
ITEM_URL = MyRow["ITEM"].ToString().Trim().ToUpper() + " - " + MyRow["DSCA"].ToString().Trim().ToUpper(),
CLOT_URL = MyRow["CLOT"].ToString() == "" ? "" : (UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["CLOT"].ToString() + "&code=Code128&dpi=96"),
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["QTYC"].ToString() + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["QTYC"].ToString() + "&code=Code128&dpi=96"
};
Lstwhcol130.Add(MyObjet);
}
}
return(Lstwhcol130);
}
public static string Click_TransferP1(string QtyReal, string Paids, string Qtys, string TargetCwar, string TargetLoca, bool final = false)
{
string[] PaidsA = Paids.Split(',');
string[] QtysA = Qtys.Split(',');
List <Ent_twhcol130131> lst131Insrt = (List <Ent_twhcol130131>)HttpContext.Current.Session["lst131Insrt"];
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
for (int i = 0; i < PaidsA.Length; i++)
{
Ent_twhcol130131 MyObj = (Ent_twhcol130131)MyObj131Base.clone();
MyObj.PAID = PaidsA[i].ToUpper().Trim();// Paid;
MyObj.CWAR = TargetCwar.ToUpper();
MyObj.LOCA = TargetLoca.ToUpper();
MyObj.QTYS = QtysA[i].ToUpper().Trim(); //Qty.ToString().Replace(".",",");
MyObj.QTYC = QtysA[i].ToUpper().Trim(); // Qty.ToString().Replace(".", ",");
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.ToUpper();
MyObj.LOAA = TargetLoca.ToUpper();
MyObj.QTYA = QtysA[i].ToUpper().Trim();// Qty.ToString().Replace(".", ",");
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.UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyObj.UNIC.ToString().Trim().ToUpper() + "&code=Code128&dpi=96";
string StrError = "";
if (twhcol130DAL.Insertartwhcol131(MyObj, ref StrError))
{
MyObj.Error = false;
lst131Insrt.Add(MyObj);
}
else
{
MyObj.Error = true;
MyObj.ErrorMsg = StrError;
lst131Insrt.Add(MyObj);
}
if (PaidsA.Length - 1 == i)
{
Click_TransferP2(QtyReal, TargetCwar.ToUpper(), TargetLoca.ToUpper());
}
}
return(JsonConvert.SerializeObject(lst131Insrt));
}
public bool updatetwhcol131(ref Ent_twhcol130131 parametro, ref string strError)
{
bool retorno = false;
try
{
retorno = dal.updatetwhcol131(ref parametro, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public List <Ent_twhcol130131> ConsultarPorPalletID(string PAID, string UrlBaseBarcode, string USER)
{
List <Ent_twhcol130131> Lstwhcol130 = new List <Ent_twhcol130131>();
DataTable DTwhcol130 = dal.ConsultarPorPalletIDReimpresionLogp(PAID, USER);
if (DTwhcol130.Rows.Count > 0)
{
foreach (DataRow MyRow in DTwhcol130.Rows)
{
Ent_twhcol130131 MyObjet = new Ent_twhcol130131
{
OORG = MyRow["OORG"].ToString(),
ORNO = MyRow["ORNO"].ToString(),
ITEM = MyRow["ITEM"].ToString(),
DSCA = MyRow["DSCA"].ToString(),
PAID = MyRow["PAID"].ToString(),
PONO = MyRow["PONO"].ToString(),
SEQN = MyRow["SEQN"].ToString(),
CLOT = MyRow["CLOT"].ToString(),
CWAR = MyRow["CWAR"].ToString(),
QTYS = MyRow["QTYS"].ToString(),
UNIT = MyRow["UNIT"].ToString(),
QTYC = MyRow["QTYC"].ToString(),
UNIC = MyRow["UNIC"].ToString(),
DATE = MyRow["T$DATE"].ToString(),
CONF = MyRow["CONF"].ToString(),
RCNO = MyRow["RCNO"].ToString(),
DATR = MyRow["DATR"].ToString(),
LOCA = MyRow["LOCA"].ToString(),
DATL = MyRow["DATL"].ToString(),
PRNT = MyRow["PRNT"].ToString(),
DATP = MyRow["DATP"].ToString(),
NPRT = (Convert.ToInt32(MyRow["NPRT"])).ToString(),
LOGN = MyRow["LOGN"].ToString(),
LOGT = MyRow["LOGT"].ToString(),
STAT = MyRow["T$STAT"].ToString(),
SLOC = MyRow["SLOC"].ToString(),
ALLO = MyRow["ALLO"].ToString(),
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["OORG"].ToString() + "&code=Code128&dpi=96",
ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["ITEM"].ToString() + "&code=Code128&dpi=96",
CLOT_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["CLOT"].ToString() + "&code=Code128&dpi=96",
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["QTYC"].ToString() + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + MyRow["UNIC"].ToString() + "&code=Code128&dpi=96"
};
Lstwhcol130.Add(MyObjet);
}
}
return(Lstwhcol130);
}
public static string VerificarWarehouse(string CWAR)
{
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
string strError = string.Empty;
Ent_ttwhcol016 Obj_twhcol016 = new Ent_ttwhcol016();
Obj_twhcol016.cwar = CWAR;
Ent_twhwmd200 Obj_twhwmd200 = new Ent_twhwmd200();
Obj_twhwmd200.cwar = CWAR;
DataTable DtTtwhcol016 = ITtwhcol016.TakeMaterialInv_verificaBodega_Param(ref Obj_twhcol016, ref strError);
DataTable DtTwhwmd200 = ITwhwmd200.listaRegistro_ObtieneAlmacenLocation(ref Obj_twhwmd200, ref strError);
if (DtTtwhcol016.Rows.Count > 0)
{
Obj_twhcol016.Error = false;
Obj_twhcol016.TypeMsgJs = "console";
Obj_twhcol016.SuccessMsg = "Warehouse Encontrado";
if (DtTwhwmd200.Rows.Count > 0)
{
Obj_twhcol016.sloc = DtTwhwmd200.Rows[0]["LOC"].ToString();
}
else
{
Obj_twhcol016.sloc = string.Empty;
if (MyObj131Base.CWAR == CWAR)
{
Obj_twhcol016.Error = true;
Obj_twhcol016.TypeMsgJs = "label";
Obj_twhcol016.ErrorMsg = "Warehouse / Location can't be the same";
}
}
}
else
{
Obj_twhcol016.Error = true;
Obj_twhcol016.TypeMsgJs = "label";
Obj_twhcol016.ErrorMsg = Warehousecodedoesntexist;
}
return(JsonConvert.SerializeObject(Obj_twhcol016));
}
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 verifyItem(string ITEM)
{
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
Ent_ttwhcol016 obj016 = new Ent_ttwhcol016();
obj016.item = ITEM.ToUpper().Trim();
DataTable DTItemt = dal016.TakeMaterialInv_verificaItem_Param(ref obj016, ref strError);
if (DTItemt.Rows.Count > 0)
{
Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"];
var MyObjDT = DTItemt.Rows[0];
if (MyObjDT["UNIDAD"].ToString().Trim() == MyOriginalPallet.UNIT.Trim())
{
MyObj.KTLC = MyObjDT["LOTE"].ToString();
MyObj.ITEM = MyObjDT["T$ITEM"].ToString();
MyObj.DSCA = MyObjDT["DESCRIPCION"].ToString();
MyObj.UNIT = MyObjDT["UNIDAD"].ToString();
MyObj.Error = false;
MyObj.errorMsg = string.Empty;
MyObj.TipeMsgJs = string.Empty;
}
else
{
MyObj.Error = true;
MyObj.errorMsg = "Item not allowed to adjust, due the unit is different";
MyObj.TipeMsgJs = "alert";
}
}
else
{
MyObj.Error = true;
MyObj.errorMsg = Itemcodedoesntexist;
MyObj.TipeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(MyObj));;
}
public bool Insertartwhcol131(Ent_twhcol130131 MyObj, ref string StrError)
{
return(dal.Insertartwhcol131(MyObj, ref StrError));
}
public bool Updateqtystwhcol131(Ent_twhcol130131 MyObj)
{
return(dal.Updateqtystwhcol131(MyObj));
}
public DataTable ConsultaSumatoriaCantidadesTwhinh210(Ent_twhcol130131 MyObj)
{
return(dal.ConsultaSumatoriaCantidadesTwhinh210(MyObj));
}
public bool Eliminartccol130(Ent_twhcol130131 MyObj)
{
return(dal.Eliminartccol130(MyObj));
}
public bool UpdateStatusPicked(Ent_twhcol130131 myObj)
{
return(dal.UpdateStatusPicked(myObj));
}
public bool InsertarReseiptRawMaterial131(Ent_twhcol130131 myObj)
{
return(dal.InsertarReseiptRawMaterial131(myObj));
}
public static string Click_Print(string PAID)
{
string strError = string.Empty;
Ent_twhcol130131 MyObj = new Ent_twhcol130131();
DataTable dt018 = idal018.SelectRegister(PAID, ref strError);
DataTable dt042 = idal042.SelectRegister(PAID, ref strError);
if (dt018.Rows.Count > 0)
{
HttpContext.Current.Session["Reprint"] = "yes";
HttpContext.Current.Session["MaterialDesc"] = dt018.Rows[0]["T$ITEM"].ToString();
HttpContext.Current.Session["Material"] = dt018.Rows[0]["T$ITEM"].ToString();
HttpContext.Current.Session["codePaid"] = dt018.Rows[0]["T$PAID"].ToString();
HttpContext.Current.Session["Lot"] = dt018.Rows[0]["T$CLOT"].ToString();
HttpContext.Current.Session["Quantity"] = dt018.Rows[0]["T$QTYR"].ToString();
HttpContext.Current.Session["Date"] = dt018.Rows[0]["T$DATR"].ToString();
HttpContext.Current.Session["Machine"] = _idaltticol022.getMachine(dt018.Rows[0]["T$CLOT"].ToString().Trim().ToString(), dt018.Rows[0]["T$ITEM"].ToString().Trim().ToUpper(), ref strError);
HttpContext.Current.Session["Operator"] = dt018.Rows[0]["T$LOGR"].ToString();
HttpContext.Current.Session["Pallet"] = dt018.Rows[0]["T$PAID"].ToString();
MyObj.Error = false;
MyObj.SuccessMsg = "3Regrinds.aspx";
}
else if (dt042.Rows.Count > 0)
{
HttpContext.Current.Session["MaterialDesc"] = dt042.Rows[0]["T$MITM"].ToString();
HttpContext.Current.Session["MaterialCode"] = dt042.Rows[0]["T$MITM"].ToString();
HttpContext.Current.Session["codePaid"] = dt042.Rows[0]["T$SQNB"].ToString();
HttpContext.Current.Session["Lot"] = dt042.Rows[0]["T$LOGN"].ToString();
HttpContext.Current.Session["Quantity"] = dt042.Rows[0]["T$QTDL"].ToString() + " " + dt042.Rows[0]["T$CUNI"].ToString();
HttpContext.Current.Session["Origin"] = dt042.Rows[0]["T$PDNO"].ToString();
HttpContext.Current.Session["Supplier"] = dt042.Rows[0]["T$LOGN"].ToString();
HttpContext.Current.Session["RecibedBy"] = dt042.Rows[0]["T$LOGN"].ToString();
HttpContext.Current.Session["RecibedOn"] = dt042.Rows[0]["T$DATC"].ToString();
HttpContext.Current.Session["Reprint"] = "yes";
MyObj.Error = false;
MyObj.SuccessMsg = "1RawMaterial.aspx";
}
else
{
MyObj.Error = true;
MyObj.ErrorMsg = "Pallet ID Doesn't exist";
}
//{
//OORG = "2",// Order type escaneada view
//ORNO = "INITIAPOP",
//ITEM = ITEM.ToUpper(),
//PAID = "INITIAPOP" + "-" + SecuenciaPallet,
//PONO = "1",
//SEQN = "1",
//CLOT = CLOT.ToUpper(),// lote VIEW
//CWAR = CWAR.ToUpper(),
//QTYS = QTYS,// cantidad escaneada view
//QTYA = QTYS,
//UNIT = UNIT,//unit escaneada view
//QTYC = QTYS,//cantidad escaneada view aplicando factor
//UNIC = UNIT,//unidad view stock
//DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(),//fecha de confirmacion
//CONF = "1",
//RCNO = " ",//llena baan
//DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString(),//llena baan
//LOCA = LOCA.ToUpper(),// enviamos vacio
//DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(),//llenar con fecha de hoy
//PRNT = "1",// llenar en 1
//DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(),//llena baan
//NPRT = "1",//conteo de reimpresiones
//LOGN = HttpContext.Current.Session["user"].ToString(),// nombre de ususario de la session
//LOGT = " ",//llena baan
//STAT = "3",// LLENAR EN 3
//DSCA = " ",
//COTP = " ",
//FIRE = "2",
//PSLIP = " ",
//ALLO = "0",
//PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + SecuenciaPallet + "&code=Code128&dpi=96",
//ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "DTOrdencompra.Rows[0][].ToString()" + "&code=Code128&dpi=96",
//ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + ITEM + "&code=Code128&dpi=96",
//CLOT_URL = CLOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + CLOT + "&code=Code128&dpi=96" : "",
//QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QTYS + "&code=Code128&dpi=96",
//UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + UNIT + "&code=Code128&dpi=96"
//};
//bool Insertsucces = twhcol130DAL.Insertartwhcol131(MyObj);
//if (Insertsucces)
//{
// HttpContext.Current.Session["MaterialDesc"] = "XXXXX XXX XXX XX";
// HttpContext.Current.Session["MaterialCode"] = MyObj.ITEM;
// HttpContext.Current.Session["codePaid"] = MyObj.PAID ;
// HttpContext.Current.Session["Lot"] = MyObj.CLOT;
// HttpContext.Current.Session["Quantity"] = MyObj.QTYS + " " + UNIT;
// HttpContext.Current.Session["Origin"] = MyObj.CLOT;
// HttpContext.Current.Session["Supplier"] = "";
// HttpContext.Current.Session["RecibedBy"] = MyObj.LOGN;
// HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString();
// HttpContext.Current.Session["Reprint"] = "no";
//}
//else
//{
// MyObj.error = true;
// MyObj.TypeMsgJs = "label";
// MyObj.errorMsg = "Error insert";
//}
return(JsonConvert.SerializeObject(MyObj));
}
public static string Click_Save(string CWAR, string ITEM, string CLOT, string LOCA, string QTYS, string UNIT)
{
//int consecutivoPalletID = 0;
//DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol130("INITIAPOP-P");
//string SecuenciaPallet = "001";
//if (DTPalletContinue.Rows.Count > 0)
//{
// foreach (DataRow item in DTPalletContinue.Rows)
// {
// string paid = item["T$PAID"].ToString().Trim();
// int indesSep = item["T$PAID"].ToString().Trim().IndexOf("-P");
// string secuence = paid.Substring(indesSep + 1);
// consecutivoPalletID = Convert.ToInt32(secuence)+1;
// if (consecutivoPalletID.ToString().Length == 1)
// {
// SecuenciaPallet = "P00" + consecutivoPalletID;
// }
// if (consecutivoPalletID.ToString().Length == 2)
// {
// SecuenciaPallet = "P0" + consecutivoPalletID;
// }
// if (consecutivoPalletID.ToString().Length == 3)
// {
// SecuenciaPallet = "P"+consecutivoPalletID.ToString();
// }
// }
//}
Ent_ttwhcol016 data016 = new Ent_ttwhcol016();;
string retorno = string.Empty;
string strError = string.Empty;
data016.zone = serieLabelRM;
DataTable dat016 = ITtwhcol016.VerificaCons_Serie_Label(ref data016, ref strError);
int actcontador = ITtwhcol016.actualizarContadores(ref data016, ref strError);
//string SecuenciaPallet = "C";
string consecutivo = dat016.Rows[0]["CONSEC"].ToString().PadLeft(3, '0');
string serie = dat016.Rows[0]["SEQ"].ToString();
if (consecutivo == "990")
{
data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString()) + 1;
int retconser = ITtwhcol016.ActualizarSerie_Consecutivo(ref data016, ref strError);
}
if (consecutivo == "998")
{
data016.serietemp = Convert.ToInt32(dat016.Rows[0]["SEQ"].ToString());
int retconser = ITtwhcol016.DesactivarSerie_Consecutivo(ref data016, ref strError);
}
string id = CLOT.Trim() == "" ? cyclecountLabelRM : CLOT.Trim();
string sqnb = cyclecountLabelRM.Trim() + serie.Trim() + "-" + consecutivo;
Ent_twhcol130131 MyObj = new Ent_twhcol130131
{
OORG = "2",// Order type escaneada view
//ORNO = "INITIAPOP",
ORNO = cyclecountLabelRM.Trim() + serie.Trim(),
ITEM = ITEM.ToUpper(),
//PAID = "INITIAPOP" + "-" + SecuenciaPallet,
PAID = sqnb,
PONO = "1",
SEQN = "1",
CLOT = CLOT.ToUpper(), // lote VIEW
CWAR = CWAR.ToUpper(),
QTYS = QTYS, // cantidad escaneada view
QTYA = QTYS,
UNIT = UNIT, //unit escaneada view
QTYC = QTYS, //cantidad escaneada view aplicando factor
UNIC = UNIT, //unidad view stock
DATE = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //fecha de confirmacion
CONF = "1",
RCNO = " ", //llena baan
DATR = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llena baan
LOCA = LOCA.ToUpper(), // enviamos vacio
DATL = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llenar con fecha de hoy
PRNT = "1", // llenar en 1
DATP = DateTime.Now.ToString("dd/MM/yyyy").ToString(), //llena baan
NPRT = "1", //conteo de reimpresiones
LOGN = HttpContext.Current.Session["user"].ToString(), // nombre de ususario de la session
LOGT = " ", //llena baan
STAT = "3", // LLENAR EN 3
DSCA = " ",
COTP = " ",
FIRE = "2",
PSLIP = " ",
ALLO = "0",
//PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + SecuenciaPallet + "&code=Code128&dpi=96",
PAID_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "INITIAPOP" + "-" + sqnb + "&code=Code128&dpi=96",
ORNO_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + "DTOrdencompra.Rows[0][].ToString()" + "&code=Code128&dpi=96",
ITEM_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + ITEM + "&code=Code128&dpi=96",
CLOT_URL = CLOT.ToString().Trim() != "" ? UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + CLOT + "&code=Code128&dpi=96" : "",
QTYC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + QTYS + "&code=Code128&dpi=96",
UNIC_URL = UrlBaseBarcode + "/Barcode/BarcodeHandler.ashx?data=" + UNIT + "&code=Code128&dpi=96"
};
string StrError = string.Empty;
bool Insertsucces = twhcol130DAL.Insertartwhcol131(MyObj, ref StrError);
if (Insertsucces)
{
HttpContext.Current.Session["MaterialDesc"] = "XXXXX XXX XXX XX";
HttpContext.Current.Session["MaterialCode"] = MyObj.ITEM;
HttpContext.Current.Session["codePaid"] = MyObj.PAID;
HttpContext.Current.Session["Lot"] = MyObj.CLOT;
HttpContext.Current.Session["Quantity"] = MyObj.QTYS + " " + UNIT;
HttpContext.Current.Session["Origin"] = MyObj.CLOT;
HttpContext.Current.Session["Supplier"] = "";
HttpContext.Current.Session["RecibedBy"] = MyObj.LOGN;
HttpContext.Current.Session["RecibedOn"] = DateTime.Now.ToString("MM/dd/yyyy");
HttpContext.Current.Session["Reprint"] = "no";
}
else
{
MyObj.error = true;
MyObj.TypeMsgJs = "label";
MyObj.errorMsg = "Error insert";
}
return(JsonConvert.SerializeObject(MyObj));
}
public bool Insertar133(Ent_twhcol130131 MyObj)
{
return(dal.Insertar133(MyObj));
}
public string InsertarReseiptRawMaterialComplementMultiInsert(Ent_twhcol130131 MyObj)
{
return(dal.InsertarReseiptRawMaterialComplementMultiInsert(MyObj));
}
public static string Save(Ent_twhcol028 twhcol028)
{
//twhcol028.EMNO =
Ent_twhcol130131 MyOriginalPallet = (Ent_twhcol130131)HttpContext.Current.Session["MyOriginalPallet"];
twhcol028.LOGN = HttpContext.Current.Session["user"].ToString();
bool Res = _idaltwhcol028.insertRegistertwhcol028(ref twhcol028, ref strError);
//JC 210122 Si es un retal hacer un calculo diferente para la cantidad.
DataTable TipoItem = _idaltwhcol028.GetItemType(ref twhcol028, ref strError);
DataTable NetwItem = _idaltwhcol028.GetItemNetw(ref twhcol028, ref strError);
twhcol028.TYPE = TipoItem.Rows[0]["TYPE"].ToString().ToUpper().Trim();
twhcol028.NETW = NetwItem.Rows[0]["NETW"].ToString().Trim();
twhcol028.UNRG = TipoItem.Rows[0]["UNIT"].ToString();
twhcol028.QTRG = Convert.ToString(Math.Round(((Convert.ToDecimal(twhcol028.TQTY) * Convert.ToDecimal(twhcol028.NETW)) / Convert.ToDecimal(2.20462)), 4));
if (Res)
{
if ((twhcol028.TITM == twhcol028.SITM) && (twhcol028.TWAR != twhcol028.SWAR || twhcol028.TLOC != twhcol028.SLOC))
{
bool updateSuccessPallet = UpdatePalletOriginTable(ref twhcol028);
if (updateSuccessPallet)
{
twhcol028.Error = false;
}
else
{
twhcol028.Error = true;
}
}
else
{
saveOriginTable(twhcol028);
string strMaxSequence = string.Empty;
switch (MyOriginalPallet.TBL)
{
case "ticol022":
case "ticol042":
if (twhcol028.KTLC == "1")
{
if (twhcol028.TLOT.Trim().ToUpper() == twhcol028.SLOT.Trim().ToUpper())
{
strMaxSequence = getSequence(twhcol028.SLOT.Trim().ToUpper() + "-A");
}
else
{
//strMaxSequence = getSequence(twhcol028.TLOT.Trim().ToUpper() + "-A");
//JC 210122 Corregir la busqueda si el lote destino no existe o si el item no maneja lote
strMaxSequence = getSequence(twhcol028.PAID.Substring(0,9).ToUpper() + "-A");
}
}
else if (twhcol028.KTLC != "1")
{
if (twhcol028.TLOT.Trim().ToUpper() == twhcol028.SLOT.Trim().ToUpper())
{
strMaxSequence = getSequence(MyOriginalPallet.ORNO + "-A");
}
else
{
strMaxSequence = getSequence(twhcol028.SLOT.Trim() + "-A");
}
}
break;
case "whcol131":
strMaxSequence = getSequence(MyOriginalPallet.ORNO + "-A");
break;
}
bool createSuccessNewPaller = saveNewPalletOriginTable(ref twhcol028,strMaxSequence);
if (createSuccessNewPaller)
{
twhcol028.Error = false;
twhcol028.ErrorMsg = "Se inserto correctamente";
twhcol028.SuccessMsg = "Se inserto ok";
twhcol028.TypeMsgJs = "Label";
}
else
{
twhcol028.Error = true;
twhcol028.ErrorMsg = "No se inserto correctamente el nuevo pallet";
twhcol028.TypeMsgJs = "Label";
}
}
}
else
{
twhcol028.Error = true;
twhcol028.ErrorMsg = "No se inserto correctamente";
twhcol028.TypeMsgJs = "Label";
}
return(JsonConvert.SerializeObject(twhcol028));
}
public DataTable selectTccol020(Ent_twhcol130131 MyObj)
{
return(dal.selectTccol020(MyObj));
}
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);
}
