#region

using System.Data;
using CSFramework.DB;
using CSFrameworkV5.CodeGeneratorCore;
using CSFrameworkV5.Core;
using CSFrameworkV5.DataAccess;
using CSFrameworkV5.Interfaces;
using CSFrameworkV5.Models;
using CSFrameworkV5.WebRef;

#endregion

namespace CSFrameworkV5.Business
{
    /// <summary>
    ///     BLL业务逻辑层:blltest 2022-5-1
    /// </summary>
    public class blltest : bllBaseDataDict
    {
        public static DatabaseMSSQL mSSQL;

        private dalPURDHA _DAL; //自定义策略接口(桥接层)

        //IBridge_Language _Bridge;
        public blltest()
        {
            _KeyFieldName = PURDHA.__KeyName; //主键字段
            _SummaryTableName = PURDHA.__TableName; //表名
            _WriteDataLog = false; //是否保存数据操作日志
            _DataDictBridge =
                DALFactory.CreateDalByORM(Loginer.CurrentUser,
                    typeof(PURDHA)); //数据字典通用DAL层实例
            _DAL = new dalPURDHA(Loginer.CurrentUser); //DAL层实例         
        }

        /// <summary>
        ///     创建自定义策略接口(桥接层)实例
        /// </summary>
        /// <returns></returns>
        private IBridge_Language CreateBridge()
        {
            if (BridgeFactory.IsADODirect) //直连模式
                return new dalPURDHA(Loginer.CurrentUser);

            //如需要开发Web服务代理层，参考WebRef模块WebService_Customer.cs文件
            if (BridgeFactory.IsWCFBridge) return new WCF_Language();

            throw new CustomException(BridgeFactory.UNKNOW_BRIDGE_TYPE);
        }

        public bool QueryDelete(DataTable dr, string tableName, string KEY)
        {
            var con =
                " Data Source=.;Initial Catalog=CSFrameworkV5_Normal;User ID=sa;Password =563593659liu;Persist Security Info=True;Connect Timeout=15;;Connection TimeOut=15;";
            mSSQL = new DatabaseMSSQL(con);
            //DataSet dZ = new DataSet();
            //dZ.Tables.Add(dF.Copy());
            var T = mSSQL.DeleteDataSet(dr, tableName, KEY);
            return T;
        }

        public bool QuerySave(DataTable dr, string tableName)
        {
            var con =
                " Data Source=.;Initial Catalog=CSFrameworkV5_Normal;User ID=sa;Password =563593659liu;Persist Security Info=True;Connect Timeout=15;;Connection TimeOut=15;";
            mSSQL = new DatabaseMSSQL(con);
            var T = mSSQL.AddTable(dr, tableName);
            return T;
        }

        public DataTable QueryT()
        {
            var dt = _DAL.Query();
            return dt;
        }

        public bool QueryUpdata(DataTable dF, string tableName, string KEY)
        {
            var con =
                " Data Source=.;Initial Catalog=CSFrameworkV5_Normal;User ID=sa;Password =563593659liu;Persist Security Info=True;Connect Timeout=15;;Connection TimeOut=15;";
            mSSQL = new DatabaseMSSQL(con);
            //DataSet dZ = new DataSet();
            //dZ.Tables.Add(dF.Copy());
            var T = mSSQL.UpdateDataSet(dF, tableName, KEY);

            return T;
        }
        //public DataTable Query(String ObjectID, String CHS, String CHT, String ENG, String DataType)
        //{
        //    DataTable dt = _Bridge.Query(ObjectID, CHS, CHT, ENG, DataType);
        //    _SummaryTable = dt;
        //    return dt;
        //}

        //internal DataTable GetTypeData()
        //{
        //    return _Bridge.GetLanguageTypeData();
        //}

        //public DataTable GetLanguageData()
        //{
        //    return _Bridge.GetLanguageData();
        //}

        //public bool PostLanguage(string lanType, string objectID, string defaultValue, string itemType)
        //{
        //    return _Bridge.PostLanguage(lanType, objectID, defaultValue, itemType);
        //}
    }
}