Пример #1
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 = '00034'  ";

                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 = "01";
        }
Пример #2
0
        private void Open1()
        {
            using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                SqlCommand cmd = new SqlCommand();
                sql.Query = " select t1.idx as idx, t1.sub_code as sub_code, t1.image_path as image_path, t1.is_best as is_best, t1.use_type as use_type, " +
                            "        t1.reg_date as reg_date, t1.remark as remark, t1.file_name as file_name " +
                            "   from domalife.tb_story_masters_images t1  " +
                            "   where t1.category_no =  '" + txtCategory_No.EditValue + "'  " +
                            "  order by t1.idx ";

                DataSet ds = sql.selectQueryDataSet();
                gridControl2.DataSource = ds.Tables[0];
            }
        }
Пример #3
0
        //추천요금제
        public void Open5()
        {
            using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
            {
                SqlCommand cmd = new SqlCommand();
                sql.Query = " select t1.idx as idx, t1.category_no as category_no, (select name from domalife.story_category t2 where t2.code = t1.category_no ) as category_name, t1.img_url as ImageURL, " +
                            "        t1.show_type as show_type, t1.img_link as img_link, t1.remark as remark, t1.link_type  as link_type, t1.show_turn as show_turn, t1.telecom_type as telecom_type  " +
                            "   from domaadmin.tb_story_banner t1  " +
                            "   where category_no = 800 and " +
                            "         telecom_type =  '" + rbUse_type.EditValue + "'  " +
                            "  order by t1.idx ";

                DataSet ds = sql.selectQueryDataSet();
                gridControl1.DataSource = ds.Tables[0];
            }
        }
Пример #4
0
        private void efwGridControl2_Click(object sender, EventArgs e)
        {
            txtQuery.Focus();
            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,  t2.customer_num as customer_num " +
                            "   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 + "'  " +
                            "  order by t1.story_id, t2.order_key ";

                DataSet ds = sql.selectQueryDataSet();
                gridControl1.DataSource = ds.Tables[0];
            }
        }
Пример #5
0
        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 = '00079'  order by code_id";

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

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

                repositoryItemLookUpEdit2.EndUpdate();
            }

            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 = '00079' 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.cmbImage_Choice, codeArray);
            }
            cmbImage_Choice.EditValue = "00";
        }