原创smarttable扩展model自定义列名
简书链接:原创smarttable扩展model自定义列名文章字数：106,阅读全文大约需要1分钟 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465/** * 获取Map中所有字段 * 暂时只支持Map中List数据解析 不支持数组[] */public static void getMapColumn(List<Column> columns, String fieldName, String parentKey, List<Object> mapList, IFormat<String> keyFormat) { if (mapList != null && mapList.size() > 0) { Object o = mapList.get(0); if (o !=...
pythonssl错误proxy错误解决思路
简书链接:pythonssl错误proxy错误解决思路文章字数：92,阅读全文大约需要1分钟 requests.exceptions.SSLError: HTTPSConnectionPool(host=’explorer.api.openai.com’, port=443): Max retries exceeded with url: /api/auth/csrf (Caused by SSLError(SSLEOFError(8, ‘EOF occurred in violation of protocol (_ssl.c:997)’))) pip install --upgrade requests 12345678910 requests.packages.urllib3.disable_warnings() requests.adapters.DEFAULT_RETRIES = 30 # 增加重连次数 response = self.session.get( url=url, ...
AOT编译missingnativecodeMethodInfoMakeGenericMethodisnotcompat
简书链接:AOT编译missingnativecodeMethodInfoMakeGenericMethodisnotcompat文章字数：255,阅读全文大约需要1分钟 12345678910111213141516171819202122232425Connection id "0HMPQ5RUFQ1EQ", Request id "0HMPQ5RUFQ1EQ:00000001": An unhandled exception was thrown by the application. System.NotSupportedException: 'Microsoft.Extensions.Internal.PropertyHelper.CallNullSafePropertyGetter[webapi_mes.api.push.MyInformation,System.Int32](System.Func`2[webapi_mes.api.push.MyInformation,...
c条件编译按需引用按需打包
简书链接:c条件编译按需引用按需打包文章字数：160,阅读全文大约需要1分钟 123456789101112131415161718192021<ItemGroup> <PackageReference Include="Dapper" Version="2.0.123" /> <PackageReference Include="Microsoft.AspNetCore.Authentication.JwtBearer" Version="6.0.5" /> <PackageReference Include="Microsoft.AspNetCore.Mvc.NewtonsoftJson" Version="7.0.1" /> <PackageReference Include="Newtonsoft.Json"...
webapicore全局拦截200的结果进行文本替换等逻辑操作办法
简书链接:webapicore全局拦截200的结果进行文本替换等逻辑操作办法文章字数：243,阅读全文大约需要1分钟方法1 中间件实现 12345678910111213141516171819202122232425262728293031323334353637using System.IO;using System.Threading.Tasks;using Microsoft.AspNetCore.Http;public class TextReplaceMiddleware{ private readonly RequestDelegate _next; public TextReplaceMiddleware(RequestDelegate next) { _next = next; } public async Task InvokeAsync(HttpContext context) { // 暂存原始响应内容 var...
原创c调用存储过程不声明参数拿来即用的办法2种
简书链接:原创c调用存储过程不声明参数拿来即用的办法2种文章字数：232,阅读全文大约需要1分钟这个东西就是靠思考了,如果不去想就自然以为没这个东西.懒癌发作 第一种使用 1234 SqlCommand cmd = new SqlCommand(procName, sqlConnection);cmd.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(cmd); 第二种 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859SqlCommand command = new SqlCommand(); SqlCommand returnCommand = new SqlCommand(); returnCommand.CommandType =...
sqlserver高级指令开启创建管理员等模板
简书链接:sqlserver高级指令开启创建管理员等模板文章字数：219,阅读全文大约需要1分钟 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122-- 检查 'remote debug' 选项是否存在USE master;SELECT * FROM sys.configurationsIF NOT EXISTS (SELECT * FROM sys.configurations WHERE name = 'remote debugging')BEGIN ...
sqlserver存储过程实例模板语法解读
简书链接:sqlserver存储过程实例模板语法解读文章字数：561,阅读全文大约需要2分钟 123456789101112131415CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY] ] [ ,...n ][ WITH <procedure_option> [ ,...n ] ][ FOR REPLICATION ]AS { [ BEGIN ] sql_statement [;] [ ...n ] [ END ] }[;]<procedure_option> ::= [ ENCRYPTION ] [...
sqlserver存储过程案例模板
简书链接:sqlserver存储过程案例模板文章字数：1072,阅读全文大约需要4分钟 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657CREATE PROCEDURE OrderProcessing @OrderID INTASBEGIN -- 判断订单是否存在 IF NOT EXISTS (SELECT * FROM Orders WHERE OrderID = @OrderID) BEGIN RAISERROR ('Invalid order ID', 16, 1) RETURN END -- 获取订单状态 DECLARE @Status VARCHAR(20) SELECT @Status = Status FROM Orders WHERE OrderID = @OrderID --...
cjsshell企业微信推送办法
简书链接:cjsshell企业微信推送办法文章字数：462,阅读全文大约需要1分钟 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677public class MyHttpUtil { public static string sendPostJSON(string url, string json) { /* var client = new HttpClient(); var request = new HttpRequestMessage(HttpMethod.Post, url); request.Content = new StringContent(json, Encoding.UTF8,...
