private void setCmb() { try { //사업장콤보 string strQueruy = @"SELECT CODE DCODE ,CODE_NM DNAME FROM ETCCODE WHERE SYS_CODE = '03' AND GRP_CODE='MEMBERQ_GBN1' AND CODE <> 'X'" + " ORDER BY RANKORDER ASC"; CodeAgent.SetLegacyCode(cmbQ1, strQueruy); } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
private void setCmb() { try { //사업장콤보 string strQueruy = @"SELECT BIZCD DCODE ,BIZCD_NM DNAME FROM TBL_BIZCD WHERE COMPANYCD = '" + COMPANYCD + "' " + " ORDER BY BIZCD ASC"; CodeAgent.SetLegacyCode(cmbBIZCD, strQueruy); } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
private void SetCmb() { try { //대분류 string strQueruy3 = @"SELECT CODE DCODE ,CODE_NM DNAME FROM ETCCODE WHERE GRP_CODE = 'MEMBERQ_GBN3' and CODE in ('2','3') ORDER BY GRP_CODE ASC"; CodeAgent.SetLegacyCode(cmbMember_Type, strQueruy3); } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
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 = '00026' "; 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.cmbU_Chef_Level, codeArray); } cmbU_Chef_Level.EditValue = "1"; using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = " select '' as DCODE, '선택하세요' as DNAME union all select ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00026' "; 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.cmbOrderMallTypeQ, codeArray); } cmbOrderMallTypeQ.EditValue = ""; }
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.BasicConn_Real)) { con.Query = " SELECT ifnull(sido,'00') as DCODE ,ifnull(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); } 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 = '00043' "; 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.cmbOrderDate, codeArray); } cmbOrderDate.EditValue = "1"; }
private void setCmb() { try { //대분류 string strQueruy = @"SELECT CODE DCODE ,CODE_NM DNAME FROM ETCCODE WHERE GRP_CODE = 'TEL_SEARCH1' and CODE != 'X' ORDER BY GRP_CODE ASC"; CodeAgent.SetLegacyCode(cmbSearch_Type, strQueruy); cmbSearch_Type.EditValue = "1"; } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
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 = 00042 and code_memo = 'Y' 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.cmbO_Sub_Company, codeArray); cmbO_Sub_Company.EditValue = "0"; } }
private void setCmb() { using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = "select '0' as DCODE, '전체' as DNAMe union all SELECT category_no as DCODE ,story_name as DNAME FROM domaadmin.tb_story_info ORDER BY 1 "; 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.cmbStory, codeArray); } 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 = '00029' "; 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.cmbWriteYn, codeArray); } }
private void setCmb() { try { //사업장콤보 string strQueruy = @"SELECT BIZCD DCODE ,BIZCD_NM DNAME FROM TBL_BIZCD WHERE COMPANYCD = '" + txtCOMPANYCD.EditValue + "' " + " ORDER BY BIZCD ASC"; CodeAgent.SetLegacyCode(cmbBIZCD, strQueruy); string strQueruy2 = @" SELECT T1.DCODE, T1.DNAME FROM ( SELECT '' DCODE, N'전체' DNAME UNION ALL SELECT BIZCD DCODE ,BIZCD_NM DNAME FROM TBL_BIZCD WHERE COMPANYCD = '" + txtCOMPANYCD.EditValue + "'" + @") T1 ORDER BY T1.DCODE ASC"; CodeAgent.SetLegacyCode(cmbBIZCDQ, strQueruy2); //대분류 string strQueruy3 = @"SELECT CODE DCODE ,CODE_NM DNAME FROM ETCCODE WHERE GRP_CODE = 'PURLARGETYPE' ORDER BY GRP_CODE ASC"; CodeAgent.SetLegacyCode(cmbLARGETYPE, strQueruy3); } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
private void setCmb() { try { Dictionary <string, string> myRecord; int i = 0; //대분류 string strQueruy = @"SELECT CODE DCODE ,CODE_NM DNAME FROM dbo.ETCCODE WHERE GRP_CODE = 'DELIVERYTYPE' " + " ORDER BY RANKORDER"; CodeAgent.SetLegacyCode(cmbO_TYPE, strQueruy); } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
private void SetCmb() { using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = "SELECT 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() { try { Dictionary <string, string> myRecord; string strQueruy2 = @" SELECT T1.DCODE, T1.DNAME FROM ( SELECT CODE DCODE, CODE_NM DNAME FROM dbo.ETCCODE WHERE GRP_CODE = 'ORDER_SEARCH' " + @") T1 "; CodeAgent.SetLegacyCode(cmbORDER_SEARCH, strQueruy2); cmbORDER_SEARCH.EditValue = "1"; } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } }
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 = '00031' "; 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.cmbQuery, codeArray); } cmbQuery.EditValue = "0"; }
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 CmbTAREA1_EditValueChanged(object sender, EventArgs e) { //if (string.IsNullOrEmpty(this.cmbTAREA1.Text)) //{ // return; //} string sCSIDO = cmbTAREA1.EditValue.ToString(); 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); } }
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 = '00079' order by code_id"; DataSet ds = con.selectQueryDataSet(); DataTable retDT = ds.Tables[0]; repositoryItemLookUpEdit2.DataSource = retDT; //컨트롤 초기화 InitCodeControl(repositoryItemLookUpEdit2); repositoryItemLookUpEdit2.EndUpdate(); } 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 = '00079' 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.cmbImage_Choice, codeArray); } cmbImage_Choice.EditValue = "00"; }
private void SetCmb() { // 공급자구분 using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = "SELECT ifnull(s_idx,'') as DCODE ,s_company_name as DNAME FROM domaadmin.tb_sellers_info where s_status = 'Y' order by s_company_name "; 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.cmbSellers, codeArray); } cmbSellers.EditValue = "1"; }
private void SetCmb() { // 공급자구분 using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = " select '0' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(s_idx,'') as DCODE ,s_company_name as DNAME FROM domaadmin.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.cmbSellers, codeArray); } cmbSellers.EditValue = "0"; 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 = '00030' "; 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.cmbQuery, codeArray); } cmbQuery.EditValue = "0"; 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 = '00028' "; 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.cmbDoma_Money, codeArray); CodeAgent.MakeCodeControl(this.cmbVip_Money, codeArray); CodeAgent.MakeCodeControl(this.cmbChef_Money, codeArray); CodeAgent.MakeCodeControl(this.cmbMd_Money, codeArray); CodeAgent.MakeCodeControl(this.cmbGshop_Money, codeArray); } cmbDoma_Money.EditValue = "0"; cmbVip_Money.EditValue = "0"; cmbChef_Money.EditValue = "0"; cmbMd_Money.EditValue = "0"; cmbGshop_Money.EditValue = "0"; }
//private void efwGridControl1_Click(object sender, EventArgs e) //{ //} private void setCmb() { try { //Dictionary<string, string> myRecord; string strQueruy1 = @" SELECT T1.DCODE, T1.DNAME FROM ( SELECT '' DCODE, N'전체' DNAME UNION ALL SELECT CODE DCODE, CODE_NM DNAME FROM dbo.ETCCODE WHERE GRP_CODE = 'MALL_TYPE' and Use_YN = 'Y' " + @") T1 "; CodeAgent.SetLegacyCode(cmbMALL_TYPE, strQueruy1); cmbMALL_TYPE.EditValue = ""; string strQueruy2 = @" SELECT T1.DCODE, T1.DNAME FROM ( SELECT CODE DCODE, CODE_NM DNAME FROM dbo.ETCCODE WHERE GRP_CODE = 'ORDER_SEARCH' " + @") T1 "; CodeAgent.SetLegacyCode(cmbORDER_SEARCH, strQueruy2); cmbORDER_SEARCH.EditValue = "1"; } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } 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 = '00025' "; 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.cmbChange_type, codeArray); } cmbChange_type.EditValue = ""; 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 = '00032' "; 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.cmbOrderDate, codeArray); } cmbOrderDate.EditValue = "1"; }
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 = '00007' "; 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.BasicConn_Real)) { con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00009' "; 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.BasicConn_Real)) { con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00008' "; 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.BasicConn_Real)) { con.Query = "SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00006' "; 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); } }
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"; }
private void SetCmb() { // 공급자구분 using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = "SELECT count(*) as DCODE, place1 as DNAME FROM domabiz.beauty_shop group by place1 "; 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.cmbPlace1, codeArray); } using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = "SELECT count(*) as DCODE, place1 as DNAME FROM domabiz.beauty_shop group by place1 "; 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.cmbPlace1_1, codeArray); } 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 = '00014' "; 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.cmbShopType, codeArray); } 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 = '00014' "; 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.cmbShop_Type, codeArray); } }