2025-12-02 15:36:44 执行时长：5.22秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 快递登记.ID as [~ID~] ,[寄组织名称_组织信息].CorpName AS [寄组织名称],[寄合作方_合作单位].PartnerName AS [寄合作方],快递登记.[ExpressNo] AS [快递单号],快递登记.[SendOn] AS [邮寄日期],[寄件人_用户].UserName AS [寄件人],[合同来源_组织机构].OrgName AS [合同来源],快递登记.[Express] AS [快递公司],快递登记.[UpdateOn] AS [修改时间] FROM GB_Express 快递登记 WITH(NOLOCK)  LEFT JOIN GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID WHERE  1=1  ',@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 GB_Corp [寄组织名称_组织信息] WITH(NOLOCK) ON 快递登记.CorpName = [寄组织名称_组织信息].CorpID LEFT JOIN GB_Partner [寄合作方_合作单位] WITH(NOLOCK) ON 快递登记.PartnerID = [寄合作方_合作单位].PartnerID LEFT JOIN Base_User [寄件人_用户] WITH(NOLOCK) ON 快递登记.SendBy = [寄件人_用户].UserID LEFT JOIN Base_Org [合同来源_组织机构] WITH(NOLOCK) ON 快递登记.Org = [合同来源_组织机构].OrgID WHERE  1=1 '

2025-12-02 15:36:45 执行时长：8.37秒 sql:exec [GB_AuditorSchedule] '2025-10-26','2025-11-25','','','','','123','','liudajun'