|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 |
public DataTable GetPagedTable(DataTable dt, int PageIndex, int PageSize, out int recound) { if (dt == null || dt.Rows == null || dt.Rows.Count <= 0) { recound = 0; return null; } if (PageIndex < 1) { PageIndex = 1; } else if (PageIndex > 1 || PageIndex == 1) { PageIndex = PageIndex + 1; } DataTable newdt = dt.Copy(); newdt.Clear(); recound = dt.Rows.Count; int rowbegin = (PageIndex - 1) * PageSize; //停止行数 int rowend = PageIndex * PageSize; if (rowbegin >= dt.Rows.Count) { return newdt; } if (rowend > dt.Rows.Count) { rowend = dt.Rows.Count; } //生成新的DataTable for (int i = rowbegin; i <= rowend - 1; i++) { DataRow newdr = newdt.NewRow(); DataRow dr = dt.Rows[i]; foreach (DataColumn column in dt.Columns) { newdr[column.ColumnName] = dr[column.ColumnName]; } newdt.Rows.Add(newdr); } return newdt; } |
| take-skip分页 针对集合 | mapList.List = mapList.List.Skip((oldpageIndex - 1) * oldpageSize).Take(oldpageSize).ToList(); | |
| 附加：//模糊查询添加回车即查询 | $("#txtKeywords").bind("keyup", function (e) {
if (e.keyCode == 13) { gv.reload(); } }) |
声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。
