Global.asax如何启动一个定时器 Global.asax中如何启动一个定时器 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 里面执行这段代码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) { } 求MVC关于Views调用control方法 Detailsview 编辑模式下 模版里有个listbox 要初始化 C#.NET 连接各类数据库 字符串的写法 [求助]数据库 插入语句的问题![online] 有关TextBox 这里报错,,该怎么改动!! 请夜间高手帮忙,关于一个无刷新DropdownList联动的问题 ? 在线等...... 一个DataGrid界面样式运用的简单问题 div布局问题 如何将中文环境下的calendar显示为英文阿 .NET语言编写的软件是如何控制软件使用的期限现的? 未指定的错误
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)
{
}