private void savePackingCheck(bool IsCheckProduct, bool IsUpdaterProdct) { //add by hiro 08/09/27 PackageFacade _Packfacade = new PackageFacade(DataProvider); PACKINGCHK newPackingCheck = _Packfacade.CreateNewPACKINGCHK(); newPackingCheck.Rcard = m_rcard; DBDateTime dbDateTime; dbDateTime = FormatHelper.GetNowDBDateTime(DataProvider); newPackingCheck.CheckAccessory = FormatHelper.TRUE_STRING; if (IsCheckProduct) { newPackingCheck.CheckProductCode = FormatHelper.TRUE_STRING; } else { newPackingCheck.CheckProductCode = FormatHelper.FALSE_STRING; } newPackingCheck.MUSER = ApplicationService.Current().UserCode; newPackingCheck.MDATE = dbDateTime.DBDate; newPackingCheck.MTIME = dbDateTime.DBTime; newPackingCheck.EATTRIBUTE1 = " "; object objGet = _Packfacade.GetPACKINGCHK(m_rcard); if (objGet != null) { if (((PACKINGCHK)objGet).EATTRIBUTE1.ToString().Trim() != string.Empty) { newPackingCheck.EATTRIBUTE1 = ((PACKINGCHK)objGet).EATTRIBUTE1.ToString(); } if (!IsUpdaterProdct) { newPackingCheck.CheckProductCode = ((PACKINGCHK)objGet).CheckProductCode.ToString(); } _Packfacade.DeletePACKINGCHK((PACKINGCHK)objGet); _Packfacade.AddPACKINGCHK(newPackingCheck); } else { _Packfacade.AddPACKINGCHK(newPackingCheck); } //end by hiro }
public override Messages Action(object act) { Messages msg = new Messages(); BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider domainProvider = null; if (act == null) { return(msg); } if ((act as IDCTClient).DBConnection != null) { domainProvider = (act as IDCTClient).DBConnection as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; } else { domainProvider = Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider() as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; (act as IDCTClient).DBConnection = domainProvider; } DataCollectFacade db = new DataCollectFacade(domainProvider); object[] objSimulation = db.GetSimulationFromCarton(strCarton); if (checkCompare) { if (objSimulation == null) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPAREAPPENDIX_NOTSUCCESS")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_WRAPPER")); this.Status = ActionStatus.PrepareData; return(msg); } else { object objSimulationRcrd = objSimulation[0]; //if (((Simulation)objSimulationRcrd).ItemCode.ToString().ToUpper() != act.ToString().ToUpper()) if (((Simulation)objSimulationRcrd).RunningCard.ToUpper().IndexOf(act.ToString().ToUpper()) != 0) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPAREAPPENDIX_NOTSUCCESS")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_WRAPPER")); this.Status = ActionStatus.PrepareData; return(msg); } else { msg.Add(new UserControl.Message(MessageType.Success, "$CS_COMPAREAPPENDIX_SUCCESS")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_COMMODITY")); DBDateTime dbDateTime; dbDateTime = FormatHelper.GetNowDBDateTime(domainProvider); PackageFacade _Packfacade = new PackageFacade(domainProvider); PACKINGCHK newPackingCheck = _Packfacade.CreateNewPACKINGCHK(); newPackingCheck.Rcard = ((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper(); newPackingCheck.CheckAccessory = FormatHelper.TRUE_STRING; newPackingCheck.CheckProductCode = FormatHelper.FALSE_STRING; newPackingCheck.MUSER = (act as IDCTClient).LoginedUser; newPackingCheck.MDATE = dbDateTime.DBDate; newPackingCheck.MTIME = dbDateTime.DBTime; newPackingCheck.EATTRIBUTE1 = " "; object objGet = _Packfacade.GetPACKINGCHK(((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper()); if (objGet != null) { newPackingCheck.CheckProductCode = ((PACKINGCHK)objGet).CheckProductCode.Trim(); newPackingCheck.EATTRIBUTE1 = ((PACKINGCHK)objGet).EATTRIBUTE1; _Packfacade.DeletePACKINGCHK((PACKINGCHK)objGet); _Packfacade.AddPACKINGCHK(newPackingCheck); } else { _Packfacade.AddPACKINGCHK(newPackingCheck); } this.Status = ActionStatus.PrepareData; checkCompare = false; return(msg); } } } else { if (objSimulation == null) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPARECOMMODITY_ISWRONG")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_COMMODITY")); this.Status = ActionStatus.PrepareData; return(msg); } else { object objSimulationRcrd = objSimulation[0]; ItemFacade itemfacade = new ItemFacade(domainProvider); object objitem = itemfacade.GetItem(((Simulation)objSimulation[0]).ItemCode.Trim().ToUpper(), GlobalVariables.CurrentOrganizations.First().OrganizationID); if (objitem == null) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPARECOMMODITY_ISWRONG")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_COMMODITY")); this.Status = ActionStatus.PrepareData; return(msg); } else { if (((Item)objitem).ItemProductCode.ToUpper().Trim() == act.ToString().ToUpper()) { base.Action(act); msg.Add(new UserControl.Message(MessageType.Success, "$CS_COMPARECOMMODITY_ISSUCCESS")); DBDateTime dbDateTime; dbDateTime = FormatHelper.GetNowDBDateTime(domainProvider); PackageFacade _Packfacade = new PackageFacade(domainProvider); PACKINGCHK newPackingCheck = _Packfacade.CreateNewPACKINGCHK(); newPackingCheck.Rcard = ((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper(); newPackingCheck.CheckAccessory = FormatHelper.TRUE_STRING; newPackingCheck.CheckProductCode = FormatHelper.TRUE_STRING; newPackingCheck.MUSER = (act as IDCTClient).LoginedUser; newPackingCheck.MDATE = dbDateTime.DBDate; newPackingCheck.MTIME = dbDateTime.DBTime; newPackingCheck.EATTRIBUTE1 = " "; object objGet = _Packfacade.GetPACKINGCHK(((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper()); if (objGet != null) { newPackingCheck.EATTRIBUTE1 = ((PACKINGCHK)objGet).EATTRIBUTE1; _Packfacade.DeletePACKINGCHK((PACKINGCHK)objGet); _Packfacade.AddPACKINGCHK(newPackingCheck); } else { _Packfacade.AddPACKINGCHK(newPackingCheck); } this.ObjectState = null; //this.Status = ActionStatus.PrepareData; strCarton = string.Empty; checkCompare = true; checkCycle = true; return(msg); } else { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPARECOMMODITY_ISWRONG")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_COMMODITY")); this.Status = ActionStatus.PrepareData; return(msg); } } } } }
public override Messages Action(object act) { Messages msg = new Messages(); BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider domainProvider = null; if (act == null) { return(msg); } if ((act as IDCTClient).DBConnection != null) { domainProvider = (act as IDCTClient).DBConnection as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; } else { domainProvider = Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider() as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; (act as IDCTClient).DBConnection = domainProvider; } DataCollectFacade db = new DataCollectFacade(domainProvider); object[] objSimulation = db.GetSimulationFromCarton(strCarton); if (objSimulation == null) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPAREAPPENDIX_NOTSUCCESS")); ProcessBeforeReturn(this.Status, msg); return(msg); } else { object objSimulationRcrd = objSimulation[0]; //if (((Simulation)objSimulationRcrd).ItemCode.ToString().ToUpper() != act.ToString().ToUpper()) if (((Simulation)objSimulationRcrd).RunningCard.ToUpper().IndexOf(act.ToString().ToUpper()) != 0) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPAREAPPENDIX_NOTSUCCESS")); ProcessBeforeReturn(this.Status, msg); return(msg); } else { msg.Add(new UserControl.Message(MessageType.Success, "$CS_COMPAREAPPENDIX_SUCCESS")); DBDateTime dbDateTime; dbDateTime = FormatHelper.GetNowDBDateTime(domainProvider); PackageFacade _Packfacade = new PackageFacade(domainProvider); PACKINGCHK newPackingCheck = _Packfacade.CreateNewPACKINGCHK(); newPackingCheck.Rcard = ((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper(); newPackingCheck.CheckAccessory = FormatHelper.TRUE_STRING; newPackingCheck.CheckProductCode = FormatHelper.FALSE_STRING; newPackingCheck.MUSER = (act as IDCTClient).LoginedUser; newPackingCheck.MDATE = dbDateTime.DBDate; newPackingCheck.MTIME = dbDateTime.DBTime; newPackingCheck.EATTRIBUTE1 = " "; object objGet = _Packfacade.GetPACKINGCHK(((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper()); if (objGet != null) { newPackingCheck.CheckProductCode = ((PACKINGCHK)objGet).CheckProductCode.Trim(); newPackingCheck.EATTRIBUTE1 = ((PACKINGCHK)objGet).EATTRIBUTE1; _Packfacade.DeletePACKINGCHK((PACKINGCHK)objGet); _Packfacade.AddPACKINGCHK(newPackingCheck); } else { _Packfacade.AddPACKINGCHK(newPackingCheck); } base.Action(act); this.ObjectState = null; strCarton = string.Empty; return(msg); } } }
public override Messages Action(object act) { Messages msg = new Messages(); BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider domainProvider = null; if (act == null) { return(msg); } if ((act as IDCTClient).DBConnection != null) { domainProvider = (act as IDCTClient).DBConnection as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; } else { domainProvider = Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider() as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; (act as IDCTClient).DBConnection = domainProvider; } DataCollectFacade db = new DataCollectFacade(domainProvider); object[] objSimulation = db.GetSimulationFromCarton(_CartonCode); if (objSimulation == null) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPARECOMMODITY_ISWRONG ")); ProcessBeforeReturn(this.Status, msg); return(msg); } else { object objSimulationRcrd = objSimulation[0]; ItemFacade itemfacade = new ItemFacade(domainProvider); object objitem = itemfacade.GetItem(((Simulation)objSimulation[0]).ItemCode.Trim().ToUpper(), GlobalVariables.CurrentOrganizations.First().OrganizationID); if (objitem == null) { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPARECOMMODITY_ISWRONG ")); ProcessBeforeReturn(this.Status, msg); return(msg); } else { if (((Item)objitem).ItemProductCode.ToUpper().Trim() == act.ToString().ToUpper()) { //add by hiro 08/10/06 DBDateTime dbDateTime; dbDateTime = FormatHelper.GetNowDBDateTime(domainProvider); PackageFacade _Packfacade = new PackageFacade(domainProvider); PACKINGCHK newPackingCheck = _Packfacade.CreateNewPACKINGCHK(); newPackingCheck.Rcard = ((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper(); newPackingCheck.CheckAccessory = FormatHelper.FALSE_STRING; newPackingCheck.CheckProductCode = FormatHelper.TRUE_STRING; newPackingCheck.MUSER = (act as IDCTClient).LoginedUser; newPackingCheck.MDATE = dbDateTime.DBDate; newPackingCheck.MTIME = dbDateTime.DBTime; newPackingCheck.EATTRIBUTE1 = " "; object objGet = _Packfacade.GetPACKINGCHK(((Simulation)objSimulationRcrd).RunningCard.ToString().ToUpper()); if (objGet != null) { newPackingCheck.CheckAccessory = ((PACKINGCHK)objGet).CheckAccessory.Trim(); newPackingCheck.EATTRIBUTE1 = ((PACKINGCHK)objGet).EATTRIBUTE1; _Packfacade.DeletePACKINGCHK((PACKINGCHK)objGet); _Packfacade.AddPACKINGCHK(newPackingCheck); } else { _Packfacade.AddPACKINGCHK(newPackingCheck); } //end by hiro base.Action(act); msg.Add(new UserControl.Message(MessageType.Success, "$CS_COMPARECOMMODITY_ISSUCCESS ")); _CartonCode = string.Empty; return(msg); } else { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPARECOMMODITY_ISWRONG ")); ProcessBeforeReturn(this.Status, msg); return(msg); } } } }
public override Messages Action(object act) { Messages msg = new Messages(); BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider domainProvider = null; if (act == null) { return(msg); } if ((act as IDCTClient).DBConnection != null) { domainProvider = (act as IDCTClient).DBConnection as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; } else { domainProvider = Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider() as BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider; (act as IDCTClient).DBConnection = domainProvider; } if (m_FlowControl == 1) { string itemCode = ((Item)_item).ItemCode.ToString(); strCarton = act.ToString().Trim().ToUpper(); if (((Item)_item).NeedCheckCarton == FormatHelper.TRUE_STRING) { if (strRcard.StartsWith(itemCode, StringComparison.CurrentCultureIgnoreCase)) { if (string.Compare(strRcard, strCarton, true) == 0) { msg.Add(new UserControl.Message(MessageType.Error, "$Error_CartonNotMatchTheRule")); msg.Add(new UserControl.Message(MessageType.Success, "$CS_PLEASE_INPUT_CARTONNO")); this.Status = ActionStatus.PrepareData; return(msg); } else { if (string.Compare(strRcard.Replace(" ", ""), strCarton.Replace(" ", ""), true) != 0) { msg.Add(new UserControl.Message(MessageType.Error, "$Error_CartonCheckFailed")); msg.Add(new UserControl.Message(MessageType.Success, "$CS_PLEASE_INPUT_CARTONNO")); this.Status = ActionStatus.PrepareData; return(msg); } else { msg.Add(new UserControl.Message(MessageType.Success, "$CARTON_COMPARE_ISSUCCESS")); } } } else { if (string.Compare(strRcard, strCarton, true) == 0) { msg.Add(new UserControl.Message(MessageType.Success, "$CARTON_COMPARE_ISSUCCESS")); } else { msg.Add(new UserControl.Message(MessageType.Error, "$Error_CartonCheckFailed")); msg.Add(new UserControl.Message(MessageType.Success, "$CS_PLEASE_INPUT_CARTONNO")); this.Status = ActionStatus.PrepareData; return(msg); } } } object obj = (new Package.PackageFacade(domainProvider)).GetCARTONINFO(act.ToString().Trim().ToUpper()); if (obj != null && ((CARTONINFO)obj).CAPACITY.ToString() == ((CARTONINFO)obj).COLLECTED.ToString()) { msg.Add(new UserControl.Message(MessageType.Error, "$CARTON_ALREADY_FILL_OUT")); msg.Add(new UserControl.Message(MessageType.Success, "$CS_PLEASE_INPUT_CARTONNO")); this.Status = ActionStatus.PrepareData; return(msg); } else { m_FlowControl++; msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_WRAPPER")); this.Status = ActionStatus.PrepareData; return(msg); } } else { //if (((Simulation)_objSimulation).ItemCode.ToUpper().Trim() == act.ToString().ToUpper()) if (((Simulation)_objSimulation).RunningCard.ToUpper().IndexOf(act.ToString().ToUpper()) == 0) { ActionOnLineHelper actionOnLineHelper = new ActionOnLineHelper(domainProvider); BenQGuru.eMES.DataCollect.Action.ActionFactory actionFactory = new BenQGuru.eMES.DataCollect.Action.ActionFactory(domainProvider); IAction actionCartonPack = actionFactory.CreateAction(ActionType.DataCollectAction_Carton); //((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)domainProvider).PersistBroker.OpenConnection(); msg = actionOnLineHelper.GetIDInfo(strRcard); string cartonno = FormatHelper.CleanString(strCarton); IDCTClient client = act as IDCTClient; //add by hiro 08/09/28 DBDateTime dbDateTime; dbDateTime = FormatHelper.GetNowDBDateTime(domainProvider); PackageFacade _Packfacade = new PackageFacade(domainProvider); PACKINGCHK newPackingCheck = _Packfacade.CreateNewPACKINGCHK(); newPackingCheck.Rcard = ((Simulation)_objSimulation).RunningCard.ToString().ToUpper(); newPackingCheck.CheckAccessory = FormatHelper.TRUE_STRING; newPackingCheck.CheckProductCode = FormatHelper.FALSE_STRING; newPackingCheck.MUSER = (act as IDCTClient).LoginedUser; newPackingCheck.MDATE = dbDateTime.DBDate; newPackingCheck.MTIME = dbDateTime.DBTime; newPackingCheck.EATTRIBUTE1 = " "; object objGet = _Packfacade.GetPACKINGCHK(((Simulation)_objSimulation).RunningCard.ToString().ToUpper()); if (objGet != null) { _Packfacade.DeletePACKINGCHK((PACKINGCHK)objGet); _Packfacade.AddPACKINGCHK(newPackingCheck); } else { _Packfacade.AddPACKINGCHK(newPackingCheck); } //end by hiro Messages msgTwo = new Messages(); domainProvider.BeginTransaction(); try { if (msg.IsSuccess()) { ProductInfo product = (ProductInfo)msg.GetData().Values[0]; if (product.LastSimulation == null) { base.Action(act); msgTwo.Add(new UserControl.Message(new Exception("$Error_LastSimulation_IsNull!"))); this.ObjectState = null; return(msgTwo); } CartonPackEventArgs cartonPackEventArgs = new CartonPackEventArgs(ActionType.DataCollectAction_Carton, strRcard, client.LoginedUser, client.ResourceCode, "", cartonno, product); msgTwo.AddMessages(actionCartonPack.Execute(cartonPackEventArgs)); } if (msgTwo.IsSuccess()) { domainProvider.CommitTransaction(); } else { domainProvider.RollbackTransaction(); msgTwo.Add(new UserControl.Message(MessageType.Normal, "$CS_Please_Input_RunningCard")); this.Status = ActionStatus.PrepareData; this.FlowDirect = FlowDirect.WaitingInput; this.ObjectState = null; this.clearValue(); return(msgTwo); } } catch (Exception ex) { domainProvider.RollbackTransaction(); msg.Add(new UserControl.Message(ex)); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_Please_Input_RunningCard")); this.Status = ActionStatus.PrepareData; this.FlowDirect = FlowDirect.WaitingInput; this.ObjectState = null; this.clearValue(); return(msg); } finally { ((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)domainProvider).PersistBroker.CloseConnection(); } base.Action(act); msg.Add(new UserControl.Message(MessageType.Success, "$CS_COMPAREAPPENDIX_SUCCESS")); msg.Add(new UserControl.Message(MessageType.Success, "$CS_RCARD_CARTON_SUCCESS [" + strCarton + "]")); this.ObjectState = null; this.clearValue(); return(msg); } else { msg.Add(new UserControl.Message(MessageType.Error, "$CS_COMPAREAPPENDIX_NOTSUCCESS")); msg.Add(new UserControl.Message(MessageType.Normal, "$CS_PLEASE_INPUT_WRAPPER")); this.Status = ActionStatus.PrepareData; return(msg); } } }