/// <summary> /// 出勤紀錄 /// </summary> /// <param name="EmpNo"></param> /// <param name="SDATE"></param> /// <returns></returns> public JsonResult Attendance(string EmpNo, string SDATE, string EDATE) { List <AppAttendanceModel> AppAttendanceList = null; AttendanceModelFactory ModelFactory = new AttendanceModelFactory(); SDATE = SDATE.Substring(0, 4) + "-" + SDATE.Substring(4, 2) + "-" + SDATE.Substring(6, 2); EDATE = EDATE.Substring(0, 4) + "-" + EDATE.Substring(4, 2) + "-" + EDATE.Substring(6, 2); DateTime cSDATE = DateTime.Parse(SDATE); DateTime cEDATE = DateTime.Parse(EDATE); AppAttendanceList = ModelFactory.GetAppAttendance(EmpNo, cSDATE, cEDATE); return(Json(AppAttendanceList, JsonRequestBehavior.AllowGet)); }
public JsonResult GetRA01ToExcel(ReportFormModel ReportForm) { //初始**** if (ReportForm.EmpNo == null) { ReportForm.EmpNo = ""; } if (ReportForm.Company == null) { ReportForm.Company = ""; } if (ReportForm.DepartMentNo == null) { ReportForm.DepartMentNo = ""; } if (ReportForm.EndDate == null) { ReportForm.EndDate = ""; } if (ReportForm.StartDate == null) { ReportForm.StartDate = ""; } if (ReportForm.EmpStatus == null) { ReportForm.EmpStatus = ""; } JsonresultModel ResultModel = new JsonresultModel(); ResultModel.Result = "0"; try { DataTable AttendanceDT = null; DateTime StartDate = DateTime.Parse(ReportForm.StartDate); DateTime EndDate = DateTime.Parse(ReportForm.EndDate); //取得出勤資料用 AttendanceModelFactory AttendanceModelFactory = new AttendanceModelFactory(); AttendanceDT = AttendanceModelFactory.GetAttendanceDataTable(2, ReportForm.Company, ReportForm.DepartMentNo, ReportForm.EmpNo, "", StartDate, EndDate, ReportForm.EmpStatus, 100000, 0); string filename = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx"; //SavePath=儲存路徑 string filenameStr = AppDomain.CurrentDomain.BaseDirectory.ToString() + "Download\\" + filename; using (MemoryStream msExcel = ReportAttendanceModelFactory.RA01ToExcel(AttendanceDT) as MemoryStream)// 新增試算表 { byte[] data = msExcel.ToArray(); using (FileStream fileStream = new FileStream(filenameStr, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.None)) { fileStream.Write(data, 0, data.Length); fileStream.Flush(); fileStream.Close(); } } //賦予報表位址 ExcelModel Excel = new ExcelModel(); Excel.Url = "../Download/" + filename; ResultModel.Result = "1"; ResultModel.Query = Excel; return(Json(ResultModel, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ResultModel, JsonRequestBehavior.AllowGet)); } }