public string aMenuMemberDB(string pDbnm, string pSiteCd, string pMenuCd, string pTopMenuCd, string pSubMenuCd, string pMenuNm, string pUsingFlag, string pSortNo, string pMemo, string pInputId, out string reMsg, out string reData)
{
string reCode = "N";
reData = "0";
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
int reCnt = bizMenu.aMenuMemberDB(pDbnm, pSiteCd, pMenuCd, pTopMenuCd, pSubMenuCd, pMenuNm, pUsingFlag, pSortNo, pMemo, pInputId);
if (reCnt > 0)
{
reMsg = "[검색 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[검색 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::aMenuMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
//SITE -> DBNM 가져오기
public string siteDbNm(string pSiteCd, out string reData, out string reMsg)
{
string reCode = "N";
string reVal = "";
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
try
{
reVal = bizMenu.siteDbNm(pSiteCd);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::siteDbNm (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString();
reCode = "N";
}
reData = reVal;
return(reCode);
}
public string mMenu(string pTopMenuCd, string pSubMenuCd, string pMenuCd, string pUsingFlag, string pSortNo, string pMenuPath, string pFileFolder, out string reMsg, out string reData)
{
string reCode = "N";
reData = "0";
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
int reCnt = bizMenu.mMenu(pTopMenuCd, pSubMenuCd, pMenuCd, pUsingFlag, pSortNo, pMenuPath, pFileFolder);
if (reCnt > 0)
{
reMsg = "[저장 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[저장 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::mMenu (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[저장 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
public string exMenu(string pMenuCd, string pTopMenuCd, string pSubMenuCd, out string reMsg, out string reData)
{
string reCode = "N";
reData = "0";
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
int reCnt = bizMenu.exMenu(pMenuCd, pTopMenuCd, pSubMenuCd);
if (reCnt > 0)
{
reMsg = "[검색 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[검색 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::exMenu (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
public string sSetAuthSiteMemberDB(string pDbnm, string pSiteCd, string pTopMenuCd, string pSubMenuCd, string pAuthCd, out List <DataSetAuthSiteMemberDB> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
try
{
ds = bizMenu.sSetAuthSiteMemberDB(pDbnm, pSiteCd, pTopMenuCd, pSubMenuCd, pAuthCd);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataSetAuthSiteMemberDB> data = new List <DataSetAuthSiteMemberDB>();
try
{
data = ListClass.ConvertDataTableToList <DataSetAuthSiteMemberDB>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::sSiteMainDB (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}
public string sMenuTopTreeView(out List <DataMenuTop> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
try
{
ds = bizMenu.sMenuTopTreeView();
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataMenuTop> data = new List <DataMenuTop>();
try
{
data = ListClass.ConvertDataTableToList <DataMenuTop>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::sMenuTopTreeView (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}
public string 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, out string reMsg, out string reData)
{
string reCode = "N";
reData = "0";
BizMenuMainDB bizMenu = null;
try
{
bizMenu = new BizMenuMainDB();
int reCnt = bizMenu.aSetAuthSiteMemberDB(pDbnm, pSiteCd, pMenuCd, pAuthCd, pViewFlag, pNewFlag, pModifyFlag, pDelFlag, pReportFlag, pPrintFlag, pDownloadFlag, pInputId);
int reCntLog = bizMenu.aSetAuthSiteMemberDBLog(pDbnm, pSiteCd, pMenuCd, pAuthCd, pViewFlag, pNewFlag, pModifyFlag, pDelFlag, pReportFlag, pPrintFlag, pDownloadFlag, pInputId);
if (reCnt > 0)
{
reMsg = "[검색 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[검색 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsMenuMainDB.svc (Function)::aMenuMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
