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());
}
}
}
