#region

using System;
using System.Data;
using System.Text;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Core.CodeGenerator;
using CSFrameworkV5.Interfaces.Bridge;
using CSFrameworkV5.Models;

#endregion

/*===================================================================
 *   程序说明: AdvancedFormConfig的数据访问层源码
 *   作者资料: 孙中吕
 *   创建日期: 2017/02/12 04:35:26
 *   最后修改: 2017/02/12 04:35:26
 *
 *   注: 本代码由代码生成器(Code Generator)自动生成
 *   (此源码文件请放置在DataAccess模块)
 *   版权所有 copyright 2006~2017, C/S框架网(www.cscode.net)
 *===================================================================*/

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

        public string ExistsConfig(string systemID, string programID,
            string configName, string applyType, string IDs)
        {
            var sp = _Database.CreateSqlProc("usp_ValidateFormConfig");
            sp.AddParam("SystemID", DbType.String, systemID);
            sp.AddParam("ProgramID", DbType.String, programID);
            sp.AddParam("ConfigName", DbType.String, configName);
            sp.AddParam("ApplyType", DbType.String, applyType);
            sp.AddParam("IDs", DbType.String, IDs);
            var o = _Database.ExecuteScalar(sp.Command);
            return ConvertEx.ToString(o);
        }

        public DataTable GetFormConfig(string systemID, string programID,
            string userID)
        {
            var sp = _Database.CreateSqlProc("usp_GetFormConfig");
            sp.AddParam("SystemID", DbType.String, systemID);
            sp.AddParam("ProgramID", DbType.String, programID);
            sp.AddParam("UserID", DbType.String, userID);
            sp.AddParam("DataSetID", DbType.String, _Loginer.DBID);
            return DatabaseProvider.SystemDatabase.GetTable(sp.Command,
                sys_AdvancedFormConfig.__TableName);
        }

        public DataTable Search(string SystemID, string ProgramID,
            string StyleID)
        {
            //构建CommandHelper实例，用于动态创建参数对象
            var cmd = _Database.CreateCommand("");

            var sb = new StringBuilder();
            sb.Append("SELECT * FROM sys_AdvancedFormConfig WHERE 1=1 ");

            var p = _Database.ParamSymboName;

            if (!string.IsNullOrEmpty(SystemID))
            {
                sb.Append($" AND SystemID ={p}SystemID");
                cmd.AddParam("SystemID", SystemID);
            }

            if (!string.IsNullOrEmpty(ProgramID))
            {
                sb.Append($" AND ProgramID ={p}ProgramID");
                cmd.AddParam("ProgramID", ProgramID);
            }

            if (!string.IsNullOrEmpty(StyleID))
            {
                sb.Append($" AND StyleID ={p}StyleID");
                cmd.AddParam("StyleID", StyleID);
            }

            sb.Append(" ORDER BY " + sys_AdvancedFormConfig.__KeyName + ";");

            cmd.Command.CommandText =
                CodeSafeHelper.GetSafeSQL(sb.ToStringEx());

            return _Database.GetTable(cmd.Command,
                sys_AdvancedFormConfig.__TableName);
        }

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

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

            return new GenerateSqlCmdByTableFields(ORM, table,
                GeneratorFactory);
        }
    } //public class
} //namespace