public string sDbNm(string MEMCO_CD)
{
string sql = "" +
" SELECT ISNULL(MAX(DB_NM), '') DB_NM " +
" FROM [PLUS_MAIN].dbo.TM00_MEMCO " +
" WHERE MEMCO_CD = " + MEMCO_CD + " ";
object reVal = null;
if (_sqlHelper != null)
{
reVal = _sqlHelper.ExecuteScalar(sql);
}
return(reVal.ToString());
}
public int exMenuTop(string TOP_MENU_CD, string TOP_MENU_NM)
{
string sql = "" +
" SELECT COUNT(*) CNT " +
" FROM [PLUS_MAIN].dbo.TM00_MENU_TOP " +
" WHERE TOP_MENU_CD = '" + TOP_MENU_CD + "' AND TOP_MENU_NM = '" + TOP_MENU_NM + "'";
object reObj = 0;
if (_sqlHelper != null)
{
reObj = _sqlHelper.ExecuteScalar(sql);
}
return(Convert.ToInt16(reObj));
}
public int exSysCodeGrp(string SCODE_GRP)
{
string sql = "" +
" SELECT COUNT(*) CNT " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_SYS_GRP " +
" WHERE SCODE_GRP = '" + SCODE_GRP + "' ";
object reObj = 0;
if (_sqlHelper != null)
{
reObj = _sqlHelper.ExecuteScalar(sql);
}
return(Convert.ToInt16(reObj));
}
public string sDbNm(string SITE_CD)
{
string sql = "" +
" SELECT ISNULL(MAX(B.DB_NM), '') DB_NM " +
" FROM [PLUS_MAIN].dbo.TM00_SITE A " +
" INNER JOIN [PLUS_MAIN].dbo.TM00_MEMCO B ON A.MEMCO_CD = B.MEMCO_CD " +
" WHERE SITE_CD =" + SITE_CD + " ";
object reVal = null;
if (_sqlHelper != null)
{
reVal = _sqlHelper.ExecuteScalar(sql);
}
return(reVal.ToString());
}
public int exSysAuthMainDB(string AUTH_CD)
{
string sql = "" +
" SELECT COUNT(*) CNT " +
" FROM [PLUS_MAIN].dbo.TM00_CODE_AUTH " +
" WHERE AUTH_CD = '" + AUTH_CD + "' ";
object reObj = 0;
if (_sqlHelper != null)
{
reObj = _sqlHelper.ExecuteScalar(sql);
}
return(Convert.ToInt16(reObj));
}
//DUPLICATE CHECK
public int exMember(string MEMCO_CD, string MEMCO_NM)
{
string sql = "" +
" SELECT COUNT(*) CNT " +
" FROM [PLUS_MAIN].dbo.TM00_MEMCO " +
" WHERE MEMCO_CD = '" + MEMCO_CD + "' AND MEMCO_NM = '" + MEMCO_NM + "' ";
object reObj = 0;
if (_sqlHelper != null)
{
reObj = _sqlHelper.ExecuteScalar(sql);
}
return(Convert.ToInt16(reObj));
}