/// <summary> /// 匯出EXCEL /// </summary> //------------------------------------------------------------------------------ public ActionResult GetExportData(string deptAbbreviate = null, string deptName = null) { var depts = DeptDataAccess.GetExportData(deptAbbreviate, deptName); using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(depts); wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; wb.Style.Font.Bold = true; Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename= EmployeeReport.xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } //return RedirectToAction("Index", "ExportData"); return(View()); }
/// <summary> /// 新增部門資料 /// </summary> /// <param name="uData"></param> /// <returns></returns> public string NewDeptData(DeptDataEntity uData) { uData.deptID = Guid.NewGuid().ToString(); var depts = new List <DeptDataEntity>() { uData }; DeptDataAccess.AddDeptData(depts); return(JsonConvert.SerializeObject(new { success = true, errorMsg = "" })); }
/// <summary> /// 刪除店家資料 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult DeleteDeptData(string deptID) { var errorMsg = string.Empty; var isSuccess = true; try { DeptDataAccess.DeleteDeptData(deptID); } catch (Exception ex) { isSuccess = false; errorMsg = ex.Message.Replace("\n", ""); } return(Json(new { success = isSuccess, errorMsg = errorMsg })); }
/// <summary> /// 取得部門員工資料 /// </summary> /// <returns></returns> public ActionResult GetUserNameData(string deptID = null) { var depts = DeptDataAccess.GetUserNameData(deptID); //var q = (order.ToUpper() == "ASC") ? // depts.OrderBy(x => x.deptAbbreviate).ToList() : // depts.OrderByDescending(x => x.deptAbbreviate).ToList(); //var offset = rows * (page - 1); //q = q.Skip(offset).Take(rows).ToList(); //var result = new { total = depts.Count, rows = q }; return(Json(depts, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 取得所有部門資料 /// </summary> /// <returns></returns> public ActionResult GetDeptData(string sort, string order, int page, int rows, string deptAbbreviate = null, string deptName = null) { var depts = DeptDataAccess.GetDeptData(deptAbbreviate, deptName); var q = (order.ToUpper() == "ASC") ? depts.OrderBy(x => x.deptAbbreviate).ToList() : depts.OrderByDescending(x => x.deptAbbreviate).ToList(); var offset = rows * (page - 1); q = q.Skip(offset).Take(rows).ToList(); var result = new { total = depts.Count, rows = q }; return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 修改部門資料 /// </summary> /// <param name="uData"></param> /// <returns></returns> public string EditDeptData(DeptDataEntity uData) { var depts = new List <DeptDataEntity>() { uData }; var errorMsg = string.Empty; var isSuccess = true; try { DeptDataAccess.UpdateDeptData(depts); } catch (Exception ex) { isSuccess = false; errorMsg = ex.Message.Replace("\n", ""); } return(JsonConvert.SerializeObject(new { success = isSuccess, errorMsg = errorMsg })); }