From 5ead11ee47704ae88e9857296900f14361e6d7c9 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期一, 10 一月 2022 18:13:05 +0800
Subject: [PATCH] nothing

---
 WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs |   18 +++++++++---------
 1 files changed, 9 insertions(+), 9 deletions(-)

diff --git a/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs b/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs
index f80dfaa..38b02b4 100644
--- a/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs
+++ b/WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs
@@ -31,13 +31,13 @@
             {
                 if (sWhere == null || sWhere.Equals(""))
                 {
-                    ds = oCN.RunProcReturn("select * from h_v_Sc_EquipMaintainPlan " + sWhere + " order by hmainid desc", "h_v_Sc_EquipMaintainPlan");
+                    ds = oCN.RunProcReturn("select * from h_v_Sc_EquipMaintain " + sWhere + " order by hmainid desc", "h_v_Sc_EquipMaintain");
                 }
                 else
                 {
-                    string sql1 = "select * from h_v_Sc_EquipMaintainPlan where 1 = 1";
+                    string sql1 = "select * from h_v_Sc_EquipMaintain where 1 = 1";
                     string sql = sql1 + sWhere + " order by hmainid desc";
-                    ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintainPlan");
+                    ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintain");
                 }
                 if (ds == null || ds.Tables[0].Rows.Count == 0)
                 {
@@ -165,7 +165,7 @@
                 msg4 = msg4.Substring(1, msg4.Length - 2);
                 msg4 = msg4.Replace("\\", "");
                 msg4 = msg4.Replace("\n", "");  //\n
-                //msg2 = msg2.Replace("'", "鈥�");
+                                                //msg2 = msg2.Replace("'", "鈥�");
                 List<Model.ClsSb_EquipMaintainBillSub> ls1 = new List<Model.ClsSb_EquipMaintainBillSub>();
                 ls1 = oListModels.getObjectByJson_Sb_EquipMaintainBillSub(msg4);
                 int j = 0;
@@ -177,11 +177,11 @@
                     //oItemSub.HCloseMan = "";       //琛屽叧闂�
                     oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                     oItemSub.HCloseType = false;   //鍏抽棴绫诲瀷
-                    //oItemSub.HRemark = "";         //澶囨敞
+                                                   //oItemSub.HRemark = "";         //澶囨敞
                     oItemSub.HSourceInterID = 0;     // 婧愬崟涓诲唴鐮�
                     oItemSub.HSourceEntryID = 0;   //婧愬崟瀛愬唴鐮�
-                    //oItemSub.HSourceBillNo = "";  //婧愬崟鍗曞彿
-                    //oItemSub.HSourceBillType = ""; //婧愬崟绫诲瀷
+                                                   //oItemSub.HSourceBillNo = "";  //婧愬崟鍗曞彿
+                                                   //oItemSub.HSourceBillType = ""; //婧愬崟绫诲瀷
                     oItemSub.HRelationQty = 0;     //鍏宠仈鏁伴噺
                                                    //oItemSub.HRelationMoney = 0;   //鍏宠仈閲戦
                                                    //HMaterID = "";//閰嶄欢浠g爜
@@ -438,7 +438,7 @@
                     return objJsonResult;
                 }
                 //寰楀埌淇℃伅
-                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipMent  where HNumber= '" + HBarCode + "'", "Gy_EquipMent");
+                ds = oCN.RunProcReturn("select top 1 * from Gy_EquipFileBillMain  where HEquipFileNumber= '" + HBarCode + "'", "Gy_EquipFileBillMain");
                 //鍐欏叆淇℃伅
                 if (ds == null || ds.Tables[0].Rows.Count == 0)
                 {
@@ -482,7 +482,7 @@
             try
             {
                 DLL.ClsSb_EquipMaintainBill oBill = new DLL.ClsSb_EquipMaintainBill();
-                List<Models.ClsSb_EquipMaintainBillMain > lsmain = new List<Models.ClsSb_EquipMaintainBillMain>();
+                List<Models.ClsSb_EquipMaintainBillMain> lsmain = new List<Models.ClsSb_EquipMaintainBillMain>();
                 msg2 = msg2.Replace("\\", "");
                 msg2 = msg2.Replace("\n", "");  //\n
                 lsmain = oListModels.getObjectByJson_Sb_EquipMaintainBillMainPDA(msg2);

--
Gitblit v1.9.1