From 8c84e5bdb4ecba8cc3b46bf1743699ee0cf87af1 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期五, 30 八月 2024 12:49:16 +0800
Subject: [PATCH] 1.收款单：删除报错 原因：统一路径设置存在问题 2.染厂 领料单： 问题：不能编辑 原因： 3.物料： 问题：新增报错 原因：统一路径设置存在问题 问题：进入页面后加载缓慢 处理：进入页面后不需要获取数据，点击物料分类再获取数据
---
WebAPI/Controllers/BaseSet/Gy_MaterialController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
index 7102970..23c5397 100644
--- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs
@@ -79,7 +79,7 @@
objJsonResult.data = null;
return objJsonResult;
}
- string sql1 = string.Format(@"select * from h_v_Gy_MaterialList where 缁勭粐鍚嶇О='" + Organization + "'");
+ string sql1 = string.Format(@"select top(500) * from h_v_Gy_MaterialList where 缁勭粐鍚嶇О='" + Organization + "'");
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn(sql1 + sWhere + " order by 鐗╂枡浠ｇ爜 desc", "h_v_Gy_MaterialList");
--
Gitblit v1.9.1