private void cmbEvent_EditValueChanged(object sender, EventArgs e) { using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { sql.Query = "SELECT code_val1 as u_name FROM domaadmin.tb_common_code " + "WHERE gcode_id = '00010' and code_id = " + cmbEvent.EditValue; DataSet ds = sql.selectQueryDataSet(); txtIssue.EditValue = sql.selectQueryForSingleValue(); } }
private void btnAdd_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtU_ID.Text)) { MessageAgent.MessageShow(MessageType.Warning, " 회원을 선택하세요!"); return; } if (chkIs_Best.EditValue.ToString() == "Y") { if (txtTEAM_NICKNAME.EditValue.ToString() == "") { MessageAgent.MessageShow(MessageType.Warning, " 담당 팀장을 선택하세요 "); return; } } else { string sGshop_name; using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real)) { sql.Query = "select gshop_name as nCount FROM domabiz.gshop_master where md_u_id = '" + txtU_ID.EditValue + "' limit 1 "; DataSet ds = sql.selectQueryDataSet(); sGshop_name = sql.selectQueryForSingleValue(); } if (sGshop_name.Length > 2) { MessageAgent.MessageShow(MessageType.Warning, sGshop_name + "에서 배스트 샵으로 등록되어 제외 할수가 없습니다"); return; } } if (MessageAgent.MessageShow(MessageType.Confirm, "체험샵을 등록 하시겠습니까?") == DialogResult.OK) { try { using (MySqlConnection con = new MySqlConnection(ConstantLib.BasicConn_Real)) { using (MySqlCommand cmd = new MySqlCommand("domabiz.USP_GSHOP_GSHOP04_SAVE_02", con)) { con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("i_gshop_id", MySqlDbType.Int32)); cmd.Parameters["i_gshop_id"].Value = Convert.ToInt32(txtGSHOP_ID.EditValue); cmd.Parameters["i_gshop_id"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_ceo_name", MySqlDbType.VarChar)); cmd.Parameters["i_ceo_name"].Value = txtCEO_NAME.EditValue; cmd.Parameters["i_ceo_name"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_gshop_name", MySqlDbType.VarChar)); cmd.Parameters["i_gshop_name"].Value = txtGSHOP_NAME.EditValue; cmd.Parameters["i_gshop_name"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_u_nickname", MySqlDbType.VarChar)); cmd.Parameters["i_u_nickname"].Value = txtU_NICKNAME.EditValue; cmd.Parameters["i_u_nickname"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_register_no", MySqlDbType.VarChar)); cmd.Parameters["i_register_no"].Value = txtREGISTER_NO.EditValue; cmd.Parameters["i_register_no"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_email", MySqlDbType.VarChar)); cmd.Parameters["i_email"].Value = txtEMAIL.EditValue; cmd.Parameters["i_email"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_tel_no", MySqlDbType.VarChar)); cmd.Parameters["i_tel_no"].Value = txtTEL_NO.EditValue; cmd.Parameters["i_tel_no"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_hp_no", MySqlDbType.VarChar)); cmd.Parameters["i_hp_no"].Value = txtHP_NO.EditValue; cmd.Parameters["i_hp_no"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_post_no", MySqlDbType.VarChar)); cmd.Parameters["i_post_no"].Value = btnPOST_NO.EditValue; cmd.Parameters["i_post_no"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_jibun_addr", MySqlDbType.VarChar)); cmd.Parameters["i_jibun_addr"].Value = txtADDRESS1.EditValue; cmd.Parameters["i_jibun_addr"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_road_addr", MySqlDbType.VarChar)); cmd.Parameters["i_road_addr"].Value = txtADDRESS1.EditValue; cmd.Parameters["i_road_addr"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_sido", MySqlDbType.VarChar)); cmd.Parameters["i_sido"].Value = cmbTAREA1.EditValue; cmd.Parameters["i_sido"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_gugun", MySqlDbType.VarChar)); cmd.Parameters["i_gugun"].Value = cmbSAREA1.EditValue; cmd.Parameters["i_gugun"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_recomm_nm", MySqlDbType.VarChar)); cmd.Parameters["i_recomm_nm"].Value = txtRECOMM_NM.EditValue; cmd.Parameters["i_recomm_nm"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_recomm_u_id", MySqlDbType.VarChar)); cmd.Parameters["i_recomm_u_id"].Value = txtRECOMM_U_ID.EditValue; cmd.Parameters["i_recomm_u_id"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_md_u_id", MySqlDbType.VarChar)); cmd.Parameters["i_md_u_id"].Value = txtMD_U_ID.EditValue; cmd.Parameters["i_md_u_id"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_road_addr2", MySqlDbType.VarChar)); cmd.Parameters["i_road_addr2"].Value = txtADDRESS2.EditValue; cmd.Parameters["i_road_addr2"].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_is_best", MySqlDbType.VarChar)); cmd.Parameters["i_is_best"].Value = chkIs_Best.EditValue; cmd.Parameters["i_is_best"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("i_team_leader", MySqlDbType.VarChar)); cmd.Parameters["i_team_leader"].Value = txtTEAM_LEADER.EditValue; cmd.Parameters["i_team_leader"].Direction = ParameterDirection.Input; cmd.Parameters.Add(new MySqlParameter("o_Return", MySqlDbType.VarChar)); cmd.Parameters["o_Return"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); MessageBox.Show(cmd.Parameters["o_Return"].Value.ToString()); } } } catch (Exception ex) { MessageAgent.MessageShow(MessageType.Error, ex.ToString()); } Search(); Open1(); } }