数据库查询和页面显示不一样的结果

[color=#0000FF]set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
Create PROCEDURE [dbo].[BranchStatistic_GetByAll] --获取网点统计运费
@branchname varchar(50)='',
@startdate varchar(50)='',
@enddate varchar(50)='',
@branchcode varchar(50)='',
@usertype int
AS
SET NOCOUNT ON
declare @mssql nvarchar(4000)
if (@usertype=0)

set @mssql='Select Branchs.BranchCode,Branchs.BranchName
    ,Income = ISNULL(sum(Orders.PSettleAmount),0)
        ,Outcome = ISNULL(sum(Orders.ISettleAmount),0)
from Branchs
left join Orders on Orders.StartBranchCode = Branchs.BranchCode where 1 = 1'
else

set @mssql='Select Branchs.BranchCode,Branchs.BranchName
    ,Income = ISNULL(sum(Orders.PSettleAmount),0)
        ,Outcome = ISNULL(sum(Orders.ISettleAmount),0)
from Branchs
left join Orders on Orders.StartBranchCode = Branchs.BranchCode and StartBranchCode = '''+ @branchcode+ '''where 1 = 1'

if(len(@branchname) > 0)
begin
   set @mssql=@mssql+' and Branchs.BranchName like ''%'+@branchname+'%'''
end

if(len(@startdate)>0)
begin
    set @mssql=@mssql+' and Orders.CreateTime>='''+@startdate+''''
end

if(len(@enddate)>0)
begin
    set @mssql=@mssql+' and Orders.CreateTime<='''+@enddate+''''
end
set  @mssql=@mssql + 'Group by Branchs.BranchCode,BranchName'

exec sp_executesql @mssql
    SET NOCOUNT OFF

select Branchs.BranchCode,Branchs.BranchName
    ,Income = ISNULL(sum(Orders.PSettleAmount),0)
        ,Outcome = ISNULL(sum(Orders.ISettleAmount),0)
from Branchs
left join Orders on Orders.StartBranchCode = Branchs.BranchCode
where 1 = 1

Group by Branchs.BranchCode,BranchName