using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using PMS.EntityModels.SysManager;
using QWPlatform.IService;

namespace PMS.DBService.SysManager
{
    /// <summary>
    /// 按钮的数据层操作
    /// </summary>
    public class ButtonDBService : DataServiceBase
    {

        /// <summary>
        /// 增加数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(ButtonModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            return model.Insert();
        }


        /// <summary>
        /// 更新数据库记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Update(ButtonModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);

            model.Where("ID");

            return model.Update("名称", "标识", "图标", "序号", "颜色", "备注", "启用");
        }

        /// <summary>
        /// 删除数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Delete(ButtonModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);

            return model.Delete("ID");
        }

        /// <summary>
        /// 查询数据对象并进行赋值
        /// </summary>
        /// <returns></returns>
        public ButtonModel Select(ButtonModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            model.Select();
            return model;
        }

        /// <summary>
        /// 检查是否存在重复的tag
        /// </summary>
        /// <param name="tag">tag</param>
        /// <param name="id">id</param>
        /// <returns></returns>
        public bool CheckNameExists(string tag, int id)
        {
            if (id > 0)
            {//修改时查询
                return this.SqlBuilder
                    .SqlText("select 1 from 系统按钮 where id <> :id and 标识=:标识")
                    .Exists();
            }
            else
            {//新增时查询
                return this.SqlBuilder
                    .SqlText("select 1 from 系统按钮 where 标识=:标识")
                    .Exists();
            }
        }

        /// <summary>
        /// 读取所有按钮
        /// </summary>
        /// <param name="includeActive"></param>
        /// <returns></returns>
        public DataTable GetAllButtons(bool includeActive)
        {
            var selectBuilder = this.SelectBuilder
                 .Columns("*")
                 .From("系统按钮")
                 .OrderBy("序号 asc");
            if (includeActive)
            {//启用
                return selectBuilder.Where("启用", 1)
                    .Select();
            }
            else
            {//所有按钮
                return selectBuilder.Select();
            } 
        }
    }
}