public DataSet sMenuTreeView(string pTopMenuCd, string pSubMenuCd)
{
DataSet ds = null;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sMenuTreeView(pTopMenuCd, pSubMenuCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::sMenuTreeView (Detail)::pTopMenuCd=[" + pTopMenuCd + "]" +
", pSubMenuCd=[" + pSubMenuCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::sMenuTreeView (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public DataSet sSetAuthSiteMemberDB(string pDbnm, string pSiteCd, string pTopMenuCd, string pSubMenuCd, string pAuthCd)
{
DataSet ds = null;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
ds = db.sSetAuthSiteMemberDB(pDbnm, pSiteCd, pTopMenuCd, pSubMenuCd, pAuthCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::sSetAuthSiteMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(ds);
}
public int aSetAuthSiteMemberDB(string pDbnm, string pSiteCd, string pMenuCd, string pAuthCd, string pViewFlag, string pNewFlag, string pModifyFlag, string pDelFlag, string pReportFlag, string pPrintFlag, string pDownloadFlag, string pInputId)
{
int reCnt = 0;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.aSetAuthSiteMemberDB(pDbnm, pSiteCd, pMenuCd, pAuthCd, pViewFlag, pNewFlag, pModifyFlag, pDelFlag, pReportFlag, pPrintFlag, pDownloadFlag, pInputId);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::aSetAuthSiteMemberDB (Detail)::, pDbnm=['" + pDbnm + "'], pSiteCd=[" + pSiteCd + "]" +
", pMenuCd=['" + pMenuCd + "'], pAuthCd=['" + pAuthCd + "'], pViewFlag=[" + pViewFlag + "]" +
", pNewFlag=[" + pNewFlag + "], pModifyFlag =[" + pModifyFlag + "], pDelFlag=[" + pDelFlag + "], pReportFlag=[" + pReportFlag + "]" +
", pPrintFlag =[" + pPrintFlag + "], pDownloadFlag =[" + pDownloadFlag + "], pInputId =[" + pInputId + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::aSetAuthSiteMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int aMenuMemberDB(string pDbnm, string pSiteCd, string pMenuCd, string pTopMenuCd, string pSubMenuCd, string pMenuNm, string pUsingFlag, string pSortNo, string pMemo, string pInputId)
{
int reCnt = 0;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.aMenuMemberDB(pDbnm, pSiteCd, pMenuCd, pTopMenuCd, pSubMenuCd, pMenuNm, pUsingFlag, pSortNo, pMemo, pInputId);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::aMenuMemberDB (Detail)::, pDbnm=[" + pDbnm + "], pSiteCd=[" + pSiteCd + "]," +
" pMenuCd=[" + pMenuCd + "], pTopMenuCd=[" + pTopMenuCd + "], pSubMenuCd=[" + pSubMenuCd + "]" +
", pMenuNm=[" + pMenuNm + "], pUsingFlag =[" + pUsingFlag + "], pSortNo=[" + pSortNo + "], pMemo=[" + pMemo + "]," +
" pInputId =[" + pInputId + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::aMenuMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public string siteDbNm(string pSiteCd)
{
string reVal = "";
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
reVal = db.siteDbNm(pSiteCd);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::siteDbNm (Detail)::pSiteCd=[" + pSiteCd + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::siteDbNm (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reVal);
}
public int mMenu(string pTopMenuCd, string pSubMenuCd, string pMenuCd, string pUsingFlag, string pSortNo, string pMenuPath, string pFileFolder)
{
int reCnt = 0;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.mMenu(pTopMenuCd, pSubMenuCd, pMenuCd, pUsingFlag, pSortNo, pMenuPath, pFileFolder);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::mMenu (Detail):: pTopMenuCd=[" + pTopMenuCd + "]" +
", pSubMenuCd=[" + pSubMenuCd + "], pMenuCd=[" + pMenuCd + "], pUsingFlag=[" + pUsingFlag + "]" +
", pSortNo=[" + pSortNo + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::mMenu (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int mMenuTop(string pTopMenuCd, string pUsingFlag, string pSortNo)
{
int reCnt = 0;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.mMenuTop(pTopMenuCd, pUsingFlag, pSortNo);
//mMenuTop(string TOP_MENU_CD, string USING_FLAG, string SORT_NO)
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::mMenuTop (Detail)::, pTopMenuCd=[" + pTopMenuCd + "]," +
" pUsingFlag=[" + pUsingFlag + "], pSortNo=[" + pSortNo + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::mMenuTop (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}
public int exMenuSub(string pSubMenuCd, string pTopMenuCd, string pSubMenuNm)
{
int reCnt = 0;
DbMenuMainDB db = null;
try
{
string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString;
string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString;
string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString;
db = new DbMenuMainDB(dbCon_IP, dbCon_DB, dbCon_USER);
reCnt = db.exMenuSub(pSubMenuCd, pTopMenuCd, pSubMenuNm);
}
catch (Exception ex)
{
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::exMenuSub (Detail)::pSubMenuCd=[" + pSubMenuCd + "]" +
", pTopMenuCd=[" + pTopMenuCd + "], pSubMenuNm=[" + pSubMenuNm + "]", "Error");
_logs.SaveLog("[error] (page)::BizMenuMainDB.cs (Function)::exMenuSub (Detail)::" + "\r\n" + ex.ToString(), "Error");
}
finally
{
if (db != null)
{
db.DisConnect();
}
}
return(reCnt);
}