コード例 #1
0
ファイル: DatabaseHelper.cs プロジェクト: WangXiang10/xinli
 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;
     }
 }
コード例 #2
0
ファイル: DatabaseHelper.cs プロジェクト: WangXiang10/xinli
        // 返回某个用户相关的所有实验记录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;
            }
        }
コード例 #3
0
        // 初始化界面
        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;
        }