private void init_ComboBox()
{
string sqlQuery = "";
//불량유형 시작
cmb_cust_gbn.Items.Add("전체 검색");
cmb_cust_gbn.Items.Add("매출처");
cmb_cust_gbn.Items.Add("구매처");
cmb_cust_gbn.SelectedIndex = 0;
cmb_used.ValueMember = "코드";
cmb_used.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustUsedYn();
wConst.ComboBox_Read_NoBlank(cmb_used, sqlQuery);
cmb_used_srch.ValueMember = "코드";
cmb_used_srch.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustUsedYnAll();
wConst.ComboBox_Read_NoBlank(cmb_used_srch, sqlQuery);
cmb_manager.ValueMember = "코드";
cmb_manager.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_Blank(cmb_manager, sqlQuery);
cmb_tax_nm.ValueMember = "코드";
cmb_tax_nm.DisplayMember = "명칭";
sqlQuery = comInfo.queryTax();
wConst.ComboBox_Read_Blank(cmb_tax_nm, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//불량유형 시작
cmb_poor.ValueMember = "코드";
cmb_poor.DisplayMember = "명칭";
sqlQuery = comInfo.queryPoor(); //" select TYPE_CD as 코드, TYPE_NM as 명칭 from N_TYPE_CODE where 1=1 and POOR_TYPE_YN = 'Y'";
wConst.ComboBox_Read_Blank(cmb_poor, sqlQuery);
cmb_poor_type.ValueMember = "코드";
cmb_poor_type.DisplayMember = "명칭";
wConst.ComboBox_Read_Blank(cmb_poor_type, sqlQuery);
//불량유형 끝
//담당자
cmb_manager.ValueMember = "코드";
cmb_manager.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_Blank(cmb_manager, sqlQuery);
//창고
cmb_stor.ValueMember = "코드";
cmb_stor.DisplayMember = "명칭";
sqlQuery = comInfo.queryStorage();
wConst.ComboBox_Read_Blank(cmb_stor, sqlQuery);
}
//콤보박스 바인딩 모음
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()
{
string sqlQuery = "";
cmb거래형태.ValueMember = "코드";
cmb거래형태.DisplayMember = "명칭";
sqlQuery = " select '1' as 코드, '약국' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '2' as 코드, '도매' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '3' as 코드, '의원' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '4' as 코드, '보건소' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '5' as 코드, '병원' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '6' as 코드, '종합병원' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '9' as 코드, '기타' as 명칭 ";
wConst.ComboBox_Read_Blank(cmb거래형태, sqlQuery);
cmb진료과목.ValueMember = "코드";
cmb진료과목.DisplayMember = "명칭";
sqlQuery = " select MAJOR_CODE as 코드, CODE_DESC as 명칭 from MAJORCODE where 1=1 ";
wConst.ComboBox_Read_NoBlank(cmb진료과목, sqlQuery);
cmb거래분류.ValueMember = "코드";
cmb거래분류.DisplayMember = "명칭";
sqlQuery = " select DEAL_KIND as 코드, CODE_DESC as 명칭 from DEALKIND where 1=1 ";
wConst.ComboBox_Read_Blank(cmb거래분류, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb_dept.ValueMember = "코드";
cmb_dept.DisplayMember = "명칭";
sqlQuery = " select DEPT_CD as 코드, DEPT_NM as 명칭 from N_DEPT_CODE where 1=1 ";
wConst.ComboBox_Read_Blank(cmb_dept, sqlQuery);
cmb_pos.ValueMember = "코드";
cmb_pos.DisplayMember = "명칭";
sqlQuery = " select POS_CD as 코드, POS_NM as 명칭 from N_POS_CODE where 1=1 ";
wConst.ComboBox_Read_Blank(cmb_pos, sqlQuery);
cmb_stor.ValueMember = "코드";
cmb_stor.DisplayMember = "명칭";
sqlQuery = " select STORAGE_CD as 코드, STORAGE_NM as 명칭 from N_STORAGE_CODE where 1=1";
wConst.ComboBox_Read_Blank(cmb_stor, sqlQuery);
cmb_auth.ValueMember = "코드";
cmb_auth.DisplayMember = "명칭";
sqlQuery = "select '1' as 코드,'사용정지' as 명칭";
sqlQuery += " union all ";
sqlQuery += "select '2' as 코드,'정보조회' as 명칭";
sqlQuery += " union all ";
sqlQuery += "select '3' as 코드,'자료입력' as 명칭";
sqlQuery += " union all ";
sqlQuery += "select '4' as 코드,'정보분석' as 명칭";
sqlQuery += " union all ";
sqlQuery += "select '5' as 코드,'관리통제' as 명칭";
wConst.ComboBox_Read_Blank(cmb_auth, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//불량유형 시작
cmb_poor_type.ValueMember = "코드";
cmb_poor_type.DisplayMember = "명칭";
sqlQuery = comInfo.queryUnitType("1");
wConst.ComboBox_Read_Blank(cmb_poor_type, sqlQuery);
//담당자
cmb_manager.ValueMember = "코드";
cmb_manager.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_Blank(cmb_manager, sqlQuery);
//창고
cmb_stor.ValueMember = "코드";
cmb_stor.DisplayMember = "명칭";
sqlQuery = comInfo.queryStorage();
wConst.ComboBox_Read_Blank(cmb_stor, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//공정
cmb_srch_gbn.ValueMember = "코드";
cmb_srch_gbn.DisplayMember = "명칭";
sqlQuery = comInfo.queryItemGbnAll();
wConst.ComboBox_Read_NoBlank(cmb_srch_gbn, sqlQuery);
cmb_item_flow.ValueMember = "코드";
cmb_item_flow.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_Blank(cmb_item_flow, sqlQuery);
//cmb_eva_gbn.ValueMember = "코드";
//cmb_eva_gbn.DisplayMember = "명칭";
//sqlQuery = comInfo.queryCode("620");
//wConst.ComboBox_Read_Blank(cmb_eva_gbn, sqlQuery);
//제품
cmb_srch_gbn2.ValueMember = "코드";
cmb_srch_gbn2.DisplayMember = "명칭";
sqlQuery = comInfo.queryItemGbnAll();
wConst.ComboBox_Read_NoBlank(cmb_srch_gbn2, sqlQuery);
}
private void init_ComboBox()
{
cmb_fac.ValueMember = "코드";
cmb_fac.DisplayMember = "명칭";
sqlQuery = comInfo.queryLine();
wConst.ComboBox_Read_Blank(cmb_fac, sqlQuery);
cmb_staff.ValueMember = "코드";
cmb_staff.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_Blank(cmb_staff, 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);
}
public void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_flow.ValueMember = "코드";
cmb_flow.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_Blank(cmb_flow, sqlQuery);
cmb_item.ValueMember = "코드";
cmb_item.DisplayMember = "명칭";
sqlQuery = comInfo.queryItem();
wConst.ComboBox_Read_Blank(cmb_item, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_Staff_NM.ValueMember = "코드";
cmb_Staff_NM.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_Blank(cmb_Staff_NM, sqlQuery);
cmb_facnm.ValueMember = "코드";
cmb_facnm.DisplayMember = "명칭";
sqlQuery = comInfo.queryFac();
wConst.ComboBox_Read_Blank(cmb_facnm, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb지역.ValueMember = "코드";
cmb지역.DisplayMember = "명칭";
sqlQuery = " select AreaCode as 코드, AreaName as 명칭 from T_Area where 1=1 ";
wConst.ComboBox_Read_Blank(cmb지역, sqlQuery);
cmb구분.ValueMember = "코드";
cmb구분.DisplayMember = "명칭";
sqlQuery = " select '전체' as 코드, '전체' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '도매' as 코드, '도매' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '소매' as 코드, '소매' as 명칭 ";
wConst.ComboBox_Read_NoBlank(cmb구분, sqlQuery);
cmb사용여부.ValueMember = "코드";
cmb사용여부.DisplayMember = "명칭";
sqlQuery = " select 'Y' as 코드, 'Y' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select 'N' as 코드, 'N' as 명칭 ";
wConst.ComboBox_Read_NoBlank(cmb사용여부, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_meatkind.ValueMember = "코드";
cmb_meatkind.DisplayMember = "명칭";
sqlQuery = comInfo.queryMeatKind();
wConst.ComboBox_Read_Blank(cmb_meatkind, sqlQuery);
cmb_grade_gubun.ValueMember = "코드";
cmb_grade_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryGradeGubun();
wConst.ComboBox_Read_NoBlank(cmb_grade_gubun, sqlQuery);
cmb_fgubun.ValueMember = "코드";
cmb_fgubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryFrozenGubun();
wConst.ComboBox_Read_NoBlank(cmb_fgubun, sqlQuery);
cmb_corigin.ValueMember = "코드";
cmb_corigin.DisplayMember = "명칭";
sqlQuery = comInfo.queryOriginGubun();
wConst.ComboBox_Read_NoBlank(cmb_corigin, sqlQuery);
}
//검색 탭의 그리드 더블클릭 시
private void dataItemGrid_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
lbl_flow_chk_gbn.Text = "";
DataGridView dgv = (DataGridView)sender;
cmb_item_flow.Enabled = true;
FlowChkGrid.Rows.Clear();
lbl_title.Text = "공정검사기준 - 신규 ";
string item_cd = dgv.Rows[e.RowIndex].Cells["ITEM_CD"].Value.ToString();
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
StringBuilder sb = new StringBuilder();
sb.AppendLine("where 1=1 ");
sb.AppendLine(" and A.ITEM_CD = '" + item_cd + "' ");
dt = wDm.fn_Item_List(sb.ToString());
if (dt != null && dt.Rows.Count > 0)
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_item_flow.ValueMember = "코드";
cmb_item_flow.DisplayMember = "명칭";
sqlQuery = comInfo.queryItemFlow(item_cd);
wConst.ComboBox_Read_Blank(cmb_item_flow, sqlQuery);
txt_item_cd.Text = dt.Rows[0]["ITEM_CD"].ToString();
txt_item_nm.Text = dt.Rows[0]["ITEM_NM"].ToString();
txt_spec.Text = dt.Rows[0]["SPEC"].ToString();
txt_item_gbn.Text = dt.Rows[0]["ITEM_GUBUN_NM"].ToString();
}
else
{
MessageBox.Show("데이터 일시 오류");
}
}
catch (Exception ex)
{
MessageBox.Show("시스템 에러: " + ex.Message.ToString());
}
}
private void cmbDataBinding()
{
ComInfo comInfo = new ComInfo();
wnGConstant wConst = new wnGConstant();
string sqlQuery = "";
cmb_storage.ValueMember = "코드";
cmb_storage.DisplayMember = "명칭";
sqlQuery = comInfo.queryStorage();
wConst.ComboBox_Read_Blank(cmb_storage, sqlQuery);
cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryLCode("310");
wConst.ComboBox_Read_Blank(cmb_gubun, sqlQuery);
}
private void frm공정관리_Load(object sender, EventArgs e)
{
string sqlQuery = "";
cmb_line.ValueMember = "코드";
cmb_line.DisplayMember = "명칭";
sqlQuery = comInfo.queryLine();
wConst.ComboBox_Read_Blank(cmb_line, 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 = "";
cmb_item_pass.ValueMember = "코드";
cmb_item_pass.DisplayMember = "명칭";
sqlQuery = comInfo.queryChkPass();
wConst.ComboBox_Read_Blank(cmb_item_pass, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb_raw.ValueMember = "코드";
cmb_raw.DisplayMember = "명칭";
sqlQuery = comInfo.queryRaw();
wConst.ComboBox_Read_Blank(cmb_raw, sqlQuery);
cmb_cust.ValueMember = "코드";
cmb_cust.DisplayMember = "명칭";
sqlQuery = comInfo.queryCust("2");
wConst.ComboBox_Read_Blank(cmb_cust, sqlQuery);
cmb_raw_pass.ValueMember = "코드";
cmb_raw_pass.DisplayMember = "명칭";
sqlQuery = comInfo.queryChkPass();
wConst.ComboBox_Read_Blank(cmb_raw_pass, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_flow_pass.ValueMember = "코드";
cmb_flow_pass.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_Blank(cmb_flow_pass, sqlQuery);
cmb_flow_pass.SelectedIndex = 0;
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_tmp_loc.ValueMember = "코드";
cmb_tmp_loc.DisplayMember = "명칭";
sqlQuery = comInfo.querySensorLoc();
wConst.ComboBox_Read_Blank(cmb_tmp_loc, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_poor.ValueMember = "코드";
cmb_poor.DisplayMember = "명칭";
sqlQuery = comInfo.queryRawPoor();
wConst.ComboBox_Read_Blank(cmb_poor, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_cd.ValueMember = "코드";
cmb_cd.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_Blank(cmb_cd, sqlQuery);
cmb_cd2.ValueMember = "코드";
cmb_cd2.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_ALL(cmb_cd2, 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);
cmb_cd_srch.Items.Add("전체 검색");
cmb_cd_srch.Items.Add("거래처명 검색");
cmb_cd_srch.Items.Add("제품명 검색");
cmb_cd_srch.SelectedIndex = 0;
}
private void pop재고위치수정_Load(object sender, EventArgs e)
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_store_gubun.ValueMember = "코드";
cmb_store_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryStorage();
wConst.ComboBox_Read_Blank(cmb_store_gubun, sqlQuery);
txt_input_date.Text = sInputDate;
txt_input_cd.Text = sInputCd;
txt_seq.Text = sInputSeq;
txt_label_nm.Text = sInputLabelNm;
txt_curr_loc.Text = sInputCurrLoc;
bindData("where A.STORAGE_CD = '" + sStorageCd + "' ");
}
private void init_ComboBox()
{
string sqlQuery = "";
//계정 콤보
//사원 콤보1
//사원 콤보2
cmb_staff.ValueMember = "코드";
cmb_staff.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
wConst.ComboBox_Read_Blank(cmb_staff, sqlQuery);
ID.ValueMember = "코드";
ID.DisplayMember = "명칭";
sqlQuery = comInfo.queryAccu();
wConst.GridComboBox_Read_Blank(ID, sqlQuery);
GUBUN.ValueMember = "코드";
GUBUN.DisplayMember = "명칭";
sqlQuery = comInfo.querySooGubun();
wConst.GridComboBox_Read_Blank(GUBUN, 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("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);
}
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 = ""; //유통일수 ( 삭제요망 )
}