/// <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)));
}
