/// <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));
}
