/// <summary>
/// 传感器匹配结果添加函数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.SensorsMatched model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Insert into SensorsMatched(");
strSql.Append("TaskID,SensorID,PLATFORM_ID,MatchingTime)");
strSql.Append(" Value(");
strSql.Append("@in_TaskID,@in_SensorID,@in_PLATFORM_ID,@in_MatchingTime)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TaskID", SqlDbType.Decimal),
new SqlParameter("@in_SensorID", SqlDbType.Decimal),
new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal),
new SqlParameter("@in_MatchingTime", SqlDbType.DateTime)
};
cmdParms[0].Value = model.TaskID;
cmdParms[1].Value = model.SensorID;
cmdParms[2].Value = model.PLATFORM_ID;
cmdParms[3].Value = model.MatchingTime;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));//执行Sql语句
}
/// <summary>
/// 根据任务ID修改传感器匹配结果数据表中的一条记录
/// </summary>
/// <param name="model"></param>传感器匹配结果实体类的实例
/// <returns></returns>返回值为修改的记录数
public int Update(Model.SensorsMatched model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update SensorsMatched set ");
strSql.Append("SensorID=@in_SensorID,");
strSql.Append("PLATFORM_ID=@in_PLATFORM_ID,");
strSql.Append("MatchingTime=@in_MatchingTime,");
strSql.Append(" where TaskID=@in_TaskID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TaskID", SqlDbType.Decimal),
new SqlParameter("@in_SensorID", SqlDbType.Decimal),
new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal),
new SqlParameter("@in_MatchingTime", SqlDbType.DateTime)
};
cmdParms[0].Value = model.TaskID;
cmdParms[1].Value = model.SensorID;
cmdParms[2].Value = model.PLATFORM_ID;
cmdParms[3].Value = model.MatchingTime;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
