public string sDbNm(string pMemcoCd, out string reData, out string reMsg) { string reCode = "N"; string reVal = ""; BizSysAuthMemberDB bizHome = null; try { bizHome = new BizSysAuthMemberDB(); try { reVal = bizHome.sDbNm(pMemcoCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysAuthMemberDB.svc (Function)::sDbNm (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString(); reCode = "N"; } reData = reVal; return(reCode); }
//MAIN DB에 INSERT public string aSysAuthMainDB(string sauthCd_val, string sauthNm_val, string myblockFlag_val, string myconFlag_val, string mycomFlag_val, string myteamFlag_val, string usingFlag_val, string sauthLevel_val, string memo_val, string pInputId, out string reMsg, out string reData) { string reCode = "N"; reData = ""; BizSysAuthMemberDB bizSys = null; try { bizSys = new BizSysAuthMemberDB(); int reCnt = bizSys.aSysAuthMainDB(sauthCd_val, sauthNm_val, myblockFlag_val, myconFlag_val, mycomFlag_val, myteamFlag_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)::aSysAuthMainDB (Detail)::" + "\r\n" + ex.ToString(), "Error"); reMsg = "[저장 에러] :: " + ex.ToString(); reCode = "N"; } return(reCode); }
//중복 체크 public string exSysAuthMainDB(string sauthCd_val, string sauthNm_val, out string reMsg, out string reData) { string reCode = "N"; reData = "0"; BizSysAuthMemberDB bizSys = null; try { bizSys = new BizSysAuthMemberDB(); int reCnt = bizSys.exSysAuthMainDB(sauthCd_val, sauthNm_val); if (reCnt > 0) { reMsg = "[검색 성공]"; reCode = "Y"; reData = reCnt.ToString(); } else { reMsg = "[검색 성공] - 정보 없음"; reCode = "Y"; } } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysAuthMemberDB.svc (Function)::exSysAuthMemberDB (Detail)::" + "\r\n" + ex.ToString(), "Error"); reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } return(reCode); }
public string sMemberMainDB(out List <DataMemberMainDB> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizSysAuthMemberDB bizSys = null; try { bizSys = new BizSysAuthMemberDB(); try { ds = bizSys.sMemberMainDB(); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataMemberMainDB> data = new List <DataMemberMainDB>(); try { data = ListClass.ConvertDataTableToList <DataMemberMainDB>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysAuthMemberDB.svc (Function)::sMemberMainDB (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }