// // GET: /Task/ public ActionResult Index(string taskid, string keyword, string CStime, string CEtime, int categoryid = -1, int nodeid = -1, int userid = -1, int state = -999, int pagesize = 10, int pageindex = 1) { return(this.Visit(Core.EnumUserRole.None, () => { ViewBag.taskid = taskid; ViewBag.keyword = keyword; ViewBag.CStime = CStime; ViewBag.CEtime = CEtime; ViewBag.categoryid = categoryid; ViewBag.nodeid = nodeid; ViewBag.userid = userid; ViewBag.state = state; ViewBag.pagesize = pagesize; ViewBag.pageindex = pageindex; tb_task_dal dal = new tb_task_dal(); PagedList <tb_tasklist_model> pageList = null; int count = 0; using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); List <tb_tasklist_model> List = dal.GetList(PubConn, taskid, keyword, CStime, CEtime, categoryid, nodeid, userid, state, pagesize, pageindex, out count); pageList = new PagedList <tb_tasklist_model>(List, pageindex, pagesize, count); List <tb_node_model> Node = new tb_node_dal().GetListAll(PubConn); List <tb_category_model> Category = new tb_category_dal().GetList(PubConn, ""); List <tb_user_model> User = new tb_user_dal().GetAllUsers(PubConn); ViewBag.Node = Node; ViewBag.Category = Category; ViewBag.User = User; } return View(pageList); })); }
public static tb_user_model GetUserName(string userstaffno) { using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); tb_user_dal dal = new tb_user_dal(); return(dal.GetUserName(PubConn, userstaffno)); } }
// // GET: /Manage/User/ public ActionResult Index() { using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); List <tb_user_model> Model = new tb_user_dal().GetAllUsers(PubConn); return(View(Model)); } }
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(EnumUserRole.Admin, () => { using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString)) { PubConn.Open(); List <tb_user_model> Model = new tb_user_dal().GetAllUsers(PubConn); return View(Model); } })); }
public ActionResult Add(int?userid) { if (userid == null) { return(View()); } using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); tb_user_dal dal = new tb_user_dal(); var model = dal.Get(PubConn, userid.Value); return(View(model)); } }
public override void Run() { GlobalConfig.MonitorPlatformManageConnectString = AppConfig["MonitorPlatformManageConnectString"]; SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_database_config_dal dal = new tb_database_config_dal(); var list = dal.GetModelList(c); UnityLogConnectString = XXF.BaseService.Monitor.SystemRuntime.DbShardingHelper.GetDataBase(list, XXF.BaseService.Monitor.SystemRuntime.DataBaseType.UnityLog); }); List <tb_user_model> users = new List <tb_user_model>(); SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_user_dal dal = new tb_user_dal(); users = dal.GetAllUsers(c); }); foreach (var u in users) { if (!string.IsNullOrWhiteSpace(u.useremail)) { if (u.lastsenderrortime.AddMinutes(u.errorsendintervaltime) < DateTime.Now) { List <tb_error_log_model> errors = new List <tb_error_log_model>(); SqlHelper.ExcuteSql(UnityLogConnectString, (c) => { tb_error_log_dal dal = new tb_error_log_dal(); if (u.userrole == (byte)XXF.BaseService.Monitor.SystemRuntime.EnumUserRole.Admin) { errors = dal.GetUserErrors(c, u.lastsenderrortime, "", "", 50); } else { errors = dal.GetUserErrors(c, u.lastsenderrortime, u.username.Trim(), u.userstaffno.Trim(), 50); } }); SendEmail(errors, u.useremail); SqlHelper.ExcuteSql(GlobalConfig.MonitorPlatformManageConnectString, (c) => { tb_user_dal dal = new tb_user_dal(); dal.UpdateLastErrorSendTime(c, u.id, DateTime.Now); }); } } } }
public ActionResult Add() { return(this.Visit(Core.EnumUserRole.Admin, () => { using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); List <tb_category_model> Category = new tb_category_dal().GetList(PubConn, ""); List <tb_node_model> Node = new tb_node_dal().GetListAll(PubConn); List <tb_user_model> User = new tb_user_dal().GetAllUsers(PubConn); ViewBag.Node = Node; ViewBag.Category = Category; ViewBag.User = User; return View(); } })); }
public JsonResult Delete(int id) { try { tb_user_dal dal = new tb_user_dal(); using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); bool state = dal.Delete(PubConn, id); return(Json(new { code = 1, state = state })); } } catch (Exception ex) { return(Json(new { code = -1, msg = ex.Message })); } }
public ActionResult Add(int?userid) { return(this.Visit(EnumUserRole.Admin, () => { if (userid == null) { return View(); } using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_user_dal dal = new tb_user_dal(); var model = dal.Get(PubConn, userid.Value); return View(model); } })); }
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 JsonResult Delete(int id) { return(this.Visit(EnumUserRole.Admin, () => { try { tb_user_dal dal = new tb_user_dal(); using (DbConn PubConn = DbConn.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 }); } })); }
public ActionResult Add(tb_user_model model) { using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); tb_user_dal dal = new tb_user_dal(); model.usercreatetime = DateTime.Now; model.lastsenderrortime = DateTime.Now; model.errorsendintervaltime = (model.errorsendintervaltime == 0?1:model.errorsendintervaltime); 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 ActionResult Add(tb_user_model model) { return(this.Visit(EnumUserRole.Admin, () => { using (DbConn PubConn = DbConn.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 ActionResult Update(int taskid) { return(this.Visit(Core.EnumUserRole.None, () => { using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_task_dal dal = new tb_task_dal(); tb_task_model model = dal.GetOneTask(PubConn, taskid); tb_tempdata_model tempdatamodel = new tb_tempdata_dal().GetByTaskID(PubConn, taskid); List <tb_version_model> Version = new tb_version_dal().GetTaskVersion(PubConn, taskid); List <tb_category_model> Category = new tb_category_dal().GetList(PubConn, ""); List <tb_node_model> Node = new tb_node_dal().GetListAll(PubConn); List <tb_user_model> User = new tb_user_dal().GetAllUsers(PubConn); ViewBag.Node = Node; ViewBag.Category = Category; ViewBag.Version = Version; ViewBag.User = User; ViewBag.TempData = tempdatamodel; return View(model); } })); }
// // GET: /Task/ public ActionResult Index(string taskid, string keyword, string CStime, string CEtime, int categoryid = -1, int nodeid = -1, int userid = -1, int state = -999, int pagesize = 10, int pageindex = 1) { return(this.Visit(EnumUserRole.None, () => { #region 保存查询信息,优化操作体验 var ps = Request.RequestParams(); ps.Remove("userid"); var sessionkey = "/task/index/"; if (ps.Count == 0) { if (HttpContext.Session.GetString(sessionkey) != null) { var ks = new BSF.Serialization.JsonProvider(BSF.Serialization.JsonAdapter.EnumJsonMode.Newtonsoft).Deserialize <List <KeyValuePair <string, object> > >(HttpContext.Session.GetString(sessionkey)); foreach (var k in ks) { if (!ViewData.ContainsKey(k.Key)) { ViewData.Add(k); } } taskid = (string)ViewBag.taskid; keyword = (string)ViewBag.keyword; CStime = (string)ViewBag.CStime; CEtime = (string)ViewBag.CEtime; categoryid = (int)ViewBag.categoryid; nodeid = (int)ViewBag.nodeid; userid = (int)ViewBag.userid; state = (int)ViewBag.state; pagesize = (int)ViewBag.pagesize; pageindex = (int)ViewBag.pageindex; } } ViewBag.taskid = taskid; ViewBag.keyword = keyword; ViewBag.CStime = CStime; ViewBag.CEtime = CEtime; ViewBag.categoryid = categoryid; ViewBag.nodeid = nodeid; ViewBag.userid = userid; ViewBag.state = state; ViewBag.pagesize = pagesize; ViewBag.pageindex = pageindex; HttpContext.Session.SetString(sessionkey, new BSF.Serialization.JsonProvider().Serializer(ViewData)); #endregion tb_task_dal dal = new tb_task_dal(); PagedList <tb_tasklist_model> pageList = null; int count = 0; using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString)) { PubConn.Open(); List <tb_tasklist_model> List = dal.GetList(PubConn, taskid, keyword, CStime, CEtime, categoryid, nodeid, userid, state, pagesize, pageindex, out count); pageList = new PagedList <tb_tasklist_model>(List, pageindex, pagesize, count); List <tb_node_model> Node = new tb_node_dal().GetListAll(PubConn); List <tb_category_model> Category = new tb_category_dal().GetList(PubConn, ""); List <tb_user_model> User = new tb_user_dal().GetAllUsers(PubConn); ViewBag.Node = Node; ViewBag.Category = Category; ViewBag.User = User; } return View(pageList); })); }