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"; }