Global.asax如何启动一个定时器
Global.asax中如何启动一个定时器 --------------------编程问答-------------------- 里面执行这段代码try
{
List<DataDB> listDB = userMgr.SelectByDataDB();
if (listDB != null)
{
if (listDB.Count > 0)
{
foreach (DataDB db in listDB)
{
if (db != null)
{
ArrayList list = unitMgr.GetAllLocalUnit(db);
if (list != null)
{
if (list.Count > 0)
{
foreach (UnitUsers unit in list)
{
UserTotal user = userMgr.SelectBySchoolIDUserTotal(unit.Id, DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString());
if (user != null && user.ID != Guid.Empty)
{
user.ParentID = unit.Parentid;
DataTable table = unitMgr.GetTeaOrStuCounts(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), db.DBName);
if (table != null)
{
if (table.Rows.Count > 0)
{
user.TeacherTotal = Convert.ToInt32(table.Rows[0]["num"].ToString());
user.StudentTotal = Convert.ToInt32(table.Rows[1]["num"].ToString());
user.TeacherMonthCount = Convert.ToInt32(table.Rows[2]["num"].ToString());
user.StudentMonthCount = Convert.ToInt32(table.Rows[3]["num"].ToString());
}
}
//user.TeacherTotal = unitMgr.GetTeaOrStuCount(unit.Id, 2) <= 0 ? 0 : unitMgr.GetTeaOrStuCount(unit.Id, 2);
//user.StudentTotal = unitMgr.GetTeaOrStuCount(unit.Id, 1) <= 0 ? 0 : unitMgr.GetTeaOrStuCount(unit.Id, 1);
user.TeacherMonthUser = unitMgr.GetTeaOrStu(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 2, db.DBName);
user.StudentMonthUser = unitMgr.GetTeaOrStu(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 1, db.DBName);
//user.TeacherMonthCount = unitMgr.GetTeaOrStuCount(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 2);
//user.StudentMonthCount= unitMgr.GetTeaOrStuCount(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 1);
user.UnitName = unit.Name;
userMgr.Update(user);
}
else
{
UserTotal userTotal = new UserTotal();
userTotal.ID = Guid.NewGuid();
userTotal.SchoolID = unit.Id;
userTotal.ParentID = unit.Parentid;
userTotal.Years = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString();
DataTable table = unitMgr.GetTeaOrStuCounts(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), db.DBName);
if (table != null)
{
if (table.Rows.Count > 0)
{
userTotal.TeacherTotal = Convert.ToInt32(table.Rows[0]["num"].ToString());
userTotal.StudentTotal = Convert.ToInt32(table.Rows[1]["num"].ToString());
userTotal.TeacherMonthCount = Convert.ToInt32(table.Rows[2]["num"].ToString());
userTotal.StudentMonthCount = Convert.ToInt32(table.Rows[3]["num"].ToString());
}
}
//userTotal.TeacherTotal = unitMgr.GetTeaOrStuCount(unit.Id, 2) <= 0 ? 0 : unitMgr.GetTeaOrStuCount(unit.Id, 2);
//userTotal.StudentTotal = unitMgr.GetTeaOrStuCount(unit.Id, 1) <= 0 ? 0 : unitMgr.GetTeaOrStuCount(unit.Id, 1);
userTotal.TeacherMonthUser = unitMgr.GetTeaOrStu(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 2, db.DBName);
userTotal.StudentMonthUser = unitMgr.GetTeaOrStu(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 1, db.DBName);
//userTotal.TeacherMonthCount = unitMgr.GetTeaOrStuCount(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 2);
//userTotal.StudentMonthCount = unitMgr.GetTeaOrStuCount(unit.Id, DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), 1);
userTotal.UnitName = unit.Name;
userMgr.Save(userTotal);
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
}
补充:.NET技术 , ASP.NET