智云MES后端API代码
parent: e0a5ad7d | 补丁 | 提交 | ignore whitespace
wtt
2024-08-23 09cabedaff68030a639a53b99c3869ffbaa195e6 
关联数量相关
11个文件已修改
91 ■■■■■ 已修改文件
BLL/bin/Release/BLL.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/BLL.pdb 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/DAL.dll 补丁 | 查看 | 原始文档 | blame | 历史
BLL/bin/Release/DAL.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/DAL.dll 补丁 | 查看 | 原始文档 | blame | 历史
DAL/bin/Release/DAL.pdb 补丁 | 查看 | 原始文档 | blame | 历史
DAL/应付管理/ClsYF_PayMentBill.cs 59 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DAL/应收管理/ClsYS_ReceiveBill.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/CGGL/YF_PayMentBillController.cs 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Models/ClsKf_ICStockBillSub.cs 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/FolderProfile21.pubxml.user 18 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 BLL/bin/Release/BLL.dll

Binary files differ



 BLL/bin/Release/BLL.pdb

Binary files differ



 BLL/bin/Release/DAL.dll

Binary files differ



 BLL/bin/Release/DAL.pdb

Binary files differ



 DAL/bin/Release/DAL.dll

Binary files differ



 DAL/bin/Release/DAL.pdb

Binary files differ



 DAL/Ó¦¸¶¹ÜÀí/ClsYF_PayMentBill.cs


@@ -31,8 +31,48 @@


        {


            DetailColl = null;


        }


       




        #endregion   è‡ªå®šä¹‰æ–¹æ³•




        //删除关联


        public override void DeleteRelation(ref string sReturn, Int64 lngBillKey)


        {


            //应收单 å…³è”数量


            try


            {


                if (DetailColl[0].HSourceBillType == "1114")                    //应付单


                {


                    oCn.RunProc("exec h_p_Cg_UpDateRelation_PayableToPayMent_Del " + lngBillKey.ToString());


                }


                else


                {


                }


            }


            catch (Exception e)


            {


                throw (e);


            }


        }


        //新增关联


        public override void AddNewRelation(ref string sReturn, Int64 lngBillKey)


        {


            //应收单 å…³è”数量


            try


            {


                if (DetailColl[0].HSourceBillType == "1114")                    //应付单


                {


                    oCn.RunProc("exec h_p_Cg_UpDateRelation_PayableToPayMent_Add " + lngBillKey.ToString());


                }


                else


                {




                }


            }


            catch (Exception e)


            {


                throw (e);


            }


        }


        //修改单据


        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)


        {


@@ -82,8 +122,11 @@


                ",HMainSourceBillNo='" + omodel.HMainSourceBillNo.ToString() +


                "',HMainSourceBillType='" + omodel.HMainSourceBillType.ToString() +


                "' where HInterID=" + lngBillKey.ToString());


                //删除关联


                DeleteRelation(ref sReturn, lngBillKey);


                if (DetailColl.Count != 0)


                {


                    //删除关联


                    DeleteRelation(ref sReturn, lngBillKey);


                }


                //删除子表


                DeleteBillSub(lngBillKey);


                //插入子表


@@ -120,6 +163,11 @@


                //        return false;


                //    }


                //}


                if (DetailColl.Count != 0)


                {


                    //更新订单关联数量


                    AddNewRelation(ref sReturn, omodel.HInterID);


                }


                sReturn = "修改单据成功！";


                oCn.Commit();


                return true;


@@ -178,6 +226,11 @@


                      "," + oSub.HPOContractInterID.ToString() + "," + oSub.HPOContractEntryID.ToString() + ",'" + oSub.HPOContractBillNo + "'," + oSub.HSeContractInterID.ToString() + "," + oSub.HSeContractEntryID.ToString() + ",'" + oSub.HSeContractBillNo + "'" +


                      ") ");


                }


                if (DetailColl.Count != 0)


                {


                    //更新订单关联数量


                    AddNewRelation(ref sReturn, omodel.HInterID);


                }


                //


                //foreach (Model.ClsYF_PayMentBillSub oSub in DetailColl)


                //{




 DAL/Ó¦ÊÕ¹ÜÀí/ClsYS_ReceiveBill.cs


@@ -41,7 +41,7 @@


            //应收单 å…³è”数量


            try


            {


                if (DetailColl[0].HSourceBillType == "1114")                    //应收单


                if (DetailColl[0].HSourceBillType == "1426")                    //应收单


                {


                    oCn.RunProc("exec h_p_Xs_UpDateRelation_ReceiveToReceivableIn_Del " + lngBillKey.ToString());


                }


@@ -60,7 +60,7 @@


            //应收单 å…³è”数量


            try


            {


                if (DetailColl[0].HSourceBillType == "1114")                    //应收单


                if (DetailColl[0].HSourceBillType == "1426")                    //应收单


                {


                    oCn.RunProc("exec h_p_Xs_UpDateRelation_ReceiveToReceivableIn_Add " + lngBillKey.ToString());


                }




 WebAPI/Controllers/CGGL/YF_PayMentBillController.cs


@@ -447,7 +447,13 @@




                string sReturn = "";


                oCN.BeginTran();




                ds = oCN.RunProcReturn("select * from h_v_YF_PayMentBillList where hmainid=" + HInterID, "h_v_YF_PayMentBillList");


                string hSourceBillType = ds.Tables[0].Rows[0]["源单类型"].ToString();


                if (hSourceBillType == "1114")


                {


                    //收款单 åˆ é™¤å›žå¡« åº”付单关联数量


                    oCN.RunProc("exec h_p_Cg_UpDateRelation_PayableToPayMent_Del " + HInterID);


                }


                oCN.RunProc("delete from YF_PayMentBillMain where HInterID = " + HInterID);


                oCN.RunProc("delete from YF_PayMentBillSub where HInterID= " + HInterID);






 WebAPI/Models/ClsKf_ICStockBillSub.cs


@@ -74,7 +74,7 @@


        public Int64 HSourceInterID;


        public Int64 HSourceEntryID;


        public Int64 HAuxPropID;


        public Int64 HlineTotal;


        public double HlineTotal;




        public object HContainerNum { get; internal set; }


        public object HPVC { get; internal set; }




 WebAPI/Properties/PublishProfiles/FolderProfile21.pubxml.user


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


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


  <PropertyGroup>


    <_PublishTargetUrl>G:\issWeb\网站发布\API</_PublishTargetUrl>


    <History>True|2024-08-22T04:38:36.4895558Z;True|2024-08-22T10:56:52.4037571+08:00;True|2024-08-22T10:23:09.0739592+08:00;True|2024-08-22T09:03:26.5727554+08:00;False|2024-08-22T09:02:31.4240959+08:00;True|2024-08-22T08:47:36.3625451+08:00;True|2024-08-21T16:51:37.2382964+08:00;True|2024-08-21T16:25:44.7030554+08:00;True|2024-08-21T16:21:11.7076342+08:00;False|2024-08-21T16:20:13.4190052+08:00;True|2024-08-21T16:00:41.9895716+08:00;True|2024-08-21T14:57:09.3460834+08:00;True|2024-08-21T10:38:36.4128047+08:00;True|2024-08-21T08:14:03.4933362+08:00;</History>


    <History>True|2024-08-23T00:57:01.4824044Z;True|2024-08-22T16:32:28.5510545+08:00;True|2024-08-22T15:05:33.7972126+08:00;True|2024-08-22T13:12:04.7949636+08:00;True|2024-08-22T12:38:36.4895558+08:00;True|2024-08-22T10:56:52.4037571+08:00;True|2024-08-22T10:23:09.0739592+08:00;True|2024-08-22T09:03:26.5727554+08:00;False|2024-08-22T09:02:31.4240959+08:00;True|2024-08-22T08:47:36.3625451+08:00;True|2024-08-21T16:51:37.2382964+08:00;True|2024-08-21T16:25:44.7030554+08:00;True|2024-08-21T16:21:11.7076342+08:00;False|2024-08-21T16:20:13.4190052+08:00;True|2024-08-21T16:00:41.9895716+08:00;True|2024-08-21T14:57:09.3460834+08:00;True|2024-08-21T10:38:36.4128047+08:00;True|2024-08-21T08:14:03.4933362+08:00;</History>


  </PropertyGroup>


  <ItemGroup>


    <File Include="apiapp.json">


@@ -45,19 +45,19 @@


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


    </File>


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


      <publishTime>08/22/2024 09:03:10</publishTime>


      <publishTime>08/23/2024 08:56:36</publishTime>


    </File>


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


      <publishTime>08/22/2024 09:03:10</publishTime>


      <publishTime>08/23/2024 08:56:36</publishTime>


    </File>


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


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


    </File>


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


      <publishTime>08/22/2024 09:03:08</publishTime>


      <publishTime>08/23/2024 08:56:33</publishTime>


    </File>


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


      <publishTime>08/22/2024 09:03:08</publishTime>


      <publishTime>08/23/2024 08:56:33</publishTime>


    </File>


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


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


@@ -288,13 +288,13 @@


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


    </File>


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


      <publishTime>08/22/2024 12:38:24</publishTime>


      <publishTime>08/23/2024 08:56:45</publishTime>


    </File>


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


      <publishTime>08/22/2024 12:38:24</publishTime>


      <publishTime>08/23/2024 08:56:45</publishTime>


    </File>


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


      <publishTime>08/22/2024 12:38:33</publishTime>


      <publishTime>08/23/2024 08:56:56</publishTime>


    </File>


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


      <publishTime>07/18/2013 01:03:52</publishTime>


@@ -489,7 +489,7 @@


      <publishTime>04/29/2024 08:30:03</publishTime>


    </File>


    <File Include="Web.config">


      <publishTime>08/21/2024 08:14:02</publishTime>


      <publishTime>08/22/2024 15:05:31</publishTime>


    </File>


  </ItemGroup>


</Project>