public ActionResult GetEmpMenu() { string strJson = string.Empty; try { if (!WebCookieHelper.EmployeeCheckLogin()) { return(RedirectToAction("Admin/Account/Login")); } int nEmpID = WebCookieHelper.GetEmployeeId(); var menus = MenuServices.GetMenuByEmpID(nEmpID); if (menus.ToList().Count > 0) { strJson = JsonHelper.GetMenuJson(menus, 0); strJson = "{" + strJson + "}"; } else { strJson = "\"menus\":[]"; } //string strJson = "[{\"id\":\"1\",\"text\":\"hello1\",\"checked\":\"true\",\"state\":\"open\",\"children\":[{\"id\":\"2\",\"text\":\"hello2\",\"state\":\"open\"}]},{\"id\":\"1\",\"text\":\"hello1\",\"state\":\"open\",\"children\":[{\"id\":\"2\",\"text\":\"hello2\",\"state\":\"open\"}]}]"; } catch (Exception ex) { throw; } return(Content(strJson)); }
/// <summary> /// 添加或修改数据 /// </summary> public ActionResult UpdateData() { try { bool blResult = false; int id = Request.Form["id"] != "" ? Convert.ToInt32(Request.Form["id"]) : 0; Users model = GetData(id); string writeMsg = "操作失败!"; if (model != null) { if (id < 1) { if (WebCookieHelper.EmployeeCheckLogin()) { int empid = WebCookieHelper.GetEmployeeId(); model.EmployeeID = empid; //判断是否已经有相同号码的考生 if (EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.Tel == model.Tel).Count() > 0) { writeMsg = "存在相同的电话号码无法新增,请查看考生是否在预报名列表"; } else { EnterRepository.GetRepositoryEnter().UsersRepository.AddEntity(model); if (EnterRepository.GetRepositoryEnter().SaveChange() > 0) { writeMsg = "增加成功!"; } } } else { writeMsg = "请重新登录!"; } } else { //EnterRepository.GetRepositoryEnter().UsersRepository.Get(m => m.ID == id); EnterRepository.GetRepositoryEnter().UsersRepository.EditEntity(model, new string[] { "Name", "School", "ExamSchool", "Sequences", "Tel", "Baks", "PayMoney", "ExamPlace", "Room", "Hotel", "HotelExpense", "MoneyBack", "Gender", "Template", "PayPlace", "ExceptRoomie", "Status" }); if (EnterRepository.GetRepositoryEnter().SaveChange() > 0) { writeMsg = "更新成功!"; } else { writeMsg = "更新失败!"; } } } return(Content(writeMsg)); } catch (Exception ex) { throw; } }
public ActionResult Index() { if (!WebCookieHelper.EmployeeCheckLogin()) { return(Redirect("/Admin/Account/Login")); } ViewBag.Name = WebCookieHelper.GetEmployeeInfo((int)WebCookieHelper.EmployeeInfo.Name); return(View()); }
// // GET: /Employee/ public ActionResult Index(int?id) { if (!WebCookieHelper.EmployeeCheckLogin()) { string userAgent = Request.UserAgent; if (userAgent.ToLower().Contains("micromessenger")) { Utility.CookieHelper.SetCookie("returnurl", Request.Url.ToString(), "", 1); return(Redirect("/weixin/account")); } else { return(Redirect("/member/login?returnurl=" + Request.Url)); } } string tel = string.Empty; string name = string.Empty; string keyword = Request.QueryString["keyword"]; name = keyword; Pagination pagination = new Pagination(); int page = 1; if (id != null) { page = int.Parse(id.ToString()); } int totalCount = 0; pagination.Size = 30; pagination.ActionUrl = "employee/index"; pagination.CurrentPageIndex = page; DateTime startTime = DateTime.Now; int szEmployeeIDs = 0; int empid = WebCookieHelper.GetEmployeeId(); if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid)) { szEmployeeIDs = empid; } var lstUsers = EnterRepository.GetRepositoryEnter().UsersRepository.LoadPageList(szEmployeeIDs, empid, tel, name, (page - 1) * pagination.Size, pagination.Size, out totalCount).ToList(); string time = (DateTime.Now - startTime).TotalSeconds.ToString(); pagination.TotalCount = totalCount; pagination.Order = "Name"; pagination.Keyword = keyword; ViewBag.time = time; ViewBag.keyword = keyword; ViewBag.users = lstUsers; ViewBag.Pagination = pagination; return(View()); }
public ActionResult Order() { if (!WebCookieHelper.EmployeeCheckLogin()) { string userAgent = Request.UserAgent; if (userAgent.ToLower().Contains("micromessenger")) { Utility.CookieHelper.SetCookie("returnurl", Request.Url.ToString(), "", 1); return(Redirect("/weixin/account")); } else { return(Redirect("/member/login?returnurl=" + Request.Url)); } } var users = EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.EmployeeID == 0).OrderByDescending(m => m.ID).ToList(); ViewBag.users = users; return(View()); }
public ActionResult QueryEmployeeIDs() { try { if (!WebCookieHelper.EmployeeCheckLogin()) { return(RedirectToAction("Admin/Account/Login")); } JsonHelper json = new JsonHelper(); string strJson = string.Empty; json.AddItem("id", ""); json.AddItem("text", "所有"); json.ItemOk(); int empid = WebCookieHelper.GetEmployeeId(); string Name = WebCookieHelper.GetEmployeeInfo((int)WebCookieHelper.EmployeeInfo.Name); if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid)) { json.AddItem("id", empid.ToString()); json.AddItem("text", Name); json.ItemOk(); } else { var result = UsersServices.GetStaffEmployee(empid); foreach (Employee item in result) { json.AddItem("id", item.ID.ToString()); json.AddItem("text", item.Name); json.ItemOk(); } } strJson = json.ToEasyuiListJsonString(); return(Content(strJson)); } catch (Exception ex) { GlobalMethod.log.Error(ex); throw; } }
public ActionResult Export() { string jsons = ""; JsonHelper jsonHelper = new JsonHelper(); var Template = Request.Form["Template"]; var Name = Request.Form["Name"]; var szEmployeeID = Request.Form["EmployeeID"]; string filePath = string.Format("{0}{1}" , Server.MapPath(SystemContext.FilePath.Excel) , "test.xls"); if (!WebCookieHelper.EmployeeCheckLogin()) { return(Content("")); } int empid = WebCookieHelper.GetEmployeeId(); if (string.IsNullOrEmpty(szEmployeeID) || szEmployeeID == "所有") { szEmployeeID = "0"; } if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid)) { szEmployeeID = empid.ToString(); } try { var lstUser = EnterRepository.GetRepositoryEnter().UsersRepository.GetUsersList(int.Parse(szEmployeeID), empid, null, null); string templateValue = SystemContext.Template.GetTemplate(Template); ExcelHelper excelOpr = new ExcelHelper(); string[] columnName = templateValue.Split(','); List <ArrayList> values = new List <ArrayList>(); foreach (var user in lstUser) { ArrayList value = new ArrayList(); for (int j = 0; j < columnName.Length; j++) { value.Add(GetColumnValue(user, columnName[j])); } value.Add(""); values.Add(value); } excelOpr.ToExcel(filePath, columnName, values); jsons = "[{\"success\":true,msg:\"导出成功\",filePath:\"" + string.Format("{0}/{1}" , SystemContext.FilePath.Excel , "test.xls") + "\"}]"; } catch (Exception ex) { GlobalMethod.log.Error(ex); jsons = "[{\"success\":true,msg:\"导出失败\"}]"; } return(Content(jsons)); }
/// <summary> /// 查询数据 /// </summary> public ActionResult QueryData() { try { int page = Request.Form["page"] != "" ? Convert.ToInt32(Request.Form["page"]) : 0; int size = Request.Form["rows"] != "" ? Convert.ToInt32(Request.Form["rows"]) : 0; string sort = Request.Form["sort"] != "" ? Request.Form["sort"] : ""; string order = Request.Form["order"] != "" ? Request.Form["order"] : ""; string Template = Request.Form["Template"] != "" ? Request.Form["Template"] : ""; string szEmployeeIDs = !string.IsNullOrEmpty(Request.Form["EmployeeID"]) ? Request.Form["EmployeeID"] : "0"; string Name = Request.Form["Name"] != "" ? Request.Form["Name"] : ""; string Tel = Request.Form["Tel"] != "" ? Request.Form["Tel"] : ""; if (page < 1) { return(Content("")); } if (Name == "所有") { Name = string.Empty; } if (szEmployeeIDs == "所有") { szEmployeeIDs = "0"; } if (!WebCookieHelper.EmployeeCheckLogin()) { return(Content("")); } int empid = WebCookieHelper.GetEmployeeId(); if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid)) { szEmployeeIDs = empid.ToString(); } int rowCount = 0; var lstUsers = EnterRepository.GetRepositoryEnter().UsersRepository.LoadPageList(int.Parse(szEmployeeIDs), empid, Tel, Name, (page - 1) * size, size, out rowCount).ToList(); JsonHelper json = new JsonHelper(); string strJson = string.Empty; try { foreach (Users item in lstUsers) { item.Hotel = item.Hotel == null?"":item.Hotel.Replace("\t", ""); item.Tel = item.Tel == null ? "" : item.Tel.Replace("\n", ""); item.Baks = item.Baks == null ? "" : item.Baks.Replace("\n", ""); json.AddItem("ID", item.ID.ToString()); json.AddItem("Name", item.Name); json.AddItem("School", item.School); json.AddItem("ExamSchool", item.ExamSchool); json.AddItem("Sequences", item.Sequences.ToString()); json.AddItem("Tel", item.Tel); json.AddItem("Baks", item.Baks); json.AddItem("Pwd", item.Pwd); json.AddItem("PayMoney", item.PayMoney); json.AddItem("ExamPlace", item.ExamPlace); json.AddItem("Hotel", item.Hotel); json.AddItem("PassWord", item.Pwd); json.AddItem("PayMoney", item.PayMoney); json.AddItem("ExamPlace", item.ExamPlace); json.AddItem("Room", item.Room); json.AddItem("Hotel", item.Hotel); json.AddItem("HotelExpense", item.HotelExpense); json.AddItem("MoneyBack", item.MoneyBack); json.AddItem("EmployeeID", item.EmployeeID.ToString()); json.AddItem("EmployeeName", item.EmployeeName); json.AddItem("Gender", item.Gender); json.AddItem("Template", item.Template); json.AddItem("PayPlace", item.PayPlace); json.AddItem("CreateTime", item.CreateTime == null?DateTime.Now.ToString():item.CreateTime.ToString()); json.AddItem("ExceptRoomie", item.ExceptRoomie); json.AddItem("Status", item.Status); json.AddItem("Prize", item.Prize); json.ItemOk(); } } catch (Exception ex) { log.Error(ex); } json.totlalCount = rowCount; if (json.totlalCount > 0) { strJson = json.ToEasyuiGridJsonString(); } else { strJson = @"[]"; } // json = "{ \"rows\":[ { \"ID\":\"48\",\"NewsTitle\":\"mr\",\"NewsContent\":\"mrsoft\",\"CreateTime\":\"2013-12-23\",\"CreateUser\":\"ceshi\",\"ModifyTime\":\"2013-12-23\",\"ModifyUser\":\"ceshi\"} ],\"total\":3}"; return(Content(strJson)); } catch (Exception ex) { log.Error(ex); throw; } }