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 }); } }); }