智云MES后端API代码
parent: ead9bbc0 | 补丁 | 提交 | ignore whitespace
zrg
2 天以前 2496d33f31d0eedfdd81d54fc5547aa3541549e4 
优化单品过站增加子表保存
4个文件已修改
75 ■■■■■ 已修改文件
WebAPI/Controllers/BaseSet/Gy_MaterialController.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/CJGL/Cj_SingleStationController.cs 28 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/条码管理/WEBSController.cs 1 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/FolderProfile2.pubxml.user 42 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/BaseSet/Gy_MaterialController.cs


@@ -2891,7 +2891,6 @@


                string HUpDater = mainList[0].HUpDater;


                string HMaterNumber = mainList[0].HMaterNumber;


                string HSupNumber = mainList[0].HSupNumber;


                long HPrintQty = mainList[0].HPrintQty;


                string HMouldOWNER = mainList[0].HMouldOWNER;


                string HSaveLife = mainList[0].HSaveLife;


                int HCaveQty = mainList[0].HCaveQty;


@@ -2949,7 +2948,7 @@


                }


                //=========================================================




                                //主表


                //主表


                oCN.RunProc("UpDate Gy_MouldFileMain set  " +


                 " HBillNo='" + HBillNo + "'" +  //固定赋值===============


                 ",HDate='" + HDate + "'" +


@@ -2979,7 +2978,6 @@


                 ",HDeptID=" + HDeptID.ToString() +


                 ",HSupID=" + HSupID.ToString() +


                 ",HSupNumber='" + HSupNumber + "'" +


                 ",HPrintQty=" + HPrintQty.ToString() +


                 ",HMouldStatus='" + HMouldStatus + "'" +


                 ",HSaveLife='" + HSaveLife + "'" +


                 ",HWhID=" + HWHID.ToString() +




 WebAPI/Controllers/CJGL/Cj_SingleStationController.cs


@@ -1728,11 +1728,11 @@


                    ds = oCN.RunProcReturn("select * from Sc_SourceLineRepairBillSub_Mater where HInterID=" + model.HInterID+ " order by HEntryID  desc", "Sc_SourceLineRepairBillSub_Mater");




                    oCN.RunProc($@"insert into Sc_SourceLineRepairBillSub_Mater


(HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID


,HSourceEntryID,HSourceBillNo,HSourceBillType,HMaterID


,HUnitID,HBarCode,HBatchNo )values


({model.HInterID},{(ds.Tables[0].Rows.Count == 0 ? 1 : int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1)},'{model.HBillNo}','',{temp.HProcExchInterID}


,{temp.HProcExchEntryID},'{temp.HProcExchBillNo}','',{temp.HMaterID},0,'{temp.HBarCode}','{temp.HBatchNo}')");


                    (HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID


                    ,HSourceEntryID,HSourceBillNo,HSourceBillType,HMaterID


                    ,HUnitID,HBarCode,HBatchNo )values


                    ({model.HInterID},{(ds.Tables[0].Rows.Count == 0 ? 1 : int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1)},'{model.HBillNo}','',{temp.HProcExchInterID}


                    ,{temp.HProcExchEntryID},'{temp.HProcExchBillNo}','',{temp.HMaterID},0,'{temp.HBarCode}','{temp.HBatchNo}')");




                    //修改产线追溯单绑定的条码批号


                    oCN.RunProc("update Sc_AssemblyBillSub set HBarCode='" + temp.HBarCode + "' where HInterID=" + temp.HInterID + " and HEntryID=" + temp.HEntryID);


@@ -1743,21 +1743,21 @@


                    model = JsonConvert.DeserializeObject<Model.ClsSc_SourceLineRepairBillMain>(sMainStr);




                    oCN.RunProc($@"insert into Sc_SourceLineRepairBillMain(HYear, HPeriod, HBillType, HBillSubType, HInterID,


HDate, HBillNo, HBillStatus, HRemark, HEmpID, HDeptID, HSourceID, HProdOrgID, HMaterID, HWorkStationID,


HProcess, HIPAddr, HMacAddr, HProdMac, HBarCode,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo)


values('{DateTime.Now.Year}','{DateTime.Now.Month}','3748','3748',{model.HInterID}


,getdate(),'{model.HBillNo}','1','{HResult}',{model.HEmpID},{model.HDeptID},{model.HSourceID},{model.HProdOrgID},{model.HMaterID},0


,{model.HProcess},'','','','{model.HBarCode}','{user}',getdate(),{model.HICMOInterID},{model.HICMOEntryID},'{model.HICMOBillNo}')");


                    HDate, HBillNo, HBillStatus, HRemark, HEmpID, HDeptID, HSourceID, HProdOrgID, HMaterID, HWorkStationID,


                    HProcess, HIPAddr, HMacAddr, HProdMac, HBarCode,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo)


                    values('{DateTime.Now.Year}','{DateTime.Now.Month}','3748','3748',{model.HInterID}


                    ,getdate(),'{model.HBillNo}','1','{HResult}',{model.HEmpID},{model.HDeptID},{model.HSourceID},{model.HProdOrgID},{model.HMaterID},0


                    ,{model.HProcess},'','','','{model.HBarCode}','{user}',getdate(),{model.HICMOInterID},{model.HICMOEntryID},'{model.HICMOBillNo}')");




                    List<Model.ClsSc_SourceLineRepairBillSub> subLsit = new List<Model.ClsSc_SourceLineRepairBillSub>();


                    sMainStr = "[" + sMainStr + "]";


                    subLsit = JsonConvert.DeserializeObject<List<Model.ClsSc_SourceLineRepairBillSub>>(sMainStr);




                    oCN.RunProc($@"insert into Sc_SourceLineRepairBillSub


(HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType


,HBadReasonID,HBadTypeID,HBadResultID,HBadProcID,HRepairResult,HCreator,HCreateDate)


values({model.HInterID},1,'{model.HBillNo}','',{subLsit[0].HProcExchInterID},{subLsit[0].HProcExchEntryID},'{subLsit[0].HProcExchBillNo}',''


,{subLsit[0].HBadReasonID},{subLsit[0].HBadTypeID},{subLsit[0].HBadResultID},{model.HBadProcID},'{HResult}','{subLsit[0].HCreator}',getdate())");


                    (HInterID,HEntryID,HBillNo_bak,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType


                    ,HBadReasonID,HBadTypeID,HBadResultID,HBadProcID,HRepairResult,HCreator,HCreateDate)


                    values({model.HInterID},1,'{model.HBillNo}','{model.HRemark}',{subLsit[0].HProcExchInterID},{subLsit[0].HProcExchEntryID},'{subLsit[0].HProcExchBillNo}',''


                    ,{subLsit[0].HBadReasonID},{subLsit[0].HBadTypeID},{subLsit[0].HBadResultID},{model.HBadProcID},'{HResult}','{subLsit[0].HCreator}',getdate())");




                    if (HResult == "OK")


                    {




 WebAPI/Controllers/ÌõÂë¹ÜÀí/WEBSController.cs


@@ -13676,6 +13676,7 @@




        #region æ·»åº·æ ¹æ®å°è½¦æ¡ç æ‰¾å‡ºç›¸åº”物料


        #endregion




        [Route("WEBSController/GetMaterIDByCarBarCode")]


        [HttpGet]


        public object GetMaterIDByCarBarCode(string CarBarCode)




 WebAPI/Properties/PublishProfiles/FolderProfile2.pubxml.user


@@ -5,7 +5,7 @@


<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">


  <PropertyGroup>


    <_PublishTargetUrl>D:\网站发布\智云MESWMS\API</_PublishTargetUrl>


    <History>True|2025-12-30T06:23:14.0889784Z;True|2025-12-29T09:12:05.7081903+08:00;False|2025-12-29T09:11:27.9082848+08:00;True|2025-07-01T16:53:57.8492332+08:00;True|2025-07-01T16:14:28.8419744+08:00;True|2025-07-01T15:15:43.3121091+08:00;True|2025-07-01T14:48:00.3454856+08:00;True|2025-07-01T09:17:46.2541717+08:00;False|2025-07-01T09:17:07.0648196+08:00;True|2025-06-23T14:30:28.6691264+08:00;False|2025-06-23T14:27:45.6002040+08:00;True|2025-06-23T11:02:08.3020700+08:00;True|2025-06-23T10:47:44.4654541+08:00;True|2025-06-23T09:46:24.9049910+08:00;False|2025-06-23T09:45:40.5195919+08:00;True|2025-06-20T14:33:10.9210583+08:00;True|2025-06-20T13:22:54.5321865+08:00;False|2025-06-20T13:21:30.8643897+08:00;True|2025-06-20T08:36:32.6695266+08:00;False|2025-06-20T08:35:57.8274069+08:00;True|2025-06-19T08:14:35.0623669+08:00;False|2025-06-19T08:12:57.2451557+08:00;True|2025-06-18T16:56:03.4555368+08:00;True|2025-06-18T16:42:43.2441845+08:00;False|2025-06-18T16:42:02.6907205+08:00;True|2025-06-16T16:13:03.2956026+08:00;False|2025-06-16T16:12:23.8438917+08:00;True|2025-06-16T15:21:32.7370852+08:00;True|2025-06-16T15:08:57.7166003+08:00;True|2025-06-16T14:02:18.4224630+08:00;True|2025-06-16T11:00:03.6375429+08:00;False|2025-06-16T10:59:26.0956296+08:00;True|2025-06-09T16:45:52.0865612+08:00;True|2025-06-09T16:38:47.2182194+08:00;True|2025-06-09T16:17:50.9170601+08:00;False|2025-06-09T16:17:43.0333396+08:00;True|2025-06-09T15:25:17.0429161+08:00;True|2025-06-09T15:00:15.0058791+08:00;True|2025-06-09T14:50:02.1370115+08:00;True|2025-06-09T14:38:10.9037045+08:00;True|2025-06-09T14:34:53.2826267+08:00;True|2025-06-09T14:07:24.5341951+08:00;True|2025-06-09T13:39:17.5042542+08:00;True|2025-06-09T09:30:31.8197114+08:00;True|2025-01-10T13:10:47.2046185+08:00;True|2025-01-10T11:11:49.4016910+08:00;True|2025-01-10T10:59:12.3481721+08:00;False|2025-01-10T10:58:24.5033898+08:00;True|2025-01-04T14:35:42.2792864+08:00;</History>


    <History>True|2026-01-04T03:27:03.6003486Z;True|2026-01-04T11:16:09.0856233+08:00;True|2026-01-04T11:09:33.9721372+08:00;True|2026-01-04T10:59:57.5111892+08:00;False|2026-01-04T10:57:57.5312203+08:00;True|2025-12-30T14:23:14.0889784+08:00;True|2025-12-29T09:12:05.7081903+08:00;False|2025-12-29T09:11:27.9082848+08:00;True|2025-07-01T16:53:57.8492332+08:00;True|2025-07-01T16:14:28.8419744+08:00;True|2025-07-01T15:15:43.3121091+08:00;True|2025-07-01T14:48:00.3454856+08:00;True|2025-07-01T09:17:46.2541717+08:00;False|2025-07-01T09:17:07.0648196+08:00;True|2025-06-23T14:30:28.6691264+08:00;False|2025-06-23T14:27:45.6002040+08:00;True|2025-06-23T11:02:08.3020700+08:00;True|2025-06-23T10:47:44.4654541+08:00;True|2025-06-23T09:46:24.9049910+08:00;False|2025-06-23T09:45:40.5195919+08:00;True|2025-06-20T14:33:10.9210583+08:00;True|2025-06-20T13:22:54.5321865+08:00;False|2025-06-20T13:21:30.8643897+08:00;True|2025-06-20T08:36:32.6695266+08:00;False|2025-06-20T08:35:57.8274069+08:00;True|2025-06-19T08:14:35.0623669+08:00;False|2025-06-19T08:12:57.2451557+08:00;True|2025-06-18T16:56:03.4555368+08:00;True|2025-06-18T16:42:43.2441845+08:00;False|2025-06-18T16:42:02.6907205+08:00;True|2025-06-16T16:13:03.2956026+08:00;False|2025-06-16T16:12:23.8438917+08:00;True|2025-06-16T15:21:32.7370852+08:00;True|2025-06-16T15:08:57.7166003+08:00;True|2025-06-16T14:02:18.4224630+08:00;True|2025-06-16T11:00:03.6375429+08:00;False|2025-06-16T10:59:26.0956296+08:00;True|2025-06-09T16:45:52.0865612+08:00;True|2025-06-09T16:38:47.2182194+08:00;True|2025-06-09T16:17:50.9170601+08:00;False|2025-06-09T16:17:43.0333396+08:00;True|2025-06-09T15:25:17.0429161+08:00;True|2025-06-09T15:00:15.0058791+08:00;True|2025-06-09T14:50:02.1370115+08:00;True|2025-06-09T14:38:10.9037045+08:00;True|2025-06-09T14:34:53.2826267+08:00;True|2025-06-09T14:07:24.5341951+08:00;True|2025-06-09T13:39:17.5042542+08:00;True|2025-06-09T09:30:31.8197114+08:00;True|2025-01-10T13:10:47.2046185+08:00;True|2025-01-10T11:11:49.4016910+08:00;True|2025-01-10T10:59:12.3481721+08:00;False|2025-01-10T10:58:24.5033898+08:00;True|2025-01-04T14:35:42.2792864+08:00;</History>


  </PropertyGroup>


  <ItemGroup>


    <File Include="apiapp.json">


@@ -45,28 +45,28 @@


      <publishTime>02/22/2013 16:43:40</publishTime>


    </File>


    <File Include="bin/BLL.dll">


      <publishTime>12/30/2025 14:23:04</publishTime>


      <publishTime>01/04/2026 10:59:34</publishTime>


    </File>


    <File Include="bin/BLL.pdb">


      <publishTime>12/30/2025 14:23:04</publishTime>


      <publishTime>01/04/2026 10:59:34</publishTime>


    </File>


    <File Include="bin/BouncyCastle.Crypto.dll">


      <publishTime>12/18/2020 05:32:28</publishTime>


    </File>


    <File Include="bin/DAL.dll">


      <publishTime>12/30/2025 14:23:00</publishTime>


      <publishTime>01/04/2026 10:59:21</publishTime>


    </File>


    <File Include="bin/DAL.pdb">


      <publishTime>12/30/2025 14:23:00</publishTime>


      <publishTime>01/04/2026 10:59:21</publishTime>


    </File>


    <File Include="bin/Dapper.dll">


      <publishTime>07/22/2016 22:52:40</publishTime>


    </File>


    <File Include="bin/DBUtility.dll">


      <publishTime>12/30/2025 14:22:53</publishTime>


      <publishTime>01/04/2026 10:59:03</publishTime>


    </File>


    <File Include="bin/DBUtility.pdb">


      <publishTime>12/30/2025 14:22:53</publishTime>


      <publishTime>01/04/2026 10:59:03</publishTime>


    </File>


    <File Include="bin/Grpc.Core.Api.dll">


      <publishTime>03/22/2022 13:17:26</publishTime>


@@ -111,10 +111,10 @@


      <publishTime>07/25/2012 19:48:56</publishTime>


    </File>


    <File Include="bin/Model.dll">


      <publishTime>12/30/2025 14:22:57</publishTime>


      <publishTime>01/04/2026 10:59:09</publishTime>


    </File>


    <File Include="bin/Model.pdb">


      <publishTime>12/30/2025 14:22:57</publishTime>


      <publishTime>01/04/2026 10:59:09</publishTime>


    </File>


    <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">


      <publishTime>05/23/2025 10:00:25</publishTime>


@@ -147,34 +147,34 @@


      <publishTime>10/23/2021 17:07:54</publishTime>


    </File>


    <File Include="bin/Pub_Class.dll">


      <publishTime>12/30/2025 14:22:41</publishTime>


      <publishTime>01/04/2026 10:58:52</publishTime>


    </File>


    <File Include="bin/Pub_Class.pdb">


      <publishTime>12/30/2025 14:22:41</publishTime>


      <publishTime>01/04/2026 10:58:52</publishTime>


    </File>


    <File Include="bin/Pub_Control.dll">


      <publishTime>12/30/2025 14:22:47</publishTime>


      <publishTime>01/04/2026 10:58:58</publishTime>


    </File>


    <File Include="bin/Pub_Control.pdb">


      <publishTime>12/30/2025 14:22:47</publishTime>


      <publishTime>01/04/2026 10:58:58</publishTime>


    </File>


    <File Include="bin/RestSharp.dll">


      <publishTime>08/31/2012 06:22:50</publishTime>


    </File>


    <File Include="bin/SQLHelper.dll">


      <publishTime>12/30/2025 14:22:48</publishTime>


      <publishTime>01/04/2026 10:58:58</publishTime>


    </File>


    <File Include="bin/SQLHelper.pdb">


      <publishTime>12/30/2025 14:22:48</publishTime>


      <publishTime>01/04/2026 10:58:58</publishTime>


    </File>


    <File Include="bin/Swashbuckle.Core.dll">


      <publishTime>02/16/2015 01:57:08</publishTime>


    </File>


    <File Include="bin/SyntacticSugar.dll">


      <publishTime>12/30/2025 14:19:59</publishTime>


      <publishTime>12/30/2025 14:23:42</publishTime>


    </File>


    <File Include="bin/SyntacticSugar.pdb">


      <publishTime>12/30/2025 14:19:59</publishTime>


      <publishTime>12/30/2025 14:23:42</publishTime>


    </File>


    <File Include="bin/System.Buffers.dll">


      <publishTime>07/19/2017 18:01:28</publishTime>


@@ -285,19 +285,19 @@


      <publishTime>05/09/2023 10:43:40</publishTime>


    </File>


    <File Include="bin/TopSdk.dll">


      <publishTime>12/30/2025 14:17:55</publishTime>


      <publishTime>12/30/2025 14:23:45</publishTime>


    </File>


    <File Include="bin/TopSdk.pdb">


      <publishTime>12/30/2025 14:17:55</publishTime>


      <publishTime>12/30/2025 14:23:45</publishTime>


    </File>


    <File Include="bin/WebActivatorEx.dll">


      <publishTime>11/24/2014 19:18:48</publishTime>


    </File>


    <File Include="bin/WebAPI.dll">


      <publishTime>12/30/2025 14:23:10</publishTime>


      <publishTime>01/04/2026 11:27:02</publishTime>


    </File>


    <File Include="bin/WebAPI.pdb">


      <publishTime>12/30/2025 14:23:10</publishTime>


      <publishTime>01/04/2026 11:27:02</publishTime>


    </File>


    <File Include="bin/WebAPI.XmlSerializers.dll">


      <publishTime>07/01/2025 16:53:56</publishTime>