private void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = GetDgvToTable(dataGridView1);
dt.DefaultView.Sort = "index";
string csvFileName = System.IO.Path.GetTempFileName();
CSVFileHelper.SaveCSV(dt, csvFileName);
if (File.Exists("Server.dat.bak"))
{
File.Delete("Server.dat.bak");
}
File.Move("Server.dat", "Server.dat.bak");
DESFileClass.EncryptFile(csvFileName, "Server.dat", "c2Soecqg9f5GXCflI7c6wBNq4fAXiZcS");
File.Delete(csvFileName);
this.Close();
}
public static void LoadGrid(DataGridView dataGridView, string group)
{
//if (File.Exists("Server.csv"))
//{
// DESFileClass.EncryptFile("Server.csv", "Server.dat", "c2Soecqg9f5GXCflI7c6wBNq4fAXiZcS");
// //File.Delete("Server.csv");
//}
if (File.Exists("Server.dat"))
{
string csvFileName = System.IO.Path.GetTempFileName();
DESFileClass.DecryptFile("Server.dat", csvFileName, "c2Soecqg9f5GXCflI7c6wBNq4fAXiZcS");
dt = CSVFileHelper.ReadCSV(csvFileName);
File.Delete(csvFileName);
if (!dt.Columns.Contains("OrderIndex"))
{
dt.Columns.Add("OrderIndex", typeof(Int32));
}
foreach (DataRow row in dt.Rows)
{
int index = 0;
int.TryParse(row["Index"].ToString(), out index);
row["OrderIndex"] = index;
}
dt.DefaultView.Sort = "OrderIndex ASC";
if (string.Compare(group, "All", false) != 0)
{
dt.DefaultView.RowFilter = string.Format("Group = '{0}'", group);
dataGridView.DataSource = dt.DefaultView;
}
else
{
dataGridView.DataSource = dt.DefaultView;
}
}
}