From 9e99d9df931a6f177bad6cfc1797a24d7ade6119 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 24 十二月 2024 10:21:53 +0800
Subject: [PATCH] 器具管理： 保养记录单，点检记录单，上模单，下模单，故障登记单，维修派工单，维修工单，维修验收单 将分页模式，改为 数据库分页。 目前的分页模式，加载数据一多就很慢，需要改为数据库分页模式提高性能 （数据库分页的功能， 杜贺和翁涛涛已编写好 案例， 物料列表 目前就是 数据库分页）
---
WebAPI/Controllers/XSGL/YS_ContactBalController.cs | 12 ++++++++----
1 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/YS_ContactBalController.cs b/WebAPI/Controllers/XSGL/YS_ContactBalController.cs
index 2885c1c..6e96437 100644
--- a/WebAPI/Controllers/XSGL/YS_ContactBalController.cs
+++ b/WebAPI/Controllers/XSGL/YS_ContactBalController.cs
@@ -427,9 +427,11 @@
ds = oCN.RunProcReturn(sql, "YSYF_ContactBal");
if (ds.Tables[0].Rows.Count == 0)
{
- sql = "insert into YSYF_ContactBal(HRP,HCusID,HCurID,HBeginBalance) " +
+ sql = "insert into YSYF_ContactBal(HYear,HPeriod,HRP,HCusID,HCurID,HBeginBalance) " +
"values(" +
- "" + HFRP + "" +
+ "YEAR(getdate())" +
+ ",Month(getdate())" +
+ "," + HFRP + "" +
"," + HCusID + "" +
"," + HCurID + "" +
"," + HBeginBalance + "" +
@@ -475,9 +477,11 @@
ds = oCN.RunProcReturn(sql, "YSYF_ContactBal");
if (ds.Tables[0].Rows.Count == 0)
{
- sql = "insert into YSYF_ContactBal(HRP,HCusID,HCurID,HBeginBalance) " +
+ sql = "insert into YSYF_ContactBal(HYear,HPeriod,HRP,HCusID,HCurID,HBeginBalance) " +
"values(" +
- "" + HFRP + "" +
+ "YEAR(getdate())" +
+ ",Month(getdate())" +
+ "," + HFRP + "" +
"," + HCusID + "" +
"," + HCurID + "" +
"," + HBeginBalance + "" +
--
Gitblit v1.9.1