/// <summary>
/// 一级目录查询（所有）
/// </summary>
/// <param name="request"></param>
public void CatFQueryBuild(DTO.PQCatQuery request)
{
this.AppendInit();
this.AppendFieldRownum("cfp.SortOrder desc,cf.CatFID");
this.AppendFieldStr("cf.CatFID as CatID");
this.AppendFieldStr("cf.Name");
this.AppendFieldStr("cf.Description");
this.AppendFieldStr("cfp.CatFPicID as CatPicID");
this.AppendFieldStr("cfp.PicType");
this.AppendFieldStr("p.PicID");
this.AppendFieldStr("p.PicName");
this.AppendFieldStr("p.StoreName");
this.AppendFieldStr("p.ThambName");
this.AppendFieldStr("p.Path");
this.AppendFromStr("from tbCatF cf,tbCatFPic cfp,tbPic p where cf.CatFID=cfp.CatFID and cfp.PicID=p.PicID and cf.Enabled='1'");
this.AppendComplete(request.Page, request.PageRow);
}
/// <summary>
/// 二级目录查询（所有）
/// </summary>
/// <param name="request"></param>
public void CatSQueryBuild(DTO.PQCatQuery request)
{
this.AppendInit();
this.AppendFieldRownum("csp.SortOrder desc,cs.CatSID");
this.AppendFieldStr("cs.CatSID as CatID");
this.AppendFieldStr("cs.Name");
this.AppendFieldStr("cs.Description");
this.AppendFieldStr("csp.CatSPicID as CatPicID");
this.AppendFieldStr("csp.PicType");
this.AppendFieldStr("p.PicID");
this.AppendFieldStr("p.PicName");
this.AppendFieldStr("p.StoreName");
this.AppendFieldStr("p.ThambName");
this.AppendFieldStr("p.Path");
this.AppendFromStr("from tbCats cs,tbCatsPic csp,tbPic p where cs.CatSID=csp.CatSID and csp.PicID=p.PicID and cs.Enabled='1'");
this.AppendWhereEqual("cs.CatFID", request.CatFID);
this.AppendComplete(request.Page, request.PageRow);
}
