/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public int SelectCount(Evalinfo model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Evalinfo>();
if (model != null)
{
if (!model.EvaluateId.IsNullOrEmpty())
{
query.Where(p => p.EvaluateId == model.EvaluateId);
}
if (!model.UserId.IsNullOrEmpty())
{
query.Where(p => p.UserId == model.UserId);
}
if (!model.CommodityId.IsNullOrEmpty())
{
query.Where(p => p.CommodityId == model.CommodityId);
}
if (!model.ImageList.IsNullOrEmpty())
{
query.Where(p => p.ImageList == model.ImageList);
}
if (!model.CreateTime.IsNullOrEmpty())
{
query.Where(p => p.CreateTime == model.CreateTime);
}
if (!model.Content.IsNullOrEmpty())
{
query.Where(p => p.Content == model.Content);
}
if (!model.Start.IsNullOrEmpty())
{
query.Where(p => p.Start == model.Start);
}
if (!model.FrontView.IsNullOrEmpty())
{
query.Where(p => p.FrontView == model.FrontView);
}
if (!model.BackView.IsNullOrEmpty())
{
query.Where(p => p.BackView == model.BackView);
}
if (!model.ParentId.IsNullOrEmpty())
{
query.Where(p => p.ParentId == model.ParentId);
}
if (!model.Name.IsNullOrEmpty())
{
query.Where(p => p.Name == model.Name);
}
if (!model.CommName.IsNullOrEmpty())
{
query.Where(p => p.CommName == model.CommName);
}
}
return(query.GetQueryCount(connection, transaction));
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="evalinfo">评价信息</param>
public EvaluateByPageResponse(Evalinfo evalinfo)
{
this.EvaluateId = evalinfo.EvaluateId;
this.UserId = evalinfo.UserId;
this.CommodityId = evalinfo.CommodityId;
this.ImageList = evalinfo.ImageList;
this.CreateTime = evalinfo.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
this.Content = evalinfo.Content;
this.Start = evalinfo.Start;
this.FrontView = AdminUrl + evalinfo.FrontView;
this.BackView = AdminUrl + evalinfo.BackView;
this.Name = evalinfo.Name;
}
/// <summary>
/// 评论应答
/// </summary>
/// <param name="evalinfo">评论</param>
public EvaluateResponse(Evalinfo evalinfo)
{
//评论Id
this.EvaluateId = evalinfo.EvaluateId;
//商品名称
this.CommName = evalinfo.CommName;
//图片列表
this.ImageList = evalinfo.ImageList;
//创建时间
this.CreateTime = evalinfo.CreateTime;
//内容
this.Content = evalinfo.Content;
//星级
this.Start = evalinfo.Start;
//前视图
this.FrontView = evalinfo.FrontView;
//后视图
this.BackView = evalinfo.BackView;
//父节点Id
this.ParentId = evalinfo.ParentId;
//用户名
this.Name = evalinfo.Name;
}
/// <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 <Evalinfo> SelectByPage(string Key, int start, int PageSize, bool desc, Evalinfo model, string SelectFiled)
{
return(EvalinfoOper.Instance.SelectByPage(Key, start, PageSize, desc, model));
}
/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public int SelectCount(Evalinfo model)
{
return(EvalinfoOper.Instance.SelectCount(model));
}
/// <summary>
/// 筛选全部数据
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public List <Evalinfo> SelectByModel(Evalinfo model)
{
return(EvalinfoOper.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 <Evalinfo> SelectByPage(string Key, int start, int PageSize, bool desc = true, Evalinfo model = null, string SelectFiled = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Evalinfo>();
if (model != null)
{
if (!model.EvaluateId.IsNullOrEmpty())
{
query.Where(p => p.EvaluateId == model.EvaluateId);
}
if (!model.UserId.IsNullOrEmpty())
{
query.Where(p => p.UserId == model.UserId);
}
if (!model.CommodityId.IsNullOrEmpty())
{
query.Where(p => p.CommodityId == model.CommodityId);
}
if (!model.ImageList.IsNullOrEmpty())
{
query.Where(p => p.ImageList == model.ImageList);
}
if (!model.CreateTime.IsNullOrEmpty())
{
query.Where(p => p.CreateTime == model.CreateTime);
}
if (!model.Content.IsNullOrEmpty())
{
query.Where(p => p.Content == model.Content);
}
if (!model.Start.IsNullOrEmpty())
{
query.Where(p => p.Start == model.Start);
}
if (!model.FrontView.IsNullOrEmpty())
{
query.Where(p => p.FrontView == model.FrontView);
}
if (!model.BackView.IsNullOrEmpty())
{
query.Where(p => p.BackView == model.BackView);
}
if (!model.ParentId.IsNullOrEmpty())
{
query.Where(p => p.ParentId == model.ParentId);
}
if (!model.Name.IsNullOrEmpty())
{
query.Where(p => p.Name == model.Name);
}
if (!model.CommName.IsNullOrEmpty())
{
query.Where(p => p.CommName == model.CommName);
}
}
if (SelectFiled != null)
{
SelectFiled = SelectFiled.ToLowerInvariant();
if (SelectFiled.Contains("evaluateid,"))
{
query.Select(p => new { p.EvaluateId });
}
if (SelectFiled.Contains("userid,"))
{
query.Select(p => new { p.UserId });
}
if (SelectFiled.Contains("commodityid,"))
{
query.Select(p => new { p.CommodityId });
}
if (SelectFiled.Contains("imagelist,"))
{
query.Select(p => new { p.ImageList });
}
if (SelectFiled.Contains("createtime,"))
{
query.Select(p => new { p.CreateTime });
}
if (SelectFiled.Contains("content,"))
{
query.Select(p => new { p.Content });
}
if (SelectFiled.Contains("start,"))
{
query.Select(p => new { p.Start });
}
if (SelectFiled.Contains("frontview,"))
{
query.Select(p => new { p.FrontView });
}
if (SelectFiled.Contains("backview,"))
{
query.Select(p => new { p.BackView });
}
if (SelectFiled.Contains("parentid,"))
{
query.Select(p => new { p.ParentId });
}
if (SelectFiled.Contains("name,"))
{
query.Select(p => new { p.Name });
}
if (SelectFiled.Contains("commname,"))
{
query.Select(p => new { p.CommName });
}
}
if (Key != null)
{
query.OrderByKey(Key, desc);
}
return(query.GetQueryPageList(start, PageSize, connection, transaction));
}
