public SPIFileParser(ConfigItem item, IFolderAccess folderAccess)
: base(item.Line, item.SrcFolder, item.FileMask, false, 0, 1)
{
this._item = item;
_folder = folderAccess;
_info = new TestRecordInfo();
setLogger(new DailyFileLogger(item.LogFolder, "SPI", ".txt"));
}
public List <TestRecordInfo> ListPreviousPoints(int n)
{
List <TestRecordInfo> list = new List <TestRecordInfo>();
string cmdText = @"select * from TestRecord
where FileTime < @FileTime and Line = @Line
and ModelName = @Model and BoardType = @BoardType
order by FileTime desc
limit @n";
MySqlParameter[] paras = new MySqlParameter[] {
new MySqlParameter("@FileTime", info.FileTime),
new MySqlParameter("@Line", info.Line),
new MySqlParameter("@Model", info.Model.ModelName),
new MySqlParameter("@BoardType", info.Model.BoardType),
new MySqlParameter("@n", n)
};
using (MySqlConnection conn = new MySqlConnection(_connString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(cmdText, conn);
cmd.Parameters.AddRange(paras);
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
TestRecordInfo tr = new TestRecordInfo
{
ID = Convert.ToInt32(dr["ID"]),
Customer = dr["CustomerCode"].ToString(),
Model = new ModelInfo
{
ModelName = dr["ModelName"].ToString(),
BoardType = dr["BoardType"].ToString()
},
FileName = dr["FileName"].ToString(),
FileTime = Convert.ToDateTime(dr["FileTime"]),
Line = dr["Line"].ToString(),
X = Convert.ToDouble(dr["X"]),
R = Convert.ToDouble(dr["R"]),
XFlag = (Status)dr["XFlag"],
RFlag = (Status)dr["RFlag"]
};
list.Add(tr);
}
}
}
return(list);
}
public TestRecord(TestRecordInfo info)
{
this._info = info;
_dal.info = info;
_list = _dal.ListPreviousPoints(29);
}
