public JsonResult QueryScrap()
{
var scraptable = RetrieveScrapData();
foreach (var item in scraptable)
{
ScrapHistoryVM.AddHistory(item);
}
var ret = new JsonResult();
ret.Data = new
{
sucess = true,
data = scraptable
};
return(ret);
}
private List <string> PrepeareSNScrapHistory()
{
var historytable = ScrapHistoryVM.RetrieveHistory();
var ret = new List <string>();
var line = "SN,Date Code,PN,Site,Failure Code,Match Rule,Result,Create Date";
ret.Add(line);
foreach (var item in historytable)
{
var line1 = string.Empty;
line1 = "\"" + item.SN.ToString().Replace("\"", "") + "\"," + "\"" + item.DateCode.Replace("\"", "") + "\"," + "\"" + item.PN.Replace("\"", "") + "\","
+ "\"" + item.WhichTest.Replace("\"", "") + "\"," + "\"" + item.ErrAbbr.Replace("\"", "") + "\"," + "\"" + item.MatchRule.Replace("\"", "")
+ "\"," + "\"" + item.Result.Replace("\"", "") + "\"," + "\"" + item.CreateDate.ToString("yyyy-MM-dd HH:mm:ss").Replace("\"", "") + "\",";
ret.Add(line1);
}
return(ret);
}
