Esempio n. 1
0
        public bool DBExists()
        {
            //mysql 3306
            string ip = "";

            try
            {
                var      DBPath  = System.Configuration.ConfigurationManager.ConnectionStrings["YZXDB"].ToString();
                string[] service = DBPath.Split(';');
                service = service[0].Split('=');
                ip      = service[1];
            }
            catch (Exception ex)
            {
                Helper.NLogHelper.log.Error("数据库连接字符串错误:" + ex.ToString());
                return(IsDBExists);
            }

            if (TestConnection(ip, 3306, 500))
            {
                using (var db = new YZXMySqlContext())
                {
                    IsDBExists = db.Database.Exists();
                }
            }
            if (!IsDBExists)
            {
                Helper.NLogHelper.log.Error("数据库未连接");
            }

            return(IsDBExists);
        }
Esempio n. 2
0
        /// <summary>
        /// 获取待检未分配车辆信息表.状态为0的
        /// </summary>
        /// <returns></returns>
        public List <WaitDetection> GetWaitDetections()
        {
            List <WaitDetection> result = new List <WaitDetection>();

            if (!IsDBExists)
            {
                return(result);
            }
            using (var db = new YZXMySqlContext())
            {
                try
                {
                    result = db.WaitDetection.Where(x => x.Status == 0).ToList();
                }
                catch (Exception ex)
                {
                    Helper.NLogHelper.log.Error(ex.Message);
                }
            }
            return(result);
        }