using AppData; using Newtonsoft.Json; using NKC_SDK; using SteamWare; using System; using System.Data; using System.Drawing.Imaging; using System.Linq; using System.Threading; namespace NKC_WF.WebUserControls { public partial class cmp_unloadSmart : BaseUserControl { #region Protected Fields protected string redMachUnloadTable = "NKC:SERV:MACH_UNLOAD:TABLES"; #endregion Protected Fields protected string PlaceCodFix { get => PlaceCod != "VIRTNE" ? PlaceCod : MachineSel; } #region Protected Properties protected DS_App.BinsDataTable currBinTab { get { DS_App.BinsDataTable answ = null; string redKey = $"{redMachUnloadTable}:currBinTab:{itemIdSelected}"; string rawVal = memLayer.ML.getRSV(redKey); // cerco su redis... if (string.IsNullOrEmpty(rawVal)) { // se non trovo --> DB answ = DLMan.taBN.getByItemID(itemIdSelected); string rawData = JsonConvert.SerializeObject(answ); // salvo in redis... TTL 2 sec memLayer.ML.setRSV(redKey, rawData, 2); } else { answ = JsonConvert.DeserializeObject(rawVal); } return answ; } } protected DS_App.CartsDataTable currCartTab { get { DS_App.CartsDataTable answ = null; string redKey = $"{redMachUnloadTable}:currCartTab:{itemIdSelected}"; string rawVal = memLayer.ML.getRSV(redKey); // cerco su redis... if (string.IsNullOrEmpty(rawVal)) { // se non trovo --> DB answ = DLMan.taCR.getByItemID(itemIdSelected); string rawData = JsonConvert.SerializeObject(answ); // salvo in redis... TTL 2 sec memLayer.ML.setRSV(redKey, rawData, 2); } else { answ = JsonConvert.DeserializeObject(rawVal); } return answ; } } /// /// ID univoco da IP /// protected string DeviceId { set { hfDeviceId.Value = value; } get { return hfDeviceId.Value; } } /// /// Comando barcode letto /// protected string lastCmd { get { return hfLastBCode.Value; } set { hfLastBCode.Value = value; lastValidCmd = value; } } /// /// ULTIMO Comando barcode VALIDO (!="") letto /// protected string lastValidCmd { get { return hfLastValidBCode.Value; } set { // solo se è !="" if (!string.IsNullOrEmpty(value)) { hfLastValidBCode.Value = value; } } } protected string secOp { get { return hfSecOp.Value; } set { hfSecOp.Value = value; } } /// /// Sheet selezionato... /// protected int SheetID { set { hfSheetID.Value = value.ToString(); } get { int answ = 0; int.TryParse(hfSheetID.Value, out answ); return answ; } } protected bool showBin { set { hfShowBin.Value = value.ToString(); } get { bool answ = false; bool.TryParse(hfShowBin.Value, out answ); return answ; } } protected bool showCart { set { hfShowCart.Value = value.ToString(); } get { bool answ = false; bool.TryParse(hfShowCart.Value, out answ); return answ; } } protected bool showSecOp { set { hfShowSecOp.Value = value.ToString(); } get { bool answ = false; bool.TryParse(hfShowSecOp.Value, out answ); return answ; } } #endregion Protected Properties #region Public Properties /// /// Batch corrente... /// public int BatchId { set { hfBatchID.Value = value.ToString(); } get { int answ = 0; int.TryParse(hfBatchID.Value, out answ); return answ; } } public int itemIdSelected { get { int answ = 0; int.TryParse(hfItemID.Value, out answ); return answ; } set { hfItemID.Value = value.ToString(); bool showBtn = value != 0; // fix visibilità lbtCancel.Visible = showBtn; lbtScrapped.Visible = showBtn; lbtParkArea.Visible = showBtn; lbtResetSel.Visible = showBtn; } } /// /// Macchina letta /// public string MachineSel { get { return cmp_MachSelSmart.MachineSel; } set { PlaceCod = value; cmp_MachSelSmart.MachineSel = value; } } #endregion Public Properties #region Private Methods private void Cmp_barcode_eh_doRefresh(object sender, EventArgs e) { bool doRaiseEv = false; // processo evento.. lastCmd = cmp_barcode.inputAcquired.ToUpper(); //Thread.Sleep(1000); doRaiseEv = processLastCmd(doRaiseEv); // reset comando cmp_barcode.inputAcquired = ""; ComLib.man.resetSheetUnload(SheetID); // aggiorno... doUpdate(); if (doRaiseEv) { resetMessageDivs(); } } private void Cmp_barcode_eh_doReset(object sender, EventArgs e) { resetMessages(); resetButtons(); } private void doUpdate() { // reset grafico icnCart.Attributes.Remove("class"); icnCart.Attributes.Add("class", "btn btn-sm btn-block btn-outline-secondary"); icnBin.Attributes.Remove("class"); icnBin.Attributes.Add("class", "btn btn-sm btn-block btn-outline-secondary"); icnSecOp.Attributes.Remove("class"); icnSecOp.Attributes.Add("class", "btn btn-sm btn-block btn-outline-secondary"); // in base al secondo mostro uno o altro... if (showCart) { icnCart.Attributes.Remove("class"); icnCart.Attributes.Add("class", "btn btn-sm btn-block btn-success"); // fix visualizzazione di inviato al cart // controllo SE HO cart if (currCartTab.Count >= 1) { var cartRow = currCartTab[0]; // imposto OUT lblDestination.Text = $"SEND TO CART C{cartRow.CartIndex} ({cartRow.CartDtmx})"; } else { lblDestination.Text = $"ERROR SEARCHING CART: {currCartTab.Count} found!"; } lblDestination.CssClass = "text-success"; } else if (showBin) { icnBin.Attributes.Remove("class"); icnBin.Attributes.Add("class", "btn btn-sm btn-block btn-primary"); if (currBinTab.Count == 1) { var binRow = currBinTab[0]; lblDestination.Text = $"SEND TO BIN B{binRow.BinIndex} ({binRow.BinDtmx})"; } else { lblDestination.Text = $"ERROR SEARCHING BIN: {currBinTab.Count} found!"; } lblDestination.CssClass = "text-primary"; } if (showSecOp) { icnSecOp.Attributes.Remove("class"); icnSecOp.Attributes.Add("class", "btn btn-sm btn-block btn-info"); lblLastBCode.Text = $"DO SEC OP: {secOp}"; lblLastBCode.CssClass = "text-info"; } } /// /// Processo il DataMatrix letto /// /// /// /// private void processItemSuggestion(codeType tipoCod, string rawData, int codeInt) { displMessage("", false); DS_App.ItemListDataTable tabItem = null; DataLayer DLMan = new DataLayer(); string message = ""; // processo suggerimenti x ITEM / cart / bin dato suo RawData (Dtmx) e Cod univoco (intero) switch (tipoCod) { case codeType.Item: tabItem = DLMan.taIL.getBySearch(codeInt, rawData, 0, 999); if (tabItem.Count == 1) { showItemDetail(true, tabItem[0], false); } else if (tabItem.Count == 0) { showItemDetail(false, null, true); } break; case codeType.ItemGeneric: // PRIMA CERCA SE ne ho in stato 1..3 tabItem = DLMan.taIL.getBySearch(0, rawData, 1, 3); if (tabItem.Count == 0) { // se NON ne trovo cerci FINO a stato 5... tabItem = DLMan.taIL.getBySearch(0, rawData, 1, 5); } if (tabItem.Count == 1) { showItemDetail(true, tabItem[0], false); } else if (tabItem.Count == 0) { showItemDetail(false, null, true); } break; case codeType.Cart: // verifico NON SIA richiesto PAINT if (showBin) { displError(traduci("WrongActionBinReq"), true); } else { if (currCartTab.Count >= 1) { // controllo se sia quello corretto if (rawData != currCartTab[0].CartDtmx) { displError(traduci("WrongActionCart"), true); } else { // dichiaro che è depositato DLMan.taIL.updateStatus(itemIdSelected, 3, PlaceCodFix); int cartIndex = 0; try { cartIndex = currCartTab[0].CartIndex; } catch { } message = $"{traduci("Part")} {itemIdSelected} {traduci("PutInCart")} C{cartIndex} {rawData}"; lblDestination.Text = message; lgInfo($"cmp_unloadSmart | Status --> 3 | {message} | PlaceCod: {PlaceCodFix}"); resetSelection(false); resetButtons(); } } } break; case codeType.Bin: // verifico NON SIA richiesto PAINT if (showCart) { displError(traduci("WrongActionCartReq"), true); } else { if (currBinTab.Count == 1) { // controllo se sia quello corretto if (rawData != currBinTab[0].BinDtmx) { displError(traduci("WrongActionBin"), true); } else { // dichiaro che è depositato DLMan.taIL.updateStatus(itemIdSelected, 4, PlaceCodFix); message = $"{traduci("Part")} {itemIdSelected} {traduci("PutInBin")} {rawData}"; lblDestination.Text = message; lgInfo($"cmp_unloadSmart | Status --> 4 | {message} | PlaceCod: {PlaceCodFix}"); resetSelection(false); resetButtons(); } } } break; case codeType.SecScreen: // se item già letto if (divItemDet.Visible) { int defaultSecScreenShowTimeout = memLayer.ML.CRI("defaultSecScreenShowTimeout"); ComLib.setSecScreenRequest(rawData, lblItemDtmx.Text, 60 * defaultSecScreenShowTimeout); message = $"{traduci("PartToSecScreen")} | {lblItemDtmx.Text} ! {defaultSecScreenShowTimeout} min"; displMessage(message, false); lgDebug($"cmp_unloadSmart | SecScreen | {message} | PlaceCod: {PlaceCodFix}"); } else { // chiedo di leggere un ITEM prima... displError("Please read ITEM before Screen and Retry", false); } break; default: break; } } private bool processLastCmd(bool doRaiseEv) { if (string.IsNullOrEmpty(lastCmd)) doRaiseEv = true; // processiamo barcode letto decodedData decoData = DLMan.decodeBcode(lastCmd); switch (decoData.codeType) { case codeType.UNK: cmp_barcode.showOutput(cssClass.danger, $"Unknown Data: {decoData.rawData} --> no action"); resetSelection(false); doRaiseEv = true; break; case codeType.Item: if (string.IsNullOrEmpty(MachineSel)) { cmp_barcode.showOutput(cssClass.danger, $"{traduci("MissingMachineSel")}: {decoData.rawData} --> {traduci("NoValiAction")}"); } else { tryPickup(decoData.rawData); cmp_barcode.showOutput(cssClass.success, $"Valid IT Code: {decoData.rawData}"); processItemSuggestion(decoData.codeType, decoData.rawData, decoData.codeInt); } break; case codeType.ItemGeneric: if (string.IsNullOrEmpty(MachineSel)) { cmp_barcode.showOutput(cssClass.danger, $"{traduci("MissingMachineSel")}: {decoData.rawData} --> {traduci("NoValiAction")}"); } else { tryPickup(decoData.rawData); cmp_barcode.showOutput(cssClass.success, $"Valid IG Code: {decoData.rawData}"); processItemSuggestion(decoData.codeType, decoData.rawData, decoData.codeInt); } break; case codeType.Material: cmp_barcode.showOutput(cssClass.warning, $"Material - ignored: {decoData.description}"); doRaiseEv = true; break; case codeType.Sheet: cmp_barcode.showOutput(cssClass.warning, $"Sheet - ignored: {decoData.description}"); doRaiseEv = true; break; case codeType.Stack: cmp_barcode.showOutput(cssClass.warning, $"BUNK - ignored: {decoData.description}"); doRaiseEv = true; break; case codeType.OtherItem: cmp_barcode.showOutput(cssClass.warning, $"Generic PART - ignored: {decoData.description}"); doRaiseEv = true; break; case codeType.Batch: cmp_barcode.showOutput(cssClass.warning, $"Batch - ignored: {decoData.description}"); doRaiseEv = true; break; case codeType.Cart: if (string.IsNullOrEmpty(MachineSel)) { cmp_barcode.showOutput(cssClass.danger, $"{traduci("MissingMachineSel")}: {decoData.rawData} --> {traduci("NoValiAction")}"); } else { cmp_barcode.showOutput(cssClass.success, $"Valid CR Code: {decoData.description}"); processItemSuggestion(decoData.codeType, decoData.rawData, decoData.codeInt); } break; case codeType.Bin: if (string.IsNullOrEmpty(MachineSel)) { cmp_barcode.showOutput(cssClass.danger, $"{traduci("MissingMachineSel")}: {decoData.rawData} --> {traduci("NoValiAction")}"); } else { cmp_barcode.showOutput(cssClass.success, $"Valid BN Code: {decoData.description}"); processItemSuggestion(decoData.codeType, decoData.rawData, decoData.codeInt); } break; case codeType.SecScreen: if (string.IsNullOrEmpty(MachineSel)) { cmp_barcode.showOutput(cssClass.danger, $"{traduci("MissingMachineSel")}: {decoData.rawData} --> {traduci("NoValiAction")}"); } else { cmp_barcode.showOutput(cssClass.success, $"Valid Screen Code: {decoData.description}"); processItemSuggestion(decoData.codeType, decoData.rawData, decoData.codeInt); } break; case codeType.MachSelection: // controllo che la macchina esista... var listMacc = DLMan.taPlac.GetData(); var trovata = listMacc.Where(x => x.ShowSel && x.PlaceCod == decoData.code).FirstOrDefault(); if (trovata != null) { MachineSel = decoData.code; cmp_barcode.showOutput(cssClass.success, $"{traduci("MachineSel")}: {decoData.code}"); } else { cmp_barcode.showOutput(cssClass.danger, $"Unknown machine: {decoData.rawData} --> no action"); resetSelection(false); } break; default: cmp_barcode.showOutput(cssClass.danger, $"Unknown Data: {decoData.rawData} --> no action"); resetSelection(false); break; } return doRaiseEv; } /// /// resetto buttons azioni /// private void resetButtons() { lbtCancel.Visible = false; lbtScrapped.Visible = false; lbtParkArea.Visible = false; lbtResetSel.Visible = false; } /// /// Resetto testi /// private void resetMessages() { lblDestination.CssClass = "text-secondary"; lblDestination.Text = ""; lblLastBCode.Text = ""; } /// /// Reset booleani visualizzazione /// private void resetShowData() { showCart = false; showBin = false; showSecOp = false; } /// /// Mostra o nasconde dettaglio su ITEM letto /// /// /// private void showItemDetail(bool showItem, DS_App.ItemListRow itemRow, bool showError) { resetShowData(); divItemDet.Visible = showItem; divItemError.Visible = showError; if (showError) { displError("Item not found", false); } if (showItem) { lblItemCode.Text = itemRow.ItemExtCode; lblItemDesc.Text = itemRow.ItemDesc; lblItemDtmx.Text = itemRow.ItemDtmx; itemIdSelected = itemRow.ItemID; // CONTROLLO SIA in stato 1 --> worked, 2--> selected, 100--> parked... switch (itemRow.StatusID) { case 0: displError("ERROR: Item not ready", false); break; case 1: case 2: case 100: // salvo che è in STATO 2 (picked up) DataLayer currDataLayer = new DataLayer(); currDataLayer.taIL.updateStatus(itemRow.ItemID, 2, PlaceCodFix); // verifico cosa devo mostrare come PROX passaggio... showCart = string.IsNullOrEmpty(itemRow.ProcessesReq); showBin = (itemRow.ProcessesReq.Contains("PaintFlag")); secOp = itemRow.PostProcList; showSecOp = (!string.IsNullOrEmpty(secOp)); doUpdate(); break; case 3: displError("Item already on CART!", false); break; case 4: // fino a concorrenza qta richiesta sposto, POI do errori displError("ALL Item already scanned on BIN!", false); break; case 5: displError("Item already at KIT STATION!", false); break; case 990: displError("Item declared SCRAP!", false); break; case 991: displError("Item declared SCRAP with CNC program created!", false); break; default: displError("ERROR: Item status UNKNOWN!", false); break; } } } #endregion Private Methods #region Protected Methods /// /// Mostra errore ed effettua reset vari... /// /// /// protected void displError(string errorMessage, bool resetStatus) { lgError($"UnloadSmart.DisplayLog | {errorMessage}"); lblErrorMsg.Text = errorMessage; divItemError.Visible = true; resetSelection(resetStatus); } /// /// Mostra INFO ed effettua reset vari... /// /// /// protected void displMessage(string currMessage, bool resetStatus) { lblInfoMessage.Text = currMessage; divInfoMessage.Visible = true; resetSelection(resetStatus); } protected void lbtCancel_Click(object sender, EventArgs e) { // resetto item selezionato... try { DLMan.taIL.updateStatus(itemIdSelected, 1, PlaceCodFix); lgInfo($"cmp_unloadSmart | cancelSelect | Status --> 1 | itemIdSelected: {itemIdSelected} | PlaceCod: {PlaceCodFix}"); } catch { } resetSelection(true); showItemDetail(false, null, false); } /// /// imposto a parcheggiato /// /// /// protected void lbtParkArea_Click(object sender, EventArgs e) { // resetto item selezionato... DLMan.taIL.updateStatus(itemIdSelected, 100, PlaceCodFix); lgInfo($"cmp_unloadSmart | parkArea | Status --> 100 | itemIdSelected: {itemIdSelected} | PlaceCod: {PlaceCodFix}"); resetSelection(false); showItemDetail(false, null, false); lblLastBCode.Text = traduci("PartParked"); lblLastBCode.CssClass = "text-secondary"; } protected void lbtResetSel_Click(object sender, EventArgs e) { var tabSheet = DLMan.taSHL.getByItemID(itemIdSelected, PlaceCodFix); if (tabSheet.Count == 1) { resetShowData(); // resetto sheet selezionato... DLMan.taIL.updateSheetStatusPU(tabSheet[0].SheetID, PlaceCodFix); lgInfo($"cmp_unloadSmart | updateSheetStatusPU | SheetID: {tabSheet[0].SheetID} | PlaceCod: {PlaceCodFix}"); resetSelection(true); showItemDetail(false, null, false); } } /// /// Imposto come danneggiato/scrapped da rilavorare offline /// /// /// protected void lbtScrapped_Click(object sender, EventArgs e) { // resetto item selezionato... DLMan.taIL.updateStatus(itemIdSelected, 990, PlaceCodFix); lgInfo($"cmp_unloadSmart | SCRAP | Status --> 990 | itemIdSelected: {itemIdSelected} | PlaceCod: {PlaceCodFix}"); resetSelection(false); showItemDetail(false, null, false); lblLastBCode.Text = traduci("PartScrapped"); lblLastBCode.CssClass = "text-danger"; // riprocesso barcode... lastCmd = lastValidCmd; processLastCmd(false); resetButtons(); } protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { resetShowData(); resetMessages(); resetButtons(); updateCurrData(); } cmp_barcode.eh_doRefresh += Cmp_barcode_eh_doRefresh; cmp_barcode.eh_doReset += Cmp_barcode_eh_doReset; // resetto lblLastBCode.Text = "------"; lblDestination.Text = "--"; } /// /// Resetta mesaggi ed errori /// protected void resetMessageDivs() { divInfoMessage.Visible = false; lblInfoMessage.Text = ""; divItemError.Visible = false; lblErrorMsg.Text = ""; } /// /// Reset selezione item + blocchi suggerimento + sel REDIS x pagina unload /// /// protected void resetSelection(bool resetStatus) { if (resetStatus) { try { // SE item esiste... var tabItem = DLMan.taIL.getBySearch(itemIdSelected, itemIdSelected.ToString(), 0, 999); if (tabItem.Count == 1) { // riposto item a status 1... DLMan.taIL.updateStatus(itemIdSelected, 1, PlaceCodFix); lgDebug($"cmp_unloadSmart | resetSelection | Status --> 1 | itemIdSelected: {itemIdSelected} | PlaceCod: {PlaceCodFix}"); } } catch { } // elimino item sel... itemIdSelected = 0; } resetShowData(); if (SheetID > 0) { ComLib.resetItemPickup(SheetID, DeviceId); lgDebug($"ComLib.resetItemPickup | SheetID {SheetID} | DeviceId: {DeviceId}"); } else { lgInfo($"Errore in resetSelection: SheetID=0 | resetStatus: {resetStatus} | DeviceId: {DeviceId}"); } } /// /// Prova a fare pickup (SOLO SE il mio item è nel foglio corrente...) /// /// protected void tryPickup(string itemDtmx) { // salvo in item sel... updateCurrData(); if (SheetID > 0) { bool fatto = ComLib.saveItemPickup(SheetID, DeviceId, itemDtmx); lgInfo($"cmp_unloadSmart | tryPickup | item: {itemDtmx} | SheetID: {SheetID} | DeviceId: {DeviceId} | done: {fatto}"); } else { lgInfo($"Errore in tryPickup: SheetID=0 | itemDtmx: {itemDtmx}"); } } /// /// Aggiorna dati correnti (IP, batch, sheet...) /// protected void updateCurrData() { if (BatchId > 0) { // 2023.10.27 passaggio versione cached // FORSE 5/5?!? #if false DataLayer DLMan = new DataLayer(); var sheetList = DLMan.taSHL.getByMLStatus(BatchId, 3, 5, PlaceCodFix); #endif var sheetList = ComLib.SheetTabGet(PlaceCodFix, BatchId, 3, 5); if (sheetList.Count > 0) { SheetID = sheetList[0].SheetID; } } DeviceId = ComLib.GetIPAddress().Replace(".", "0").Replace(":", "0"); } #endregion Protected Methods protected void lbtForceReload_Click(object sender, EventArgs e) { lgInfo("UnloadSmart: Requested ForceReload by user"); Response.Redirect(Request.RawUrl); } } }