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);
}
