c#通过存储过程 out参数输出正常数据和count

ALTER proc sp_loadlist
    (
    @pageIndexStart int ,
    @pageIndexEnd int,
    @total  int out
    )
as 

select [ID] ,[title] ,[content] ,[type]  ,[Date]  ,[people] ,[picUrl] from (select row_number()over(order by id)rownumber,* from [HKSJ_Main])a where rownumber between @pageIndexStart and @pageIndexEnd

SELECT @total =COUNT (1) from [HKSJ_Main]

int total = 0;
MainInfoService mainList = new MainInfoService();

//获取modellist
MainListData = mainList.GetModelListByPage(pageIndexStart, pageIndexEnd,out total);

//同时获取数据条数
int allCount = total;

public static List<MainInfo> GetModelListByPageDal(int pageIndexStart, int pageIndexEnd, out int total)
        {
            DataTable dt = new DataTable();
            List<MainInfo> mainInfoList = new List<MainInfo>();
            
            //设定为输出参数
            SqlParameter totalParameter = new SqlParameter("@total", SqlDbType.Int);
            totalParameter.Direction = ParameterDirection.Output;

            SqlParameter[] parm = new SqlParameter[]{
                new SqlParameter("@pageIndexStart",pageIndexStart),
                new SqlParameter("@pageIndexEnd",pageIndexEnd), 
                totalParameter
             };
             
            dt= SqlHelper.ExecuteDataTable("sp_loadlist", System.Data.CommandType.StoredProcedure, parm);

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                MainInfo mainItem = new MainInfo();
                mainItem.ID=int.Parse( dt.Rows[i]["ID"].ToString());
                mainItem.Title = dt.Rows[i]["title"].ToString();
                mainItem.Content = dt.Rows[i]["content"].ToString();
                mainItem.type = dt.Rows[i]["type"].ToString();
                mainItem.Date = (DateTime)dt.Rows[i]["date"];
                mainItem.People = dt.Rows[i]["people"].ToString();
                mainInfoList.Add(mainItem);
            }
            //获取输出参数值
            total =(int) totalParameter.Value;
            return mainInfoList;
        }