예제 #1
0
        private void init_ComboBox()
        {
            ComInfo comInfo  = new ComInfo();
            string  sqlQuery = "";

            //불량유형 시작

            cmb_cd_srch.Items.Add("전체 검색");
            cmb_cd_srch.Items.Add("코드별 검색");
            cmb_cd_srch.Items.Add("이름별 검색");
            cmb_cd_srch.SelectedIndex = 0;

            cmb_type.ValueMember   = "코드";
            cmb_type.DisplayMember = "명칭";
            sqlQuery = comInfo.queryType();
            wConst.ComboBox_Read_Blank(cmb_type, sqlQuery);

            cmb_raw_mat_gbn.ValueMember   = "코드";
            cmb_raw_mat_gbn.DisplayMember = "명칭";
            sqlQuery = comInfo.queryRawList();
            wConst.ComboBox_Read_Blank(cmb_raw_mat_gbn, sqlQuery);

            cmb_raw2.ValueMember   = "코드";
            cmb_raw2.DisplayMember = "명칭";
            sqlQuery = comInfo.queryRawList();
            wConst.ComboBox_Read_ALL(cmb_raw2, sqlQuery);

            cmb_input_unit.ValueMember   = "코드";
            cmb_input_unit.DisplayMember = "명칭";
            sqlQuery = comInfo.queryUnit();
            wConst.ComboBox_Read_Blank(cmb_input_unit, sqlQuery);

            cmb_output_unit.ValueMember   = "코드";
            cmb_output_unit.DisplayMember = "명칭";
            wConst.ComboBox_Read_Blank(cmb_output_unit, sqlQuery);

            cmb_used.ValueMember   = "코드";
            cmb_used.DisplayMember = "명칭";
            sqlQuery = comInfo.queryUsedYn();
            wConst.ComboBox_Read_NoBlank(cmb_used, sqlQuery);

            cmb_line.ValueMember   = "코드";
            cmb_line.DisplayMember = "명칭";
            sqlQuery = comInfo.queryLine();
            wConst.ComboBox_Read_Blank(cmb_line, sqlQuery);

            cmb_cust.ValueMember   = "코드";
            cmb_cust.DisplayMember = "명칭";
            sqlQuery = comInfo.queryCustUsed("2"); //구매처
            wConst.ComboBox_Read_Blank(cmb_cust, sqlQuery);

            cmb_raw_chk.ValueMember   = "코드";
            cmb_raw_chk.DisplayMember = "명칭";
            sqlQuery = comInfo.queryCode("601"); //수입검사여부
            wConst.ComboBox_Read_Blank(cmb_raw_chk, sqlQuery);

            cmb_used_srch.ValueMember   = "코드";
            cmb_used_srch.DisplayMember = "명칭";
            sqlQuery = comInfo.queryCustUsedYnAll(); //사용여부검색
            wConst.ComboBox_Read_NoBlank(cmb_used_srch, sqlQuery);

            cmb_raw_stor.ValueMember   = "코드";
            cmb_raw_stor.DisplayMember = "명칭";
            sqlQuery = comInfo.queryStorageAll(); //기본창고 선택 ( 안사용될듯 삭제요망 )
            wConst.ComboBox_Read_NoBlank(cmb_raw_stor, sqlQuery);

            cmb_chugjong_txt.ValueMember   = "코드";
            cmb_chugjong_txt.DisplayMember = "명칭";
            sqlQuery = comInfo.queryChugjongAll(); //축종
            wConst.ComboBox_Read_NoBlank(cmb_chugjong_txt, sqlQuery);

            cmb_class_txt.ValueMember   = "코드";
            cmb_class_txt.DisplayMember = "명칭";
            sqlQuery = comInfo.queryClassAll(); //분류
            wConst.ComboBox_Read_NoBlank(cmb_class_txt, sqlQuery);

            cmb_country_txt.ValueMember   = "코드";
            cmb_country_txt.DisplayMember = "명칭";
            sqlQuery = comInfo.queryCountryAll(); //원산지
            wConst.ComboBox_Read_NoBlank(cmb_country_txt, sqlQuery);

            cmb_grade_txt.ValueMember   = "코드";
            cmb_grade_txt.DisplayMember = "명칭";
            sqlQuery = comInfo.queryGradeAll(); //등급
            wConst.ComboBox_Read_NoBlank(cmb_grade_txt, sqlQuery);

            cmb_pattern_gubun.ValueMember   = "코드";
            cmb_pattern_gubun.DisplayMember = "명칭";
            sqlQuery = comInfo.queryPatternAll(); //등급
            wConst.ComboBox_Read_NoBlank(cmb_pattern_gubun, sqlQuery);

            cmb_vat_cd.ValueMember   = "코드";
            cmb_vat_cd.DisplayMember = "명칭";
            sqlQuery = comInfo.queryVat(); // 과세구분
            wConst.ComboBox_Read_NoBlank(cmb_vat_cd, sqlQuery);

            txt_box_amt.Text      = "0";
            txt_hamyang_txt.Text  = "";
            txt_label_nm_txt.Text = "";
            txt_exprt_count.Text  = ""; //유통일수 ( 삭제요망 )
        }