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); }
GetSortedPreWarningData(int iStartIndex, int iEndIndex) { List <PreWarningHistoryResultEnt> ents = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM ("); strSql.Append(" SELECT ROW_NUMBER() OVER(ORDER BY " + PreWarningResultDBConstNames.ID + ") AS rowid, *"); strSql.Append(" FROM " + PreWarningResultDBConstNames.TABLE_NAME_TEMP + ") AS TB"); strSql.Append(" WHERE rowid >= " + iStartIndex); strSql.Append(" AND rowid <= " + iEndIndex); strSql.Append(" AND [clearWarning]=0 AND ([warning_result]=0 OR [warning_result]=1)"); ManageDataBase database = new ManageDataBase(DATABASE_TYPE.WarningManagementDB); DataTable dt = database.ReturnDS(strSql.ToString()).Tables[0]; if (dt != null) { if (dt.Rows.Count > 0) { ents = new List <PreWarningHistoryResultEnt>(); int rowCount = dt.Rows.Count; PreWarningHistoryResultEnt ent = null; for (int i = 0; i < rowCount; i++) { ent = new PreWarningHistoryResultEnt(); //巷道名称 ent.TunelName = dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.TUNNEL_NAME].ToString().TrimEnd(); //巷道ID ent.TunnelID = (int)(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.TUNNEL_ID]); //日期 ent.DateTime = Convert.ToDateTime(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.DATA_TIME]); //班次 ent.Date_Shift = dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.DATE_SHIFT].ToString(); int defultValue = (int)WarningResult.NULL; //超限预警详细信息 int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OVER_LIMIT].ToString(), out defultValue); ent.OverLimitWarningResult.WarningResult = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OVER_LIMIT_GAS].ToString(), out defultValue); ent.OverLimitWarningResult.Gas = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OVER_LIMIT_COAL].ToString(), out defultValue); ent.OverLimitWarningResult.Coal = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OVER_LIMIT_GEOLOGY].ToString(), out defultValue); ent.OverLimitWarningResult.Geology = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OVER_LIMIT_VENTILATION].ToString(), out defultValue); ent.OverLimitWarningResult.Ventilation = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OVER_LIMIT_MANAGEMENT].ToString(), out defultValue); ent.OverLimitWarningResult.Management = defultValue; //突出预警详细信息 int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OUTBURST].ToString(), out defultValue); ent.OutBrustWarningResult.WarningResult = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OUTBURST_GAS].ToString(), out defultValue); ent.OutBrustWarningResult.Gas = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OUTBURST_COAL].ToString(), out defultValue); ent.OutBrustWarningResult.Coal = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OUTBURST_GEOLOGY].ToString(), out defultValue); ent.OutBrustWarningResult.Geology = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OUTBURST_VENTILATION].ToString(), out defultValue); ent.OutBrustWarningResult.Ventilation = defultValue; defultValue = (int)WarningResult.NULL; int.TryParse(dt.Rows[i][LibBusiness.PreWarningHistroyResultQueryDBConstNames.OUTBURST_MANAGEMENT].ToString(), out defultValue); ent.OutBrustWarningResult.Management = defultValue; ents.Add(ent); } } } return(ents); }