注册登录
  • Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1557796230') or link in(1557796230)) 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:606599dd-e8d3-4454-b150-ce8a4b79e71f
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1557796230') or link in(1557796230)) 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()$
  • Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1546229280') or link in(1546229280)) 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:606599dd-e8d3-4454-b150-ce8a4b79e71f
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1546229280') or link in(1546229280)) 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()$
  • 卤肉
  • 酱肉
  • 其他
    Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1512732760') or link in(1512732760)) 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:606599dd-e8d3-4454-b150-ce8a4b79e71f
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1512732760') or link in(1512732760)) 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()$
    Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1535843110') or link in(1535843110)) 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:606599dd-e8d3-4454-b150-ce8a4b79e71f
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1535843110') or link in(1535843110)) 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()$
    Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。 ---> System.ComponentModel.Win32Exception (0x80004005): 等待的操作过时。
    在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
    在 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
    在 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
    在 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
    在 System.Data.SqlClient.TdsParserStateObject.TryReadByteArray(Byte[] buff, Int32 offset, Int32 len, Int32& totalRead)
    在 System.Data.SqlClient.TdsParserStateObject.TryReadString(Int32 length, String& value)
    在 System.Data.SqlClient.TdsParser.TryProcessError(Byte token, TdsParserStateObject stateObj, SqlError& error)
    在 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:606599dd-e8d3-4454-b150-ce8a4b79e71f
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1576730590') or link in(1576730590)) 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()$
MORE +
    Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1512629600') or link in(1512629600)) 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:4956cd62-0274-4a55-ba64-e31a4255fbf8
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1512629600') or link in(1512629600)) 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()$
MORE +
  • 行业动态
  • 企业新闻
    Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1508252800') or link in(1508252800)) 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:4956cd62-0274-4a55-ba64-e31a4255fbf8
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1508252800') or link in(1508252800)) 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()$
    Base.Action.ItemList err:err:System.Exception: System.SystemException: System.Data.SqlClient.SqlException (0x80131904): Timeout 时间已到。在操作完成之前超时时间已过或服务器未响应。
    select top 50 * 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.[ipAddress],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.companyTelephone as companyTelephone,UC.telephone as companyMobile,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] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1503113220') or link in(1503113220)) 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:4956cd62-0274-4a55-ba64-e31a4255fbf8
    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,50,'',' And [B_Common_Item].[isExamine] = 1 And [B_Common_Item].[isDelete] = -1 And [B_Common_Item].[reply] < 1 And([B_Common_Item].[consumer] =1587974480) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1503113220') or link in(1503113220)) 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()$
MORE +
公司产品自投入市场以来，深受广大消费者的好评。我公司始终坚持“质量第一、信誉至上”的原则，对原材料的购进、精选、加工、检验、包装到成品出厂等环节均进行严格的监控。科学的管理使产品质量得到了保障，各项指标均达到国家标准。 友情提示：加盟有风险，投资需谨慎！
MORE +

    • 陕西尚元农牧科技发展有限公司

    地  址：陕西省咸阳市三原县陵前镇北街

    邮  编：710000

    联系电话：029-32391066

    手  机：13992898886

    邮  箱：shangysp@126.com

    网  址：www.sxsynmu.cn

    Copyright © 2016    版权所有    陕西尚元农牧科技发展有限公司    陕ICP备16013028号      陕公网安备 61042202000120号