摘要:
例1: select Min(VisitTime),count(*) as Num from online group by datediff(day,VisitTime,getdate()) 例2: select count(*),Min(PayTime) from LimitBidBills w 阅读全文
摘要:
执行语句: SELECT TOP 2000 ST.text AS '执行的SQL语句', QS.execution_count AS '执行次数', QS.total_elapsed_time AS '耗时', QS.total_logical_reads AS '逻辑读取次数', QS.total 阅读全文
摘要:
using System; using System.Security.Cryptography; using System.Text; using Microsoft.VisualStudio.TestTools.UnitTesting; namespace UnitTest.OtherTest 阅读全文
摘要:
控制器代码 var limitbidlist = LimitBidInfoBLL.GetLimitBidList(); var selectItemList = new List<SelectListItem>() { new SelectListItem(){Value="0",Text="全部" 阅读全文
摘要:
例: select * from LoanApply where ApplyTime>'2020-4-25' and CheckStatus=3 and BidderNo in (select BidderNo from LoanApply where ApplyTime>'2020-4-25' g 阅读全文
摘要:
在.Net core 使用NPOI首先必须先安装DotNetCore.NPOI,第一种方法可以在管理Nuget包中安装,如图: 引用代码: using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; using NPOI.XSSF.UserModel; 业 阅读全文