找回密码
 立即注册

QQ登录

只需一步,快速开始

学员

金牌服务用户

185

主题

735

帖子

1660

积分

金牌服务用户

积分
1660
学员
金牌服务用户   /  发表于:2022-2-22 17:05  /   查看:1433  /  回复:3
1金币
在进行测试的时候,出现错误 , 这个错误说 什么列名  组织无效  , 我应该没有设置什么列名

附件: 您需要 登录 才可以下载或查看,没有帐号?立即注册

最佳答案

查看完整内容

问题解决了,主要原始是因为视图有改过,需要重新绑定才能解决这个问题。

3 个回复

倒序浏览
最佳答案
最佳答案
学员
金牌服务用户   /  发表于:2022-2-22 17:05:10
来自 3#
问题解决了,主要原始是因为视图有改过,需要重新绑定才能解决这个问题。
回复 使用道具 举报
学员
金牌服务用户   /  发表于:2022-2-22 17:12:11
2#
在执行导出操作时,未知的异常出现。请再次尝试。
{
  "ClassName": "System.AggregateException",
  "Message": "One or more errors occurred.",
  "Data": null,
  "InnerException": {
    "$type": "System.Data.SqlClient.SqlException, System.Data.SqlClient",
    "ClassName": "System.Data.SqlClient.SqlException",
    "Message": "列名 '组织' 无效。",
    "Data": {
      "$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
      "HelpLink.ProdName": "Microsoft SQL Server",
      "HelpLink.ProdVer": "11.00.3128",
      "HelpLink.EvtSrc": "MSSQLServer",
      "HelpLink.EvtID": "207",
      "HelpLink.BaseHelpUrl": "https://go.microsoft.com/fwlink",
      "HelpLink.LinkId": "20476",
      "SqlError 1": "System.Data.SqlClient.SqlError: 列名 '组织' 无效。"
    },
    "InnerException": null,
    "HelpURL": null,
    "StackTraceString": "   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
   at ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
   at ForguncyDataAccess.DataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
   at Forguncy.Server2.b.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
   at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
   at ForguncyDataAccess.DataAccess.<>c__DisplayClass30_0.<<GetDetailDataTable>b__0>d.MoveNext()",
    "RemoteStackTraceString": null,
    "RemoteStackIndex": 0,
    "ExceptionMethod": null,
    "HResult": -2146232060,
    "Source": "Core .Net SqlClient Data Provider",
    "WatsonBuckets": null,
    "Errors": null,
    "ClientConnectionId": "5471978a-4286-4c12-bf28-7d8cc353ccc2"
  },
  "HelpURL": null,
  "StackTraceString": "   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at Forguncy.Server2.Controllers.b.q(String A_0, String A_1)
   at Forguncy.Server2.Controllers.a.a(ListViewInfo A_0, Boolean A_1)
   at Forguncy.Server2.Controllers.a.e(GcExcelSheetWrapper A_0, List`1 A_1)
   at Forguncy.Server2.Controllers.a.b(Int32 A_0)
   at Forguncy.Server2.Controllers.a.c(Int32 A_0)
   at Forguncy.Server2.Controllers.a.a(Int32 A_0)
   at Forguncy.Server2.Controllers.a.a(Action`1 A_0)
   at Forguncy.Server2.Controllers.a.c(Boolean A_0)
   at Forguncy.Server2.Controllers.a.i()
   at Forguncy.Server2.Controllers.HomeController.a(Object A_0)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": null,
  "HResult": -2146233088,
  "Source": "System.Private.CoreLib",
  "WatsonBuckets": null,
  "InnerExceptions": {
    "$type": "System.Exception[], System.Private.CoreLib",
    "$values": [
      {
        "$type": "System.Data.SqlClient.SqlException, System.Data.SqlClient",
        "ClassName": "System.Data.SqlClient.SqlException",
        "Message": "列名 '组织' 无效。",
        "Data": {
          "$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
          "HelpLink.ProdName": "Microsoft SQL Server",
          "HelpLink.ProdVer": "11.00.3128",
          "HelpLink.EvtSrc": "MSSQLServer",
          "HelpLink.EvtID": "207",
          "HelpLink.BaseHelpUrl": "https://go.microsoft.com/fwlink",
          "HelpLink.LinkId": "20476",
          "SqlError 1": "System.Data.SqlClient.SqlError: 列名 '组织' 无效。"
        },
        "InnerException": null,
        "HelpURL": null,
        "StackTraceString": "   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Forguncy.DataSourceBase.FillTableAsync(String commandText, IEnumerable`1 parameters)
   at ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
   at ForguncyDataAccess.DataAccess.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
   at Forguncy.Server2.b.SelectAsync(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
   at ForguncyDataAccess.DataAccess.GetDetailDataTableAsync(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
   at ForguncyDataAccess.DataAccess.<>c__DisplayClass30_0.<<GetDetailDataTable>b__0>d.MoveNext()",
        "RemoteStackTraceString": null,
        "RemoteStackIndex": 0,
        "ExceptionMethod": null,
        "HResult": -2146232060,
        "Source": "Core .Net SqlClient Data Provider",
        "WatsonBuckets": null,
        "Errors": null,
        "ClientConnectionId": "5471978a-4286-4c12-bf28-7d8cc353ccc2"
      }
    ]
  }
}

CurrentMethodName: ExportToExcelThread
回复 使用道具 举报
Lay.Li悬赏达人认证 活字格认证
超级版主   /  发表于:2022-2-22 17:53:35
4#
问题解决了就好,这边按照您所说的步骤尝试复现一下这个问题。
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部