Esempio n. 1
0
        public DataSet GetDataSetByPage(string FieldList, string SearchCondition, string orderStr, int PageIndex, int PageSize)
        {
            DataSet ds = null;

            try
            {
                if (SearchCondition.Length > 0)
                {
                    SearchCondition = " WHERE " + SearchCondition;
                }

                using (CommonDal Access = new CommonDal(_dct))
                {
                    ds = Access.GetPageDataByParameterizedSql(model.paramList, SMSCheckSystemListModel.TableName, FieldList, SearchCondition,
                                                              orderStr, PageIndex, PageSize);
                }
            }
            catch (Exception ex)
            {
                ds = null;
                this._infomation = ex.Message;
            }

            return(ds);
        }