225 lines
24 KiB
MySQL
225 lines
24 KiB
MySQL
|
<EFBFBD><EFBFBD>USE [SGGLDB_TCCC]
|
|||
|
|
GO
|
|||
|
|
/****** Object: StoredProcedure [dbo].[sp_rpt_UnitWorkareaAnalyze] Script Date: 2021/9/6 19:03:42 ******/
|
|||
|
|
SET ANSI_NULLS ON
|
|||
|
|
GO
|
|||
|
|
SET QUOTED_IDENTIFIER ON
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|
|||
|
|
ALTER PROC [dbo].[sp_rpt_UnitWorkareaAnalyze]
|
|||
|
|
@UnitNo nVARCHAR(400) = NULL,
|
|||
|
|
@AreaNo nVARCHAR(50) = NULL,
|
|||
|
|
@installationId nVARCHAR(50) = NULL,
|
|||
|
|
@ste_steeltype nvarchar(50) = NULL,
|
|||
|
|
@startTime datetime = NULL,
|
|||
|
|
@endTime datetime = NULL,
|
|||
|
|
@projectId NVARCHAR(50) = NULL,
|
|||
|
|
@supervisorUnitId NVARCHAR(50) = NULL,
|
|||
|
|
@IsStandard NVARCHAR(50) = NULL
|
|||
|
|
|
|||
|
|
AS
|
|||
|
|
/*USMO<EFBFBD>]:Sۏ<EFBFBD>^R<EFBFBD>g*/
|
|||
|
|
SELECT
|
|||
|
|
WorkArea.ProjectId,
|
|||
|
|
WorkArea.WorkAreaCode AS baw_areano,--<EFBFBD>]:S<EFBFBD>N<EFBFBD>S
|
|||
|
|
Unit.UnitCode AS bsu_unitcode,--USMO<EFBFBD>Nx
|
|||
|
|
Unit.UnitName AS bsu_unitname, --USMO
T<EFBFBD>y
|
|||
|
|
Installation.InstallationCode, --ňn<EFBFBD>N<EFBFBD>S
|
|||
|
|
Installation.InstallationName, --ňn
T<EFBFBD>y
|
|||
|
|
-- gя
|
|||
|
|
q g
|
|||
|
|
ISNULL(total_jot.total_jot,0) AS total_jot, --;`
|
|||
|
|
q<EFBFBD>S
|
|||
|
|
--- /}<EFBFBD><EFBFBD>pe start
|
|||
|
|
ISNULL(total_sjot.total_sjot,0) AS total_sjot, --<EFBFBD><EFBFBD>6R;`
|
|||
|
|
q<EFBFBD>Spe
|
|||
|
|
ISNULL(total_fjot.total_fjot,0) AS total_fjot, --<EFBFBD>[ň;`
|
|||
|
|
q<EFBFBD>Spe
|
|||
|
|
ISNULL(cut_total_jot.cut_total_jot,0) AS cut_total_jot, --Rd<EFBFBD>
|
|||
|
|
q<EFBFBD>S
|
|||
|
|
CAST(ISNULL(total_jot.total_din,0) AS DECIMAL(19,2)) AS total_din,--;`<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
CAST(ISNULL(total_sjot.total_Sdin,0) AS DECIMAL(19,2)) AS total_Sdin, --<EFBFBD><EFBFBD>6R;`<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
CAST(ISNULL(total_fjot.total_Fdin,0) AS DECIMAL(19,2)) AS total_Fdin, --<EFBFBD>[ň;`<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
ISNULL(finished_total_jot_bq.finished_total_jot_bq,0) AS finished_total_jot_bq, --,g g<EFBFBD>[b
|
|||
|
|
q<EFBFBD>Spe
|
|||
|
|
ISNULL(finished_total_sjot_bq.finished_total_sjot_bq,0) AS finished_total_sjot_bq, --,g g<EFBFBD>[b<EFBFBD><EFBFBD>6R
|
|||
|
|
q<EFBFBD>Spe
|
|||
|
|
ISNULL(finished_total_fjot_bq.finished_total_fjot_bq,0) AS finished_total_fjot_bq, --,g g<EFBFBD>[b<EFBFBD>[ň
|
|||
|
|
q<EFBFBD>Spe
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_jot ,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_jot_bq.finished_total_jot_bq,0) / (1.0 * total_jot.total_jot)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_bq, --,g g<EFBFBD>[b<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_jot,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_sjot_bq.finished_total_sjot_bq,0)/ (1.0 *total_jot.total_jot)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_s_bq, -- ,g g<EFBFBD><EFBFBD>6R<EFBFBD>[b<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_jot,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_fjot_bq.finished_total_fjot_bq,0)/ (1.0 *total_jot.total_jot)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_f_bq, -- ,g g<EFBFBD>[ň<EFBFBD>[b<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
CAST(ISNULL(finished_total_jot_bq.finished_total_din_bq ,0) AS DECIMAL(19,2)) AS finished_total_din_bq, --,g g<EFBFBD>[b<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
CAST(ISNULL(finished_total_sjot_bq.finished_total_Sdin_bq,0) AS DECIMAL(19,2)) AS finished_total_Sdin_bq,----,g g<EFBFBD>[b<EFBFBD><EFBFBD>6R<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
CAST(ISNULL(finished_total_fjot_bq.finished_total_Fdin_bq,0) AS DECIMAL(19,2)) AS finished_total_Fdin_bq, ----,g g<EFBFBD>[b<EFBFBD>[ň<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_din,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_jot_bq.finished_total_din_bq ,0)/ (1.0 * total_jot.total_din)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_din_bq, --,g g<EFBFBD>[b<EFBFBD><EFBFBD><EFBFBD>V<EFBFBD>k<EFBFBD>O
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_din,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_sjot_bq.finished_total_Sdin_bq,0) /(1.0 * total_jot.total_din)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_din_s_bq, -- ,g g<EFBFBD>[b<EFBFBD><EFBFBD>6R<EFBFBD><EFBFBD><EFBFBD>V<EFBFBD>k<EFBFBD>O
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_din,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_fjot_bq.finished_total_Fdin_bq,0)/ (1.0 * total_jot.total_din)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_din_f_bq, -- ,g g<EFBFBD>[b<EFBFBD>[ň<EFBFBD><EFBFBD><EFBFBD>V<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
ISNULL(finished_total_jot.finished_total_jot,0) AS finished_total_jot, --<EFBFBD>[b
|
|||
|
|
q<EFBFBD>S
|
|||
|
|
ISNULL(finished_total_sjot.finished_total_sjot,0) AS finished_total_sjot, --<EFBFBD>[b<EFBFBD><EFBFBD>6R
|
|||
|
|
q<EFBFBD>S
|
|||
|
|
ISNULL(finished_total_fjot.finished_total_fjot,0) AS finished_total_fjot,--<EFBFBD>[b<EFBFBD>[ň
|
|||
|
|
q<EFBFBD>S
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_jot ,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_jot.finished_total_jot,0)/ (1.0 * total_jot.total_jot)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate, --<EFBFBD>[b<EFBFBD>k<EFBFBD>O
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_jot,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_fjot.finished_total_fjot,0) / (1.0 * total_jot.total_jot)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_f, -- <EFBFBD>[ň<EFBFBD>[b<EFBFBD>k<EFBFBD>O
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_jot,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(finished_total_sjot.finished_total_sjot,0) / (1.0 * total_jot.total_jot)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_s, -- <EFBFBD><EFBFBD>6R<EFBFBD>[b<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
CAST(ISNULL(total_jot.finished_total_din,0) AS DECIMAL(19,2)) AS finished_total_din, --<EFBFBD>[b<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
CAST(ISNULL(total_sjot.finished_total_Sdin,0) AS DECIMAL(19,2)) AS finished_total_Sdin,--<EFBFBD>[b<EFBFBD><EFBFBD>6R<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
CAST(ISNULL(total_fjot.finished_total_Fdin,0) AS DECIMAL(19,2)) AS finished_total_Fdin, --<EFBFBD>[b<EFBFBD>[ň<EFBFBD><EFBFBD><EFBFBD>V
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_din,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(total_jot.finished_total_din,0) / (1.0 * total_jot.total_din)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_din, ---<EFBFBD>[b<EFBFBD><EFBFBD><EFBFBD>V<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_din,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(total_sjot.finished_total_Sdin,0) / (1.0 *total_jot.total_din)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_din_s, -- <EFBFBD>[b<EFBFBD><EFBFBD>6R<EFBFBD><EFBFBD><EFBFBD>V<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
CAST((CASE ISNULL(total_jot.total_din,0)
|
|||
|
|
WHEN 0 THEN 0
|
|||
|
|
ELSE 1.0 * ISNULL(total_fjot.finished_total_Fdin,0) / (1.0 *total_jot.total_din)
|
|||
|
|
END) AS DECIMAL(19,3)) AS finisedrate_din_f -- <EFBFBD>[b<EFBFBD>[ň<EFBFBD><EFBFBD><EFBFBD>V<EFBFBD>k<EFBFBD>O
|
|||
|
|
|
|||
|
|
FROM ProjectData_WorkArea AS WorkArea
|
|||
|
|
LEFT JOIN Base_Unit AS Unit ON WorkArea.UnitId =Unit.UnitId
|
|||
|
|
LEFT JOIN Project_Installation AS Installation ON Installation.InstallationId = WorkArea.InstallationId
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) total_jot ,pw_isoinfo.WorkAreaId ,SUM(JOT_Size) AS total_din
|
|||
|
|
,SUM(JOT_DoneDin) AS finished_total_din
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS total_jot ON total_jot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) total_sjot ,pw_isoinfo.WorkAreaId, SUM(JOT_Size) AS total_Sdin
|
|||
|
|
,SUM(JOT_DoneDin) AS finished_total_Sdin
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and pw_jointinfo.WLO_Code='S' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS total_sjot ON total_sjot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) total_fjot ,pw_isoinfo.WorkAreaId, SUM(JOT_Size) AS total_Fdin
|
|||
|
|
,SUM(JOT_DoneDin) AS finished_total_Fdin
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and pw_jointinfo.WLO_Code='F' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS total_fjot ON total_fjot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) cut_total_jot ,pw_isoinfo.WorkAreaId
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and pw_jointinfo.JOT_JointStatus='104' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS cut_total_jot ON cut_total_jot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) finished_total_jot_bq ,pw_isoinfo.WorkAreaId ,SUM(JOT_DoneDin) AS finished_total_din_bq
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
LEFT JOIN BO_WeldReportMain ON BO_WeldReportMain.dreportid = pw_jointinfo.dreportid
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and pw_jointinfo.DReportID is not null
|
|||
|
|
and (jot_welddate >= @startTime OR @startTime IS NULL) and (jot_welddate <=@endTime OR @endTime IS NULL) AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS finished_total_jot_bq ON finished_total_jot_bq.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) finished_total_sjot_bq ,pw_isoinfo.WorkAreaId,SUM(JOT_DoneDin) AS finished_total_Sdin_bq
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
LEFT JOIN BO_WeldReportMain ON BO_WeldReportMain.dreportid = pw_jointinfo.dreportid
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and pw_jointinfo.DReportID is not null
|
|||
|
|
and (jot_welddate >= @startTime OR @startTime IS NULL) and (jot_welddate <=@endTime OR @endTime IS NULL)
|
|||
|
|
and WLO_Code='S' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS finished_total_sjot_bq ON finished_total_sjot_bq.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) finished_total_fjot_bq ,pw_isoinfo.WorkAreaId , SUM(JOT_DoneDin) AS finished_total_Fdin_bq
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
LEFT JOIN BO_WeldReportMain ON BO_WeldReportMain.dreportid = pw_jointinfo.dreportid
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and pw_jointinfo.DReportID is not null
|
|||
|
|
and (jot_welddate >= @startTime OR @startTime IS NULL) and (jot_welddate <=@endTime OR @endTime IS NULL)
|
|||
|
|
and WLO_Code='F' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS finished_total_fjot_bq ON finished_total_fjot_bq.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) finished_total_jot ,pw_isoinfo.WorkAreaId
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and DReportID is not null AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS finished_total_jot ON finished_total_jot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) finished_total_sjot ,pw_isoinfo.WorkAreaId
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and DReportID is not null
|
|||
|
|
and WLO_Code='S' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS finished_total_sjot ON finished_total_sjot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
|
|||
|
|
LEFT JOIN (SELECT COUNT(*) finished_total_fjot ,pw_isoinfo.WorkAreaId
|
|||
|
|
FROM pw_jointinfo
|
|||
|
|
LEFT JOIN pw_isoinfo ON pw_jointinfo.ISO_ID = pw_isoinfo.ISO_ID
|
|||
|
|
LEFT JOIN Base_Material ON Base_Material.MaterialId = pw_jointinfo.MaterialId
|
|||
|
|
WHERE (Base_Material.SteelType =@ste_steeltype or @ste_steeltype is null) and DReportID is not null
|
|||
|
|
and WLO_Code='F' AND
|
|||
|
|
(pw_isoinfo.Is_Standard=@IsStandard OR @IsStandard IS NULL)
|
|||
|
|
GROUP BY pw_isoinfo.WorkAreaId) AS finished_total_fjot ON finished_total_fjot.WorkAreaId = WorkArea.WorkAreaId
|
|||
|
|
WHERE
|
|||
|
|
(WorkArea.ProjectId=@projectId OR @projectId IS NULL ) AND
|
|||
|
|
(WorkArea.WorkAreaId=@areano OR @AreaNo IS NULL ) AND
|
|||
|
|
(WorkArea.UnitId=@unitno OR @UnitNo IS NULL) AND
|
|||
|
|
(WorkArea.InstallationId=@installationId OR @installationId IS NULL) AND
|
|||
|
|
(WorkArea.SupervisorUnitId=@supervisorUnitId OR @supervisorUnitId IS NULL)
|
|||
|
|
ORDER BY Unit.UnitCode ,Installation.InstallationCode
|
|||
|
|
|
|||
|
|
|