ASP源码
PHP源码
.NET源码
JSP源码
第一步:这样写Sql语句:
select top 5 PK_Rntol_ID,Title,RenoDate,Promulgator,Flag=case
when getdate() - RenoDate < 5 then '1'
else '0'
end
from es***ypzb.T_Info_Rntol where RenoKind= @type order by RenoDate desc
第二步:
在DataGrid的DataBound()方法里面:
///
/// 根据日期的多少,决定是否显示new图标
///
///
///
private void wgrd_Info_ItemDataBound(object sender, Sy***m.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.***m.ItemType == Li***temType.Item || e.***m.ItemType == Li***temType.AlternatingItem)
{
if(e.***m.Cells[5].Text == "1")
{
e.***m.Cells[1].Text = e.***m.Cells[1].Text + " ";
}
}
}