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;
gridView1.OptionsView.ShowFooter = true;
rbShowType.EditValue = "N";
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();
}
dtS_DATE.EditValue = DateTime.Now;
dtE_DATE.EditValue = DateTime.Now;
SetCmb();
}
private void SetCmb()
{
// 공급자구분
using (MySQLConn con = new MySQLConn(ConstantLib.BasicConn_Real))
{
con.Query = "SELECT ifnull(s_idx,'') as DCODE ,s_company_name as DNAME FROM domaadmin.tb_sellers_info where s_status = 'Y' order by s_company_name ";
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);
}
dtS_DATE.EditValue = DateTime.Now;
dtE_DATE.EditValue = DateTime.Now;
cmbSellers.EditValue = "1";
}
private void efwSimpleButton7_Click(object sender, EventArgs e)
{
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
SqlCommand cmd = new SqlCommand();
sql.Query = "SELECT idx as idx, u_name as u_name FROM domalife.member_master " +
"ORDER BY u_name";
DataSet ds = sql.selectQueryDataSet();
gridControl1.DataSource = ds.Tables[0];
}
}
void timer_tick(object sender, EventArgs e)
{
string sChkType = string.Empty;
using (MySQLConn sql = new MySQLConn(ConstantLib.BasicConn_Real))
{
sql.Query = "SELECT count(*) as Cht FROM domamall.tb_am_product_orders t1 " +
"WHERE date_format(o_date, '%Y%m%d') = '20191030' and " +
" o_type = 'O' ";
DataSet ds = sql.selectQueryDataSet();
sChkType = sql.selectQueryForSingleValue();
}
if (sChkType != "0" && sChkType != null)
{
popup1 = new frmSCM03_Pop02();
popup1.pChkType = "1";
Time_Stop();
popup1.ShowDialog();
Time_Start();
}
}
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 = '00007' ";
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.cmbS_DIVISION, 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 = '00009' ";
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.cmbS_STATUS, 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 = '00008' ";
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.cmbS_TAX_TYPE, 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 = '00006' ";
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.cmbS_BANK, codeArray);
}
}