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);
}
}