private void Form1_Load(object sender, EventArgs e) { Assistance.Init(); Assistance.LoadSettings(); BindingDatas(); //NameNumLength = FileLength(numpath); spb.obj = toolStripStatusLabel1; pastDBSHA1 = Assistance.Settings.ShA1OfDB; if (SECURITY_Enabled == true) { if (pastDBSHA1 != Assistance.GetSHA1Hash(Settings.DBpath)) { var pib = new PasswordInputDialog(this, "检测到不安全的数据修改,请输入管理员密码", true); pib.Owner = this; pib.Show(); } } conn.ConnectionString = "Data Source=" + Settings.DBpath; TBOutput.Location = pictureBox1.Location; TBOutput.Size = pictureBox1.Size; TBOutput.Visible = false; ReadDataFromDatabase(); LoadConfig_SelectedClassroom(); ShowSelectedClassroomCheckbox(); }
public void updateDataBase() { if (AllStudents.Count == 0) { return; } foreach (Student astd in AllStudents) { astd.Sha1 = astd.getSHA1(); } Stopwatch sw = new Stopwatch(); sw.Start(); SQLiteConnection conn = new SQLiteConnection(); conn.ConnectionString = "Data source=" + Settings.DBpath; conn.Open(); var cmd = conn.CreateCommand(); StringBuilder tempCmd = new StringBuilder("replace into students values"); foreach (var astd in AllStudents) { tempCmd.Append(getStudentText(astd) + ","); } tempCmd.Remove(tempCmd.Length - 1, 1); cmd.CommandText = tempCmd.ToString(); cmd.ExecuteNonQuery(); // loadStudent(); sw.Stop(); var sw1 = new StreamWriter(Settings.SHA1ofDBpath, false); sw1.WriteLine(Assistance.GetSHA1Hash(Settings.DBpath)); sw1.Close(); spb.add("完成更新!用时" + sw.ElapsedMilliseconds + "ms"); }