public string sSysSysCode(out List <DataCodeGroup> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizSysSysCode bizSysSysCode = null; try { bizSysSysCode = new BizSysSysCode(); ds = bizSysSysCode.sSysCodeGrp(); reCode = "Y"; try { ds = bizSysSysCode.sSysCodeGrp(); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러 - BizSystem 연결 실패] :: " + ex.ToString(); reCode = "N"; } List <DataCodeGroup> data = new List <DataCodeGroup>(); try { data = ListClass.ConvertDataTableToList <DataCodeGroup>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WebSvcSystem.svc (Function)::sSiteMenu (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; 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); }
public string co_Cmb(string pSiteCd, out List <DataComCombo> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizInOut bizInOut = null; try { bizInOut = new BizInOut(); try { ds = bizInOut.co_Cmb(pSiteCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataComCombo> data = new List <DataComCombo>(); try { data = ListClass.ConvertDataTableToList <DataComCombo>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsInOut.svc (Function)::sLaborCompanyList (Detail)::co_Cmb " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
public string sInOutHistory(string pDbnm, string pSiteCd, string pDtp1, string pDtp2, string pCocd, out List <DataInOut> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizInOut bizInOut = null; try { bizInOut = new BizInOut(); try { ds = bizInOut.sInOutHistory(pDbnm, pSiteCd, pDtp1, pDtp2, pCocd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataInOut> data = new List <DataInOut>(); try { data = ListClass.ConvertDataTableToList <DataInOut>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsInOut.svc (Function)::sInOutHistory (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
//COTYPE CMB BOX public string cotype_Cmb(out List <DataCotypeCmb> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizCompany bizSys = null; try { bizSys = new BizCompany(); try { ds = bizSys.cotype_Cmb(); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataCotypeCmb> data = new List <DataCotypeCmb>(); try { data = ListClass.ConvertDataTableToList <DataCotypeCmb>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysCompanyTeam.svc (Function)::cotype_Cmb (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
//SELECT public string sTeam(string pSiteCd, string pCoCd, string pUsingFlag, string pTeamNm, out List <DataTeam> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizTeam bizSys = null; try { bizSys = new BizTeam(); try { ds = bizSys.sTeam(pSiteCd, pCoCd, pUsingFlag, pTeamNm); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataTeam> data = new List <DataTeam>(); try { data = ListClass.ConvertDataTableToList <DataTeam>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysCompanyTeam.svc (Function)::sTeam (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; 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); }
//SELECT : WHEN USER CLICK TTYPE_SCD public string sCodeTAuthTtype(string pTtypeScd, string pSiteCd, string pAuthCd, out List <DataCodeTAuthSelect> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizCodeT bizCodeT = null; try { bizCodeT = new BizCodeT(); try { ds = bizCodeT.sCodeTAuthTtype(pTtypeScd, pSiteCd, pAuthCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataCodeTAuthSelect> data = new List <DataCodeTAuthSelect>(); try { data = ListClass.ConvertDataTableToList <DataCodeTAuthSelect>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsCodeTMainDB.svc (Function)::sCodeTAuthTtype (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
//ADD INFO DATA public string sLaborAddInfoSub(string pSiteCd, string pTcode, out List <DataAddinfoCcodesub> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizLaborSearch bizSys = null; try { bizSys = new BizLaborSearch(); try { ds = bizSys.sLaborAddInfoSub(pSiteCd, pTcode); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataAddinfoCcodesub> data = new List <DataAddinfoCcodesub>(); try { data = ListClass.ConvertDataTableToList <DataAddinfoCcodesub>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::sLaborAddInfoSub (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); }
//SELECT public string sLaborSearch(string pSiteCd, string pBlockCcd, string pConstCcd, string pCoCd, string pTeamCd, string pSearchCondition, string pSearchTxt, string pTtypeScd, string pTcode, string pValue, out List <DataLaborSearch> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizLaborSearch bizSys = null; try { bizSys = new BizLaborSearch(); try { ds = bizSys.sLaborSearch(pSiteCd, pBlockCcd, pConstCcd, pCoCd, pTeamCd, pSearchCondition, pSearchTxt, pTtypeScd, pTcode, pValue); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataLaborSearch> data = new List <DataLaborSearch>(); try { data = ListClass.ConvertDataTableToList <DataLaborSearch>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::sDevice (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
//LAB INFO TYPE CMB public string sLabTcodeList(string pSiteCd, string pTgrpCcd, string pTtypeScd, string pLngCategory, string pAuthCd, out List <DataComComboStr> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizLaborSearch bizSys = null; try { bizSys = new BizLaborSearch(); try { ds = bizSys.sLabTcodeList(pSiteCd, pTgrpCcd, pTtypeScd, pLngCategory, pAuthCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataComComboStr> data = new List <DataComComboStr>(); try { data = ListClass.ConvertDataTableToList <DataComComboStr>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsWorkerLaborSearch.svc (Function)::sLabTcodeList (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
//SELECT public string sDevice(string pDbNm, string pSiteCd, out List <DataDevice> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizDevice bizSys = null; try { bizSys = new BizDevice(); try { ds = bizSys.sDevice(pDbNm, pSiteCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataDevice> data = new List <DataDevice>(); try { data = ListClass.ConvertDataTableToList <DataDevice>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsDevice.svc (Function)::sDevice (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
public string sComnSite(string pDbnm, string pSiteCd, string pCcodeGrp, string pUsingFlag, string pCcodeNm, out List <DataComecodeSite> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizComnCodeGrp bizComn = null; try { bizComn = new BizComnCodeGrp(); try { ds = bizComn.sComnSite(pDbnm, pSiteCd, pCcodeGrp, pUsingFlag, pCcodeNm); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataComecodeSite> data = new List <DataComecodeSite>(); try { data = ListClass.ConvertDataTableToList <DataComecodeSite>(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); }
//Select -> GridView1 public string sMember(string pMemcoCd, out List <DataMemberDB> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizMember bizSys = null; try { bizSys = new BizMember(); try { ds = bizSys.sMember(pMemcoCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataMemberDB> data = new List <DataMemberDB>(); try { data = ListClass.ConvertDataTableToList <DataMemberDB>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsMember.svc (Function)::sMember (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
public string sComnCodeGrpUsingFlag(out List <DataComnCodeGrp> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizComnCodeGrp bizComn = null; try { bizComn = new BizComnCodeGrp(); try { ds = bizComn.sComnCodeGrpUsingFlag(); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러] :: " + ex.ToString(); reCode = "N"; } List <DataComnCodeGrp> data = new List <DataComnCodeGrp>(); try { data = ListClass.ConvertDataTableToList <DataComnCodeGrp>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsSysCodeGrp.svc (Function)::sSysCodeGrp (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }
public string sSiteSubMenu1(string pDbNm, string pSiteCd, string pTopMenuCd, out List <DataSubMenu1> reList, out string reMsg) { string reCode = "N"; DataSet ds = null; BizMainHome bizHome = null; try { bizHome = new BizMainHome(); try { ds = bizHome.sSiteSubMenu1(pDbNm, pSiteCd, pTopMenuCd); reMsg = "[검색 성공]"; reCode = "Y"; } catch (Exception ex) { reMsg = "[검색 실패]" + ex.ToString(); reCode = "N"; } } catch (Exception ex) { reMsg = "[검색 에러 - BizMainHome 연결 실패] :: " + ex.ToString(); reCode = "N"; } List <DataSubMenu1> data = new List <DataSubMenu1>(); try { data = ListClass.ConvertDataTableToList <DataSubMenu1>(ds.Tables[0]); } catch (Exception ex) { logs.SaveLog("[error] (page)::WsMainHome.svc (Function)::sSiteSubMenu1 (Detail)::ConvertDataTableToList " + "\r\n" + ex.ToString(), "Error"); reMsg += "/[List 에러]" + ex.ToString(); reCode = "N"; } reList = data; return(reCode); }