版本号:

业务场景(如下):

 

预期效果(如下):

 

实际效果(如下)(包括错误,异常):

异常信息(异常类型:Genersoft.Platform.Core.Error.GSPException)
异常提示:执行分页数据查询发生错误,请查看扩展信息。错误信息:Conversion failed when converting date and/or time from character string.
异常信息:执行分页数据查询发生错误,请查看扩展信息。错误信息:Conversion failed when converting date and/or time from character string.
导致错误的应用程序或对象的名称:Genersoft.Platform.Engine.DataAccess
引发当前异常的方法:
异常相关帮助:
堆栈信息:
   at Genersoft.Platform.Engine.DataAccess.DataOperator.GSPDataOperator.GetPaginationData(SelectSqlStatement sql, GSPFilter& filter, GSPDataAccessEngineContext daeContext)
   at Genersoft.Platform.Engine.DataAccess.GSPDataAccessEngine.GetObjectsXml(String dataModelId, GSPFilter& gspFilter, DataQueryType queryType, IQueryFilterPolicy policy)
   at Genersoft.Platform.XForm.FormServer.FormDataAccessorByCustomParams.GetObjectsXml(String dataModelId, GSPFilter& filter, DataQueryType queryType, IQueryFilterPolicy policy, TransferState& transferState)
   at Genersoft.Platform.XForm.FormWebService.FormDataAccessService.GetObjectsXmlByPolicyWithParameters(BinaryReader reader, BinaryWriter writer)
内部异常
异常提示:执行分页数据查询发生错误,请查看扩展信息。错误信息:Conversion failed when converting date and/or time from character string.
异常信息:Conversion failed when converting date and/or time from character string.
导致错误的应用程序或对象的名称:.Net SqlClient Data Provider
引发当前异常的方法:
异常相关帮助:
堆栈信息:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Genersoft.Platform.Core.DataAccess.Database.GetDataSet(String dataSetTableName, String cmdText, IDbDataParameter[] dataParams, Boolean isSqlStatement)
   at Genersoft.Platform.Core.DataAccess.Database.RunProcGetDataSet(String dataSetTableName, String procName, IDbDataParameter[] dataParams, Int32[] resultNum)
   at Genersoft.Platform.Engine.DataAccess.DataOperator.GSPDataOperator.RunOldProcGetData(IGSPDatabase db, String dataSetTableName, String tables, String fields, String primaryKey, String condition, String orderBy, Int32 pageSize, Int32 pageIndex, String policyTables, Int32& totalCount, Int32& pageNumber)
   at Genersoft.Platform.Engine.DataAccess.DataOperator.GSPDataOperator.GetPaginationData(SelectSqlStatement sql, GSPFilter& filter, GSPDataAccessEngineContext daeContext)
内部异常:{}
扩展信息:
  数据访问引擎:
异常信息Conversion failed when converting date and/or time from character string.
执行数据库分页查询方法:
Table列表:ROBXDJ ROBXDJ JOIN LSZGZD LSZGZD ON ROBXDJ.ROBXDJ_YGNM = LSZGZD.LSZGZD_ID  LEFT OUTER JOIN HROrgDuty HRORGDUTY ON LSZGZD.HRZGZD_XRZW = HRORGDUTY.NM  JOIN LSBZDW LSBZDW ON ROBXDJ.ROBXDJ_DWBH = LSBZDW.LSBZDW_DWBH  JOIN ROBXLX ROBXLX ON ROBXDJ.ROBXDJ_BXLX = ROBXLX.ROBXLX_NM  JOIN LSBMZD LSBMZD ON ROBXDJ.ROBXDJ_DWBH = LSBMZD.LSBMZD_DWBH AND ROBXDJ.ROBXDJ_BMBH = LSBMZD.LSBMZD_BMBH  LEFT OUTER JOIN GSPUser GSPUSER ON LSBMZD.LSBMZD_BMFZR = GSPUSER.ID  JOIN LSWBZD LSWBZD ON ROBXDJ.ROBXDJ_BXHB = LSWBZD.LSWBZD_BZBH  LEFT OUTER JOIN ZWJSFS ZWJSFS ON ROBXDJ.ROBXDJ_YQFS = ZWJSFS.ZWJSFS_BH  LEFT OUTER JOIN ROFYXM ROFYXM ON ROBXDJ.ROBXDJ_FYXM = ROFYXM.ROFYXM_NM  LEFT OUTER JOIN ROZFFS ZFFS ON ROBXDJ.ROBXDJ_FKFS = ZFFS.ROZFFS_NM  LEFT OUTER JOIN ZWJSFS ZWJSFS1 ON ZFFS.ROZFFS_JSFS = ZWJSFS1.ZWJSFS_BH  JOIN ROYWZT ROYWZT ON ROBXDJ.ROBXDJ_ZT = ROYWZT.ROYWZT_ZT AND ROYWZT_YWLX='BX'  LEFT OUTER JOIN GSPUser GSPUSER1 ON ROBXDJ.ROBXDJ_USERID = GSPUSER1.ID  LEFT OUTER JOIN PROCESSINSTANCE PROCESSINSTANCE ON ROBXDJ.ROBXDJ_LCSL = PROCESSINSTANCE.PROCESSINSTANCEID  LEFT OUTER JOIN LSBZDW LSBZDW1 ON ROBXDJ.ROBXDJ_JZZZ = LSBZDW1.LSBZDW_DWBH  LEFT OUTER JOIN ROHBYG ROHBYG ON ROBXDJ.ROBXDJ_HBYGNM = ROHBYG.ROHBYG_NM  LEFT OUTER JOIN ROHBGX ROHBGX ON ROHBYG.ROHBYG_GXNM = ROHBGX.ROHBGX_NM  LEFT OUTER JOIN LSZGZD LSZGZD1 ON ROHBYG.ROHBYG_YGNM = LSZGZD1.LSZGZD_ID  LEFT OUTER JOIN FSYWLX FSYWLX ON ROBXDJ.ROBXDJ_YWLX = FSYWLX.FSYWLX_NM  JOIN  (SELECT DISTINCT AO_DATA FROM GSPAURESULT   WITH(NOLOCK) 
                      WHERE OWNERID = 'c8bfb99d-7f06-44b2-bac8-95560871534e' AND BIZOBJID = 'ROBXDJ' AND BIZOPID = '4270c8a4-6881-4145-a0ea-11edf55c34ad' AND AO_ID = 'DA_RO_LSBMZD'  )  AO_TBL_DA_RO_LSBMZD ON ROBXDJ.ROBXDJ_BMID = AO_TBL_DA_RO_LSBMZD.AO_DATA  JOIN  (SELECT DISTINCT AO_DATA FROM GSPAURESULT   WITH(NOLOCK) 
                      WHERE OWNERID = 'c8bfb99d-7f06-44b2-bac8-95560871534e' AND BIZOBJID = 'ROBXDJ' AND BIZOPID = '4270c8a4-6881-4145-a0ea-11edf55c34ad' AND AO_ID = 'DA_RO_LSBZDW'  )  AO_TBL_DA_RO_LSBZDW ON ROBXDJ.ROBXDJ_DWBH = AO_TBL_DA_RO_LSBZDW.AO_DATA
Field列表: ROBXDJ.ROBXDJ_NM AS "ROBXDJ_NM", ROBXDJ.ROBXDJ_YGNM AS "ROBXDJ_YGNM", ROBXDJ.ROBXDJ_RQ AS "ROBXDJ_RQ", ROBXDJ.ROBXDJ_DWBH AS "ROBXDJ_DWBH", ROBXDJ.ROBXDJ_BXLX AS "ROBXDJ_BXLX", ROBXDJ.ROBXDJ_BH AS "ROBXDJ_BH", ROBXDJ.ROBXDJ_ZY AS "ROBXDJ_ZY", ROBXDJ.ROBXDJ_BMID AS "ROBXDJ_BMID", ROBXDJ.ROBXDJ_BMBH AS "ROBXDJ_BMBH", ROBXDJ.ROBXDJ_BXJE AS "ROBXDJ_BXJE", ROBXDJ.ROBXDJ_BXHB AS "ROBXDJ_BXHB", ROBXDJ.ROBXDJ_YQFS AS "ROBXDJ_YQFS", ROBXDJ.ROBXDJ_CXJK AS "ROBXDJ_CXJK", ROBXDJ.ROBXDJ_FYXM AS "ROBXDJ_FYXM", ROBXDJ.ROBXDJ_XXSM AS "ROBXDJ_XXSM", ROBXDJ.ROBXDJ_LSBZ AS "ROBXDJ_LSBZ", ROBXDJ.ROBXDJ_FJZS AS "ROBXDJ_FJZS", ROBXDJ.ROBXDJ_HL AS "ROBXDJ_HL", ROBXDJ.ROBXDJ_JHJE AS "ROBXDJ_JHJE", ROBXDJ.ROBXDJ_JHWB AS "ROBXDJ_JHWB", ROBXDJ.ROBXDJ_BZJE AS "ROBXDJ_BZJE", ROBXDJ.ROBXDJ_BZWB AS "ROBXDJ_BZWB", ROBXDJ.ROBXDJ_SBJE AS "ROBXDJ_SBJE", ROBXDJ.ROBXDJ_HXJE AS "ROBXDJ_HXJE", ROBXDJ.ROBXDJ_HKJE AS "ROBXDJ_HKJE", ROBXDJ.ROBXDJ_SFJE AS "ROBXDJ_SFJE", ROBXDJ.ROBXDJ_FKFS AS "ROBXDJ_FKFS", ROBXDJ.ROBXDJ_JHSM AS "ROBXDJ_JHSM", ROBXDJ.ROBXDJ_SQNM AS "ROBXDJ_SQNM", ROBXDJ.ROBXDJ_FJBZ AS "ROBXDJ_FJBZ", ROBXDJ.ROBXDJ_ZT AS "ROBXDJ_ZT", ROBXDJ.ROBXDJ_BXQR AS "ROBXDJ_BXQR", ROBXDJ.ROBXDJ_SPFS AS "ROBXDJ_SPFS", ROBXDJ.ROBXDJ_USERID AS "ROBXDJ_USERID", ROBXDJ.ROBXDJ_FKHXRQ AS "ROBXDJ_FKHXRQ", ROBXDJ.ROBXDJ_USER AS "ROBXDJ_USER", ROBXDJ.ROBXDJ_SHR AS "ROBXDJ_SHR", ROBXDJ.ROBXDJ_SHRQ AS "ROBXDJ_SHRQ", ROBXDJ.ROBXDJ_SPRQ AS "ROBXDJ_SPRQ", ROBXDJ.ROBXDJ_JHR AS "ROBXDJ_JHR", ROBXDJ.ROBXDJ_JHRQ AS "ROBXDJ_JHRQ", ROBXDJ.ROBXDJ_FHR AS "ROBXDJ_FHR", ROBXDJ.ROBXDJ_FHRQ AS "ROBXDJ_FHRQ", ROBXDJ.ROBXDJ_FYRQ AS "ROBXDJ_FYRQ", ROBXDJ.ROBXDJ_DJSM AS "ROBXDJ_DJSM", ROBXDJ.ROBXDJ_DJBZ AS "ROBXDJ_DJBZ", ROBXDJ.ROBXDJ_QRJS AS "ROBXDJ_QRJS", ROBXDJ.ROBXDJ_JSSJ AS "ROBXDJ_JSSJ", ROBXDJ.ROBXDJ_CJSJ AS "ROBXDJ_CJSJ", ROBXDJ.ROBXDJ_XGSJ AS "ROBXDJ_XGSJ", ROBXDJ.ROBXDJ_PZNM AS "ROBXDJ_PZNM", ROBXDJ.ROBXDJ_GXM1 AS "ROBXDJ_GXM1", ROBXDJ.ROBXDJ_GXM2 AS "ROBXDJ_GXM2", ROBXDJ.ROBXDJ_GXM3 AS "ROBXDJ_GXM3", ROBXDJ.ROBXDJ_GXM4 AS "ROBXDJ_GXM4", ROBXDJ.ROBXDJ_GXM5 AS "ROBXDJ_GXM5", ROBXDJ.ROBXDJ_GNM1 AS "ROBXDJ_GNM1", ROBXDJ.ROBXDJ_GNM2 AS "ROBXDJ_GNM2", ROBXDJ.ROBXDJ_GNM3 AS "ROBXDJ_GNM3", ROBXDJ.ROBXDJ_GNM4 AS "ROBXDJ_GNM4", ROBXDJ.ROBXDJ_GNM5 AS "ROBXDJ_GNM5", ROBXDJ.ROBXDJ_GSZ1 AS "ROBXDJ_GSZ1", ROBXDJ.ROBXDJ_GSZ2 AS "ROBXDJ_GSZ2", ROBXDJ.ROBXDJ_GSZ3 AS "ROBXDJ_GSZ3", ROBXDJ.ROBXDJ_GRQ1 AS "ROBXDJ_GRQ1", ROBXDJ.ROBXDJ_GRQ2 AS "ROBXDJ_GRQ2", ROBXDJ.ROBXDJ_XM1 AS "ROBXDJ_XM1", ROBXDJ.ROBXDJ_XM2 AS "ROBXDJ_XM2", ROBXDJ.ROBXDJ_XM3 AS "ROBXDJ_XM3", ROBXDJ.ROBXDJ_XM4 AS "ROBXDJ_XM4", ROBXDJ.ROBXDJ_XM5 AS "ROBXDJ_XM5", ROBXDJ.ROBXDJ_XM6 AS "ROBXDJ_XM6", ROBXDJ.ROBXDJ_XM7 AS "ROBXDJ_XM7", ROBXDJ.ROBXDJ_XM8 AS "ROBXDJ_XM8", ROBXDJ.ROBXDJ_XM9 AS "ROBXDJ_XM9", ROBXDJ.ROBXDJ_XM10 AS "ROBXDJ_XM10", ROBXDJ.ROBXDJ_XM11 AS "ROBXDJ_XM11", ROBXDJ.ROBXDJ_XM12 AS "ROBXDJ_XM12", ROBXDJ.ROBXDJ_XM13 AS "ROBXDJ_XM13", ROBXDJ.ROBXDJ_XM14 AS "ROBXDJ_XM14", ROBXDJ.ROBXDJ_XM15 AS "ROBXDJ_XM15", ROBXDJ.ROBXDJ_XM16 AS "ROBXDJ_XM16", ROBXDJ.ROBXDJ_XM17 AS "ROBXDJ_XM17", ROBXDJ.ROBXDJ_XM18 AS "ROBXDJ_XM18", ROBXDJ.ROBXDJ_XM19 AS "ROBXDJ_XM19", ROBXDJ.ROBXDJ_XM20 AS "ROBXDJ_XM20", ROBXDJ.ROBXDJ_NM1 AS "ROBXDJ_NM1", ROBXDJ.ROBXDJ_NM2 AS "ROBXDJ_NM2", ROBXDJ.ROBXDJ_NM3 AS "ROBXDJ_NM3", ROBXDJ.ROBXDJ_NM4 AS "ROBXDJ_NM4", ROBXDJ.ROBXDJ_NM5 AS "ROBXDJ_NM5", ROBXDJ.ROBXDJ_NM6 AS "ROBXDJ_NM6", ROBXDJ.ROBXDJ_NM7 AS "ROBXDJ_NM7", ROBXDJ.ROBXDJ_NM8 AS "ROBXDJ_NM8", ROBXDJ.ROBXDJ_NM9 AS "ROBXDJ_NM9", ROBXDJ.ROBXDJ_NM10 AS "ROBXDJ_NM10", ROBXDJ.ROBXDJ_NM11 AS "ROBXDJ_NM11", ROBXDJ.ROBXDJ_NM12 AS "ROBXDJ_NM12", ROBXDJ.ROBXDJ_NM13 AS "ROBXDJ_NM13", ROBXDJ.ROBXDJ_NM14 AS "ROBXDJ_NM14", ROBXDJ.ROBXDJ_NM15 AS "ROBXDJ_NM15", ROBXDJ.ROBXDJ_NM16 AS "ROBXDJ_NM16", ROBXDJ.ROBXDJ_NM17 AS "ROBXDJ_NM17", ROBXDJ.ROBXDJ_NM18 AS "ROBXDJ_NM18", ROBXDJ.ROBXDJ_NM19 AS "ROBXDJ_NM19", ROBXDJ.ROBXDJ_LCSL AS "ROBXDJ_LCSL", ROBXDJ.ROBXDJ_NM20 AS "ROBXDJ_NM20", ROBXDJ.ROBXDJ_SZ1 AS "ROBXDJ_SZ1", ROBXDJ.ROBXDJ_SZ2 AS "ROBXDJ_SZ2", ROBXDJ.ROBXDJ_SZ3 AS "ROBXDJ_SZ3", ROBXDJ.ROBXDJ_SZ4 AS "ROBXDJ_SZ4", ROBXDJ.ROBXDJ_SZ5 AS "ROBXDJ_SZ5", ROBXDJ.ROBXDJ_SZ6 AS "ROBXDJ_SZ6", ROBXDJ.ROBXDJ_SZ7 AS "ROBXDJ_SZ7", ROBXDJ.ROBXDJ_SZ8 AS "ROBXDJ_SZ8", ROBXDJ.ROBXDJ_SZ9 AS "ROBXDJ_SZ9", ROBXDJ.ROBXDJ_SZ10 AS "ROBXDJ_SZ10", ROBXDJ.ROBXDJ_RQ1 AS "ROBXDJ_RQ1", ROBXDJ.ROBXDJ_RQ2 AS "ROBXDJ_RQ2", ROBXDJ.ROBXDJ_RQ3 AS "ROBXDJ_RQ3", ROBXDJ.ROBXDJ_RQ4 AS "ROBXDJ_RQ4", ROBXDJ.ROBXDJ_RQ5 AS "ROBXDJ_RQ5", ROBXDJ.ROBXDJ_BZ1 AS "ROBXDJ_BZ1", ROBXDJ.ROBXDJ_BE1 AS "ROBXDJ_BE1", ROBXDJ.ROBXDJ_BE2 AS "ROBXDJ_BE2", ROBXDJ.ROBXDJ_BE3 AS "ROBXDJ_BE3", ROBXDJ.ROBXDJ_BE4 AS "ROBXDJ_BE4", ROBXDJ.ROBXDJ_BE5 AS "ROBXDJ_BE5", ROBXDJ.ROBXDJ_ZS1 AS "ROBXDJ_ZS1", ROBXDJ.ROBXDJ_ZS2 AS "ROBXDJ_ZS2", ROBXDJ.ROBXDJ_ZS3 AS "ROBXDJ_ZS3", ROBXDJ.ROBXDJ_XGR AS "ROBXDJ_XGR", ROBXDJ.ROBXDJ_HTNM AS "ROBXDJ_HTNM", ROBXDJ.ROBXDJ_ZJJH AS "ROBXDJ_ZJJH", ROBXDJ.ROBXDJ_HTJHNM AS "ROBXDJ_HTJHNM", ROBXDJ.ROBXDJ_JZZZ AS "ROBXDJ_JZZZ", ROBXDJ.ROBXDJ_YSBZ AS "ROBXDJ_YSBZ", ROBXDJ.ROBXDJ_XEBZ AS "ROBXDJ_XEBZ", ROBXDJ.ROBXDJ_YXZT AS "ROBXDJ_YXZT", ROBXDJ.ROBXDJ_ZX1 AS "ROBXDJ_ZX1", ROBXDJ.ROBXDJ_ZX2 AS "ROBXDJ_ZX2", ROBXDJ.ROBXDJ_PRINTCOUNT AS "ROBXDJ_PRINTCOUNT", ROBXDJ.ROBXDJ_YSCXJE AS "ROBXDJ_YSCXJE", ROBXDJ.ROBXDJ_JSRID AS "ROBXDJ_JSRID", ROBXDJ.ROBXDJ_JSR AS "ROBXDJ_JSR", ROBXDJ.ROBXDJ_GZJE AS "ROBXDJ_GZJE", ROBXDJ.ROBXDJ_DJXM AS "ROBXDJ_DJXM", ROBXDJ.ROBXDJ_PRINTTIME AS "ROBXDJ_PRINTTIME", ROBXDJ.ROBXDJ_SZ11 AS "ROBXDJ_SZ11", ROBXDJ.ROBXDJ_SZ12 AS "ROBXDJ_SZ12", ROBXDJ.ROBXDJ_SZ13 AS "ROBXDJ_SZ13", ROBXDJ.ROBXDJ_SZ14 AS "ROBXDJ_SZ14", ROBXDJ.ROBXDJ_SZ15 AS "ROBXDJ_SZ15", ROBXDJ.ROBXDJ_SZ16 AS "ROBXDJ_SZ16", ROBXDJ.ROBXDJ_SZ17 AS "ROBXDJ_SZ17", ROBXDJ.ROBXDJ_SZ18 AS "ROBXDJ_SZ18", ROBXDJ.ROBXDJ_SZ19 AS "ROBXDJ_SZ19", ROBXDJ.ROBXDJ_SZ20 AS "ROBXDJ_SZ20", ROBXDJ.ROBXDJ_SZ21 AS "ROBXDJ_SZ21", ROBXDJ.ROBXDJ_SZ22 AS "ROBXDJ_SZ22", ROBXDJ.ROBXDJ_SZ23 AS "ROBXDJ_SZ23", ROBXDJ.ROBXDJ_SZ24 AS "ROBXDJ_SZ24", ROBXDJ.ROBXDJ_SZ25 AS "ROBXDJ_SZ25", ROBXDJ.ROBXDJ_YFJE AS "ROBXDJ_YFJE", ROBXDJ.ROBXDJ_IFZF AS "ROBXDJ_IFZF", ROBXDJ.ROBXDJ_QWRQ AS "ROBXDJ_QWRQ", ROBXDJ.ROBXDJ_JHDW AS "ROBXDJ_JHDW", ROBXDJ.ROBXDJ_SPGXNM AS "ROBXDJ_SPGXNM", ROBXDJ.ROBXDJ_BRQR AS "ROBXDJ_BRQR", ROBXDJ.ROBXDJ_SPRID01 AS "ROBXDJ_SPRID01", ROBXDJ.ROBXDJ_SPRID02 AS "ROBXDJ_SPRID02", ROBXDJ.ROBXDJ_SPRID03 AS "ROBXDJ_SPRID03", ROBXDJ.ROBXDJ_SPRID04 AS "ROBXDJ_SPRID04", ROBXDJ.ROBXDJ_SPRID05 AS "ROBXDJ_SPRID05", ROBXDJ.ROBXDJ_SPR01 AS "ROBXDJ_SPR01", ROBXDJ.ROBXDJ_SPR02 AS "ROBXDJ_SPR02", ROBXDJ.ROBXDJ_SPR03 AS "ROBXDJ_SPR03", ROBXDJ.ROBXDJ_SPR04 AS "ROBXDJ_SPR04", ROBXDJ.ROBXDJ_SPR05 AS "ROBXDJ_SPR05", ROBXDJ.ROBXDJ_SPSJ01 AS "ROBXDJ_SPSJ01", ROBXDJ.ROBXDJ_SPSJ02 AS "ROBXDJ_SPSJ02", ROBXDJ.ROBXDJ_SPSJ03 AS "ROBXDJ_SPSJ03", ROBXDJ.ROBXDJ_SPSJ04 AS "ROBXDJ_SPSJ04", ROBXDJ.ROBXDJ_SPSJ05 AS "ROBXDJ_SPSJ05", ROBXDJ.ROBXDJ_XJHKJE AS "ROBXDJ_XJHKJE", ROBXDJ.ROBXDJ_HBYGNM AS "ROBXDJ_HBYGNM", ROBXDJ.ROBXDJ_PZFLAG AS "ROBXDJ_PZFLAG", ROBXDJ.ROBXDJ_ZJJHKZJG AS "ROBXDJ_ZJJHKZJG", ROBXDJ.ROBXDJ_ZJJHKZXX AS "ROBXDJ_ZJJHKZXX", ROBXDJ.ROBXDJ_BZ2 AS "ROBXDJ_BZ2", ROBXDJ.ROBXDJ_BZ3 AS "ROBXDJ_BZ3", ROBXDJ.ROBXDJ_BZ4 AS "ROBXDJ_BZ4", ROBXDJ.ROBXDJ_NDLJBXJE AS "ROBXDJ_NDLJBXJE", ROBXDJ.ROBXDJ_YSFT AS "ROBXDJ_YSFT", ROBXDJ.ROBXDJ_PZBH AS "ROBXDJ_PZBH", ROBXDJ.ROBXDJ_PZINFO AS "ROBXDJ_PZINFO", ROBXDJ.ROBXDJ_YWLX AS "ROBXDJ_YWLX", ROBXDJ.ROBXDJ_RQ6 AS "ROBXDJ_RQ6", ROBXDJ.ROBXDJ_RQ7 AS "ROBXDJ_RQ7", ROBXDJ.ROBXDJ_RQ8 AS "ROBXDJ_RQ8", ROBXDJ.ROBXDJ_RQ9 AS "ROBXDJ_RQ9", ROBXDJ.ROBXDJ_RQ10 AS "ROBXDJ_RQ10", ROBXDJ.ROBXDJ_RQ11 AS "ROBXDJ_RQ11", ROBXDJ.ROBXDJ_RQ12 AS "ROBXDJ_RQ12", ROBXDJ.ROBXDJ_RQ13 AS "ROBXDJ_RQ13", ROBXDJ.ROBXDJ_RQ14 AS "ROBXDJ_RQ14", ROBXDJ.ROBXDJ_RQ15 AS "ROBXDJ_RQ15", ROBXDJ.ROBXDJ_YCXX AS "ROBXDJ_YCXX", ROBXDJ.ROBXDJ_SBYBJE AS "ROBXDJ_SBYBJE", ROBXDJ.ROBXDJ_SFBBJE AS "ROBXDJ_SFBBJE", ROBXDJ.ROBXDJ_HXBBJE AS "ROBXDJ_HXBBJE", ROBXDJ.ROBXDJ_GZYBJE AS "ROBXDJ_GZYBJE", ROBXDJ.ROBXDJ_YFYBJE AS "ROBXDJ_YFYBJE", ROBXDJ.ROBXDJ_XJHKBBJE AS "ROBXDJ_XJHKBBJE", ROBXDJ.ROBXDJ_HDSY AS "ROBXDJ_HDSY", ROBXDJ.ROBXDJ_SZ26 AS "ROBXDJ_SZ26", ROBXDJ.ROBXDJ_SZ27 AS "ROBXDJ_SZ27", ROBXDJ.ROBXDJ_SZ28 AS "ROBXDJ_SZ28", ROBXDJ.ROBXDJ_SZ29 AS "ROBXDJ_SZ29", ROBXDJ.ROBXDJ_SZ30 AS "ROBXDJ_SZ30", ROBXDJ.ROBXDJ_CSR AS "ROBXDJ_CSR", ROBXDJ.ROBXDJ_CSRQ AS "ROBXDJ_CSRQ", ROBXDJ.ROBXDJ_CSRID AS "ROBXDJ_CSRID", ROBXDJ.ROBXDJ_KJND AS "ROBXDJ_KJND", ROBXDJ.ROBXDJ_KJQJ AS "ROBXDJ_KJQJ", ROBXDJ.ROBXDJ_SQJE AS "ROBXDJ_SQJE", ROBXDJ.ROBXDJ_SE AS "ROBXDJ_SE", ROBXDJ.ROBXDJ_SL AS "ROBXDJ_SL", ROBXDJ.ROBXDJ_IFYX AS "ROBXDJ_IFYX", ROBXDJ.ROBXDJ_BXXYDJ AS "ROBXDJ_BXXYDJ", ROBXDJ.ROBXDJ_ZDXYDJ AS "ROBXDJ_ZDXYDJ", ROBXDJ.ROBXDJ_FSSC AS "ROBXDJ_FSSC", ROBXDJ.ROBXDJ_MJ AS "ROBXDJ_MJ", ROBXDJ.ROBXDJ_SignMessage AS "ROBXDJ_SignMessage", ROBXDJ.ROBXDJ_CerBase64String AS "ROBXDJ_CerBase64String", LSZGZD.LSZGZD_ID AS "ROBXDJ_YGNM_LSZGZD_ID", LSZGZD.LSZGZD_DWBH AS "ROBXDJ_YGNM_LSZGZD_DWBH", LSZGZD.LSZGZD_BMBH AS "ROBXDJ_YGNM_LSZGZD_BMBH", LSZGZD.LSZGZD_ZGBH AS "ROBXDJ_YGNM_LSZGZD_ZGBH", LSZGZD.LSZGZD_ZJM AS "ROBXDJ_YGNM_LSZGZD_ZJM", LSZGZD.LSZGZD_ZGXM AS "ROBXDJ_YGNM_LSZGZD_ZGXM", LSZGZD.LSZGZD_RYSX AS "ROBXDJ_YGNM_LSZGZD_RYSX", LSZGZD.LSZGZD_USERID AS "ROBXDJ_YGNM_LSZGZD_USERID", LSZGZD.LSZGZD_ZWBZ AS "ROBXDJ_YGNM_LSZGZD_ZWBZ", LSZGZD.LSZGZD_YGID AS "ROBXDJ_YGNM_LSZGZD_YGID", LSZGZD.HRZGZD_XRZW AS "ROBXDJ_YGNM_HRZGZD_XRZW", LSZGZD.LSZGZD_LXDH AS "ROBXDJ_YGNM_LSZGZD_LXDH", LSZGZD.LSZGZD_CustomFiled1 AS "ROBXDJ_YGNM_LSZGZD_CustomFiled", LSZGZD.LSZGZD_YGLB AS "ROBXDJ_YGNM_LSZGZD_YGLB", LSZGZD.LSZGZD_FZ47 AS "ROBXDJ_YGNM_LSZGZD_FZ47", LSZGZD.LSZGZD_FZ48 AS "ROBXDJ_YGNM_LSZGZD_FZ48", LSZGZD.LSZGZD_FZ49 AS "ROBXDJ_YGNM_LSZGZD_FZ49", LSZGZD.LSZGZD_FZ50 AS "ROBXDJ_YGNM_LSZGZD_FZ50", HRORGDUTY.DutyCode AS "ROBXDJ_YGNM_HRZGZD_XRZW_DutyCo", HRORGDUTY.DutyName AS "ROBXDJ_YGNM_HRZGZD_XRZW_DutyNa", LSBZDW.LSBZDW_DWMC AS "ROBXDJ_DWBH_LSBZDW_DWMC", LSBZDW.LSBZDW_SJGS AS "ROBXDJ_DWBH_LSBZDW_SJGS", ROBXLX.ROBXLX_BH AS "ROBXDJ_BXLX_ROBXLX_BH", ROBXLX.ROBXLX_MC AS "ROBXDJ_BXLX_ROBXLX_MC", LSBMZD.LSBMZD_BMMC AS "ROBXDJ_BMBH_LSBMZD_BMMC", LSBMZD.LSBMZD_SX AS "ROBXDJ_BMBH_LSBMZD_SX", LSBMZD.LSBMZD_BMFZR AS "ROBXDJ_BMBH_LSBMZD_BMFZR", LSBMZD.LSBMZD_BMFGLD AS "ROBXDJ_BMBH_LSBMZD_BMFGLD", LSBMZD.LSBMZD_FZLDID AS "ROBXDJ_BMBH_LSBMZD_FZLDID", GSPUSER.NAME AS "ROBXDJ_BMBH_LSBMZD_BMFZR_NAME", LSWBZD.LSWBZD_ID AS "ROBXDJ_BXHB_LSWBZD_ID", LSWBZD.LSWBZD_BZMC AS "ROBXDJ_BXHB_LSWBZD_BZMC", LSWBZD.LSWBZD_BZFH AS "ROBXDJ_BXHB_LSWBZD_BZFH", ZWJSFS.ZWJSFS_MC AS "ROBXDJ_YQFS_ZWJSFS_MC", ROFYXM.ROFYXM_ZJM AS "ROBXDJ_FYXM_ROFYXM_ZJM", ROFYXM.ROFYXM_MC AS "ROBXDJ_FYXM_ROFYXM_MC", ROFYXM.ROFYXM_NOTE AS "ROBXDJ_FYXM_ROFYXM_NOTE", ROFYXM.ROFYXM_QC AS "ROFYXM_QC", ZFFS.ROZFFS_NM AS "ROBXDJ_FKFS_ROZFFS_NM", ZFFS.ROZFFS_JSFS AS "ROBXDJ_FKFS_ROZFFS_JSFS", ZWJSFS1.ZWJSFS_MC AS "ROBXDJ_FKFS_ROZFFS_JSFS_ZWJSFS", ROYWZT.ROYWZT_ZTSM AS "ROBXDJ_ZT_ROYWZT_ZTSM", GSPUSER1.TelNumber AS "ROBXDJ_USERID_TelNumber", PROCESSINSTANCE.CURRENTACTIVITIES AS "ROBXDJ_LCSL_CURRENTACTIVITIES", PROCESSINSTANCE.CURRENTPARTICIPANTS AS "ROBXDJ_LCSL_CURRENTPARTICIPANT", LSBZDW1.LSBZDW_DWMC AS "ROBXDJ_JZZZ_LSBZDW_DWMC", ROHBYG.ROHBYG_GXNM AS "ROBXDJ_HBYGNM_ROHBYG_GXNM", ROHBYG.ROHBYG_SPLC AS "ROBXDJ_HBYGNM_ROHBYG_SPLC", ROHBGX.ROHBGX_MC AS "ROBXDJ_HBYGNM_ROHBYG_GXNM_ROHB", LSZGZD1.LSZGZD_ZGXM AS "ROBXDJ_HBYGNM_ROHBYG_YGNM_LSZG", FSYWLX.FSYWLX_BH AS "ROBXDJ_YWLX_FSYWLX_BH", FSYWLX.FSYWLX_MC AS "ROBXDJ_YWLX_FSYWLX_MC"
主键:ROBXDJ.ROBXDJ_NM
条件:(ROBXDJ.ROBXDJ_ZT = 6    )AND(ROBXDJ.ROBXDJ_FKHXRQ =cast('2018-12-21T00:00:00+08:00' as DateTime)  )
      排序:
        
异常信息:Conversion failed when converting date and/or time from character string.
导致错误的应用程序或对象的名称:.Net SqlClient Data Provider
引发当前异常的方法:Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
  异常相关帮助:
堆栈信息:   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Genersoft.Platform.Core.DataAccess.Database.GetDataSet(String dataSetTableName, String cmdText, IDbDataParameter[] dataParams, Boolean isSqlStatement)
   at Genersoft.Platform.Core.DataAccess.Database.RunProcGetDataSet(String dataSetTableName, String procName, IDbDataParameter[] dataParams, Int32[] resultNum)
   at Genersoft.Platform.Engine.DataAccess.DataOperator.GSPDataOperator.RunOldProcGetData(IGSPDatabase db, String dataSetTableName, String tables, String fields, String primaryKey, String condition, String orderBy, Int32 pageSize, Int32 pageIndex, String policyTables, Int32& totalCount, Int32& pageNumber)
   at Genersoft.Platform.Engine.DataAccess.DataOperator.GSPDataOperator.GetPaginationData(SelectSqlStatement sql, GSPFilter& filter, GSPDataAccessEngineContext daeContext)
 

操作步骤(如下):

 

1 个回答

登录后再回答