//SELECT THE LOWEST AUTH_CD AT SITE public string sLabAuth(string pSiteCd) { string reVal = ""; 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"); reVal = db.sLabAuth(pSiteCd); } catch (Exception ex) { logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLabAuth (Detail):: " + " pSiteCd=['" + pSiteCd + "']", "Error"); logs.SaveLog("[error] (page)::BizLaborSearch.cs (Function)::sLabAuth (Detail)::" + "\r\n" + ex.ToString(), "Error"); } finally { if (db != null) { db.DisConnect(); } } return(reVal); }