委外工单

WYB

2021-04-27 20e924758f1ffbf538fee6b1d7852fdb270a5066

委外工单

 WebAPI/Controllers/Sc_ProcessMangementController.cs

@@ -479,13 +479,13 @@
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select top 500 * from WW_EntrustWorkOrderBillMain ", "WW_EntrustWorkOrderBillMain");
                    ds = oCN.RunProcReturn("select top 500 * from h_v_WW_EntrustWorkOrderBillList ", "h_v_WW_EntrustWorkOrderBillList");
                }
                else
                {
                    string sql1 = "select * from WW_EntrustWorkOrderBillMain where 1 = 1 ";
                    string sql1 = "select * from h_v_WW_EntrustWorkOrderBillList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "WW_EntrustWorkOrderBillMain");
                    ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustWorkOrderBillList");
                }
            }
            catch (Exception e)

 WebAPI/Properties/PublishProfiles/API.pubxml.user

@@ -11,28 +11,28 @@
  </PropertyGroup>
  <ItemGroup>
    <File Include="apiapp.json">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.dll">
      <publishTime>04/13/2021 13:28:28</publishTime>
      <publishTime>02/22/2013 08:43:40</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.pdb">
      <publishTime>04/13/2021 13:28:28</publishTime>
      <publishTime>02/22/2013 08:43:40</publishTime>
    </File>
    <File Include="bin/BLL.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>04/13/2021 13:30:11</publishTime>
      <publishTime>07/22/2016 14:52:40</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.FormService.dll">
      <publishTime>04/26/2020 09:57:16</publishTime>
@@ -50,7 +50,7 @@
      <publishTime>07/25/2012 11:48:56</publishTime>
    </File>
    <File Include="bin/Model.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Newtonsoft.Json.dll">
      <publishTime>08/03/2014 20:33:56</publishTime>
@@ -59,13 +59,13 @@
      <publishTime>01/04/2011 13:48:18</publishTime>
    </File>
    <File Include="bin/Pub_Class.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/Swashbuckle.Core.dll">
      <publishTime>02/15/2015 17:57:08</publishTime>
@@ -107,7 +107,7 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.Cors.dll">
      <publishTime>04/13/2021 13:30:39</publishTime>
      <publishTime>11/28/2018 12:58:44</publishTime>
    </File>
    <File Include="bin/System.Web.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -131,16 +131,16 @@
      <publishTime>11/28/2018 13:01:00</publishTime>
    </File>
    <File Include="bin/System.Web.Http.WebHost.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="bin/System.Web.Mvc.dll">
      <publishTime>04/13/2021 13:31:08</publishTime>
      <publishTime>01/28/2015 04:02:18</publishTime>
    </File>
    <File Include="bin/System.Web.Optimization.dll">
      <publishTime>04/13/2021 13:31:24</publishTime>
      <publishTime>02/11/2014 15:26:04</publishTime>
    </File>
    <File Include="bin/System.Web.Razor.dll">
      <publishTime>04/13/2021 13:31:12</publishTime>
      <publishTime>01/28/2015 04:02:32</publishTime>
    </File>
    <File Include="bin/System.Web.Services.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -164,10 +164,10 @@
      <publishTime>11/24/2014 11:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>04/22/2021 20:00:19</publishTime>
      <publishTime>04/27/2021 14:49:31</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>04/22/2021 20:00:19</publishTime>
      <publishTime>04/27/2021 14:49:31</publishTime>
    </File>
    <File Include="bin/WebAPI.XmlSerializers.dll">
      <publishTime>02/04/2021 21:35:21</publishTime>
@@ -185,163 +185,163 @@
      <publishTime>03/26/2019 14:23:20</publishTime>
    </File>
    <File Include="Content/bootstrap.css">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Content/bootstrap.min.css">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Content/Site.css">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/BLL.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/DAL.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/DBUtility.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/Model.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/Newtonsoft.Json.Net35.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/Pub_Class.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/Pub_Control.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="DLL/SQLHelper.dll">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.eot">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.svg">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.ttf">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.woff">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Global.asax">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Index.html">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json">
      <publishTime>04/13/2021 10:11:33</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="packages.config">
      <publishTime>04/13/2021 13:27:57</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.min.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.map">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.min.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Scripts/modernizr-2.6.2.js">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Shared/Error.cshtml">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/Shared/_Layout.cshtml">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/web.config">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Views/_ViewStart.cshtml">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Department_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Customer_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Department_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Employee_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Group_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Source_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource">
      <publishTime>04/13/2021 10:11:34</publishTime>
      <publishTime>03/26/2021 14:35:48</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>04/22/2021 20:00:25</publishTime>
      <publishTime>04/27/2021 14:49:42</publishTime>
    </File>
  </ItemGroup>
</Project>