/// <summary> /// 导出日志列表 /// </summary> /// <param name="objectTypeID">角色ID</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索框填写内容</param> /// <param name="field">排序字段</param> /// <param name="direction">排序方式</param> /// <param name="startDate">请求开始日期</param> /// <param name="endDate">请求结束日期</param> /// <returns>日志列表excel</returns> public ActionResult ExportSysAuditLogList(int objectTypeID, string filterField, string filterText, string field, bool direction, string startDate, string endDate) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { DateTime _startDate = (DateTime)SqlDateTime.MinValue; DateTime _endDate = DateTime.Now; BaseDao.ProcessFieldFilterValue(filterField, ref filterText); if (!string.IsNullOrEmpty(startDate)) { _startDate = Convert.ToDateTime(startDate); } if (!string.IsNullOrEmpty(endDate)) { _endDate = Convert.ToDateTime(endDate); } UserInfo userInfo = GetLoginUser(); List <AuditHdrInfo> infos = this.auditLogDao.QuerySysAuditLogs(objectTypeID, filterField, filterText, field, direction, _startDate, _endDate, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("用户姓名"); dt.Columns.Add("操作时间"); dt.Columns.Add("操作类型"); dt.Columns.Add("对象类型"); dt.Columns.Add("对象系统编号"); foreach (AuditHdrInfo info in infos) { dt.Rows.Add(info.OID, info.TransUser.Name, info.UpdateDate.ToString("yyyy-MM-dd"), info.Operation.Name, info.ObjectType.Name, info.ObjectOID); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "日志列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(JsonResult(result)); }
/// <summary> /// 导出设备清单 /// </summary> /// <param name="equipmentType">设备类别</param> /// <param name="amountType">金额</param> /// <param name="equipmentName">设备名称</param> /// <param name="serialCode">设备序列号</param> /// <param name="departmentName">科室名称</param> /// <param name="class1ID">富士I类id</param> /// <param name="class2ID">腐蚀II类id</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>设备清单</returns> public ActionResult ExportValEquipments(int equipmentType, int amountType, string equipmentName, string serialCode, string departmentName, int class1ID, int class2ID, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModel <List <ValEquipmentInfo> > result = new ResultModel <List <ValEquipmentInfo> >(); try { BaseDao.ProcessFieldFilterValue(filterField, ref filterText); List <ValEquipmentInfo> infos = this.valuationDao.QueryEquipmentList(GetLoginUser().ID, equipmentType, amountType, equipmentName, serialCode, departmentName, class1ID, class2ID, filterField, filterText, sortField, sortDirection); DataTable dt = new DataTable(); dt.Columns.Add("是否在系统中"); dt.Columns.Add("系统编号"); dt.Columns.Add("资产编号"); dt.Columns.Add("名称"); dt.Columns.Add("设备序列号"); dt.Columns.Add("厂商"); dt.Columns.Add("科室"); dt.Columns.Add("金额"); dt.Columns.Add("设备类型"); dt.Columns.Add("富士I类"); dt.Columns.Add("富士II类"); dt.Columns.Add("目前维保种类"); dt.Columns.Add("维保到期日"); dt.Columns.Add("下期维保种类"); foreach (ValEquipmentInfo info in infos) { dt.Rows.Add(info.InSystem ? 'Y' : 'N', info.Equipment.OID, info.Equipment.AssetCode, info.Equipment.Name, info.Equipment.SerialCode, info.Equipment.Manufacturer.Name, info.Equipment.Department.Name, info.Equipment.PurchaseAmount, info.Equipment.FujiClass2.EquipmentType.Name, info.Equipment.FujiClass2.FujiClass1.Name, info.Equipment.FujiClass2.Name, info.CurrentScope.Name, info.EndDate == DateTime.MinValue ? "" : info.EndDate.ToString("yyyy-MM-dd"), info.NextScope.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "估价执行:设备清单.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出派工单列表 /// </summary> /// <param name="status">派工单状态</param> /// <param name="urgency">派工单紧急程度</param> /// <param name="type">派工类型</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索框填写内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>派工单列表的excel</returns> public ActionResult ExportDispatches(int status, int urgency, int type, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { UserInfo userInfo = new UserInfo(); userInfo = GetLoginUser(); List <DispatchInfo> dispatches = null; BaseDao.ProcessFieldFilterValue(filterField, ref filterText); dispatches = this.dispatchManager.QueryDispatches(userInfo.ID, userInfo.Role.ID, status, urgency, type, filterField, filterText, sortField, sortDirection, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("派工单编号"); dt.Columns.Add("请求编号"); dt.Columns.Add("设备系统编号"); dt.Columns.Add("设备名称"); dt.Columns.Add("派工类型"); dt.Columns.Add("紧急程度"); dt.Columns.Add("派工日期"); dt.Columns.Add("结束日期"); dt.Columns.Add("状态"); foreach (DispatchInfo dispatch in dispatches) { dt.Rows.Add(dispatch.OID, dispatch.Request.OID, dispatch.Request.EquipmentOID, dispatch.Request.EquipmentName, dispatch.RequestType.Name, dispatch.Urgency.Name, dispatch.ScheduleDate.ToString("yyyy-MM-dd"), dispatch.EndDate == DateTime.MinValue ? "" : dispatch.EndDate.ToString("yyyy-MM-dd"), dispatch.Status.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "派工单.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportRequestsList(int status, int requestType, bool isRecall, int department, int urgency, bool overDue, int source, string filterField, string filterText, string field, bool direction, string startDate = "", string endDate = "") { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModel <List <RequestInfo> > result = new ResultModel <List <RequestInfo> >(); try { BaseDao.ProcessFieldFilterValue(filterField, ref filterText); List <RequestInfo> infos = new List <RequestInfo>(); infos = this.requestManager.QueryRequestsList(status, requestType, isRecall, department, urgency, overDue, source, filterField, filterText, field, direction, 0, 0, startDate, endDate); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("请求编号"); dt.Columns.Add("设备系统编号"); dt.Columns.Add("设备名称"); dt.Columns.Add("科室"); dt.Columns.Add("请求人"); dt.Columns.Add("请求日期"); dt.Columns.Add("择期日期"); dt.Columns.Add("请求来源"); dt.Columns.Add("类型"); dt.Columns.Add("状态"); foreach (RequestInfo requestInfo in infos) { dt.Rows.Add(requestInfo.OID, requestInfo.EquipmentOID, requestInfo.EquipmentName, requestInfo.Equipments.Count > 0?requestInfo.Equipments[0].Department.Name:"", requestInfo.RequestUser.Name, requestInfo.RequestDate.ToString("yyyy-MM-dd"), requestInfo.SelectiveDate == DateTime.MinValue ? "" : requestInfo.SelectiveDate.ToString("yyyy-MM-dd"), requestInfo.Source.Name, requestInfo.RequestType.Name, requestInfo.Status.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "客户请求列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportUsersList(int status, int roleId, int verifyStatusID, string filterField, string filterText, string field, bool direction) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModel <List <UserInfo> > result = new ResultModel <List <UserInfo> >(); try { List <UserInfo> infos = null; infos = this.userDao.QueryUsers(status, roleId, verifyStatusID, filterField, filterText, field, direction, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("用户名"); dt.Columns.Add("角色"); dt.Columns.Add("姓名"); dt.Columns.Add("电话"); dt.Columns.Add("邮箱"); dt.Columns.Add("地址"); dt.Columns.Add("添加日期"); dt.Columns.Add("状态"); dt.Columns.Add("审批状态"); foreach (UserInfo userInfo in infos) { dt.Rows.Add(userInfo.LoginID, userInfo.Role.Name, userInfo.Name, userInfo.Mobile, userInfo.Email, userInfo.Address, userInfo.CreatedDate.ToShortDateString(), (userInfo.IsActive ? "启用" : "停用"), userInfo.VerifyStatus.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "用户列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出零件信息 /// </summary> /// <param name="statusID">状态</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>零件列表excel</returns> public ActionResult ExportComponents(int statusID, string filterField, string filterText, string sortField, bool sortDirection, string eqptID = "") { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <InvComponentInfo> invComponents = this.invComponentDao.QueryComponents(statusID, filterField, filterText, sortField, sortDirection, 0, 0, eqptID); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("序列号"); dt.Columns.Add("简称"); dt.Columns.Add("描述"); dt.Columns.Add("类型"); dt.Columns.Add("设备系统编号"); dt.Columns.Add("设备名称"); dt.Columns.Add("供应商"); dt.Columns.Add("单价(元)"); dt.Columns.Add("购入日期"); dt.Columns.Add("采购单号"); dt.Columns.Add("状态"); foreach (InvComponentInfo invComponent in invComponents) { dt.Rows.Add(invComponent.OID, invComponent.SerialCode, invComponent.Component.Name, invComponent.Component.Description, invComponent.Component.Type.Name, invComponent.Equipment.OID, invComponent.Equipment.Name, invComponent.Supplier.Name, invComponent.Price, invComponent.PurchaseDate.ToString("yyyy-MM-dd"), invComponent.Purchase.ID == 0 ? "" : invComponent.Purchase.Name, invComponent.Status.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "零件库列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出供应商列表信息 /// </summary> /// <param name="typeID">供应商类型</param> /// <param name="status">供应商状态</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索框填写内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>供应商列表excel</returns> public ActionResult ExportSupplierList(int typeID, int status, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModel <List <SupplierInfo> > result = new ResultModel <List <SupplierInfo> >(); try { List <SupplierInfo> infos = null; BaseDao.ProcessFieldFilterValue(filterField, ref filterText); infos = this.supplierDao.QuerySupplier(typeID, status, filterField, filterText, sortField, sortDirection, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("供应商名称"); dt.Columns.Add("类型"); dt.Columns.Add("省份"); dt.Columns.Add("地址"); dt.Columns.Add("联系人"); dt.Columns.Add("联系人电话"); dt.Columns.Add("添加日期"); dt.Columns.Add("状态"); foreach (SupplierInfo supplierInfo in infos) { dt.Rows.Add(supplierInfo.OID, supplierInfo.Name, supplierInfo.SupplierType.Name, supplierInfo.Province, supplierInfo.Address, supplierInfo.Contact, supplierInfo.ContactMobile, supplierInfo.AddDate.ToString("yyyy-MM-dd"), (supplierInfo.IsActive ? "启用" : "停用")); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "供应商列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportContracts(int status, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <ContractInfo> contracts = null; BaseDao.ProcessFieldFilterValue(filterField, ref filterText); contracts = this.contractManager.QueryContracts(status, filterField, filterText, sortField, sortDirection); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("合同编号"); dt.Columns.Add("设备编号"); dt.Columns.Add("设备序列号"); dt.Columns.Add("合同名称"); dt.Columns.Add("合同类型"); dt.Columns.Add("供应商"); dt.Columns.Add("开始时间"); dt.Columns.Add("结束时间"); dt.Columns.Add("状态"); foreach (ContractInfo contract in contracts) { dt.Rows.Add(contract.OID, contract.ContractNum, contract.EquipmentOID, contract.EquipmentSerialCode, contract.Name, contract.Type.Name, contract.Supplier.Name, contract.StartDate.ToString("yyyy-MM-dd"), contract.EndDate.ToString("yyyy-MM-dd"), contract.Status); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "合同列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出服务信息 /// </summary> /// <param name="statusID">状态</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>服务列表excel</returns> public ActionResult ExportServices(int statusID, string filterField, string filterText, string sortField, bool sortDirection, int fujiClass2ID = 0) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { BaseDao.ProcessFieldFilterValue(filterField, ref filterText); List <InvServiceInfo> invServices = this.invServiceDao.QueryServices(statusID, filterField, filterText, sortField, sortDirection, 0, 0, fujiClass2ID); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("服务名称"); dt.Columns.Add("关联富士II类"); dt.Columns.Add("供应商"); dt.Columns.Add("服务次数"); dt.Columns.Add("服务开始日期"); dt.Columns.Add("服务结束日期"); dt.Columns.Add("金额"); dt.Columns.Add("剩余服务次数"); dt.Columns.Add("采购单号"); dt.Columns.Add("状态"); foreach (InvServiceInfo invService in invServices) { dt.Rows.Add(invService.OID, invService.Name, invService.FujiClass2.Name, invService.Supplier.Name, invService.TotalTimes, invService.AddDate.ToString("yyyy-MM-dd"), invService.EndDate.ToString("yyyy-MM-dd"), invService.Price, invService.AvaibleTimes, invService.Purchase.ID == 0 ? "" : invService.Purchase.Name, invService.Status); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "服务库列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出广播列表excel /// </summary> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索框填写内容</param> /// <returns>广播列表excel</returns> public ActionResult ExportNoticesList(string filterField, string filterText) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModel <List <NoticeInfo> > result = new ResultModel <List <NoticeInfo> >(); try { List <NoticeInfo> infos = null; BaseDao.ProcessFieldFilterValue(filterField, ref filterText); infos = this.noticeDao.QueryNotices(filterField, filterText, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("广播编号"); dt.Columns.Add("广播名称"); dt.Columns.Add("添加时间"); dt.Columns.Add("广播内容"); dt.Columns.Add("备注"); dt.Columns.Add("是否轮播"); foreach (NoticeInfo noticeInfo in infos) { dt.Rows.Add(noticeInfo.OID, noticeInfo.Name, noticeInfo.CreatedDate, noticeInfo.Content, noticeInfo.Comments, noticeInfo.IsLoop ? '是' : '否'); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "广播列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出耗材信息 /// </summary> /// <param name="fujiClass2ID">富士II类ID</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>耗材列表excel</returns> public ActionResult ExportConsumables(int fujiClass2ID, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <InvConsumableInfo> invConsumables = this.invConsumableDao.QueryConsumables(fujiClass2ID, filterField, filterText, sortField, sortDirection, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("批次号"); dt.Columns.Add("简称"); dt.Columns.Add("描述"); dt.Columns.Add("供应商"); dt.Columns.Add("富士II类"); dt.Columns.Add("单价(元)"); dt.Columns.Add("购入日期"); dt.Columns.Add("采购单号"); dt.Columns.Add("数量"); foreach (InvConsumableInfo invConsumable in invConsumables) { dt.Rows.Add(invConsumable.OID, invConsumable.LotNum, invConsumable.Consumable.Name, invConsumable.Consumable.Description, invConsumable.Supplier.Name, invConsumable.Consumable.FujiClass2.Name, invConsumable.Price, invConsumable.PurchaseDate.ToString("yyyy-MM-dd"), invConsumable.Purchase.ID == 0 ? "" : invConsumable.Purchase.Name, invConsumable.AvaibleQty); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "耗材库列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult RunCustRpt(CustomReportInfo info, string field, DateTime startTime, DateTime endTime) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { endTime = endTime.AddDays(1); DataTable infoList = new DataTable(); if (info.Type.ID == CustomReportInfo.CustRptType.Equipment) { infoList = this.customRptManager.QueryCustRpt4Equipment(info, field, startTime, endTime); } if (info.Type.ID == CustomReportInfo.CustRptType.Contract) { infoList = this.customRptManager.QueryCustRpt4Contract(info, field, startTime, endTime); } if (info.Type.ID == CustomReportInfo.CustRptType.Request) { infoList = this.customRptManager.QueryCustRpt4Request(info, field, startTime, endTime); } if (info.Type.ID == CustomReportInfo.CustRptType.Dispatch) { infoList = this.customRptManager.QueryCustRpt4Dispatch(info, field, startTime, endTime); } MemoryStream ms = ExportUtil.ToExcel(infoList); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", info.Name + ".xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportFujiClass2s(int class1, int class2, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <FujiClass2Info> fujiClass2s = this.fujiClassManager.QueryFujiClass2s(class1, class2, filterField, filterText, sortField, sortDirection); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("富士I类"); dt.Columns.Add("富士II类简称"); dt.Columns.Add("富士II类描述"); dt.Columns.Add("人工费"); dt.Columns.Add("维保服务费"); dt.Columns.Add("备用机成本"); dt.Columns.Add("维保额外维修费"); dt.Columns.Add("零件"); dt.Columns.Add("耗材"); foreach (FujiClass2Info fujiClass2 in fujiClass2s) { dt.Rows.Add(fujiClass2.FujiClass1.Name, fujiClass2.Name, fujiClass2.Description, fujiClass2.IncludeLabour?"有":"无", fujiClass2.IncludeContract ? "有" : "无", fujiClass2.IncludeSpare ? "有" : "无", fujiClass2.IncludeRepair ? "有" : "无", (fujiClass2.Components != null && fujiClass2.Components.Count > 0)?"有" : "无", (fujiClass2.Consumables != null && fujiClass2.Consumables.Count > 0)?"有" : "无"); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "富士II类列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出耗材列表 /// </summary> /// <param name="statusID">耗材状态</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <returns>耗材定义excel</returns> public ActionResult ExportConsumables(int statusID, string filterField, string filterText) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <ConsumableInfo> consumables = this.consumableDao.QueryConsumables(statusID, filterField, filterText, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("富士II类"); dt.Columns.Add("简称"); dt.Columns.Add("描述"); dt.Columns.Add("类型"); dt.Columns.Add("标准单价(元)"); dt.Columns.Add("是否参与估值"); dt.Columns.Add("更换频率(次/年)"); dt.Columns.Add("单次保养耗材成本(元)"); dt.Columns.Add("状态"); foreach (ConsumableInfo consumable in consumables) { dt.Rows.Add(consumable.FujiClass2.Name, consumable.Name, consumable.Description, consumable.Type.Name, consumable.StdPrice, consumable.IsIncluded ? "是" : "否", consumable.ReplaceTimes, consumable.CostPer, consumable.IsActive ? "启用" : "停用"); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "耗材定义列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportCustRpt(int typeID, string filterField, string filterText) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { BaseDao.ProcessFieldFilterValue(filterField, ref filterText); List <CustomReportInfo> CustRpts = this.customRptDao.QueryCustRptsList(typeID, filterField, filterText, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("编号"); dt.Columns.Add("类别"); dt.Columns.Add("名称"); dt.Columns.Add("创建人"); dt.Columns.Add("创建日期"); dt.Columns.Add("更改日期"); dt.Columns.Add("上次运行日期"); foreach (CustomReportInfo custRpt in CustRpts) { dt.Rows.Add(custRpt.OID, custRpt.Type.Name, custRpt.Name, custRpt.CreateUser.Name, custRpt.CreatedDate.ToString("yyyy-MM-dd"), custRpt.UpdateDate == DateTime.MinValue ? "" : custRpt.UpdateDate.ToString("yyyy-MM-dd"), custRpt.LastRunDate == DateTime.MinValue ? "" : custRpt.LastRunDate.ToString("yyyy-MM-dd")); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "自定义报表列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出科室列表 /// </summary> /// <param name="departmentTypeID">科室分类编号</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <param name="field">排序字段</param> /// <param name="direction">排序方式</param> /// <returns>科室列表excel</returns> public ActionResult ExportDepartmentList(int departmentTypeID, string filterField, string filterText, string field, bool direction) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModel <List <DepartmentInfo> > result = new ResultModel <List <DepartmentInfo> >(); try { List <DepartmentInfo> infos = this.departmentDao.QueryDepartments(departmentTypeID, filterField, filterText, field, direction, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("科室系统编号"); dt.Columns.Add("科室排序"); dt.Columns.Add("科室名称"); dt.Columns.Add("科室拼音简称"); dt.Columns.Add("科室分类"); foreach (DepartmentInfo info in infos) { dt.Rows.Add(info.OID, info.Seq, info.Description, info.Pinyin, info.DepartmentType.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "科室列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出采购单信息 /// </summary> /// <param name="statusID">状态</param> /// <param name="filterField">搜索字段</param> /// <param name="filterText">搜索内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>采购单列表excel</returns> public ActionResult ExportPurchaseOrders(int statusID, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { BaseDao.ProcessFieldFilterValue(filterField, ref filterText); List <PurchaseOrderInfo> purchaseOrders = this.purchaseOrderDao.QueryPurchaseOrders(statusID, filterField, filterText, sortField, sortDirection, 0, 0); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("请求人"); dt.Columns.Add("供应商"); dt.Columns.Add("采购日期"); dt.Columns.Add("到货日期"); dt.Columns.Add("状态"); foreach (PurchaseOrderInfo purchaseOrder in purchaseOrders) { dt.Rows.Add(purchaseOrder.OID, purchaseOrder.User.Name, purchaseOrder.Supplier.Name, purchaseOrder.OrderDate.ToString("yyyy-MM-dd"), purchaseOrder.DueDate.ToString("yyyy-MM-dd"), purchaseOrder.Status.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "采购单列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出富士类别 /// </summary> /// <param name="EquipmentClass1Name">设备类别1</param> /// <param name="EquipmentClass2Name">设备类别2</param> /// <param name="FujiClass1ID">富士I类id</param> /// <param name="FujiClass2ID">富士II类id</param> /// <returns>零件列表excel</returns> public ActionResult ExportFujiClass(string EquipmentClass1Name, string EquipmentClass2Name, int FujiClass1ID, int FujiClass2ID) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <FujiClassLink> infos = this.fujiClassDao.QueryFujiClass(EquipmentClass1Name, EquipmentClass2Name, FujiClass1ID, FujiClass2ID); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("设备类型I简称"); dt.Columns.Add("设备类型II简称"); dt.Columns.Add("富士I类简称"); dt.Columns.Add("富士II类简称"); foreach (FujiClassLink info in infos) { dt.Rows.Add(info.EquipmentType1.Description, info.EquipmentType2.Description, info.FujiClass2.FujiClass1.Name, info.FujiClass2.Name); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "富士类别.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出设备列表信息 /// </summary> /// <param name="status">设备状态</param> /// <param name="warrantyStatus">维保状态</param> /// <param name="departmentID">设备科室编号</param> /// <param name="filterTextName">设备名称</param> /// <param name="filterTextSerialCode">设备序列号</param> /// <param name="useStatus">设备使用状态</param> /// <param name="searchField">搜索字段</param> /// <param name="searchValue">搜索框填写内容</param> /// <param name="sortField">排序字段</param> /// <param name="sortDirection">排序方式</param> /// <returns>设备列表信息excel</returns> public ActionResult ExportEquipments(int status, int warrantyStatus, int departmentID, string filterTextName, string filterTextSerialCode, bool useStatus, string filterField, string filterText, string sortField, bool sortDirection) { if (CheckSession() == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } ResultModelBase result = new ResultModelBase(); try { List <EquipmentInfo> equipments = null; BaseDao.ProcessFieldFilterValue(filterField, ref filterText); equipments = this.equipmentDao.QueryEquipments(status, warrantyStatus, departmentID, filterTextName, filterTextSerialCode, useStatus, filterField, filterText, sortField, sortDirection); DataTable dt = new DataTable("Sheet1"); dt.Columns.Add("系统编号"); dt.Columns.Add("设备名称"); dt.Columns.Add("设备型号"); dt.Columns.Add("设备序列号"); dt.Columns.Add("厂商"); dt.Columns.Add("标准响应时间(分)"); dt.Columns.Add("等级"); dt.Columns.Add("设备类别 (I)"); dt.Columns.Add("设备类别 (II)"); dt.Columns.Add("设备类别 (III)"); dt.Columns.Add("分类编码"); dt.Columns.Add("整包范围"); dt.Columns.Add("品牌"); dt.Columns.Add("出厂日期"); dt.Columns.Add("备注"); dt.Columns.Add("固定资产"); dt.Columns.Add("资产等级"); dt.Columns.Add("注册证有效日期"); dt.Columns.Add("资产编号"); dt.Columns.Add("折旧年限(年)"); dt.Columns.Add("销售合同名称"); dt.Columns.Add("购入方式"); dt.Columns.Add("采购日期"); dt.Columns.Add("经销商"); dt.Columns.Add("采购金额(元)"); dt.Columns.Add("设备产地"); dt.Columns.Add("使用科室"); dt.Columns.Add("安装地点"); dt.Columns.Add("安装日期"); dt.Columns.Add("启用日期"); dt.Columns.Add("验收状态"); dt.Columns.Add("验收时间"); dt.Columns.Add("使用状态"); dt.Columns.Add("设备状态"); dt.Columns.Add("维保状态"); dt.Columns.Add("强检标记"); dt.Columns.Add("强检时间"); dt.Columns.Add("召回标记"); dt.Columns.Add("召回时间"); dt.Columns.Add("巡检周期"); dt.Columns.Add("保养周期"); dt.Columns.Add("校准周期"); foreach (EquipmentInfo equipment in equipments) { dt.Rows.Add(equipment.OID, equipment.Name, equipment.EquipmentCode, equipment.SerialCode, equipment.Manufacturer.Name, equipment.ResponseTimeLength, equipment.EquipmentLevel.Name, equipment.EquipmentClass1.Description, equipment.EquipmentClass2.Description, equipment.EquipmentClass3.Description, equipment.ClassCode, equipment.ServiceScope == true? "是":"否", equipment.Brand, equipment.ManufacturingDate == DateTime.MinValue ? "" : equipment.ManufacturingDate.ToString("yyyy-MM-dd"), equipment.Comments, equipment.FixedAsset == true? "是":"否", equipment.AssetLevel.Name, equipment.ValidityStartDate == DateTime.MinValue ? "" : equipment.ValidityStartDate.ToString("yyyy-MM-dd") + " - " + equipment.ValidityEndDate.ToString("yyyy-MM-dd"), equipment.AssetCode, equipment.DepreciationYears, equipment.SaleContractName, equipment.PurchaseWay, equipment.PurchaseDate.ToString("yyyy-MM-dd"), equipment.Supplier.Name, equipment.PurchaseAmount, equipment.IsImport == true ? "进口" : "国产", equipment.Department.Name, equipment.InstalSite, equipment.InstalDate.ToString("yyyy-MM-dd"), equipment.UseageDate == DateTime.MinValue ? "" : equipment.UseageDate.ToString("yyyy-MM-dd"), equipment.Accepted == true ? "已验收" : "未验收", equipment.AcceptanceDate == DateTime.MinValue ? "" : equipment.AcceptanceDate.ToString("yyyy-MM-dd"), equipment.UsageStatus.Name, equipment.EquipmentStatus.Name, equipment.WarrantyStatus, equipment.MandatoryTestStatus.Name == "" ? "无" : equipment.MandatoryTestStatus.Name, equipment.MandatoryTestDate == DateTime.MinValue ? "" : equipment.MandatoryTestDate.ToString("yyyy-MM-dd"), equipment.RecallFlag == true ? "是" : "否", equipment.RecallDate == DateTime.MinValue ? "" : equipment.RecallDate.ToString("yyyy-MM-dd"), equipment.PatrolType.Name != "" ? equipment.PatrolPeriod + equipment.PatrolType.Name : "无巡检", equipment.MaintenanceType.Name != "" ? equipment.MaintenancePeriod + equipment.MaintenanceType.Name : "无保养", equipment.CorrectionType.Name != "" ? equipment.CorrectionPeriod + equipment.CorrectionType.Name : "无巡检" ); } MemoryStream ms = ExportUtil.ToExcel(dt); Response.AddHeader("Set-Cookie", "fileDownload=true; path=/"); return(File(ms, "application/excel", "设备列表.xlsx")); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(Json(result, JsonRequestBehavior.AllowGet)); }