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);
}
public static Boolean IsNeedUpdateSoftware()
{
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)
{
logger.Error(string.Format("文件 {0} 已损坏，请联系管理员！"));
throw new Exception(string.Format("文件 {0} 已损坏，请联系管理员！"));
}
Boolean r = Convert.ToBoolean(ServerFileVersionManager.CallRemoteService("Yqun.BO.ApplicationUpdater.dll", "IsNeedUpdateSoftware", new object[] { Data }));
logger.Error(r ? "" : "");
return(r);
}
public static Boolean SaveLocalFile(List <UpdaterFileInfo> UpdaterFilesInfo)
{
Boolean Result = false;
String AppConfig = Path.Combine(Application.StartupPath, "AppConfig");
String DataSource = Path.Combine(AppConfig, "DataUpdater.dat");
SimpleDataService DataService = new SimpleDataService(DataSource, 1024);
IDbConnection Connection = DataService.GetConnection();
Transaction Transaction = new Transaction(Connection);
StringBuilder sql_select = new StringBuilder();
sql_select.Append("select * from sys_updaterfiletable");
DataTable Data = DataService.GetDataTable(sql_select.ToString());
if (Data != null)
{
foreach (UpdaterFileInfo UpdaterFile in UpdaterFilesInfo)
{
DataRow DataRow;
DataRow[] DataRows = Data.Select("FileName='" + UpdaterFile.FileName + "'");
if (DataRows.Length > 0)
{
DataRow = DataRows[0];
DataRow["FileName"] = UpdaterFile.FileName;
DataRow["FileData"] = UpdaterFile.FileData;
DataRow["FileVersion"] = UpdaterFile.FileVersion;
}
else
{
DataRow = Data.NewRow();
DataRow["ID"] = Guid.NewGuid().ToString();
DataRow["FileName"] = UpdaterFile.FileName;
DataRow["FileData"] = UpdaterFile.FileData;
DataRow["FileVersion"] = UpdaterFile.FileVersion;
Data.Rows.Add(DataRow);
}
}
}
try
{
object r = DataService.UpdateCommand(Data, Transaction);
Result = (Convert.ToInt32(r) == 1);
if (Result)
{
Transaction.Commit();
}
else
{
Transaction.Rollback();
}
}
catch
{
Transaction.Rollback();
}
return(Result);
}