StoredProcedure spd = new StoredProcedure("PayMoneySearch");
spd.Command.AddParameter("@starttime", c.GetQueryStr(qList, "PudDate"));
spd.Command.AddParameter("@endtime", c.GetQueryStr(qList, "PudDate_2"));
spd.Command.AddParameter("@CusName", c.GetQueryStr(qList, "CusName"));
spd.Command.AddParameter("@flag", c.GetQueryStr(qList, "flag"));
spd.Command.AddParameter("@currentpage", query.pager.page);
spd.Command.AddParameter("@pagesize", query.pager.rows);
spd.Command.AddOutputParameter("@allpage");
spd.Command.AddOutputParameter("@sumcount");
spd.Execute();
int total = 0;
List<Model.ReceiveMoneySearch> list = spd.ExecuteTypedList<Model.ReceiveMoneySearch>();
Subsonic 执行存储过程
最新推荐文章于 2021-04-05 11:13:26 发布