From 9e99d9df931a6f177bad6cfc1797a24d7ade6119 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 24 十二月 2024 10:21:53 +0800
Subject: [PATCH] 器具管理： 保养记录单，点检记录单，上模单，下模单，故障登记单，维修派工单，维修工单，维修验收单 将分页模式，改为 数据库分页。 目前的分页模式，加载数据一多就很慢，需要改为数据库分页模式提高性能 （数据库分页的功能， 杜贺和翁涛涛已编写好 案例， 物料列表 目前就是 数据库分页）
---
WebAPI/Controllers/SellOutBackController.cs | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/WebAPI/Controllers/SellOutBackController.cs b/WebAPI/Controllers/SellOutBackController.cs
index c8a743f..4f0babc 100644
--- a/WebAPI/Controllers/SellOutBackController.cs
+++ b/WebAPI/Controllers/SellOutBackController.cs
@@ -246,6 +246,8 @@
{
try
{
+ if (String.IsNullOrEmpty(sWhere))
+ sWhere = "and 1 = 1 ";
ds = webserver.GetKf_PonderationBillMain_Temp(HBillID, HBillType, sWhere);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
@@ -399,12 +401,13 @@
websLsmain.HEmpID = lsmain[0].HEmpID;
websLsmain.HRemark = lsmain[0].HRemark;
websLsmain.HMaker = lsmain[0].HMaker;
-
+ websLsmain.HBillType = "1247";//鍥哄畾鍊�
if (webserver.set_SaveSellOutBackBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))
{
objJsonResult.code = "0";
objJsonResult.count = 1;
- objJsonResult.Message = "鐢熸垚閫�鏂欏崟鎴愬姛锛佸崟鎹彿涓猴細";
+ objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //鎴愬姛锛�
+ //objJsonResult.Message = "鐢熸垚閫�鏂欏崟鎴愬姛锛佸崟鎹彿涓猴細";
objJsonResult.data = null;
return objJsonResult;
}
@@ -412,7 +415,8 @@
{
objJsonResult.code = "0";
objJsonResult.count = 0;
- objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
+ objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //澶辫触锛�
+ //objJsonResult.Message = "涓婁紶澶辫触锛�" + DBUtility.ClsPub.sErrInfo;
objJsonResult.data = null;
return objJsonResult;
}
--
Gitblit v1.9.1