2025-09-22 14:08:04 执行时长：7.23秒 sql:exec [GB_PartnerCertiStatistics]

2025-09-22 14:08:04 执行时长：7.7秒 sql:exec [GB_PartnerCertiStatistics]

2025-09-22 14:56:30 执行时长：12.3秒 sql:select count(*) from ( SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org ='0001'  or [快递登记].org ='01'  or [快递登记].org ='02'  or [快递登记].org ='03'  or [快递登记].org ='04'  or [快递登记].org ='05'  or [快递登记].org ='20'  or [快递登记].org ='21'  or [快递登记].org ='2101'  or [快递登记].org ='2102'  or [快递登记].org ='2103'  or [快递登记].org ='22'  or [快递登记].org ='23'  or [快递登记].org ='25'  or [快递登记].org ='2501'  or [快递登记].org ='26'  or [快递登记].org ='27'  or [快递登记].org ='29'  or [快递登记].org ='30'  or [快递登记].org ='301'  or [快递登记].org ='302'  or [快递登记].org ='303'  or [快递登记].org ='304'  or [快递登记].org ='305'  or [快递登记].org ='306'  or [快递登记].org ='307'  or [快递登记].org ='308'  or [快递登记].org ='309'  or [快递登记].org ='31'  or [快递登记].org ='310'  or [快递登记].org ='311'  or [快递登记].org ='312'  or [快递登记].org ='313'  or [快递登记].org ='315'  or [快递登记].org ='316'  or [快递登记].org ='32'  or [快递登记].org ='40'  or [快递登记].org ='41'  or [快递登记].org ='42'  or [快递登记].org ='43'  or [快递登记].org ='4301'  or [快递登记].org ='4302'  or [快递登记].org ='4303'  or [快递登记].org ='44'  or [快递登记].org ='45'  or [快递登记].org ='46'  or [快递登记].org ='48'  or [快递登记].org ='49'  or [快递登记].org ='50' ) ) as CurrentCount

2025-09-22 14:56:31 执行时长：13.75秒 sql:select count(*) from ( SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org ='0001'  or [快递登记].org ='01'  or [快递登记].org ='02'  or [快递登记].org ='03'  or [快递登记].org ='04'  or [快递登记].org ='05'  or [快递登记].org ='20'  or [快递登记].org ='21'  or [快递登记].org ='2101'  or [快递登记].org ='2102'  or [快递登记].org ='2103'  or [快递登记].org ='22'  or [快递登记].org ='23'  or [快递登记].org ='25'  or [快递登记].org ='2501'  or [快递登记].org ='26'  or [快递登记].org ='27'  or [快递登记].org ='29'  or [快递登记].org ='30'  or [快递登记].org ='301'  or [快递登记].org ='302'  or [快递登记].org ='303'  or [快递登记].org ='304'  or [快递登记].org ='305'  or [快递登记].org ='306'  or [快递登记].org ='307'  or [快递登记].org ='308'  or [快递登记].org ='309'  or [快递登记].org ='31'  or [快递登记].org ='310'  or [快递登记].org ='311'  or [快递登记].org ='312'  or [快递登记].org ='313'  or [快递登记].org ='315'  or [快递登记].org ='316'  or [快递登记].org ='32'  or [快递登记].org ='40'  or [快递登记].org ='41'  or [快递登记].org ='42'  or [快递登记].org ='43'  or [快递登记].org ='4301'  or [快递登记].org ='4302'  or [快递登记].org ='4303'  or [快递登记].org ='44'  or [快递登记].org ='45'  or [快递登记].org ='46'  or [快递登记].org ='48'  or [快递登记].org ='49'  or [快递登记].org ='50' ) ) as CurrentCount

2025-09-22 14:56:32 执行时长：13.16秒 sql:select count(*) from ( SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org ='0001'  or [快递登记].org ='01'  or [快递登记].org ='02'  or [快递登记].org ='03'  or [快递登记].org ='04'  or [快递登记].org ='05'  or [快递登记].org ='20'  or [快递登记].org ='21'  or [快递登记].org ='2101'  or [快递登记].org ='2102'  or [快递登记].org ='2103'  or [快递登记].org ='22'  or [快递登记].org ='23'  or [快递登记].org ='25'  or [快递登记].org ='2501'  or [快递登记].org ='26'  or [快递登记].org ='27'  or [快递登记].org ='29'  or [快递登记].org ='30'  or [快递登记].org ='301'  or [快递登记].org ='302'  or [快递登记].org ='303'  or [快递登记].org ='304'  or [快递登记].org ='305'  or [快递登记].org ='306'  or [快递登记].org ='307'  or [快递登记].org ='308'  or [快递登记].org ='309'  or [快递登记].org ='31'  or [快递登记].org ='310'  or [快递登记].org ='311'  or [快递登记].org ='312'  or [快递登记].org ='313'  or [快递登记].org ='315'  or [快递登记].org ='316'  or [快递登记].org ='32'  or [快递登记].org ='40'  or [快递登记].org ='41'  or [快递登记].org ='42'  or [快递登记].org ='43'  or [快递登记].org ='4301'  or [快递登记].org ='4302'  or [快递登记].org ='4303'  or [快递登记].org ='44'  or [快递登记].org ='45'  or [快递登记].org ='46'  or [快递登记].org ='48'  or [快递登记].org ='49'  or [快递登记].org ='50' ) ) as CurrentCount

2025-09-22 14:56:33 执行时长：13.75秒 sql:select count(*) from ( SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org ='0001'  or [快递登记].org ='01'  or [快递登记].org ='02'  or [快递登记].org ='03'  or [快递登记].org ='04'  or [快递登记].org ='05'  or [快递登记].org ='20'  or [快递登记].org ='21'  or [快递登记].org ='2101'  or [快递登记].org ='2102'  or [快递登记].org ='2103'  or [快递登记].org ='22'  or [快递登记].org ='23'  or [快递登记].org ='25'  or [快递登记].org ='2501'  or [快递登记].org ='26'  or [快递登记].org ='27'  or [快递登记].org ='29'  or [快递登记].org ='30'  or [快递登记].org ='301'  or [快递登记].org ='302'  or [快递登记].org ='303'  or [快递登记].org ='304'  or [快递登记].org ='305'  or [快递登记].org ='306'  or [快递登记].org ='307'  or [快递登记].org ='308'  or [快递登记].org ='309'  or [快递登记].org ='31'  or [快递登记].org ='310'  or [快递登记].org ='311'  or [快递登记].org ='312'  or [快递登记].org ='313'  or [快递登记].org ='315'  or [快递登记].org ='316'  or [快递登记].org ='32'  or [快递登记].org ='40'  or [快递登记].org ='41'  or [快递登记].org ='42'  or [快递登记].org ='43'  or [快递登记].org ='4301'  or [快递登记].org ='4302'  or [快递登记].org ='4303'  or [快递登记].org ='44'  or [快递登记].org ='45'  or [快递登记].org ='46'  or [快递登记].org ='48'  or [快递登记].org ='49'  or [快递登记].org ='50' ) ) as CurrentCount

2025-09-22 14:56:36 执行时长：16.94秒 sql:select count(*) from ( SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org ='0001'  or [快递登记].org ='01'  or [快递登记].org ='02'  or [快递登记].org ='03'  or [快递登记].org ='04'  or [快递登记].org ='05'  or [快递登记].org ='20'  or [快递登记].org ='21'  or [快递登记].org ='2101'  or [快递登记].org ='2102'  or [快递登记].org ='2103'  or [快递登记].org ='22'  or [快递登记].org ='23'  or [快递登记].org ='25'  or [快递登记].org ='2501'  or [快递登记].org ='26'  or [快递登记].org ='27'  or [快递登记].org ='29'  or [快递登记].org ='30'  or [快递登记].org ='301'  or [快递登记].org ='302'  or [快递登记].org ='303'  or [快递登记].org ='304'  or [快递登记].org ='305'  or [快递登记].org ='306'  or [快递登记].org ='307'  or [快递登记].org ='308'  or [快递登记].org ='309'  or [快递登记].org ='31'  or [快递登记].org ='310'  or [快递登记].org ='311'  or [快递登记].org ='312'  or [快递登记].org ='313'  or [快递登记].org ='315'  or [快递登记].org ='316'  or [快递登记].org ='32'  or [快递登记].org ='40'  or [快递登记].org ='41'  or [快递登记].org ='42'  or [快递登记].org ='43'  or [快递登记].org ='4301'  or [快递登记].org ='4302'  or [快递登记].org ='4303'  or [快递登记].org ='44'  or [快递登记].org ='45'  or [快递登记].org ='46'  or [快递登记].org ='48'  or [快递登记].org ='49'  or [快递登记].org ='50' ) ) as CurrentCount

2025-09-22 14:56:42 执行时长：19.14秒 sql:select count(*) from ( SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org ='0001'  or [快递登记].org ='01'  or [快递登记].org ='02'  or [快递登记].org ='03'  or [快递登记].org ='04'  or [快递登记].org ='05'  or [快递登记].org ='20'  or [快递登记].org ='21'  or [快递登记].org ='2101'  or [快递登记].org ='2102'  or [快递登记].org ='2103'  or [快递登记].org ='22'  or [快递登记].org ='23'  or [快递登记].org ='25'  or [快递登记].org ='2501'  or [快递登记].org ='26'  or [快递登记].org ='27'  or [快递登记].org ='29'  or [快递登记].org ='30'  or [快递登记].org ='301'  or [快递登记].org ='302'  or [快递登记].org ='303'  or [快递登记].org ='304'  or [快递登记].org ='305'  or [快递登记].org ='306'  or [快递登记].org ='307'  or [快递登记].org ='308'  or [快递登记].org ='309'  or [快递登记].org ='31'  or [快递登记].org ='310'  or [快递登记].org ='311'  or [快递登记].org ='312'  or [快递登记].org ='313'  or [快递登记].org ='315'  or [快递登记].org ='316'  or [快递登记].org ='32'  or [快递登记].org ='40'  or [快递登记].org ='41'  or [快递登记].org ='42'  or [快递登记].org ='43'  or [快递登记].org ='4301'  or [快递登记].org ='4302'  or [快递登记].org ='4303'  or [快递登记].org ='44'  or [快递登记].org ='45'  or [快递登记].org ='46'  or [快递登记].org ='48'  or [快递登记].org ='49'  or [快递登记].org ='50' ) ) as CurrentCount

2025-09-22 14:56:47 执行时长：15.43秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[邮寄日期] DESC',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' )'

2025-09-22 14:56:48 执行时长：14.95秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[邮寄日期] DESC',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' )'

2025-09-22 14:56:48 执行时长：26.97秒 sql:exec [GB_AuditorSchedule] '2025-09-01','','','','','','123','0.5','ISC0042'

2025-09-22 14:56:48 执行时长：18.67秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[邮寄日期] DESC',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' )'

2025-09-22 14:56:49 执行时长：17.8秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[邮寄日期] DESC',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' )'

2025-09-22 14:56:51 执行时长：14.44秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[邮寄日期] DESC',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' )'

2025-09-22 14:56:51 执行时长：9.31秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[Express] AS [快递公司],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[Remark] AS [备注],快递登记.[Createby] AS [创建者],快递登记.[CreateOn] AS [创建时间],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' ) ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC,[邮寄日期] DESC',@OnlyID = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,快递登记.[UpdateOn] AS [修改时间],快递登记.[SendOn] AS [邮寄日期] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID WHERE ( [快递登记].org =''0001''  or [快递登记].org =''01''  or [快递登记].org =''02''  or [快递登记].org =''03''  or [快递登记].org =''04''  or [快递登记].org =''05''  or [快递登记].org =''20''  or [快递登记].org =''21''  or [快递登记].org =''2101''  or [快递登记].org =''2102''  or [快递登记].org =''2103''  or [快递登记].org =''22''  or [快递登记].org =''23''  or [快递登记].org =''25''  or [快递登记].org =''2501''  or [快递登记].org =''26''  or [快递登记].org =''27''  or [快递登记].org =''29''  or [快递登记].org =''30''  or [快递登记].org =''301''  or [快递登记].org =''302''  or [快递登记].org =''303''  or [快递登记].org =''304''  or [快递登记].org =''305''  or [快递登记].org =''306''  or [快递登记].org =''307''  or [快递登记].org =''308''  or [快递登记].org =''309''  or [快递登记].org =''31''  or [快递登记].org =''310''  or [快递登记].org =''311''  or [快递登记].org =''312''  or [快递登记].org =''313''  or [快递登记].org =''315''  or [快递登记].org =''316''  or [快递登记].org =''32''  or [快递登记].org =''40''  or [快递登记].org =''41''  or [快递登记].org =''42''  or [快递登记].org =''43''  or [快递登记].org =''4301''  or [快递登记].org =''4302''  or [快递登记].org =''4303''  or [快递登记].org =''44''  or [快递登记].org =''45''  or [快递登记].org =''46''  or [快递登记].org =''48''  or [快递登记].org =''49''  or [快递登记].org =''50'' )'