private void SetCmb()
{
// 회원검색
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 = '00034' ";
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.cmbMember_Search, codeArray);
}
cmbMember_Search.EditValue = "01";
}
private void SetCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = "SELECT ifnull(sido,'') as DCODE ,sido_nm as DNAME FROM domabiz.place_master GROUP BY sido, sido_nm ";
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.cmbTAREA1, 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 = '00059' ";
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);
}
cmbCompany.EditValue = "";
}
private void CmbTAREA1_EditValueChanged(object sender, EventArgs e)
{
string sCSIDO = cmbTAREA1.EditValue.ToString();
if (string.IsNullOrEmpty(this.cmbTAREA1.EditValue.ToString()))
{
return;
}
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
//con.Query = "select DCODE, DNAME from ( select gugun as DCODE, concat(gugun_nm, IFNULL((select ' ( 선점 )' from domabiz.md_place where sido = a.sido and gugun = a.gugun), '')) as DNAME from domabiz.place_master a where sido = " + sCSIDO + " ) AS t1 group by dcode, dname ";
con.Query = "select DCODE, DNAME from " +
" ( select gugun as DCODE, " +
" concat(gugun_nm, IFNULL((select ' ( 선점 )' from domabiz.md_place where sido = a.sido and gugun = a.gugun), '')) as DNAME " +
" from domabiz.place_master a " +
" where sido = " + sCSIDO + " ) AS t1 " +
"group by dcode, dname ";
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.cmbSAREA1, codeArray);
}
}