/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public int SelectCount1(Gradefindparent model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Gradefindparent>();
if (model != null)
{
if (!model.grandpaId.IsNullOrEmpty())
{
query.Where(p => p.grandpaId == model.grandpaId);
}
if (!model.grandpaName.IsNullOrEmpty())
{
query.Where(p => p.grandpaName == model.grandpaName);
}
if (!model.grandpaImage.IsNullOrEmpty())
{
query.Where(p => p.grandpaImage == model.grandpaImage);
}
if (!model.parentId.IsNullOrEmpty())
{
query.Where(p => p.parentId == model.parentId);
}
if (!model.parentName.IsNullOrEmpty())
{
query.Where(p => p.parentName == model.parentName);
}
if (!model.parentImage.IsNullOrEmpty())
{
query.Where(p => p.parentImage == model.parentImage);
}
if (!model.id.IsNullOrEmpty())
{
query.Where(p => p.id == model.id);
}
if (!model.gradeName.IsNullOrEmpty())
{
query.Where(p => p.gradeName == model.gradeName);
}
if (!model.gradeImage.IsNullOrEmpty())
{
query.Where(p => p.gradeImage == model.gradeImage);
}
if (!model.HotGradeTime.IsNullOrEmpty())
{
query.Where(p => p.HotGradeTime == model.HotGradeTime);
}
if (!model.GradeAttrName.IsNullOrEmpty())
{
query.Where(p => p.GradeAttrName == model.GradeAttrName);
}
}
return(query.GetQueryCount(connection, transaction));
}
/// <summary>
/// 根据某一分类获取它和它的子孙分类
/// </summary>
/// <param name="model"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public List <Gradefindparent> SelectFamilyByGradeId(Gradefindparent model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Gradefindparent>();
if (model != null)
{
if (!model.grandpaId.IsNullOrEmpty())
{
query.Where(p => p.grandpaId == model.grandpaId || p.id == model.id || p.parentId == model.parentId);
}
}
return(query.GetQueryList(connection, transaction));
}
public GradeInfo(Gradefindparent g)
{
Id = g.id.ToString();
Name = g.gradeName;
Img = g.gradeImage ?? "";
GradeAttr = g.GradeAttrName ?? "";
if (g.parentId != null)
{
parentId = g.parentId.ToString();
}
else
{
parentId = "0";
}
parentName = g.parentName ?? "";
}
public GradeDetailReq(Gradefindparent req)
{
gradeId = req.id.ToString();
gradeName = req.gradeName ?? "";
gradeAttr = req.GradeAttrName ?? "";
if (req.parentId != null)
{
fatherId = req.parentId.ToString();
}
else
{
fatherId = "";
}
fatherName = req.parentName ?? "";
img = req.gradeImage;
Bigimg = req.gradeBigImage;
}
/// <summary>
/// 分类信息构造函数
/// </summary>
/// <param name="gradefindparent">分类父节点</param>
public GradeInfo(Gradefindparent gradefindparent)
{
Id = gradefindparent.id.ToString();
Name = gradefindparent.gradeName;
Img = gradefindparent.gradeImage ?? "暂无图片";
GradeAttr = gradefindparent.GradeAttrName ?? "";
if (gradefindparent.parentId != null)
{
parentId = gradefindparent.parentId.ToString();
}
else
{
parentId = "0";
}
parentName = gradefindparent.parentName ?? "暂无父节点";
HotGradeTime = gradefindparent.HotGradeTime != null?gradefindparent.HotGradeTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : "暂无推荐时间";
}
/// <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 <Gradefindparent> SelectByPage1(string Key, int start, int PageSize, bool desc = true, Gradefindparent model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Gradefindparent>();
if (model != null)
{
if (!model.grandpaId.IsNullOrEmpty())
{
query.Where(p => p.grandpaId == model.grandpaId);
}
if (!model.grandpaName.IsNullOrEmpty())
{
query.Where(p => p.grandpaName == model.grandpaName);
}
if (!model.grandpaImage.IsNullOrEmpty())
{
query.Where(p => p.grandpaImage == model.grandpaImage);
}
if (!model.parentId.IsNullOrEmpty())
{
query.Where(p => p.parentId == model.parentId);
}
if (!model.parentName.IsNullOrEmpty())
{
query.Where(p => p.parentName == model.parentName);
}
if (!model.parentImage.IsNullOrEmpty())
{
query.Where(p => p.parentImage == model.parentImage);
}
if (!model.id.IsNullOrEmpty())
{
query.Where(p => p.id == model.id);
}
if (!model.gradeName.IsNullOrEmpty())
{
query.Where(p => p.gradeName == model.gradeName);
}
if (!model.gradeImage.IsNullOrEmpty())
{
query.Where(p => p.gradeImage == model.gradeImage);
}
if (!model.HotGradeTime.IsNullOrEmpty())
{
query.Where(p => p.HotGradeTime == model.HotGradeTime);
}
if (!model.GradeAttrName.IsNullOrEmpty())
{
query.Where(p => p.GradeAttrName == model.GradeAttrName);
}
}
if (Key != null)
{
query.OrderByKey(Key, desc);
}
return(query.GetQueryPageList(start, PageSize, connection, transaction));
}
/// <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 <Gradefindparent> SelectByPage(string Key, int start, int PageSize, bool desc, Gradefindparent model, string SelectFiled)
{
return(GradefindparentOper.Instance.SelectByPage(Key, start, PageSize, desc, model));
}
/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public int SelectCount(Gradefindparent model)
{
return(GradefindparentOper.Instance.SelectCount(model));
}
/// <summary>
/// 筛选全部数据
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public List <Gradefindparent> SelectByModel(Gradefindparent model)
{
return(GradefindparentOper.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 <Gradefindparent> SelectByPage(string Key, int start, int PageSize, bool desc = true, Gradefindparent model = null, string SelectFiled = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Gradefindparent>();
if (model != null)
{
if (!model.grandpaId.IsNullOrEmpty())
{
query.Where(p => p.grandpaId == model.grandpaId);
}
if (!model.grandpaName.IsNullOrEmpty())
{
query.Where(p => p.grandpaName == model.grandpaName);
}
if (!model.grandpaImage.IsNullOrEmpty())
{
query.Where(p => p.grandpaImage == model.grandpaImage);
}
if (!model.grandpaBigImage.IsNullOrEmpty())
{
query.Where(p => p.grandpaBigImage == model.grandpaBigImage);
}
if (!model.parentId.IsNullOrEmpty())
{
query.Where(p => p.parentId == model.parentId);
}
if (!model.parentName.IsNullOrEmpty())
{
query.Where(p => p.parentName == model.parentName);
}
if (!model.parentImage.IsNullOrEmpty())
{
query.Where(p => p.parentImage == model.parentImage);
}
if (!model.parentBigImage.IsNullOrEmpty())
{
query.Where(p => p.parentBigImage == model.parentBigImage);
}
if (!model.id.IsNullOrEmpty())
{
query.Where(p => p.id == model.id);
}
if (!model.gradeName.IsNullOrEmpty())
{
query.Where(p => p.gradeName == model.gradeName);
}
if (!model.gradeImage.IsNullOrEmpty())
{
query.Where(p => p.gradeImage == model.gradeImage);
}
if (!model.gradeBigImage.IsNullOrEmpty())
{
query.Where(p => p.gradeBigImage == model.gradeBigImage);
}
if (!model.HotGradeTime.IsNullOrEmpty())
{
query.Where(p => p.HotGradeTime == model.HotGradeTime);
}
if (!model.GradeAttrName.IsNullOrEmpty())
{
query.Where(p => p.GradeAttrName == model.GradeAttrName);
}
}
if (SelectFiled != null)
{
SelectFiled = SelectFiled.ToLowerInvariant();
if (SelectFiled.Contains("grandpaid,"))
{
query.Select(p => new { p.grandpaId });
}
if (SelectFiled.Contains("grandpaname,"))
{
query.Select(p => new { p.grandpaName });
}
if (SelectFiled.Contains("grandpaimage,"))
{
query.Select(p => new { p.grandpaImage });
}
if (SelectFiled.Contains("grandpabigimage,"))
{
query.Select(p => new { p.grandpaBigImage });
}
if (SelectFiled.Contains("parentid,"))
{
query.Select(p => new { p.parentId });
}
if (SelectFiled.Contains("parentname,"))
{
query.Select(p => new { p.parentName });
}
if (SelectFiled.Contains("parentimage,"))
{
query.Select(p => new { p.parentImage });
}
if (SelectFiled.Contains("parentbigimage,"))
{
query.Select(p => new { p.parentBigImage });
}
if (SelectFiled.Contains("id,"))
{
query.Select(p => new { p.id });
}
if (SelectFiled.Contains("gradename,"))
{
query.Select(p => new { p.gradeName });
}
if (SelectFiled.Contains("gradeimage,"))
{
query.Select(p => new { p.gradeImage });
}
if (SelectFiled.Contains("gradebigimage,"))
{
query.Select(p => new { p.gradeBigImage });
}
if (SelectFiled.Contains("hotgradetime,"))
{
query.Select(p => new { p.HotGradeTime });
}
if (SelectFiled.Contains("gradeattrname,"))
{
query.Select(p => new { p.GradeAttrName });
}
}
if (Key != null)
{
query.OrderByKey(Key, desc);
}
return(query.GetQueryPageList(start, PageSize, connection, transaction));
}
