//수정 public string mSysAuthMainDB(string sauthCd_val, string sauthNm_val, string myblockFlag_val, string myconFlag_val, string mycomFlag_val, string myteamFlag_val, string usingFlag_val, string memo_val, out string reMsg, out string reData) { string reCode = "N"; reData = "0"; BizSysAuthMainDB bizSys = null; try { bizSys = new BizSysAuthMainDB(); int reCnt = bizSys.mSysAuthMainDB(sauthCd_val, sauthNm_val, myblockFlag_val, myconFlag_val, mycomFlag_val, myteamFlag_val, usingFlag_val, memo_val); if (reCnt > 0) { reMsg = "[저장 성공]"; reCode = "Y"; reData = reCnt.ToString(); } else { reMsg = "[저장 성공] - 정보 없음"; reCode = "Y"; } } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysAuthMainDB.svc (Function)::mSysAuthMainDB (Detail)::" + "\r\n" + ex.ToString(), "Error"); reMsg = "[저장 에러] :: " + ex.ToString(); reCode = "N"; } return(reCode); }
//중복 체크 public string exSysAuthMainDB(string sauthCd_val, out string reMsg, out string reData) { string reCode = "N"; reData = "0"; BizSysAuthMainDB bizSys = null; try { bizSys = new BizSysAuthMainDB(); int reCnt = bizSys.exSysAuthMainDB(sauthCd_val); if (reCnt > 0) { reMsg = "[검색 성공]"; reCode = "Y"; reData = reCnt.ToString(); } else { reMsg = "[검색 성공] - 정보 없음"; reCode = "Y"; } } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysAuthMainDB.svc (Function)::exSysAuthMainDB (Detail)::" + "\r\n" + ex.ToString(), "Error"); reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } return(reCode); }
public string sSysAuthMainDB(string pUsingFlag, out List <DataSysAuthMainDB> reList, out string reMsg) //셀렉트 { string reCode = "N"; DataSet ds = null; BizSysAuthMainDB bizSys = null; try { bizSys = new BizSysAuthMainDB(); try { ds = bizSys.sSysAuthMainDB(pUsingFlag); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataSysAuthMainDB> data = new List <DataSysAuthMainDB>(); try { data = ListClass.ConvertDataTableToList <DataSysAuthMainDB>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysAuthMainDB.svc (Function)::sSysAuthMainDB (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }