/// <summary> /// Execute operation. /// </summary> public override void Execute() { base.Execute(); BOMBIZ biz = new BOMBIZ(); //biz.UpdateWithPK(Data, OldUpperItemCode, OldLowerItemCode); }
/// <summary> /// Execute operation. /// </summary> public override void Execute() { base.Execute(); BOMBIZ biz = new BOMBIZ(); biz.Delete(Data); }
internal List <BOMSetupViewDTO> LoadIssueList(NZString ItemCD) { // get child part for add to transaction BOMBIZ bizBom = new BOMBIZ(); List <BOMSetupViewDTO> dtoBomList = bizBom.LoadChildPartWithLevelFix(ItemCD, 1); return(dtoBomList); }
protected void chkMRPFlag_CheckedChanged(object sender, EventArgs e) { cboMRPFlag.Enabled = !chkMRPFlag.Checked; if (chkMRPFlag.Checked && txtItemCode.Text != string.Empty) { BOMBIZ bizBOM = new BOMBIZ(); DTO.ItemProcessDTO dto = bizBOM.LoadLocationandMRPFLag((NZString)txtItemCode.Text); //cboMRPFlag.SelectedValue = dto.MRP_FLAG.ToString(); } }
protected void chkChildOrderLoc_CheckedChanged(object sender, EventArgs e) { cboOrderLoc.Enabled = !chkChildOrderLoc.Checked; if (chkChildOrderLoc.Checked && txtItemCode.Text != string.Empty) { BOMBIZ bizBOM = new BOMBIZ(); DTO.ItemProcessDTO dto = bizBOM.LoadLocationandMRPFLag((NZString)txtItemCode.Text); //cboOrderLoc.SelectedValue = dto.ORDER_LOC_CD.ToString(); } }
/// <summary> /// /// </summary> /// <param name="ParentItemCode">Parent of current item which need to check looping.</param> /// <param name="ItemCode">ItemCode which will checkinig.</param> /// <returns></returns> public ErrorItem LoopingUpCheck(NZString ParentItemCode, NZString ItemCode) { BOMBIZ biz = new BOMBIZ(); List <BOMSetupDTO> implosionList = biz.LoadBOMImplosion(ItemCode); for (int i = 0; i < implosionList.Count; i++) { if (implosionList[i].UPPER_ITEM_CD.Value == ParentItemCode.Value) { ErrorItem item = new ErrorItem(ItemCode.Owner, "MSG CUSTOM", "LoopingUpCheck fail."); return(item); } } return(null); }
private void SetOrderLoactionandMRPFlag() { for (int iRow = 0; iRow < shtView.RowCount; iRow++) { if (Convert.ToString(shtView.Cells[iRow, (int)eColView.CHILD_ORDER_LOC].Value) == string.Empty) { BOMBIZ bizBOM = new BOMBIZ(); ItemProcessDTO dto = bizBOM.LoadLocationandMRPFLag(Convert.ToString(shtView.Cells[iRow, (int)eColView.ITEM_CD].Value)); if (dto != null) { //shtView.Cells[iRow, (int)eColView.CHILD_ORDER_LOC].Value = dto.ORDER_LOC_CD; shtView.Cells[iRow, (int)eColView.CHILD_ORDER_LOC].ForeColor = Color.Gray; //shtView.Cells[iRow, (int)eColView.CHILD_ORDER_LOC].HorizontalAlignment = FarPoint.Win.Spread.she } } else { shtView.Cells[iRow, (int)eColView.CHILD_ORDER_LOC].ForeColor = Color.Black; } if (Convert.ToString(shtView.Cells[iRow, (int)eColView.MRP_FLAG].Value) == string.Empty) { BOMBIZ bizBOM = new BOMBIZ(); ItemProcessDTO dto = bizBOM.LoadLocationandMRPFLag(Convert.ToString(shtView.Cells[iRow, (int)eColView.ITEM_CD].Value)); if (dto != null) { //shtView.Cells[iRow, (int)eColView.MRP_FLAG].Value = dto.MRP_FLAG.StrongValue == string.Empty ? "" : bizBOM.LoadMRPFLag(dto.MRP_FLAG); shtView.Cells[iRow, (int)eColView.MRP_FLAG].ForeColor = Color.Gray; } } else { shtView.Cells[iRow, (int)eColView.MRP_FLAG].ForeColor = Color.Black; } } }
public List <BOMSetupDTO> LoadChildItem(NZString parentItemCode) { List <BOMSetupDTO> listResult = new List <BOMSetupDTO>(); //method นี้ไว้ใช้กับ Multi work result เท่านั้น เลยต้อง check ว่ามันมี level แรก ตัวเดียว //หลังจากได้ BOM ค่อยไปหา equivalent item มาให้ //กรณาอย่าแก้ไขให้ดึงข้อมูลBOM ได้หลายตัว ไม่งั้น multi work result จะผิด BOMBIZ biz = new BOMBIZ(); List <BOMSetupDTO> listExplosion = biz.LoadBOMExplosion(parentItemCode); int iCountLevel1 = 0; //เก็บ count level =1 int iIndexLevel1 = -1; //เก็บ index ของตัวที่ level =1 for (int iLength = 0; iLength < listExplosion.Count; iLength++) { if (listExplosion[iLength].LEVEL == 1) { iIndexLevel1 = iLength; iCountLevel1++; if (iCountLevel1 > 1) { break; } } } if (iCountLevel1 > 1 || iIndexLevel1 == -1) { throw new BusinessException(new ErrorItem(null, TKPMessages.eValidate.VLM0094.ToString())); } //ต้องเป็น 1 / 1 ระหว่าง upper , lower เท่านั้น if (!(listExplosion[iIndexLevel1].UPPER_QTY == 1 && listExplosion[iIndexLevel1].LOWER_QTY == 1)) { throw new BusinessException(new ErrorItem(null, TKPMessages.eValidate.VLM0098.ToString())); } //ItemBIZ bizItem = new ItemBIZ(); //ItemDTO dtoItem = bizItem.LoadItem(list[iIndexLevel1].LOWER_ITEM_CD); BOMSetupDTO dtoBOM = listExplosion[iIndexLevel1]; listResult.Add((BOMSetupDTO)dtoBOM.Clone()); //Load Equivalent Item ItemDTO dtoItem = new ItemDTO(); dtoItem.ITEM_CD = dtoBOM.LOWER_ITEM_CD; ItemBIZ bizItem = new ItemBIZ(); List <ItemEquivalentDTO> listEquivalent = bizItem.LoadEquivalentItem(dtoItem); foreach (ItemEquivalentDTO objEquivalent in listEquivalent) { BOMSetupDTO dtoBOMEquivalent = new BOMSetupDTO(); dtoBOMEquivalent.UPPER_ITEM_CD = parentItemCode; dtoBOMEquivalent.LOWER_ITEM_CD = objEquivalent.EQUIVALENT_ITEM_CD; dtoBOMEquivalent.UPPER_QTY = dtoBOM.UPPER_QTY; dtoBOMEquivalent.LOWER_QTY = dtoBOM.LOWER_QTY; //dtoBOMEquivalent.CHILD_ORDER_LOC_CD = objEquivalent.ORDER_LOC_CD; listResult.Add(dtoBOMEquivalent); } return(listResult); }
public DataTable LoadBOMList() { BOMBIZ biz = new BOMBIZ(); return(biz.LoadBOMList()); }
public List <BOMSetupViewDTO> LoadBOMSetup(NZString ITEM_CD) { BOMBIZ biz = new BOMBIZ(); return(biz.LoadBOMSetupView(ITEM_CD)); }
internal void SaveNewMovePart(MovePartUIDM model) { #region Validate ItemValidator itemValidator = new ItemValidator(); BusinessException businessException = itemValidator.CheckItemNotExist(model.MASTER_NO); if (businessException != null) { ValidateException.ThrowErrorItem(businessException.Error); } #endregion InventoryBIZ bizInv = new InventoryBIZ(); DealingConstraintBIZ bizConstraint = new DealingConstraintBIZ(); InventoryTransactionDTO dtoInvTrnsFrom = new InventoryTransactionDTO(); InventoryTransactionDTO dtoInvTrnsTo = new InventoryTransactionDTO(); #region From dtoInvTrnsFrom.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrnsFrom.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrnsFrom.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrnsFrom.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; //dtoInvTrnsListFrom.TRANS_ID = dtoInvTrnsFrom.ITEM_CD = model.MASTER_NO; dtoInvTrnsFrom.LOC_CD = model.FROM_PROCESS; //dtoInvTrnsFrom.LOT_NO = model.LOT_NO; //dtoInvTrnsListFrom.PACK_NO = string.Empty; dtoInvTrnsFrom.TRANS_DATE = model.MOVE_DATE; dtoInvTrnsFrom.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.MovePart).ToNZString(); dtoInvTrnsFrom.IN_OUT_CLS = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out).ToNZString(); dtoInvTrnsFrom.QTY = model.MOVE_QTY; //dtoInvTrnsListFrom.OBJ_ITEM_CD = //dtoInvTrnsListFrom.OBJ_ORDER_QTY = //dtoInvTrnsListFrom.REF_NO = //dtoInvTrnsListFrom.REF_SLIP_NO = //dtoInvTrnsListFrom.REF_SLIP_CLS = //dtoInvTrnsListFrom.OTHER_DL_NO = //dtoInvTrnsListFrom.SLIP_NO = dtoInvTrnsFrom.REMARK = model.REMARK; //dtoInvTrnsListFrom.DEALING_NO = //dtoInvTrnsListFrom.EXTERNAL_LOT_NO = //dtoInvTrnsListFrom.PRICE = //dtoInvTrnsListFrom.FOR_CUSTOMER = //dtoInvTrnsListFrom.FOR_MACHINE = dtoInvTrnsFrom.SHIFT_CLS = model.SHIFT_CLS; //dtoInvTrnsListFrom.REF_SLIP_NO2 = //dtoInvTrnsListFrom.NG_QTY = dtoInvTrnsFrom.TRAN_SUB_CLS = model.REASON; dtoInvTrnsFrom.SCREEN_TYPE = DataDefine.ScreenType.MovePartEntry.ToNZString(); //dtoInvTrnsListFrom.GROUP_TRANS_ID = //dtoInvTrnsListFrom.RESERVE_QTY = //dtoInvTrnsListFrom.NG_REASON = dtoInvTrnsFrom.EFFECT_STOCK = new NZInt(null, (int)DataDefine.eEFFECT_STOCK.Out); dtoInvTrnsFrom.LOT_REMARK = model.LOT_NO; dtoInvTrnsFrom.OLD_DATA = new NZInt(null, 0); dtoInvTrnsFrom.WEIGHT = model.WEIGHT; #endregion #region To dtoInvTrnsTo.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrnsTo.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrnsTo.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrnsTo.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; //dtoInvTrnsListFrom.TRANS_ID = dtoInvTrnsTo.ITEM_CD = model.MASTER_NO; dtoInvTrnsTo.LOC_CD = model.TO_PROCESS; //dtoInvTrnsTo.LOT_NO = model.LOT_NO; //dtoInvTrnsListFrom.PACK_NO = string.Empty; dtoInvTrnsTo.TRANS_DATE = model.MOVE_DATE; dtoInvTrnsTo.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.MovePart).ToNZString(); dtoInvTrnsTo.IN_OUT_CLS = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.In).ToNZString(); dtoInvTrnsTo.QTY = model.MOVE_QTY; //dtoInvTrnsListFrom.OBJ_ITEM_CD = //dtoInvTrnsListFrom.OBJ_ORDER_QTY = //dtoInvTrnsListFrom.REF_NO = //dtoInvTrnsListFrom.REF_SLIP_NO = //dtoInvTrnsListFrom.REF_SLIP_CLS = //dtoInvTrnsListFrom.OTHER_DL_NO = //dtoInvTrnsListFrom.SLIP_NO = dtoInvTrnsTo.REMARK = model.REMARK; //dtoInvTrnsListFrom.DEALING_NO = //dtoInvTrnsListFrom.EXTERNAL_LOT_NO = //dtoInvTrnsListFrom.PRICE = //dtoInvTrnsListFrom.FOR_CUSTOMER = //dtoInvTrnsListFrom.FOR_MACHINE = dtoInvTrnsTo.SHIFT_CLS = model.SHIFT_CLS; //dtoInvTrnsListFrom.REF_SLIP_NO2 = //dtoInvTrnsListFrom.NG_QTY = dtoInvTrnsTo.TRAN_SUB_CLS = model.REASON; dtoInvTrnsTo.SCREEN_TYPE = DataDefine.ScreenType.MovePartEntry.ToNZString(); //dtoInvTrnsListFrom.GROUP_TRANS_ID = //dtoInvTrnsListFrom.RESERVE_QTY = //dtoInvTrnsListFrom.NG_REASON = dtoInvTrnsTo.EFFECT_STOCK = new NZInt(null, (int)DataDefine.eEFFECT_STOCK.In); dtoInvTrnsTo.LOT_REMARK = model.LOT_NO; dtoInvTrnsTo.OLD_DATA = new NZInt(null, 0); dtoInvTrnsTo.WEIGHT = model.WEIGHT; #endregion #region Consumption List <InventoryTransactionDTO> listComponent = new List <InventoryTransactionDTO>(); DealingConstraintDTO dtoConstraint = bizConstraint.LoadDealingConstraint(model.FROM_PROCESS); if (dtoConstraint != null && dtoConstraint.COMPONENT_ITEM_USAGE.StrongValue == 1) { //get component usage BOMBIZ bizBOM = new BOMBIZ(); List <ComponentUsageDTO> components = bizBOM.LoadComponentUsage(model.MASTER_NO, model.MOVE_QTY); if (components != null) { foreach (ComponentUsageDTO component in components) { InventoryTransactionDTO dtoComponent = new InventoryTransactionDTO(); dtoComponent.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoComponent.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoComponent.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoComponent.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; //dtoComponent.TRANS_ID = dtoComponent.ITEM_CD = component.LOWER_ITEM_CD; dtoComponent.LOC_CD = model.FROM_PROCESS; //dtoComponent.LOT_NO = model.LOT_NO; //dtoComponent.PACK_NO = string.Empty; dtoComponent.TRANS_DATE = model.MOVE_DATE; dtoComponent.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.MoveConsumption).ToNZString(); dtoComponent.IN_OUT_CLS = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out).ToNZString(); dtoComponent.QTY = component.USAGE_QTY; //dtoComponent.OBJ_ITEM_CD = //dtoComponent.OBJ_ORDER_QTY = //dtoComponent.REF_NO = //dtoComponent.REF_SLIP_NO = //dtoComponent.REF_SLIP_CLS = //dtoComponent.OTHER_DL_NO = //dtoComponent.SLIP_NO = dtoComponent.REMARK = model.REMARK; //dtoComponent.DEALING_NO = //dtoComponent.EXTERNAL_LOT_NO = //dtoComponent.PRICE = //dtoComponent.FOR_CUSTOMER = //dtoComponent.FOR_MACHINE = dtoComponent.SHIFT_CLS = model.SHIFT_CLS; //dtoComponent.REF_SLIP_NO2 = //dtoComponent.NG_QTY = dtoComponent.TRAN_SUB_CLS = model.REASON; dtoComponent.SCREEN_TYPE = DataDefine.ScreenType.MovePartEntry.ToNZString(); //dtoComponent.GROUP_TRANS_ID = //dtoComponent.RESERVE_QTY = //dtoComponent.NG_REASON = dtoComponent.EFFECT_STOCK = new NZInt(null, (int)DataDefine.eEFFECT_STOCK.Out); dtoComponent.LOT_REMARK = model.LOT_NO; dtoComponent.OLD_DATA = new NZInt(null, 0); //dtoComponent.WEIGHT = model.WEIGHT; listComponent.Add(dtoComponent); } } #endregion } bizInv.AddMovePart(dtoInvTrnsFrom, dtoInvTrnsTo, listComponent); }