02 2020 档案

dt转list
摘要：//linq dt转list //var linq = (from s in dt.AsEnumerable() // select new Shop // { // Id = s.Field<int>("Id"), // Title = s.Field<string>("Title"), // P 阅读全文
posted @ 2020-02-27 14:39 zhengyiwei 阅读(440) 评论(0) 推荐(0)
layui数据表格
摘要：<!DOCTYPE html><html><head> <meta charset="utf-8"> <title>table模块快速使用</title> <link href="layui/css/layui.css" rel="stylesheet" /> <script src="js/jqu 阅读全文
posted @ 2020-02-17 18:01 zhengyiwei 阅读(390) 评论(0) 推荐(0)
c# EF增删改查
摘要：public int Add(UserInfo user) { db.UserInfo.Add(user); return db.SaveChanges(); } // post public int Edit(UserInfo user) { db.Entry<UserInfo>(user).St 阅读全文
posted @ 2020-02-17 17:58 zhengyiwei 阅读(1473) 评论(0) 推荐(0)
分页存储过程
摘要：create proc proc_Page(@pageIndex int,@pageSize int,@Count int output)asbegin declare @start int = (@pageIndex-1)*@pageSize +1 declare @end int = @page 阅读全文
posted @ 2020-02-17 17:56 zhengyiwei 阅读(102) 评论(0) 推荐(0)