/// <summary>
 /// 关闭数据库
 /// </summary>
 public static void CloseDatabase()
 {
     _database.Close();
 }
        /// <summary>
        /// 以巷道为单位
        /// </summary>
        /// <returns></returns>
        public static List <PreWarningResultQuery> QueryHoldWarningResult()
        {
            List <PreWarningResultQuery> lastedResultEnts = new
                                                            List <PreWarningResultQuery>();

            // 一条巷道,有的记录有两条“突出和超限”,有的记录只有一条“”,我们把两条的合并成一条
            Dictionary <int, PreWarningResultQuery> container = new
                                                                Dictionary <int, PreWarningResultQuery>();

            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT * FROM ");
            strSql.Append(PreWarningResultViewDbConstNames.VIEW_NAME);
            strSql.Append(" WHERE ");
            strSql.Append(PreWarningResultDBConstNames.WARNING_RESULT);
            strSql.Append(" < 2 ");
            strSql.Append(" AND " +
                          PreWarningResultDBConstNames.HANDLE_STATUS + " < 3"); // 3指 HANDLED
            strSql.Append(" AND WARNING_STATUS = 1");
            //strSql.Append(" AND " + PreWarningResultDBConstNames.TUNNEL_ID + " IN (SELECT TUNNEL_ID FROM " + PreWarningResultViewDbConstNames.VIEW_NAME + " WHERE WARNING_STATUS=1)");
            //strSql.Append(" ORDER BY ");
            //strSql.Append(PreWarningResultDBConstNames.TUNNEL_ID);
            ManageDataBase database = new
                                      ManageDataBase(DATABASE_TYPE.WarningManagementDB);

            database.Open();
            DataTable dt =
                database.ReturnDSNotOpenAndClose(strSql.ToString()).Tables[0];

            if (dt != null)
            {
                int rowCount = dt.Rows.Count;
                PreWarningResultQuery ent = null;
                for (int i = 0; i < rowCount; i++)
                {
                    //巷道名称
                    int tunelId = LibCommon.Const.INVALID_ID;
                    int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.TUNNEL_ID].ToString(),
                                 out tunelId);
                    if (container.ContainsKey(tunelId))
                    {
                        ent = container[tunelId];// 巷道已经存在字典中
                    }
                    else
                    {
                        ent = new PreWarningResultQuery();
                        container.Add(tunelId, ent);
                    }

                    ent.TunnelID = tunelId;

                    Tunnel entTunnel = Tunnel.Find(tunelId);
                    ent.TunelName =
                        entTunnel.WorkingFace.WorkingfaceTypeEnum ==
                        WorkingfaceTypeEnum.JJ ?
                        entTunnel.WorkingFace.WorkingFaceName :
                        entTunnel.WorkingFace.WorkingFaceName + " - " +
                        entTunnel.TunnelName;
                    //ent.TunelName = GetTunelNameByTunelID(tunelId);
                    ent.WorkingfaceId =
                        dt.Rows[i][WorkingFaceDbConstNames.WORKINGFACE_ID] !=
                        DBNull.Value ?
                        Convert.ToInt32(dt.Rows[i][WorkingFaceDbConstNames.WORKINGFACE_ID])
                        : 0;
                    ent.WorkingfaceName =
                        dt.Rows[i][WorkingFaceDbConstNames.WORKINGFACE_ID] !=
                        DBNull.Value ?
                        dt.Rows[i][WorkingFaceDbConstNames.WORKINGFACE_NAME].ToString()
                        : "";

                    //日期
                    ent.DateTime =
                        Convert.ToDateTime(dt.Rows[i][PreWarningResultDBConstNames.DATA_TIME]);
                    //班次
                    ent.Date_Shift =
                        dt.Rows[i][PreWarningResultDBConstNames.DATE_SHIFT].ToString();



                    int defultValue = (int)WarningResult.NULL;
                    //突出预警结果
                    if
                    ((WarningType)(dt.Rows[i][PreWarningResultDBConstNames.WARNING_TYPE])
                     == WarningType.OUTBURST)
                    {
                        WarningResultEnt outburstEnt = new
                                                       WarningResultEnt();
                        outburstEnt.ID =
                            dt.Rows[i][PreWarningResultDBConstNames.ID].ToString();

                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.WARNING_RESULT].ToString(),
                                     out defultValue);
                        outburstEnt.WarningResult = defultValue;

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GAS].ToString(),
                                     out defultValue);
                        if (defultValue < outburstEnt.Gas)
                        {
                            outburstEnt.Gas
                                = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.COAL].ToString(),
                                     out defultValue);
                        if (defultValue < outburstEnt.Coal)
                        {
                            outburstEnt.Coal = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GEOLOGY].ToString(),
                                     out defultValue);
                        if (defultValue < outburstEnt.Geology)
                        {
                            outburstEnt.Geology = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.VENTILATION].ToString(),
                                     out defultValue);
                        if (defultValue < outburstEnt.Ventilation)
                        {
                            outburstEnt.Ventilation = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.MANAGEMENT].ToString(),
                                     out defultValue);
                        if (defultValue < outburstEnt.Management)
                        {
                            outburstEnt.Management = defultValue;
                        }

                        // 处理状态
                        outburstEnt.HandleStatus =
                            Convert.ToInt32(dt.Rows[i][PreWarningResultDBConstNames.HANDLE_STATUS]);

                        ent.OutBrustWarningResult = outburstEnt;
                    }
                    //超限预警结果
                    if
                    ((WarningType)(dt.Rows[i][PreWarningResultDBConstNames.WARNING_TYPE])
                     == WarningType.OVER_LIMIT)
                    {
                        WarningResultEnt overlimitEnt = new
                                                        WarningResultEnt();
                        overlimitEnt.ID =
                            dt.Rows[i][PreWarningResultDBConstNames.ID].ToString();

                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.WARNING_RESULT].ToString(),
                                     out defultValue);
                        if (defultValue < overlimitEnt.WarningResult)
                        {
                            overlimitEnt.WarningResult = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GAS].ToString(),
                                     out defultValue);
                        if (defultValue < overlimitEnt.Gas)
                        {
                            overlimitEnt.Gas = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.COAL].ToString(),
                                     out defultValue);
                        if (defultValue < overlimitEnt.Coal)
                        {
                            overlimitEnt.Coal = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GEOLOGY].ToString(),
                                     out defultValue);
                        if (defultValue < overlimitEnt.Geology)
                        {
                            overlimitEnt.Geology = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.VENTILATION].ToString(),
                                     out defultValue);
                        if (defultValue < overlimitEnt.Ventilation)
                        {
                            overlimitEnt.Ventilation = defultValue;
                        }

                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.MANAGEMENT].ToString(),
                                     out defultValue);
                        if (defultValue < overlimitEnt.Management)
                        {
                            overlimitEnt.Management = defultValue;
                        }

                        overlimitEnt.HandleStatus =
                            Convert.ToInt32(dt.Rows[i][PreWarningResultDBConstNames.HANDLE_STATUS].ToString());

                        ent.OverLimitWarningResult = overlimitEnt;
                    }
                    if (ent.OutBrustWarningResult == null &&
                        ent.OverLimitWarningResult == null)
                    {
                        continue;
                    }
                    //lastedResultEnts.Add(ent);
                }

                foreach (KeyValuePair <int, PreWarningResultQuery> kvp in
                         container)
                {
                    lastedResultEnts.Add(kvp.Value);
                }
            }
            database.Close();
            return(lastedResultEnts);
        }
예제 #3
0
        QueryUnLiftedWarningResult()
        {
            List <PreWarningHistoryResultEnt> unliftedResultEnts = new
                                                                   List <PreWarningHistoryResultEnt>();
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT * FROM ");
            strSql.Append(PreWarningResultDBConstNames.TABLE_NAME);
            strSql.Append(" WHERE ");
            strSql.Append(" [clearWarning]=0 AND ([warning_result]=0 OR [warning_result]=1)");
            strSql.Append(" ORDER BY ");
            strSql.Append(PreWarningResultDBConstNames.TUNNEL_ID);

            ManageDataBase database = new
                                      ManageDataBase(DATABASE_TYPE.WarningManagementDB);

            database.Open();
            DataTable dt =
                database.ReturnDSNotOpenAndClose(strSql.ToString()).Tables[0];

            if (dt != null)
            {
                int rowCount = dt.Rows.Count;
                PreWarningHistoryResultEnt ent = null;
                for (int i = 0; i < rowCount; i++)
                {
                    ent = new PreWarningHistoryResultEnt();
                    //巷道名称
                    int tunelId = LibCommon.Const.INVALID_ID;
                    int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.TUNNEL_ID].ToString(),
                                 out tunelId);
                    ent.TunnelID = tunelId;
                    //ent.TunelName = GetTunelNameByTunelID(database, tunelId);
                    //日期
                    //ent.DateTime = time;
                    //班次
                    ent.Date_Shift =
                        dt.Rows[i][PreWarningResultDBConstNames.DATE_SHIFT].ToString();

                    int defultValue = (int)WarningResult.NULL;
                    //突出预警结果
                    if
                    (dt.Rows[i][PreWarningResultDBConstNames.WARNING_TYPE].ToString()
                     == LibCommon.WarningType.OUTBURST.ToString())
                    {
                        WarningResultEnt outburstEnt = new
                                                       WarningResultEnt();
                        outburstEnt.ID =
                            dt.Rows[i][PreWarningResultDBConstNames.ID].ToString();

                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.WARNING_RESULT].ToString(),
                                     out defultValue);
                        outburstEnt.WarningResult = defultValue;
                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GAS].ToString(),
                                     out defultValue);
                        outburstEnt.Gas = defultValue;
                        defultValue     = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.COAL].ToString(),
                                     out defultValue);
                        outburstEnt.Coal = defultValue;
                        defultValue      = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GEOLOGY].ToString(),
                                     out defultValue);
                        outburstEnt.Geology = defultValue;
                        defultValue         = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.VENTILATION].ToString(),
                                     out defultValue);
                        outburstEnt.Ventilation = defultValue;
                        defultValue             = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.MANAGEMENT].ToString(),
                                     out defultValue);
                        outburstEnt.Management = defultValue;

                        ent.OutBrustWarningResult = outburstEnt;
                    }
                    //超限预警结果
                    if
                    (dt.Rows[i][PreWarningResultDBConstNames.WARNING_TYPE].ToString()
                     == LibCommon.WarningType.OVER_LIMIT.ToString())
                    {
                        WarningResultEnt overlimitEnt = new
                                                        WarningResultEnt();
                        overlimitEnt.ID =
                            dt.Rows[i][PreWarningResultDBConstNames.ID].ToString();

                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.WARNING_RESULT].ToString(),
                                     out defultValue);
                        overlimitEnt.WarningResult = defultValue;
                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GAS].ToString(),
                                     out defultValue);
                        overlimitEnt.Gas = defultValue;
                        defultValue      = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.COAL].ToString(),
                                     out defultValue);
                        overlimitEnt.Coal = defultValue;
                        defultValue       = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.GEOLOGY].ToString(),
                                     out defultValue);
                        overlimitEnt.Geology = defultValue;
                        defultValue          = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.VENTILATION].ToString(),
                                     out defultValue);
                        overlimitEnt.Ventilation = defultValue;
                        defultValue = (int)WarningResult.NULL;
                        int.TryParse(dt.Rows[i][PreWarningResultDBConstNames.MANAGEMENT].ToString(),
                                     out defultValue);
                        overlimitEnt.Management = defultValue;

                        ent.OverLimitWarningResult = overlimitEnt;
                    }

                    unliftedResultEnts.Add(ent);
                }
            }
            database.Close();
            return(unliftedResultEnts);
        }