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

namespace PMS.DBService.BaseCode
{
    public class BaseClasservice : DataServiceBase
    {
        //            Procedure p_编码分类_Edit

        //(
        //  分类id_In     In 编码分类.Id % Type,
        //  上级id_In     In 编码分类.上级id % Type,
        //  分类编码_In   In 编码分类.分类编码 % Type,
        //  分类名称_In   In 编码分类.分类名 % Type,
        //  是否启用_In   In 编码分类.是否启用 % Type,
        //  说明_In       In 编码分类.说明 % Type,
        //  编辑类型_In   In Number, --0、新增 1、修改

        //  Resultstr_Out Out Varchar2
        public string CodeClassAdd(BaseClassModel param, int editType)
        {
          var exeResult = this.ProcedureBuilder.Procedure("b_基础管理_基础编码.p_编码分类_Edit")
                 .Paramter("分类id_In", param.ID)
                 .Paramter("上级id_In",param.simpleCode)
                 .Paramter("分类编码_In",param.Classcode)
                 .Paramter("分类名称_In",param.Classname)
                  .Paramter("是否启用_In",param.open)
                 .Paramter("说明_In",param.explain)
                   .Paramter("编辑类型_In", editType)
                 .ParamterOut("Resultstr_Out", DbType.String, 400);
            exeResult.Execute();
            return exeResult.ParameterValue<String>("Resultstr_Out");
        }
        /// <summary>
        /// 删除编码分类
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public string DelCodeClassif(string id)
        {
            var dt = this.ProcedureBuilder.Procedure("b_基础管理_基础编码.p_编码分类_Delete")
                .Paramter("分类id_In", id)
                .ParamterOut("Resultstr_Out", DbType.String,400);
            dt.Execute();
            return dt.ParameterValue<string>("Resultstr_Out");
        }

        /// <summary>
        /// 查询单条语句
        /// </summary>
        /// <param name="iD"></param>
        /// <returns></returns>
        public DataTable GetCodeClassif(string iD)
        {
            string sql = "select * from 编码分类 where id=:iD";
            var dt = this.SqlBuilder.SqlText(sql).Parameters("id",iD).Select();
            return dt;
        }


        /// <summary>
        /// 查询上级编码分类
        /// </summary>
        /// <returns></returns>
        public DataTable CodeClassSimpleCodeSelect()
        {
            var exeResult = this.ProcedureBuilder.Procedure("b_基础管理_基础编码.p_编码分类上级编码_Select")
                 .ParamterOut("ResultList", true);
            exeResult.Execute();
            return exeResult.ParameterValue<DataTable>("ResultList");
        }
        /// <summary>
        /// 获取编码分类最大值
        /// </summary>
        /// <returns></returns>
        ///   procedure p_编码分类最大编码_Select
    //(
    //result_out out varchar2
    //)
        public string CodeClassPopWindows(string Sjfl)
        {
           var exeResult= this.ProcedureBuilder.Procedure("b_基础管理_基础编码.p_编码分类最大编码_Select")
                .Paramter("上级分类_In", Sjfl)
                 .ParamterOut("result_out", DbType.String,400);
            exeResult.Execute();
            return exeResult.ParameterValue<string>("result_out");
        }

        /// <summary>
        /// 获取编码分类的分类编码
        /// </summary>
        /// <param name="parame"></param>
        /// <returns></returns>
        public string CodeClassFLBM(string parame)
        {
            var result = this.ProcedureBuilder.Procedure("b_基础管理_基础编码.p_分类编码_Select")
                .Paramter("上级ID_In",parame)
                .ParamterOut("Resultstr_Out",DbType.String,400);
            result.Execute();
             
            return result.ParameterValue<string>("Resultstr_Out");
        }

        /// <summary>
        /// 基础编码的上级分类id查询
        /// </summary>
        /// <returns></returns>
        public object CodeFLIDSelect()
        {
            var exeResult = this.ProcedureBuilder.Procedure("b_基础管理_基础编码.p_基础编码分类ID树形_Select")
                 .ParamterOut("ResultList", true);
            exeResult.Execute();
            return exeResult.ParameterValue<DataTable>("ResultList");
        }
    }
}