Git.Storage.DataAccess/Base/SequenceDataAccess.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

/*******************************************************************************
 * Copyright (C) Git Corporation. All rights reserved.
 *
 * Author: 代码工具自动生成
 * Create Date: 2015/10/08 11:42:17
 * Blog: www.baidu.com 
 * Copyright: 太数智能科技（上海）有限公司 
 * Description: Git.Framework
 * 
 * Revision History:
 * Date         Author               Description
 * 2015/10/08 11:42:17
*********************************************************************************/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Git.Framework.ORM;
using Git.Framework.MsSql;
using Git.Storage.Entity.Base;
using Git.Storage.IDataAccess.Base;
using Git.Framework.MsSql.DataAccess;

namespace Git.Storage.DataAccess.Base
{
    public partial class SequenceDataAccess : DbHelper<SequenceEntity>, ISequence
    {
        public SequenceDataAccess()
        {
        }

        /// <summary>
        /// 查询系统所有的自定义表信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetTables()
        {
            string sql = "select * from sysobjects where xtype='U'";
            DataCommand command = DataCommandManager.CreateCustomDataCommand("JooWMS", CommandType.Text, sql);
            DataSet ds = command.ExecuteDataSet();
            if (ds != null && ds.Tables.Count > 0)
            {
                return ds.Tables[0];
            }
            return null;
        }
    }
}