//SysAuthSiteDB
//추가
public string aSysAuthSiteDB(string pDbnm, string pSiteCd, string sauthCd_val, string lab_aprv_Flag_val, string usingFlag_val, string sauthLevel_val, string memo_val, string pInputId, out string reMsg, out string reData)
{
string reCode = "N";
reData = "";
BizSysSiteDB bizSys = null;
try
{
bizSys = new BizSysSiteDB();
int reCnt = bizSys.aSysAuthSiteDB(pDbnm, pSiteCd, sauthCd_val, lab_aprv_Flag_val, usingFlag_val, sauthLevel_val, memo_val, pInputId);
if (reCnt > 0)
{
reMsg = "[저장 성공]";
reCode = "Y";
reData = reCnt.ToString();
}
else
{
reMsg = "[저장 성공] - 정보 없음";
reCode = "Y";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsSysAuthMemberDB.svc (Function)::aSysAuthSiteDB (Detail)::" + "\r\n" + ex.ToString(), "Error");
reMsg = "[저장 에러] :: " + ex.ToString();
reCode = "N";
}
return(reCode);
}
//SysAuthSiteDB
//SITE -> DBNM 가져오기
public string siteDbNm(string pSiteCd, out string reData, out string reMsg)
{
string reCode = "N";
string reVal = "";
BizSysSiteDB bizHome = null;
try
{
bizHome = new BizSysSiteDB();
try
{
reVal = bizHome.siteDbNm(pSiteCd);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsSysAuthMemberDB.svc (Function)::siteDbNm (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString();
reCode = "N";
}
reData = reVal;
return(reCode);
}
//SysAuthSiteDB
//SELECT
public string sSysAuthSiteDB(string pSiteCd, string pDbnm, string pUsingFlag, out List <DataSysAuthSiteDB> reList, out string reMsg)
{
string reCode = "N";
DataSet ds = null;
BizSysSiteDB bizSys = null;
try
{
bizSys = new BizSysSiteDB();
try
{
ds = bizSys.sSysAuthSiteDB(pSiteCd, pDbnm, pUsingFlag);
reMsg = "[검색 성공]";
reCode = "Y";
}
catch (Exception ex)
{
reMsg = "[검색 실패]" + ex.ToString();
reCode = "N";
}
}
catch (Exception ex)
{
reMsg = "[검색 에러] :: " + ex.ToString();
reCode = "N";
}
List <DataSysAuthSiteDB> data = new List <DataSysAuthSiteDB>();
try
{
data = ListClass.ConvertDataTableToList <DataSysAuthSiteDB>(ds.Tables[0]);
}
catch (Exception ex)
{
logs.SaveLog("[error] (page)::WsSysAuthMemberDB.svc (Function)::sSysAuthSiteDB (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error");
reMsg += "/[List 에러]" + ex.ToString();
reCode = "N";
}
reList = data;
return(reCode);
}