猿掌柜 发布的文章 - 社畜猿

C#泛型model 类public static class ToModel { public static TModel DataToModel<TModel>(this DataRow dr) { Type type = typeof(TModel); TModel md = (TModel)Activator.CreateInstance(type); foreach(var prop in type.GetProperties()) { prop.SetValue(md,dr[prop.Name]); } return md; } }使用：dr.DataToModel<userinfo>()

C# +webAPI+post+Httpclient C# +webAPI+post+Httpclient

Nginx+NET6+Vue部署windows Nginx+NET6+Vue部署windows

C# Mysql 多条件查询技巧笔记 C# 笔记SQL语句连接

Javascript清除浏览器所有的cookie Javascript清除浏览器所有的cookie

C#控制台程序重启 var applicationPath = System.Reflection.Assembly.GetExecutingAssembly().Location; Process.Start(applicationPath); Environment.Exit(Environment.ExitCode);

CryptoJS前端加密后端php 解密 前端加密jm(word){ var key = CryptoJS.enc.Latin1.parse('B55BA55A12ABCDEF'); //为了避免补位，直接用16位的秘钥 var iv = CryptoJS.enc.Latin1.parse('ABCDEF123A55A412'); //16位初始向量 let srcs = CryptoJS.enc.Utf8.parse(word); let encrypted = CryptoJS.AES.encrypt(word, key, ); return encrypted.toString(); },后端解密function decuserId($str){ $key = "B55BA55A12ABCDEF"; $iv = "ABCDEF123A55A412"; $decrypted = openssl_decrypt(base64_decode($str), 'AES-128-CBC', $key, 1, $iv); return $decrypted; }

Thinkphp6.0 获取绝对路径 在tp6.0 改到了App 基础类里面获取助手函数获取：app()>getRootPath() //获取应用根目录app()>getNamespace() //获取应用类库命名空间app()>version() //获取框架版本app()>getBasePath() //获取应用基础目录app()>getAppPath() //获取当前应用目录app()>getThinkPath() //获取核心框架目录app()>getConfigPath() //获取应用配置目录app()>getConfigPath() //获取应用配置目录

thinkphp6 动态连接数据库 //use think\facade\Config; $config = Config::get('database'); $config['connections']['tmp'] = [ 'type' => 'mysql', 'hostname' => 'localhost', 'database' => 'test', 'username' => 'root', 'password' => 'root', 'hostport' => 3306, 'params' => [], 'charset' => 'utf8mb4' ]; Config::set($config, 'database'); Db::connect('tmp')->query('select * from t limit 1');

C# 查询表和字段是否存在，不存在则新建 自动检测服务器上的数据库是否存在某表和某字段，如果表不存在，先新建表，再在表下查询某字段，如果不存在，则新建字段。private void Database_Operation(ComboBox ICChip) { try { if (PubVar.SQL_Connection)//如果数据库能打开 { using (SqlConnection conn = new SqlConnection(PubVar.connStr))//创建连接对象，并使用using释放（关闭），连接用完后会被自动关闭 { //if (conn.State == ConnectionState.Open) conn.Close();//如果打开则先关闭 conn.Open(); // 打开数据库连接 string sql = "select 1 from INFORMATION_SCHEMA.TABLES where TABLE_NAME='" + ICChip.Text.Trim() + "'"; SqlCommand command = new SqlCommand(sql, conn);//调用公共类中的ExceRead方法创建数据阅读器 var Read = command.ExecuteScalar(); if (Read == null)//加个判断,没有则创建表 { sql = "create table [" + ICChip.Text.Trim() + "]([NO.] [int] identity(1,1))";//([NO.] [int] identity(1,1))";//创建表 //identity(1,1)自增ID using (SqlConnection Conn = new SqlConnection(PubVar.connStr)) { Conn.Open(); command = new SqlCommand(sql, Conn); command.ExecuteNonQuery(); } } //判断字段是否存在 sql = "SELECT *FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + ICChip.Text.Trim() + "' AND COLUMN_NAME = '新字段'"; using (SqlConnection Conn = new SqlConnection(PubVar.connStr)) { Conn.Open(); command = new SqlCommand(sql, Conn); Read = command.ExecuteScalar(); } if (Read == null)//如果没有字段则创建 { sql = "ALTER TABLE [" + ICChip.Text.Trim() + "] ADD [新字段] [text] null";//id int primary key IDENTITY(1,1) NOT NULL //创建字段 using (SqlConnection Conn = new SqlConnection(PubVar.connStr)) { Conn.Open(); command = new SqlCommand(sql, Conn); command.ExecuteNonQuery(); } } } } } catch (Exception ex) { MessageBox.Show("错误信息：" + ex.Message, "创建数据库失败！"); } }