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;
}