public static List <UpdaterFileInfo> GetLocalOldFile()
{
List <UpdaterFileInfo> oldFilesInfo = new List <UpdaterFileInfo>();
String AppConfig = Path.Combine(Application.StartupPath, "AppConfig");
String DataSource = Path.Combine(AppConfig, "DataUpdater.dat");
SimpleDataService DataService = new SimpleDataService(DataSource, 1024);
StringBuilder sql_select = new StringBuilder();
sql_select.Append("select FileName,FileVersion from sys_updaterfiletable");
DataTable Data = DataService.GetDataTable(sql_select.ToString());
if (Data != null && Data.Rows.Count > 0)
{
foreach (DataRow Row in Data.Rows)
{
UpdaterFileInfo oldFileInfo = new UpdaterFileInfo();
oldFileInfo.FileName = Row["FileName"].ToString();
oldFileInfo.FileVersion = Row["FileVersion"].ToString();
oldFilesInfo.Add(oldFileInfo);
}
}
return(oldFilesInfo);
}
private void SaveButton_Click(object sender, EventArgs e)
{
List <UpdaterFileInfo> UpdaterFiles = new List <UpdaterFileInfo>();
for (int i = 0; i < NewFile_Spread_Sheet1.Rows.Count; i++)
{
String FileName = Path.Combine(NewFile_Spread_Sheet1.Rows[i].Tag.ToString(), NewFile_Spread_Sheet1.Cells[i, 0].Text);
UpdaterFileInfo UpdaterFile = new UpdaterFileInfo();
UpdaterFile.FileName = NewFile_Spread_Sheet1.Cells[i, 0].Text;
UpdaterFile.FileData = File.ReadAllBytes(FileName);
UpdaterFile.FileVersion = NewFile_Spread_Sheet1.Cells[i, 1].Text.Replace('_', '0');
UpdaterFiles.Add(UpdaterFile);
}
Boolean Result = ServerFileVersionManager.SaveUpdaterFile(UpdaterFiles);
String Message = (Result ? "保存成功。" : "保存失败！");
MessageBoxIcon Icon = (Result ? MessageBoxIcon.Information : MessageBoxIcon.Error);
MessageBox.Show(Message, "提示", MessageBoxButtons.OK, Icon);
}
public List <UpdaterFileInfo> GetExistingFile()
{
List <UpdaterFileInfo> Files = new List <UpdaterFileInfo>();
StringBuilder sql_select = new StringBuilder();
sql_select.Append("select FileName,FileVersion,FileData from sys_updaterfiletable");
DataTable DataTable = GetDataTable(sql_select.ToString());
foreach (DataRow Row in DataTable.Rows)
{
UpdaterFileInfo File = new UpdaterFileInfo();
File.FileName = Row["FileName"].ToString();
File.FileVersion = Row["FileVersion"].ToString();
File.FileData = (byte[])Row["FileData"];
Files.Add(File);
}
return(Files);
}
