App_Code/DB/Market/DataMarketMySQL.cs

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

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

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

using MySql.Data.MySqlClient;


sealed class DataMarketMySQL : DataMarketInterface
{
    private DBOper<MySQLCreator> db = new DBOper<MySQLCreator>();
    /// <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 + ";" + RegistFields.instance.TableSQL + ";" + RegistFields.instance.FKSQL;
                    sql = string.Format(sql, dataBase);
                    this.tableDataSet = new DataSet();
                    string[] names = { "ColumnInfo", "TableInfo", "FKInfo" };
                    this.tableDataSet = db.ExecuteDataSet(sql, names:names);

                    DataTable dt = this.tableDataSet.Tables["TableInfo"];
                    DataColumn dc = dt.Columns.Add("ID", Type.GetType("System.Int32"));
                    //dc.AllowDBNull = false;
                    int index = 1;
                    foreach (DataRow r in dt.Rows)
                    {
                        r["ID"] = index;
                        index++;
                    }
                }
                catch (System.Exception ex)
                {
                    this.tableDataSet = null;
                    string msg = ex.ToString();
                    throw ex;
                }
            }