请选择 进入手机版 | 继续访问电脑版
 找回密码
 立即注册

QQ登录

只需一步,快速开始

djs521720 讲师达人认证 悬赏达人认证 活字格认证

金牌服务用户

441

主题

1654

帖子

5547

积分

金牌服务用户

积分
5547

活字格认证圣诞拼拼乐微信认证勋章悬赏达人讲师达人

QQ
djs521720 讲师达人认证 悬赏达人认证 活字格认证
金牌服务用户   /  发表于:2019-2-23 15:05  /   查看:1612  /  回复:8
本帖最后由 djs521720 于 2019-2-25 13:09 编辑

单独两个视图都是可以加载数据,单内置库视图关联外联库视图报错,无法加载数据



ga.js:1 Uncaught SyntaxError: Invalid or unexpected token
%E9%9A%90%E8%97%8F%E6%A0%87%E9%A2%98%E6%A0%8F.js:1 Uncaught SyntaxError: Invalid or unexpected token
Script.js:1 Uncaught SyntaxError: Invalid or unexpected token
jquery-3.2.1.min.js:4 [Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check https://xhr.spec.whatwg.org/.
send @ jquery-3.2.1.min.js:4
Forguncy.js?v=636833428692780387:1 Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:140915
Request Data:
bindingInfos:-----------------------
[{"TableName":"考勤视图_排班","ColumnName":"员工考勤号"},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"员工姓名"}},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"部门ID","NextRelationBinding":{"RelatedTable":"部门名称字典表","RelatedColumn":"ID","DisplayColumn":"部门中文名称"}}},{"TableName":"考勤视图_排班","ColumnName":"日期"},{"TableName":"考勤视图_排班","ColumnName":"上班码","RelationBinding":{"RelatedTable":"节日字典表","RelatedColumn":"节日ID","DisplayColumn":"节日名称"}},{"TableName":"考勤视图_排班","ColumnName":"班次ID","RelationBinding":{"RelatedTable":"班次表","RelatedColumn":"ID","DisplayColumn":"班次名称"}},{"TableName":"考勤视图_排班","ColumnName":"扣款补卡次数"},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"标准工时"}},{"TableName":"考勤视图_排班","ColumnName":"加班时长"},{"TableName":"考勤视图_排班","ColumnName":"连班时数"},{"TableName":"考勤视图_排班","ColumnName":"请假时长"},{"TableName":"考勤视图_排班","ColumnName":"开始时间"},{"TableName":"考勤视图_排班","ColumnName":"结束时间"},{"TableName":"考勤视图_排班","ColumnName":"正式上班码"},{"TableName":"考勤视图_排班","ColumnName":"班次ID"},{"TableName":"考勤视图_排班","ColumnName":"时间段ID"},{"TableName":"考勤视图_排班","ColumnName":"有薪时长"},{"TableName":"考勤视图_排班","ColumnName":"销假ID"},{"TableName":"考勤视图_排班","ColumnName":"是_否晚上开始上班"},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"计薪别"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"早上上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"早上下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"下午上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"下午下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"晚上上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"晚上下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"今天考勤识别码"},{"TableName":"考勤视图_排班","ColumnName":"今天考勤识别码","RelationBinding":{"RelatedTable":"打卡记录视图_2","RelatedColumn":"考勤识别码","DisplayColumn":"白班上午下班"}},{"TableName":"考勤视图_排班","ColumnName":"判断选用识别码"}]
------------------------------
currentRowInfo:-----------------------
{"currentTable":"考勤视图_排班","viewname":"考勤分析表 (2)分析表","listviewLocation":"考勤分析表 (2)分析表"}
------------------------------
demandRowCount:-----------------------
0
------------------------------
currentDataLength:-----------------------
0
------------------------------
needRowVersion:-----------------------
false
------------------------------
editorDataInfos:-----------------------

------------------------------
sortCommandID:-----------------------

------------------------------
orderByInfo:-----------------------

------------------------------
offsetConditionInfo:-----------------------
{"targetPage":1,"pageLimitRowCount":0}
------------------------------
{
  "ClassName": "System.FormatException",
  "Message": "对象不能被转换为 DBNull。",
  "Data": {
    "$type": "System.Collections.ListDictionaryInternal, mscorlib",
    "App Name": "ForguncyServerConsole.exe",
    "App Version": "4.0.105.0",
    "Timestamp of the exe": "5c4058a4",
    "Assembly Name": "mscorlib",
    "Version of faulting assembly": "4.7.3324.0",
    "Timestamp of faulting module": "5c09b7d7",
    "MethodDef": "ba5",
    "IL Offset of faulting instruction": "222",
    "Exception Type": "System.FormatException",
    "NIL": ""
  },
  "InnerException": {
    "$type": "System.InvalidCastException, mscorlib",
    "ClassName": "System.InvalidCastException",
    "Message": "对象不能被转换为 DBNull。",
    "Data": null,
    "InnerException": null,
    "HelpURL": null,
    "StackTraceString": "   在 System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)
   在 System.String.System.IConvertible.ToType(Type type, IFormatProvider provider)
   在 System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   在 CommonUtilities.SuperConverter.a(Object A_0, Type A_1, IFormatProvider A_2)",
    "RemoteStackTraceString": null,
    "RemoteStackIndex": 0,
    "ExceptionMethod": "8
DefaultToType
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Convert
System.Object DefaultToType(System.IConvertible, System.Type, System.IFormatProvider)",
    "HResult": -2147467262,
    "Source": "mscorlib",
    "WatsonBuckets": null
  },
  "HelpURL": null,
  "StackTraceString": "   在 CommonUtilities.SuperConverter.a(Object A_0, Type A_1, IFormatProvider A_2)
   在 CommonUtilities.SuperConverter.Convert(Object value, TypeConverter sourceTypeConverter, Type targetType, TypeConverter targetTypeConverter, String format, IFormatProvider formatProvider)
   在 CommonUtilities.SuperConverter.Convert(Object value, Type targetType)
   在 ForguncyDataAccess.DataAccess.a(DataTable A_0, List`1 A_1, String A_2)
   在 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
a
CommonUtilities, Version=4.0.105.0, Culture=neutral, PublicKeyToken=967100671921c115
CommonUtilities.SuperConverter
System.Object a(System.Object, System.Type, System.IFormatProvider)",
  "HResult": -2146233033,
  "Source": "CommonUtilities",
  "WatsonBuckets": null
}

i.checkError @ Forguncy.js?v=636833428692780387:1
Forguncy.js?v=636833428692780387:1 Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:140915
Request Data:
bindingInfos:-----------------------
[{"TableName":"考勤视图_排班","ColumnName":"员工考勤号"},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"员工姓名"}},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"部门ID","NextRelationBinding":{"RelatedTable":"部门名称字典表","RelatedColumn":"ID","DisplayColumn":"部门中文名称"}}},{"TableName":"考勤视图_排班","ColumnName":"日期"},{"TableName":"考勤视图_排班","ColumnName":"上班码","RelationBinding":{"RelatedTable":"节日字典表","RelatedColumn":"节日ID","DisplayColumn":"节日名称"}},{"TableName":"考勤视图_排班","ColumnName":"班次ID","RelationBinding":{"RelatedTable":"班次表","RelatedColumn":"ID","DisplayColumn":"班次名称"}},{"TableName":"考勤视图_排班","ColumnName":"扣款补卡次数"},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"标准工时"}},{"TableName":"考勤视图_排班","ColumnName":"加班时长"},{"TableName":"考勤视图_排班","ColumnName":"连班时数"},{"TableName":"考勤视图_排班","ColumnName":"请假时长"},{"TableName":"考勤视图_排班","ColumnName":"开始时间"},{"TableName":"考勤视图_排班","ColumnName":"结束时间"},{"TableName":"考勤视图_排班","ColumnName":"正式上班码"},{"TableName":"考勤视图_排班","ColumnName":"班次ID"},{"TableName":"考勤视图_排班","ColumnName":"时间段ID"},{"TableName":"考勤视图_排班","ColumnName":"有薪时长"},{"TableName":"考勤视图_排班","ColumnName":"销假ID"},{"TableName":"考勤视图_排班","ColumnName":"是_否晚上开始上班"},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"计薪别"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"早上上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"早上下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"下午上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"下午下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"晚上上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"晚上下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"今天考勤识别码"},{"TableName":"考勤视图_排班","ColumnName":"今天考勤识别码","RelationBinding":{"RelatedTable":"打卡记录视图_2","RelatedColumn":"考勤识别码","DisplayColumn":"白班上午下班"}},{"TableName":"考勤视图_排班","ColumnName":"判断选用识别码"}]
------------------------------
currentRowInfo:-----------------------
{"currentTable":"考勤视图_排班","viewname":"考勤分析表 (2)分析表","listviewLocation":"考勤分析表 (2)分析表"}
------------------------------
demandRowCount:-----------------------
0
------------------------------
currentDataLength:-----------------------
0
------------------------------
needRowVersion:-----------------------
false
------------------------------
queryCommandInfo:-----------------------
{"id":"ea3e71ca2be846fbbda938e03248301e","paramList":{"=E5":null,"=M5":43497,"=V5":43524,"=AB5":null,"=AG5":null}}
------------------------------
editorDataInfos:-----------------------

------------------------------
sortCommandID:-----------------------

------------------------------
orderByInfo:-----------------------

------------------------------
offsetConditionInfo:-----------------------
{"targetPage":1,"pageLimitRowCount":0}
------------------------------
{
  "ClassName": "System.FormatException",
  "Message": "对象不能被转换为 DBNull。",
  "Data": {
    "$type": "System.Collections.ListDictionaryInternal, mscorlib",
    "App Name": "ForguncyServerConsole.exe",
    "App Version": "4.0.105.0",
    "Timestamp of the exe": "5c4058a4",
    "Assembly Name": "mscorlib",
    "Version of faulting assembly": "4.7.3324.0",
    "Timestamp of faulting module": "5c09b7d7",
    "MethodDef": "ba5",
    "IL Offset of faulting instruction": "222",
    "Exception Type": "System.FormatException",
    "NIL": ""
  },
  "InnerException": {
    "$type": "System.InvalidCastException, mscorlib",
    "ClassName": "System.InvalidCastException",
    "Message": "对象不能被转换为 DBNull。",
    "Data": null,
    "InnerException": null,
    "HelpURL": null,
    "StackTraceString": "   在 System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)
   在 System.String.System.IConvertible.ToType(Type type, IFormatProvider provider)
   在 System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   在 CommonUtilities.SuperConverter.a(Object A_0, Type A_1, IFormatProvider A_2)",
    "RemoteStackTraceString": null,
    "RemoteStackIndex": 0,
    "ExceptionMethod": "8
DefaultToType
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Convert
System.Object DefaultToType(System.IConvertible, System.Type, System.IFormatProvider)",
    "HResult": -2147467262,
    "Source": "mscorlib",
    "WatsonBuckets": null
  },
  "HelpURL": null,
  "StackTraceString": "   在 CommonUtilities.SuperConverter.a(Object A_0, Type A_1, IFormatProvider A_2)
   在 CommonUtilities.SuperConverter.Convert(Object value, TypeConverter sourceTypeConverter, Type targetType, TypeConverter targetTypeConverter, String format, IFormatProvider formatProvider)
   在 CommonUtilities.SuperConverter.Convert(Object value, Type targetType)
   在 ForguncyDataAccess.DataAccess.a(DataTable A_0, List`1 A_1, String A_2)
   在 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
a
CommonUtilities, Version=4.0.105.0, Culture=neutral, PublicKeyToken=967100671921c115
CommonUtilities.SuperConverter
System.Object a(System.Object, System.Type, System.IFormatProvider)",
  "HResult": -2146233033,
  "Source": "CommonUtilities",
  "WatsonBuckets": null
}

i.checkError @ Forguncy.js?v=636833428692780387:1
Forguncy.js?v=636833428692780387:1 Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
UserName:140915
Request Data:
bindingInfos:-----------------------
[{"TableName":"考勤视图_排班","ColumnName":"员工考勤号"},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"员工姓名"}},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"部门ID","NextRelationBinding":{"RelatedTable":"部门名称字典表","RelatedColumn":"ID","DisplayColumn":"部门中文名称"}}},{"TableName":"考勤视图_排班","ColumnName":"日期"},{"TableName":"考勤视图_排班","ColumnName":"上班码","RelationBinding":{"RelatedTable":"节日字典表","RelatedColumn":"节日ID","DisplayColumn":"节日名称"}},{"TableName":"考勤视图_排班","ColumnName":"班次ID","RelationBinding":{"RelatedTable":"班次表","RelatedColumn":"ID","DisplayColumn":"班次名称"}},{"TableName":"考勤视图_排班","ColumnName":"扣款补卡次数"},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"标准工时"}},{"TableName":"考勤视图_排班","ColumnName":"加班时长"},{"TableName":"考勤视图_排班","ColumnName":"连班时数"},{"TableName":"考勤视图_排班","ColumnName":"请假时长"},{"TableName":"考勤视图_排班","ColumnName":"开始时间"},{"TableName":"考勤视图_排班","ColumnName":"结束时间"},{"TableName":"考勤视图_排班","ColumnName":"正式上班码"},{"TableName":"考勤视图_排班","ColumnName":"班次ID"},{"TableName":"考勤视图_排班","ColumnName":"时间段ID"},{"TableName":"考勤视图_排班","ColumnName":"有薪时长"},{"TableName":"考勤视图_排班","ColumnName":"销假ID"},{"TableName":"考勤视图_排班","ColumnName":"是_否晚上开始上班"},{"TableName":"考勤视图_排班","ColumnName":"员工考勤号","RelationBinding":{"RelatedTable":"员工信息表","RelatedColumn":"工牌号码","DisplayColumn":"计薪别"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"早上上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"早上下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"下午上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"下午下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"晚上上班时间"}},{"TableName":"考勤视图_排班","ColumnName":"时间段ID","RelationBinding":{"RelatedTable":"班次时间段表","RelatedColumn":"ID","DisplayColumn":"晚上下班时间"}},{"TableName":"考勤视图_排班","ColumnName":"今天考勤识别码"},{"TableName":"考勤视图_排班","ColumnName":"今天考勤识别码","RelationBinding":{"RelatedTable":"打卡记录视图_2","RelatedColumn":"考勤识别码","DisplayColumn":"白班上午下班"}},{"TableName":"考勤视图_排班","ColumnName":"判断选用识别码"}]
------------------------------
currentRowInfo:-----------------------
{"currentTable":"考勤视图_排班","viewname":"考勤分析表 (2)分析表","listviewLocation":"考勤分析表 (2)分析表"}
------------------------------
demandRowCount:-----------------------
0
------------------------------
currentDataLength:-----------------------
0
------------------------------
needRowVersion:-----------------------
false
------------------------------
queryCommandInfo:-----------------------
{"id":"ea3e71ca2be846fbbda938e03248301e","paramList":{"=E5":null,"=M5":43497,"=V5":43524,"=AB5":null,"=AG5":null}}
------------------------------
editorDataInfos:-----------------------

------------------------------
sortCommandID:-----------------------
dba7081bcd484f14862f0ef59d876b5e
------------------------------
offsetConditionInfo:-----------------------
{"targetPage":1,"pageLimitRowCount":0}
------------------------------
{
  "ClassName": "System.FormatException",
  "Message": "对象不能被转换为 DBNull。",
  "Data": {
    "$type": "System.Collections.ListDictionaryInternal, mscorlib",
    "App Name": "ForguncyServerConsole.exe",
    "App Version": "4.0.105.0",
    "Timestamp of the exe": "5c4058a4",
    "Assembly Name": "mscorlib",
    "Version of faulting assembly": "4.7.3324.0",
    "Timestamp of faulting module": "5c09b7d7",
    "MethodDef": "ba5",
    "IL Offset of faulting instruction": "222",
    "Exception Type": "System.FormatException",
    "NIL": ""
  },
  "InnerException": {
    "$type": "System.InvalidCastException, mscorlib",
    "ClassName": "System.InvalidCastException",
    "Message": "对象不能被转换为 DBNull。",
    "Data": null,
    "InnerException": null,
    "HelpURL": null,
    "StackTraceString": "   在 System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider)
   在 System.String.System.IConvertible.ToType(Type type, IFormatProvider provider)
   在 System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   在 CommonUtilities.SuperConverter.a(Object A_0, Type A_1, IFormatProvider A_2)",
    "RemoteStackTraceString": null,
    "RemoteStackIndex": 0,
    "ExceptionMethod": "8
DefaultToType
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Convert
System.Object DefaultToType(System.IConvertible, System.Type, System.IFormatProvider)",
    "HResult": -2147467262,
    "Source": "mscorlib",
    "WatsonBuckets": null
  },
  "HelpURL": null,
  "StackTraceString": "   在 CommonUtilities.SuperConverter.a(Object A_0, Type A_1, IFormatProvider A_2)
   在 CommonUtilities.SuperConverter.Convert(Object value, TypeConverter sourceTypeConverter, Type targetType, TypeConverter targetTypeConverter, String format, IFormatProvider formatProvider)
   在 CommonUtilities.SuperConverter.Convert(Object value, Type targetType)
   在 ForguncyDataAccess.DataAccess.a(DataTable A_0, List`1 A_1, String A_2)
   在 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
a
CommonUtilities, Version=4.0.105.0, Culture=neutral, PublicKeyToken=967100671921c115
CommonUtilities.SuperConverter
System.Object a(System.Object, System.Type, System.IFormatProvider)",
  "HResult": -2146233033,
  "Source": "CommonUtilities",
  "WatsonBuckets": null
}

i.checkError @ Forguncy.js?v=636833428692780387:1

8 个回复

倒序浏览
lwt悬赏达人认证 活字格认证
论坛元老   /  发表于:2019-2-23 15:26:13
沙发
不支持跨数据源关联
回复 使用道具 举报
djs521720讲师达人认证 悬赏达人认证 活字格认证
金牌服务用户   /  发表于:2019-2-23 15:38:27
板凳
lwt 发表于 2019-2-23 15:26
不支持跨数据源关联

这是本身支持的!之前一直好好的!最近不知道为什么不行了!
回复 使用道具 举报
lwt悬赏达人认证 活字格认证
论坛元老   /  发表于:2019-2-23 16:05:34
地板
djs521720 发表于 2019-2-23 15:38
这是本身支持的!之前一直好好的!最近不知道为什么不行了!

记错了关联是可以,不可以再查询。你这问题看不出来。
回复 使用道具 举报
songlinxin
中级会员   /  发表于:2019-2-23 16:07:59
5#
这代码有点像天书。。。看不懂
只能说一句
我槽大神膜拜了!!!!
回复 使用道具 举报
无厘头
初级会员   /  发表于:2019-2-24 22:39:33
6#
你的第五行是不是空行?看不懂~~~积分全靠猜!~~~
回复 使用道具 举报
Eric.Liang讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2019-2-25 09:04:25
7#
老板,你的这个问题这样子是看不出来的哈,方便的话你可以搞一个有问题的小DEMO,只有两个表,把外联的备份给我。
回复 使用道具 举报
djs521720讲师达人认证 悬赏达人认证 活字格认证
金牌服务用户   /  发表于:2019-2-25 13:08:56
8#
Eric.Liang 发表于 2019-2-25 09:04
老板,你的这个问题这样子是看不出来的哈,方便的话你可以搞一个有问题的小DEMO,只有两个表,把外联的备份 ...

谢谢!发现是有为空数据导致的!重新改写视图,过滤为空字段,已解决!
回复 使用道具 举报
Tracy.Liu讲师达人认证 悬赏达人认证 活字格认证
论坛元老   /  发表于:2019-2-25 13:29:51
9#
好的,感谢您的支持
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部