#region

using System;
using System.Data;
using CSFrameworkV5.Core;
using CSFrameworkV5.Core.CodeGenerator;
using CSFrameworkV5.Interfaces;
using CSFrameworkV5.Models;

#endregion

/*===================================================================
 *   程序说明: DataFieldConfig的数据访问层源码
 *   作者资料: 楚楚.C/S框架网
 *   创建日期: 2014/06/07 10:20:48
 *   最后修改: 2014/06/07 10:20:48
 *
 *   注: 本代码由代码生成器(Code Generator)自动生成
 *   (此源码文件请放置在DataAccess模块)
 *   版权所有 copyright 2006~2014, C/S框架网 http://www.csframework.com
 *===================================================================*/

namespace CSFrameworkV5.DataAccess
{
    /// <summary>
    ///     DAL数据层:dalDataFieldConfig
    /// </summary>
    [DefaultORM_UpdateMode(typeof(sys_DataFieldConfig), true)]
    public class dalDataFieldConfig : dalBaseDataDict, IBridge_DataFieldConfig
    {
        /// <summary>
        ///     构造器
        /// </summary>
        /// <param name="loginer">当前登录用户</param>
        public dalDataFieldConfig(Loginer loginer)
            : base(loginer)
        {
            _KeyName = sys_DataFieldConfig.__KeyName; //主键字段
            _TableName = sys_DataFieldConfig.__TableName; //表名
            _ModelType = typeof(sys_DataFieldConfig); //指定ORM模型
        }

        public DataTable GetConfig(string configName)
        {
            var sql =
                $"SELECT * FROM sys_DataFieldConfig WHERE ConfigName={_Database.ParamSymboName}ConfigName;";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("ConfigName", configName);
            return _Database.GetTable(cmd.Command,
                sys_DataFieldConfig.__TableName);
        }

        public DataTable GetConfig(string account, string configName)
        {
            var sql =
                $"SELECT * FROM sys_DataFieldConfig WHERE ConfigName={_Database.ParamSymboName}ConfigName AND UserName={_Database.ParamSymboName}UserName;";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("ConfigName", configName);
            cmd.AddParam("UserName", account);
            return _Database.GetTable(cmd.Command,
                sys_DataFieldConfig.__TableName);
        }

        /// <summary>
        ///     根据表名获取该表的SQL命令生成器
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        protected override IGenerateSqlCommand CreateSqlGenerator(
            DataTable table)
        {
            Type ORM = null;
            if (table.TableName == sys_DataFieldConfig.__TableName)
                ORM = typeof(sys_DataFieldConfig); //指定表与ORM模型的对应关系

            if (ORM == null) throw new Exception(table.TableName + "表没有ORM模型！");

            return new GenerateSqlCmdByTableFields(ORM, table,
                GeneratorFactory);
        }

        public override bool Update(DataSet data)
        {
            _UserManualControlTrans = true;

            try
            {
                BeginTransaction();

                //保存资料前清空旧数据
                var R = data.Tables[0].Rows[0];

                var sql =
                    $"DELETE FROM sys_DataFieldConfig WHERE ConfigName={_Database.ParamSymboName}ConfigName AND UserName={_Database.ParamSymboName}UserName;";
                var cmd = _Database.CreateCommand(sql);
                cmd.AddParam("ConfigName", R[sys_DataFieldConfig.ConfigName]);
                cmd.AddParam("UserName", R[sys_DataFieldConfig.UserName]);

                _Database.ExecuteTrans(_CurrentTrans, cmd.Command);

                var ret = base.Update(data);

                CommitTransaction();
                return ret;
            }
            catch
            {
                RollbackTransaction();
                return false;
            }
        }
    } //public class
} //namespace