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);
}