protected void Button2_Click(object sender, EventArgs e) { //创建分页存储过程sp_page.sql int page = 1; int pageSize = 15; int count; CRL.ParameCollection c = new CRL.ParameCollection(); string where = " InterFaceUser='******'";//按标准 SQL 进行拼接 c.SetQueryCondition(where); c.SetQueryPageIndex((int)page); c.SetQueryPageSize(pageSize); var list = Code.ProductDataManage.Instance.QueryListByPage(c, out count); }
protected void Button2_Click(object sender, EventArgs e) { //创建分页存储过程sp_TablesPageNew.sql int page = 1; int pageSize = 15; int count; CRL.ParameCollection c = new CRL.ParameCollection(); string where = " InterFaceUser='******'";//按标准 SQL 进行拼接 c.SetQueryCondition(where); c.SetQueryPageIndex((int)page); c.SetQueryPageSize(pageSize); var list = Code.ProductDataManage.Instance.QueryListByPage(c, out count); }