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