//콤보박스 바인딩 모음 private void init_ComboBox() { ComInfo comInfo = new ComInfo(); string sqlQuery = ""; 매출구분.DataSource = wnDm.매출구분(); 매출구분.ValueMember = "코드"; 매출구분.DisplayMember = "명칭"; sqlQuery = ""; cbo배송사원.ValueMember = "코드"; cbo배송사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo배송사원, sqlQuery); sqlQuery = ""; cbo전표상태.ValueMember = "코드"; cbo전표상태.DisplayMember = "명칭"; sqlQuery = comInfo.queryCode("640"); sqlQuery += "and B.S_CODE in('2','3') "; //2: 배송 3:배송완료 wConst.ComboBox_Read_Blank(cbo전표상태, sqlQuery); sqlQuery = ""; cbo담당사원.ValueMember = "코드"; cbo담당사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo담당사원, sqlQuery); }
private void init_ComboBox() { ComInfo comInfo = new ComInfo(); string sqlQuery = ""; //창고 cmb_stor.ValueMember = "코드"; cmb_stor.DisplayMember = "명칭"; sqlQuery = comInfo.queryStorage(); wConst.ComboBox_Read_Blank(cmb_stor, sqlQuery); sqlQuery = ""; cbo부가세.ValueMember = "코드"; cbo부가세.DisplayMember = "명칭"; sqlQuery = comInfo.queryCode("910"); wConst.ComboBox_Read_Blank(cbo부가세, sqlQuery); sqlQuery = ""; cbo담당사원.ValueMember = "코드"; cbo담당사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo담당사원, sqlQuery); sqlQuery = ""; cbo배송사원.ValueMember = "코드"; cbo배송사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo배송사원, sqlQuery); cbo전표상태.ValueMember = "코드"; cbo전표상태.DisplayMember = "명칭"; sqlQuery = comInfo.queryCode("640"); wConst.ComboBox_Read_Blank(cbo전표상태, sqlQuery); 매출구분.DataSource = wnDm.매출구분(); 매출구분.ValueMember = "코드"; 매출구분.DisplayMember = "명칭"; }
private void init_ComboBox() { ComInfo comInfo = new ComInfo(); string sqlQuery = ""; //tax cbo부가세.ValueMember = "코드"; cbo부가세.DisplayMember = "명칭"; sqlQuery = comInfo.queryTax(); wConst.ComboBox_Read_NoBlank(cbo부가세, sqlQuery); ////배송사원 //cbo배송사원.ValueMember = "코드"; //cbo배송사원.DisplayMember = "명칭"; //sqlQuery = comInfo.queryStaff(); //wConst.ComboBox_Read_NoBlank(cbo배송사원, sqlQuery); //창고 cbo창고.ValueMember = "코드"; cbo창고.DisplayMember = "명칭"; sqlQuery = comInfo.queryStorage(); wConst.ComboBox_Read_NoBlank(cbo창고, sqlQuery); //담당사원 cbo담당사원.ValueMember = "코드"; cbo담당사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_NoBlank(cbo담당사원, sqlQuery); 매출구분.DataSource = wnDm.매출구분(); 매출구분.ValueMember = "코드"; 매출구분.DisplayMember = "명칭"; O_부가세.DataSource = wnDm.부가세구분(); O_부가세.ValueMember = "코드"; O_부가세.DisplayMember = "명칭"; O_과세.DataSource = wnDm.과세구분(); O_과세.ValueMember = "코드"; O_과세.DisplayMember = "명칭"; cbo전표상태.ValueMember = "코드"; cbo전표상태.DisplayMember = "명칭"; sqlQuery = comInfo.queryCode("640"); wConst.ComboBox_Read_NoBlank(cbo전표상태, sqlQuery); }
private void init_ComboBox() { ComInfo comInfo = new ComInfo(); string sqlQuery = ""; //창고 cmb_stor.ValueMember = "코드"; cmb_stor.DisplayMember = "명칭"; sqlQuery = comInfo.queryStorage(); wConst.ComboBox_Read_NoBlank(cmb_stor, sqlQuery); //반품상태 cbo반품상태.ValueMember = "코드"; cbo반품상태.DisplayMember = "명칭"; sqlQuery = comInfo.queryCode("905"); wConst.ComboBox_Read_NoBlank(cbo반품상태, sqlQuery); //담당자 cbo담당자.ValueMember = "코드"; cbo담당자.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo담당자, sqlQuery); ////배송사원 //cbo배송사원.ValueMember = "코드"; //cbo배송사원.DisplayMember = "명칭"; //sqlQuery = comInfo.queryStaff(); //wConst.ComboBox_Read_Blank(cbo배송사원, sqlQuery); //cbo완료사원 cbo완료사원.ValueMember = "코드"; cbo완료사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo완료사원, sqlQuery); //cbo회수사원 cbo회수사원.ValueMember = "코드"; cbo회수사원.DisplayMember = "명칭"; sqlQuery = comInfo.queryStaff(); wConst.ComboBox_Read_Blank(cbo회수사원, sqlQuery); 매출구분.DataSource = wnDm.매출구분(); 매출구분.ValueMember = "코드"; 매출구분.DisplayMember = "명칭"; }
private void init_ComboBox() { ComInfo comInfo = new ComInfo(); string sqlQuery = ""; cmb_mainten.ValueMember = "코드"; cmb_mainten.DisplayMember = "명칭"; sqlQuery = comInfo.queryCode("800"); wConst.ComboBox_Read_Blank(cmb_mainten, sqlQuery); cmb_dept.ValueMember = "코드"; cmb_dept.DisplayMember = "명칭"; sqlQuery = comInfo.queryDept(); wConst.ComboBox_Read_Blank(cmb_dept, sqlQuery); }
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 = ""; //유통일수 ( 삭제요망 ) }
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("and L_CODE = '2' "); wConst.ComboBox_Read_Blank(cmb_type, sqlQuery); cmb_raw_mat_gbn.ValueMember = "코드"; cmb_raw_mat_gbn.DisplayMember = "명칭"; sqlQuery = comInfo.queryRawList(); wConst.ComboBox_Read_NoBlank(cmb_raw_mat_gbn, sqlQuery); cmb_raw2.ValueMember = "코드"; cmb_raw2.DisplayMember = "명칭"; sqlQuery = comInfo.queryRawList(); wConst.ComboBox_Read_NoBlank(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.queryStorage(); //창고 wConst.ComboBox_Read_Blank(cmb_raw_stor, sqlQuery); cmb_tax_cd.ValueMember = "코드"; cmb_tax_cd.DisplayMember = "명칭"; sqlQuery = comInfo.queryVatAll(); //창고 wConst.ComboBox_Read_NoBlank(cmb_tax_cd, sqlQuery); }