/// <summary> /// 保存科室信息 /// </summary> /// <param name="info">科室信息</param> /// <returns>科室id</returns> public int SaveDepartment(DepartmentInfo info) { if (info.ID >= 0) { DepartmentInfo existingInfo = this.departmentDao.GetDepartmentByID(info.ID); if (existingInfo.Seq > info.Seq) { this.departmentDao.UpdateDepartmentSeq(info.Seq, existingInfo.Seq, 1); } else if (existingInfo.Seq < info.Seq) { this.departmentDao.UpdateDepartmentSeq(existingInfo.Seq, info.Seq, -1); } this.departmentDao.UpdateDepartment(info); } else { this.departmentDao.UpdateDepartmentSeq(info.Seq, Int16.MaxValue, 1); info.ID = this.departmentDao.AddDepartment(info); } LookupManager.RecacheDepartments(); return(info.ID); }
/// <summary> /// 获取派工单报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetDispatchDesc(DataRow dr, List <string> fieldsInRpt) { if (SQLUtil.ConvertInt(dr["DisID"]) != 0) { if (fieldsInRpt.Contains("DispatchTypeDesc")) { dr["DispatchTypeDesc"] = LookupManager.GetRequestTypeDesc(SQLUtil.ConvertInt(dr["DispatchRequestType"])); } if (fieldsInRpt.Contains("UrgencyDesc")) { dr["UrgencyDesc"] = LookupManager.GetUrgencyDesc(SQLUtil.ConvertInt(dr["UrgencyID"])); } if (fieldsInRpt.Contains("MachineStatusDesc")) { dr["MachineStatusDesc"] = MachineStatuses.GetMachineStatusesDesc(SQLUtil.ConvertInt(dr["EquipmentStatus"])); } if (fieldsInRpt.Contains("EngineerName")) { dr["EngineerName"] = (SQLUtil.ConvertInt(dr["EngineerID"]) == 0) ? "" : (this.userDao.GetUser(SQLUtil.ConvertInt(dr["EngineerID"])) == null ? "" : this.userDao.GetUser(SQLUtil.ConvertInt(dr["EngineerID"])).Name); } if (fieldsInRpt.Contains("DispatchStatusDesc")) { dr["DispatchStatusDesc"] = LookupManager.GetDispatchStatusDesc(SQLUtil.ConvertInt(dr["DispatchStatusID"])); } } return(dr); }
/// <summary> /// 获取合同报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetContractDesc(DataRow dr, List <string> fieldsInRpt) { if (fieldsInRpt.Contains("TypeDesc")) { dr["TypeDesc"] = LookupManager.GetContractTypeDesc(SQLUtil.ConvertInt(dr["TypeID"])); } if (fieldsInRpt.Contains("ScopeDesc")) { dr["ScopeDesc"] = LookupManager.GetContractScopeDesc(SQLUtil.ConvertInt(dr["ScopeID"])); } return(dr); }
/// <summary> /// 获取作业报告报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetDispatchReportDesc(DataRow dr, List <string> fieldsInRpt) { if (SQLUtil.ConvertInt(dr["ReportID"]) != 0) { if (fieldsInRpt.Contains("ReportTypeDesc")) { dr["ReportTypeDesc"] = LookupManager.GetDispatchReportType(SQLUtil.ConvertInt(dr["TypeID"])).Name; } if (fieldsInRpt.Contains("ReportStatusDesc")) { dr["ReportStatusDesc"] = LookupManager.GetDispatchDocStatusDesc(SQLUtil.ConvertInt(dr["DispatchReportStatusID"])); } if (fieldsInRpt.Contains("ServiceProviderDesc")) { dr["ServiceProviderDesc"] = DispatchReportInfo.ServiceProviders.GetDescByID(SQLUtil.ConvertInt(dr["ServiceProvider"])); } if (fieldsInRpt.Contains("ReportEquipmentStatusDesc")) { dr["ReportEquipmentStatusDesc"] = LookupManager.GetEquipmentStatusDesc(SQLUtil.ConvertInt(dr["reportEquipmentStatus"])); } if (fieldsInRpt.Contains("ServiceScopeDesc")) { dr["ServiceScopeDesc"] = SQLUtil.ConvertBoolean(dr["ServiceScope"]) ? "是" : "否"; } if (fieldsInRpt.Contains("SolutionResultStatusDesc")) { dr["SolutionResultStatusDesc"] = LookupManager.GetSolutionResultStatusDesc(SQLUtil.ConvertInt(dr["SolutionResultStatusID"])); } if (fieldsInRpt.Contains("ReportIsRecallDesc")) { dr["ReportIsRecallDesc"] = SQLUtil.ConvertBoolean(dr["ReportIsRecall"]) ? "是" : "否"; } if (fieldsInRpt.Contains("IsPrivateDesc")) { dr["IsPrivateDesc"] = SQLUtil.ConvertBoolean(dr["IsPrivate"]) ? "是" : "否"; } } return(dr); }
/// <summary> /// 获取下载附件时的文件名 /// </summary> /// <param name="info">附件信息</param> /// <returns>格式化后的附件名</returns> public string GetDownloadFileName(UploadFileInfo info) { string name = info.GetDisplayFileName(); if (name == "") { return(info.FileName); } if (ObjectTypes.Equipment.Equals(info.ObjectTypeId)) { EquipmentInfo equipmentInfo = this.equipmentDao.GetEquipmentByID(info.ObjectID); name = string.Format("{0}_{1}", name, equipmentInfo.AssetCode); } else { name = string.Format("{0}_{1}", LookupManager.GetObjectOID(info.ObjectTypeId, info.ObjectID), name); } return(name + new FileInfo(info.FileName).Extension); }
/// <summary> /// 获取合同报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetContractDesc(DataRow dr, List <string> fieldsInRpt) { if (fieldsInRpt.Contains("TypeDesc")) { dr["TypeDesc"] = LookupManager.GetContractTypeDesc(SQLUtil.ConvertInt(dr["TypeID"])); } if (fieldsInRpt.Contains("ScopeDesc")) { dr["ScopeDesc"] = LookupManager.GetContractScopeDesc(SQLUtil.ConvertInt(dr["ScopeID"])); } if (fieldsInRpt.Contains("SupplierType")) { dr["SupplierType"] = LookupManager.GetSupplierTypeDesc(SQLUtil.ConvertInt(dr["SupplierTypeID"])); } if (fieldsInRpt.Contains("SupplierStatus")) { dr["SupplierStatus"] = SQLUtil.ConvertBoolean(dr["SupplierStatusID"]) ? "启用" : "停用"; } return(dr); }
/// <summary> /// 获取服务凭证报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetDispatchJournalDesc(DataRow dr, List <string> fieldsInRpt) { if (SQLUtil.ConvertInt(dr["JournalID"]) != 0) { if (fieldsInRpt.Contains("ResultStatusDesc")) { dr["ResultStatusDesc"] = LookupManager.GetDispatchJournalResultStatusDesc(SQLUtil.ConvertInt(dr["ResultStatusID"])); } if (fieldsInRpt.Contains("SignedDesc")) { dr["SignedDesc"] = (SQLUtil.ConvertInt(dr["JournalID"]) > 0) ? (SQLUtil.ConvertBoolean(dr["Signed"]) ? "是" : "否") : ""; } if (fieldsInRpt.Contains("JournalStatusDesc")) { dr["JournalStatusDesc"] = LookupManager.GetDispatchDocStatusDesc(SQLUtil.ConvertInt(dr["DispatchJournalStatusID"])); } } return(dr); }
/// <summary> /// 获取请求报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetRequestDesc(DataRow dr, List <string> fieldsInRpt) { if (SQLUtil.ConvertInt(dr["RequestID"]) != 0) { if (fieldsInRpt.Contains("RequestTypeDesc")) { dr["RequestTypeDesc"] = LookupManager.GetRequestTypeDesc(SQLUtil.ConvertInt(dr["RequestType"])); } if (fieldsInRpt.Contains("SourceDesc")) { dr["SourceDesc"] = RequestInfo.Sources.GetSourceDesc(SQLUtil.ConvertInt(dr["Source"])); } if (fieldsInRpt.Contains("FaultTypeDesc")) { dr["FaultTypeDesc"] = RequestInfo.GetDescFaultType(SQLUtil.ConvertInt(dr["RequestType"]), SQLUtil.ConvertInt(dr["FaultTypeID"])); } if (fieldsInRpt.Contains("RequestStatusID")) { dr["RequestStatusID"] = LookupManager.GetRequestStatusDesc(SQLUtil.ConvertInt(dr["StatusID"])); } if (fieldsInRpt.Contains("DealTypeDesc")) { dr["DealTypeDesc"] = LookupManager.GetDealTypeDesc(SQLUtil.ConvertInt(dr["DealTypeID"])); } if (fieldsInRpt.Contains("PriorityDesc")) { dr["PriorityDesc"] = LookupManager.GetUrgencyDesc(SQLUtil.ConvertInt(dr["PriorityID"])); } if (fieldsInRpt.Contains("IsRecallDesc")) { dr["IsRecallDesc"] = SQLUtil.ConvertBoolean(dr["RequestIsRecall"]) ? "是" : "否"; } } return(dr); }
/// <summary> /// 获取设备报表的部分字段描述信息 /// </summary> /// <param name="dr">报表所有字段信息</param> /// <param name="fieldsInRpt">选取的报表字段</param> /// <returns>报表信息</returns> public DataRow GetEquipmentDesc(DataRow dr, List <string> fieldsInRpt) { if (SQLUtil.ConvertInt(dr["EquipmentID"]) != 0) { if (fieldsInRpt.Contains("EquipmentLevelDesc")) { dr["EquipmentLevelDesc"] = (dr["EquipmentLevel"] == null) ? "" : EquipmentInfo.EquipmentLevels.GetEquipmentLevelDesc(SQLUtil.ConvertInt(dr["EquipmentLevel"])); } if (fieldsInRpt.Contains("ServiceScopeDesc")) { dr["ServiceScopeDesc"] = SQLUtil.ConvertBoolean(dr["ServiceScope"]) ? "是" : "否"; } if (fieldsInRpt.Contains("EquipmentClass1Name")) { dr["EquipmentClass1Name"] = (SQLUtil.TrimNull(dr["EquipmentClass1"]) == "00" || SQLUtil.TrimNull(dr["EquipmentClass1"]) == null) ? "" : LookupManager.GetEquipmentClassDesc(SQLUtil.TrimNull(dr["EquipmentClass1"]), 1); } if (fieldsInRpt.Contains("EquipmentClass2Name")) { dr["EquipmentClass2Name"] = (SQLUtil.TrimNull(dr["EquipmentClass2"]) == "00") ? "" : LookupManager.GetEquipmentClassDesc(SQLUtil.TrimNull(dr["EquipmentClass2"]), 2, SQLUtil.TrimNull(dr["EquipmentClass1"])); } if (fieldsInRpt.Contains("EquipmentClass3Name")) { dr["EquipmentClass3Name"] = (SQLUtil.TrimNull(dr["EquipmentClass3"]) == "00") ? "" : LookupManager.GetEquipmentClassDesc(SQLUtil.TrimNull(dr["EquipmentClass3"]), 3, SQLUtil.TrimNull(dr["EquipmentClass1"]) + SQLUtil.TrimNull(dr["EquipmentClass2"])); } if (fieldsInRpt.Contains("DepartmentName")) { dr["DepartmentName"] = LookupManager.GetDepartmentDesc(SQLUtil.ConvertInt(dr["DepartmentID"])); } if (fieldsInRpt.Contains("UsageStatusDesc")) { dr["UsageStatusDesc"] = LookupManager.GetUsageStatusDesc(SQLUtil.ConvertInt(dr["UsageStatusID"])); } if (fieldsInRpt.Contains("EquipmentStatusDesc")) { dr["EquipmentStatusDesc"] = LookupManager.GetEquipmentStatusDesc(SQLUtil.ConvertInt(dr["EquipmentStatusID"])); } if (fieldsInRpt.Contains("MandatoryTestStatusDesc")) { dr["MandatoryTestStatusDesc"] = EquipmentInfo.MandatoryTestStatuses.GetMandatoryTestStatusDesc(SQLUtil.ConvertInt(dr["MandatoryTestStatus"])); } if (fieldsInRpt.Contains("MaintenanceTypeDesc")) { dr["MaintenanceTypeDesc"] = LookupManager.GetPeriodTypeDesc(SQLUtil.ConvertInt(dr["MaintenanceTypeID"])); } if (fieldsInRpt.Contains("PatrolTypeDesc")) { dr["PatrolTypeDesc"] = LookupManager.GetPeriodTypeDesc(SQLUtil.ConvertInt(dr["PatrolTypeID"])); } if (fieldsInRpt.Contains("CorrectionTypeDesc")) { dr["CorrectionTypeDesc"] = LookupManager.GetPeriodTypeDesc(SQLUtil.ConvertInt(dr["CorrectionTypeID"])); } if (fieldsInRpt.Contains("CreateUserName")) { dr["CreateUserName"] = (SQLUtil.ConvertInt(dr["CreateUserID"]) == 0) ? "" : this.userDao.GetUser(SQLUtil.ConvertInt(dr["CreateUserID"])).Name; } if (fieldsInRpt.Contains("WarrantyStatus")) { dr["WarrantyStatus"] = SQLUtil.ConvertInt(dr["WarrantyStatusID"]) == 0 ? "保外" : "保内"; } } return(dr); }