using BizCom; using Castle.ActiveRecord; using SQLData; using System; using System.Collections.Generic; using System.Data; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using Utils; using SiteCore; using Utils.Serialization; public partial class ENotice_Notice_win : BasePage { protected override void OnPreInit(EventArgs e) { _selfCheckPermission = true; } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //string nData = GetString("nData"); //StringBuilder sql = new StringBuilder(); //sql.AppendFormat("select * from view_erptradelog where tid='{0}' order by id;", ctid); //DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString()); StringBuilder sql = new StringBuilder(); sql.AppendFormat("select * from view_erpnoticecell where uid={0} and IsRead=0 and DATEDIFF(MINUTE,NoticeTime,getdate())>0 order by id desc;", CurrentUser.UserID); DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString()); AppendScript("noticeData=" + JsonString.DataTable2AjaxJson(ds.Tables[0]) + ";"); //AppendScript("noticeData=" + nData + ";"); } //foreach (DataRow dr in dt.Rows) //{ //} } }