改制申请单加改型模式

zzr99

2021-10-22 ce842e6e2a4dd7e488e28d091fc481ccd77c5f9a

改制申请单加改型模式

 WebAPI/Controllers/MJGL/Sc_MouldRepairChangeBillController.cs

 WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs

@@ -46,14 +46,14 @@
                "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate," +
                "HMaker,HMakeDate,HInnerBillNo,HRepairID,HDeptID,HRepairBeginDate,HRepairEndDate," +
                "HCycleUnit,HPlanTimes,HTimes,HChangeNum,HEmpID,HManagerID,HRepairType,HSupID," +
                "HNewMaterID,HNewName,HNewModel,HNewModel2,HExplanation,HRepairContent,HRemark" +
                "HNewMaterID,HNewName,HNewModel,HNewModel2,HExplanation,HRepairContent,HRemark,HChangeType" +
                ") " +
                " values("+omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ",'"  + omodel.HMaker + "',getdate()" + 
                ",'" + omodel.HInnerBillNo+"',"+ omodel.HRepairID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HRepairBeginDate + "','" + omodel.HRepairEndDate +
                "','" + omodel.HCycleUnit + "'," + omodel.HPlanTimes.ToString() + "," + omodel.HTimes.ToString() + "," + omodel.HChangeNum.ToString()  + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() +
                 ",'" + omodel.HRepairType + "'," + omodel.HSupID.ToString() + "," + omodel.HNewMaterID.ToString() + ",'"+ omodel.HNewName + "','" + omodel.HNewModel + "','" + omodel.HNewModel2 + "','" + omodel.HExplanation  + "','" + omodel.HRepairContent + "','" + omodel.HRemark+
                 "') ");
                 "','"+omodel.HChangeType + "') ");
                //插入子表
                foreach (Models.ClsSc_MouldRepairChangeBillSub oSub in DetailColl)
                {

 WebAPI/Models/ClsSc_MouldRepairChangeBillMain.cs

@@ -28,6 +28,7 @@
        public string HNewBarCode;        /*--改制后新条码*/
        public string HNewDesignLife;       /*--新设计寿命*/
        public string HExplanation;           /* --改制要求*/
        public string HChangeType;         /* --改型类型*/
        public string HRemark;         /* --备注*/
        public string HInnerBillNo;        /* --内部单据号*/
    }

 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>10/21/2021 18:45:37</publishTime>
      <publishTime>10/22/2021 15:00:35</publishTime>
    </File>
    <File Include="bin/BLL.pdb">
      <publishTime>10/21/2021 18:45:37</publishTime>
      <publishTime>10/22/2021 15:00:35</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>10/21/2021 18:45:35</publishTime>
      <publishTime>10/22/2021 15:00:33</publishTime>
    </File>
    <File Include="bin/DAL.pdb">
      <publishTime>10/21/2021 18:45:35</publishTime>
      <publishTime>10/22/2021 15:00:33</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>07/22/2016 14:52:40</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>10/21/2021 18:45:30</publishTime>
      <publishTime>10/22/2021 15:00:29</publishTime>
    </File>
    <File Include="bin/DBUtility.pdb">
      <publishTime>10/21/2021 18:45:30</publishTime>
      <publishTime>10/22/2021 15:00:29</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>10/21/2021 18:45:30</publishTime>
      <publishTime>10/22/2021 15:00:30</publishTime>
    </File>
    <File Include="bin/Model.pdb">
      <publishTime>10/21/2021 18:45:30</publishTime>
      <publishTime>10/22/2021 15:00:30</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>10/21/2021 18:45:27</publishTime>
      <publishTime>10/22/2021 15:00:27</publishTime>
    </File>
    <File Include="bin/Pub_Class.pdb">
      <publishTime>10/21/2021 18:45:27</publishTime>
      <publishTime>10/22/2021 15:00:27</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>10/21/2021 18:45:28</publishTime>
      <publishTime>10/22/2021 15:00:28</publishTime>
    </File>
    <File Include="bin/Pub_Control.pdb">
      <publishTime>10/21/2021 18:45:28</publishTime>
      <publishTime>10/22/2021 15:00:28</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>10/21/2021 18:45:28</publishTime>
      <publishTime>10/22/2021 15:00:29</publishTime>
    </File>
    <File Include="bin/SQLHelper.pdb">
      <publishTime>10/21/2021 18:45:28</publishTime>
      <publishTime>10/22/2021 15:00:29</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>10/21/2021 18:45:41</publishTime>
      <publishTime>10/22/2021 15:00:38</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>10/21/2021 18:45:41</publishTime>
      <publishTime>10/22/2021 15:00:38</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>10/21/2021 18:46:44</publishTime>
      <publishTime>10/22/2021 15:01:44</publishTime>
    </File>
  </ItemGroup>
</Project>