App_Code/DB/Market/DataMarketOracle.cs

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

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

using System;
using System.Collections;
using System.Data;

using System.Data.OracleClient;
using System.Windows.Forms;


sealed class DataMarketOracle : DataMarketInterface
{
    private DBOper<OracleCreator> db = new DBOper<OracleCreator>();

    /// <summary>
    /// 存储数据库信息的DataSet
    /// </summary>
    /// <author>天志</author>
    /// <log date="2007-09-01">创建</log>
    private DataSet tableDataSet;

    /// <summary>
    /// 存储数据库信息的DataSet
    /// </summary>
    /// <author>天志</author>
    /// <log date="2007-09-01">创建</log>
    public DataSet TableDataSet
    {
        set
        {
            this.tableDataSet = value;
        }
        get
        {
            if (this.tableDataSet == null)
            {
                try
                {
                    string dataBase = RegisterAccess.ReadKey("dataBase");

                    // 取得数据库中列信息，表信息，外键信息
                    string sql = RegistFields.instance.ColumnsInfoSQL + "\r\n" + RegistFields.instance.TableSQL + "\r\n " + RegistFields.instance.FKSQL;
                    //sql = string.Format(sql, dataBase);
                    this.tableDataSet = new DataSet();
                    DataTable dt = db.ExecuteDataTable(RegistFields.instance.ColumnsInfoSQL, null, CommandType.Text);
                    dt.TableName = "ColumnInfo";
                    this.tableDataSet.Tables.Add(dt);

                    dt = db.ExecuteDataTable(RegistFields.instance.TableSQL, null, CommandType.Text);
                    dt.TableName = "TableInfo";
                    this.tableDataSet.Tables.Add(dt);

                    dt = db.ExecuteDataTable(RegistFields.instance.FKSQL, null, CommandType.Text);
                    dt.TableName = "FKInfo";
                    this.tableDataSet.Tables.Add(dt);
                    /*
                    string[] names = { "ColumnInfo", "TableInfo", "FKInfo" };
                    this.tableDataSet = DBOperOracle.ExecuteDataSet(sql, names);*/

                    dt = this.tableDataSet.Tables["TableInfo"];
                    DataColumn dc = dt.Columns.Add("ID", Type.GetType("System.Int32"));
                    //dc.AllowDBNull = false;