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