private void Eating2_Load_2(object sender, EventArgs e)
        {
            string bookid = Users.StaticBook;
            // TODO: 这行代码将数据加载到表“dataSet_Notice.TB_NOTICE”中。您可以根据需要移动或移除它。

            this.tB_NOTICETableAdapter.Fill(this.dataSet_Notice.TB_NOTICE,bookid);
            this.toolStripStatusLabel2.Text =  Users.Staticdept + "--" + Users.Staticname;
           

            //遍历所有MENU,将菜单NAME和TEXT写入txt。开发过程用。
            //menuToTxt();
            //InitMenuItem();

          
            System.Timers.Timer t =
            new System.Timers.Timer(600000);
            //实例化Timer类,设置间隔时间为10000毫秒;  

            t.Elapsed +=
            new System.Timers.ElapsedEventHandler(theout);
            //到达时间的时候执行事件;  
            t.AutoReset = true;
            //设置是执行一次(false)还是一直执行(true);  

            //是否执行System.Timers.Timer.Elapsed事件;

            t.Enabled = true;
          
        }
        //建立个委托
        private delegate string returnStrDelegate();

        //搞个最简单滴取值滴方法~
        private string returnSchool()
        {
            DataTable dt = this.bindData();
            this.dataGridView1.DataSource = dt;
            return "1";
        }

        //判断一下是不是该用Invoke滴~,不是就直接返回~
        private string returnCB(returnStrDelegate myDelegate)
        {
            if (this.InvokeRequired)
            {
                return (string)this.Invoke(myDelegate);
            }
            else
            {
                return myDelegate();
            }
        }


        public void theout(
           object source,
           System.Timers.ElapsedEventArgs e)
        {


            //DataTable dt = this.bindData();
            //this.dataGridView1.DataSource = dt;
            returnCB(returnSchool);
        }

        public DataTable bindData()
        {
            string bookid = Users.StaticBook;
            string sql = "SELECT top 15 id, Title, Contents, WritePerson, AllowPerson, WritePart, ReadParts, NoticeDatetime, FileId, Bak1, Bak2, Bak3 FROM TB_NOTICE WHERE (ReadParts LIKE '%" + bookid + "%') and (Bak1 = '1') order by NoticeDatetime desc";
            DataTable dt = this.gettablebysqls.GetTableBySql(sql);
            return dt;

        }

posted on 2013-08-07 11:11  点滴汪洋  阅读(1410)  评论(0编辑  收藏  举报