public static bool SaveExperimentRecord(ExperimentRecord experiment_record) { string string_of_register_experiment_record = string.Format("insert into `" + ExperimentRecordTableName + "` (`UserInfoID`, `ExperimentName`, `Date`, `Times`) values ('{0}','{1}','{2}','{3}');", experiment_record.UserInfoID.ToString(), Convert.ToInt32(experiment_record.ExperimentName).ToString(), experiment_record.Date.ToString(), experiment_record.Times.ToString()); if (_DatabaseInUse == DatabaseType.MySql) { if(MySql.MySqlHelper.ExecuteCommand(string_of_register_experiment_record) != 1) return false; return true; } else { return false; } }
// 返回某个用户相关的所有实验记录UserInfoID\ ExperimentName\ Date\ Times public static bool GetExperimentRecordGivenUserInfoID(int user_info_ID, out ExperimentRecord experiment_record) { string string_of_query = "select `UserInfoID`, `ExperimentName`, `Date`, `Times` from `" + ExperimentRecordTableName + "` where `UserInfoID`='" + user_info_ID.ToString() + "';"; experiment_record = new ExperimentRecord(); if (_DatabaseInUse == DatabaseType.MySql) { DataSet dataset = MySql.MySqlHelper.ExecuteQuery(string_of_query); if (dataset.Tables[0].Rows.Count == 0) return false; DataRow row = dataset.Tables[0].Rows[0]; DataColumnCollection colums = dataset.Tables[0].Columns; experiment_record.UserInfoID = Convert.ToInt32(row["UserInfoID"].ToString()); experiment_record.ExperimentName = (ExperimentType)(Convert.ToInt32(row["ExperimentName"].ToString())); experiment_record.Date = DateTime.Parse(row["Date"].ToString()); experiment_record.Times = Convert.ToInt32(row["Times"].ToString()); return true; } else { return false; } }
// 初始化界面 private void Init() { CurrentExperimentRecord = new ExperimentRecord(); CurrentExperimentRecord.UserInfoID = MainWindow.UserInfoID; try { if (DatabaseHelper.GetLoginName(MainWindow.UserInfoID, out LoginName)) LabelExperimenterName.Content = LoginName; } catch (Exception ex) { // 获取LoginName 失败 DatabaseMessage.ShowDatabaseFailure(ex.Message); } // UI初始化设置 BtnExpRun.IsEnabled = true; BtnExpEnd.IsEnabled = false; BtnExpResult.IsEnabled = false; TxtTrainingGroupCount.Text = TrialTrainingCount.ToString(); TxtTestGroupCount.Text = TrialTestCount.ToString(); LabelTotalGroupCount.Content = (TrialTrainingCount + TrialTestCount).ToString(); LabelTrialTime.Content = TimeSpan.Zero.ToString(@"hh\:mm\:ss"); //LabelFps.Content = ""; CheckBoxCamera.IsChecked = true; }