看板接口修改

yl

2022-08-01 832e62a7ef59d4268e54c5994360554210d8729d

看板接口修改

 .vs/VueWebApi/v16/.suo

Binary files differ

 VueWebApi/Controllers/KanBanManagerentController.cs

@@ -40,7 +40,7 @@
        /// <param name="json">提交数据(参考工序定义关联工作站提交)</param>
        /// <returns></returns>
        [Route(template: "LineSearchTopLeftData")]
        [HttpGet]
        [HttpPost]
        public HttpResponseMessage LineSearchTopLeftData(List<ObjectData> json)
        {
            mes = KanBanManagerentBLL.LineSearchTopLeftData(json);
@@ -89,5 +89,6 @@
            return TJson.toJson(mes);
        }
        #endregion

    }
}

 VueWebApi/DLL/DAL/KanBanManagerentDAL.cs

@@ -57,12 +57,12 @@
        {
            string sql = "";
            string search = "";
            List<ShopTopLeft> list = new List<ShopTopLeft>();
            var dynamicParams = new DynamicParameters();
            try
            {
                if (json == null || json.Count <= 0) //产线编码不为空
                if (json == null || json.Count>0) //产线编码不为空
                {
                    List<ShopTopLeft> list = new List<ShopTopLeft>();
                    //获取产线信息
                    for (int i = 0; i < json.Count; i++)
                    {
@@ -118,7 +118,7 @@
                                            from TK_Wrk_Step A
                                            left join TStep T on A.step_code=T.stepcode
                                            where A.wo_code=@wo_code";
                                    dynamicParams.Add("@linecode", wo_code);
                                    dynamicParams.Add("@wo_code", wo_code);
                                    var data1 = DapperHelper.selectdata(sql, dynamicParams);
                                    for (int k = 0; k < data1.Rows.Count; k++)
                                    {
@@ -171,6 +171,9 @@
                mes.Message = e.Message;
                mes.data = null;
            }
            mes.code = "200";
            mes.Message = "查询成功!";
            mes.data = list;
            return mes;
        }
        #endregion\

 VueWebApi/Logs/2022-08-01.TXT

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,29 @@
 ã€æ—¶é—´ã€‘:2022-08-01 10:27:57,417
 ã€çº§åˆ«ã€‘:ERROR
 ã€ç±»åã€‘:日志记录
 ã€çº¿ç¨‹ID】: 9 
 ã€æ–‡ä»¶åœ°å€ã€‘:D:\新凯迪MES\VueWebApi\VueWebApi\Tools\LogHelper.cs ç¬¬26行
 ã€æ—¥å¿—内容】:
消息类型：SqlException
消息内容：必须声明标量变量 "@wo_code"。
引发异常路径：/api/KanBanManagerent/LineSearchTopLeftData
引发异常的方法：OnError
引发异常源：.Net SqlClient Data Provider   åœ¨ System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   åœ¨ System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   åœ¨ System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   åœ¨ System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   åœ¨ System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   åœ¨ System.Data.SqlClient.SqlDataReader.get_MetaData()
   åœ¨ System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   åœ¨ System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   åœ¨ System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   åœ¨ System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   åœ¨ System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   åœ¨ Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior)
   åœ¨ Dapper.SqlMapper.ExecuteReaderImpl(IDbConnection cnn, CommandDefinition& command, CommandBehavior commandBehavior, IDbCommand& cmd)
   åœ¨ Dapper.SqlMapper.ExecuteReader(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType)
   åœ¨ VueWebApi.Tools.DapperHelper.selectdata(String sql, Object parm) ä½ç½® D:\新凯迪MES\VueWebApi\VueWebApi\Tools\DapperHelper.cs:行号 195
 ã€æ—¥è®°è¯¦ç»†ã€‘： 
---------------------------------------------------------------------------------------------------------------

 VueWebApi/Properties/PublishProfiles/FolderProfile.pubxml.user

@@ -696,16 +696,16 @@
      <publishTime>12/24/2021 15:38:29</publishTime>
    </File>
    <File Include="bin/VueWebApi.dll">
      <publishTime>07/29/2022 14:06:06</publishTime>
      <publishTime>08/01/2022 10:40:13</publishTime>
    </File>
    <File Include="bin/VueWebApi.dll.config">
      <publishTime>06/15/2022 15:31:43</publishTime>
    </File>
    <File Include="bin/VueWebApi.pdb">
      <publishTime>07/29/2022 14:06:06</publishTime>
      <publishTime>08/01/2022 10:40:13</publishTime>
    </File>
    <File Include="bin/VueWebApi.xml">
      <publishTime>07/29/2022 14:06:06</publishTime>
      <publishTime>08/01/2022 10:40:13</publishTime>
    </File>
    <File Include="bin/WebActivatorEx.dll">
      <publishTime>02/08/2013 16:42:28</publishTime>
@@ -1287,7 +1287,7 @@
      <publishTime>06/10/2022 08:20:24</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>07/29/2022 14:06:07</publishTime>
      <publishTime>08/01/2022 10:40:23</publishTime>
    </File>
  </ItemGroup>
</Project>

 VueWebApi/bin/VueWebApi.pdb

Binary files differ

 VueWebApi/obj/Release/DesignTimeResolveAssemblyReferencesInput.cache

Binary files differ

 VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb

Binary files differ

 VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache

Binary files differ

 VueWebApi/obj/Release/VueWebApi.csproj.FileListAbsolute.txt

@@ -267,4 +267,3 @@
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.CopyComplete
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Release\VueWebApi.dll
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Release\VueWebApi.pdb
D:\新凯迪MES\VueWebApi\VueWebApi\obj\Release\VueWebApi.csproj.AssemblyReference.cache

 VueWebApi/obj/Release/VueWebApi.pdb

Binary files differ