private void SetCmb()
{
try
{
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " SELECT board_cd as DCODE ,board_name as DNAME FROM domalife.g_board where is_use = 'Y' order by board_cd ";
DataSet ds = con.selectQueryDataSet();
//DataTable retDT = ds.Tables[0];
DataRow[] dr = ds.Tables[0].Select();
CodeData[] codeArray = new CodeData[dr.Length];
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbBoard, codeArray);
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
cmbBoard.EditValue = "01";
}
private void popup_FormClosed(object sender, FormClosedEventArgs e)
{
popup_member.FormClosed -= popup_FormClosed;
if (popup_member.DialogResult == DialogResult.OK)
{
this.txtgshop_id.EditValue = popup_member.GSHOP_ID;
int nCount;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select count(*) as nCount FROM domabiz.tb_poto_best_gshop where gshop_id = '" + txtgshop_id.EditValue + "' ";
DataSet ds = sql.selectQueryDataSet();
nCount = Convert.ToInt32(sql.selectQueryForSingleValue());
}
if (nCount == 1)
{
MessageAgent.MessageShow(MessageType.Warning, " 선정 이력이 존재합니다 목록에서 선택하여 수정 하세요~ ");
this.txtSearch_Name.EditValue = popup_member.GSHHOP_NAME;
Search();
}
this.txtgshop_name.EditValue = popup_member.GSHHOP_NAME;
this.txtTelNo.EditValue = popup_member.U_CELL_NUM;
this.txtAddr.EditValue = popup_member.U_ADDR;
}
popup_member = null;
}
private void SetCmb()
{
try
{
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 = '00049' 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];
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbBoard_Type, codeArray);
}
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
cmbBoard_Type.EditValue = "0";
}
private void setCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00052' ";
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.cmbQ1, codeArray);
}
cmbQ1.EditValue = "0";
}
