//콤보박스 바인딩 모음
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);
}
