コード例 #1
0
ファイル: ShiftPop.cs プロジェクト: LEE-JiHong/Team3
        private void InitComboBind()
        {
            string todayFormat = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);

            txtUdate.Text = todayFormat;
            ResourceService  R_service = new ResourceService();
            List <MachineVO> m_list    = R_service.GetMachineAll();

            ComboUtil.ComboBinding(cboM_code, m_list, "m_id", "m_code");

            CommonCodeService C_service = new CommonCodeService();
            List <CommonVO>   c_list    = C_service.GetCommonCodeAll();
            var shift_code = (from shift in c_list
                              where shift.common_type == "shift_code"
                              select shift).ToList();

            ComboUtil.ComboBinding(cboShiftID, shift_code, "common_value", "common_name");

            var YN = (from shift in c_list
                      where shift.common_type == "user_flag"
                      select shift).ToList();

            ComboUtil.ComboBinding(cboYN, YN, "common_value", "common_name");
        }
コード例 #2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                ResourceService R_Service = new ResourceService();
                MachineGradeVO  VO        = new MachineGradeVO();
                try
                {
                    VO.mgrade_name    = txtMgrade_name.Text;
                    VO.mgrade_code    = txtMgrade_code.Text;
                    VO.mgrade_yn      = cboYN.SelectedValue.ToString();
                    VO.mgrade_udate   = txtMgrade_udate.Text;
                    VO.mgrade_uadmin  = txtMgrade_uadmin.Text;
                    VO.mgrade_comment = txtMgrade_comment.Text;

                    if (mode == EditMode.Input)
                    {
                        bool bResult = R_Service.InsertMachineGr(VO);
                        if (bResult)
                        {
                            MessageBox.Show("등록성공");
                            this.DialogResult = DialogResult.OK;
                        }
                        else if (!bResult)
                        {
                            MessageBox.Show("등록실패");
                            this.DialogResult = DialogResult.None;
                            return;
                        }
                    }
                    else if (mode == EditMode.Update)
                    {
                        VO.mgrade_id = Convert.ToInt32(lblID.Text);
                        bool bResult = R_Service.UpdateMachineGr(VO);
                        if (bResult)
                        {
                            MessageBox.Show("수정성공");
                            this.DialogResult = DialogResult.OK;
                        }
                        else if (!bResult)
                        {
                            MessageBox.Show("수정실패");
                            this.DialogResult = DialogResult.None;
                            return;
                        }
                    }
                }
                catch (NullReferenceException err)
                {
                    MessageBox.Show("입력되지 않은값이 있습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    this.DialogResult = DialogResult.None;
                    return;
                }
                catch (Exception err)
                {
                    string str = err.Message;
                    return;
                }
            }
            catch (NullReferenceException err)
            {
                MessageBox.Show("입력되지 않은값이 있습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
                return;
            }
            catch (Exception err)
            {
                string str = err.Message;
            }
        }
コード例 #3
0
ファイル: ProductPop.cs プロジェクト: LEE-JiHong/Team3
        private void ComboBoxBinding()
        {
            //TODO 메서드 하나로 모듈화
            ProductService      product_service  = new ProductService();
            ResourceService     resource_service = new ResourceService();
            List <FactoryDB_VO> f_list           = new List <FactoryDB_VO>();

            common_service = new CommonCodeService();
            codelist       = common_service.GetCommonCodeAll();

            List <UserVO> user_list = product_service.GetUserAll();

            List <CommonVO> _cboUnit = (from item in codelist
                                        where item.common_type == "item_unit"
                                        select item).ToList();

            ComboUtil.ComboBinding(cboProductUnit, _cboUnit, "common_value", "common_name", "선택");


            List <CommonVO> _cboUseFlag = (from item in codelist
                                           where item.common_type == "user_flag"
                                           select item).ToList();

            ComboUtil.ComboBinding(cboIsUsed, _cboUseFlag, "common_value", "common_name", "선택");


            List <CommonVO> _commonlist = (from item in codelist
                                           where item.common_type == "item_type"
                                           select item).ToList();

            ComboUtil.ComboBinding(cboProductType, _commonlist, "common_value", "common_name", "선택");

            List <CommonVO> _commonmeastype = (from item in codelist
                                               where item.common_type == "meastype"
                                               select item).ToList();

            ComboUtil.ComboBinding(cboMeasType, _commonmeastype, "common_value", "common_name", "선택");

            #region 담당자cbo

            ComboUtil.ComboBinding(cboAdmin, user_list, "user_id", "user_name", "선택");
            #endregion

            #region 입고창고cbo
            f_list = resource_service.GetFactoryAll();
            List <FactoryDB_VO> _cboInSector = (from item in f_list
                                                where item.facility_value == "FAC200" || item.facility_value == "FAC400"
                                                select item).ToList();
            ComboUtil.ComboBinding(cboInSector, _cboInSector, "factory_code", "factory_name", "선택");
            #endregion

            #region 출고창고cbo
            List <FactoryDB_VO> _cboOutSector = (from item in f_list
                                                 where item.facility_value == "FAC100"
                                                 select item).ToList();
            ComboUtil.ComboBinding(cboOutSector, _cboOutSector, "factory_code", "factory_name", "선택");
            #endregion


            #region 발주방식cbo
            _commonlist = (from item in codelist
                           where item.common_type == "order_method"
                           select item).ToList();
            ComboUtil.ComboBinding(cboOrderType, _commonlist, "common_value", "common_name", "선택");
            #endregion

            #region 납품업체cbo
            List <CompanyVO> company_list  = new List <CompanyVO>();
            OrderService     order_service = new OrderService();
            company_list = order_service.GetCompanyAll("COOPERATIVE");
            ComboUtil.ComboBinding(cboSupplyCompany, company_list, "company_code", "company_name", "선택");
            #endregion

            #region 발주업체cbo
            company_list = order_service.GetCompanyAll("CUSTOMER");
            ComboUtil.ComboBinding(cboDemandCompany, company_list, "company_code", "company_name", "선택");

            List <UserVO> user_vo = new List <UserVO>();
            #endregion
        }