From 49fb136bb4dcc08beeb860f7e15bb37c03c4ea86 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期二, 30 十一月 2021 17:40:57 +0800
Subject: [PATCH] 修改丸井项目提出的问题+模具保养单选器具以后带出默认保养规程信息

---
 WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user   |   34 ++++----
 WebAPI/WebAPI.csproj.user                                     |    2 
 WebAPI/Controllers/WebAPIController.cs                        |   38 +++++----
 DAL/生产管理/模具管理/ClsSc_MouldMaintainRuleBill.cs                  |   69 +++++------------
 WebAPI/Controllers/MJGL/Sc_MouldMaintainRuleBillController.cs |   90 ++++++++++++++++------
 5 files changed, 122 insertions(+), 111 deletions(-)

diff --git "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldMaintainRuleBill.cs" "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldMaintainRuleBill.cs"
index 5c1a4bb..85324c8 100644
--- "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldMaintainRuleBill.cs"
+++ "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/\346\250\241\345\205\267\347\256\241\347\220\206/ClsSc_MouldMaintainRuleBill.cs"
@@ -62,65 +62,36 @@
                 ////鍒犻櫎瀛愯〃
                 DeleteBillSub(lngBillKey);
                 DeleteBillSub2(lngBillKey);
-                DeleteBillSub3(lngBillKey);
-                DeleteBillSub4(lngBillKey);
                 ////鎻掑叆瀛愯〃
                 omodel.HInterID = lngBillKey;
+                ////鎻掑叆瀛愯〃
                 foreach (Model.ClsSc_MouldMaintainRuleBillSub oSub in DetailColl_Mater)
                 {
                     oCn.RunProc("Insert into Sc_MouldMaintainRuleBillSub " +
-                     " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
-                     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
-                     ",HMaterID,HUnitID" +
-                     ",HQty,HQtyMust" +
-                     ") values("
-                     + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
-                     "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
-                     "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() +
-                     "," + oSub.HQty.ToString() + "," + oSub.HQtyMust.ToString() + 
-                     ") ");
+                    " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
+                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
+                    ",HMaterID,HUnitID" +
+                    ",HQty,HQtyMust" +
+                    ") values("
+                    + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
+                    "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
+                    "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() +
+                    "," + oSub.HQty.ToString() + "," + oSub.HQtyMust.ToString() +
+                    ") ");
                 }
                 foreach (Model.ClsSc_MouldMaintainRuleBillSub_Item oSub in DetailColl_Pay)
                 {
                     oCn.RunProc("Insert into Sc_MouldMaintainRuleBillSub_Item " +
-                     " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
-                     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
-                     ",HMaintainItemID,HMaintainItem,HMaintainPart" +
-                     ",HClaim,HManagerID" +
-                     ") values("
-                     + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
-                     "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
-                     "," + oSub.HMaintainItemID.ToString() + ",'" + oSub.HMaintainItem + "','" + oSub.HMaintainPart + "','" + oSub.HClaim + "'," + oSub.HManagerID.ToString() + 
-                     ") ");
+                      " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
+                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
+                      ",HMaintainItemID,HMaintainItem,HMaintainPart" +
+                      ",HClaim,HManagerID" +
+                      ") values("
+                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
+                      "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
+                      "," + oSub.HMaintainItemID.ToString() + ",'" + oSub.HMaintainItem + "','" + oSub.HMaintainPart + "','" + oSub.HClaim + "'," + oSub.HManagerID.ToString() +
+                      ") ");
                 }
-                //foreach (Model.ClsSc_MouldMaintainRuleBillSub_Entrust oSub in DetailColl_Entrust)
-                //{
-                //    oCn.RunProc("Insert into Sc_MouldMaintainRuleBillSub_Entrust " +
-                //     " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
-                //     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
-                //     ",HMaterID,HUnitID,HProcID" +
-                //     ",HQty,HPrice,HMoney" +
-                //     ") values("
-                //     + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
-                //     "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
-                //     "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HProcID.ToString() +
-                //     "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() +
-                //     ") ");
-                //}
-                //foreach (Model.ClsSc_MouldMaintainRuleBillSub_Money oSub in DetailColl_Money)
-                //{
-                //    oCn.RunProc("Insert into Sc_MouldMaintainRuleBillSub_Money " +
-                //     " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
-                //     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
-                //     ",HItMoneyID" +
-                //     ",HQty,HPrice,HMoney" +
-                //     ") values("
-                //     + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + oSub.HEntryCloseDate.ToShortDateString() + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
-                //     "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
-                //     "," + oSub.HItMoneyID.ToString() +
-                //     "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() +
-                //     ") ");
-                //}
                 sReturn = "淇敼鍗曟嵁鎴愬姛锛�";
                 oCn.Commit();
                 return true;
diff --git a/WebAPI/Controllers/MJGL/Sc_MouldMaintainRuleBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldMaintainRuleBillController.cs
index 6a3a178..e3a6c4c 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldMaintainRuleBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldMaintainRuleBillController.cs
@@ -150,10 +150,10 @@
                 }
                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                 //鑾峰彇淇濆吇椤圭洰缂栬緫鏁版嵁
-                string sql = "select * from h_v_Sc_MouldMaintainRuleBillSub_Item where 1 = 1 " + Swhere + "";
-                ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillSub_Item");
+                string sql = "select 淇濆吇椤圭洰ID,淇濆吇椤圭洰,淇濆吇閮ㄤ綅,鍏蜂綋瑕佹眰,璐熻矗浜篒D,璐熻矗浜轰唬鐮�,璐熻矗浜哄悕绉�,瀛愬娉�2 from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + "";
+                ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillList");
                 //鑾峰彇閰嶄欢椤圭洰缂栬緫鏁版嵁
-                string sql1 = "select 閰嶄欢ID,閰嶄欢浠g爜,閰嶄欢鍚嶇О,鍗曚綅ID,璁¢噺鍗曚綅浠g爜,璁¢噺鍗曚綅鍚嶇О,鐢ㄩ噺,鏍囧噯鐢ㄩ噺,瀛愬娉� from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + "";
+                string sql1 = "select 閰嶄欢ID,閰嶄欢浠g爜,閰嶄欢鍚嶇О,鍗曚綅ID,璁¢噺鍗曚綅浠g爜,璁¢噺鍗曚綅鍚嶇О,鐢ㄩ噺,鏍囧噯鐢ㄩ噺,瀛愬娉�1 from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + "";
                 ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainRuleBillList");
 
                 list.Add(ds.Tables[0]);
@@ -182,14 +182,64 @@
             if (string.IsNullOrEmpty(HID))
                 return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
             SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
-            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMaintainRuleBillList  where hmainid= " + HID + " ", "h_v_Sc_MouldMaintainRuleBillList");
+            var dataSet = oCN.RunProcReturn("select top 1 * from Sc_MouldMaintainRuleBillMain  where HInterID= " + HID + " ", "Sc_MouldMaintainRuleBillMain");
             if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
                 return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄥ櫒鍏蜂繚鍏昏绋嬭褰�" };
             return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet };
         }
         #endregion
 
+        #region 鍣ㄥ叿淇濆吇瑙勭▼缂栬緫鏃惰幏鍙栬〃浣撴暟鎹柊(淇濆吇椤瑰垪琛ㄣ�侀厤浠堕」鍒楄〃)
+        [Route("Sc_MouldMaintainRuleBill/Sc_MouldMaintainRuleBillSubAndSubItem")]
+        [HttpGet]
+        public object Sc_MouldMaintainRuleBillSubAndSubItem(string HInterID)
+        {
+
+            DataSet ds, ds1;
+            List<object> list = new List<object>();
+            string Swhere = "";
+            try
+            {
+                if (HInterID != "" || HInterID != null)
+                {
+                    Swhere = " and hmainid='" + HInterID + "'";
+                }
+                else
+                {
+                    Swhere = HInterID;
+                }
+                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+                //鑾峰彇淇濆吇椤圭洰缂栬緫鏁版嵁
+                string sql = "select 淇濆吇椤圭洰ID HMaintainItemID,淇濆吇椤圭洰浠g爜 HMaintainItemNumber,淇濆吇椤圭洰 HMaintainItem,淇濆吇閮ㄤ綅 HMaintainPart,鍏蜂綋瑕佹眰 HClaim,璐熻矗浜篒D HManagerID,璐熻矗浜轰唬鐮� HManagerNumber,璐熻矗浜哄悕绉� HManagerName,瀛愬娉�2 HRemark from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + "";
+                ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillList");
+                //鑾峰彇閰嶄欢椤圭洰缂栬緫鏁版嵁
+                string sql1 = "select 閰嶄欢ID HMaterID,閰嶄欢浠g爜 HMaterNumber,閰嶄欢鍚嶇О HMaterName,鍗曚綅ID HUnitID,璁¢噺鍗曚綅浠g爜 HUnitNumber,璁¢噺鍗曚綅鍚嶇О HUnitName,鐢ㄩ噺 HQty,瀛愬娉�1 HRemark from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + "";
+                ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainRuleBillList");
+
+                list.Add(ds.Tables[0]);
+                list.Add(ds1.Tables[0]);
+                objJsonResult.code = "0";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
+                objJsonResult.list = list;
+            }
+            catch (Exception e)
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString();
+                objJsonResult.data = null;
+            }
+            return objJsonResult;
+        }
+        #endregion
+
         #region 鍣ㄥ叿淇濆吇瑙勭▼琛� 淇濆瓨/缂栬緫
+        /// <summary>
+        /// 淇濆瓨妯″叿缁翠慨鍗�
+        /// </summary>
+        /// <param name="msg"></param>
+        /// <returns></returns>
         [Route("Sc_MouldMaintainRuleBill/SaveMouldMaintainRuleBillList")]
         [HttpPost]
         public object SaveMouldMaintainRuleBillList([FromBody] JObject msg)
@@ -209,20 +259,18 @@
                 List<Model.ClsSc_MouldMaintainRuleBillMain> lsmain = new List<Model.ClsSc_MouldMaintainRuleBillMain>();
                 msg2 = msg2.Replace("\\", "");
                 msg2 = msg2.Replace("\n", "");  //\n
+                //涓昏〃
                 lsmain = oListModels.getObjectByJson_Sc_MouldMaintainRuleBillMain(msg2);
                 foreach (Model.ClsSc_MouldMaintainRuleBillMain oItem in lsmain)
                 {
-                    //oItem.HMaker = "";
                     UserName = oItem.HMaker;  //鍒跺崟浜�
                     oItem.HBillType = "3833";
                     oItem.HBillSubType = "3833";
 
-                    //oItem.HInterID =0;
-                    //oItem.HBillNo = "";
                     oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --鏃ユ湡
                     oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
-                    
-                    //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo);
+                    oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
+
                     if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
                     {
                         objJsonResult.code = "0";
@@ -248,20 +296,17 @@
 
                     i++;
                     item.HEntryID = i;
-                    //oItemSub.HCloseMan = "";       //琛屽叧闂�
                     item.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                     item.HCloseType = false;   //鍏抽棴绫诲瀷
-                    //oItemSub.HRemark = "";         //澶囨敞
                     item.HSourceInterID = 0;     // 婧愬崟涓诲唴鐮�
                     item.HSourceEntryID = 0;   //婧愬崟瀛愬唴鐮�
-                    //oItemSub.HSourceBillNo = "";  //婧愬崟鍗曞彿
-                    //oItemSub.HSourceBillType = ""; //婧愬崟绫诲瀷
                     item.HRelationQty = 0;     //鍏宠仈鏁伴噺
                     oBill.DetailColl_Pay.Add(item);
 
                 }
 
-                //閰嶄欢琛ㄤ綋鏁版嵁
+
+                //閰嶄欢椤硅〃浣撴暟鎹�
                 //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆�
                 msg4 = msg4.Substring(1, msg4.Length - 2);
                 msg4 = msg4.Replace("\\", "");
@@ -274,26 +319,19 @@
                 {
 
                     j++;
-                    oItemSub.HEntryID = i;
+                    oItemSub.HEntryID = j;
                     //oItemSub.HCloseMan = "";       //琛屽叧闂�
                     oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                     oItemSub.HCloseType = false;   //鍏抽棴绫诲瀷
-                                                   //oItemSub.HRemark = "";         //澶囨敞
+
                     oItemSub.HSourceInterID = 0;     // 婧愬崟涓诲唴鐮�
                     oItemSub.HSourceEntryID = 0;   //婧愬崟瀛愬唴鐮�
-                                                   //oItemSub.HSourceBillNo = "";  //婧愬崟鍗曞彿
-                                                   //oItemSub.HSourceBillType = ""; //婧愬崟绫诲瀷
+
                     oItemSub.HRelationQty = 0;     //鍏宠仈鏁伴噺
-                                                   //oItemSub.HRelationMoney = 0;   //鍏宠仈閲戦
-                                                   //HMaterID = "";//閰嶄欢浠g爜
-                                                   //HUnitID = "";//鍗曚綅浠g爜
-                                                   //HQty = "";//瀹為檯鐢ㄩ噺
-                                                   //HQtyMust = "";//鍗曚綅鐢ㄩ噺
-                                                   //HRemark = "";//澶囨敞
-
                     oBill.DetailColl_Mater.Add(oItemSub);
-
                 }
+
+
                 //淇濆瓨
                 //淇濆瓨瀹屾瘯鍚庡鐞�
                 bool bResult;
diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 7e5f56e..ab9a83b 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -2093,6 +2093,7 @@
         [HttpGet]
         public object GetMaintainItemtemByMouldProjectID(int MouldProjectID)
         {
+            
             if (MouldProjectID <= 0)
             {
                 objjson.code = "0";
@@ -2104,28 +2105,29 @@
             try
             {
                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
-                string sql = string.Format(@"select t.HMaintainItemID HMaintainItemID,m.HNumber HMaintainItemNumber,t.HMaintainItem HMaintainItem,t.HMaintainPart HMaintainPart,t.HClaim HClaim,t.HManagerID HManagerID,e.HNumber HManagerNumber,e.HName HManagerName,a.HRemark
+                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=(select HMouldMaintainRuleInterID from Gy_MouldFileMain where HInterID=" + MouldProjectID + ") ");
-                ds = oCN.RunProcReturn(sql, "Sc_MouldMaintainRuleBillMain");
-                if (ds == null || ds.Tables[0].Rows.Count <= 0)
-                {
-                    objjson.code = "0";
-                    objjson.count = 0;
-                    objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo;
-                    objjson.data = null;
-                    return objjson;
-                }
-                else
-                {
-                    objjson.code = "1";
-                    objjson.count = 1;
-                    objjson.Message = "鑾峰彇鎴愬姛!";
-                    objjson.data = ds.Tables[0];
-                    return objjson;
-                }
+
+                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=(select HMouldMaintainRuleInterID from Gy_MouldFileMain  where HInterID=" + MouldProjectID + ") ");
+                ds1 = oCN.RunProcReturn(sql1, "Sc_MouldMaintainRuleBillMain");//淇濆吇
+                ds2 = oCN.RunProcReturn(sql2, "Sc_MouldMaintainRuleBillMain");//閰嶄欢
+                list.Add(ds1.Tables[0]);
+                list.Add(ds2.Tables[0]);
+                objJsonResult.code = "0";
+                objJsonResult.count = 1;
+                objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
+                objJsonResult.list = list;
+                return objJsonResult;
             }
             catch (Exception ex)
             {
diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
index 658c36b..35690be 100644
--- a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
+++ b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -18,25 +18,25 @@
       <publishTime>02/22/2013 08:43:40</publishTime>
     </File>
     <File Include="bin/BLL.dll">
-      <publishTime>11/29/2021 18:37:32</publishTime>
+      <publishTime>11/30/2021 17:02:49</publishTime>
     </File>
     <File Include="bin/BLL.pdb">
-      <publishTime>11/29/2021 18:37:32</publishTime>
+      <publishTime>11/30/2021 17:02:49</publishTime>
     </File>
     <File Include="bin/DAL.dll">
-      <publishTime>11/29/2021 18:37:29</publishTime>
+      <publishTime>11/30/2021 17:02:48</publishTime>
     </File>
     <File Include="bin/DAL.pdb">
-      <publishTime>11/29/2021 18:37:29</publishTime>
+      <publishTime>11/30/2021 17:02:48</publishTime>
     </File>
     <File Include="bin/Dapper.dll">
       <publishTime>07/22/2016 14:52:40</publishTime>
     </File>
     <File Include="bin/DBUtility.dll">
-      <publishTime>11/29/2021 18:37:23</publishTime>
+      <publishTime>11/30/2021 17:02:44</publishTime>
     </File>
     <File Include="bin/DBUtility.pdb">
-      <publishTime>11/29/2021 18:37:23</publishTime>
+      <publishTime>11/30/2021 17:02:44</publishTime>
     </File>
     <File Include="bin/Interop.gregn6Lib.dll">
       <publishTime>08/25/2021 10:28:25</publishTime>
@@ -60,10 +60,10 @@
       <publishTime>07/25/2012 11:48:56</publishTime>
     </File>
     <File Include="bin/Model.dll">
-      <publishTime>11/29/2021 18:37:24</publishTime>
+      <publishTime>11/30/2021 17:02:45</publishTime>
     </File>
     <File Include="bin/Model.pdb">
-      <publishTime>11/29/2021 18:37:24</publishTime>
+      <publishTime>11/30/2021 17:02:45</publishTime>
     </File>
     <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
       <publishTime>08/16/2021 17:23:15</publishTime>
@@ -72,22 +72,22 @@
       <publishTime>08/03/2014 20:33:56</publishTime>
     </File>
     <File Include="bin/Pub_Class.dll">
-      <publishTime>11/29/2021 18:37:21</publishTime>
+      <publishTime>11/30/2021 17:02:43</publishTime>
     </File>
     <File Include="bin/Pub_Class.pdb">
-      <publishTime>11/29/2021 18:37:21</publishTime>
+      <publishTime>11/30/2021 17:02:43</publishTime>
     </File>
     <File Include="bin/Pub_Control.dll">
-      <publishTime>11/29/2021 18:37:22</publishTime>
+      <publishTime>11/30/2021 17:02:44</publishTime>
     </File>
     <File Include="bin/Pub_Control.pdb">
-      <publishTime>11/29/2021 18:37:22</publishTime>
+      <publishTime>11/30/2021 17:02:44</publishTime>
     </File>
     <File Include="bin/SQLHelper.dll">
-      <publishTime>11/29/2021 18:37:22</publishTime>
+      <publishTime>11/30/2021 17:02:44</publishTime>
     </File>
     <File Include="bin/SQLHelper.pdb">
-      <publishTime>11/29/2021 18:37:22</publishTime>
+      <publishTime>11/30/2021 17:02:44</publishTime>
     </File>
     <File Include="bin/stdole.dll">
       <publishTime>05/09/2021 13:35:37</publishTime>
@@ -189,10 +189,10 @@
       <publishTime>11/24/2014 11:18:48</publishTime>
     </File>
     <File Include="bin/WebAPI.dll">
-      <publishTime>11/29/2021 18:37:36</publishTime>
+      <publishTime>11/30/2021 17:02:52</publishTime>
     </File>
     <File Include="bin/WebAPI.pdb">
-      <publishTime>11/29/2021 18:37:36</publishTime>
+      <publishTime>11/30/2021 17:02:52</publishTime>
     </File>
     <File Include="bin/WebGrease.dll">
       <publishTime>07/17/2013 17:03:52</publishTime>
@@ -363,7 +363,7 @@
       <publishTime>08/06/2021 22:57:28</publishTime>
     </File>
     <File Include="Web.config">
-      <publishTime>11/29/2021 18:37:45</publishTime>
+      <publishTime>11/30/2021 17:03:22</publishTime>
     </File>
   </ItemGroup>
 </Project>
\ No newline at end of file
diff --git a/WebAPI/WebAPI.csproj.user b/WebAPI/WebAPI.csproj.user
index 16d95e2..729b04f 100644
--- a/WebAPI/WebAPI.csproj.user
+++ b/WebAPI/WebAPI.csproj.user
@@ -18,7 +18,7 @@
     <IISExpressWindowsAuthentication />
     <IISExpressUseClassicPipelineMode />
     <UseGlobalApplicationHostFile />
-    <ProjectView>ShowAllFiles</ProjectView>
+    <ProjectView>ProjectFiles</ProjectView>
     <Controller_SelectedScaffolderID>ApiControllerEmptyScaffolder</Controller_SelectedScaffolderID>
     <Controller_SelectedScaffolderCategoryPath>root/Common/Web API</Controller_SelectedScaffolderCategoryPath>
   </PropertyGroup>

--
Gitblit v1.9.1