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

namespace PMS.DBService.Product
{
 public   class ZDYCXService : DataServiceBase
    {
    /// <summary>
    /// 创建者：冉利
    /// 创建日期：2018/1/07
    /// 功能描述：自定义查询方案
    /// </summary>
        //实例化数据库
        public DataServiceBase dataservice = new DataServiceBase();
        /// <summary>
        /// 查询自定义查询方案
        /// </summary>
        /// <param name="zhID">账户id</param>
        /// <returns></returns>
        public DataTable ZdyCx(long? zhID)
        {
            var dt = this.SelectBuilder.Columns("查询条件")
                .From("自定义查询")
                .Where("账户id", zhID)
                .Where("是否默认", 1)
                     .Select();
            return dt;
        }
        /// <summary>
        /// 方案名重复检查
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public DataTable FAM(string name)
        {
            var dt = this.SelectBuilder.Columns("*")
               .From("自定义查询")
               .Where("方案名", name)
                    .Select();
            return dt;
        }

        /// <summary>
        /// 方案名查询
        /// </summary>
        /// <returns></returns>
        public object FanSelect()
        {
            var dt=this.SelectBuilder.Columns("ID")
                .Columns("方案名")
                .From("自定义查询")
                     .Select();
            return dt;
        }

        /// <summary>
        /// 方案名查询
        /// </summary>
        /// <param name="faCx"></param>
        /// <returns></returns>
        public DataTable FaSelect(string faCx)
        {
            var dt = this.SelectBuilder.Columns("查询条件")
               .From("自定义查询")
               .Where("ID", faCx)
                    .Select();
            return dt;
        }

        /// <summary>
        /// 自定义查询方案的保存
        /// </summary>
        /// <param name="zdymodel"></param>
        /// <returns></returns>
        public string ZdyFangan(ZDYCXModel zdymodel)
        {
          var dt= this.ProcedureBuilder.Procedure("B_自定义查询.P_自定义查询_Edit")
                .Paramter("账户ID_in",zdymodel.ZHID)
                .Paramter("方案名_in",zdymodel.FAM)
                .Paramter("模块ID_in",zdymodel.MKID)
                .Paramter("查询条件_in",zdymodel.CXTJ)
                .Paramter("是否默认_in",zdymodel.SFMR)
                .ParamterOut("Resultstr_Out", DbType.String, 400);
            dt.Execute();
            return dt.ParameterValue<string>("Resultstr_Out");
        }
    }
}