Ejemplo n.º 1
0
        /// <summary>
        /// 单芯查询 无 IN条件
        /// </summary>
        /// <param name="e"></param>
        public void GetData_Method_OneCore(My_GetTestData.GetDataEventArgs e)
        {
            //查询JDSU中的数据
            string sql = " SELECT LEFT(SN, 10) AS SN,  '1' AS Name, Result, Wave, IL_A, Refl_A, IL_B, Refl_B, TestDate ";

            sql       += " FROM User_JDS_Test_Good";
            sql       += " WHERE " + e.sqlWhere + "  AND (Result LIKE '%Passed')";
            e.TestData = dbs.Query(sql);                    //返回查询到的数据

            //查询Exfo中的数据
            bool tem = false;

            if (e.TestData.Tables[0].Rows.Count > 0)
            {
                tem = false;
            }
            else
            {
                tem = true;
            }

            if (tem)
            {
                string asql = "SELECT * FROM( SELECT LEFT (dbo.TDUTMeasurement.Dum_FixSerialNr,10) AS [SN], ";
                asql      += " '1' AS [Name], ";
                asql      += "(CASE WHEN dbo.TDUTMeasurement.Dum_GlobalTestStatus = 1 THEN 'PASS' END ) AS [Result] , ";
                asql      += " (CASE WHEN dbo.TWaveLength.Wvl_Value = 0.0000013100 THEN '1310nm' WHEN dbo.TWaveLength.Wvl_Value = 0.0000015500 THEN '1550um' END ) AS Wave, ";
                asql      += "dbo.TFiberMeasurement.Fim_ILEndA AS [Il_A], ";
                asql      += "dbo.TFiberMeasurement.Fim_ReflectanceEndA AS [Refl_A], ";
                asql      += "dbo.TFiberMeasurement.Fim_ILEndB AS [Il_B], ";
                asql      += "dbo.TFiberMeasurement.Fim_ReflectanceEndB AS [Refl_B], ";
                asql      += "dbo.TDUTMeasurement.Dum_MeasurementDate AS [TestDate] ";
                asql      += " FROM dbo.TDUTMeasurement LEFT OUTER JOIN";
                asql      += " dbo.TTestTemplate ON ";
                asql      += " dbo.TDUTMeasurement.Dum_Tst_Id = dbo.TTestTemplate.Tst_Id LEFT OUTER JOIN";
                asql      += " dbo.TFiberMeasurement ON";
                asql      += " dbo.TFiberMeasurement.Fim_Dum_Id = dbo.TDUTMeasurement.Dum_Id LEFT OUTER JOIN";
                asql      += " dbo.TCustomer ON ";
                asql      += " dbo.TTestTemplate.Tst_Cus_Id = dbo.TCustomer.Cus_Id LEFT OUTER JOIN";
                asql      += " dbo.TDutModel ON ";
                asql      += " dbo.TTestTemplate.Tst_Dtm_Id = dbo.TDutModel.Dtm_Id LEFT OUTER JOIN";
                asql      += " dbo.TCable ON dbo.TCable.Cab_Dtm_Id = dbo.TDutModel.Dtm_Id LEFT OUTER JOIN";
                asql      += " dbo.TFiber ON dbo.TFiber.Fib_Cab_Id = dbo.TCable.Cab_Id LEFT OUTER JOIN";
                asql      += " dbo.TConnector AS StartingConnector ON ";
                asql      += " dbo.TFiber.Fib_Starting_Con_Id = StartingConnector.Con_Id LEFT OUTER JOIN";
                asql      += " dbo.TWaveLength ON";
                asql      += " dbo.TFiberMeasurement.Fim_Wvl_Id = dbo.TWaveLength.Wvl_Id";
                asql      += " WHERE (dbo.TDUTMeasurement.Dum_FixSerialNr LIKE '" + e.SN + "%') AND (TDUTMeasurement.Dum_GlobalTestStatus = '1')) AS TemTab";
                asql      += " WHERE " + e.sqlWhere + "  AND (Result LIKE '%Passed')";
                e.TestData = dbs_Exfo.Query(asql);
            }
            if (e.TestData.Tables[0].Rows.Count > 0)
            {
                ArrayList temAl = new ArrayList();
                temAl.Add("1");
                e.PigtailList = temAl;
            }
            // e.PiagtilNum = e.TestData.Tables[0].Rows[0][""].ToString();
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取 MPO JDS数据
        /// </summary>
        public void GetData_MPO(My_GetTestData.GetDataEventArgs e)
        {
            //查询JDSU中的数据
            string sql = " SELECT LEFT(SN, 13) AS SN, SUBSTRING(SN, 15, 2) AS Name, Result, Wave, IL_A, ABS(Refl_A) AS Refl_A, IL_B, Refl_B, TestDate ";

            sql          += " FROM User_JDS_Test_Good";
            sql          += " WHERE " + e.sqlWhere + "  AND (Result LIKE '%Passed')";
            e.TestData    = dbs.Query(sql);
            e.PigtailList = Get_PigtailList(e.TestData, 11);

            //查询Exfo中的数据
            bool tem = false;

            if (e.TestData.Tables[0].Rows.Count > 0)
            {
                tem = false;
            }
            else
            {
                tem = true;
            }

            //如果JDS表中没有数据 从Exfo测试表中查找
            if (tem)
            {
                string asql = " SELECT * FROM (SELECT CAST(TDUTMeasurement.Dum_FixSerialNr AS nvarchar(20))  ";
                asql += "  + '-' + TDUTMeasurement.Dum_IncrSerialNr AS SN,  TFiber.Fib_SequenceNr AS Name, ";
                asql += " (CASE WHEN dbo.TDUTMeasurement.Dum_GlobalTestStatus = 1 THEN 'PASS' END) AS Result, ";
                asql += " (CASE WHEN dbo.TWaveLength.Wvl_Value = 0.0000013100 THEN '1310nm' WHEN ";
                asql += " dbo.TWaveLength.Wvl_Value = 0.0000015500 THEN '1550nm'   ";
                asql += " WHEN dbo.TWaveLength.Wvl_Value = 0.0000008500 THEN '850nm' WHEN dbo.TWaveLength.Wvl_Value = 0.0000013000 THEN '1300nm' END) ";
                asql += " AS Wave, TFiberMeasurement.Fim_ILEndA AS Il_A, ";
                asql += " TFiberMeasurement.Fim_ReflectanceEndA AS Refl_A, ";
                asql += " TFiberMeasurement.Fim_ILEndB AS Il_B, ";
                asql += " TFiberMeasurement.Fim_ReflectanceEndB AS Refl_B, ";
                asql += " TDUTMeasurement.Dum_MeasurementDate AS TestDate";
                asql += " FROM TFiber INNER JOIN";
                asql += " TFiberMeasurement ON ";
                asql += " TFiber.Fib_Id = TFiberMeasurement.Fim_Fib_Id RIGHT OUTER JOIN ";
                asql += " TDUTMeasurement ON ";
                asql += " TFiberMeasurement.Fim_Dum_Id = TDUTMeasurement.Dum_Id LEFT OUTER JOIN";
                asql += " TWaveLength ON ";
                asql += " TFiberMeasurement.Fim_Wvl_Id = TWaveLength.Wvl_Id";
                asql += " WHERE (TDUTMeasurement.Dum_FixSerialNr = '" + e.SN + "') AND ";
                asql += " (TDUTMeasurement.Dum_GlobalTestStatus = '1')) AS derivedtbl_1";
                //赋值返回的测试数据
                e.TestData    = dbs_Exfo.Query(asql);
                e.PigtailList = Get_PigtailList(e.TestData, 11);
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 双并查询 有IN条件
        /// </summary>
        /// <param name="e"></param>
        public void Getdata_Method_TwainCore(My_GetTestData.GetDataEventArgs e)
        {
            string sql = " SELECT TOP (100) PERCENT LEFT(SN, 13) AS SN, SUBSTRING(SN, 12, 2) AS Name, Type, ";

            sql       += " Result, Curvature, Curvature_Result, Spherical, Spherical_Result, Planar, ";
            sql       += " Planar_Result, Apex_Offset, Apex_Offset_Result, Bearing, Bearing_Result, ";
            sql       += " Apex_Angle, Apex_Angle_Result, Tilt_Offset, Tilt_Offset_Result, Tilt_Angle, ";
            sql       += "  Tilt_Angle_Result, KeyError, KeyError_Result, FiberRq, FiberRq_Result, FiberRa, ";
            sql       += " FiberRa_Result, FerruleRq, FerruleRq_Result, FerruleRa, FerruleRa_Result, ";
            sql       += " Diameter, Diameter_Result, Test_Date, Test_Time, D, E, F, A ";
            sql       += " FROM User_3D_Test_Good ";
            sql       += " WHERE " + e.sqlWhere + " AND (Result LIKE N'%PASS%') ";
            e.TestData = dbs.Query(sql);
            if (e.TestData.Tables[0].Rows.Count > 0)
            {
                e.PigtailList = GetPigtailList(e.TestData);
            }
        }