From 9e99d9df931a6f177bad6cfc1797a24d7ade6119 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 24 十二月 2024 10:21:53 +0800
Subject: [PATCH] 器具管理： 保养记录单，点检记录单，上模单，下模单，故障登记单，维修派工单，维修工单，维修验收单 将分页模式，改为 数据库分页。 目前的分页模式，加载数据一多就很慢，需要改为数据库分页模式提高性能 （数据库分页的功能， 杜贺和翁涛涛已编写好 案例， 物料列表 目前就是 数据库分页）
---
WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs b/WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs
index c7e9544..d653986 100644
--- a/WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs
+++ b/WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs
@@ -46,14 +46,14 @@
"(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate," +
"HMaker,HMakeDate,HInnerBillNo,HRepairID,HDeptID,HRepairBeginDate,HRepairEndDate," +
"HCycleUnit,HPlanTimes,HTimes,HChangeNum,HEmpID,HManagerID,HRepairType,HSupID," +
- "HNewMaterID,HNewName,HNewModel,HNewModel2,HExplanation,HRepairContent,HRemark" +
+ "HNewMaterID,HNewName,HNewModel,HNewModel2,HExplanation,HRepairContent,HRemark,HChangeType" +
") " +
" values("+omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
",'" + omodel.HMaker + "',getdate()" +
",'" + omodel.HInnerBillNo+"',"+ omodel.HRepairID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HRepairBeginDate + "','" + omodel.HRepairEndDate +
"','" + omodel.HCycleUnit + "'," + omodel.HPlanTimes.ToString() + "," + omodel.HTimes.ToString() + "," + omodel.HChangeNum.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() +
",'" + omodel.HRepairType + "'," + omodel.HSupID.ToString() + "," + omodel.HNewMaterID.ToString() + ",'"+ omodel.HNewName + "','" + omodel.HNewModel + "','" + omodel.HNewModel2 + "','" + omodel.HExplanation + "','" + omodel.HRepairContent + "','" + omodel.HRemark+
- "') ");
+ "','"+omodel.HChangeType + "') ");
//鎻掑叆瀛愯〃
foreach (Models.ClsSc_MouldRepairChangeBillSub oSub in DetailColl)
{
--
Gitblit v1.9.1