private void setCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(s_idx,'') as DCODE ,s_company_name as DNAME FROM erp.tb_sellers_info where s_status = 'Y' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbAgencyCode, codeArray);
}
cmbAgencyCode.EditValue = "";
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
// con.Query = " SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00003' ";
con.Query = " SELECT idx_fac as DCODE, u_name as DNAME FROM telecom.tb_admin_masters where idx_fac = 4099 ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbFactory, codeArray);
}
cmbFactory.EditValue = "4099";
}
private void setCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00051' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmb_advice_type, codeArray);
}
cmb_advice_type.EditValue = "1";
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00002' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmb_move_type, codeArray);
}
// cmb_move_type.EditValue = "1";
}
private void setCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = " SELECT idx_fac as DCODE, u_name as DNAME FROM telecom.tb_admin_masters where idx_fac = 4099 ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbOut_Factory, codeArray);
}
cmbOut_Factory.EditValue = "4099";
}
private void SetCmb()
{
// 공급자구분
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00007' order by code_id";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbS_DIVISION, codeArray);
}
// 상태
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00009' order by code_id";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbS_STATUS, codeArray);
}
// 과세유형
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00008' order by code_id";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbS_TAX_TYPE, codeArray);
}
// 은행
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00006' order by code_id";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbS_BANK, codeArray);
}
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = "SELECT code_id as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00004' order by code_id";
DataSet ds = con.selectQueryDataSet();
DataTable retDT = ds.Tables[0];
repositoryItemLookUpEdit3.DataSource = retDT;
//컨트롤 초기화
InitCodeControl(repositoryItemLookUpEdit3);
repositoryItemLookUpEdit3.EndUpdate();
}
// 거래처구분
using (MySQLConn con = new MySQLConn(ConstantLib.TelConn_Real))
{
con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM erp.tb_common_code where gcode_id = '00004' order by code_id";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbAgency_type, codeArray);
}
}
private void SetCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00078' and use_yn = 'Y' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbCompany, codeArray);
CodeAgent.MakeCodeControl(this.cmbCompanyQ, codeArray);
}
cmbCompany.EditValue = "01";
cmbCompanyQ.EditValue = "01";
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = "SELECT code_id as DCODE, code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00075' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbMajor_Code, codeArray);
}
cmbMajor_Code.EditValue = "1";
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = "SELECT code_id as DCODE, code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00076' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbLarge_Code, codeArray);
}
cmbLarge_Code.EditValue = "01";
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = "SELECT code_id as DCODE, code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00077' ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
// cmbTAREA1.EditValue = "";
// cmbTAREA1.EditValue = ds.Tables[0].Rows[0]["RESIDENTTYPE"].ToString();
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbSmall_Code, codeArray);
}
cmbSmall_Code.EditValue = "01";
}