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

namespace PMS.DBService.Product
{
    /// <summary>
    /// 创 建 人：伍莲魁
    /// 创建日期：2018-12-11
    /// 功能描述：产品版本配置数据层
    /// </summary>
    public class Productversionservice : DataServiceBase
    {
        /// <summary>
        /// 重写数据工厂
        /// </summary>
        /// <param name="conName"></param>
        protected override void DBFctory(string conName)
        {
            base.DBFctory(conName);
        }

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

        /// <summary>
        /// 增加数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(ProductVersionModel model, ITransaction trans)
        {
            model.SetDataFactory(this.DataFactoryObject);
            if (trans == null)
            {
                return model.Insert();
            }
            else
            {
                return model.Insert(trans);
            }
        }

        /// <summary>
        /// 更新数据库记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Update(ProductVersionModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            return model.Where("ID").Update("主版本ID","版本号", "类型", "状态", "计划日期", "发布日期", "版本概述", "注意事项", "封版日期", "配置信息","负责人ID", "负责人");
        }
        /// <summary>
        /// 将问题记录待发布状态批量更新已发布 6
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateProblem(ProductVersionModel model)
        {
         return   this.UpdateBuilder.Update("问题记录").Column("解决版本状态", 6).Where("解决版本",model.BBH).Where("解决版本状态", 4).Execute();
           
        }
        /// <summary>
        /// 更新已有数据的版本号
        /// </summary>
        /// <param name="model"></param>
        /// <param name="OldVersion"></param>
        /// <returns></returns>
        public int UpdateProblemVersion(ProductVersionModel model,string OldVersion)
        {
            return this.UpdateBuilder.Update("问题记录").Column("解决版本", model.BBH).Where("解决版本", OldVersion).Execute();

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

            List<string> where = new List<string>();
            where.Add("ID");

            if (trans == null)
            {
                return model.Update(where, string.Empty);
            }
            else
            {
                return model.Update(trans, where, string.Empty);
            }
        }

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

            return model.Delete("ID");
        }

        /// <summary>
        /// 删除数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Delete(ProductVersionModel model, ITransaction trans)
        {
            model.SetDataFactory(this.DataFactoryObject);
            if (trans == null)
            {
                return model.Delete("ID");
            }
            else
            {
                return model.Delete(trans, "ID");
            }
        }

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

        /// <summary>
        /// 列表查询
        /// </summary>
        /// <returns></returns>
        public List<ProductVersionModel> SelectList(ProductVersionModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            return model.SelectList<ProductVersionModel>();
        }

        /// <summary>
        /// 调用存储过程
        /// </summary>
        /// <returns></returns>
		public void CallProcedure(ProductVersionModel model)
        {
            this.ProcedureBuilder
                .Procedure("p_PT_产品版本配置_INSERT")
                .Paramter("ID_IN", model.ID)
                .Paramter("主版本ID_IN", model.ZBBID)
                .Paramter("产品ID_IN", model.CPID)
                .Paramter("版本号_IN", model.BBH)
                .Paramter("类型_IN", model.LX)
                .Paramter("状态_IN", model.ZT)
                .Paramter("渠道ID_IN", model.QDID)
                .Paramter("申请人ID_IN", model.SQRID)
                .Paramter("申请人_IN", model.SQR)
                .Paramter("申请日期_IN", model.SQRJ)
                .Paramter("计划日期_IN", model.JHRJ)
                .Paramter("发布日期_IN", model.FBRJ)
                .Paramter("版本概述_IN", model.BBGS)
                .Paramter("注意事项_IN", model.ZYSX)
                .Paramter("负责人ID_IN", model.FZRID)
                .Paramter("负责人_IN", model.FZR)
                .Paramter("附件_IN", model.FJ)
                .Paramter("封版日期_IN", model.FBRQ)
                .Paramter("配置信息_IN", model.PZXX)
                .Execute();
        }
        public DataTable productVersionInfoTreeGrid(string ProductID, string States)
        {


            var execute = this.ProcedureBuilder
                  .Procedure("b_基础管理_产品管理.p_产品版本Tree_Select")
                  .Paramter("产品ID_In", ProductID)
                  .ParamterOut("Resultlist", true);

            if (States == "")
            {
                execute.Paramter("状态_In", DBNull.Value);
            }
            else
            {
                execute.Paramter("状态_In", Convert.ToInt32(States));
            }
            execute.Execute();
            var dt = execute.ParameterValue<DataTable>("Resultlist");
            return dt;
        }
        public DataTable GetProductVerInfo(string id)
        {
            return this.SelectBuilder.Columns("*")
                       .From("产品版本配置")
                       .Where("ID", id)
                       .Select();
        }
        public DataTable ProductVerAnnexDataGrid(string ProductVerID)
        {
            return this.SelectBuilder.Columns("类型", "添加人", "添加时间","ID","附件ID")
                        .From("产品版本附件")
                        .Where("产品版本ID", ProductVerID)
                        .Where("是否删除",0)
                        .Select();
                         
        }
    }
}