/// <summary>
/// 实体转表
/// </summary>
/// <typeparam name="T">泛型</typeparam>
/// <param name="list">对象</param>
/// <returns></returns>
public static DataTable ToDataTable<T>(this IList<T> list)
{
    Type elementType = typeof(T);
    var t = new DataTable();

# 安装字体
yum -y install fontconfig
cd /usr/share/fonts
#创建新的字体文件夹
mkdir invoice_needed_font
#修改invoice_needed_font目录的权限使root用户以外的用户也可以使用
chmod -R 755 /usr/share/fonts/invoice_needed_font
#拷贝字体到invoice_needed_font文件夹

#如果提示 mkfontscale: command not found，需自行安装 #yum install mkfontscale

#检查是否安装（没任何反应）
chkconfig –list | grep vsftpd

#安装
yum install vsftpd

#创建日志
touch /var/log/vsftpd.log

#自启动

/// <summary>
/// 反射参数为实体
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <param name="request"></param>
/// <returns></returns>
public static T RequesToModel<T>(this T model, HttpRequest request = null)
{
    if (request == null)

/// <summary>
/// 实体转为表
/// </summary>
/// <typeparam name="T">泛型</typeparam>
/// <param name="list">对象</param>
/// <returns></returns>
public static DataTable ToDataTable<T>(this IList<T> list)
{
    Type elementType = typeof(T);
    var t = new DataTable();

/// <summary>
/// 字符串 JSON转义
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static string OfJson(this string s)
{
    StringBuilder sb = new StringBuilder();
    for (int i = 0; i < s.Length; i++)
    {

#备份格式
mysqldump -u 账号 -p 数据库 > 路径

#备份库（表结构及数据）
mysqldump -u root -p netnrdb > /netnr/data/netnrdb.sql
mysqldump -uroot -p123456 netnrdb > /netnr/data/netnrdb.sql

#备份库（表结构）(加 -d 不含数据)
mysqldump -u root -p -d netnrdb > /netnr/data/netnrdb.sql

--删除所有表
DECLARE @sql VARCHAR(8000);
WHILE EXISTS (SELECT name FROM sysobjects WHERE type = 'U')
BEGIN
    SELECT @sql = 'DROP TABLE ' + name
    FROM sysobjects
    WHERE (type = 'U');

    PRINT (@sql);

--生成清理所有表语句;
SELECT CONCAT('truncate TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA IN ( '数据库名' );

#公共的依赖
Install-Package Microsoft.EntityFrameworkCore.Tools
Install-Package Microsoft.VisualStudio.Web.CodeGeneration.Design

#MySQL
Install-Package Pomelo.EntityFrameworkCore.MySql
Scaffold-DbContext -Force "server=localhost;database=db;uid=root;pwd=123456;" Pomelo.EntityFrameworkCore.MySql

#SQLServer
Install-Package Microsoft.EntityFrameworkCore