private void simpleButton1_Click(object sender, EventArgs e)
{
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 domabiz.table8 " +
// " where a.id = '" + txtSETCODE.EditValue + "' and " +
// " a.id = b.id " +
// " order by a.p_name, b.idx ";
con.Query = "select join_code from domabiz.table8 ";
ds = con.selectQueryDataSet();
}
ds.WriteXmlSchema("DataSet3.xsd");
// //파라매터전달(옵션)
frmDN20_Report report = new frmDN20_Report();
report.DataSource = ds.Tables[0];
report.ShowPreview();
}
private void Member_Chk(string p1)
{
Dictionary <string, string> myRecord;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
if (cmbSel.EditValue.ToString() == "0")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE u_name like '%" + p1 + "%' ";
}
else if (cmbSel.EditValue.ToString() == "1")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE u_nickname like '%" + p1 + "%' ";
}
else if (cmbSel.EditValue.ToString() == "2")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE login_id like '%" + p1 + "%' ";
}
else if (cmbSel.EditValue.ToString() == "3")
{
sql.Query = "SELECT login_id FROM domalife.member_master " +
"WHERE replace(u_cell_num, '-','') = '" + p1.Replace("-", "") + "'";
}
myRecord = sql.selectQueryForSingleRecord();
if (myRecord != null && myRecord.Count > 0)
{
lblID.Text = myRecord["login_id"].ToString();
}
}
}
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 = '00047' order by seq ";
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.cmbDonut_Type, codeArray);
}
cmbDonut_Type.EditValue = "0";
}
private void gridView1_DoubleClick(object sender, EventArgs e)
{
var gv = sender as GridView;
var rowIndex = gv.FocusedRowHandle;
var columnIndex = gv.FocusedColumn.VisibleIndex;
if (columnIndex == 5)
{
DataRow dr = this.efwGridControl1.GetSelectedRow(0);
int nId = Convert.ToInt32(txtId.EditValue.ToString());
if (nId != 0)
{
this.txtId.EditValue = dr["id"].ToString();
popup = new frmDN01_Pop01();
popup.Id = Convert.ToInt32(txtId.EditValue.ToString());
txtId.EditValue = "0";
popup.ShowDialog();
}
}
if (columnIndex == 32)
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
string sDelivery_Cd = txtDelivery_cd.EditValue.ToString();
sql.Query = "select d_address from domamall.tb_am_product_delivers " +
" where d_code = '" + sDelivery_Cd + "' ";
DataSet ds = sql.selectQueryDataSet();
string sDelivery_Query = sql.selectQueryForSingleValue() + txto_delivery_num.EditValue;
System.Diagnostics.Process.Start(sDelivery_Query);
}
}
}
private void Btn3_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txt_o_u_id.Text) || string.IsNullOrEmpty(this.txt_o_code.Text))
{
return;
}
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select ifnull(td_donut,0) " +
" from domamall.z_product_masters " +
" where p_id = " + Convert.ToInt32(txt_p_id.EditValue.ToString());
DataSet ds = sql.selectQueryDataSet();
int ncnt = Convert.ToInt32(sql.selectQueryForSingleValue());
if (ncnt > 0)
{
lblRes1.Text = ncnt.ToString();
}
else
{
lblRes1.Text = "0";
}
}
}
private void efwGridControl1_Click(object sender, EventArgs e)
{
DataRow dr = this.efwGridControl1.GetSelectedRow(0);
txtcancel.EditValue = "";
txtcontents_id.EditValue = "";
if (dr != null && dr["idx"].ToString() != "0")
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select ifnull(contents_id,'0') FROM domalife.donut_shooting_list where contents_id = '" + txtidx.EditValue + "' ";
DataSet ds = sql.selectQueryDataSet();
txtcontents_id.EditValue = sql.selectQueryForSingleValue().ToString();
}
if (txtcontents_id.Text.Length > 5 ^ txtr_login_id.EditValue.ToString() == "AdminLife")
{
txtcancel.EditValue = "반환 불가";
}
else
{
txtcancel.EditValue = "반환 가능";
}
}
}
private void EfwSimpleButton1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
//XtraReport report = new XtraReport();
//report.DataSource = CreateData();
//ReportPrintTool tool = new ReportPrintTool(report);
//tool.ShowPreview();
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 = 1781 and " +
" a.id = b.id " +
" order by a.p_name, b.idx ";
ds = con.selectQueryDataSet();
//ReportDataAgent.Instance().AddDataSource("DataSet1", ds.Tables[0]);
}
ds.WriteXmlSchema("DataSet1.xsd");
XtraReport1 report = new XtraReport1();
//report.parameter1.Value = 30;
//report.parameter1.Visible = false;
report.DataSource = ds.Tables[0];
report.ShowPreview();
}
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 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];
}
}
}
private int MonthDataCnt()
{
int nCnt = 0;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "SELECT count(*) FROM domamall.tb_ps_charge_month " +
"WHERE yymm = '" + dtS_DATE.EditValue3.Substring(0, 6) + "' and LENGTH(acc_date) > 0 and p_type = '01' ";
DataSet ds = sql.selectQueryDataSet();
nCnt = Convert.ToInt32(sql.selectQueryForSingleValue());
}
dtAcc_Date.EditValue = "";
string sAccDate;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "SELECT date_format(acc_date, '%Y-%m-%d') FROM domamall.tb_ps_charge_month " +
"WHERE yymm = '" + dtS_DATE.EditValue3.Substring(0, 6) + "' and LENGTH(acc_date) > 0 and p_type = '01' group by acc_date ";
DataSet ds = sql.selectQueryDataSet();
sAccDate = sql.selectQueryForSingleValue();
}
dtAcc_Date.EditValue = sAccDate;
return(nCnt);
}
public override void FrmLoadEvent()
{
base.FrmLoadEvent();
DevExpress.Utils.AppearanceObject.DefaultFont = new System.Drawing.Font("맑은고딕", 9);
this.IsMenuVw = true;
this.IsSearch = true;
this.IsNewMode = false;
this.IsSave = true;
this.IsDelete = false;
this.IsCancel = false;
this.IsPrint = false;
this.IsExcel = false;
dtS_DATE.EditValue = DateTime.Now;
dtE_DATE.EditValue = DateTime.Now;
dtOut_Date.EditValue = DateTime.Now;
rbCompany.EditValue = "1";
rbo_type.EditValue = "O";
//그리드 컬럼에 체크박스 레포지토리아이템 추가
gridView1.OptionsView.ShowFooter = true;
gridView3.OptionsView.ShowFooter = true;
gridView3.Columns["tot_qty"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView3.Columns["tot_qty"].SummaryItem.FieldName = "tot_qty";
gridView3.Columns["tot_qty"].SummaryItem.DisplayFormat = "{0}";
gridView5.OptionsView.ShowFooter = true;
gridView5.Columns["tot_qty"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView5.Columns["tot_qty"].SummaryItem.FieldName = "tot_qty";
gridView5.Columns["tot_qty"].SummaryItem.DisplayFormat = "{0}";
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();
}
gridView4.OptionsView.ShowFooter = true;
this.efwGridControl4.BindControlSet(
new ColumnControlSet("p_code", txtP_Code)
);
this.efwGridControl4.Click += efwGridControl4_Click;
SetCmb();
}
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();
}
}
}
}
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 = 00042 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];
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbO_Sub_Company, 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 = 00041 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];
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbO_Company, 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 = 00042 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];
for (int i = 0; i < dr.Length; i++)
{
codeArray[i] = new CodeData(dr[i]["DCODE"].ToString(), dr[i]["DNAME"].ToString());
}
CodeAgent.MakeCodeControl(this.cmbO_Sub_Company1, codeArray);
}
}
private int MonthDataCnt()
{
int nCnt = 0;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "SELECT count(*) FROM domamall.tb_ps_charge_month " +
"WHERE yymm = '" + dtS_DATE.EditValue3.Substring(0, 6) + "' and LENGTH(acc_date) > 0 and p_type = '02' ";
DataSet ds = sql.selectQueryDataSet();
nCnt = Convert.ToInt32(sql.selectQueryForSingleValue());
}
return(nCnt);
}
private DataSet StoryOpen2(string s_o_code, string story_cd)
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = " select t1.o_code, t1.user_nickname, t1.user_name, t1.login_id, t1.is_write, t1.story_id, DATE_FORMAT(t1.write_date,'%Y-%m-%d %H:%i:%S') as write_date, t1.user_id, " +
" t1.money_type, t1.money, money_fix " +
" FROM domalife.story_donut_banks t1 " +
" WHERE t1.contents_type = '" + story_cd + "'" +
" AND t1.o_code = '" + s_o_code + "'" +
" Order By t1.reg_date DESC ";
DataSet ds = sql.selectQueryDataSet();
return(ds);
}
}
private void OpenRel1(string uid)
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = " select t3.u_nickname as 닉네임, t3.u_name as 이름, t3.login_id as ID, t3.u_chef_level as 등급, t3.u_id U_ID, t3.is_biz " +
" FROM domalife.member_master t1 " +
" left join domalife.member_relations t2 on t2.recv_id = t1.u_id and t2.is_use = 'Y' " +
" left join domalife.member_master t3 on t3.u_id = t2.send_id " +
" WHERE t1.u_id = '" + uid + "'";
DataSet ds = sql.selectQueryDataSet();
efwGridControl3.DataBind(ds);
this.efwGridControl3.MyGridView.BestFitColumns();
}
}
private void StoryOpen1(string s_o_code, string story_cd)
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = " select o_code, user_nickname, user_name, login_id, is_write, story_id, DATE_FORMAT(write_date,'%Y-%m-%d %H:%i:%S') as write_date, user_id, " +
" money_type, money, money_fix " +
" FROM domalife.story_donut_banks t1 " +
" WHERE t1.contents_type = '" + story_cd + "'" +
" AND t1.o_code = '" + s_o_code + "'" +
" Order By reg_date DESC ";
DataSet ds = sql.selectQueryDataSet();
efwGridControl6.DataBind(ds);
}
}
private void EfwSimpleButton1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtStory_id.Text))
{
return;
}
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select contents " +
" from domalife.story_list " +
" where story_id = " + Convert.ToInt32(txtStory_id.EditValue);
DataSet ds = sql.selectQueryDataSet();
txtContents.EditValue = sql.selectQueryForSingleValue();
}
}
private DataSet StoryOpen4(string s_o_code, string story_cd)
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = " select t1.o_code, t1.user_nickname, t1.user_name, t1.login_id, t1.is_write, t1.story_id, DATE_FORMAT(t1.write_date,'%Y-%m-%d %H:%i:%S') as write_date, t1.user_id, " +
" t1.money_type, t1.money, money_fix, t2.donut_count as 적립 " +
" FROM domalife.story_donut_banks t1 " +
" LEFT JOIN domalife.donut_shooting_list t2 ON t1.story_id = t2.contents_id AND t2.donut_code = 6024 " +
" WHERE t1.contents_type = '" + story_cd + "'" +
" AND t1.o_code = (SELECT o_code FROM domamall.tb_gshop_orders WHERE product_o_code = '" + s_o_code + "')" +
" Order By t1.reg_date DESC ";
DataSet ds = sql.selectQueryDataSet();
return(ds);
}
}
private void SetCmb()
{
// 공급자구분
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " select '0' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(s_idx,'') as DCODE ,s_company_name as DNAME FROM domaadmin.tb_sellers_info where s_status = 'Y' ";
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.cmbSellers, codeArray);
}
cmbSellers.EditValue = "0";
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00025' and code_id in ('O','P','D') ";
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.cmbChange_type, codeArray);
}
cmbChange_type.EditValue = "P";
}
private void setCmb()
{
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = "select '0' as DCODE, '전체' as DNAMe union all SELECT category_no as DCODE ,story_name as DNAME FROM domaadmin.tb_story_info ORDER BY 1 ";
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.cmbStory, 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 = '00029' ";
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.cmbWriteYn, codeArray);
}
}
private void frmDN25_Load(object sender, EventArgs e)
{
// base.FrmLoadEvent();
DevExpress.Utils.AppearanceObject.DefaultFont = new System.Drawing.Font("맑은고딕", 9);
this.IsMenuVw = true;
this.IsSearch = true;
this.IsNewMode = true;
this.IsSave = false;
this.IsDelete = false;
this.IsCancel = false;
this.IsPrint = false;
this.IsExcel = false;
txtCoidNo.EditValue = UserInfo.instance().LOGIN_ID;
dtS_DATE.EditValue = DateTime.Now;
dtE_DATE.EditValue = DateTime.Now;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select code_id FROM domaadmin.tb_common_code where gcode_id = 00048 and code_nm = '" + UserInfo.instance().Name + "' ";
DataSet ds = sql.selectQueryDataSet();
txtCoidName.EditValue = sql.selectQueryForSingleValue().ToString();
}
gridView1.OptionsView.ShowFooter = true;
this.efwGridControl1.BindControlSet(
new ColumnControlSet("idx", txtidx)
, new ColumnControlSet("r_u_name", txtr_u_name)
, new ColumnControlSet("r_u_nickname", txtr_nickname)
, new ColumnControlSet("r_login_id", txtr_login_id)
, new ColumnControlSet("contents_id", txtcontents_id)
);
this.efwGridControl1.Click += efwGridControl1_Click;
SetCmb();
}
private void SwitchChk()
{
if (MonthDataCnt() > 0)
{
toggleSwitch1.IsOn = true;
}
else
{
toggleSwitch1.IsOn = false;
}
string sAccDate = "";
dtAcc_Date.EditValue = "";
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "SELECT date_format(acc_date, '%Y-%m-%d') FROM domamall.tb_ps_charge_month " +
"WHERE yymm = '" + dtS_DATE.EditValue3.Substring(0, 6) + "' and LENGTH(acc_date) > 0 and p_type = '02' group by acc_date ";
DataSet ds = sql.selectQueryDataSet();
sAccDate = sql.selectQueryForSingleValue();
}
dtAcc_Date.EditValue = sAccDate;
}
private void Search1()
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = " SELECT DATE_FORMAT(t1.create_date,'%Y-%m-%d %H:%i:%S') as 가입일, ";
sql.Query += " t1.gshop_name, t1.u_nickname, t1.login_id, t1.u_id, t100.u_chef_level as 등급, ";
sql.Query += " t1.ceo_name, ";
sql.Query += " t1.register_no, t1.tel_no, t1.hp_no, ";
sql.Query += " t1.md_u_id as 담당MD, t200.u_nickname as 담당MD닉네임, t200.u_name as 담당MD이름, t200.u_chef_level as 등급,";
sql.Query += " is_pay, is_approval ";
sql.Query += " FROM domabiz.gshop_master t1 ";
sql.Query += " left join domalife.member_master t100 on t100.u_id = t1.u_id ";
sql.Query += " left join domalife.member_master t200 on t200.u_id = t1.md_u_id ";
sql.Query += " WHERE t100.u_nickname like '%" + txt1.EditValue + "%' ";
sql.Query += " AND date_format(t1.create_date, '%Y%m%d') between '" + dtS_DATE.EditValue3 + "' AND '" + dtE_DATE.EditValue3 + "' ";
sql.Query += " AND experience_shop = 'Y' ";
sql.Query += " ORDER BY t1.create_date desc ";
DataSet ds = sql.selectQueryDataSet();
efwGridControl1.DataBind(ds);
}
}
private void Btn1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txt_o_u_id.Text) || string.IsNullOrEmpty(this.txt_o_code.Text))
{
return;
}
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "select count(*) " +
" from " +
" ( " +
" select a.id as src_idx " +
" , 221 as contents_type " +
" , b.send_id as user_id " +
" , c.u_name as user_name " +
" , c.u_nickname as user_nickname " +
" , c.login_id as login_id " +
" , a.o_code as o_code " +
" , (SELECT p_id FROM domamall.tb_am_product_order_datas where o_code = a.o_code limit 1) as p_id " +
" , b.recv_id as recomender_u_id " +
" , d.u_name as recomender_u_name " +
" , d.u_nickname as recomender_u_nickname " +
" , d.login_id as recomender_login_id " +
" , date_format(adddate(a.o_delivery_end_date, interval 72 hour), '%Y-%m-%d 23:59:59') as expiration_date " +
" , 'N' as is_write " +
" , a.o_date " +
" , a.o_deposit_confirm_date " +
" , (SELECT IFNULL(group_concat(t.pm_id), 0) FROM domamall.tb_promotion_products t left join domamall.tb_am_product_order_datas tt on t.p_id = tt.p_id where tt.o_code = a.o_code ) as pm_id " +
" , (select IF((select count(1) from domamall.tb_cate_product t left join domamall.tb_am_product_order_datas tt on t.p_id = tt.p_id where tt.o_code = a.o_code " +
" and (t.c_org_code like 'DC001#DC00115%' or t.c_org_code like 'DC001#DC00120%' or t.c_org_code like 'DC001#DC00121%' or t.c_org_code like 'DC001#DC00122%') ) > 0, 'Y', 'N')) as hangawi_yn " +
" , a.reco_possible_donut as reco_donut " +
" , (select chef_id from domamall.tb_doma_chef_relations where user_id = b.recv_id and chef_type = 'C' and is_use = 'Y' limit 1) as chef_id " +
" from domamall.tb_am_product_orders a " +
" left join domalife.member_relations b on a.o_u_id = b.recv_id " +
" left join domalife.member_master c on b.send_id = c.u_id " +
" inner join domalife.member_master d on a.o_u_id = d.u_id " +
" where a.o_type IN ('O','D','F') " +
" and a.o_deposit_confirm_date is not null " +
" and a.order_mall_type = 'PRIVATE' " +
" and a.o_u_id = '" + txt_o_u_id.EditValue + "' " +
" and a.o_code = '" + txt_o_code.EditValue + "' " +
" order by a.o_date desc " +
" ) pp " +
"where pp.pm_id not like '%3%' " +
" and pp.hangawi_yn = 'N' " +
" and pp.reco_donut > 0 " +
" and pp.user_id != pp.chef_id ";
DataSet ds = sql.selectQueryDataSet();
int ncnt = Convert.ToInt32(sql.selectQueryForSingleValue());
if (ncnt > 0)
{
lblRes1.Text = "생성!";
}
else
{
lblRes1.Text = "비생성!";
}
}
}
//private void efwGridControl1_Click(object sender, EventArgs e)
//{
//}
private void setCmb()
{
try
{
//Dictionary<string, string> myRecord;
string strQueruy1 = @" SELECT
T1.DCODE, T1.DNAME
FROM
( SELECT '' DCODE, N'전체' DNAME
UNION ALL
SELECT CODE DCODE, CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'MALL_TYPE' and Use_YN = 'Y' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbMALL_TYPE, strQueruy1);
cmbMALL_TYPE.EditValue = "";
string strQueruy2 = @" SELECT
T1.DCODE, T1.DNAME
FROM
( SELECT CODE DCODE, CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'ORDER_SEARCH' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbORDER_SEARCH, strQueruy2);
cmbORDER_SEARCH.EditValue = "1";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = " select '' as DCODE, '선택하세요' DNAME UNION all SELECT ifnull(code_id,'') as DCODE ,code_nm as DNAME FROM domaadmin.tb_common_code where gcode_id = '00025' ";
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.cmbChange_type, codeArray);
}
cmbChange_type.EditValue = "";
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 = '00032' ";
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 OpenOrder()
{
txtO_Code.EditValue = null;
txtO_Type.EditValue = null;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = " SELECT DATE_FORMAT(t1.o_date,'%Y-%m-%d %H:%i:%S') as o_date, ";
sql.Query += " t1.o_code, ";
sql.Query += " t200.o_mcode, ";
sql.Query += " t1.o_type, ";
sql.Query += " case t1.o_type when 'T' then '임시저장' ";
sql.Query += " when 'O' then '주문완료' ";
sql.Query += " when 'P' then '상품준비중' ";
sql.Query += " when 'D' then '배송중' ";
sql.Query += " when 'F' then '배송완료' ";
sql.Query += " when 'E' then '구매완료' ";
sql.Query += " when 'C' then '구매취소' ";
sql.Query += " when 'X' then '주문실패' ";
sql.Query += " when 'I' then '결제진행중' ";
sql.Query += " when 'Z' then '품절취소' ";
sql.Query += " when 'A' then '반품처리중' ";
sql.Query += " when 'B' then '반품완료' ";
sql.Query += " end as 주문상태, ";
sql.Query += " case t200.membership_buy when '1' then 'VIP(할인)가입' ";
sql.Query += " when '2' then 'GBIZ가입' ";
sql.Query += " when '3' then 'G멀티샵가입' ";
sql.Query += " when '4' then '뉴G멀티샵가입' ";
sql.Query += " end as 구분, ";
sql.Query += " t1.u_id, t1.u_name, t1.u_nickname, t1.login_id, t1.u_chef_level, ";
sql.Query += " t1.is_biz as G멀티샵, t1.g_prod as G제품, ";
sql.Query += " IFNULL(t100.experience_shop,'N') as 체험샵, ";
sql.Query += " t1.p_id, t1.option_id, ";
sql.Query += " t1.product_name, t1.option_name, t1.p_num as 수량, ";
sql.Query += " t200.o_total_cost as 총금액, t200.o_donut_d_cost as d머니, t200.o_donut_s_cost SD머니, t200.o_donut_g_cost as GD머니,";
sql.Query += " t200.o_delivery_cost as 배송료, t200.o_purchase_cost as 총결제금액,";
sql.Query += " case t200.o_pay_type when '1' then '카드' ";
sql.Query += " when '3' then '가상계좌' end as 결제구분,";
sql.Query += " domabiz.func_221_story_money_type(t1.g_prod) as PS축하, ";
sql.Query += " domabiz.func_221_story_money(t1.o_code) as PS축하금액 ";
sql.Query += " FROM domabiz.vw_order_product_info t1 ";
sql.Query += " left join domabiz.gshop_master t100 on t100.u_id = t1.u_id ";
sql.Query += " left join domamall.tb_am_product_orders t200 on t200.o_code = t1.o_code ";
sql.Query += " WHERE t1.login_id like '" + txtLogin_Id.EditValue + "%' ";
sql.Query += " AND date_format(t1.o_date, '%Y%m%d') between '" + dtS_DATE.EditValue3 + "' AND '" + dtE_DATE.EditValue3 + "' ";
if (chk1.Checked == true)
{
sql.Query += " AND IFNULL(t100.experience_shop,'N') = 'Y' ";
}
if (chk2.Checked == true)
{
sql.Query += " AND t1.o_type IN('O', 'P', 'D', 'E', 'F') ";
}
sql.Query += " ORDER BY t1.o_date desc ";
DataSet ds = sql.selectQueryDataSet();
efwGridControl1.DataBind(ds);
}
}
