Exemplo n.º 1
0
        public static List <SnTestDataVM> RetrieveLatestSNStep(string sn)
        {
            var testdatalist = new List <SnTestDataVM>();

            var sql = @"select top 1 ProductId,MoveOutTime,WorkflowStepName,Comments,TxnTypeName
                        from PDMSMaster.dbo.HistStepMoveSummary (nolock) where ContainerName = '<ContainerName>'  and MFGOrderId is not null order by MoveOutTime desc";

            sql = sql.Replace("<ContainerName>", sn.Replace("'", ""));
            var dbret = DBUtility.ExeMESReportSqlWithRes(sql, null);

            if (dbret.Count > 0)
            {
                var line = dbret[0];
                var data = new SnTestDataVM();
                data.ModuleSerialNum = sn;
                data.DataID          = Convert.ToString(line[0]);
                data.TestTime        = Convert.ToDateTime(line[1]);
                data.WhichTest       = Convert.ToString(line[2]);
                data.ErrAbbr         = "";
                if (!string.IsNullOrEmpty(Convert2Str(line[3])))
                {
                    data.ErrAbbr = Convert2Str(line[3]);
                }
                testdatalist.Add(data);
            }
            return(testdatalist);
        }
Exemplo n.º 2
0
        public static void RetrieveTestData(List <ScrapTableItem> scraptable)
        {
            foreach (var stab in scraptable)
            {
                var mestablist = RetrieveDCTableFromSn(stab.SN);

                var ret = new List <SnTestDataVM>();
                foreach (var tabname in mestablist)
                {
                    var sql = "select top 1 dc_<DCTABLE>HistoryId,ModuleSerialNum, ErrAbbr, TestTimeStamp,assemblypartnum,WhichTest,TestStation from "
                              + " insite.dc_<DCTABLE> (nolock)  where ModuleSerialNum = '<modulesn>'";
                    sql = sql.Replace("<modulesn>", stab.SN).Replace("<DCTABLE>", tabname);
                    var dbret = DBUtility.ExeRealMESSqlWithRes(sql);
                    foreach (var line in dbret)
                    {
                        var data = new SnTestDataVM();
                        data.DataID          = Convert.ToString(line[0]);
                        data.ModuleSerialNum = Convert.ToString(line[1]);
                        data.ErrAbbr         = Convert.ToString(line[2]);
                        data.TestTime        = Convert.ToDateTime(line[3]);
                        data.PN          = Convert.ToString(line[4]);
                        data.WhichTest   = Convert.ToString(line[5]);
                        data.TestStation = Convert.ToString(line[6]);
                        data.MESTab      = tabname.ToUpper().Trim();
                        ret.Add(data);
                    }
                }

                ret.Sort(delegate(SnTestDataVM d1, SnTestDataVM d2)
                {
                    return(DateTime.Compare(d2.TestTime, d1.TestTime));
                });

                if (ret.Count > 0)
                {
                    stab.TestData = ret[0];
                }
                else
                {
                    stab.TestData = new SnTestDataVM();
                }
            }
        }
Exemplo n.º 3
0
        public static List <SnTestDataVM> RetrieveLatestSNTestResult(string sn)
        {
            var dctablelist  = RetrieveDCTableFromSn(sn);
            var testdatalist = new List <SnTestDataVM>();

            foreach (var dctable in dctablelist)
            {
                if (dctable.Contains("OQCPARALLEL") ||
                    dctable.Contains("AOC_MANUALINSPECTION"))
                {
                    continue;
                }

                var sql = @"select top 1 a.<DCTABLE>HistoryId,a.ModuleSerialNum, a.WhichTest, a.ModuleType, a.ErrAbbr, a.TestTimeStamp, a.TestStation,a.assemblypartnum 
                               from insite.<DCTABLE> a (nolock) where a.ModuleSerialNum = '<ModuleSerialNum>' order by  testtimestamp DESC";
                sql = sql.Replace("<DCTABLE>", dctable).Replace("<ModuleSerialNum>", sn);
                var dbret = DBUtility.ExeRealMESSqlWithRes(sql);
                foreach (var item in dbret)
                {
                    var tempdata = new SnTestDataVM(Convert.ToString(item[0]), Convert.ToString(item[1]), Convert.ToString(item[7]), Convert.ToString(item[2])
                                                    , Convert.ToString(item[4]), dctable, Convert.ToDateTime(item[5]), Convert.ToString(item[6]));

                    testdatalist.Add(tempdata);
                }
            }

            testdatalist.Sort(delegate(SnTestDataVM obj1, SnTestDataVM obj2)
            {
                return(obj2.TestTime.CompareTo(obj1.TestTime));
            });

            var ret = new List <SnTestDataVM>();

            ret.Add(testdatalist[0]);
            return(ret);
        }