/// <summary> /// 根据Id获取一行所有的信息(未测试) /// 历史记录表 /// </summary> /// <param name="id">Id</param> /// <returns>null 代表没有此行或者数据收到损坏</returns> public HistoryModel GetHistoryTotalRecord(int id) { HistoryModel record = new HistoryModel(); //连接数据库 using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString)) { sqlConnect.Open(); String commandString = String.Format("SELECT * FROM " + HistoryTableName + " WHERE Id='{0}'", id); SQLiteCommand command = sqlConnect.CreateCommand(); command.CommandText = commandString; using (SQLiteDataReader reader = command.ExecuteReader()) { if (reader.Read()) { try { //读取所有的信息 record.Id = id; record.StartWork = new HParaModel(reader["StartWork"].ToString()); record.IdlingWork = new HParaModel(reader["IdlingWork"].ToString()); record.IdlingBreak = new HParaModel(reader["IdlingBreak"].ToString()); record.ReviseBegin = new HParaModel(reader["ReviseBegin"].ToString()); record.ReviseWork = new HParaModel(reader["ReviseWork"].ToString()); record.ReviseEnd = new HParaModel(reader["ReviseEnd"].ToString()); record.DemWork = new HParaModel(reader["DemWork"].ToString()); record.AdjWork = new HParaModel(reader["AdjWork"].ToString()); record.HighBreak = new HParaModel(reader["HighBreak"].ToString()); record.Tem = new RangeValue(reader["Tem"].ToString()); record.EquCode = reader["EquCode"].ToString(); record.EquType = reader["EquType"].ToString(); record.HDate = reader["HDate"].ToString(); record.HTime = reader["HTime"].ToString(); record.IsPass = bool.Parse(reader["IsPass"].ToString()); } catch (Exception) { record = null; } } else { record = null; } } return(record); } }
/// <summary> /// 获取所有的简短信息(未测试) /// 历史记录表 /// </summary> /// <returns></returns> public List <HistoryModel> GetHistoryAllShortRecord() { List <HistoryModel> datas = new List <HistoryModel>(); //连接数据库 using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString)) { String commandString = "SELECT Id,EquType,HDate,HTime,IsPass FROM " + HistoryTableName; sqlConnect.Open(); SQLiteCommand command = sqlConnect.CreateCommand(); command.CommandText = commandString; using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { HistoryModel record = new HistoryModel(); try { //获取用于显示的简短数据 record.Id = int.Parse(reader["Id"].ToString()); record.EquType = reader["EquType"].ToString(); record.HDate = reader["HDate"].ToString(); record.HTime = reader["HTime"].ToString(); record.IsPass = bool.Parse(reader["IsPass"].ToString()); datas.Add(record); } catch (Exception e) { } } } return(datas); } }
/// <summary> /// 插入一条新的记录(未测试)(插入可行,但未检查完整性) /// 历史记录表 /// </summary> /// <param name="model">需要添加的新模型</param> /// <returns>插入表中自动生成的Id,-1代表失败</returns> public int AddHistoryRecord(HistoryModel model) { int id = -1; string sql = string.Format("Insert Into " + HistoryTableName + "(StartWork,IdlingWork, IdlingBreak, ReviseBegin,ReviseWork, ReviseEnd,DemWork,AdjWork,HighBreak,Tem,EquCode,EquType,HDate,HTime,IsPass) Values" + "('{0}', '{1}', '{2}', '{3}','{4}', '{5}', '{6}', '{7}','{8}', '{9}','{10}','{11}','{12}','{13}' , '{14}')", model.StartWork, model.IdlingWork, model.IdlingBreak, model.ReviseBegin, model.ReviseWork, model.ReviseEnd, model.DemWork, model.AdjWork, model.HighBreak, model.Tem, model.EquCode, /*model.IconHex,*/ model.EquType, model.HDate, model.HTime, model.IsPass.ToString()); //连接数据库 using (SQLiteConnection sqlConnect = new SQLiteConnection(ConnectingString)) { //打开连接 sqlConnect.Open(); SQLiteCommand command = sqlConnect.CreateCommand(); command.CommandText = sql; //如果成功插入则代表成功 if (command.ExecuteNonQuery() == 1) { String getIdCommandString = "SELECT last_insert_rowid() FROM " + HistoryTableName; SQLiteCommand getIdCommand = sqlConnect.CreateCommand(); getIdCommand.CommandText = getIdCommandString; //读取刚刚插入的ID,赋值给模型 using (SQLiteDataReader reader = getIdCommand.ExecuteReader()) { reader.Read(); id = reader.GetInt32(0); } } } return(id); }
/// <summary> /// 历史测试记录是否符合要求 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IsMatchRequire(HistoryModel model) { if (StartWork != null) { if (!StartWork.IsMatchTheRequire(model.StartWork)) { return(false); } } if (IdlingWork != null) { if (!IdlingWork.IsMatchTheRequire(model.IdlingWork)) { return(false); } } if (IdlingBreak != null) { if (!IdlingBreak.IsMatchTheRequire(model.IdlingBreak)) { return(false); } } if (ReviseBegin != null) { if (!ReviseBegin.IsMatchTheRequire(model.ReviseBegin)) { return(false); } } if (ReviseWork != null) { if (!ReviseWork.IsMatchTheRequire(model.ReviseWork)) { return(false); } } if (ReviseEnd != null) { if (!ReviseEnd.IsMatchTheRequire(model.ReviseEnd)) { return(false); } } if (DemWork != null) { if (!DemWork.IsMatchTheRequire(model.DemWork)) { return(false); } } if (AdjWork != null) { if (!AdjWork.IsMatchTheRequire(model.AdjWork)) { return(false); } } if (HighBreak != null) { if (!HighBreak.IsMatchTheRequire(model.HighBreak)) { return(false); } } if (Tem != null) { if (!Tem.IsInRange(model.Tem)) { return(false); } } return(true); }