/// <summary>
/// 获取作业报告信息
/// </summary>
/// <param name="dr">The dr.</param>
public DispatchReportInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Dispatch.ID = SQLUtil.ConvertInt(dr["DispatchID"]);
this.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.Type = LookupManager.GetDispatchReportType(this.Type.ID);
this.FaultCode = SQLUtil.TrimNull(dr["FaultCode"]);
this.FaultDesc = SQLUtil.TrimNull(dr["FaultDesc"]);
this.SolutionCauseAnalysis = SQLUtil.TrimNull(dr["SolutionCauseAnalysis"]);
this.SolutionWay = SQLUtil.TrimNull(dr["SolutionWay"]);
this.IsPrivate = SQLUtil.ConvertBoolean(dr["IsPrivate"]);
this.ServiceProvider.ID = SQLUtil.ConvertInt(dr["ServiceProvider"]);
this.ServiceProvider.Name = ServiceProviders.GetDescByID(this.ServiceProvider.ID);
this.SolutionResultStatus.ID = SQLUtil.ConvertInt(dr["SolutionResultStatusID"]);
this.SolutionResultStatus.Name = LookupManager.GetSolutionResultStatusDesc(this.SolutionResultStatus.ID);
this.SolutionUnsolvedComments = SQLUtil.TrimNull(dr["SolutionUnsolvedComments"]);
this.DelayReason = SQLUtil.TrimNull(dr["DelayReason"]);
this.Comments = SQLUtil.TrimNull(dr["Comments"]);
this.FujiComments = SQLUtil.TrimNull(dr["FujiComments"]);
this.Status.ID = SQLUtil.ConvertInt(dr["StatusID"]);
this.Status.Name = LookupManager.GetDispatchDocStatusDesc(this.Status.ID);
this.PurchaseAmount = SQLUtil.ConvertDouble(dr["PurchaseAmount"]); this.ServiceScope = SQLUtil.ConvertBoolean(dr["ServiceScope"]);
this.ServiceScope = SQLUtil.ConvertBoolean(dr["ServiceScope"]);
this.Result = SQLUtil.TrimNull(dr["Result"]);
this.IsRecall = SQLUtil.ConvertBoolean(dr["IsRecall"]);
this.AcceptanceDate = SQLUtil.ConvertDateTime(dr["AcceptanceDate"]);
this.EquipmentStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatus"]);
this.EquipmentStatus.Name = MachineStatuses.GetMachineStatusesDesc(this.EquipmentStatus.ID);
}
/// <summary>
/// 根据请求类型、故障分类编号获取故障分类字段描述
/// </summary>
/// <param name="requestType">请求类型</param>
/// <param name="faultType">故障分类编号</param>
/// <returns>故障分类字段描述</returns>
public static string GetFaultTypeDesc(int requestType, int faultType)
{
switch (requestType)
{
case Repair:
return(MachineStatuses.GetMachineStatusesDesc(faultType));
case Maintain:
return(MaintainType.GetMaintainTypeDesc(faultType));
case Inspection:
return(InspectionType.GetInspectionDesc(faultType));
case AdverseEvent:
return(AdverseEventType.GetAdverseEventDesc(faultType));
default:
return("");
}
}
/// <summary>
/// 获取派工单信息
/// </summary>
/// <param name="dr">The dr.</param>
public DispatchInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Request.ID = SQLUtil.ConvertInt(dr["RequestID"]);
this.RequestType.ID = SQLUtil.ConvertInt(dr["RequestType"]);
this.RequestType.Name = LookupManager.GetRequestTypeDesc(this.RequestType.ID);
this.Urgency.ID = SQLUtil.ConvertInt(dr["UrgencyID"]);
this.Urgency.Name = LookupManager.GetUrgencyDesc(this.Urgency.ID);
this.MachineStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatus"]);
this.MachineStatus.Name = MachineStatuses.GetMachineStatusesDesc(this.MachineStatus.ID);
this.Engineer.ID = SQLUtil.ConvertInt(dr["EngineerID"]);
this.ScheduleDate = SQLUtil.ConvertDateTime(dr["ScheduleDate"]);
this.LeaderComments = SQLUtil.TrimNull(dr["LeaderComments"]);
this.Status.ID = SQLUtil.ConvertInt(dr["StatusID"]);
this.Status.Name = LookupManager.GetDispatchStatusDesc(this.Status.ID);
this.CreateDate = SQLUtil.ConvertDateTime(dr["CreateDate"]);
this.StartDate = SQLUtil.ConvertDateTime(dr["StartDate"]);
this.EndDate = SQLUtil.ConvertDateTime(dr["EndDate"]);
if (dr.Table.Columns.Contains("DispatchJournalID"))
{
this.DispatchJournal.ID = SQLUtil.ConvertInt(dr["DispatchJournalID"]);
}
if (dr.Table.Columns.Contains("DispatchJournalStatusID"))
{
this.DispatchJournal.Status.ID = SQLUtil.ConvertInt(dr["DispatchJournalStatusID"]);
this.DispatchJournal.Status.Name = LookupManager.GetDispatchDocStatusDesc(this.DispatchJournal.Status.ID);
}
if (dr.Table.Columns.Contains("DispatchReportID"))
{
this.DispatchReport.ID = SQLUtil.ConvertInt(dr["DispatchReportID"]);
}
if (dr.Table.Columns.Contains("DispatchReportStatusID"))
{
this.DispatchReport.Status.ID = SQLUtil.ConvertInt(dr["DispatchReportStatusID"]);
this.DispatchReport.Status.Name = LookupManager.GetDispatchDocStatusDesc(this.DispatchReport.Status.ID);
}
}
/// <summary>
/// 获取请求信息
/// </summary>
/// <param name="dr">The dr.</param>
public RequestInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Source.ID = SQLUtil.ConvertInt(dr["Source"]);
this.Source.Name = Sources.GetSourceDesc(this.Source.ID);
this.RequestType.ID = SQLUtil.ConvertInt(dr["RequestType"]);
this.RequestType.Name = Manager.LookupManager.GetRequestTypeDesc(this.RequestType.ID);
this.RequestUser.ID = SQLUtil.ConvertInt(dr["RequestUserID"]);
this.RequestUser.Name = SQLUtil.TrimNull(dr["RequestUserName"]);
this.RequestUser.Mobile = SQLUtil.TrimNull(dr["RequestUserMobile"]);
if (dr.Table.Columns.Contains("RequestUserRoleID"))
{
this.RequestUser.Role.Name = Manager.LookupManager.GetRoleDesc(SQLUtil.ConvertInt(dr["RequestUserRoleID"]));
}
this.Subject = SQLUtil.TrimNull(dr["Subject"]);
this.FaultDesc = SQLUtil.TrimNull(dr["FaultDesc"]);
this.MachineStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatus"]);
this.MachineStatus.Name = MachineStatuses.GetMachineStatusesDesc(this.MachineStatus.ID);
this.FaultType.ID = SQLUtil.ConvertInt(dr["FaultTypeID"]);
this.FaultType.Name = RequestTypes.GetFaultTypeDesc(this.RequestType.ID, this.FaultType.ID);
this.Status.ID = SQLUtil.ConvertInt(dr["StatusID"]);
this.Status.Name = Manager.LookupManager.GetRequestStatusDesc(this.Status.ID);
this.DealType.ID = SQLUtil.ConvertInt(dr["DealTypeID"]);
this.DealType.Name = Manager.LookupManager.GetDealTypeDesc(this.DealType.ID);
this.Priority.ID = SQLUtil.ConvertInt(dr["PriorityID"]);
this.Priority.Name = Manager.LookupManager.GetUrgencyDesc(this.Priority.ID);
this.RequestDate = SQLUtil.ConvertDateTime(dr["RequestDate"]);
this.DistributeDate = SQLUtil.ConvertDateTime(dr["DistributeDate"]);
this.DispatchDate = SQLUtil.ConvertDateTime(dr["DispatchDate"]);
this.ResponseDate = SQLUtil.ConvertDateTime(dr["ResponseDate"]);
this.CloseDate = SQLUtil.ConvertDateTime(dr["CloseDate"]);
this.LastStatus.ID = SQLUtil.ConvertInt(dr["LastStatusID"]);
this.LastStatus.Name = Manager.LookupManager.GetRequestStatusDesc(this.LastStatus.ID);
this.IsRecall = SQLUtil.ConvertBoolean(dr["IsRecall"]);
this.SelectiveDate = SQLUtil.ConvertDateTime(dr["SelectiveDate"]);
}
