/// <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)); } }