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_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()
{
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_cd.ValueMember = "코드";
cmb_tax_cd.DisplayMember = "명칭";
sqlQuery = comInfo.queryTax();
wConst.ComboBox_Read_NoBlank(cmb_tax_cd, 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 init_ComboBox()
{
string sqlQuery = "";
cmb연도.ValueMember = "코드";
cmb연도.DisplayMember = "명칭";
sqlQuery = " select '" + DateTime.Now.ToString("yyyy") + "' as 코드, '" + DateTime.Now.ToString("yyyy") + "년' as 명칭 ";
for (int kk = int.Parse(DateTime.Now.ToString("yyyy")) - 1; kk >= 2000; kk--)
{
sqlQuery += " union all ";
sqlQuery += " select '" + kk.ToString() + "' as 코드, '" + kk.ToString() + "년' as 명칭 ";
}
wConst.ComboBox_Read_NoBlank(cmb연도, sqlQuery);
cmbS연도.ValueMember = "코드";
cmbS연도.DisplayMember = "명칭";
wConst.ComboBox_Read_NoBlank(cmbS연도, 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 명칭 ";
wConst.ComboBox_Read_NoBlank(cmb구분, sqlQuery);
cmbS구분.ValueMember = "코드";
cmbS구분.DisplayMember = "명칭";
wConst.ComboBox_Read_ALL(cmbS구분, sqlQuery);
}
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()
{
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 pop계산서매출검색_Load(object sender, EventArgs e)
{
ComInfo.gridHeaderSet(GridRecord);
start_date.Text = DateTime.Now.ToString().Substring(0, 8) + "01";
lbl_cust_nm.Text = sName;
ComInfo cominfo = new ComInfo();
wnGConstant wConst = new wnGConstant();
string sqlQuery = "";
cmb_vat_cd.ValueMember = "코드";
cmb_vat_cd.DisplayMember = "명칭";
sqlQuery = cominfo.queryVatAll();
wConst.ComboBox_Read_NoBlank(cmb_vat_cd, sqlQuery);
cmb_vat_cd.SelectedValue = sVatCd;
rsTable.Columns.Add("매출일자");
rsTable.Columns.Add("번호");
rsTable.Columns.Add("순번");
rsTable.Columns.Add("부가세구분");
rsTable.Columns.Add("상품명");
rsTable.Columns.Add("규격");
rsTable.Columns.Add("총수량");
rsTable.Columns.Add("단가");
rsTable.Columns.Add("금액");
rsTable.Columns.Add("상품코드");
rsTable.Columns.Add("상품구분");
bindData("where B.CUST_CD = '" + sCode + "' and A.SALES_DATE >= '" + start_date.Text + "' and A.SALES_DATE <= '" + end_date.Text + "' and A.ESCALATION_YN = 'N' ");
}
private void pop원자재반환_Load(object sender, EventArgs e)
{
string sqlQuery = "";
STORAGE_CD.ValueMember = "코드";
STORAGE_CD.DisplayMember = "명칭";
sqlQuery = comInfo.queryStorage();
wConst.ComboBox_Read_NoBlank(STORAGE_CD, sqlQuery);
del_dgv.AllowUserToAddRows = false;
del_dgv.Columns.Add("INPUT_DATE", "INPUT_DATE");
del_dgv.Columns.Add("INPUT_CD", "INPUT_CD");
del_dgv.Columns.Add("SEQ", "SEQ");
DataTable dt = new DataTable();
string sb = " and (A.LOT_NO =" + lot_no + " )";
//dt = wDm.fn_item_inst_raw_list(sb.ToString());
dt = wDm.raw_input_lotNo(sb);
if (chk == 1)
{
grid_logic(dt);
}
}
private void init_ComboBox()
{
string 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_NoBlank(cmb_stor, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb_comp_yn.ValueMember = "코드";
cmb_comp_yn.DisplayMember = "명칭";
sqlQuery = comInfo.queryCompYnAll();
wConst.ComboBox_Read_NoBlank(cmb_comp_yn, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
//납품일 방법
cmb_tax_cd.ValueMember = "코드";
cmb_tax_cd.DisplayMember = "명칭";
sqlQuery = ComInfo.queryCustTax_select();
wConst.ComboBox_Read_NoBlank(cmb_tax_cd, sqlQuery);
}
private void init_combobox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_vat_gubun.ValueMember = "코드";
cmb_vat_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryVatAll();
wConst.ComboBox_Read_NoBlank(cmb_vat_gubun, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_exprt_gubun.ValueMember = "코드";
cmb_exprt_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryUsedYn(); //사용여부검색
wConst.ComboBox_Read_NoBlank(cmb_exprt_gubun, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb부서지역.ValueMember = "코드";
cmb부서지역.DisplayMember = "명칭";
sqlQuery = " select a.AreaCode as 코드, b.AreaName as 명칭 ";
//sqlQuery = " select isnull(a.AreaCode, '') as 코드, b.AreaName as 명칭 ";
sqlQuery += " from DEPTCODE a ";
sqlQuery += " left outer join T_Area b on b.AreaCode = a.AreaCode ";
sqlQuery += " order by a.DEPT_CODE asc ";
wConst.ComboBox_Read_NoBlank(cmb부서지역, sqlQuery);
cmb부서.ValueMember = "코드";
cmb부서.DisplayMember = "명칭";
sqlQuery = " select DEPT_CODE as 코드, CODE_DESC as 명칭 from DEPTCODE ";
sqlQuery += " order by DEPT_CODE asc ";
wConst.ComboBox_Read_NoBlank(cmb부서, sqlQuery);
}
private void initComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryHACCP_GUBUN();
wConst.ComboBox_Read_NoBlank(cmb_gubun, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
cmb_used_srch.ValueMember = "코드";
cmb_used_srch.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustUsedYnAll(); //사용여부검색
wConst.ComboBox_Read_NoBlank(cmb_used_srch, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//공정
cmb_공정명.ValueMember = "코드";
cmb_공정명.DisplayMember = "명칭";
sqlQuery = comInfo.queryFlow();
wConst.ComboBox_Read_NoBlank(cmb_공정명, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb_year.ValueMember = "코드";
cmb_year.DisplayMember = "명칭";
sqlQuery = "select '1' as 코드, DATEPART(YYYY,dateadd(year,0,getdate())) as 명칭";
//sqlQuery += " union all ";
//sqlQuery += "select DATEPART(YYYY,dateadd(year,-1,getdate())) as s_year";
wConst.ComboBox_Read_NoBlank(cmb_year, sqlQuery);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb_year.ValueMember = "월";
cmb_year.DisplayMember = "월";
sqlQuery = " select substring(w_inst_date,0,5) as 월 from F_WORK_INST group by substring(w_inst_date,0,5) order by 월 desc";
//sqlQuery += " union all ";
//sqlQuery += "select DATEPART(YYYY,dateadd(year,-1,getdate())) as s_year";
wConst.ComboBox_Read_NoBlank(cmb_year, sqlQuery);
}
private void kiosk원자재반환_Load(object sender, EventArgs e)
{
string sqlQuery = "";
int rowCount = 0;
cmb_storage_nm.ValueMember = "명칭";
cmb_storage_nm.DisplayMember = "코드";
sqlQuery = comInfo.queryRawStorage();
wConst.ComboBox_Read_NoBlank(cmb_storage_nm, sqlQuery);
rowCount = cmb_storage_nm.Items.Count;
btn_storage(rowCount);
}
private void init_ComboBox()
{
string sqlQuery = "";
cmb검색조건.ValueMember = "코드";
cmb검색조건.DisplayMember = "명칭";
sqlQuery = " select '0' as 코드, '전체' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '1' as 코드, '부서별' as 명칭 ";
sqlQuery += " union all ";
sqlQuery += " select '2' as 코드, '담당자별' as 명칭 ";
wConst.ComboBox_Read_NoBlank(cmb검색조건, sqlQuery);
cmb담당자.ValueMember = "코드";
cmb담당자.DisplayMember = "명칭";
sqlQuery = " select MAN_CODE as 코드, CODE_DESC as 명칭 from MANCODE where 1=1 ";
wConst.ComboBox_Read_NoBlank(cmb담당자, sqlQuery);
cmb부서.ValueMember = "코드";
cmb부서.DisplayMember = "명칭";
sqlQuery = " select DEPT_CODE as 코드, CODE_DESC as 명칭 from DEPTCODE where 1=1 ";
wConst.ComboBox_Read_NoBlank(cmb부서, sqlQuery);
}
private void init_ComboBox()
{
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//배송사원
cbo배송사원.ValueMember = "코드";
cbo배송사원.DisplayMember = "명칭";
sqlQuery = comInfo.queryStaff();
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.queryStaff();
wConst.ComboBox_Read_NoBlank(cbo상담사원, sqlQuery);
cbo전표상태.ValueMember = "코드";
cbo전표상태.DisplayMember = "명칭";
sqlQuery = comInfo.queryLCode("640");
wConst.ComboBox_Read_NoBlank(cbo전표상태, sqlQuery);
}
private void frm수금등록_Load(object sender, EventArgs e)
{
string sqlQuery = "";
//납품처리방법
cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = new 스마트팩토리.Model.Query.scQuery().queryTSCode("910");
wConst.ComboBox_Read_NoBlank(cmb_gubun, sqlQuery);
grdSooLoad();
ComInfo.gridHeaderSet(grd_soo);
ComInfo.gridHeaderSet(collectGrid);
}
private void frm단가관리_Load(object sender, EventArgs e)
{
//dt = new MES.Model.Query.scQuery().selectPriceInfoSearch();
//grdLoad(dt);
string sqlQuery = "";
cbo_cust.ValueMember = "코드";
cbo_cust.DisplayMember = "명칭";
sqlQuery = comInfo.queryCustSell();
wConst.ComboBox_Read_NoBlank(cbo_cust, sqlQuery);
//cbo_cust.SelectedIndex = 0;
ComInfo.gridHeaderSet(grd_ucost);
}
private void pop오류리포트_Load(object sender, EventArgs e)
{
txt_intime.Text = DateTime.Now.ToString();
txt_saup_nm.Text = Common.p_strCompNm;
ComInfo comInfo = new ComInfo();
string sqlQuery = "";
//불량유형 시작
cmb_error_gubun.ValueMember = "코드";
cmb_error_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.queryErrorGubun();
wConst.ComboBox_Read_NoBlank(cmb_error_gubun, sqlQuery);
if (!Error_log.Equals(""))
{
cmb_error_gubun.SelectedValue = "ERROR";
cmb_error_gubun.Enabled = false;
}
}
private void frm수금등록_Load(object sender, EventArgs e)
{
lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
string sqlQuery = "";
ComInfo comInfo = new ComInfo();
//납품처리방법
cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = cmb_gubun.ValueMember = "코드";
cmb_gubun.DisplayMember = "명칭";
sqlQuery = comInfo.querySooGubun();
wConst.ComboBox_Read_NoBlank(cmb_gubun, sqlQuery);
grdSooLoad();
ComInfo.gridHeaderSet(grd_soo);
ComInfo.gridHeaderSet(collectGrid);
}
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 = ""; //유통일수 ( 삭제요망 )
}