#region

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

#endregion

namespace CSFrameworkV5.DataAccess
{
    /// *************************************************************************/
    /// *
    /// * 文件名    ：dalAttachFile.cs                                     
    /// * 程序说明  : 附件管理数据层
    /// * 原创作者  ：www.csframework.com 
    /// * 
    /// * Copyright 2006-2021 C/S框架网 www.csframework.com
    /// **************************************************************************/
    /// <summary>
    ///     附件管理数据层
    /// </summary>
    [DefaultORM_UpdateMode(typeof(tb_AttachFile), true)]
    public class dalAttachFile : dalBaseDataDict, IBridge_AttachFile
    {
        public dalAttachFile(Loginer loginer)
            : base(loginer)
        {
            TableName = tb_AttachFile.__TableName;
            _KeyName = tb_AttachFile.__KeyName;
            _ModelType = typeof(tb_AttachFile);
        }

        /// <summary>
        ///     获取指定单据的附件数据
        /// </summary>
        /// <param name="docID">单据号码</param>
        /// <returns></returns>
        public DataTable GetData(string docID)
        {
            var sql =
                $"SELECT * FROM tb_AttachFile WHERE DocID={_Database.ParamSymboName}DocID;";
            var cmd = _Database.CreateCommand(sql);
            cmd.AddParam("DocID", DbType.String, docID);
            var dt = _Database.GetTable(cmd.Command, tb_AttachFile.__TableName);
            return dt;
        }
    }
}