GZFramwork数据库层《前言》DLL项目引用

2021-11-13 08:45:27

新建项目：

1. 项目引入GZFramwork.dll

NuGet地址：Install-Package GZFramwork

每个项目都引用

2.BLL层

设置数据库连接维护类：继承于：GZFramwork.DBUtility.FramworkDbConnection

代码：

using GZFramwork;

using GZFramwork.DBUtility;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace GZFramworkTest.BLL

{

    public class FramworkDBProvider : GZFramwork.DBUtility.FramworkDbConnection

    {

        public override GZFramwork.DBUtility.ConnectionInfo DoDbInfo(string DBName)

        {

            if (DefaultConnection == null)

            {

                SQLConfig sc = new SQLConfig()

                {

                    Server = "(local)",

                    DataBase = "GZFramworkTest",

                    UserID = "test",

                    Password = "gzframwork"

                };

                DefaultConnection = new ConnectionInfo(sc);

            }

            if (DBName == DefaultConnection.DBName)

                return DefaultConnection;

            else

            {

                throw new Exception("不能识别的数据库！");

                //如果支持多数据库，在这里返回不同数据库名的ConnectionInfo实例

                //return new ConnectionInfo()

                //{

                //    DBObject = DBObject.MSSQL,

                //    DBName = DBName,

                //    ConnectionStr = DefaultSQLConfig.GetConnectionStr(DBName)

                //};

            }

        }

    }

}

Program 应用数据库连接维护：修改启动项目Program文件中Main函数：

项目主程序Main()函数中配置初始化

/// <summary>

        /// 应用程序的主入口点。

        /// </summary>

        [STAThread]

        static void Main()

        {

            Application.EnableVisualStyles();

            Application.SetCompatibleTextRenderingDefault(false);

new GZFramwork.GZFramworkDBConfig<BLL.GZFramworkDBProvider>();//应用数据库连接维护

            Application.Run(new Form1());

        }

定义bllBusiness类，继承自GZFramwork.ORM.GZbllBaseBusiness

代码：

namespace GZFramworkTest.BLL

{

    public class bllBusiness : GZFramwork.Lib.GZbllBaseBusiness

    {

        public bllBusiness(Type ORM_Main, string DocCode, int Length, params Type[] ORM_Details)

        {

            _DAL = new GZFramwork.Lib.GZdalBaseBusiness(ORM_Main, DocCode, Length, ORM_Details);

        }

        public bllBusiness(Type ORM_Main, params Type[] ORM_Details)

        {

            _DAL = new GZFramwork.Lib.GZdalBaseBusiness(ORM_Main, null, , ORM_Details);

        }

        public override string Account

        {

            //这里模拟登陆账号为GarsonZhang

            get { return "GarsonZhang"; }

        }

        public override string DefultDBName

        {

            //当前数据库

            get { return "GZFramworkTest"; }

        }

    }

}