本帖最后由 djs521720 于 2019-1-21 11:36 编辑
公式字段IF函数无法判断，页面无法加载数据！
以下错误代码！
Forguncy.js?v=636833428692780387:1 Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:140915
Request Data:
bindingInfos:-----------------------
[{"TableName":"排班视图","ColumnName":"考勤识别码"},{"TableName":"排班视图","ColumnName":"判断选用节日ID","RelationBinding":{"RelatedTable":"节日字典表","RelatedColumn":"节日ID","DisplayColumn":"节日名称"}}]
------------------------------
currentRowInfo:-----------------------
{"currentTable":"排班视图","viewname":"页面2表格1","listviewLocation":"页面2表格1"}
------------------------------
demandRowCount:-----------------------
0
------------------------------
currentDataLength:-----------------------
0
------------------------------
needRowVersion:-----------------------
false
------------------------------
editorDataInfos:-----------------------
------------------------------
sortCommandID:-----------------------
------------------------------
orderByInfo:-----------------------
------------------------------
offsetConditionInfo:-----------------------
{"targetPage":1,"pageLimitRowCount":0}
------------------------------
{
"errorCode": 1,
"ClassName": "System.Data.SQLite.SQLiteException",
"Message": "SQL logic error or missing database
no such column: a.判断选用节日ID",
"Data": {
"$type": "System.Collections.ListDictionaryInternal, mscorlib",
"App Name": "ForguncyServerConsole.exe",
"App Version": "4.0.105.0",
"Timestamp of the exe": "5c4058a4",
"Assembly Name": "System.Data.SQLite",
"Version of faulting assembly": "1.0.105.2",
"Timestamp of faulting module": "593c3a68",
"MethodDef": "3b",
"IL Offset of faulting instruction": "3d1",
"Exception Type": "System.Data.SQLite.SQLite",
"NIL": ""
},
"InnerException": null,
"HelpURL": null,
"StackTraceString": " 在 System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
在 System.Data.SQLite.SQLiteCommand.BuildNextCommand()
在 System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
在 System.Data.SQLite.SQLiteDataReader.NextResult()
在 System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
在 System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
在 Forguncy.DataSourceBase.FillTable(DataTable dataTable, String tableName, String tableSchema, Nullable`1 maxRows, String commandText, IEnumerable`1 parameters)
在 ForguncyDataAccess.DataAccess.a(String A_0, String A_1, DataBaseType A_2, DbParameter[] A_3)
在 ForguncyDataAccess.DataAccess.Select(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
在 Forguncy.Server2.a.a(TopSqlConditionBase A_0, String A_1, Boolean A_2, i A_3, OffsetSqlCondition A_4)
在 Forguncy.Server2.a.Select(List`1 columnBindingInfos, ISqlCondition selectCondition, TopSqlConditionBase topCondition, String tableName, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean useGroupBy)
在 ForguncyDataAccess.DataAccess.GetDetailDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
在 ForguncyDataAccess.DataAccess.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
在 Forguncy.Server2.a.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
在 Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, Int32 A_3, Boolean A_4, QueryCommandInfo A_5, List`1 A_6, String A_7, OffsetSqlCondition A_8, Boolean A_9)
在 Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffset(List`1 bindingInfos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 orderByInfo, String sortCommandID, List`1 editorDataInfos, OffsetConditionInfo offsetConditionInfo)",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": "8
Prepare
System.Data.SQLite, Version=1.0.105.2, Culture=neutral, PublicKeyToken=db937bc2d44ff139
System.Data.SQLite.SQLite3
System.Data.SQLite.SQLiteStatement Prepare(System.Data.SQLite.SQLiteConnection, System.String, System.Data.SQLite.SQLiteStatement, UInt32, System.String ByRef)",
"HResult": -2147467259,
"Source": "System.Data.SQLite",
"WatsonBuckets": null
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图
