博问 / 全部问题 / Web开发 / 高性能网站构建

CREATE PROCEDURE Getdefaultinfo

   AS

/*顶部交换技能*/
select top 30 FTID,FuserID,dbo.TurnUserName(FuserID) as userName,FShi,FQu,substring(FTtitle,40,50) as title,FTechKey,FPClassID,dbo.TurnClassName(FPClassID) as PClassName,FBClassID,dbo.TurnClassName(FBClassID) as BClassName,dbo.FormatFtime(FcreateTime) as createTime from T_Techtory where FTtype=1 and FmoneyArea in (1,3) order by FcreateTime desc

/*顶部交易技能*/
select top 30 d.FUserLoginName,a.FTID,substring(a.FTtitle,40,50) title,a.FPClassID,a.FBClassID,b.FclassName fpc,a.FuserID,c.FclassName fbc,FShi,FQu,dbo.FormatFtime(a.FcreateTime) createTime from  T_Techtory a  left join T_ClassType b on  a.FPClassID=b.FClassID left join T_ClassType c on a.FBClassID=c.FClassID left join T_UserInfo d on a.FuserID=d.FuserID where a.FTtype=1 and a.FmoneyArea in(2,3) order by a.FcreateTime desc

/*最新需求*/
select top 24 ftid, fttitle,Fmoney from t_techtory where FTtype='2'  and Fispublic='0'and FStatus='0'  and fdatetime >getdate()  order by fcreatetime  desc

/*热门需求*/
select top 24 ftid, fttitle,Fmoney from t_techtory where FTtype='2'  and Fispublic='0'and FStatus='0'  and fdatetime >getdate()  order by FTechCredit  desc

/*推荐交换*/
select top 16 ftid, fttitle,FtechKey,FuserID,dbo.TurnUserName(FuserID) as userName from t_techtory where FTtype=1 and Frecommend>0 and FmoneyArea in(1,3) and fdatetime >getdate() and Fispublic='0'and FStatus='0' and FmoneyArea in(1,3)  order by fcreatetime  desc

/*推荐交易*/
select top 24 ftid,fttitle,fuserid from t_techtory where fttype=1 and Frecommend>0 and FmoneyArea in(2,3) and fdatetime >getdate() order by fcreatetime  desc

/*热门交换*/
select top 16 ftid, fttitle,FtechKey,FuserID,dbo.TurnUserName(FuserID) as userName from t_techtory where FTtype=1 and fdatetime >getdate() and Fispublic='0'and FStatus='0' and FmoneyArea in(1,3) order by fskillhit desc

/*读取社区图片*/
select top 2 title,imgurl,link from usernews order by [time] desc

/*资讯频道图片*/
select top 2 FnewsID, Ftitle,FhtmlUrl from T_News where FType='N00002' and FisTopNews=1 order by fregtime desc

/*资讯频道内容*/
select top 12 FnewsID, Ftitle from T_News where FType='N00002' and FisTopNews<>1 order by fregtime desc

/*综合频道图片*/
select top 2 FnewsID, Ftitle,FhtmlUrl from T_News where FType='N00003' and FisTopNews=1 order by fregtime desc

/*综合频道内容*/
select top 12 FnewsID, Ftitle from T_News where FType='N00003' and FisTopNews<>1 order by fregtime desc

/*申请友情链接*/
select * from t_link order by displayorder
GO