void CreateNode2(Com_CodeNode OrNode) { if (OrNode == null) { return; } try { using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = " select code_id, code_nm FROM domaadmin.tb_common_code where gcode_id = '" + OrNode.gcode_id + "' "; DataSet ds = con.selectQueryDataSet(); DataRow[] drs2 = ds.Tables[0].Select(); for (int i = 0; i < drs2.Length; i++) { Com_CodeNode1 OrNode2 = new Com_CodeNode1(drs2[i]); OrNode.Nodes.Add(OrNode2); } } } 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 domabiz.tb_member_grant_master group by code_id, code_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.cmbMember_Search, codeArray); } cmbMember_Search.EditValue = "4"; }
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 = '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 EfwSimpleButton9_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtIDX2.Text)) { return; } Dictionary <string, string> myRecord; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Dev)) { sql.Query = "SELECT * FROM domalife.member_master_20170530 " + "WHERE idx = @idx LIMIT 1"; sql.addParam("@Idx", txtIDX2.EditValue); myRecord = sql.selectQueryForSingleRecord(); for (int i = 0; i < myRecord.Count; i++) { efwMemoEdit3.EditValue = "idx : " + myRecord["idx"] + "\r\n" + "u_name : " + myRecord["u_name"] + "\r\n" + "u_id : " + myRecord["u_id"] + "\r\n" + "u_nickname : " + myRecord["u_nickname"] + "\r\n" + "login_id : " + myRecord["login_id"]; } } }
private void CreTree() { using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real)) { con.Query = " select gcode_id, gcode_nm FROM domaadmin.tb_common_code where gcode_id in ( '00042', '00055') and use_yn = 'Y' group by gcode_id, gcode_nm "; DataSet ds = con.selectQueryDataSet(); DataRow[] drs1 = ds.Tables[0].Select(); TreeNode rootNode = new TreeNode("기초코드"); this.treeView1.Nodes.Add(rootNode); this.treeView1.ImageList = this.imgOrganList; for (int i = 0; i < drs1.Length; i++) { Com_CodeNode Onode = new Com_CodeNode(drs1[i]); CreateNode2(Onode); rootNode.Nodes.Add(Onode); if (treeView1.Nodes.Count > 0) { treeView1.Nodes[0].Expand(); } } this.treeView1.EndUpdate(); } }
private void EfwSimpleButton7_Click(object sender, EventArgs e) { using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { //sql.Query = "SELECT idx as idx, u_name as u_name FROM domalife.member_master_20170530 " + // "ORDER BY u_name"; sql.Query = "SELECT idx as idx, u_name as u_name FROM domalife.member_master " + "ORDER BY u_name"; DataSet ds = sql.selectQueryDataSet(); efwGridControl1.DataBind(ds); this.efwGridControl1.MyGridView.BestFitColumns(); } }
private void frmMM25_Load(object sender, EventArgs e) { base.FrmLoadEvent(); DevExpress.Utils.AppearanceObject.DefaultFont = new System.Drawing.Font("맑은고딕", 9); this.IsMenuVw = true; this.IsSearch = true; this.IsNewMode = false; this.IsSave = false; this.IsDelete = false; this.IsCancel = false; this.IsPrint = false; this.IsExcel = false; dt1F.EditValue = DateTime.Now.ToString("yyyy-MM"); dt1T.EditValue = DateTime.Now.ToString("yyyy-MM"); DateTime NextMonth; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { sql.Query = "select concat(date_format(adddate(now(), interval 1 month), '%Y-%m')) as NextMonth FROM dual "; DataSet ds = sql.selectQueryDataSet(); NextMonth = Convert.ToDateTime(sql.selectQueryForSingleValue()); } dt1T.EditValue = NextMonth; dt1F.Properties.Mask.EditMask = "yyyy-MM"; dt1F.Properties.DisplayFormat.FormatString = "yyyy-MM"; dt1F.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; dt1F.Properties.CalendarView = DevExpress.XtraEditors.Repository.CalendarView.Vista; dt1F.Properties.VistaCalendarViewStyle = DevExpress.XtraEditors.VistaCalendarViewStyle.YearView; dt1T.Properties.Mask.EditMask = "yyyy-MM"; dt1T.Properties.DisplayFormat.FormatString = "yyyy-MM"; dt1T.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; dt1T.Properties.CalendarView = DevExpress.XtraEditors.Repository.CalendarView.Vista; dt1T.Properties.VistaCalendarViewStyle = DevExpress.XtraEditors.VistaCalendarViewStyle.YearView; gridView1.OptionsView.ShowFooter = true; gridView1.Columns["order_amt"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridView1.Columns["order_amt"].SummaryItem.FieldName = "order_amt"; gridView1.Columns["order_amt"].SummaryItem.DisplayFormat = "합계: {0:c}"; setCmb(); }
private void EfwSimpleButton8_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtIDX1.Text)) { return; } using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Dev)) { sql.Query = "SELECT u_name as u_name FROM domalife.member_master_20170530 " + "WHERE idx = " + txtIDX1.EditValue; DataSet ds = sql.selectQueryDataSet(); efwMemoEdit2.EditValue = sql.selectQueryForSingleValue(); } }
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"; }
private void EfwSimpleButton10_Click(object sender, EventArgs e) { List <string> myColVals; StringBuilder sb = new StringBuilder(); using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Dev)) { sql.Query = "SELECT u_name FROM domalife.member_master_20170530"; myColVals = sql.selectQueryForSingleColumn(); for (int i = 0; i < myColVals.Count; i++) { sb.Append(myColVals[i] + "\r\n"); } efwMemoEdit4.EditValue = sb.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 message() { if (txtLogin_id.Text.Length > 4) { int nCount; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { sql.Query = "select count(*) as nCount FROM domalife.member_master where login_id = '" + txtLogin_id.EditValue + "' "; DataSet ds = sql.selectQueryDataSet(); nCount = Convert.ToInt32(sql.selectQueryForSingleValue()); } if (nCount == 1) { txtId_yn.EditValue = "N"; lbMessage.Text = "사용중인 아이디 입니다"; return; } else { txtId_yn.EditValue = "Y"; lbMessage.Text = "사용가능한 아이디 입니다"; } string strQuery = string.Format(@"SELECT idx AS SEQ FROM y2k2.dbo.Y2K2_member where id = '" + txtLogin_id.EditValue + "' "); DataSet ds1 = ServiceAgent.ExecuteDataSetStr("CONIS_IBS", strQuery); if (ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0 && ds1.Tables[0].Rows[0][0] != DBNull.Value) { // txtCnt.EditValue = ds.Tables[0].Rows[0]["SEQ"]; txtId_yn.EditValue = "N"; lbMessage.Text = "사용중인 아이디 입니다"; } else { txtId_yn.EditValue = "Y"; lbMessage.Text = "사용가능한 아이디 입니다"; } } }
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 = '00053' 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.cmbQ1, codeArray); } cmbQ1.EditValue = "0"; }
private void message1() { if (txtU_NICKNAME.Text.Length > 4) { int nCount; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { sql.Query = "select count(*) as nCount FROM domalife.member_master where login_id = '" + txtU_NICKNAME.EditValue + "' "; DataSet ds = sql.selectQueryDataSet(); nCount = Convert.ToInt32(sql.selectQueryForSingleValue()); } if (nCount == 1) { txtNick_yn.EditValue = "N"; lbMessage.Text = "사용중인 닉네임 입니다"; } else { txtNick_yn.EditValue = "Y"; lbMessage.Text = "사용가능한 닉네임 입니다"; } } }
private void efwSimpleButton1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtID.Text)) { MessageAgent.MessageShow(MessageType.Warning, " ID를 선택하세요!"); return; } int nCount; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { sql.Query = "select count(*) as nCount FROM domalife.member_master where login_id = '" + txtID.EditValue + "' "; DataSet ds = sql.selectQueryDataSet(); nCount = Convert.ToInt32(sql.selectQueryForSingleValue()); } if (nCount == 1) { MessageAgent.MessageShow(MessageType.Warning, " domalife.member_master 회원 이력이 존재합니다 "); return; } txtO_U_ID.EditValue = ""; if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK) { try { // using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real)) using (MySqlConnection con = new MySqlConnection(ConstantLib.Member_Real)) { using (MySqlCommand cmd = new MySqlCommand("DB_MEMBER.USP_MM_MM16_SAVE_01", con)) { con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("i_id", MySqlDbType.VarChar)); cmd.Parameters["i_id"].Value = txtID.EditValue; cmd.Parameters["i_id"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_pwd", MySqlDbType.VarChar)); cmd.Parameters["i_pwd"].Value = txtPWD.EditValue; cmd.Parameters["i_pwd"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_name", MySqlDbType.VarChar)); cmd.Parameters["i_name"].Value = txtNAME.EditValue; cmd.Parameters["i_name"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_nickname", MySqlDbType.VarChar)); cmd.Parameters["i_nickname"].Value = txtNICKNAME.EditValue; cmd.Parameters["i_nickname"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_birth", MySqlDbType.VarChar)); cmd.Parameters["i_birth"].Value = txtBIRTH.EditValue; cmd.Parameters["i_birth"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_hpno", MySqlDbType.VarChar)); cmd.Parameters["i_hpno"].Value = txtHPNO.EditValue; cmd.Parameters["i_hpno"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_gender", MySqlDbType.VarChar)); cmd.Parameters["i_gender"].Value = rbGENDER.EditValue; cmd.Parameters["i_gender"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("o_u_id", MySqlDbType.VarChar)); cmd.Parameters["o_u_id"].Direction = ParameterDirection.Output; cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar)); cmd.Parameters["o_Return"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); txtO_U_ID.EditValue = cmd.Parameters["o_u_id"].Value.ToString(); string sU_ID = string.Empty; sU_ID = txtO_U_ID.EditValue.ToString(); if (sU_ID == "N") { MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString()); } else { db_member(); } } } } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } } }