public static void LoadBITestDateFromAuto(Controller ctrl) { var syscfgdict = CfgUtility.GetSysConfig(ctrl); var bitables = syscfgdict["BIAUTOTABLES"].Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); var bizerotime = syscfgdict["BIZEROTIME"]; foreach (var bt in bitables) { var testresultlist = new List <BITestResult>(); var testresultfieldlist = new List <BITestResultDataField>(); var bilatesttime = RetrieveLatestTimeStampOfAnBITable(bt, bizerotime); var sql = "select ContainerName,ProcessStep,DateTime,Failure_Mode,Station,Work_Order,PN,Channel,SLOPE,PO_LD,PO_Uniformity,THOLD,Delta_PO_LD,Delta_SLOPE,Delta_THOLD,Delta_PO_Uniformity from <bitable> where DateTime > '<bilatesttime>' " + " and ProcessStep is not null and PN is not null and Work_Order is not null and ContainerName is not null and Failure_Mode is not null and ContainerName <> '' and Failure_Mode <> '--' and Failure_Mode <> '' and Failure_Mode is not null order by ContainerName,DateTime"; sql = sql.Replace("<bitable>", bt).Replace("<bilatesttime>", bilatesttime); var dbret = DBUtility.ExeAutoSqlWithRes(sql); foreach (var line in dbret) { var sn = Convert.ToString(line[0]); var testname = Convert.ToString(line[1]); var testtime = DateTime.Parse(ConvertToDateStr(line[2])); var failure = Convert.ToString(line[3]); var station = Convert.ToString(line[4]); var jo = Convert.ToString(line[5]); var pn = Convert.ToString(line[6]); var ch = Convert.ToString(line[7]); var slope = Convert.ToDouble(line[8]); var pold = Convert.ToDouble(line[9]); var pouniformity = Convert.ToDouble(line[10]); var thold = Convert.ToDouble(line[11]); var dpold = Convert.ToDouble(line[12]); var dslope = Convert.ToDouble(line[13]); var dthold = Convert.ToDouble(line[14]); var dpouniformity = Convert.ToDouble(line[15]); var tempresult = new BITestResult(sn, testname, station, failure, testtime, pn, jo, bt); testresultlist.Add(tempresult); var tempfield = new BITestResultDataField(sn, testname, testtime, pn, jo, ch, slope, pold, pouniformity, thold, dpold, dslope, dthold, dpouniformity); testresultfieldlist.Add(tempfield); }//end foreach StoreBITestResult(testresultlist); StoreBITestResultDateField(testresultfieldlist); }//end foreach }