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