Global.asax中如何启动一个定时器

解决方案 »

  1.   

    里面执行这段代码
    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)
                    {
                        
                    }