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 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));
}
public static string Click_Process(string QtyReal, string Paids, string TargetCwar, string TargetLoca)
{
List <Ent_twhcol130131> LstInserts = new List <Ent_twhcol130131>();
Ent_twhcol130131 MyObj131Base = (Ent_twhcol130131)HttpContext.Current.Session["MyPalletTwhcol13"];
MyObj131Base.PAIDS_URLS.Clear();
MyObj131Base.PAIDS.Clear();
Ent_twhcol130131 MyObj = (Ent_twhcol130131)MyObj131Base.clone();
decimal qtyReal = Convert.ToDecimal(QtyReal);
int PaidsInt = Convert.ToInt32(Paids);
decimal QtyPallets = Decimal.Round((qtyReal / PaidsInt), 4);
decimal QtyPalletFin = (qtyReal - (QtyPallets * PaidsInt)) + QtyPallets;
decimal Parcials = qtyReal / QtyPallets;
decimal QUANTITY = 0;
decimal CantPalletsComp = Math.Truncate(Parcials);
decimal 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 < PaidsInt; i++)
{
DataTable DTPalletContinue = twhcol130DAL.PaidMayorwhcol131(MyObj131Base.ORNO);
string SecuenciaPallet = "001";
if (DTPalletContinue.Rows.Count > 0)
{
foreach (DataRow item in DTPalletContinue.Rows)
{
if (consecutivoPalletID == 0)
{
consecutivoPalletID = Convert.ToInt32(item["T$PAID"].ToString().Trim().Substring(10, 3)) + 1;
}
else
{
consecutivoPalletID += 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().Replace(",", ".");
MyObj.QTYC = QtyPallets.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;
MyObj.LOAA = TargetLoca;
MyObj.QTYA = QtyPallets.ToString().Replace(",", ".");
MyObj.QTYAF = i == PaidsInt - 1 ? QtyPalletFin.ToString().Replace(",", ".") : QtyPallets.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";
}
return(JsonConvert.SerializeObject(MyObj));
}
