private static void setState()
{
TasksClass tasksClass = new TasksClass();
string strsql1 = "update tasks8 set stu='等待中' where stu='暂停' and userid=" + (object)sys.LoginUser.ID;
tasksClass.exec(strsql1);
usersClass usersClass = new usersClass();
string strsql2 = "update tasks8 set Stu='等待中' where Stu='正在进行' and startTime<'" + tasksClass.getSysTime().AddMinutes(-30.0).ToString("yyyy-MM-dd HH:mm:ss") + "' and jd<sl";
usersClass.exec(strsql2);
string strsql3 = "update tasks8 set Stu='操作完成',jd=sl where jd>=sl or nofind>=sl ";
usersClass.exec(strsql3);
}