/// <summary>
/// 获取更新程序
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool GetUpgrade(int id)
{
AMS.Model.ProgramUpgrade programModel = AMS.ServiceProxy.ProjecVersionWindow.GetProgramUpgradeByID(id);
if (programModel != null)
{
FileOperate advertfileOperate = new FileOperate();
SeatManage.EnumType.SeatManageSubsystem systemType = (SeatManage.EnumType.SeatManageSubsystem)(int) programModel.Application;
SeatManage.Bll.FileOperate seatmanagefileOperate = new SeatManage.Bll.FileOperate();
SeatManage.ClassModel.FileUpdateInfo programInfo = SeatManage.ClassModel.FileUpdateInfo.Convert(programModel.AutoUpdaterXml);
List <string> filePath = programInfo.BuildUpdateFilePaths();
foreach (string path in filePath)
{
string fullPath = string.Format("{0}{1}", ServiceSet.TempFilePath, path);
//文件下载
if (advertfileOperate.FileDownLoad(fullPath, path, systemType) != "")
{
return(false);
}
if (!seatmanagefileOperate.UpdateFile(fullPath, path, systemType))
{
return(false);
}
}
//执行完成，不需要更新数据库。
//上传完毕删除本地的文件以及文件夹。
SeatManage.ClassModel.FileUpdateInfo.DelDirectorys(ServiceSet.TempFilePath);
return(true);
}
return(true);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AMS.Model.ProgramUpgrade GetModel(string Version, int application)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Application,AutoUpdaterXml,UpdateLog,ReleaseDate,Version,Remark from ProgramUpgrade ");
strSql.Append(" where Version=@Version");
strSql.Append(" and Application=@Application");
SqlParameter[] parameters =
{
new SqlParameter("@Version", SqlDbType.NVarChar),
new SqlParameter("@Application", SqlDbType.Int)
};
parameters[0].Value = Version;
parameters[1].Value = application;
AMS.Model.ProgramUpgrade model = new AMS.Model.ProgramUpgrade();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Application"] != null && ds.Tables[0].Rows[0]["Application"].ToString() != "")
{
model.Application = int.Parse(ds.Tables[0].Rows[0]["Application"].ToString());
}
if (ds.Tables[0].Rows[0]["AutoUpdaterXml"] != null && ds.Tables[0].Rows[0]["AutoUpdaterXml"].ToString() != "")
{
model.AutoUpdaterXml = ds.Tables[0].Rows[0]["AutoUpdaterXml"].ToString();
}
if (ds.Tables[0].Rows[0]["UpdateLog"] != null && ds.Tables[0].Rows[0]["UpdateLog"].ToString() != "")
{
model.UpdateLog = ds.Tables[0].Rows[0]["UpdateLog"].ToString();
}
if (ds.Tables[0].Rows[0]["ReleaseDate"] != null && ds.Tables[0].Rows[0]["ReleaseDate"].ToString() != "")
{
model.ReleaseDate = DateTime.Parse(ds.Tables[0].Rows[0]["ReleaseDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Version"] != null && ds.Tables[0].Rows[0]["Version"].ToString() != "")
{
model.Version = ds.Tables[0].Rows[0]["Version"].ToString();
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
return(model);
}
else
{
return(null);
}
}
private void btnIssued_Click(object sender, RoutedEventArgs e)
{
if (lstProjectVersionList.SelectedIndex < 0)
{
vm_pv.ErrorMessage = "请选择要下发的版本！";
return;
}
AMS.Model.ProgramUpgrade model = lstProjectVersionList.SelectedItem as AMS.Model.ProgramUpgrade;
SyatemManage.IssuedSchoolSelectWindow iss = new IssuedSchoolSelectWindow(AMS.Model.Enum.CommandType.ProgramUpgrade, model.Id);
iss.ShowDialog();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public AMS.Model.ProgramUpgrade GetModelByID(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Application,AutoUpdaterXml,UpdateLog,ReleaseDate,Version,Remark from ProgramUpgrade ");
strSql.Append(" where Id=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", id)
};
AMS.Model.ProgramUpgrade model = new AMS.Model.ProgramUpgrade();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Application"] != null && ds.Tables[0].Rows[0]["Application"].ToString() != "")
{
model.Application = int.Parse(ds.Tables[0].Rows[0]["Application"].ToString());
}
if (ds.Tables[0].Rows[0]["AutoUpdaterXml"] != null && ds.Tables[0].Rows[0]["AutoUpdaterXml"].ToString() != "")
{
model.AutoUpdaterXml = ds.Tables[0].Rows[0]["AutoUpdaterXml"].ToString();
}
if (ds.Tables[0].Rows[0]["UpdateLog"] != null && ds.Tables[0].Rows[0]["UpdateLog"].ToString() != "")
{
model.UpdateLog = ds.Tables[0].Rows[0]["UpdateLog"].ToString();
}
if (ds.Tables[0].Rows[0]["ReleaseDate"] != null && ds.Tables[0].Rows[0]["ReleaseDate"].ToString() != "")
{
model.ReleaseDate = DateTime.Parse(ds.Tables[0].Rows[0]["ReleaseDate"].ToString());
}
if (ds.Tables[0].Rows[0]["Version"] != null && ds.Tables[0].Rows[0]["Version"].ToString() != "")
{
model.Version = ds.Tables[0].Rows[0]["Version"].ToString();
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(AMS.Model.ProgramUpgrade model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ProgramUpgrade set ");
strSql.Append("Application=@Application,");
strSql.Append("AutoUpdaterXml=@AutoUpdaterXml,");
strSql.Append("UpdateLog=@UpdateLog,");
strSql.Append("ReleaseDate=@ReleaseDate,");
strSql.Append("Version=@Version,");
strSql.Append("Remark=@Remark");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Application", SqlDbType.Int, 4),
new SqlParameter("@AutoUpdaterXml", SqlDbType.Text),
new SqlParameter("@UpdateLog", SqlDbType.NVarChar, 4000),
new SqlParameter("@ReleaseDate", SqlDbType.DateTime),
new SqlParameter("@Version", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Application;
parameters[1].Value = model.AutoUpdaterXml;
parameters[2].Value = model.UpdateLog;
parameters[3].Value = model.ReleaseDate;
parameters[4].Value = model.Version;
parameters[5].Value = model.Remark;
parameters[6].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public string AddNewProgramUpgrade(Model.ProgramUpgrade model)
{
try
{
AMS.Model.ProgramUpgrade sameModel = dal_ProgramUpgrade.GetModel(model.Version, model.Application);
if (sameModel != null)
{
return("该程序已存在相同的版本！");
}
if (dal_ProgramUpgrade.Add(model) == 0)
{
return("添加失败！");
}
else
{
return("");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(AMS.Model.ProgramUpgrade model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ProgramUpgrade(");
strSql.Append("Application,AutoUpdaterXml,UpdateLog,ReleaseDate,Version,Remark)");
strSql.Append(" values (");
strSql.Append("@Application,@AutoUpdaterXml,@UpdateLog,@ReleaseDate,@Version,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Application", SqlDbType.Int, 4),
new SqlParameter("@AutoUpdaterXml", SqlDbType.Text),
new SqlParameter("@UpdateLog", SqlDbType.NVarChar, 4000),
new SqlParameter("@ReleaseDate", SqlDbType.DateTime),
new SqlParameter("@Version", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300)
};
parameters[0].Value = model.Application;
parameters[1].Value = model.AutoUpdaterXml;
parameters[2].Value = model.UpdateLog;
parameters[3].Value = model.ReleaseDate;
parameters[4].Value = model.Version;
parameters[5].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
