Exemple #1
0
        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);
        }
Exemple #2
0
        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);
        }