Ejemplo n.º 1
0
        public JsonResult DispatchRequest(RequestInfo requestInfo, DispatchInfo dispatchInfo)
        {
            if (CheckSession(false) == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                List <DispatchInfo> dispatchInfos = this.dispatchDao.GetOpenDispatchesByRequestID(requestInfo.ID);
                foreach (DispatchInfo dispatch in dispatchInfos)
                {
                    if (dispatch.Engineer.ID == dispatchInfo.Engineer.ID)
                    {
                        result.SetFailed(ResultCodes.ParameterError, "该工程师已被派工且未完成");
                        return(JsonResult(result));
                    }
                }
                this.requestManager.DispatchRequest(requestInfo, dispatchInfo, GetLoginUser());
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 2
0
        public JsonResult UpdatePassword(string loginPwd)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                int    ID  = GetLoginUser().ID;
                string pwd = this.userManager.GetUser(ID).LoginPwd;
                if (loginPwd == pwd)
                {
                    result.SetFailed(ResultCodes.ParameterError, "与原密码相同,请重新输入");
                    return(JsonResult(result));
                }
                this.userManager.UpdatePassword(ID, loginPwd);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 3
0
        public JsonResult SaveDispatchReport(DispatchReportInfo dispatchReport)
        {
            ResultModelBase result = new ResultModelBase();

            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }
            try
            {
                DispatchInfo dispatch = this.dispatchManager.GetDispatchByID(dispatchReport.Dispatch.ID);
                if (dispatch.DispatchReport.Status.ID != DispatchInfo.DocStatus.New)
                {
                    result.SetFailed(ResultCodes.ParameterError, "不可重复提交");
                }
                else
                {
                    this.dispatchManager.SaveDispatchReport(dispatchReport, GetLoginUser());
                }
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 初始化备用机
        /// </summary>
        /// <returns>初始化结果</returns>
        public JsonResult InitValSpares()
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                this.valuationDao.DeleteSpares(GetLoginUser().ID);
                this.valuationDao.InitSpares(GetLoginUser().ID);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 5
0
        public JsonResult SaveValControl(ValControlInfo info)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                info.User.ID = GetLoginUser().ID;
                this.valuationManager.SaveValControl(info);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 保存富士II类信息
        /// </summary>
        /// <param name="info">关联信息</param>
        /// <param name="isUpdate">是否更新</param>
        /// <param name="copyID">复制的II类id</param>
        /// <returns>富士II类id</returns>
        public JsonResult SaveFujiClass2(FujiClassLink info, bool isUpdate, int copyID = 0)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                this.fujiClassManager.SaveFujiClass2(info, GetLoginUser(), isUpdate, copyID);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 7
0
        /// <summary>
        /// 设备查看页面
        /// </summary>
        /// <param name="id">设备编号</param>
        /// <param name="actionName">上级页面名称</param>
        /// <returns>设备查看页面</returns>
        public ActionResult EquipmentView(int id, string actionName)
        {
            if (CheckSession() == false)
            {
                Response.Redirect(Url.Action(ConstDefinition.HOME_ACTION, ConstDefinition.HOME_CONTROLLER), true);
                return(null);
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                ViewBag.Id         = id;
                ViewBag.ActionName = actionName;

                return(View());
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }

            return(View("Error", result));
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 删除附件
        /// </summary>
        /// <param name="objectTypeId">附件对象类型ID</param>
        /// <param name="id">附件编号</param>
        /// <returns>删除附件返回信息</returns>
        public JsonResult DeleteUploadFile(int objectTypeId, int id)
        {
            if (CheckSession(false) == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                if (id < 0)
                {
                    DeleteUploadFileInSession(id);
                }
                else
                {
                    this.fileManager.DeleteUploadFileByID(objectTypeId, id);
                }
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 9
0
        public JsonResult AddRequest(RequestInfo info)
        {
            if (CheckSession(false) == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                List <UploadFileInfo> files = GetUploadFilesInSession();

                info.RequestUser = GetLoginUser();
                info.Status.ID   = RequestInfo.Statuses.New;
                info.Source.ID   = RequestInfo.Sources.ManualRequest;
                info.Source.Name = RequestInfo.Sources.GetSourceDesc(info.Source.ID);

                info.ID = this.requestManager.AddRequest(info, files, GetLoginUser());
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 10
0
        /// <summary>
        /// 批量保存富士II类信息
        /// </summary>
        /// <param name="infos">富士II类信息</param>
        /// <param name="type">费用类型</param>
        /// <returns>保存结果</returns>
        public JsonResult SaveFujiClass2s(List <FujiClass2Info> infos, FujiClass2Info.SectionType type)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                this.fujiClassManager.SaveFujiClass2s(infos, type, GetLoginUser());
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 11
0
        /// <summary>
        ///  存入缓存
        /// </summary>
        /// <param name="type">缓存类型</param>
        /// <returns>返回结果</returns>
        public JsonResult SaveValuation(ValuationType type)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                switch (type)
                {
                case ValuationType.Equipment:
                    var equipments = GetValSession <ValEquipmentInfo>();
                    if (equipments != null)
                    {
                        this.valuationManager.SaveValEquipments(GetLoginUser().ID, equipments.Values.ToList());
                    }
                    break;

                case ValuationType.Spare:
                    var spares = GetValSession <ValSpareInfo>();
                    if (spares != null)
                    {
                        this.valuationManager.SaveValSpares(spares.Values.ToList());
                    }
                    break;

                case ValuationType.Consumable:
                    var consumables = GetValSession <ValConsumableInfo>();
                    if (consumables != null)
                    {
                        this.valuationManager.SaveValConsumables(consumables.Values.ToList());
                    }
                    break;

                case ValuationType.Component:
                case ValuationType.CTTube:
                    var components = GetValSession <ValComponentInfo>();
                    if (components != null)
                    {
                        this.valuationManager.SaveValComponents(components.Values.ToList());
                    }
                    break;
                }
                ClearValSession();
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 12
0
        public JsonResult ImportValEquipment(string base64String)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }

            ResultModelBase result = new ResultModelBase();

            try
            {
                base64String = ParseBase64String(base64String);
                if (string.IsNullOrEmpty(base64String))
                {
                    result.SetFailed(ResultCodes.ParameterError, "上传文件为空");
                }
                else
                {
                    UserInfo user      = GetLoginUser();
                    byte[]   excelFile = Convert.FromBase64String(base64String);
                    string   message   = null;
                    List <ValEquipmentInfo> importEquipments = null;
                    List <ValEquipmentInfo> updateEquipments = null;
                    int parseResult = this.valuationManager.ParseImportFile(user.ID, excelFile, out message, out importEquipments, out updateEquipments);
                    if (parseResult == 1)
                    {
                        result.SetFailed(ResultCodes.BusinessError, message);
                    }
                    else
                    {
                        this.valuationManager.SaveValEquipments(user.ID, updateEquipments, importEquipments);
                    }
                }
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 13
0
        /// <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));
        }
Ejemplo n.º 14
0
        public ActionResult ViewPDF(int equipmentID, int fileID)
        {
            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }
            ResultModelBase result = new ResultModelBase();

            try
            {
                UploadFileInfo info = this.fileDao.GetFileByID(ObjectTypes.Equipment, fileID);

                FileUtil.CheckDirectory(Constants.EquipmentFolder);

                string filePath = Path.Combine(Constants.EquipmentFolder, string.Format("{0}_{1}{2}", equipmentID, fileID, new FileInfo(info.FileName).Extension));


                if (info != null && System.IO.File.Exists(filePath))
                {
                    Stream stream = new FileStream(filePath, FileMode.Open);
                    return(File(stream, info.FileName));
                }
                else
                {
                    result.SetFailed(ResultCodes.BusinessError, "文件不存在");
                }
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }

            return(View("ErrorPage", null, result.ResultMessage));
        }
Ejemplo n.º 15
0
        /// <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));
        }
Ejemplo n.º 16
0
        public JsonResult ForgetPassword(string loginID)
        {
            ResultModelBase result = new ResultModelBase();

            try
            {
                UserInfo existingInfo = this.userManager.GetUserByLoginID(loginID);

                if (existingInfo == null)
                {
                    result.SetFailed(ResultCodes.BusinessError, "用户尚未注册");
                }
                else if (string.IsNullOrEmpty(existingInfo.Email))
                {
                    result.SetFailed(ResultCodes.BusinessError, "无邮箱账号,请联系管理员");
                }
                else if (existingInfo.IsActive == false)
                {
                    result.SetFailed(ResultCodes.BusinessError, "用户已停用");
                }
                else if (existingInfo.VerifyStatus.ID != BusinessObjects.Domain.VerifyStatus.Pass)
                {
                    result.SetFailed(ResultCodes.BusinessError, "用户尚未通过审批");
                }
                else
                {
                    SendNoticeEmail(existingInfo);
                }
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 17
0
        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));
        }
Ejemplo n.º 18
0
        /// <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));
        }
Ejemplo n.º 19
0
        /// <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));
        }
Ejemplo n.º 20
0
        /// <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));
        }
Ejemplo n.º 21
0
        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));
        }
Ejemplo n.º 22
0
        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));
        }
Ejemplo n.º 23
0
        /// <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));
        }
Ejemplo n.º 24
0
        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));
        }
Ejemplo n.º 25
0
        /// <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));
        }
Ejemplo n.º 26
0
        /// <summary>
        /// 扫码报修
        /// </summary>
        /// <param name="id">设备编号</param>
        /// <returns>扫码报修页面</returns>
        public ActionResult Repair(int id)
        {
            ResultModelBase result = new ResultModelBase();

            try
            {
                EquipmentInfo info = this.equipmentManager.GetEquipment(id);
                if (info == null)
                {
                    return(View("Error", result));
                }
                return(View("Repair", info));
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }

            return(View("Error", result));
        }
Ejemplo n.º 27
0
        /// <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));
        }
Ejemplo n.º 28
0
        public JsonResult DeleteConsumableByID(int consumableID)
        {
            if (CheckSession(false) == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }
            ResultModelBase result = new ResultModelBase();

            try
            {
                this.consumableDao.DeleteConsumableByID(consumableID);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 29
0
        public JsonResult UpdateSelectiveDate(RequestInfo info)
        {
            ResultModelBase result = new ResultModelBase();

            if (CheckSession(false) == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }
            try
            {
                this.requestManager.UpdateSelectiveDate(info.ID, info.SelectiveDate);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }
Ejemplo n.º 30
0
        public JsonResult EndPurchaseOrder(int purchaseOrderID, string comments = "")
        {
            ResultModelBase result = new ResultModelBase();

            if (CheckSession() == false)
            {
                return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
            }
            if (CheckSessionID() == false)
            {
                return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
            }
            try
            {
                this.purchaseOrderManager.EndPurchaseOrder(purchaseOrderID, GetLoginUser(), comments);
            }
            catch (Exception ex)
            {
                NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
                result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
            }
            return(JsonResult(result));
        }