public FileContentResult Download_StyleOfWorkTotalCount(int?deptID) { DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); int year = this.timeOverService.GetFirst().Year; List <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetList(ids, year); IList <ReviewDataObject> reviewList = this.reviewService.GetList(year); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("工号"), new DataColumn("姓名"), new DataColumn("没有"), new DataColumn("有些"), new DataColumn("很严重") } ); foreach (BeMeasuredDataObject bm in beMeasuredList) { DataRow row = dt.NewRow(); row["工号"] = bm.UserInfo.WorkNo; row["姓名"] = bm.UserInfo.UserName; row["没有"] = bm.StyleOfWorkList.Count((p) => { return(p.Score == 100); }); row["有些"] = bm.StyleOfWorkList.Count((p) => { return(p.Score == 80); }); row["很严重"] = bm.StyleOfWorkList.Count((p) => { return(p.Score == 50); }); dt.Rows.Add(row); } string fileName = "德和作风测评票数(" + dept.Name + ")"; byte[] buf = ExcelHelper.ExportToExcel(dt, fileName); return(File(buf, "application/octet-stream", Server.UrlEncode(fileName + ".xls"))); }
private ActionResult GetTotalCount(int?deptID, int?pageSize, int?pageIndex) { pageSize = pageSize ?? 20; if (pageIndex == null || pageIndex.Value < 1) { pageIndex = 1; } ViewResult view = new ViewResult(); JTPager pager = new JTPager() { Size = pageSize.Value, Index = pageIndex.Value }; int year = this.timeOverService.GetFirst()?.Year ?? DateTime.Now.Year; DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); IList <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetTotal(ids, year, pager); view.ViewData["PageSize"] = pager.Size; view.ViewData["PageIndex"] = pager.Index; view.ViewData["PageCount"] = pager.Count; view.ViewData["RecordCount"] = pager.Total; view.ViewData["DeptID"] = deptID.Value; view.ViewName = "EvaluationCountResult"; view.ViewData["BeMeasuredList"] = beMeasuredList; return(view); }
public FileContentResult Download_StyleOfWorkTotal(int?deptID) { DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); int year = this.timeOverService.GetFirst().Year; List <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetList(ids, year); IList <ReviewDataObject> reviewList = this.reviewService.GetList(year); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("工号"), new DataColumn("姓名"), new DataColumn("分数") }); foreach (BeMeasuredDataObject bm in beMeasuredList) { DataRow row = dt.NewRow(); row["工号"] = bm.UserInfo.WorkNo; row["姓名"] = bm.UserInfo.UserName; var query = bm.StyleOfWorkList.GroupBy(p => p.Ratio) .Select(p => new { Ratio = p.Key, Score = p.Sum(k => k.Score) * p.Key / 100 / p.Count() } ); row["分数"] = query.Sum(p => p.Score); dt.Rows.Add(row); } string fileName = "德和作风测评结果(" + dept.Name + ")"; byte[] buf = ExcelHelper.ExportToExcel(dt, fileName); return(File(buf, "application/octet-stream", Server.UrlEncode(fileName + ".xls"))); }
public string GetDepartmentTree(DepartmentDataObject parent = null) { IList <TreeNodeDataObject> treeNodes = this.departmentService.GetTreeNodes(); JArray arr = JArray.FromObject(treeNodes); return(arr.ToString()); }
public ActionResult DepartmentEdit(int?id, int?pageSize, int?pageIndex) { if (id == null || id.Value == 0) { return(RedirectToAction("ShowError", "Error", new { Msg = "请选择组织机构!" })); } if (pageSize == null || pageSize.Value <= 0) { pageSize = 20; } if (pageIndex == null || pageIndex.Value <= 0) { pageIndex = 1; } DepartmentDataObject dept = departmentService.GetOne(id.Value); int recordCount = dept.UserList.Count; int pageCount = (recordCount + pageSize.Value - 1) / pageSize.Value; if (pageIndex.Value > pageCount) { pageIndex = pageCount; } List <UserInfoDataObject> userList = dept.UserList.OrderBy(p => p.WorkNo).Skip((pageIndex.Value - 1) * pageSize.Value) .Take(pageSize.Value).ToList(); ViewData["Department"] = dept; ViewData["DeptList"] = departmentService.GetList(); ViewData["UserList"] = userList; ViewData["PageSize"] = pageSize.Value; ViewData["PageIndex"] = pageIndex.Value; ViewData["PageCount"] = pageCount; ViewData["RecordCount"] = recordCount; return(View()); }
public ActionResult AddUser(int?deptID, int?id, int?pageSize, int?pageIndex) { if (deptID == null) { return(Redirect(Request.UrlReferrer.ToString())); } JTPager pager = new JTPager(); pager.Size = pageSize == null || pageSize.Value <= 0 ? 20 : pageSize.Value; pager.Index = pageIndex == null || pageIndex.Value <= 0 ? 1 : pageIndex.Value; DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.UserList.Select(p => p.ID).ToArray(); IList <UserInfoDataObject> userList = this.userInfoService.GetList(ids, pager); ViewData["PageSize"] = pager.Size; ViewData["PageIndex"] = pager.Index; ViewData["PageCount"] = pager.Count; ViewData["RecordCount"] = pager.Total; ViewData["Department"] = dept; ViewData["UserList"] = userList; return(View()); }
public ActionResult StyleOfWorkTotalCount(int?deptID, int?pageSize, int?pageIndex) { pageSize = pageSize ?? 20; if (pageIndex == null || pageIndex.Value < 1) { pageIndex = 1; } DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); int year = this.timeOverService.GetFirst().Year; List <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetList(ids, year); int recordCount = beMeasuredList.Count(); int pageCount = (recordCount + pageSize.Value - 1) / pageSize.Value; if (pageIndex > pageCount) { pageIndex = pageCount; } IList <ReviewDataObject> reviewList = this.reviewService.GetList(year); beMeasuredList = beMeasuredList.Skip((pageIndex.Value - 1) * pageSize.Value).Take(pageSize.Value).ToList(); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("工号"), new DataColumn("姓名"), new DataColumn("没有"), new DataColumn("有些"), new DataColumn("很严重") } ); foreach (BeMeasuredDataObject bm in beMeasuredList) { DataRow row = dt.NewRow(); row["工号"] = bm.UserInfo.WorkNo; row["姓名"] = bm.UserInfo.UserName; row["没有"] = bm.StyleOfWorkList.Count((p) => { return(p.Score == 100); }); row["有些"] = bm.StyleOfWorkList.Count((p) => { return(p.Score == 80); }); row["很严重"] = bm.StyleOfWorkList.Count((p) => { return(p.Score == 50); }); dt.Rows.Add(row); } ViewResult view = new ViewResult(); view.ViewName = "EvaluationTotal"; view.ViewData["PageSize"] = pageSize.Value; view.ViewData["PageIndex"] = pageIndex.Value; view.ViewData["PageCount"] = pageCount; view.ViewData["RecordCount"] = recordCount; view.ViewData["DeptID"] = deptID.Value; view.ViewData["DataTable"] = dt; return(view); }
public FileContentResult Download_EvaluationTotal(int?deptID) { DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); int year = this.timeOverService.GetFirst().Year; List <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetList(ids, year); int recordCount = beMeasuredList.Count(); IList <ReviewDataObject> reviewList = this.reviewService.GetList(year); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("工号"), new DataColumn("姓名") }); foreach (ReviewDataObject review in reviewList) { dt.Columns.Add(new DataColumn(review.Name)); } dt.Columns.Add(new DataColumn("总分")); foreach (BeMeasuredDataObject bm in beMeasuredList) { DataRow row = dt.NewRow(); row["工号"] = bm.UserInfo.WorkNo; row["姓名"] = bm.UserInfo.UserName; double sum = 0; foreach (ReviewDataObject review in reviewList) { var query = bm.EvaluationTableList.GroupBy(p => p.Ratio) .Select(p => new { Ratio = p.Key, Score = p.Sum(k => k.EvaluationTableDetail.Where(t => t.ReviewID == review.ID).Sum(s => s.Score)) * p.Key / 100 / p.Count() }); double score = query.Sum(p => p.Score); row[review.Name] = score; sum += score; } row["总分"] = sum; dt.Rows.Add(row); } string fileName = "民主测评总评(" + dept.Name + ")"; byte[] buf = ExcelHelper.ExportToExcel(dt, fileName); return(File(buf, "application/octet-stream", Server.UrlEncode(fileName + ".xls"))); }
public FileContentResult Download_GetStyleOfWorkCount(int?deptID) { int year = this.timeOverService.GetFirst()?.Year ?? DateTime.Now.Year; DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); List <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetList(ids, year); List <double> ratios = new List <double>(); beMeasuredList.ForEach( item => ratios.AddRange(item.MeasuredList.GroupBy(p => p.Ratio).Select(p => p.Key).ToArray()) ); ratios = ratios.Distinct().OrderBy(p => - p).ToList(); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("工号"), new DataColumn("姓名") }); foreach (double ratio in ratios) { dt.Columns.Add(new DataColumn(string.Format("{0}%投票人数", ratio))); } foreach (BeMeasuredDataObject bm in beMeasuredList) { DataRow row = dt.NewRow(); row["工号"] = bm.UserInfo.WorkNo; row["姓名"] = bm.UserInfo.UserName; foreach (double ratio in ratios) { row[string.Format("{0}%投票人数", ratio)] = bm.StyleOfWorkList.Where(p => p.Ratio == ratio && p.Score > 0).Count(); } dt.Rows.Add(row); } string fileName = string.Format("德和作风({0})投票数", dept.Name); byte[] buf = ExcelHelper.ExportToExcel(dt, fileName); return(File(buf, "application/octet-stream", Server.UrlEncode(fileName + ".xls"))); }
public ActionResult ImportUserInfo(HttpPostedFileBase file) { if (file == null) { return(View()); } MemoryStream ms = new MemoryStream(); file.InputStream.CopyTo(ms); DataTable dt = ExcelHelper.ImportExcel(ms); IList <UserInfoDataObject> list = new List <UserInfoDataObject>(); IList <DepartmentDataObject> deptList = this.departmentService.GetList(); IList <DutiesDataObject> dutiesList = this.dutiesService.GetList(); foreach (DataRow row in dt.Rows) { UserInfoDataObject userInfo = new UserInfoDataObject(); userInfo.WorkNo = row[0].ToString(); userInfo.UserName = row[1].ToString(); userInfo.Password = "******"; DepartmentDataObject dept = deptList.FirstOrDefault(p => p.Name == row[2].ToString()); userInfo.DepartmentID = dept == null ? 0 : dept.ID; userInfo.Professional = row[3].ToString(); DutiesDataObject duty = dutiesList.FirstOrDefault(p => p.Name == row[4].ToString()); userInfo.DutiesID = duty == null ? 0 : duty.ID; userInfo.MajorLeader = row[5].ToString() == "是" ? true : false; userInfo.Director = row[6].ToString() == "是"; userInfo.Instructor = row[7].ToString() == "是"; userInfo.Secretary = row[8].ToString() == "是"; list.Add(userInfo); } int count = this.userInfoService.Import(list); ViewData["Msg"] = string.Format("{0}条数据导入成功!", count); return(View()); }
public ActionResult EvaluationTotal(int?deptID, int?pageSize, int?pageIndex) { pageSize = pageSize ?? 20; if (pageIndex == null || pageIndex.Value < 1) { pageIndex = 1; } DepartmentDataObject dept = this.departmentService.GetOne(deptID.Value); int[] ids = dept.GetIDArray(); int year = this.timeOverService.GetFirst().Year; List <BeMeasuredDataObject> beMeasuredList = this.beMeasuredService.GetList(ids, year); int recordCount = beMeasuredList.Count(); int pageCount = (recordCount + pageSize.Value - 1) / pageSize.Value; if (pageIndex > pageCount) { pageIndex = pageCount; } IList <ReviewDataObject> reviewList = this.reviewService.GetList(year); beMeasuredList = beMeasuredList.Skip((pageIndex.Value - 1) * pageSize.Value).Take(pageSize.Value).ToList(); DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("工号"), new DataColumn("姓名") }); foreach (ReviewDataObject review in reviewList) { dt.Columns.Add(new DataColumn(review.Name)); } dt.Columns.Add(new DataColumn("总分")); foreach (BeMeasuredDataObject bm in beMeasuredList) { DataRow row = dt.NewRow(); row["工号"] = bm.UserInfo.WorkNo; row["姓名"] = bm.UserInfo.UserName; double sum = 0; foreach (ReviewDataObject review in reviewList) { var query = bm.EvaluationTableList.GroupBy(p => p.Ratio) .Select(p => new { Ratio = p.Key, Score = p.Sum(k => k.EvaluationTableDetail.Where(t => t.ReviewID == review.ID).Sum(s => s.Score)) * p.Key / 100 / p.Count() }); double score = query.Sum(p => p.Score); row[review.Name] = score; sum += score; } row["总分"] = sum; dt.Rows.Add(row); } ViewResult view = new ViewResult(); view.ViewName = "EvaluationTotal"; view.ViewData["PageSize"] = pageSize.Value; view.ViewData["PageIndex"] = pageIndex.Value; view.ViewData["PageCount"] = pageCount; view.ViewData["RecordCount"] = recordCount; view.ViewData["DeptID"] = deptID.Value; view.ViewData["DataTable"] = dt; return(view); }
public ActionResult SaveDepartment(DepartmentDataObject department) { department = departmentService.Update(department); return(RedirectToAction("DepartmentEdit", "Department", new { id = department.ID })); }