/// <summary>
/// 过滤时段列表
/// </summary>
/// <param name="objectId">对象Id,用逗号隔开</param>
/// <returns></returns>
public IEnumerable <FilterTimeEntity> GetList(string objectId)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_FilterTime where 1=1 ");
if (!string.IsNullOrEmpty(objectId))
{
sql.Append(" and ObjectId=@0", objectId);
}
sql.Append(" order by CreateDate desc");
var list = Base_FilterTime.Query(sql);
return(EntityConvertTools.CopyToList <Base_FilterTime, FilterTimeEntity>(list.ToList()));
}
/// <summary>
/// 保存过滤时段表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="filterTimeEntity">过滤时段实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, FilterTimeEntity filterTimeEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
filterTimeEntity.Modify(keyValue);
Base_FilterTime filterTime = Base_FilterTime.SingleOrDefault("where FilterTimeId=@0", keyValue);
filterTime = EntityConvertTools.CopyToModel <FilterTimeEntity, Base_FilterTime>(filterTimeEntity, filterTime);
filterTime.FilterTimeId = keyValue;
filterTime.Update();
}
else
{
filterTimeEntity.Create();
filterTimeEntity.FilterTimeId = filterTimeEntity.ObjectId;
Base_FilterTime filterTime = new Base_FilterTime();
filterTime = EntityConvertTools.CopyToModel <FilterTimeEntity, Base_FilterTime>(filterTimeEntity, null);
filterTime.Insert();
}
}
/// <summary>
/// 删除过滤时段
/// </summary>
/// <param name="keyValue">主键</param>
public void RemoveForm(string keyValue)
{
Base_FilterTime.Delete("where FilterTimeId=@0", keyValue);
}
/// <summary>
/// 过滤时段实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public FilterTimeEntity GetEntity(string keyValue)
{
var model = Base_FilterTime.SingleOrDefault("where FilterTimeId=@0", keyValue);
return(EntityConvertTools.CopyToModel <Base_FilterTime, FilterTimeEntity>(model, null));
}
