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