From b9bdd104ce8e53aa1cb27b6701f92ccfa21a965a Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 05 六月 2024 17:00:22 +0800
Subject: [PATCH] 平板绑定自动创建文件夹,模具保养记录单自动带出保养项目改为查询视图

---
 WebAPI/Controllers/WebAPIController.cs |   25 +++++++++++++++----------
 1 files changed, 15 insertions(+), 10 deletions(-)

diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index ad05fa7..888879e 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -11983,17 +11983,22 @@
                 List<object> list = new List<object>();
                 DataSet ds2;
                 DataSet ds1;
-                string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
-                                                from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID 
-                                                left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
-                                                left join Gy_Employee e on e.HItemID=t.HManagerID
-                                                where a.HInterID=" + MouldMaintainRuleID);
 
-                string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a  
-												left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID 
-                                                left join h_v_IF_Material m on b.HMaterID=m.HItemID
-												left join h_v_IF_Unit u on b.HUnitID=u.HItemID
-                                                where a.HInterID=" + MouldMaintainRuleID);
+            //    string sql1 = string.Format(@"select t.HMaintainItemID ,m.HNumber HMaintainItemNumber,t.HMaintainItem,t.HMaintainPart,t.HClaim,t.HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
+            //                                    from Sc_MouldMaintainRuleBillMain a left join Sc_MouldMaintainRuleBillSub_Item t on a.HInterID=t.HInterID 
+            //                                    left join Gy_Maintain m on m.HItemID=t.HMaintainItemID
+            //                                    left join Gy_Employee e on e.HItemID=t.HManagerID
+            //                                    where a.HInterID=" + MouldMaintainRuleID);
+
+            //    string sql2 = string.Format(@"select b.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName, m.HModel HMaterSpec,b.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark from Sc_MouldMaintainRuleBillMain a  
+												//left join Sc_MouldMaintainRuleBillSub b on a.HInterID=b.HInterID 
+            //                                    left join h_v_IF_Material m on b.HMaterID=m.HItemID
+												//left join h_v_IF_Unit u on b.HUnitID=u.HItemID
+            //                                    where a.HInterID=" + MouldMaintainRuleID);
+
+                string sql1 = string.Format(@"select * from h_v_Sc_MouldMaintainRuleBillSub_Item where hmainid=" + MouldMaintainRuleID);
+                string sql2 = string.Format(@"select * from h_v_Sc_MouldMaintainRuleBillSub where hmainid=" + MouldMaintainRuleID);
+
                 ds1 = oCN.RunProcReturn(sql1, "Sc_MouldMaintainRuleBillMain");//淇濆吇
                 ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//閰嶄欢
                 list.Add(ds1.Tables[0]);

--
Gitblit v1.9.1