62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:DSN %>"
SelectCommand="select top 92 a.com_name,b.of_com_account,max(b.of_update_date) as of_update_date from com_members a join offer_info b on a.com_account=b.of_com_account and a.COM_IS_ACCT = '02' and b.IS_PASS = '01' and b.OF_DEADLINE >='<%=SY_DATE %>' group by a.COM_ID,a.com_name, b.of_com_account order by of_update_date desc">
</asp:SqlDataSource>
public 类型 SY_DATE;