private void setCmb()
{
try
{
// Dictionary<string, string> myRecord;
string strQueruy = @" SELECT
T1.DCODE, T1.DNAME
FROM
(
SELECT '' DCODE, N'전체' DNAME
UNION ALL
SELECT CODE DCODE
,CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'MEMBER' " + @") T1 ";
CodeAgent.SetLegacyCode(cmbO_TYPE, strQueruy);
cmbO_TYPE.EditValue = "";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void setCmb()
{
try
{
//사업장콤보
string strQueruy = @"SELECT
BIZCD DCODE
,BIZCD_NM DNAME
FROM TBL_BIZCD
WHERE COMPANYCD = '" + txtCOMPANYCD.EditValue + "' " +
" ORDER BY BIZCD ASC";
string strQueruy2 = @" SELECT
T1.DCODE, T1.DNAME
FROM
(
SELECT '' DCODE, N'전체' DNAME
UNION ALL
SELECT BIZCD DCODE
,BIZCD_NM DNAME
FROM TBL_BIZCD
WHERE COMPANYCD = '" + txtCOMPANYCD.EditValue + "'" + @") T1
ORDER BY T1.DCODE ASC";
CodeAgent.SetLegacyCode(cmbBIZCD, strQueruy);
CodeAgent.SetLegacyCode(cmbBIZCDQ, strQueruy2);
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
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());
}
}
private void setCmb()
{
try
{
//사업장콤보
string strQueruy = @"SELECT
BIZCD DCODE
,BIZCD_NM DNAME
FROM TBL_BIZCD
WHERE COMPANYCD = '" + COMPANYCD + "' " +
" ORDER BY BIZCD ASC";
CodeAgent.SetLegacyCode(cmbBIZCD, strQueruy);
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void setCmb()
{
try
{
//사업장콤보
string strQueruy = @"SELECT
CODE DCODE
,CODE_NM DNAME
FROM ETCCODE
WHERE SYS_CODE = '03' AND GRP_CODE='MEMBERQ_GBN1' AND CODE <> 'X'" +
" ORDER BY RANKORDER ASC";
CodeAgent.SetLegacyCode(cmbQ1, strQueruy);
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void SetCmb()
{
try
{
//대분류
string strQueruy3 = @"SELECT
CODE DCODE
,CODE_NM DNAME
FROM ETCCODE
WHERE GRP_CODE = 'MEMBERQ_GBN3' and CODE in ('2','3')
ORDER BY GRP_CODE ASC";
CodeAgent.SetLegacyCode(cmbMember_Type, strQueruy3);
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void setCmb()
{
try
{
//대분류
string strQueruy = @"SELECT
CODE DCODE
,CODE_NM DNAME
FROM ETCCODE
WHERE GRP_CODE = 'TEL_SEARCH1' and CODE != 'X'
ORDER BY GRP_CODE ASC";
CodeAgent.SetLegacyCode(cmbSearch_Type, strQueruy);
cmbSearch_Type.EditValue = "1";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void setCmb()
{
try
{
Dictionary <string, string> myRecord;
int i = 0;
//대분류
string strQueruy = @"SELECT
CODE DCODE
,CODE_NM DNAME
FROM dbo.ETCCODE
WHERE GRP_CODE = 'DELIVERYTYPE' " +
" ORDER BY RANKORDER";
CodeAgent.SetLegacyCode(cmbO_TYPE, strQueruy);
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
private void setCmb()
{
try
{
Dictionary <string, string> myRecord;
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(cmbSearch, strQueruy2);
cmbSearch.EditValue = "1";
}
catch (Exception ex)
{
MessageAgent.MessageShow(MessageType.Error, ex.ToString());
}
}
//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";
}
