Exemplo n.º 1
0
        private void btn_del2_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(this.txt_idx2.Text))
            {
                MessageAgent.MessageShow(MessageType.Warning, "게시판 코드를 선택하세요 !");
                return;
            }

            if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R2"))
            {
                try
                {
                    Cursor.Current = Cursors.WaitCursor;

                    using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
                    {
                        using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_RM02_DELETE_01", con))
                        {
                            con.Open();
                            cmd.CommandType = CommandType.StoredProcedure;

                            cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.VarChar));
                            cmd.Parameters["i_idx"].Value     = txt_idx2.EditValue;
                            cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;


                            cmd.ExecuteNonQuery();
                            con.Close();
                        }
                    }

                    MessageAgent.MessageShow(MessageType.Informational, "처리 되었습니다.");
                    Cursor.Current = Cursors.Default;
                    //Clear();
                    rbis_notice.EditValue = "Y";
                    picBanner1.LoadAsync("http://media.domalife.net:8080/files/product/donutbiz/mori_00000009/2019101884241596.jpg");
                    picBanner2.LoadAsync("http://media.domalife.net:8080/files/product/donutbiz/mori_00000009/2019101884241596.jpg");
                    picBanner3.LoadAsync("http://media.domalife.net:8080/files/product/donutbiz/mori_00000009/2019101884241596.jpg");
                    txtfile1.EditValue    = "";
                    txtsubject.EditValue  = "";
                    txt_idx2.EditValue    = "";
                    txtimg_url1.EditValue = "";
                    txtimg_url2.EditValue = "";
                    txtimg_url3.EditValue = "";
                    Clear2();

                    Open2();
                    //SetCmb();
                }
                catch (Exception ex)
                {
                    MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    Cursor.Current = Cursors.Default;
                }
            }
        }
Exemplo n.º 2
0
        public override void Save()
        {
            base.Save();

            //부서정보 저장
            if (txtCOMPANYCD.EditValue == null)
            {
                MessageAgent.MessageShow(MessageType.Warning, "회사코드가 없습니다!");
                return;
            }

            if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
            {
                if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R1"))
                {
                    try
                    {
                        int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_MM_MM02_SAVE_01"
                                                                   , UserInfo.instance().UserId
                                                                   , this.txtCOMPANYCD.EditValue
                                                                   , this.cmbBIZCD.EditValue
                                                                   , this.txtDEPTCODE.EditValue
                                                                   , this.txtDEPTNAME.EditValue
                                                                   , this.txtDEPTABBR.EditValue
                                                                   , this.txtSTARTYM.EditValue
                                                                   , this.txtENDYM.EditValue
                                                                   , this.chkUSEYN.EditValue
                                                                   , this.txtMEMO.EditValue
                                                                   , this.txtREFCODE.EditValue
                                                                   , Convert.ToInt16(this.txtRNKORDER.EditValue)
                                                                   , Convert.ToInt16(this.txtLEVEL.EditValue)
                                                                   );

                        if (retVal > 0)
                        {
                            MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
                            Open1();
                            this.treeView1.Nodes.Clear();
                            CreTree();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    }
                }
            }
        }
Exemplo n.º 3
0
        private void btnSave1_Click(object sender, EventArgs e)
        {
            //회사정보 저장
            if (txtCOMPANYCD.EditValue == null)
            {
                MessageAgent.MessageShow(MessageType.Warning, "회사코드가 없습니다!");
                return;
            }

            if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
            {
                if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R1"))
                {
                    try
                    {
                        int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_MM_MM01_SAVE_01"
                                                                   , UserInfo.instance().UserId
                                                                   , this.txtCOMPANYCD.EditValue
                                                                   , this.txtCOMPANYNAME.EditValue
                                                                   , this.txtCOMPANYENG.EditValue
                                                                   , this.txtZIPNO.EditValue
                                                                   , this.txtADDR.EditValue
                                                                   , this.txtTEL.EditValue
                                                                   , this.txtFAX.EditValue
                                                                   , this.txtURL.EditValue
                                                                   , this.txtMEMO.EditValue
                                                                   , this.txtREGISTERNO.EditValue
                                                                   , this.txtPREGIDENT.EditValue
                                                                   , this.txtWORKTYPE.EditValue
                                                                   , this.txtWORKJONG.EditValue
                                                                   , this.lblFILE_GRP_ID.Text
                                                                   , this.lblFILE_GRP_ID2.Text
                                                                   );

                        if (retVal > 0)
                        {
                            Open1();
                            MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    }
                }
            }
        }
Exemplo n.º 4
0
        private void brnSave_Click(object sender, EventArgs e)
        {
            if (txtCOMPANYCD.EditValue == null)
            {
                MessageAgent.MessageShow(MessageType.Warning, "회사코드가 없습니다!");
                return;
            }

            if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
            {
                if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R1"))
                {
                    try
                    {
                        int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_MA_MA01_SAVE_01"
                                                                   , UserInfo.instance().UserId
                                                                   , this.txtCOMPANYCD.EditValue
                                                                   , this.cmbBIZCD.EditValue
                                                                   , this.txtDUTYCODE.EditValue
                                                                   , this.txtDUTYNAME.EditValue
                                                                   , Convert.ToInt16(this.txtRANKORDER.EditValue)
                                                                   , this.txtMEMO.EditValue
                                                                   );

                        if (retVal > 0)
                        {
                            MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
                            Open1();
                            btnNew_Click(null, null);
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    }
                }
            }
        }
Exemplo n.º 5
0
        private void save2()
        {
            if (string.IsNullOrEmpty(this.txt_board_cd2.Text) ^ txt_board_cd2.EditValue.ToString() == "01")
            {
                MessageAgent.MessageShow(MessageType.Warning, "게시판 코드를 선택하세요 !");
                return;
            }

            if (string.IsNullOrEmpty(this.txtsubject.Text))
            {
                MessageAgent.MessageShow(MessageType.Warning, "글 제목을 입력하세요 !");
                return;
            }
            if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R2"))
            {
                try
                {
                    Cursor.Current = Cursors.WaitCursor;

                    using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
                    {
                        using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_RM02_SAVE_02", con))
                        {
                            con.Open();
                            cmd.CommandType = CommandType.StoredProcedure;

                            cmd.Parameters.Add(new MySqlParameter("i_userid", MySqlDbType.VarChar));
                            cmd.Parameters["i_userid"].Value     = UserInfo.instance().UserId;
                            cmd.Parameters["i_userid"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.VarChar));
                            cmd.Parameters["i_idx"].Value     = txt_idx2.EditValue;
                            cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_board_cd", MySqlDbType.VarChar));
                            cmd.Parameters["i_board_cd"].Value     = txt_board_cd2.EditValue;
                            cmd.Parameters["i_board_cd"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_subject", MySqlDbType.VarChar));
                            cmd.Parameters["i_subject"].Value     = txtsubject.EditValue;
                            cmd.Parameters["i_subject"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_content", MySqlDbType.Text));
                            //cmd.Parameters["i_content"].Value = txt_content.DocumentHtml;
                            cmd.Parameters["i_content"].Value     = txt_content.BodyHtml;
                            cmd.Parameters["i_content"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_img_url1", MySqlDbType.VarChar));
                            cmd.Parameters["i_img_url1"].Value     = txtimg_url1.EditValue;
                            cmd.Parameters["i_img_url1"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_img_url2", MySqlDbType.VarChar));
                            cmd.Parameters["i_img_url2"].Value     = txtimg_url2.EditValue;
                            cmd.Parameters["i_img_url2"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_img_url3", MySqlDbType.VarChar));
                            cmd.Parameters["i_img_url3"].Value     = txtimg_url3.EditValue;
                            cmd.Parameters["i_img_url3"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_file1", MySqlDbType.VarChar));
                            cmd.Parameters["i_file1"].Value     = txtfile1.EditValue;
                            cmd.Parameters["i_file1"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_is_notice", MySqlDbType.VarChar));
                            cmd.Parameters["i_is_notice"].Value     = rbis_notice.EditValue;
                            cmd.Parameters["i_is_notice"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_summury", MySqlDbType.VarChar));
                            cmd.Parameters["i_summury"].Value     = txtsummury.EditValue;
                            cmd.Parameters["i_summury"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_board_type", MySqlDbType.VarChar));
                            cmd.Parameters["i_board_type"].Value     = rbboard_type.EditValue;
                            cmd.Parameters["i_board_type"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_is_file", MySqlDbType.VarChar));
                            cmd.Parameters["i_is_file"].Value     = chkis_file.EditValue;
                            cmd.Parameters["i_is_file"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_notice_seq", MySqlDbType.VarChar));
                            cmd.Parameters["i_notice_seq"].Value     = cknotice_seq.EditValue;
                            cmd.Parameters["i_notice_seq"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.VarChar));
                            cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;



                            cmd.ExecuteNonQuery();
                            txt_idx2.EditValue = cmd.Parameters["o_idx"].Value.ToString();

                            con.Close();
                        }
                    }

                    //MessageAgent.MessageShow(MessageType.Informational, "처리 되었습니다.");
                    Cursor.Current = Cursors.Default;
                    //Clear();
                    Open2();
                    //SetCmb();
                }
                catch (Exception ex)
                {
                    MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    Cursor.Current = Cursors.Default;
                }
            }
        }
Exemplo n.º 6
0
        private void btn_save1_Click(object sender, EventArgs e)
        {
            if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R1"))
            {
                try
                {
                    Cursor.Current = Cursors.WaitCursor;

                    using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
                    {
                        using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_RM02_SAVE_01", con))
                        {
                            con.Open();
                            cmd.CommandType = CommandType.StoredProcedure;

                            cmd.Parameters.Add(new MySqlParameter("i_userid", MySqlDbType.VarChar));
                            cmd.Parameters["i_userid"].Value     = UserInfo.instance().UserId;
                            cmd.Parameters["i_userid"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.VarChar));
                            cmd.Parameters["i_idx"].Value     = txt_idx.EditValue;
                            cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_board_cd", MySqlDbType.VarChar));
                            cmd.Parameters["i_board_cd"].Value     = txt_board_cd.EditValue;
                            cmd.Parameters["i_board_cd"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_board_name", MySqlDbType.VarChar));
                            cmd.Parameters["i_board_name"].Value     = txt_board_name.EditValue;
                            cmd.Parameters["i_board_name"].Direction = ParameterDirection.Input;

                            string s_is_use = string.Empty;
                            if (chk_is_use.Checked == true)
                            {
                                s_is_use = "Y";
                            }
                            else
                            {
                                s_is_use = "N";
                            }
                            cmd.Parameters.Add(new MySqlParameter("i_is_use", MySqlDbType.VarChar));
                            cmd.Parameters["i_is_use"].Value     = s_is_use;
                            cmd.Parameters["i_is_use"].Direction = ParameterDirection.Input;

                            string s_is_notice = string.Empty;
                            if (chk_is_notice.Checked == true)
                            {
                                s_is_notice = "Y";
                            }
                            else
                            {
                                s_is_notice = "N";
                            }
                            cmd.Parameters.Add(new MySqlParameter("i_is_notice", MySqlDbType.VarChar));
                            cmd.Parameters["i_is_notice"].Value     = s_is_notice;
                            cmd.Parameters["i_is_notice"].Direction = ParameterDirection.Input;

                            string s_is_file = string.Empty;
                            if (chk_is_file.Checked == true)
                            {
                                s_is_file = "Y";
                            }
                            else
                            {
                                s_is_file = "N";
                            }
                            cmd.Parameters.Add(new MySqlParameter("i_is_file", MySqlDbType.VarChar));
                            cmd.Parameters["i_is_file"].Value     = s_is_file;
                            cmd.Parameters["i_is_file"].Direction = ParameterDirection.Input;

                            string s_is_comment = string.Empty;
                            if (chk_is_comment.Checked == true)
                            {
                                s_is_comment = "Y";
                            }
                            else
                            {
                                s_is_comment = "N";
                            }
                            cmd.Parameters.Add(new MySqlParameter("i_is_comment", MySqlDbType.VarChar));
                            cmd.Parameters["i_is_comment"].Value     = s_is_comment;
                            cmd.Parameters["i_is_comment"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("i_remark", MySqlDbType.VarChar));
                            cmd.Parameters["i_remark"].Value     = txt_remark.EditValue;
                            cmd.Parameters["i_remark"].Direction = ParameterDirection.Input;

                            cmd.Parameters.Add(new MySqlParameter("o_idx", MySqlDbType.VarChar));
                            cmd.Parameters["o_idx"].Direction = ParameterDirection.Output;

                            cmd.ExecuteNonQuery();
                            txt_idx.EditValue = cmd.Parameters["o_idx"].Value.ToString();

                            con.Close();
                        }
                    }

                    MessageAgent.MessageShow(MessageType.Informational, "처리 되었습니다.");
                    Cursor.Current = Cursors.Default;
                    //Clear();
                    Open1();
                    SetCmb();
                }
                catch (Exception ex)
                {
                    MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    Cursor.Current = Cursors.Default;
                }
            }
        }
Exemplo n.º 7
0
        public override void Save()
        {
            //기본정보 저장
            if (txtPURCHASECODE.EditValue == null)
            {
                MessageAgent.MessageShow(MessageType.Warning, " 거래처 코드가 없습니다!");
                return;
            }

            if (txtPURCHASENAME.EditValue == null)
            {
                MessageAgent.MessageShow(MessageType.Warning, " 거래처명이 없습니다!");
                return;
            }


            if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
            {
                if (ValidationAgentEx.IsRequireCheck(this.layoutControl2.Controls, "P1"))
                {
                    try
                    {
                        //DataSet ds = ServiceAgent.ExecuteDataSet(false, "CONIS_IBS", "USP_PM_PM01_SAVE_01"
                        int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_PM_PM01_SAVE_01"
                                                                   , UserInfo.instance().UserId
                                                                   , this.txtCOMPANYCD.EditValue
                                                                   , this.cmbBIZCD.EditValue
                                                                   , this.txtPURCHASECODE.EditValue
                                                                   , this.txtPURCHASENAME.EditValue
                                                                   , this.txtREGISTERNO.EditValue
                                                                   , this.cmbLARGETYPE.EditValue
                                                                   , this.dtINDATE.EditValue3
                                                                   , this.dtDEALSTOPDATE.EditValue3
                                                                   , this.txtDEALSTOPREASON.EditValue
                                                                   , this.txtHANDPHONE.EditValue
                                                                   , this.txtEMAILADD.EditValue
                                                                   , this.txtPERSONNAME.EditValue
                                                                   , this.txtSERVICETYPE.EditValue
                                                                   , this.txtSERVICENAME.EditValue
                                                                   , this.txtCHARGENAME.EditValue
                                                                   , this.txtTELNO.EditValue
                                                                   , this.txtFAXNO.EditValue
                                                                   , this.txtPOSTNO.EditValue
                                                                   , this.txtADDRESS1.EditValue
                                                                   , this.txtADDRESS2.EditValue
                                                                   , this.txtCUSTID.EditValue
                                                                   , this.txtCUSTPASS.EditValue
                                                                   , this.txtACCHOLDER.EditValue
                                                                   , this.txtBANKCODE.EditValue2
                                                                   , this.txtSALENO.EditValue
                                                                   , this.txtACCNO.EditValue
                                                                   );

                        if (retVal > 0)
                        //if (ds.Tables.Count > 0)
                        {
                            //this.txtPURCHASECODE.EditValue = ds.Tables[0].Rows[0]["NEW_ID"];
                            MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
                            Open1();

                            //NewMode();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                    }
                }
            }
        }
Exemplo n.º 8
0
        private void BtnSave_Click(object sender, EventArgs e)
        {
            //if (UserInfo.instance().UserId != "0000000024" && UserInfo.instance().UserId != "0000000012" && UserInfo.instance().UserId != "169.254.169.113" && UserInfo.instance().UserId != "0000000027" && UserInfo.instance().UserId != "2020020002" && UserInfo.instance().UserId != "0000000036" && UserInfo.instance().UserId != "0000000036" )
            //{
            //    MessageAgent.MessageShow(MessageType.Error, "처리권한이 없습니다!");
            //    IsAutoSearch = false;
            //    return;
            //}

            if (string.IsNullOrEmpty(this.txtIDX.Text))
            {
                MessageAgent.MessageShow(MessageType.Error, "회원을 선택하신후에 처리하세요!");
                IsAutoSearch = false;
                return;
            }


            if (cmbU_CHEF_LEVEL.EditValue.ToString() == "4")
            {
                MessageAgent.MessageShow(MessageType.Error, "멀티샵 등급인경우 헬퍼로 선택후 미용실(G샵) 체크하세요 !");
                IsAutoSearch = false;
                return;
            }

            if (MessageAgent.MessageShow(MessageType.Confirm, "저장 하시겠습니까?") == DialogResult.OK)
            {
                if (ValidationAgentEx.IsRequireCheck(this.layoutControl1.Controls, "R1"))
                {
                    try
                    {
                        //히스토리 내용 생성
                        using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real))
                        {
                            using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_MM_MM05_SAVE_03", con))
                            {
                                con.Open();
                                cmd.CommandType = CommandType.StoredProcedure;

                                cmd.Parameters.Add(new MySqlParameter("i_idx", MySqlDbType.Int32));
                                cmd.Parameters["i_idx"].Value     = Convert.ToInt32(txtIDX.EditValue);
                                cmd.Parameters["i_idx"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_u_id", MySqlDbType.VarChar));
                                cmd.Parameters["i_u_id"].Value     = txtU_ID.EditValue;
                                cmd.Parameters["i_u_id"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_name", MySqlDbType.VarChar));
                                cmd.Parameters["i_name"].Value     = txtU_NAME.EditValue;
                                cmd.Parameters["i_name"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_nickname", MySqlDbType.VarChar));
                                cmd.Parameters["i_nickname"].Value     = txtU_NICKNAME.EditValue;
                                cmd.Parameters["i_nickname"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_u_email", MySqlDbType.VarChar));
                                cmd.Parameters["i_u_email"].Value     = txtU_EMAIL.EditValue;
                                cmd.Parameters["i_u_email"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_doramd_type", MySqlDbType.VarChar));
                                cmd.Parameters["i_doramd_type"].Value     = cmbDORAMD_TYPE.EditValue;
                                cmd.Parameters["i_doramd_type"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_is_comp_md", MySqlDbType.VarChar));
                                cmd.Parameters["i_is_comp_md"].Value     = chkIS_COMP_MD.EditValue;
                                cmd.Parameters["i_is_comp_md"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_post_no", MySqlDbType.VarChar));
                                cmd.Parameters["i_post_no"].Value     = txtU_ZIP.EditValue;
                                cmd.Parameters["i_post_no"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_addr", MySqlDbType.VarChar));
                                cmd.Parameters["i_addr"].Value     = txtU_ADDR.EditValue;
                                cmd.Parameters["i_addr"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_addr_detail", MySqlDbType.VarChar));
                                cmd.Parameters["i_addr_detail"].Value     = txtU_ADDR_DETAIL.EditValue;
                                cmd.Parameters["i_addr_detail"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_cell_num", MySqlDbType.VarChar));
                                cmd.Parameters["i_cell_num"].Value     = txtU_CELL_NUM.EditValue;
                                cmd.Parameters["i_cell_num"].Direction = ParameterDirection.Input;


                                cmd.Parameters.Add(new MySqlParameter("i_is_stock_friend", MySqlDbType.VarChar));
                                cmd.Parameters["i_is_stock_friend"].Value     = chkIS_STOCK_FRIEND.EditValue;
                                cmd.Parameters["i_is_stock_friend"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_u_chef_level", MySqlDbType.VarChar));
                                cmd.Parameters["i_u_chef_level"].Value     = cmbU_CHEF_LEVEL.EditValue;
                                cmd.Parameters["i_u_chef_level"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_is_official", MySqlDbType.VarChar));
                                cmd.Parameters["i_is_official"].Value     = ckis_official.EditValue;
                                cmd.Parameters["i_is_official"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_is_vvip", MySqlDbType.VarChar));
                                cmd.Parameters["i_is_vvip"].Value     = cbis_vvip.EditValue;
                                cmd.Parameters["i_is_vvip"].Direction = ParameterDirection.Input;

                                cmd.Parameters.Add(new MySqlParameter("i_is_biz", MySqlDbType.VarChar));
                                cmd.Parameters["i_is_biz"].Value     = chkIS_BIZ.EditValue;
                                cmd.Parameters["i_is_biz"].Direction = ParameterDirection.Input;

                                cmd.ExecuteNonQuery();
                                con.Close();
                            }
                        }

                        Cursor.Current = Cursors.WaitCursor;



                        //int retVal = ServiceAgent.ExecuteNoneQuery(UserInfo.instance().UserId, "CONIS_IBS", "USP_MM_MM05_SAVE_01"
                        //                                         , UserInfo.instance().UserId
                        //                                         , this.txtCOMPANYCD.EditValue
                        //                                         , Convert.ToInt64(this.txtIDX.EditValue)
                        //                                         , this.txtU_NICKNAME.EditValue
                        //                                         //, this.chkUNIONORNOT.Checked == true ? "Y" : "N"
                        //                                         );

                        //if (retVal > 0)
                        //{
                        //    //this.txtUSERID.EditValue = ds.Tables[0].Rows[0]["NEW_ID"];
                        //    MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
                        //    Search();
                        //    //NewMode();
                        //}

                        //DataSet ds = ServiceAgent.ExecuteDataSet(false, "CONIS_IBS", "USP_MM_MM05_SAVE_01"
                        //                                        , UserInfo.instance().UserId
                        //                                        , this.txtCOMPANYCD.EditValue
                        //                                        , Convert.ToInt64(this.txtIDX.EditValue)
                        //                                        , this.txtU_ID.EditValue
                        //                                        , this.txtU_NICKNAME.EditValue
                        //                                        , this.txtU_CELL_NUM.EditValue
                        //                                        , this.txtU_EMAIL.EditValue
                        //                                        , this.txtU_ZIP.Text
                        //                                        , this.txtU_ADDR.EditValue
                        //                                        , this.txtU_ADDR_DETAIL.EditValue
                        //                                        , Convert.ToInt16(this.cmbU_CHEF_LEVEL.EditValue)
                        //                                        , this.chkIS_AL_FRIEND.EditValue
                        //                                        , this.chkIS_STOCK_FRIEND.EditValue
                        //                                        , this.txtCHEF_U_NICKNAME.EditValue2
                        //                                        , this.txtCHEF_U_NICKNAME.Text.Replace("선택하세요","")
                        //                                        , this.txtVIP_RECO_NICKNAME.EditValue2
                        //                                        , this.txtVIP_RECO_NICKNAME.Text.Replace("선택하세요", "")
                        //                                        , this.chkIS_GR_MD.Checked == true ? "Y" : "N"
                        //                                        , this.chkIS_DORAMD.Checked == true ? "Y" : "N"
                        //                                        , this.chkIS_BIZ.Checked == true ? "Y" : "N"
                        //                                        );

                        DataSet ds = ServiceAgent.ExecuteDataSet(false, "CONIS_IBS", "USP_MM_MM05_SAVE_02"
                                                                 , this.txtUSER_ID.EditValue
                                                                 , this.txtCOMPANYCD.EditValue
                                                                 , Convert.ToInt64(this.txtIDX.EditValue)
                                                                 , this.txtU_ID.EditValue
                                                                 , this.txtU_NICKNAME.EditValue
                                                                 , this.txtU_EMAIL.EditValue
                                                                 , this.txtU_NAME.EditValue
                                                                 , this.cmbU_CHEF_LEVEL.EditValue
                                                                 , this.cmbDORAMD_TYPE.EditValue
                                                                 , this.chkIS_SUPPORT_TEAM.EditValue
                                                                 , this.txtU_CELL_NUM.EditValue
                                                                 , this.txtU_ZIP.EditValue
                                                                 , this.txtU_ADDR.EditValue
                                                                 , this.txtU_ADDR_DETAIL.EditValue
                                                                 );

                        if (ds.Tables.Count > 0)
                        {
                            if (ds.Tables[0].Rows[0]["ERRC"].ToString() == "ERR")
                            {
                                MessageAgent.MessageShow(MessageType.Error, ds.Tables[0].Rows[0]["ERRM"].ToString());
                            }
                            else
                            {
                                MessageAgent.MessageShow(MessageType.Informational, "저장 되었습니다.");
                                IsAutoSearch = false;
                                Search();
                                Open1();
                                //NewMode();
                            }
                        }

                        Cursor.Current = Cursors.Default;
                    }
                    catch (Exception ex)
                    {
                        MessageAgent.MessageShow(MessageType.Error, ex.ToString());
                        Cursor.Current = Cursors.Default;
                    }
                }
            }
        }