public override void Run()
{
var tempinfo = this.OpenOperator.GetDataBaseTempData<TaskManageErrorSendTaskTempInfo>();
if (tempinfo == null)
{
tempinfo = new TaskManageErrorSendTaskTempInfo();
tempinfo.LastLogID = 0;
}
//扫描
List<tb_senderror_model> senderrormodels = new List<tb_senderror_model>();
List<tb_user_model> usermodels = new List<tb_user_model>();
SqlHelper.ExcuteSql(this.SystemRuntimeInfo.TaskConnectString, (c) =>
{
tb_error_dal errordal = new tb_error_dal();
senderrormodels = errordal.GetErrors(c, tempinfo.LastLogID);
tb_user_dal userdal = new tb_user_dal();
usermodels = userdal.GetAllUsers(c);
});
foreach (var u in usermodels)
{
if (string.IsNullOrEmpty(u.useremail))
continue;
if (u.userrole == (int)EnumUserRole.Admin)
SendEmail(senderrormodels, u.useremail);
else
SendEmail(senderrormodels.Where(c => c.taskcreateuserid == u.id).ToList(), u.useremail);
}
if (senderrormodels.Count > 0)
{
int maxid = senderrormodels.Max(c => c.error_model.id);
tempinfo.LastLogID = maxid;
this.OpenOperator.Log(string.Format("本次处理错误日志{0}条", senderrormodels.Count));
}
this.OpenOperator.SaveDataBaseTempData(tempinfo);
}
public static tb_user_model GetUser(string userstaffno, string userpsw)
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_user_dal dal = new tb_user_dal();
return dal.GetUser(PubConn, userstaffno, userpsw);
}
}
//
// GET: /Developers/
public ActionResult Index()
{
return this.Visit(Core.EnumUserRole.Admin,() =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
List<tb_user_model> Model = new tb_user_dal().GetAllUsers(PubConn);
return View(Model);
}
});
}
public ActionResult Add(int? userid)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
if (userid == null)
return View();
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_user_dal dal = new tb_user_dal();
var model = dal.Get(PubConn,userid.Value);
return View(model);
}
});
}
public ActionResult Add(tb_user_model model)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_user_dal dal = new tb_user_dal();
model.usercreatetime = DateTime.Now;
model.usertel = model.usertel.NullToEmpty();
model.useremail = model.useremail.NullToEmpty();
if (model.id == 0)
dal.Add(PubConn, model);
else
dal.Edit(PubConn, model);
}
return RedirectToAction("index");
});
}
public JsonResult Delete(int id)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
try
{
tb_user_dal dal = new tb_user_dal();
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
bool state = dal.DeleteOneNode(PubConn, id);
return Json(new { code = 1, state = state });
}
}
catch (Exception ex)
{
return Json(new { code = -1, msg = ex.Message });
}
});
}
