AllPower.SQLSERVER/Content/CommonField.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

#region 程序集引用

using System;
using System.Collections.Generic;
using System.Collections;
using System.Text;
using System.Text.RegularExpressions;
using System.Data.SqlClient;
using System.Data;

using AllPower.IDAL.Content;
using AllPower.Common;
#endregion

#region 版权注释
/*----------------------------------------------------------------------------------------
// Copyright (C) 2010 华强北在线 
// 作者：吴岸标

// 创建日期：2010-06-22
// 功能描述：模型字段操作

----------------------------------------------------------------------------------------*/
#endregion

namespace AllPower.SQLServer.Content
{
    public class CommonField : AllPower.IDAL.Content.ICommonField
    {
        #region  获取数据库中数据表与表字段
        /// <summary>
        /// 获取数据库中数据表与表字段
        /// </summary>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public DataSet GetTableAndField(string tableName)
        {
            string selSQL;
            SqlParameter[] selParam;
            DataSet ds;

            selParam = new SqlParameter[]{new SqlParameter("@TableName", tableName)};
            selSQL = "SELECT [Name],[object_id] as ID FROM sys.tables order by [name] asc;SELECT [name] FROM sys.columns WHERE [object_id]=(select [object_id] from sys.tables where [name]=@TableName) order by [Name] asc";
            try
            {
                ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, selSQL, selParam);
            }
            catch
            {
                ds = null;
            }

            return ds;
        }
        #endregion

        #region 添加/更新
        /// <summary>
        ///  添加/更新
        /// </summary>