| | |
| | | + " declare @DocCode varchar(20) = "+GridUtils.prossSqlParm(docCode)+",@Title varchar(50) = "+GridUtils.prossSqlParm(title)+" \n" |
| | | + " declare @ShopCcCode varchar(50) = "+GridUtils.prossSqlParm(shopCcCode)+" ,@AuthorizationAppid varchar(50) = "+GridUtils.prossSqlParm(authorizationAppid)+" \n" |
| | | + " select a.DocCode,a.Title,a.BannerImage,a.BannerImageUrl,a.isShowBannerOnHomePage,a.isShowBannerOnDetailPage, \n" |
| | | + " a.Description,a.MetaTitle,a.MetaDescription,a.MetaKeyword,,a.HDLink,a.HDPathCode,a.HDFinderUserName,a.HDFeedId,a.HDFeedToken, \n" |
| | | + " a.Description,a.MetaTitle,a.MetaDescription,a.MetaKeyword,a.HDLink,a.HDPathCode,a.HDFinderUserName,a.HDFeedId,a.HDFeedToken, \n" |
| | | + " b.Link,b.PathCode,b.Image,b.SortOrder,c.PathName,c.PathUrl, \n" |
| | | + " case when exists(select 1 from t720123 y where b.pathcode = y.pathcode and y.AuthorizationAppid = @AuthorizationAppid) then 1 else 0 end as isTabBarButton, \n" |
| | | + " b.isShowBottom,,b.FinderUserName,b.FeedId,b.FeedToken \n" |
| | | + " b.isShowBottom,b.FinderUserName,b.FeedId,b.FeedToken \n" |
| | | + " from t714031H a join t714031D b on a.doccode = b.doccode \n" |
| | | + " left join t730117 c on b.PathCode = c.PathCode \n" |
| | | + " where (isnull(@DocCode,'') = '' or a.DocCode = @DocCode ) \n" |