/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public int SelectCount(Message_Grant_View model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Message_Grant_View>();
if (model != null)
{
if (!model.Id.IsNullOrEmpty())
{
query.Where(p => p.Id == model.Id);
}
if (!model.UserId.IsNullOrEmpty())
{
query.Where(p => p.UserId == model.UserId);
}
if (!model.MessageId.IsNullOrEmpty())
{
query.Where(p => p.MessageId == model.MessageId);
}
if (!model.IsWatch.IsNullOrEmpty())
{
query.Where(p => p.IsWatch == model.IsWatch);
}
if (!model.MainTitle.IsNullOrEmpty())
{
query.Where(p => p.MainTitle == model.MainTitle);
}
if (!model.Title.IsNullOrEmpty())
{
query.Where(p => p.Title == model.Title);
}
if (!model.MessageTime.IsNullOrEmpty())
{
query.Where(p => p.MessageTime == model.MessageTime);
}
if (!model.Content.IsNullOrEmpty())
{
query.Where(p => p.Content == model.Content);
}
if (!model.IsDelete.IsNullOrEmpty())
{
query.Where(p => p.IsDelete == model.IsDelete);
}
}
return(query.GetQueryCount(connection, transaction));
}
/// <summary>
/// 订单应答构造方法
/// </summary>
public MessageResponse(Message_Grant_View mes)
{
//订单ID
this.Id = mes.Id;
//用户id
this.UserId = mes.UserId;
//信息Id
this.MessageId = mes.MessageId;
//是否观看
this.IsWatch = mes.IsWatch;
//标题
this.MainTitle = mes.MainTitle;
//消息标题
this.Title = mes.Title;
//时间
this.MessageTime = mes.MessageTime == null ? "暂无时间" : mes.MessageTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
//内容
this.Content = mes.Content;
//是否删除
this.IsDelete = mes.IsDelete;
}
/// <summary>
/// 根据分页筛选数据
/// </summary>
/// <param name="Key">主键</param>
/// <param name="start">开始数据</param>
/// <param name="PageSize">页面长度</param>
/// <param name="desc">排序</param>
/// <param name="model">对象</param>
/// <returns>对象列表</returns>
public List <Message_Grant_View> SelectByPage(string Key, int start, int PageSize, bool desc, Message_Grant_View model, string SelectFiled)
{
return(Message_Grant_ViewOper.Instance.SelectByPage(Key, start, PageSize, desc, model));
}
/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public int SelectCount(Message_Grant_View model)
{
return(Message_Grant_ViewOper.Instance.SelectCount(model));
}
/// <summary>
/// 筛选全部数据
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public List <Message_Grant_View> SelectByModel(Message_Grant_View model)
{
return(Message_Grant_ViewOper.Instance.SelectAll(model));
}
/// <summary>
/// 根据分页筛选数据
/// </summary>
/// <param name="Key">主键</param>
/// <param name="start">开始数据</param>
/// <param name="PageSize">页面长度</param>
/// <param name="desc">排序</param>
/// <param name="model">对象</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public List <Message_Grant_View> SelectByPage(string Key, int start, int PageSize, bool desc = true, Message_Grant_View model = null, string SelectFiled = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Message_Grant_View>();
if (model != null)
{
if (!model.Id.IsNullOrEmpty())
{
query.Where(p => p.Id == model.Id);
}
if (!model.UserId.IsNullOrEmpty())
{
query.Where(p => p.UserId == model.UserId);
}
if (!model.MessageId.IsNullOrEmpty())
{
query.Where(p => p.MessageId == model.MessageId);
}
if (!model.IsWatch.IsNullOrEmpty())
{
query.Where(p => p.IsWatch == model.IsWatch);
}
if (!model.MainTitle.IsNullOrEmpty())
{
query.Where(p => p.MainTitle == model.MainTitle);
}
if (!model.Title.IsNullOrEmpty())
{
query.Where(p => p.Title == model.Title);
}
if (!model.MessageTime.IsNullOrEmpty())
{
query.Where(p => p.MessageTime == model.MessageTime);
}
if (!model.Content.IsNullOrEmpty())
{
query.Where(p => p.Content == model.Content);
}
if (!model.IsDelete.IsNullOrEmpty())
{
query.Where(p => p.IsDelete == model.IsDelete);
}
}
if (SelectFiled != null)
{
SelectFiled = SelectFiled.ToLowerInvariant();
if (SelectFiled.Contains("id,"))
{
query.Select(p => new { p.Id });
}
if (SelectFiled.Contains("userid,"))
{
query.Select(p => new { p.UserId });
}
if (SelectFiled.Contains("messageid,"))
{
query.Select(p => new { p.MessageId });
}
if (SelectFiled.Contains("iswatch,"))
{
query.Select(p => new { p.IsWatch });
}
if (SelectFiled.Contains("maintitle,"))
{
query.Select(p => new { p.MainTitle });
}
if (SelectFiled.Contains("title,"))
{
query.Select(p => new { p.Title });
}
if (SelectFiled.Contains("messagetime,"))
{
query.Select(p => new { p.MessageTime });
}
if (SelectFiled.Contains("content,"))
{
query.Select(p => new { p.Content });
}
if (SelectFiled.Contains("isdelete,"))
{
query.Select(p => new { p.IsDelete });
}
}
if (Key != null)
{
query.OrderByKey(Key, desc);
}
return(query.GetQueryPageList(start, PageSize, connection, transaction));
}
