/// <summary> /// 新增超限报警记录数据 /// </summary> /// <param name="item">超限报警记录实体</param> /// <returns>新增的数据行数</returns> public int AddOverLimitRecord(KPI_OverLimitRecordEntity item) { int Result = 0; string SqlText = @"Insert KPI_OverLimitRecord (AlarmID,TagID,AlarmStartTime,AlarmEndTime, Duration,AlarmValue,StandardValue,Offset,AlarmType,Period,Shift,UnitID) Values (@AlarmID,@TagID,@AlarmStartTime,@AlarmEndTime,@Duration,@AlarmValue, @StandardValue,@Offset,@AlarmType,@Period,@Shift,@UnitID) " ; IDbDataParameter AlarmIDParam = new SqlParameter("@AlarmID", item.AlarmID); IDbDataParameter TagIDParam = new SqlParameter("@TagID", item.TagID); IDbDataParameter AlarmStartTimeParam = new SqlParameter("@AlarmStartTime", item.AlarmStartTime); IDbDataParameter AlarmEndTimeParam = new SqlParameter("@AlarmEndTime", DBNull.Value); IDbDataParameter DurationParam = new SqlParameter("@Duration", DBNull.Value); IDbDataParameter AlarmValueParam = new SqlParameter("@AlarmValue", item.AlarmValue); IDbDataParameter StandardValueParam = new SqlParameter("@StandardValue", item.StandardValue); IDbDataParameter OffsetParam = new SqlParameter("@Offset", item.Offset); IDbDataParameter AlarmTypeParam = new SqlParameter("@AlarmType", item.AlarmType); IDbDataParameter PeriodParam = new SqlParameter("@Period", item.Period); IDbDataParameter ShiftParam = new SqlParameter("@Shift", item.Shift); IDbDataParameter UnitIDParam = new SqlParameter("@UnitID", item.UnitID); //RelaInterface DB = DBAccess.GetRelation(); try { Result = m_DB.ExecuteNonQuery(SqlText, AlarmIDParam, TagIDParam, AlarmStartTimeParam, AlarmEndTimeParam, DurationParam, AlarmValueParam, StandardValueParam, OffsetParam, AlarmTypeParam, PeriodParam, ShiftParam, UnitIDParam); } catch (Exception ex) { throw ex; } return(Result); }
/// <summary> /// 删除日常管理考核得分数据 /// </summary> /// <param name="ManagementScore">日常管理考核得分实体</param> /// <returns>删除的数据行数</returns> public int DeleteManagementScore(ManagementScoreEntity ManagementScore) { string SqlText = @"DELETE FROM KPI_ManagementScore WHERE PersonID=@PersonID AND CheckDate=@CheckDate AND TagID=@TagID "; return(m_DataAccess.ExecuteNonQuery(CommandType.Text, SqlText, GetParameters(ManagementScore))); }
/// <summary> /// 删除安全指标与测点对应关系表数据 /// </summary> /// <param name="SAID">安全指标与测点对应关系表实体</param> /// <returns>删除的数据行数</returns> public int DeleteSATagMap(String SAID) { int Result = 0; string SqlText = @"DELETE FROM KPI_SATagMap WHERE SAID=@SAID "; SqlParameter[] parames = new SqlParameter[] { new SqlParameter("@SAID", SqlDbType.VarChar) }; parames[0].Value = SAID; Result = m_DB.ExecuteNonQuery(SqlText, parames); return(Result); }
/// <summary> /// 删除运行人员配置数据 /// </summary> /// <param name="KPI_Person">运行人员配置实体</param> /// <returns>删除的数据行数</returns> public int DeletePerson(KPI_PersonEntity person) { int Result = 0; string SqlText = @"DELETE FROM KPI_Person WHERE PersonID=@PersonID "; IDbDataParameter[] parames = new SqlParameter[] { new SqlParameter("@PersonID", DbType.String) }; parames[0].Value = person.PersonID; Result = m_DB.ExecuteNonQuery(SqlText, parames); return(Result); }
/// <summary> /// 计算各值奖金与得分、个人奖金与得分 /// </summary> public void CalcScoreAndBonus() { try { m_DB.ExecuteNonQuery("Proc_CalcScoreAndBonus", CommandType.StoredProcedure, null); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除数据 /// </summary> /// <param name="SATagValue">实体</param> /// <returns>删除的数据行数</returns> public int DeleteKPI_SATagValue(KPI_SATagValueEntity SATagValue) { int Result = 0; string SqlText = @"DELETE FROM KPI_SATagValue WHERE SAID=@SAID AND CalcDateTime=@CalcDateTime AND Shift=@Shift " ; IDbDataParameter[] parames = new SqlParameter[] { new SqlParameter("@SAID", DbType.String), new SqlParameter("@CalcDateTime", DbType.DateTime), new SqlParameter("@Shift", DbType.String) }; parames[0].Value = SATagValue.SAID; parames[1].Value = SATagValue.CalcDateTime; parames[2].Value = SATagValue.Shift; Result = DataBase.ExecuteNonQuery(SqlText, parames); return(Result); }
public void SaveMonitorDuration(MonitorDurationEntity MonitorDuration) { if (MonitorDuration.Duration <= 0) { return; } IDbDataParameter[] parames = new SqlParameter[] { new SqlParameter("@UnitID", DbType.String), new SqlParameter("@Shift", DbType.String), new SqlParameter("@CheckDate", DbType.Date), new SqlParameter("@Duration", DbType.Decimal) }; parames[0].Value = MonitorDuration.UnitID; parames[1].Value = MonitorDuration.Shift; parames[2].Value = MonitorDuration.CheckDate; parames[3].Value = MonitorDuration.Duration; String SqlText = @"IF NOT EXISTS(SELECT * FROM KPI_MonitorDuration WHERE UnitID=@UnitID AND CheckDate=@CheckDate AND Shift=@Shift) BEGIN INSERT INTO KPI_MonitorDuration(UnitID,Shift,CheckDate,Duration)VALUES(@UnitID,@Shift,@CheckDate,@Duration) END" ; m_DB.ExecuteNonQuery(SqlText, parames); }
public int DeleteInputTag(InputTagEntity InputTag) { string SqlText = @"DELETE FROM KPI_InputTag WHERE InputID=@InputID "; return(m_DataAccess.ExecuteNonQuery(SqlText, GetParameters(InputTag))); }