Example #1
0
        public DataSet GetTerSet(int pageIndex, int pageSize, string where)
        {
            SqlParameter[] para = { new SqlParameter("@tblName",   SqlDbType.VarChar, 255),
                                    new SqlParameter("@fldName",   SqlDbType.VarChar, 255),
                                    new SqlParameter("@PageSize",  SqlDbType.Int),
                                    new SqlParameter("@PageIndex", SqlDbType.Int),
                                    new SqlParameter("@IsReCount", SqlDbType.Bit),
                                    new SqlParameter("@OrderType", SqlDbType.Bit),
                                    new SqlParameter("@strWhere",  SqlDbType.VarChar, 1000) };
            para[0].Value = "KJ128N_TerTypeSet_Table";
            para[1].Value = "TerritorialSetID";
            para[2].Value = pageSize;
            para[3].Value = pageIndex;
            para[4].Value = 1;
            para[5].Value = 0;
            para[6].Value = where;

            return(areadal.GetTerSet(para));
        }