走进白龟

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] =1530565410) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1581884900') or link in(1581884900)) 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:e0649b4b-b9c4-40a4-a6c1-146bb201d735
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] =1530565410) and ( ([B_Common_Item].[readType] < 0)) And [B_Common_Item].[category] in(select link from [B_Common_Channel] where contains([channelFrontList], '1581884900') or link in(1581884900)) And [B_Common_Item].[WebsiteId] =1303112420 ','1',
在 Base.Data.ItemList.B_GetDataTableMain(String _sCommandText)
在 Base.Data.BaseDataList.B_GetContentMain(String _sCommandText)
在 Base.Data.ItemList.B_GetContentMain()
在 Base.Action.ItemList.C_GetContentMain()$

技术园地

• 常用农药外观鉴别法2016-10-10
• 无公害百合栽培技术介绍2016-10-10
• 油菜管理应结合苗情进行科学追肥2016-10-10

招贤纳士

• 区域销售经理2019-08-16
• 大区销售经理2019-08-16