02 2020 档案

AccessHelper.cs
摘要:/* access 连接工具类 */ using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.Data; using System.Con 阅读全文

posted @ 2020-02-23 19:45 lingtw 阅读(253) 评论(0) 推荐(0)

SqlSugarHelper.cs
摘要:using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Linq; using System.Linq.Expressions; using 阅读全文

posted @ 2020-02-23 19:44 lingtw 阅读(3208) 评论(1) 推荐(0)

NPOIHelper.cs
摘要:using System; using System.Collections.Generic; using System.Data; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks 阅读全文

posted @ 2020-02-23 19:43 lingtw 阅读(237) 评论(0) 推荐(0)

ORACLE分页查询SQL语句(最有效的分页)
摘要:1.无ORDER BY排序的写法。(效率最高)(经过测试,此方法成本最低,只嵌套一层,速度最快!即使查询的数据量再大,也几乎不受影响,速度依然!) SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM emp t WHERE hire_date BETWEE 阅读全文

posted @ 2020-02-22 20:49 lingtw 阅读(853) 评论(0) 推荐(0)

导航