Beispiel #1
0
        /// <summary>
        /// Load data for Receiving Entry.
        /// </summary>
        /// <param name="receiveNo"></param>
        /// <returns></returns>
        public ReceivingEntryUIDM LoadData(NZString receiveNo)
        {
            InventoryBIZ biz = new InventoryBIZ();
            List <InventoryTransactionViewDTO> listViewDTO = biz.LoadTransactionViewByReceiveNo(receiveNo);

            if (listViewDTO != null)
            {
                if (listViewDTO.Count > 0)
                {
                    ReceivingEntryUIDM model = MapDTOToUIDM(listViewDTO[0]);
                    model.DATA_VIEW = DTOUtility.ConvertListToDataTable(listViewDTO);

                    //== Ensure that data has not modified.
                    model.DATA_VIEW.AcceptChanges();

                    return(model);
                }
            }
            return(new ReceivingEntryUIDM());
        }
Beispiel #2
0
        private void LoadData(NZDateTime FromPeriod, NZDateTime ToPeriod, NZString ItemFrom, NZString ItemTo, NZString LotNo)
        {
            try
            {
                if (ItemFrom == "")
                {
                    ItemFrom = null;
                }
                if (ItemTo == "")
                {
                    ItemTo = null;
                }

                bool GroupByItem = rdoGroupItem.Checked;

                NGInquiryController     ctlInvent = new NGInquiryController();
                List <NGInquiryViewDTO> dto       = ctlInvent.LoadNGInquiry(FromPeriod, ToPeriod, ItemFrom, ItemTo, GroupByItem, LotNo);
                if (dto.Count == 0)
                {
                    MessageDialog.ShowBusiness(this, new EVOFramework.Message(TKPMessages.eInformation.INF0001.ToString()));
                    return;
                }

                m_dtAllData = DTOUtility.ConvertListToDataTable(dto);
                DataTable dtView = m_dtAllData.Clone();
                foreach (DataRow dr in m_dtAllData.Rows)
                {
                    dtView.ImportRow(dr);
                }

                //Hide Column When ByGroupItem
                RefreshSpreadColumn();

                fpView.DataSource = dtView;
                CtrlUtil.MappingDataFieldWithEnum(shtView, typeof(eColumns));
            }
            catch (Exception ex)
            {
                MessageDialog.ShowBusiness(this, ex.Message);
            }
        }
Beispiel #3
0
        private void InitialComboBox()
        {
            cboCustomerCode.Format += Common.ComboBox_Format;

            LookupDataBIZ bizLookup = new LookupDataBIZ();

            // Lookup To CustomerLocation
            LookupData lookupCustomer = bizLookup.LoadLookupLocation(new NZString[] { (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.Customer)
                                                                                      , (NZString)DataDefine.Convert2ClassCode(DataDefine.eLOCATION_CLS.CustomerVendor) });

            cboCustomerCode.LoadLookupData(lookupCustomer);
            cboCustomerCode.SelectedIndex = -1;

            ClassListBIZ biz = new ClassListBIZ();
            DataTable    dt  = DTOUtility.ConvertListToDataTable <ClassListDTO>(biz.LoadByClassInfo("term_of_payment".ToNZString()));

            cboTermOfPayment.DataSource    = dt;
            cboTermOfPayment.ValueMember   = "CLS_CD";
            cboTermOfPayment.DisplayMember = "TERM_OF_PAYMENT";
            cboTermOfPayment.SelectedIndex = -1;
        }
Beispiel #4
0
        private void Lot_Maintenance_Load(object sender, EventArgs e)
        {
            InitializeMenuButton();
            InitialFormat();
            InitialSpread();
            InitialDefaultValue();

            CtrlUtil.EnabledControl(false, txtItemNo, txtPartNo, txtRemainQty, txtQty);

            // Get all data
            DeliveryBIZ bizDelivery            = new DeliveryBIZ();
            List <ActualOnhandViewDTO> listDTO = bizDelivery.Load_LotMaintenance(SlipNo, LocCd, ItemCd, false);

            m_Data = DTOUtility.ConvertListToDataTable <ActualOnhandViewDTO>(listDTO);
            m_Data.Columns.Add(CONST_COLUMN_NAME_CHECK_FLAG, typeof(int));


            m_Data = OrderData(m_Data);

            // Filter
            loadData();
        }
Beispiel #5
0
        private void LoadData(NZDateTime from, NZDateTime to, NZInt filterType)
        {
            if (dtPeriodBegin.NZValue.IsNull || dtPeriodEnd.NZValue.IsNull)
            {
                if (dtPeriodBegin.NZValue.IsNull && dtPeriodEnd.NZValue.IsNull)
                {
                    MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date begin and Delivery date end" }));
                }
                else if (dtPeriodBegin.NZValue.IsNull)
                {
                    MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date begin" }));
                }
                else
                {
                    MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date end" }));
                }
                return;
            }

            CustomerOrderBIZ biz = new CustomerOrderBIZ();
            DataTable        dt  = DTOUtility.ConvertListToDataTable <CustomerOrderViewDTO>(biz.LoadCustomerOrderList(from, to, filterType, false));

            shtCustomerOrderList.RowCount   = 0;
            shtCustomerOrderList.DataSource = null;
            m_dtAllData = dt;
            FindDataFromMemory();
            CalculateTotal();
            //List<InventoryTransactionViewDTO> list = m_controller.LoadReceivingList(from, to);
            ////DataTable dt = DTOUtility.ConvertListToDataTable(list);
            //m_dtAllData = DTOUtility.ConvertListToDataTable(list);
            //shtCustomerOrderList.RowCount = 0;
            //shtCustomerOrderList.DataSource = null;
            //FindDataFromMemory();
            //shtView.DataSource = m_dtAllData;

            // CtrlUtil.SpreadUpdateColumnSorting(shtView);
        }
Beispiel #6
0
        public MultiWorkResultEntryUIDM LoadForEditMultiWorkResult(NZString transID)
        {
            //== Load Header (Work Result)
            InventoryTransBIZ bizInventoryTransaction = new InventoryTransBIZ();
            InventoryBIZ      bizInventory            = new InventoryBIZ();


            ItemBIZ bizItem = new ItemBIZ();

            InventoryTransactionDTO transDTO = bizInventoryTransaction.LoadByTransactionID(transID);

            if (transDTO == null)
            {
                return(null);
            }


            //เอา transDTO ไปหา group
            //แล้วก็ group -> แปลงเป็น column ตาม spread


            ItemDTO        dtoItem        = bizItem.LoadItem(transDTO.ITEM_CD);
            ItemProcessDTO dtoItemProcess = bizItem.LoadItemProcess(transDTO.ITEM_CD);

            MultiWorkResultEntryUIDM model = new MultiWorkResultEntryUIDM();

            //model.ChildItemCode = ;// ต้องไปดึงมาจาก consumption ตัวแรก
            //model.OrderLoc=;

            //model.CONSUMTION_CLS = dtoItemProcess.CONSUMTION_CLS;
            model.ForMachine        = transDTO.FOR_MACHINE;
            model.ItemCode          = transDTO.ITEM_CD;
            model.ItemDesc          = dtoItem.ITEM_DESC;
            model.Remark            = transDTO.REMARK;
            model.ShiftClass        = transDTO.SHIFT_CLS;
            model.StoredLoc         = transDTO.LOC_CD;
            model.TRAN_SUB_CLS      = transDTO.TRAN_SUB_CLS;
            model.WorkOrderNo       = transDTO.REF_SLIP_NO;
            model.WorkResultDate    = transDTO.TRANS_DATE;
            model.WorkResultGroupNo = transDTO.GROUP_TRANS_ID;

            List <InventoryTransactionDTO> listTrans = bizInventoryTransaction.LoadGroupTransaction(transDTO.GROUP_TRANS_ID, DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.WorkResult).ToNZString());

            //new list ของ multi work result เพื่อใส่ข้อมูล เป็น row ก่อน
            //แล้วพอวนใส่เสร็จค่อย convert เป็น datatable เพื่อ set value ให้ model.DataView
            List <MultiWorkResultEntryViewDTO> listMultiWorkResult = new List <MultiWorkResultEntryViewDTO>();



            foreach (InventoryTransactionDTO dtoTran in listTrans)
            {
                MultiWorkResultEntryViewDTO multiDTO = new MultiWorkResultEntryViewDTO();
                multiDTO.GOOD_QTY            = dtoTran.QTY;
                multiDTO.GOOD_TRANSACTION_ID = dtoTran.TRANS_ID;
                //multiDTO.LOT_NO = dtoTran.LOT_NO;
                multiDTO.NG_QTY    = dtoTran.NG_QTY;
                multiDTO.NG_REASON = dtoTran.NG_REASON;

                multiDTO.RESERVE_QTY    = dtoTran.RESERVE_QTY;
                multiDTO.WORK_RESULT_NO = dtoTran.SLIP_NO;

                InventoryTransactionDTO dtoNGTrans = bizInventoryTransaction.LoadNGWorkResult(dtoTran.SLIP_NO);
                if (dtoNGTrans != null && !dtoNGTrans.TRANS_ID.IsNull)
                {
                    multiDTO.NG_TRANSACTION_ID = dtoNGTrans.TRANS_ID;
                }

                InventoryTransactionDTO dtoReserveTrans = bizInventoryTransaction.LoadReserveResult(dtoTran.SLIP_NO);
                if (dtoReserveTrans != null && !dtoReserveTrans.TRANS_ID.IsNull)
                {
                    multiDTO.RESERVE_TRANSACTION_ID = dtoReserveTrans.TRANS_ID;
                }



                List <WorkResultEntryViewDTO> consumptionList = bizInventory.LoadWorkResultConsumptionList(dtoTran.SLIP_NO);
                if (consumptionList != null && consumptionList.Count == 1)
                {
                    //model.OrderLoc = consumptionList[0].LOC_CD;
                    //model.ChildItemCode = consumptionList[0].ITEM_CD;
                    //multiDTO.CONSUMPTION_TRANSACTION_ID = consumptionList[0].TRANS_ID;
                    //multiDTO.ON_HAND_QTY = consumptionList[0].ON_HAND_QTY;
                    //multiDTO.LOT_NO = consumptionList[0].LOT_NO;
                }
                else
                {
                    throw new NotSupportedException("Comsumption != 1 item");
                    //if (dtoItemProcess != null)
                    //    model.OrderLoc = dtoItemProcess.ORDER_LOC_CD;
                }


                //multiDTO.ON_HAND_QTY = new NZDecimal(null, 0);//onhand + good + ng + reserve
                //ActualOnhandViewDTO onhandConsumption = bizInventory.LoadActualInventoryOnHand(model.ChildItemCode, model.OrderLoc, multiDTO.LOT_NO);
                //if (onhandConsumption == null)
                //{
                //    multiDTO.ON_HAND_QTY.Value = multiDTO.GOOD_QTY.NVL(0) + multiDTO.NG_QTY.NVL(0) + multiDTO.RESERVE_QTY.NVL(0);
                //}
                //else
                //{
                //    multiDTO.ON_HAND_QTY.Value = onhandConsumption.ONHAND_QTY.NVL(0) + multiDTO.GOOD_QTY.NVL(0) + multiDTO.NG_QTY.NVL(0) + multiDTO.RESERVE_QTY.NVL(0);
                //}



                listMultiWorkResult.Add(multiDTO);
            }

            model.DataView = DTOUtility.ConvertListToDataTable <MultiWorkResultEntryViewDTO>(listMultiWorkResult);

            model.DataView.AcceptChanges();
            return(model);
        }
Beispiel #7
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="transactionID"></param>
        /// <returns></returns>
        public WorkResultEntryUIDM LoadForEditWorkResult(NZString transactionID)
        {
            //== Load Header (Work Result)
            InventoryTransBIZ bizInventoryTransaction = new InventoryTransBIZ();
            ItemBIZ           bizItem = new ItemBIZ();

            InventoryTransactionDTO dtoInventoryTransaction = bizInventoryTransaction.LoadByTransactionID(transactionID);

            if (dtoInventoryTransaction == null)
            {
                return(null);
            }

            ItemDTO             dtoItem        = bizItem.LoadItem(dtoInventoryTransaction.ITEM_CD);
            ItemProcessDTO      dtoItemProcess = bizItem.LoadItemProcess(dtoInventoryTransaction.ITEM_CD);
            WorkResultEntryUIDM model          = new WorkResultEntryUIDM();

            model.TransactionID       = dtoInventoryTransaction.TRANS_ID;
            model.ItemCode            = dtoInventoryTransaction.ITEM_CD;
            model.ItemDesc            = dtoItem.ITEM_DESC;
            model.LotNo               = dtoInventoryTransaction.LOT_NO;
            model.StoredLoc           = dtoInventoryTransaction.LOC_CD;
            model.Remark              = dtoInventoryTransaction.REMARK;
            model.WorkOrderNo         = dtoInventoryTransaction.REF_SLIP_NO;
            model.WorkResultDate      = dtoInventoryTransaction.TRANS_DATE;
            model.WorkResultQty.Value = dtoInventoryTransaction.QTY.NVL(0) + dtoInventoryTransaction.NG_QTY.NVL(0) + dtoInventoryTransaction.RESERVE_QTY.NVL(0);
            model.GoodQty.Value       = dtoInventoryTransaction.QTY.NVL(0);
            model.WorkResultNo        = dtoInventoryTransaction.SLIP_NO;
            model.ShipClass           = dtoInventoryTransaction.SHIFT_CLS;
            //model.CONSUMTION_CLS = dtoItemProcess.CONSUMTION_CLS;
            model.ReserveQty = dtoInventoryTransaction.RESERVE_QTY;
            model.NGQty      = dtoInventoryTransaction.NG_QTY;
            model.ForMachine = dtoInventoryTransaction.FOR_MACHINE;
            model.NGReason   = dtoInventoryTransaction.NG_REASON;
            //model.LotSize = dtoItemProcess.LOT_SIZE;

            //model.OrderLoc = dtoItemProcess.ORDER_LOC_CD;


            InventoryTransactionDTO dtoNGTrans = bizInventoryTransaction.LoadNGWorkResult(model.WorkResultNo);

            if (dtoNGTrans != null && !dtoNGTrans.TRANS_ID.IsNull)
            {
                model.NGTransactionID = dtoNGTrans.TRANS_ID;
            }

            InventoryTransactionDTO dtoReserveTrans = bizInventoryTransaction.LoadReserveResult(model.WorkResultNo);

            if (dtoReserveTrans != null && !dtoReserveTrans.TRANS_ID.IsNull)
            {
                model.ReserveTransactionID = dtoReserveTrans.TRANS_ID;
            }


            InventoryBIZ bizInventory             = new InventoryBIZ();
            List <WorkResultEntryViewDTO> dtoList = bizInventory.LoadWorkResultConsumptionList(model.WorkResultNo);

            model.DataView = DTOUtility.ConvertListToDataTable(dtoList);

            model.DataView.AcceptChanges();
            return(model);
        }
Beispiel #8
0
        internal DataTable LoadAllMenuSubNotInMenuSet(string menuSetCD)
        {
            MenuSetMaintenanceBIZ biz = new MenuSetMaintenanceBIZ();

            return(DTOUtility.ConvertListToDataTable(biz.LoadAllMenuSubNotInMenuSet(menuSetCD)));
        }
Beispiel #9
0
        internal DataTable LoadAllMenuSet()
        {
            MenuSetMaintenanceBIZ biz = new MenuSetMaintenanceBIZ();

            return(DTOUtility.ConvertListToDataTable(biz.LoadAllMenuSet()));
        }
Beispiel #10
0
        internal ItemUIDM LoadItem(EVOFramework.NZString ItemCD)
        {
            ItemBIZ biz = new ItemBIZ();

            ItemDTO dtoItem = biz.LoadItem(ItemCD);
            List <ItemViewProcessDTO> dtoItemProcess   = biz.LoadItemProcessList(ItemCD);
            List <ItemComponentDTO>   dtoItemComponent = biz.LoadItemComponentList(ItemCD);
            List <ItemMachineDTO>     dtoItemMachine   = biz.LoadItemMachineByItemCD(ItemCD);

            #region ITEM uidm
            ItemUIDM uidm = new ItemUIDM();
            uidm.CRT_BY             = dtoItem.CRT_BY;
            uidm.CRT_DATE           = dtoItem.CRT_DATE;
            uidm.CRT_MACHINE        = dtoItem.CRT_MACHINE;
            uidm.UPD_BY             = dtoItem.UPD_BY;
            uidm.UPD_DATE           = dtoItem.UPD_DATE;
            uidm.UPD_MACHINE        = dtoItem.UPD_MACHINE;
            uidm.ITEM_CD            = dtoItem.ITEM_CD;
            uidm.SHORT_NAME         = dtoItem.SHORT_NAME;
            uidm.ITEM_DESC          = dtoItem.ITEM_DESC;
            uidm.KIND_OF_PRODUCT    = dtoItem.KIND_OF_PRODUCT;
            uidm.CUSTOMER_CD        = dtoItem.CUSTOMER_CD;
            uidm.CUSTOMER_USE_POINT = dtoItem.CUSTOMER_USE_POINT;
            uidm.WEIGHT             = dtoItem.WEIGHT;
            uidm.BOI                        = dtoItem.BOI;
            uidm.PRODUCTION_DI              = dtoItem.PRODUCTION_DI;
            uidm.ITEM_LEVEL                 = dtoItem.ITEM_LEVEL;
            uidm.MAT_NAME                   = dtoItem.MAT_NAME;
            uidm.MAT_SIZE                   = dtoItem.MAT_SIZE;
            uidm.SUPPLIER_NAME              = dtoItem.MAT_SUPPLIER_CD;
            uidm.KIND_OF_MAT                = dtoItem.KIND_OF_MAT;
            uidm.MAT_DI                     = dtoItem.MAT_DI;
            uidm.REMARK                     = dtoItem.REMARK;
            uidm.SCREW_KIND                 = dtoItem.SCREW_KIND;
            uidm.SCREW_HEAD                 = dtoItem.SCREW_HEAD;
            uidm.SCREW_M                    = dtoItem.SCREW_M;
            uidm.SCREW_L                    = dtoItem.SCREW_L;
            uidm.SCREW_TYPE                 = dtoItem.SCREW_TYPE;
            uidm.SCREW_REMARK1              = dtoItem.SCREW_REMARK1;
            uidm.SCREW_REMARK2              = dtoItem.SCREW_REMARK2;
            uidm.HEXABULAR                  = dtoItem.HEXABULAR;
            uidm.HEAT_FLAG                  = dtoItem.HEAT_FLAG;
            uidm.HEAT_TYPE                  = dtoItem.HEAT_TYPE;
            uidm.HEAT_HARDNESS              = dtoItem.HEAT_HARDNESS;
            uidm.HEAT_CORE_HARDNESS         = dtoItem.HEAT_CORE_HARDNESS;
            uidm.HEAT_CASE_DEPTH            = dtoItem.HEAT_CASE_DEPTH;
            uidm.PLATING_FLAG               = dtoItem.PLATING_FLAG;
            uidm.PLATING_KIND               = dtoItem.PLATING_KIND;
            uidm.PLATING_SUPPLIER_NAME      = dtoItem.PLATING_SUPPLIER_CD;
            uidm.PLATING_THICKNESS1_1       = dtoItem.PLATING_THICKNESS1_1;
            uidm.PLATING_THICKNESS1_2       = dtoItem.PLATING_THICKNESS1_2;
            uidm.PLATING_THICKNESS2_1       = dtoItem.PLATING_THICKNESS2_1;
            uidm.PLATING_THICKNESS2_2       = dtoItem.PLATING_THICKNESS2_2;
            uidm.PLATING_KTC                = dtoItem.PLATING_KTC;
            uidm.BAKING_FLAG                = dtoItem.BAKING_FLAG;
            uidm.BAKING_TIME                = dtoItem.BAKING_TIME;
            uidm.BAKING_TEMP                = dtoItem.BAKING_TEMP;
            uidm.OTHER_TREATMENT1_FLAG      = dtoItem.OTHER_TREATMENT1_FLAG;
            uidm.OTHER_TREATMENT1_KIND      = dtoItem.OTHER_TREATMENT1_KIND;
            uidm.OTHER_TREATMENT1_CONDITION = dtoItem.OTHER_TREATMENT1_CONDITION;
            uidm.OTHER_TREATMENT2_FLAG      = dtoItem.OTHER_TREATMENT2_FLAG;
            uidm.OTHER_TREATMENT2_KIND      = dtoItem.OTHER_TREATMENT2_KIND;
            uidm.OTHER_TREATMENT2_CONDITION = dtoItem.OTHER_TREATMENT2_CONDITION;
            uidm.OLD_DATA                   = dtoItem.OLD_DATA;
            #endregion

            uidm.DataView = DTOUtility.ConvertListToDataTable <ItemViewProcessDTO>(dtoItemProcess);
            uidm.DataView.AcceptChanges();
            uidm.DataComponentView = DTOUtility.ConvertListToDataTable <ItemComponentDTO>(dtoItemComponent);
            uidm.DataComponentView.AcceptChanges();
            uidm.DataItemMachine = DTOUtility.ConvertListToDataTable <ItemMachineDTO>(dtoItemMachine);
            uidm.DataItemMachine.AcceptChanges();

            return(uidm);
        }
Beispiel #11
0
        private void LoadData(NZDateTime FromPeriod, NZDateTime ToPeriod, string keyFilter, bool validate)
        {
            try
            {
                if (validate)
                {
                    if (chkToEndMonth.Checked)
                    {
                        // Validate period date before search data.
                        InventoryOnhandInquiryValidator validator = new InventoryOnhandInquiryValidator();
                        try
                        {
                            validator.ValidatePeriodDateRange(FromPeriod, ToPeriod);
                        }
                        catch (ValidateException err)
                        {
                            MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message);
                            err.ErrorResults[0].FocusOnControl();
                            return;
                        }
                    }
                }

                //== Start to search data.
                InventoryOnhandController ctlInvent = new InventoryOnhandController();

                bool GroupByItem = rdoGroupItem.Checked;

                int iToEndOfMonth = 1;

                if (chkToEndMonth.Checked)
                {
                    iToEndOfMonth = 0;
                }
                else
                {
                    iToEndOfMonth = 1;
                }
                //== 20091203 Add by Teerayt S.

                //NZString yearMonth = GetLatestYearMonthInInvOnhand();

                //InventoryPeriodBIZ biz = new InventoryPeriodBIZ();
                //InventoryPeriodDTO dtoPeriod = biz.LoadCurrentPeriod();
                NZString yearMonth = dtPeriodBegin.Value.Value.ToString("yyyyMM").ToNZString(); //dtoPeriod.YEAR_MONTH;
                //== 20091203 End Add by Teerayt S.

                List <InventoryOnhandInquiryViewDTO> dtoView = ctlInvent.LoadInventoryOnhand(yearMonth, FromPeriod, ToPeriod, GroupByItem, iToEndOfMonth);

                m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView);

                DataTable dtView = m_dtAllData.Clone();

                if (keyFilter != string.Empty)
                {
                    string filterString = string.Format(@"
                                                (
                                                    LOCATION         LIKE '%{0}%' OR 
                                                    ITEM_CODE        LIKE '%{0}%' OR 
                                                    CUSTOMER_CD     LIKE '%{0}%' OR 
                                                    LOT_NO           LIKE '%{0}%' OR
                                                    PACK_NO           LIKE '%{0}%' OR
                                                    EXTERNAL_LOT_NO      LIKE '%{0}%' OR
                                                    SHORT_NAME       LIKE '%{0}%'   OR
                                                    LAST_RECEIVE_DATE = #{0:dd/MM/yyyy}#
                                                  )", keyFilter);

                    if (!chkZeroQty.Checked)
                    {
                        filterString = filterString + " AND ONHAND_QTY <> 0 ";
                    }

                    //get only the rows you want
                    DataRow[] results = m_dtAllData.Select(filterString, @"LOCATION,ITEM_CODE,LOT_NO,PACK_NO,EXTERNAL_LOT_NO");

                    //populate new destination table
                    foreach (DataRow dr in results)
                    {
                        dtView.ImportRow(dr);
                    }
                }
                else
                {
                    if (!chkZeroQty.Checked)
                    {
                        string filterString = " ONHAND_QTY <> 0 ";

                        //get only the rows you want
                        DataRow[] results = m_dtAllData.Select(filterString, @"LOCATION,ITEM_CODE,LOT_NO,PACK_NO,EXTERNAL_LOT_NO");

                        //populate new destination table
                        foreach (DataRow dr in results)
                        {
                            dtView.ImportRow(dr);
                        }
                    }
                    else
                    {
                        foreach (DataRow dr in m_dtAllData.Rows)
                        {
                            dtView.ImportRow(dr);
                        }
                    }
                }
                fpView.DataSource = dtView;
                CtrlUtil.SpreadUpdateColumnSorting(shtView);
            }
            catch (Exception ex)
            {
                MessageDialog.ShowBusiness(this, ex.Message);
            }
        }
Beispiel #12
0
        /// <summary>
        /// Set Default for each control in screen.
        /// </summary>
        /// <param name="hDTO">DTO for set default.</param>
        private void SetDefault(PurchaseOrderHDTO hDTO)
        {
            if (hDTO != null)
            {
                // แสดง header
                PurchaseOrderHDTO hDTOSearch = m_BIZPurchaseOrder.LoadByPK(hDTO);

                this.lblPoNo.Text    = hDTOSearch.PO_NO.ToString();
                this.dtmPODate.Value = hDTOSearch.PO_DATE;

                this.cboSupplierCode.SelectedValue = hDTOSearch.SUPPLIER_CD;

                string strDeliveryTo = Convert.ToString((new SysConfigBIZ().LoadByPK((NZString)"DELIVERY_TO", (NZString)"PUR010")).CHAR_DATA.Value);
                if (hDTOSearch.DELIVERY_TO.Value.Equals(strDeliveryTo))
                {
                    chkOurFactory.Checked = true;
                    chkOurFactory_CheckedChanged(this, null);
                }
                else
                {
                    this.cboDelivery.SelectedValue = hDTOSearch.DELIVERY_TO;
                }

                this.cboTermOfPayment.SelectedValue = hDTOSearch.TERM_OF_PAYMENT;

                m_bIsActived     = hDTO.IS_ACTIVE.StrongValue;
                lblPoStatus.Text = m_bIsActived ? "Active" : "Cancel";


                this.txtVatRate.Text           = hDTOSearch.VAT_RATE.ToString();
                this.cboCurrency.SelectedValue = hDTOSearch.CURRENCY;

                this.txtRemark.Text = hDTOSearch.REMARK;

                m_HDTOPurchaseOrder = hDTOSearch;

                // แสดง detail
                shtView.RowCount = 0;
                List <PurchaseOrderDDTO> dDTOPurchaseOrderList = m_BIZPurchaseOrder.LoadDetailByPO(m_HDTOPurchaseOrder);
                shtView.DataSource = DTOUtility.ConvertListToDataTable <PurchaseOrderDDTO>(dDTOPurchaseOrderList);

                for (int iRow = 0; iRow < shtView.RowCount; iRow++)
                {
                    LoadItem(iRow);
                    SetComboBoxInSpreadSheet(iRow);
                }

                if (hDTOSearch.IS_ACTIVE.StrongValue)
                {
                    SetScreenState(eScreenState.Edit);
                }
                else
                {
                    SetScreenState(eScreenState.View);
                }
            }
            else
            {
                // set default into Controls.
                var bizSysConfig = new SysConfigBIZ();

                string strVatRate = (bizSysConfig.LoadByPK((NZString)"VAT_RATE", (NZString)"PUR010")).CHAR_DATA;;
                this.txtVatRate.Text = strVatRate;

                string strCurrency = (bizSysConfig.LoadByPK((NZString)"CURRENCY", (NZString)"PUR010")).CHAR_DATA;;
                cboCurrency.SelectedValue = strCurrency;

                chkOurFactory.Checked = true;
                chkOurFactory_CheckedChanged(this, null);

                this.lblPoNo.Text    = string.Empty;
                this.dtmPODate.Value = DateTime.Now;

                this.cboSupplierCode.SelectedIndex  = -1;
                this.cboTermOfPayment.SelectedIndex = -1;

                lblPoStatus.Text = "Actived";

                this.txtRemark.Text = string.Empty;

                shtView.Rows.Count = 0;
                SetScreenState(eScreenState.Add);
            }
            m_DDTOListForDelete = new List <PurchaseOrderDDTO>();
        }