//窗口加载时进行更新检测,并进行更新 private void Window_Loaded(object sender, RoutedEventArgs e) { //获取配置文件中服务器地址 //判断文件是否存在 try { if (File.Exists(address)) { FileStream file = new FileStream(address, FileMode.Open); StreamReader reader = new StreamReader(file); String temp = reader.ReadLine(); serverPath = temp; file.Close(); reader.Close(); } } catch (IOException) { } ; Update update = new Update(); String serverDbName = GetFileName.GetFileNameWithonExtension(serverPath); if (serverDbName == null) { return; } String localDbName = GetFileName.GetFileNameWithonExtension(localPath); if (update.AntoUpdateOrNot()) { MessageBoxResult result = MessageBox.Show("当前软件需要更新", "提示", MessageBoxButton.OKCancel); if (result == MessageBoxResult.OK) { String filename = Assembly.GetExecutingAssembly().Location; File.Move(filename, filename + ".delete"); File.Copy(serverPath + "\\" + "TeamProjectDevelopment.exe", filename); String DbName = GetFileName.getFileName(serverPath); String conStr = databaseCon + serverPath + "\\" + DbName; OleDbConnection connection = CreateDb.getConn(conStr); connection.Open(); String selectString = "delete from config1 where fileName=\"TeamProjectDevelopment.exe\""; OleDbCommand command = new OleDbCommand(selectString, connection); command.ExecuteNonQuery(); connection.Close(); update.AutoUpdate(); } } if (update.UpdateOrNot()) { MessageBoxResult result = MessageBox.Show("当前有版本更新,需要更新吗?", "更新", MessageBoxButton.OKCancel); if (result == MessageBoxResult.OK) { update.update(this); } } }
public static OleDbConnection getCon() { String localDbName = GetFileName.getFileName(localPath); String conStr = databaseCon + localPath + "\\" + localDbName; OleDbConnection connection = getConn(conStr); String selectString = "select * from config1"; OleDbCommand command = new OleDbCommand(selectString, connection); return(connection); }
public void GetFileName_getMetadata_ReturnsCorrectString() { GetFileName name = new GetFileName(); string guid = "eb31d4ff-be0b-4366-9838-994ed803dd69"; string destPath = "Testpfad"; //act string result = name.GetMetadataName(destPath, guid); //assert Assert.That(result, Is.EqualTo(@"Testpfad\eb31d4ff-be0b-4366-9838-994ed803dd69_Metadata.xml")); }
// コンストラクタ public MainViewModel(GetFileName funcGFN1, GetFileName funcGFN2) { // PreviewImageFlg = PreviewImage.Select(p => p != null).ToReadOnlyReactiveProperty(); // ShowImageDataFlg1.Subscribe(_ => RedrawViewImage()); ShowImageDataFlg2.Subscribe(_ => RedrawViewImage()); ShowImageDataFlg3.Subscribe(_ => RedrawViewImage()); // CreateFormationPictureCommand.Subscribe(_ => { var image = CreateFormationPicture(); if (image == null) { return; } string filePath = funcGFN2(); if (filePath != "") { if (System.IO.Path.GetExtension(filePath) != ".png") { filePath += ".png"; } image.Save(filePath, ImageFormat.Png); } }); DeleteDataAllCommand.Subscribe(_ => { var result = MessageBox.Show("リストの画像を全て消去しますか?", "編成まとめ隊", MessageBoxButtons.YesNo, MessageBoxType.Question); if (result == DialogResult.Yes) { piecePictureData.Clear(); PiecePictureList1.Clear(); PiecePictureList2.Clear(); PiecePictureList3.Clear(); RedrawViewImage(); } }); AddPiecePicture1Command.Subscribe(_ => { AddPiecePicture(funcGFN1(), PiecePictureType.Main); }); AddPiecePicture2Command.Subscribe(_ => { AddPiecePicture(funcGFN1(), PiecePictureType.Support); }); AddPiecePicture3Command.Subscribe(_ => { AddPiecePicture(funcGFN1(), PiecePictureType.Base); }); DeletePiecePicture1Command.Subscribe(_ => { DeletePiecePicture(PiecePictureType.Main); }); DeletePiecePicture2Command.Subscribe(_ => { DeletePiecePicture(PiecePictureType.Support); }); DeletePiecePicture3Command.Subscribe(_ => { DeletePiecePicture(PiecePictureType.Base); }); MoveUpPiecePicture1Command.Subscribe(_ => { MoveUpPiecePicture(PiecePictureType.Main); }); MoveUpPiecePicture2Command.Subscribe(_ => { MoveUpPiecePicture(PiecePictureType.Support); }); MoveUpPiecePicture3Command.Subscribe(_ => { MoveUpPiecePicture(PiecePictureType.Base); }); MoveDownPiecePicture1Command.Subscribe(_ => { MoveDownPiecePicture(PiecePictureType.Main); }); MoveDownPiecePicture2Command.Subscribe(_ => { MoveDownPiecePicture(PiecePictureType.Support); }); MoveDownPiecePicture3Command.Subscribe(_ => { MoveDownPiecePicture(PiecePictureType.Base); }); DeletePiecePictureAll1Command.Subscribe(_ => { DeletePiecePictureAll(PiecePictureType.Main); }); DeletePiecePictureAll2Command.Subscribe(_ => { DeletePiecePictureAll(PiecePictureType.Support); }); DeletePiecePictureAll3Command.Subscribe(_ => { DeletePiecePictureAll(PiecePictureType.Base); }); }
private void CreateCommands() { GetProcessesCommand = new RelayCommand(o => { UpdateProcesses(); }); GetFilesOverviewCommand = new RelayCommand(o => UpdateFiles()); GetInputFilesFromFolderCommand = new RelayCommand(o => InputDirectory = GetFolderName()); RefreshJobsCommand = new RelayCommand(o => UpdateJobs()); AddJobCommand = new RelayCommand(o => AddJob()); DeleteJobCommand = new RelayCommand( async o => await api.DeleteJob(SelectedProcess.Id, SelectedJob.JobId), o => SelectedJob != null); GetMeCommand = new RelayCommand(o => { UpdateLoginName(); }); DeleteFileCommand = new RelayCommand <IRemotePath>(async o => { if (!(o is IRemotePath remotePath)) { return; } var remotePaths = o is RemoteFolder folder ? folder.GetAllSubPathsRecursive().ToArray() : new[] { remotePath }; foreach (var path in remotePaths) { var success = await api.DeleteFile(path.FullPath); if (!success) { ErrorMessage = $"Could not delete {o}"; } } UpdateFiles(); }, o => o != null); DownloadFileCommand = new RelayCommand <IRemotePath>(async remotePath => { var fileName = GetFileName?.Invoke(remotePath.Name); if (fileName == null) { return; } await api.DownloadFile(remotePath.FullPath, fileName); }); }
public static OleDbDataReader DbConnect(String path) { String DbName = GetFileName.getFileName(path); String conStr = databaseCon + path + "\\" + DbName; OleDbConnection connection = getConn(conStr); String selectString = "select * from config1"; OleDbCommand command = new OleDbCommand(selectString, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); return(reader); }
public void GetFileName_getContent_ReturnsCorrectString() { //arrange GetFileName name = new GetFileName(); const string guid = "eb31d4ff-be0b-4366-9838-994ed803dd69"; const string filePath = "Testpfad.txt"; const string destPath = "Testpfad"; //act string result = name.GetContentName(filePath, guid, destPath); //assert Assert.That(result, Is.EqualTo(@"Testpfad\eb31d4ff-be0b-4366-9838-994ed803dd69_Content.txt")); }
public void SoftwareUpdate() { String filename = Assembly.GetExecutingAssembly().Location; File.Move(filename, filename + ".delete"); File.Copy(serverPath + "\\" + softwareName, filename); String DbName = GetFileName.getFileName(serverPath); String conStr = databaseCon + serverPath + "\\" + DbName; OleDbConnection connection = CreateDb.getConn(conStr); connection.Open(); String selectString = "delete from config1 where fileName=\"" + softwareName + "\""; OleDbCommand command = new OleDbCommand(selectString, connection); command.ExecuteNonQuery(); connection.Close(); AutoUpdate(); }
private void BtnOpenFileDialog_Click(object sender, RoutedEventArgs e) { if (!TbTfs.Text.Equals("")) { System.Windows.Forms.OpenFileDialog openFileDialog1 = new System.Windows.Forms.OpenFileDialog(); openFileDialog1.Title = "Dosya Seçiniz"; openFileDialog1.InitialDirectory = "C:\\"; openFileDialog1.ShowDialog(); TbFileName.Text = openFileDialog1.FileName; //OpenAndWorkOnFile(TbFileName.Text); OpenXmlPowerTools.GetFileName FileGet = new GetFileName(); myCollection.AddRange(FileGet.SelectFile(TbFileName.Text)); Mygrid.IsEnabled = true; } else { MessageBoxResult result = System.Windows.MessageBox.Show("Please Choose Test Project&Plan"); } }
public void generateLocalVersion(String DbPath) { CopyFile copyFile = new CopyFile(); String DbName = GetFileName.getFileName(DbPath); OleDbDataReader reader = CreateDb.DbConnect(DbPath); String path = versionFile; System.IO.Directory.CreateDirectory(path + "\\" + "本地版本" + Path.GetFileNameWithoutExtension(DbName)); DirectoryInfo dir = new DirectoryInfo(path + "\\" + "本地版本" + Path.GetFileNameWithoutExtension(DbName)); dir.Create(); while (reader.Read()) { String tempStr = (String)reader["path"]; String targetDir = dir + "\\" + Path.GetFileName(tempStr); copyFile.copyFile(tempStr, targetDir); } copyFile.copyFile(DbPath + "\\" + DbName, dir + "\\" + DbName); MessageBox.Show("生成版本成功", "提示", MessageBoxButton.OK); }
public void update(Window oldWindow) { //判断文件是否存在 CopyFile copyFile = new CopyFile(); String serverDbName = GetFileName.getFileName(serverPath); OleDbDataReader reader = CreateDb.DbConnect(serverPath); while (reader.Read()) { String tempStr = (String)reader["fileName"]; String originFile = serverPath + "\\" + tempStr; String updateMethod = (String)reader["updateMethod"]; if (updateMethod.Equals("删除") && File.Exists(localPath + "\\" + tempStr)) { File.Delete(localPath + "\\" + tempStr); } else { copyFile.copyFile(originFile, localPath + "\\" + tempStr); } } if (reader != null) { reader.Close(); } //最后复制服务器配置文件到本地,并删除原来的配置文件 String localDbName = GetFileName.getFileName(localPath); copyFile.copyFile(serverPath + "\\" + serverDbName, localPath + "\\" + localDbName); /* * if (serverDbName != localDbName) * File.Delete(localPath + "\\" + localDbName); */ SuccessTips(oldWindow); }
public bool AntoUpdateOrNot() { //判断文件是否存在 String serverDbName = GetFileName.getFileName(serverPath); if (serverDbName == null) { return(false); } OleDbDataReader serverReader = CreateDb.DbConnect(serverPath); while (serverReader.Read()) { if (serverReader["fileName"].Equals(softwareName)) { serverReader.Close(); return(true); } } serverReader.Close(); return(false); }
private void Button3_Click(object sender, EventArgs e) { string imagePath = textBox1.Text; string savePath = textBox2.Text; if (textBox3.Text == "" || textBox4.Text == "") { GetErrorPage.Get("错误:未输入横向像素点跨度或纵向像素点跨度"); return; } string w = textBox3.Text; string h = textBox4.Text; int.TryParse(w, out int wSpan); int.TryParse(h, out int hSpan); string imageName = GetFileName.Get(imagePath); // 使用推荐字符组 if (checkBox1.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c256.txt", wSpan, hSpan, GrayValueString.c_256); } if (checkBox2.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c128.txt", wSpan, hSpan, GrayValueString.c_128); } if (checkBox3.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c64.txt", wSpan, hSpan, GrayValueString.c_64); } if (checkBox4.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c32.txt", wSpan, hSpan, GrayValueString.c_32); } if (checkBox5.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c16.txt", wSpan, hSpan, GrayValueString.c_16); } if (checkBox6.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c8.txt", wSpan, hSpan, GrayValueString.c_8); } if (checkBox7.Checked) { Transformation.ImageToChar(imagePath, savePath + imageName + "_c4.txt", wSpan, hSpan, GrayValueString.c_4); } // 使用自定义字符组 string[] replaceChars = { textBox5.Text, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text, textBox11.Text, }; int num = 1; for (int index = 0; index < replaceChars.Length; ++index) { if (replaceChars[index] != "") { Transformation.ImageToChar(imagePath, savePath + imageName + "_custom_" + num + ".txt", wSpan, hSpan, replaceChars[index]); ++num; } } }
public Save(GetFileName files) { InitializeComponent(); filePath = files; }
static void Main(string[] args) { FileInfo = new FileInformation(); while (ValueFormatter.isEmpty(FileInfo.InputFileName)) { Out.WriteLine("Please copy and paste file path in .csv or .tsv format"); FileInfo.InputFileName = ReadLine(); } FileInfo.ReadResults = GetFileName.ReadFileName(FileInfo.InputFileName); string numberOfFields = null; int temp2; while (ValueFormatter.isEmpty(numberOfFields) || !int.TryParse(numberOfFields, out temp2)) { WriteLine("Enter number of fields"); numberOfFields = ReadLine(); } int fieldsInRecords = 0; try { fieldsInRecords = Convert.ToInt32(numberOfFields); FileInfo.NumberOfFields = fieldsInRecords; FileInfo.Results = GetLines.ReturnDetailRecords(FileInfo.ReadResults); FileInfo.NewResults = FileInfo.Results.Skip(1).ToList(); char delimiter = GetFileName.CheckFileName(FileInfo.InputFileName); //Once you run this, it'll write the files to your bin direcotry FileInfo.EnvironmentDirectory = WriteToFile.GetEnvironmentDirectory(); foreach (var rec in FileInfo.NewResults) { var returnedFields = GetLines.ReturnFields(rec, delimiter); var isRecordCorrect = GetLines.GetFieldCount(returnedFields, fieldsInRecords); if (isRecordCorrect == false) { var pathCombined = Path.Combine(FileInfo.EnvironmentDirectory, "errorrecs.txt"); Out.WriteLine($"directory is {pathCombined}"); WriteToFile.WriteErrorsToFile(pathCombined, rec); } else { var pathCombined = Path.Combine(FileInfo.EnvironmentDirectory, "correct.txt"); Out.WriteLine($"directory is {pathCombined}"); WriteToFile.WriteErrorsToFile(pathCombined, rec); } } Console.WriteLine($"the delimiter is {delimiter}"); Console.WriteLine(FileInfo.NewResults.Count); } catch (System.FormatException fe) { Out.WriteLine($"No fields were read {fe}"); } Console.Out.WriteLine("Bonsoir, Elliot"); Console.ReadKey(); }
public void TestInitialize() { fut = GetFileName.ReadFileName(@"C:\Temp\TestFile.csv"); readFileResults = GetLines.ReturnDetailRecords(fut); }
//判断是否需要更新 public bool UpdateOrNot() { String serverDbName = GetFileName.getFileName(serverPath); if (serverDbName == null) { return(false); } //String DbName = GetFileName.getFileName(serverPath); String serverConStr = databaseCon + serverPath + "\\" + serverDbName; OleDbConnection serverConnection = new OleDbConnection(serverConStr); String serverSelectString = "select * from config1"; OleDbCommand serverCommand = new OleDbCommand(serverSelectString, serverConnection); serverConnection.Open(); OleDbDataReader serverReader = serverCommand.ExecuteReader(); //OleDbDataReader serverReader = CreateDb.DbConnect(serverPath); //OleDbDataReader localReader = CreateDb.DbConnect(localPath); String localDbName = GetFileName.getFileName(localPath); String localConStr = databaseCon + localPath + "\\" + localDbName; OleDbConnection localConnection = new OleDbConnection(localConStr); String localSelectString = "select * from config1"; OleDbCommand localCommand = new OleDbCommand(localSelectString, localConnection); localConnection.Open(); OleDbDataReader localReader = localCommand.ExecuteReader(); if (localReader.Read()) { try { localVersion = (int)localReader["versionNum"]; } catch { localVersion = 1; } } if (serverReader.Read()) { serverVersion = (int)serverReader["versionNum"]; } Console.WriteLine("localVersion:" + localVersion); Console.WriteLine("serverVersion:" + serverVersion); if (localVersion < serverVersion) { serverReader.Close(); localReader.Close(); localConnection.Close(); serverConnection.Close(); return(true); } else { serverReader.Close(); localReader.Close(); localConnection.Close(); serverConnection.Close(); return(false); } }