编码方法整理Code篇

C#

1.Json数据转换成DataTable 👍

        /// <summary>
        /// Json数据转换成DataTable
        /// </summary>
        /// <remark>
        /// </remark>
        /// <param name="Json"></param>
        /// <param name="TableName"></param>
        /// <returns></returns>
        public DataTable JsonConvertToDataTable(String TableName, String Json)
        {
            DataTable dataTable = new DataTable();
            dataTable.TableName = TableName;
            JArray array = JsonConvert.DeserializeObject(Json) as JArray;
            if (array != null && array.Count > 0)
            {
                StringBuilder columns = new StringBuilder();
                JObject objColumns = array[0] as JObject;
                //构造表头
                //AsEnumerable 引用报错 可以尝试AsJEnumerable
                foreach (JToken jkon in objColumns.AsEnumerable<JToken>())
                {
                    string name = ((JProperty)(jkon)).Name;
                    columns.Append(name + ",");
                    dataTable.Columns.Add(name);
                }
                //向表中添加数据
                for (int i = 0; i < array.Count; i++)
                {
                    DataRow row = dataTable.NewRow();
                    JObject obj = array[i] as JObject;
                    foreach (JToken jkon in obj.AsEnumerable<JToken>())
                    {
                        string name = ((JProperty)(jkon)).Name;
                        string value = ((JProperty)(jkon)).Value.ToString();
                        row[name] = value;
                    }
                    dataTable.Rows.Add(row);
                }
            }
            return dataTable;
        }

2.将JArray转换为datatable 👍

        /// <summary>
        /// 将JArray转换为datatable
        /// </summary>
        /// <param name="dataArr"></param>
        /// <returns></returns>
        public DataTable JArrayToDatable(JArray dataArr)
        {
            if (dataArr == null || dataArr.Count <= 0) return null;
            DataTable result = new DataTable();
            var colnames = ((JObject)dataArr.First).Properties();
            List<string> columnNames = new List<string>();
            if (colnames == null) return null;
            foreach (var item in colnames)
            {
                if (!columnNames.Contains(item.Name))
                {
                    columnNames.Add(item.Name);
                }
                result.Columns.Add(item.Name, typeof(string));
            }
            foreach (JObject data in dataArr)
            {
                JObject jo = JObject.Parse(data.ToString());
                DataRow row = result.NewRow();
                foreach (var columnName in columnNames)
                {
                    if (jo.Property(columnName) == null)
                    {
                        data.Add(columnName, "");
                        row[columnName] = data[columnName].ToString();
                    }
                    else
                    {
                        row[columnName] = data[columnName].ToString();
                    }
                }
                result.Rows.Add(row);
            }
            return result;
        }

3.DataTable使用Select方法之后，把结果转换成DataTable 👍

/// <summary> 
/// 扩展DataTable Select结果为DataTable
/// </summary> 
/// <remark> 
/// </remark>
public DataTable DataTableSelect(this DataTable me, string where)
{
    if(me == null || me.Rows.Count == 0) return me;
    var dtNew = me.Clone();
    var drArray = me.Select(where);
    foreach(var item in drArray)
    dtNew.Rows.Add(item.ItemArray);
    return dtNew;
}

4. dot net core读取appsettings.json配置 👍

        /// <summary>
        /// 读取配置信息
        /// </summary>
        /// <remarks>
        /// </remarks>
        /// <typeparam name="T"></typeparam>
        /// <param name="name"></param>
        /// <returns></returns>
        public static T Getconfig<T>(string name) where T : class, new()
        {
            IConfiguration config = new ConfigurationBuilder().Add(new JsonConfigurationSource
            {
                Path = "appsettings.json",
                ReloadOnChange = true
            }).Build();
            var appconfig = new ServiceCollection().AddOptions().Configure<T>(config.GetSection(name)).BuildServiceProvider().GetService<IOptions<T>>().Value;
            return appconfig;
        }

5.Socket获取以太网IP（会筛掉虚拟网卡）👍

/// <summary>
/// 通过socket获取IP
/// </summary>
/// <returns></returns>
public static string SocketGetIp()
{
    string localIP = string.Empty;
    using(Socket socket = new Socket(AddressFamily.InterNetwork, SocketType.Dgram, 0))
    {
        socket.Connect("8.8.8.8", 65530);
        IPEndPoint endPoint = socket.LocalEndPoint as IPEndPoint;
        localIP = endPoint.Address.ToString();
    }
    return localIP;
}

6.Dns获取IP（只获取IP V4的外网IP） 😄

public static void SocketGetIp()
{
    string localIP = string.Empty;
    using(Socket socket = new Socket(AddressFamily.InterNetwork, SocketType.Dgram, 0))
    {
        socket.Connect("8.8.8.8", 65530);
        IPEndPoint endPoint = socket.LocalEndPoint as IPEndPoint;
        localIP = endPoint.Address.ToString();
    }
    Console.WriteLine("IP Address = " + localIP);
}

7.Network获取外网IP 😄

public static void NetworkGetIp()
{
    NetworkInterface[] nics = NetworkInterface.GetAllNetworkInterfaces();
    foreach(NetworkInterface adapter in nics)
    {
        bool Pd1 = (adapter.NetworkInterfaceType == NetworkInterfaceType.Ethernet); //判断是否是以太网连接
        if(Pd1)
        {
            Console.WriteLine("网络适配器名称：" + adapter.Name);
            Console.WriteLine("网络适配器标识符：" + adapter.Id);
            Console.WriteLine("适配器连接状态：" + adapter.OperationalStatus.ToString());
            IPInterfaceProperties ip = adapter.GetIPProperties(); //IP配置信息
            if(ip.UnicastAddresses.Count > 0)
            {
                Console.WriteLine("IP地址:" + ip.UnicastAddresses.Where(d => d.IsDnsEligible == true).FirstOrDefault().Address.ToString());
                //Console.WriteLine("IP地址:" + ip.UnicastAddresses[0].Address.ToString());
                Console.WriteLine("子网掩码:" + ip.UnicastAddresses[0].IPv4Mask.ToString());
            }
            if(ip.GatewayAddresses.Count > 0)
            {
                Console.WriteLine("默认网关:" + ip.GatewayAddresses[0].Address.ToString()); //默认网关
            }
            int DnsCount = ip.DnsAddresses.Count;
            Console.WriteLine("DNS服务器地址："); //默认网关
            if(DnsCount > 0)
            {
                //其中第一个为首选DNS，第二个为备用的，余下的为所有DNS为DNS备用，按使用顺序排列
                for(int i = 0; i < DnsCount; i++)
                {
                    Console.WriteLine("              " + ip.DnsAddresses[i].ToString());
                }
            }
            Console.WriteLine("网络接口速度：" + (adapter.Speed / 1000000).ToString("0.0") + "Mbps");
            Console.WriteLine("接口描述：" + adapter.Description);
            Console.WriteLine("适配器的媒体访问控制 (MAC) 地址:" + adapter.GetPhysicalAddress().ToString());
            Console.WriteLine("该接口是否只接收数据包：" + adapter.IsReceiveOnly.ToString());
            Console.WriteLine("该接口收到的字节数：" + adapter.GetIPv4Statistics().BytesReceived.ToString());
            Console.WriteLine("该接口发送的字节数：" + adapter.GetIPv4Statistics().BytesSent.ToString());
            Console.WriteLine("该接口丢弃的传入数据包数：" + adapter.GetIPv4Statistics().IncomingPacketsDiscarded.ToString());
            Console.WriteLine("该接口丢弃的传出数据包数：" + adapter.GetIPv4Statistics().OutgoingPacketsDiscarded.ToString());
            Console.WriteLine("该接口有错误的传入数据包数：" + adapter.GetIPv4Statistics().IncomingPacketsWithErrors.ToString());
            Console.WriteLine("该接口有错误的传出数据包数：" + adapter.GetIPv4Statistics().OutgoingPacketsWithErrors.ToString());
            Console.WriteLine("该接口协议未知的数据包数：" + adapter.GetIPv4Statistics().IncomingUnknownProtocolPackets.ToString());
            Console.WriteLine("---------------------------------------------------------------------\n");
        }
    }
}

8.校验datatable中被更改的列 👍

        /// <summary>
        /// 校验datatable中被更改的列
        /// </summary>
        /// <param name="dt">验证的datatable</param>
        /// <returns>FiledName 字段名称 OldValue 改之前的值 NewValue 修改后的值</returns>
        public static List<object> CheckDataTableColumnChange(DataTable dt)
        {
            if (dt == null || dt.Rows == null || dt.Rows.Count == 0) return null;
            //获取datatable中所有的列名称
            List<string> columnList = new List<string>();
            foreach (DataColumn dc in dt.Columns)
            {
                columnList.Add(dc.ColumnName);
            }
            List<object> checkList = new List<object>();
            foreach (DataRow dataRow in dt.Rows)
            {
                //使用列名称进行匹配
                foreach (var item in columnList)
                {
                    var a = dataRow[item];
                    string oldVal = dataRow[item, DataRowVersion.Original]?.ToString();
                    string newVal = dataRow[item, DataRowVersion.Current]?.ToString();
                    if (!oldVal.Equals(newVal))
                    {
                        checkList.Add(new
                        {
                            FieldName = item,
                            OldValue = oldVal,
                            NewValue = newVal
                        });
                    }
                }
            }
            return checkList;
        }

9.文件加密👍

/// <summary>
/// 文件加密
/// </summary>
/// <param name="inputFile">要加密的文件路径</param>
/// <param name="outputFile">加密后的文件存放路径</param>
public static void EncryptFile(string inputFile, string outputFile)   //加密
{
    try
    {
        string password = @"12345678";
        UnicodeEncoding UE = new UnicodeEncoding();
        byte[] key = UE.GetBytes(password);

        string cryptFile = outputFile;
        FileStream fsCrypt = new FileStream(cryptFile, FileMode.Create);

        RijndaelManaged RMCrypto = new RijndaelManaged();

        CryptoStream cs = new CryptoStream(fsCrypt,
            RMCrypto.CreateEncryptor(key, key),
            CryptoStreamMode.Write);

        FileStream fsIn = new FileStream(inputFile, FileMode.Open);

        int data;
        while ((data = fsIn.ReadByte()) != -1)
            cs.WriteByte((byte)data);


        fsIn.Close();
        cs.Close();
        fsCrypt.Close();

        Console.WriteLine("Encrypt Source file succeed!");
    }
    catch (Exception ex)
    {
        Console.WriteLine("Source file error! Error :" + ex.Message);
    }
}

10.文件解密👍

   /// <summary>
/// 文件解密
/// </summary>
/// <param name="inputFile">要解密的文件路径</param>
/// <param name="outputFile">解密后的文件存放路径</param>
public static void DecryptFile(string inputFile, string outputFile)   //解密
{
    try
    {
        string password = @"12345678";
        UnicodeEncoding UE = new UnicodeEncoding();
        byte[] key = UE.GetBytes(password);

        FileStream fsCrypt = new FileStream(inputFile, FileMode.Open);

        RijndaelManaged RMCrypto = new RijndaelManaged();

        CryptoStream cs = new CryptoStream(fsCrypt,
            RMCrypto.CreateDecryptor(key, key),
            CryptoStreamMode.Read);

        FileStream fsOut = new FileStream(outputFile, FileMode.Create);

        int data;
        while ((data = cs.ReadByte()) != -1)
            fsOut.WriteByte((byte)data);

        fsOut.Close();
        cs.Close();
        fsCrypt.Close();
        Console.WriteLine("Decrypt Source file succeed!");

    }
    catch (Exception ex)
    {
        Console.WriteLine("Source file error! Error :" + ex.Message);
    }
}

JavaScript

1.下载convas中的图片 👍

var convas = document.getElementById("canvas");
var dataURL = convas.toDataURL();
var link = document.createElement('a');
link.href=dataURL;
link.download='image.png';
document.body.appendChild(link);
link.click();

2.下载svg中的图片 👍

svg无法当成图片打开，可以使用工具转换成你想要的图片格式

var svg =document.getElementById("aaa")
var svgData=new XMLSerializer().serializeToString(svg);
var blob=new Blob([svgData],{type:"image/svg+xml;charset=utf-8"});
var url=URL.createObjectURL(blob);
var a=document.createElement("a");
a.href=url;
a.download="image.svg";
a.click();