//SELECT public DataSet sLaborSearch(string pSiteCd, string pBlockCcd, string pConstCcd, string pCoCd, string pTeamCd, string pSearchCondition, string pSearchTxt, string pTtypeScd, string pTcode, string pValue) { DataSet ds = null; DbLaborSearch db = null; try { string dbCon_IP = WebConfigurationManager.ConnectionStrings["ConnectionStr_IP"].ConnectionString; string dbCon_DB = WebConfigurationManager.ConnectionStrings["ConnectionStr_DB"].ConnectionString; string dbCon_USER = WebConfigurationManager.ConnectionStrings["ConnectionStr_USER"].ConnectionString; db = new DbLaborSearch(dbCon_IP, dbCon_DB, dbCon_USER, "0"); ds = db.sLaborSearch(pSiteCd, pBlockCcd, pConstCcd, pCoCd, pTeamCd, pSearchCondition, pSearchTxt, pTtypeScd, pTcode, pValue); } catch (Exception ex) { logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborSearch (Detail):: " + " pSiteCd=['" + pSiteCd + "'], pBlockCcd=[" + pBlockCcd + "], pConstCcd=[" + pConstCcd + "], pCoCd=[" + pCoCd + "],pTeamCd=[" + pTeamCd + "],pSearchCondition=[" + pSearchCondition + "]," + "pSearchTxt=[" + pSearchTxt + "],pTtypeScd=[" + pTtypeScd + "],pTcode=[" + pTcode + "], pValue=[" + pValue + "]", "Error"); logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLaborSearch (Detail)::" + "\r\n" + ex.ToString(), "Error"); } finally { if (db != null) { db.DisConnect(); } } return(ds); }