Esempio n. 1
0
        private void cmbPlace1_1_EditValueChanged(object sender, EventArgs e)
        {
            if (this.cmbPlace1_1.EditValue == null)
            {
                return;
            }

            string sPlace1_1 = cmbPlace1_1.Text.ToString();

            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT count(*) as DCODE, place2  as DNAME  FROM  domabiz.beauty_shop where place1 = " + "'" + sPlace1_1 + "'" + " group by place2 ";

                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.cmbPlace2_1, codeArray);
            }
        }
Esempio n. 2
0
        private void setCmb()
        {
            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT category_no as DCODE ,story_name as DNAME FROM domaadmin.tb_story_info WHERE category_no in(240, 223, 243, 205) ORDER BY sort_id ";

                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.cmbTAREA1, codeArray);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    chkCmb_Story.SelectedText             = "전체선택";
                    chkCmb_Story.Properties.DisplayMember = "DNAME";
                    chkCmb_Story.Properties.ValueMember   = "DCODE";
                    chkCmb_Story.Properties.DataSource    = ds.Tables[0];
                }
            }
        }
Esempio n. 3
0
        public override void InitPrint()
        {
            DataSet ds = new DataSet();

            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "select a.id as ID_Q, a.p_code as P_CODE_Q,  a.p_name as P_NAME_Q,  " +
                            "       b.idx as IDX_Q, b.name as NAME_Q, b.unit as UNIT_Q, b.qty as QTY_Q, b.endornot as ENDORNOT_Q, b.remark as REMARK_Q, prodseq as PRODSEQ_Q " +
                            "  from domamall.tb_am_product_masters a,  " +
                            "        domamall.tb_am_setproduct b  " +
                            "  where a.id = '" + txtSETCODE.EditValue + "'  and " +
                            "        a.id = b.id  " +
                            "  order by a.p_name, b.idx ";

                ds = con.selectQueryDataSet();
            }

            ds.WriteXmlSchema("DataSet1.xsd");


            //    //파라매터전달(옵션)
            string sMEMBER_TYPE = txtMEMBER_TYPE.EditValue.ToString();
            string sTEL_NO      = txtU_CELL_NUM.EditValue.ToString();
            string sADDR        = txtU_ADDR.EditValue.ToString();
            string sU_NAME      = txtU_NAME.EditValue.ToString();

            //GSHOP03_RPT report = new GSHOP03_RPT();
            //report.Parameters["TEL_NO"].Value = sTEL_NO;
            //report.Parameters["MEMBER_TYPE"].Value = sMEMBER_TYPE;
            //report.Parameters["U_NAME"].Value = sU_NAME;
            //report.Parameters["Addr"].Value = sADDR;

            //report.DataSource = ds.Tables[0];
            //report.ShowPreview();
        }
Esempio n. 4
0
        private void Open2()
        {
            using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                SqlCommand cmd = new SqlCommand();
                sql.Query = " select t2.idx as idx, t1.reg_date as reg_date, t1.is_use as is_use, t2.image_url as pic_url1, " +
                            "        t2.contents_id as contents_id, t2.order_key as order_key, t2.overlap_pic as overlap_pic, t2.overlap_loc as overlap_loc" +
                            "   from domalife.story_list t1  " +
                            "        inner join domalife.y_thumbnail_list t2 on t2.contents_id = t1.story_id  and t2.is_use = 'Y' " +
                            "   where t1.category_no = 249 and t1.u_id =  '" + txtU_Id.EditValue + "' and  t2.overlap_pic != 0 " +
                            " union ALL " +
                            " select t2.idx as idx, t1.reg_date as reg_date, t2.is_use as is_use, t2.image_url as pic_url1, " +
                            "        t2.contents_id as contents_id, t2.order_key as order_key, t2.overlap_pic as overlap_pic, t2.overlap_loc as overlap_loc " +
                            "   from domalife.story_list t1 " +
                            "        inner join domalife.y_thumbnail_list t2 on t2.contents_id = t1.story_id   and t2.is_use = 'Y' " +
                            "  where t1.category_no = 249 and t1.u_id = '" + txtU_Id.EditValue + "'  AND " +
                            "        t2.contents_id in (select overlap_pic " +
                            "                             from domalife.story_list a " +
                            "                                  inner join domalife.y_thumbnail_list b on b.contents_id = a.story_id   and a.is_use = 'Y' " +
                            "                             where a.category_no = 249 and a.u_id = '" + txtU_Id.EditValue + "'  and overlap_pic != 0) and " +
                            "        t2.order_key   in (select overlap_loc " +
                            "                            from domalife.story_list a " +
                            "                                 inner join domalife.y_thumbnail_list b on b.contents_id = a.story_id   and a.is_use = 'Y' " +
                            "                            where a.category_no = 249 and a.u_id = '" + txtU_Id.EditValue + "' and overlap_loc != 0) ";

                DataSet ds1 = sql.selectQueryDataSet();
                gridControl2.DataSource = ds1.Tables[0];
            }
        }
Esempio n. 5
0
        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();
            }
        }
Esempio n. 6
0
        private void SetPic()
        {
            picImg1.Image = null;
            picImg2.Image = null;
            picImg3.Image = null;
            picImg4.Image = null;
            picImg5.Image = null;

            lblpic1.Text = "";
            lblpic2.Text = "";
            lblpic3.Text = "";
            lblpic4.Text = "";
            lblpic5.Text = "";

            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT image_url FROM domalife.y_thumbnail_list WHERE contents_id = " + pSTORY_ID;
                DataSet ds = con.selectQueryDataSet();
                //DataTable retDT = ds.Tables[0];
                DataRow[]  dr        = ds.Tables[0].Select();
                CodeData[] codeArray = new CodeData[dr.Length];

                //pictureEdit.Image = Image.FromFile(@"c:\sample.jpg");
                for (int i = 0; i < dr.Length; i++)
                {
                    if (i == 0)
                    {
                        picImg1.LoadAsync(dr[i]["image_url"].ToString());
                        lblpic1.Text = dr[i]["image_url"].ToString();
                    }
                    else if (i == 1)
                    {
                        picImg2.LoadAsync(dr[i]["image_url"].ToString());
                        lblpic2.Text = dr[i]["image_url"].ToString();
                    }
                    else if (i == 2)
                    {
                        picImg3.LoadAsync(dr[i]["image_url"].ToString());
                        lblpic3.Text = dr[i]["image_url"].ToString();
                    }
                    else if (i == 3)
                    {
                        picImg4.LoadAsync(dr[i]["image_url"].ToString());
                        lblpic4.Text = dr[i]["image_url"].ToString();
                    }
                    else if (i == 4)
                    {
                        picImg5.LoadAsync(dr[i]["image_url"].ToString());
                        lblpic5.Text = dr[i]["image_url"].ToString();
                    }
                }
            }
        }
Esempio n. 7
0
        public override void FrmLoadEvent()
        {
            base.FrmLoadEvent();
            DevExpress.Utils.AppearanceObject.DefaultFont = new System.Drawing.Font("맑은고딕", 9);

            this.IsMenuVw  = true;
            this.IsSearch  = true;
            this.IsNewMode = true;
            this.IsSave    = true;
            this.IsDelete  = false;
            this.IsCancel  = false;
            this.IsPrint   = true;
            this.IsExcel   = false;

            dtS_DATE.EditValue = DateTime.Now;
            dtE_DATE.EditValue = DateTime.Now;

            dataGridView.OptionsView.ShowFooter = true;

            this.efwGridControl1.BindControlSet(
                new ColumnControlSet("ID", txtID)
                , new ColumnControlSet("setcode", txtSETCODE)
                , new ColumnControlSet("u_name", txtU_NAME)
                , new ColumnControlSet("member_type", txtMEMBER_TYPE)
                , new ColumnControlSet("u_cell_num", txtU_CELL_NUM)
                , new ColumnControlSet("u_addr", txtU_ADDR)
                );

            this.efwGridControl1.Click += efwGridControl1_Click;



            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT d_code as DCODE ,d_name as DNAME  FROM domamall.tb_am_product_delivers order by sort";

                DataSet   ds    = con.selectQueryDataSet();
                DataTable retDT = ds.Tables[0];

                repositoryItemLookUpEdit1.DataSource = retDT;
                //컨트롤 초기화
                InitCodeControl(repositoryItemLookUpEdit1);

                repositoryItemLookUpEdit1.EndUpdate();
            }


            setCmb();
        }
Esempio n. 8
0
        private void CmbTAREA1_EditValueChanged(object sender, EventArgs e)
        {
            string sCSIDO = string.Empty;

            //if (cmbTAREA1.EditValue.ToString() == null && cmbTAREA1.EditValue.ToString() == "")
            //if (cmbTAREA1.EditValue.ToString() == "")
            //{
            //    sCSIDO = "00";
            //}
            //else
            //{
            sCSIDO = cmbTAREA1.EditValue.ToString();
            //}



            if (string.IsNullOrEmpty(this.cmbTAREA1.EditValue.ToString()))
            {
                return;
            }


            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                //con.Query = "select DCODE, DNAME from ( select gugun as DCODE, concat(gugun_nm, IFNULL((select '   ( 선점 )' from domabiz.md_place where sido = a.sido and gugun = a.gugun), '')) as DNAME from domabiz.place_master a  where sido = " + sCSIDO + "  ) AS t1 group by dcode, dname ";
                con.Query = "select DCODE, DNAME from " +
                            " ( select ifnull(gugun,'00') as DCODE, " +
                            "          concat(gugun_nm, IFNULL((select '   ( 선점 )' from domabiz.md_place where sido = a.sido and gugun = a.gugun), '')) as DNAME " +
                            "     from domabiz.place_master a  " +
                            "    where sido = " + sCSIDO + "  ) AS t1 " +
                            "group by dcode, dname ";

                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.cmbSAREA1, codeArray);
            }
        }
Esempio n. 9
0
        private void simpleButton4_Click(object sender, EventArgs e)
        {
            using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                SqlCommand cmd = new SqlCommand();
                sql.Query = " select t2.idx as idx, t1.reg_date as reg_date, t3.u_nickname as u_nickname, t1.is_use as is_use, t2.image_url as pic_url1, " +
                            "        t2.contents_id as contents_id, t2.order_key as order_key, t2.overlap_pic as overlap_pic, t2.overlap_loc as overlap_loc" +
                            "   from domalife.story_list t1  " +
                            "        inner join domalife.y_thumbnail_list t2 on t2.contents_id = t1.story_id  and t2.is_use = 'Y' " +
                            "        inner join domalife.member_master    t3 on t3.u_id = t1.u_id    " +
                            "   where t1.category_no = 249 and t1.u_id =  '" + txtU_Id.EditValue + "' and  t2.overlap_pic = 0 " +
                            "  order by t1.story_id, t2.order_key ";

                DataSet ds2 = sql.selectQueryDataSet();
                gridControl1.DataSource = ds2.Tables[0];
            }
        }
Esempio n. 10
0
        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 = '00010' and use_yn = 'Y' 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];

                // 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.cmbEvent, codeArray);
            }

            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT d_code as DCODE ,d_name as DNAME  FROM domamall.tb_am_product_delivers  order by sort ";

                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.cmbDelivery_Company, codeArray);
                cmbDelivery_Company.EditValue = "08";
            }
        }
Esempio n. 11
0
        private void SetCmb()
        {
            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = " SELECT ifnull(sido,'00') as DCODE ,ifnull(sido_nm,'전국') as DNAME  FROM domabiz.place_master GROUP BY sido, sido_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.cmbTAREA1, codeArray);
            }

            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 = '00043'   ";

                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.cmbOrderDate, codeArray);
            }
            cmbOrderDate.EditValue = "1";
        }
Esempio n. 12
0
        private void SetCmb()
        {
            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT sido as DCODE ,sido_nm as DNAME  FROM domabiz.place_master GROUP BY sido, sido_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.cmbTAREA1, codeArray);
            }
        }
Esempio n. 13
0
        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 = '00031'   ";

                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";
        }
Esempio n. 14
0
        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();
            }
        }
Esempio n. 15
0
        public void Open1()
        {
            try
            {
                using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
                {
                    con.Query = " select idx, before_url, after_url, sort,  story_id from  domalife.tb_gsite_story  ";
                    DataSet    ds        = con.selectQueryDataSet();
                    DataRow[]  dr        = ds.Tables[0].Select();
                    CodeData[] codeArray = new CodeData[dr.Length];

                    for (int i = 0; i < dr.Length; i++)
                    {
                        if (dr[i]["idx"].ToString() == "1")
                        {
                            txtIdx1.EditValue         = dr[i]["idx"].ToString();
                            txtBChoice_Url1.EditValue = dr[i]["before_url"].ToString();
                            txtAChoice_Url1.EditValue = dr[i]["after_url"].ToString();
                            txtStory_id1.EditValue    = dr[i]["story_id"].ToString();
                            txtSort1.EditValue        = dr[i]["sort"].ToString();
                            picBChoice_img1.LoadAsync(txtBChoice_Url1.EditValue.ToString());
                            picAChoice_img1.LoadAsync(txtAChoice_Url1.EditValue.ToString());
                        }
                        if (dr[i]["idx"].ToString() == "2")
                        {
                            txtIdx2.EditValue         = dr[i]["idx"].ToString();
                            txtBChoice_Url2.EditValue = dr[i]["before_url"].ToString();
                            txtAChoice_Url2.EditValue = dr[i]["after_url"].ToString();
                            txtStory_id2.EditValue    = dr[i]["story_id"].ToString();
                            txtSort2.EditValue        = dr[i]["sort"].ToString();
                            picBChoice_img2.LoadAsync(txtBChoice_Url2.EditValue.ToString());
                            picAChoice_img2.LoadAsync(txtAChoice_Url2.EditValue.ToString());
                        }
                        if (dr[i]["idx"].ToString() == "3")
                        {
                            txtIdx3.EditValue         = dr[i]["idx"].ToString();
                            txtBChoice_Url3.EditValue = dr[i]["before_url"].ToString();
                            txtAChoice_Url3.EditValue = dr[i]["after_url"].ToString();
                            txtStory_id3.EditValue    = dr[i]["story_id"].ToString();
                            txtSort3.EditValue        = dr[i]["sort"].ToString();
                            picBChoice_img3.LoadAsync(txtBChoice_Url3.EditValue.ToString());
                            picAChoice_img3.LoadAsync(txtAChoice_Url3.EditValue.ToString());
                        }
                        if (dr[i]["idx"].ToString() == "4")
                        {
                            txtIdx4.EditValue         = dr[i]["idx"].ToString();
                            txtBChoice_Url4.EditValue = dr[i]["before_url"].ToString();
                            txtAChoice_Url4.EditValue = dr[i]["after_url"].ToString();
                            txtStory_id4.EditValue    = dr[i]["story_id"].ToString();
                            txtSort4.EditValue        = dr[i]["sort"].ToString();
                            picBChoice_img4.LoadAsync(txtBChoice_Url4.EditValue.ToString());
                            picAChoice_img4.LoadAsync(txtAChoice_Url4.EditValue.ToString());
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageAgent.MessageShow(MessageType.Error, ex.ToString());
            }
            Cursor.Current = Cursors.Default;
        }
Esempio n. 16
0
        private void SetCmb()
        {
            // 공급자구분

            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT count(*) as DCODE, place1  as DNAME  FROM  domabiz.beauty_shop group by place1 ";

                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.cmbPlace1, codeArray);
            }

            using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                con.Query = "SELECT count(*) as DCODE, place1  as DNAME  FROM  domabiz.beauty_shop group by place1 ";

                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.cmbPlace1_1, codeArray);
            }


            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 = '00014'  ";

                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.cmbShopType, codeArray);
            }

            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 = '00014'  ";

                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.cmbShop_Type, codeArray);
            }
        }