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";
}
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];
}
}
//추천요금제
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];
}
}
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];
}
}
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";
}
