Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 時間已到。在操作完成之前超時時間已過或服務器未響應。
select top 8 * FROM(SELECT row_number() over(order by B_Common_Item.indexOrder asc,B_Common_Item.id desc) as rownum, B_Common_Item.[id],B_Common_Item.[weight],B_Common_Item.[link],B_Common_Item.[visitCount],B_Common_Item.[author],B_Common_Item.[authorEdit],B_Common_Item.[authorExamine],B_Common_Item.[authorDelete],B_Common_Item.[pubDate],B_Common_Item.[lastEditDate],B_Common_Item.[lastExamineDate],B_Common_Item.[lastDeleteDate],B_Common_Item.[lastBuildDate],B_Common_Item.[category],B_Common_Item.[ipadsdress],B_Common_Item.[indexOrder],B_Common_Item.[type],B_Common_Item.[mail],B_Common_Item.[isLimit],B_Common_Item.[isNew],B_Common_Item.[isSale],B_Common_Item.[isHot],B_Common_Item.[isHome],B_Common_Item.[isExamine],B_Common_Item.[isDelete],B_Common_Item.[reply],B_Common_Item.[isvalid],B_Common_Item.[isLink],B_Common_Item.[isEnclosure],B_Common_Item.[roleReadTitle],B_Common_Item.[ReadChannel],B_Common_Item.[colleagues],B_Common_Item.[readuser],B_Common_Item.[isImage],B_Common_Item.[isDescription],B_Common_Item.[isContent],B_Common_Item.[isReply],B_Common_Item.[isValidation],B_Common_Item.[isFusion],B_Common_Item.[consumer],B_Common_Item.[special],B_Common_Item.[longitude],B_Common_Item.[latitude],B_Common_Item.[keyword],B_Common_Item.[price],B_Common_Item.[mapImage],B_Common_Item.[__iIsHttp],B_Common_Item.[__iOldLink],B_Common_Item.[source],B_Common_Item.[startlimit],B_Common_Item.[endLimit],B_Common_Item.[mimetype],B_Common_Item_content.action_count as praise,B_Common_Item_content.*,B_Common_Channel.[title] AS categoryTitle,B_Common_Channel.[hyperLink] AS categoryHyperLink,B_Common_Channel.[IsSubmit] AS categoryIsSubmit,B_Common_Channel.[image] AS categoryImage,B_Common_Channel.[description] AS categoryDescription,B_Common_Channel.[ReadType] as categoryReadType,B_Common_Channel.[RoleReadTitle] as categoryRoleReadTitle,B_Common_Channel.[channelFrontList],B_Common_Channel.[alias],B_Common_Channel.[endLimit] as categoryEndLimit,T.title as typeTitle,T.alias as typeAlias,U.longitude as authorLongitude,U.latitude as authorLatitude,U.username,UC.companyName as companyTitle,UC.companyTelephones as companyTelephones,UC.telephones as companymobiles,UC.Address as companyAddress,UC.hyperLink as companyHyperLink,UC.province as authorProvince,UC.title as authorTitle,W.link as websiteLink,W.host as website,W.title as websiteTitle,W.LookFor as websiteHost,B_Common_Item_content.reply_count as replyCount,(SELECT count(*) FROM [B_Common_Inquiry] AS [order] LEFT JOIN [B_Common_Inquiry_Content] AS [content] ON [content].[orderId]=[order].[link] WHERE [order].[isDelete]=-1 AND [order].[state]=3 AND [content].[itemid]=[B_Common_Item].[link]) as [sellcount],M.link as moduleLink,M.visittitle as visitTitle,M.title as moduleTitle from B_Common_Item INNER JOIN B_Common_Item_content ON B_Common_Item_Content.[link_join] = B_Common_Item.[link] LEFT JOIN B_Common_Channel ON B_Common_Item.[category] = B_Common_Channel.[link] LEFT JOIN A_Global_Module as M ON B_Common_Item.[moduleid] = M.[link] LEFT JOIN A_Global_Website as W ON M.[websiteId] = W.[link] LEFT JOIN A_Member_Users_Content as UC ON B_Common_Item.[author] = UC.[link_join] LEFT JOIN A_Member_Users as U ON B_Common_Item.[author] = U.[link] LEFT JOIN B_Common_Type as T ON B_Common_Item.[type] = T.[link] where 1=1 And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1298604060) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1599348900') or link in(1599348900)) And [B_Common_Item].[WebsiteId] =1303112420 ) as it where rownum > 0 order by rownum asc ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作過時。
在 System.Data.SqlClient.SqlConnection.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)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
在 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)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText)
ClientConnectionId:8a768eac-0e18-4d4a-bdf3-33b3b8b95de1
Error Number:-2,State:0,Class:11
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText):exec ItemList 'B_Common_Channel','B_Common_Item',0,0,0,1,8,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1298604060) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1599348900') or link in(1599348900)) And [B_Common_Item].[WebsiteId] =1303112420 ',
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText)
在 Base.Data.BaseDataList.B_GetContentMain(String _sCommandText)
在 Base.Data.ItemList.B_GetContentMain()
在 Base.Action.ItemList.C_GetContentMain()$
版權所有: 綿陽香蕉视频app无限观看次数账号機械股份有限公司
友情鏈接 Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 時間已到。在操作完成之前超時時間已過或服務器未響應。
select top 8 B_Common_Item.[id],B_Common_Item.[weight],B_Common_Item.[link],B_Common_Item.[visitCount],B_Common_Item.[author],B_Common_Item.[authorEdit],B_Common_Item.[authorExamine],B_Common_Item.[authorDelete],B_Common_Item.[pubDate],B_Common_Item.[lastEditDate],B_Common_Item.[lastExamineDate],B_Common_Item.[lastDeleteDate],B_Common_Item.[lastBuildDate],B_Common_Item.[category],B_Common_Item.[ipadsdress],B_Common_Item.[indexOrder],B_Common_Item.[type],B_Common_Item.[mail],B_Common_Item.[isLimit],B_Common_Item.[isNew],B_Common_Item.[isSale],B_Common_Item.[isHot],B_Common_Item.[isHome],B_Common_Item.[isExamine],B_Common_Item.[isDelete],B_Common_Item.[reply],B_Common_Item.[isvalid],B_Common_Item.[isLink],B_Common_Item.[isEnclosure],B_Common_Item.[roleReadTitle],B_Common_Item.[ReadChannel],B_Common_Item.[colleagues],B_Common_Item.[readuser],B_Common_Item.[isImage],B_Common_Item.[isDescription],B_Common_Item.[isContent],B_Common_Item.[isReply],B_Common_Item.[isValidation],B_Common_Item.[isFusion],B_Common_Item.[consumer],B_Common_Item.[special],B_Common_Item.[longitude],B_Common_Item.[latitude],B_Common_Item.[keyword],B_Common_Item.[price],B_Common_Item.[mapImage],B_Common_Item.[__iIsHttp],B_Common_Item.[__iOldLink],B_Common_Item.[source],B_Common_Item.[startlimit],B_Common_Item.[endLimit],B_Common_Item.[mimetype],B_Common_Item_content.action_count as praise,B_Common_Item_content.*,B_Common_Channel.[title] AS categoryTitle,B_Common_Channel.[hyperLink] AS categoryHyperLink,B_Common_Channel.[IsSubmit] AS categoryIsSubmit,B_Common_Channel.[image] AS categoryImage,B_Common_Channel.[description] AS categoryDescription,B_Common_Channel.[ReadType] as categoryReadType,B_Common_Channel.[RoleReadTitle] as categoryRoleReadTitle,B_Common_Channel.[channelFrontList],B_Common_Channel.[alias],B_Common_Channel.[endLimit] as categoryEndLimit,T.title as typeTitle,T.alias as typeAlias,U.longitude as authorLongitude,U.latitude as authorLatitude,U.username,UC.companyName as companyTitle,UC.companyTelephones as companyTelephones,UC.telephones as companymobiles,UC.Address as companyAddress,UC.hyperLink as companyHyperLink,UC.province as authorProvince,UC.title as authorTitle,W.link as websiteLink,W.host as website,W.title as websiteTitle,W.LookFor as websiteHost,B_Common_Item_content.reply_count as replyCount,(SELECT count(*) FROM [B_Common_Inquiry] AS [order] LEFT JOIN [B_Common_Inquiry_Content] AS [content] ON [content].[orderId]=[order].[link] WHERE [order].[isDelete]=-1 AND [order].[state]=3 AND [content].[itemid]=[B_Common_Item].[link]) as [sellcount],M.link as moduleLink,M.visittitle as visitTitle,M.title as moduleTitle from B_Common_Item INNER JOIN B_Common_Item_content ON B_Common_Item_Content.[link_join] = B_Common_Item.[link] LEFT JOIN B_Common_Channel ON B_Common_Item.[category] = B_Common_Channel.[link] LEFT JOIN A_Global_Module as M ON B_Common_Item.[moduleid] = M.[link] LEFT JOIN A_Global_Website as W ON M.[websiteId] = W.[link] LEFT JOIN A_Member_Users_Content as UC ON B_Common_Item.[author] = UC.[link_join] LEFT JOIN A_Member_Users as U ON B_Common_Item.[author] = U.[link] LEFT JOIN B_Common_Type as T ON B_Common_Item.[type] = T.[link] where 1=1 And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1298604060) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[moduleId] =1131674810 And [B_Common_Item].[WebsiteId] =1303112420 And [B_Common_Item].[channelId] = 1587514670 order by B_Common_Item.indexOrder asc, B_Common_Item.id desc ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作過時。
在 System.Data.SqlClient.SqlConnection.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)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
在 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)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText)
ClientConnectionId:8a768eac-0e18-4d4a-bdf3-33b3b8b95de1
Error Number:-2,State:0,Class:11
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText):exec ItemList 'B_Common_Channel','B_Common_Item',8,0,0,1,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1298604060) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[moduleId] =1131674810 And [B_Common_Item].[WebsiteId] =1303112420 And [B_Common_Item].[channelId] = 1587514670',
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText)
在 Base.Data.BaseDataList.B_GetContentMain(String _sCommandText)
在 Base.Data.ItemList.B_GetContentMain()
在 Base.Action.ItemList.C_GetContentMain()$
地址: 四川省綿陽市高新區菩提寺岷山機電園 電話: 0816-2533367