public void ClearMySQLCnn() { if (mysqlCnn != null) { MySqlConnectPoolHelper.getPool().closeConnection(mysqlCnn); mysqlCnn = null; } }
public void InitQueryParams(DataQueryParamObject DataQueryParam, DataStoreTableInfo DataStoreItem) { int res = 0; QueryResultBase QueryResultObject = new QueryResultBase(); dataQueryParam = DataQueryParam; dataStoreItem = DataStoreItem; mysqlCnn = MySqlConnectPoolHelper.getPool().getConnection(); String DbName = $"`[iot]-[{DataQueryParam.CompanyCode}]`"; res = mysqlCnn.SelectDB(DbName); }
static void Main(string[] args) { MySqlConnectPoolHelper.getPool().InitMySqlConnectPool(); UserManagerHelper.InitUserManager(); CompanyManagerHelper.Initialize(); CompanyManagerHelper.StartAlarmStoreService(); CompanyManagerHelper.StartDataStoreService(); FileServerHelper.Initialize(); //CompanyManagerHelper.StartDeviceStatusThread(); //跨域配置 // config.EnableCors(new EnableCorsAttribute("*", "*", "*")); //var _client = RedisManager.GetClient(); //routeTemplate: "api/{controller}/{id}", LoggerManager.Log.Info("服务启动开始...\n"); try { Assembly.Load("IotCloudService.IotWebServerWebApi, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"); HttpSelfHostConfiguration configuration = new HttpSelfHostConfiguration("http://127.0.0.1:8081"); using (HttpSelfHostServer httpServer = new HttpSelfHostServer(configuration)) { httpServer.Configuration.EnableCors(); httpServer.Configuration.MapHttpAttributeRoutes(); httpServer.Configuration.Filters.Add(new ApiSecurityFilter()); httpServer.Configuration.Routes.MapHttpRoute( name: "DefaultApi", routeTemplate: "api/{controller}/{action}/{id}", defaults: new { id = RouteParameter.Optional }); httpServer.OpenAsync().Wait(); Console.WriteLine("Press Enter to quit."); Console.ReadLine(); } } catch (Exception ex) { LoggerManager.Log.Info(ex.Message); LoggerManager.Log.Info("出现异常,服务退出!\n"); Console.ReadLine(); } }
static void Main(string[] args) { MySqlConnectPoolHelper.getPool().InitMySqlConnectPool(); CompanyManagerHelper.Initialize(); }