public bool Update(FileUpdateInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE [dbo].[AutoUpdater] SET ");
strSql.Append("[AutoUpdaterXml] =@AutoUpdaterXml, ");
strSql.Append("[UpdateLog] =@Remart, ");
strSql.Append("[ReleaseDate] =@ReleaseDate ");
strSql.Append(" WHERE Application=@Application ");
SqlParameter[] parameters =
{
new SqlParameter("@AutoUpdaterXml", model.ToString()),
new SqlParameter("@Remart", model.UpdateLog),
new SqlParameter("@ReleaseDate", model.ReleaseDate),
new SqlParameter("@Application", (int)model.SubsystemType)
};
try
{
int i = DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 系统Xml信息上传
/// </summary>
public string SystemUpdate()
{
try
{
system.ReleaseDate = DateTime.Now;
system.StartProgram = StartProgram;
system.SubsystemType = (SeatManage.EnumType.SeatManageSubsystem)(int) SystemType;
system.UpdateLog = string.Format("{0}{1}\r{2}\r\r", oldSystem == null ? "" : oldSystem.UpdateLog, DateTime.Now.ToShortDateString(), UpdateLog);
system.Version = Version;
AdvertManage.Model.ProgramUpgradeModel model = new AdvertManage.Model.ProgramUpgradeModel();
model.Application = SystemType;
model.AutoUpdaterXml = system.ToString();
model.ReleaseDate = DateTime.Now;
model.UpdateLog += string.Format("{0}{1}\r{2}\r\r", oldSystem == null ? "" : oldSystem.UpdateLog, DateTime.Now.ToShortDateString(), UpdateLog);
model.Version = Version;
if (AdvertManage.BLL.ProgramUpgradeBLL.ReleaseProgram(model) == AdvertManage.Model.Enum.HandleResult.Successed)
{
return("更新成功");
}
else
{
return("更新失败");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 添加一条新的纪录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(FileUpdateInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AutoUpdater ([Application] ,[AutoUpdaterXml] ,[UpdateLog] ,[ReleaseDate] )");
strSql.Append(" values (@Application ,@AutoUpdaterXml ,@UpdateLog ,@ReleaseDate )");
SqlParameter[] parameters =
{
new SqlParameter("@Application", (int)model.SubsystemType),
new SqlParameter("@AutoUpdaterXml", model.ToString()),
new SqlParameter("@UpdateLog", model.UpdateLog),
new SqlParameter("@ReleaseDate", model.ReleaseDate.ToString())
};
try
{
int i = DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
