//CONST CMB BOX
public DataSet constCmb(string SITE_CD)
{
string dbNm = sDbNm(SITE_CD);
string con = "[PLUS-" + dbNm + "].dbo.";
string sql = "" +
" SELECT VALUE, TEXT " +
" FROM( " +
" SELECT CCODE AS VALUE, CCODE_NM AS TEXT, SORT_NO " +
" FROM " + con + "View_Code_Comn " +
" WHERE CCODE_GRP = 'Const' " +
" AND SITE_CD = " + SITE_CD + " AND USING_FLAG = 1 " +
" UNION ALL " +
" SELECT '0' AS VALUE, '미선택' AS TEXT, '99999999' AS SORT_NO " +
" ) X " +
" ORDER BY SORT_NO, TEXT ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
//COMPANY CMB BOX
public DataSet sLaborCompanyList(string SITE_CD, int CO_CD)
{
string dbNm = sDbNm(SITE_CD);
string con = "[PLUS-" + dbNm + "].dbo.";
string sql = "" +
" SELECT CO_CD AS VALUE, CO_NM AS TEXT, SORT_NO " +
" FROM " + con + "View_Company " +
" WHERE SITE_CD = " + SITE_CD +
" AND USING_FLAG = 1 " +
" UNION ALL " +
" SELECT '0' AS VALUE, '전체' AS TEXT, '99999999' AS SORT_NO " +
" ORDER BY SORT_NO, TEXT ";
//if (MYCOM_FLAG == 1)
// sql += " AND VALUE = " + CO_CD + " ";
//sql += "" +
// " ORDER BY SORT_NO, TEXT ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
//Dev Type CMB BOX
public DataSet devTypeCmb()
{
string sql = "" +
" SELECT SCODE, SCODE_NM " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_SYS " +
" WHERE SCODE_GRP = 'DevType' AND USING_FLAG = 1 ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sMemberMainDB()
{
string sql = "" +
" SELECT MEMCO_CD, MEMCO_NM " +
" FROM TM00_MEMCO " +
" WHERE USING_FLAG =1 ";
sql += "" +
" ORDER BY SORT_NO, MEMCO_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
//COMBO BOX -> SITE_CD, SITE_NM
public DataSet sSiteMainDB(string MEMCO_CD)
{
string sql = "" +
" SELECT SITE_CD, SITE_NM " +
" FROM [PLUS_MAIN].dbo.TM00_SITE " +
" WHERE USING_FLAG = 1 AND MEMCO_CD = " + MEMCO_CD + " ";
sql += "" +
" ORDER BY SORT_NO, SITE_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sSiteMenu(string DBNM, string SITE_CD)
{
//string dbNm = siteDbNm(SITE_CD);
string con = "[PLUS-" + DBNM + "].dbo.";
string sql = "" +
" SELECT A.TOP_MENU_CD, B.TOP_MENU_NM " +
" FROM " + con + "T00_MENU_SITE A " +
" INNER JOIN [PLUS_MAIN].dbo.TM00_MENU_TOP B ON A.TOP_MENU_CD = B.TOP_MENU_CD " +
" WHERE A.SITE_CD = " + SITE_CD + " AND A.TOP_MENU_CD != 1 " +
" GROUP BY A.TOP_MENU_CD, B.TOP_MENU_NM, B.SORT_NO " +
" ORDER BY B.SORT_NO ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sMenuTopTreeView()
{
string sql = "" +
" SELECT TOP_MENU_CD, TOP_MENU_NM, APP_FLAG, USING_FLAG, SORT_NO " +
" FROM [PLUS_MAIN].dbo.TM00_MENU_TOP ";
sql += "" +
" ORDER BY SORT_NO, TOP_MENU_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sSysCodeGrp(string SCODE_GRP)
{
string sql = "" +
" SELECT SCODE_GRP, SCODE_GRP_NM, USING_FLAG, SORT_NO, MEMO " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_SYS_GRP ";
if (SCODE_GRP != "")
{
sql += " WHERE SCODE_GRP = '" + SCODE_GRP + "'";
}
sql += "" +
" ORDER BY SORT_NO, SCODE_GRP_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
//SELECT (USING FLAG CHECKED)
public DataSet sMember_UsingFlag(string USING_FLAG)
{
string sql = "" + " " +
"SELECT MEMCO_CD, MEMCO_NM, USING_FLAG, SORT_NO, MEMO " +
" FROM [PLUS_MAIN].dbo.TM00_MEMCO ";
if (USING_FLAG != "")
{
sql += " WHERE USING_FLAG = " + USING_FLAG + "";
}
sql += "" +
" ORDER BY SORT_NO, MEMCO_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sSysCodeGrp()
{
string sql = "" +
" SELECT SCODE_GRP, SCODE_NM" +
" FROM[PLUS_MAIN].dbo.TM00_CODE_SYS_GRP ";
//object reVal = null;
DataSet ds = null;
if (sqlHelper != null)
{
ds = sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sComnCodeGrp()
{
string sql = "" +
" SELECT CCODE_GRP, CCODE_GRP_NM, USING_FLAG, SORT_NO, MEMO " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_COMN_GRP ";
sql += "" +
" ORDER BY SORT_NO, CCODE_GRP_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
//COMPANY CMB BOX
public DataSet companyCmb(string SITE_CD)
{
string dbNm = sDbNm(SITE_CD);
string sql = "" +
" SELECT CO_CD, CO_NM " +
" FROM [PLUS-ELDIGM].dbo.View_Company " +
" WHERE SITE_CD = " + SITE_CD + " ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sDbSysAuthMainDB(string USING_FLAG)
{
string sql = "" +
" SELECT AUTH_CD, AUTH_NM, MYBLOCK_FLAG, MYCON_FLAG, MYCOM_FLAG, MYTEAM_FLAG, USING_FLAG, AUTH_LEVEL, MEMO " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_AUTH ";
if (USING_FLAG != "")
{
sql += " WHERE USING_FLAG = '" + USING_FLAG + "' ";
}
sql += "" +
" ORDER BY AUTH_LEVEL, AUTH_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sComnCodeGrp(string CCODE_GRP)
{
string sql = "" +
" SELECT CCODE_GRP, CCODE_NM, USING_FLAG, SORT_NO, MEMO " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_COMN_GRP ";
if (CCODE_GRP != "")
{
sql += " WHERE CCODE_GRP = '" + CCODE_GRP + "'";
}
sql += "" +
" ORDER BY SORT_NO, CCODE_NM ";
DataSet ds = null;
if (sqlHelper != null)
{
ds = sqlHelper.ExecuteFill(sql);
}
return(ds);
}
public DataSet sSysCode()
{
string sql = "" +
" SELECT SCODE, SCODE_NM " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_SYS " +
" WHERE SCODE_GRP = 'LabInfoType' AND USING_FLAG = 1 ";
sql += "" +
" ORDER BY SORT_NO, SCODE_NM ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}
// ** LaborSearch Part Start **
//TOTAL FLAG
public DataSet sMyFlags(string SITE_CD, string AUTH_CD)
{
string dbNm = "";
dbNm = sDbNm(SITE_CD);
string con = "[PLUS-" + dbNm + "].dbo.";
string sql = "" +
" SELECT MYBLOCK_FLAG, MYCON_FLAG, MYCOM_FLAG, MYTEAM_FLAG " +
" FROM " + con + "T00_CODE_AUTH A " +
" INNER JOIN " + con + "T00_CODE_AUTH_SITE B ON A.AUTH_CD = B.AUTH_CD " +
" WHERE B.AUTH_CD = '" + AUTH_CD + "' AND B.SITE_CD = " + SITE_CD + " ";
DataSet ds = null;
if (_sqlHelper != null)
{
ds = _sqlHelper.ExecuteFill(sql);
}
return(ds);
}