摘要:
--查询被锁表SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName FROM sys.dm_tran_locks WHERE resource_type='OBJECT' DECLARE 阅读全文
摘要:
1.如果是多个项目,需要配置nginx。 首先了解下的具体内容 https://www.cnblogs.com/nananana/p/10117250.html 2.注意做负载均衡时,session共享。 #user nobody; worker_processes 1; #error_log lo 阅读全文
摘要:
https://www.cnblogs.com/zhangjd/p/12565088.html 阅读全文
摘要:
public static class ConvertData { #region 范型集合和DataSet之间的转换 /// <summary> /// 数据集合转换成DataSet /// </summary> /// <param name="datas">数据集合转换成的Object数组</ 阅读全文
摘要:
1.检查数据库版本要大于SQLSERVER 2008R2.(重点) 2. 修改Dockerfile文件, (文件收vs 2019 创建默认配置,运行于Linux)把第一行: FROM mcr.microsoft.com/dotnet/core/aspnet:3.1-buster-slim AS ba 阅读全文
摘要:
1.微服务开源,包含redis。MongoDB的封装 介绍:https://www.cnblogs.com/skychen1218/p/13327965.html Github:https://github.com/SkyChenSky/Sikiro 阅读全文
摘要:
1.当月每一天的汇总 SELECT SUM(Qty)Qty , DATEPART(DAY,pickDate) Pickday FROM dbo.Delivery WHERE DATEDIFF(MONTH, pickDate, GETDATE()) < 1 GROUP BY DATEPART(DAY, 阅读全文
摘要:
public static string GetClientIPv4Address() { string ipv4 = String.Empty; foreach (IPAddress ip in Dns.GetHostAddresses(GetClientIP())) { if (ip.Addre 阅读全文
摘要:
当PlanNO 为空时,我们在EF查询筛选PlanNO列时,会报错 Expression<Func<DeliveryPlan, bool>> expr = PredicateExtensionses.True<DeliveryPlan>(); //动态拼接查询 //静态类的使用步骤 expr.And 阅读全文