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