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