erp/Web/ENotice/Notice_win.aspx.cs

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)
        //{
        //}
    }


}