From 9e99d9df931a6f177bad6cfc1797a24d7ade6119 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 24 十二月 2024 10:21:53 +0800 Subject: [PATCH] 器具管理: 保养记录单,点检记录单,上模单,下模单,故障登记单,维修派工单,维修工单,维修验收单 将分页模式,改为 数据库分页。 目前的分页模式,加载数据一多就很慢,需要改为数据库分页模式提高性能 (数据库分页的功能, 杜贺和翁涛涛已编写好 案例, 物料列表 目前就是 数据库分页) --- WebAPI/Controllers/BaseSet/Gy_SourceController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs index 2b0e6a7..9ebd278 100644 --- a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs @@ -676,7 +676,7 @@ { try { - string sql1 = string.Format("select hitemid,hnumber,hname from Gy_Source"+ sWhere + " order by hnumber"); + string sql1 = string.Format("select hitemid,hnumber,hname,HUSEORGID from Gy_Source" + sWhere + " order by hnumber"); ds = oCN.RunProcReturn(sql1, "Gy_Source"); -- Gitblit v1.9.1