public static List <SNProVM> RetrieveTestFlowData(List <string> SNList) { var ret = new List <SNProVM>(); var sncond = "('" + string.Join("','", SNList) + "')"; var sql = @"SELECT distinct [ModuleSN],[PN],[WhichTest],[TestTimeStamp],[ErrAbbr],[TestStation] FROM [BSSupport].[dbo].[ModuleTestData] WHERE ModuleSN in <sncond> order by ModuleSN,TestTimeStamp asc"; sql = sql.Replace("<sncond>", sncond); var dbret = DBUtility.ExeBSSqlWithRes(sql); foreach (var line in dbret) { try { var tempvm = new SNProVM(Convert.ToString(line[0]), Convert.ToString(line[1]) , Convert.ToString(line[2]), Convert.ToDateTime(line[3]).ToString("yyyy-MM-dd HH:mm:ss")); tempvm.Failure = Convert.ToString(line[4]); tempvm.Tester = Convert.ToString(line[5]); ret.Add(tempvm); } catch (Exception ex) { } } return(ret); }