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