WPF学习记录

目录

• 1. 获取Debug文件目录
• 2. npoi简单操作
• 3. Textbox多行设置
• 4. byte转16进制
• 5. CRC16校验
• 6.读写app.config
• 7.UI占位
• 8.字体图片文件
• 9.FluentFTP简单操作
• 10.NPOI简单插入新行
• 11.WPF元素隐藏显示与占位
• 12.单例模式
• 13.TextBox多行输入
• 14.XAML时间格式化
• 15.viewmodel里面获取dispatcher

1. 获取Debug文件目录

string str = System.Environment.CurrentDirectory;
输出结果：X:/工程/bin/debug

2. npoi简单操作

public OutExcel(List<OutExcelModel> list)
        {
            IWorkbook wb = null;
            using (FileStream fs = new FileStream(filePath,FileMode.Open,FileAccess.ReadWrite))
            {
                wb = WorkbookFactory.Create(fs);
            }
            ISheet sheet = wb.GetSheetAt(0);
            IRow row = sheet.GetRow(2);
            ICell cell = row.GetCell(1);
            cell.SetCellValue(1);
            using (FileStream newfs = new FileStream(outFilePath, FileMode.Create, FileAccess.ReadWrite))
            {
                wb.Write(newfs);
            }
        }

3. Textbox多行设置

TextWrapping=“Wrap” AcceptsReturn=“True” VerticalScrollBarVisibility=“Visible”

4. byte转16进制

Convert.ToString(item, 16)

5. CRC16校验

public  byte[] CRC16(byte[] data)
        {
            int len = data.Length;
            if (len > 0)
            {
                ushort crc = 0xFFFF;

                for (int i = 0; i < len; i++)
                {
                    crc = (ushort)(crc ^ (data[i]));
                    for (int j = 0; j < 8; j++)
                    {
                        crc = (crc & 1) != 0 ? (ushort)((crc >> 1) ^ 0xA001) : (ushort)(crc >> 1);
                    }
                }
                byte hi = (byte)((crc & 0xFF00) >> 8); //高位置
                byte lo = (byte)(crc & 0x00FF); //低位置

                return new byte[] { lo, hi };
            }
            return new byte[] { 0, 0 };
        }

6.读写app.config

System.Configuration.Configuration  config = System.Configuration.ConfigurationManager.OpenExeConfiguration(System.Configuration.ConfigurationUserLevel.None);
//读取
string sqlServer = config.AppSettings.Settings["MySQLServer"].Value;
//写入
config.AppSettings.Settings["MySQLServer"].Value = "XXX";
//增加节点
 config.AppSettings.Settings.Add("MySQLServer","XXX");

7.UI占位

<ContentPresenter Content="{Binding MyDate}" />

8.字体图片文件

要设置字体文件属性为资源

<TextBlock
	Text="&#xe613;"
	FontFamily="pack://application:,,,/../Icon/#iconfont" />

9.FluentFTP简单操作

using FluentFTP;
using System;
using System.Diagnostics;
using System.IO;
using System.Net;
using System.Windows;

namespace FtpTest
{
    class Ftp
    {
        private static Ftp ftp = null;
        static Ftp()
        {
            ftp = new Ftp();
        }

        private string user = "FtpTest";
        private string password = "123";
        private string ftpHost = "ftp://192.168.1.246/";
        private string basePath = "/Test/";                                         //Ftp内部基础路径
        private string tempPath = Environment.CurrentDirectory + "Temp/temp.jpg";   //下载文件临时储存路径（这个存在debug文件夹下）
        /// <summary>
        /// 把FTP上面的文件下载到本地，然后通过process打开
        /// path：文件在ftp内的路径
        /// </summary>
        /// <param name="path"></param>
        private void Open(string path)
        {
            using (FtpClient connection = new FtpClient())
            {
                connection.Host = ftpHost;
                connection.Credentials = new NetworkCredential(user, password);
                byte[] outbytes;
                connection.Download(out outbytes, basePath+path);
                if (outbytes==null)
                {
                    MessageBox.Show("未找到该文件");
                    return;
                }
                using (FileStream fs = new FileStream(tempPath,FileMode.Create,FileAccess.ReadWrite,FileShare.ReadWrite))
                {
                    fs.Write(outbytes, 0, outbytes.Length);
                }
                using (Process pro = new Process())
                {
                    pro.StartInfo.FileName = tempPath;
                    pro.Start();
                }
            }
        }

        /// <summary>
        /// 直接将byte[]数组上传到Ftp上面指定路径path
        /// </summary>
        /// <param name="bytes"></param>
        /// <param name="path"></param>
        private void UpLoad(byte[] bytes,string path)
        {
            using (FtpClient connection = new FtpClient())
            {
                connection.Host = ftpHost;
                connection.Credentials = new NetworkCredential(user, password);
                connection.Upload(bytes, basePath+path);
            }
        }
    }
}

10.NPOI简单插入新行

        public void Level1WorkSheet(string path)
        {
            IWorkbook wb = null;
            using (FileStream fs = new FileStream(level1Path, FileMode.Open, FileAccess.ReadWrite))
            {
                wb = WorkbookFactory.Create(fs);
            }
            ISheet sheet = wb.GetSheetAt(0);
            IRow row = sheet.GetRow(4 + i);
            var rowStyle = row.RowStyle;
			 if (i!=level1List.Count-1)
                {
                    sheet.ShiftRows(5 + i, sheet.LastRowNum, 1,true,true);
                    var insertRow = sheet.CreateRow(5 + i);
                    if (rowStyle!=null)
                    {
                        insertRow.RowStyle = rowStyle;
                    }
                    insertRow.Height = row.Height;
                    for (int col = 0; col < row.LastCellNum; col++)
                    {
                        var cellsource = row.GetCell(col);
                        var cellInsert = insertRow.CreateCell(col);
                        var cellStyle = cellsource.CellStyle;
                        //设置单元格样式　　　　
                        if (cellStyle != null)
                            cellInsert.CellStyle = cellsource.CellStyle;
                    }
                }
            using (FileStream newfs = new FileStream(path, FileMode.Create, FileAccess.ReadWrite))
            {
                wb.Write(newfs);
            }
        }

11.WPF元素隐藏显示与占位

    // 摘要:
    //     指定元素的显示状态。
    public enum Visibility : byte
    {
        //
        // 摘要:
        //     显示元素。
        Visible = 0,
        //
        // 摘要:
        //     不显示元素，但是在布局中为元素保留空间。
        Hidden = 1,
        //
        // 摘要:
        //     不显示元素，并且不在布局中为它保留空间。
        Collapsed = 2
    }

12.单例模式

https://www.cnblogs.com/igeekfan/p/Singleton-Pattern.html

13.TextBox多行输入

<TextBox
  TextWrapping="Wrap"
  VerticalContentAlignment="Top"
  AcceptsReturn="True"
  VerticalScrollBarVisibility="Visible"/>

14.XAML时间格式化

要求被格式化数据的类型是DateTime

StringFormat='yyyy-MM-dd'
StringFormat={}{0:yyyy-MM-dd}

15.viewmodel里面获取dispatcher

  App.Current.Dispatcher