ZLPMS/PMS.BusinessService/Product/CpjtpzBusiness.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.Composition;
using System.Linq;
using System.Text;
using PMS.DBService.Product;
using PMS.Interface;
using QWPlatform.IService;
using QWPlatform.SystemLibrary.Utils;
using QWPlatform.SystemLibrary;
using System.Data;
using PMS.Interface.Product;
using PMS.BusinessModels.Product;
using PMS.EntityModels.Product;

namespace PMS.BusinessService.Product
{
    /// <summary>
    ///  创 建 人：伍莲魁
    /// 创建日期：2018-12-10
    /// 功能描述：产品管理业务层
    /// </summary>
    public class CpjtpzBusiness : IProductModule
       
    {
        private Cpjtpzservice db_ProInfo = DataServiceBase.Instance<Cpjtpzservice>();
        private Productfunservice db_ProfunInfo = DataServiceBase.Instance<Productfunservice>();
        #region 产品系统配置
        /// <summary>
        /// 获取所有产品编码
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public string GetProductCode()
        {
            var dt = db_ProInfo.GetProductCode();
            return dt.ToJson();
        }
        public string GetProductCodeBycustom(string ProjectId)
        {
            var dt = db_ProInfo.GetProductCodeBycustom(ProjectId);
            return dt.ToJson();
        }
        public string GetProductInfoDataGrid(string search, string states)
        {
            var dt = db_ProInfo.GetProductInfoDataGrid(search, states);

            return Strings.ObjectToJson(dt, true);
        }
        public string ProductInfoCombobox()
        {
            var dt = db_ProInfo.ProductInfoCombobox();

            return Strings.ObjectToJson(dt, true);
        }
       public  string GetProductFunctionTree(string ProductId,string search, string states)
        {
            var dt = db_ProInfo.GetProductFunctionTree(ProductId, search, states);
            if (dt !=null && dt.Rows.Count > 0)
            {
                var column = new string[] { "ID", "上级ID", "名称", "编码", "开发方式", "开发状态", "研发人", "测试人", "测试人NEW", "说明" ,"类型"};
                return dt.ToEasyUITreeGridJson("ID", "上级ID", null, column, "");
            }
            return "[]";
           
        }
        /// <summary>
        /// 返回dataTable
        /// </summary>
        /// <param name="ProductId"></param>
        /// <param name="search"></param>
        /// <param name="states"></param>
        /// <returns></returns>
        public DataTable GetProductFunctionDataTable(string ProductId, string search, string states)
        {
            var dt = db_ProInfo.GetProductFunctionTree(ProductId, search, states);
           
            return dt;

        }
        public DataTable GetProductInfo(string  id)
        {
            return db_ProInfo.GetProductInfo(id);
        }
        public DataTable GetProductFunInfo(string id)
        {
            return db_ProfunInfo.GetProductFunInfo(id);
        }
        public bool SaveProductInfo(FormProductModel model)
        {
            var Cmodel = new CPJTPZModel();
            Cmodel.BM = model.Coding;
            Cmodel.FZR = model.PerInCharge;
            Cmodel.FZRID = model.PerInChargeID;
            Cmodel.MC = model.name;
            Cmodel.SM = model.remark;
            Cmodel.ZT= model.GetIsActive ? 1 : 0;
            Cmodel.CPLCZT = model.ProductStatus;
            if (String.IsNullOrEmpty(model.id))
            {
                //不存在ID，需要创建一个新记录
                return db_ProInfo.Add(Cmodel) > 0;
            }
            else
            {
                //存在ID，说明是编辑
                Cmodel.ID = model.id;
                return db_ProInfo.Update(Cmodel) > 0;
            }
        }
        public   bool DelProduct(string id)
        {
            var Cmodel = new CPJTPZModel();
            Cmodel.ID= id;
            return db_ProInfo.Delete(Cmodel) > 0;
        }
        public  bool DelProductFun(string id)
        {
            var Fmodel = new ProductFunModel();
            Fmodel.ID = id;
            return db_ProfunInfo.Delete(Fmodel) > 0;
        }
        
        public string GetProdutFunTree(string id)
        {
            var dt = db_ProInfo.GetProductFunctionTree(id, "", "");
            return dt.ToEasyUITreeJson("ID", "名称", "上级ID", null, "");
        }
        public bool PostSaveProductFun(FormProductFunModel model)
        {
            var Cmodel = new ProductFunModel();
            Cmodel.BM = model.Coding;
            Cmodel.CPID = model.ProID;
            Cmodel.CSRNEW = model.TestPer;
            Cmodel.CSRIDNEW = model.TestPerID;
            Cmodel.KFFS = model.DevelopmentModeID;
            Cmodel.LX = model.IntType;
            Cmodel.MC = model.name;
            Cmodel.SM = model.remark;
            Cmodel.YFR = model.ResearchPer;
            Cmodel.YFRID = model.ResearchPerID;
            Cmodel.ZT = model.DevelopmentStatusID;
            if (!String.IsNullOrEmpty(model.parentid))
            {
                Cmodel.SJID = model.parentid;
            }
            if (String.IsNullOrEmpty(model.id))
            {
                //不存在ID，需要创建一个新记录
                return db_ProfunInfo.Add(Cmodel) > 0;
            }
            else
            {
                //存在ID，说明是编辑
                Cmodel.ID = model.id;
                return db_ProfunInfo.Update(Cmodel) > 0;
            }
        }
        public bool PostSaveProductFunInport(FormProductFunModel model)
        {
            var Cmodel = new ProductFunModel();
            Cmodel.ID = model.id;
            Cmodel.SJID = model.parentid;
            Cmodel.BM = model.Coding;
            Cmodel.CPID = model.ProID;
            Cmodel.CSRNEW = model.TestPer;
            Cmodel.CSRIDNEW = model.TestPerID;
            Cmodel.KFFS = model.DevelopmentModeID;
            Cmodel.LX = model.IntType;
            Cmodel.MC = model.name;
            Cmodel.SM = model.remark;
            Cmodel.YFR = model.ResearchPer;
            Cmodel.YFRID = model.ResearchPerID;
            Cmodel.ZT = model.DevelopmentStatusID;
            //不存在ID，需要创建一个新记录
            return db_ProfunInfo.AddInport(Cmodel) > 0;
        }
        #endregion

        #region 产品版本配置
        private Productversionservice db_ProVerInfo = DataServiceBase.Instance<Productversionservice>();
        public string productVersionInfoTreeGrid(string ProductID, string States)
        {
            var dt = db_ProVerInfo.productVersionInfoTreeGrid(ProductID, States);
            if (dt != null && dt.Rows.Count > 0)
            {
                var column = new string[] { "ID", "上级ID", "版本号", "类型", "状态", "申请人ID", "申请人", "申请日期", "计划日期", "发布日期", "负责人", "封版日期","版本概述", "注意事项", "配置信息" };
                return dt.ToEasyUITreeGridJson("ID", "上级ID", null, column, "");
            }
            return "[]";
        }
        public string GetProdutVersionTree(string ProID)
        {
            var dt = db_ProVerInfo.productVersionInfoTreeGrid(ProID, "");
            return dt.ToEasyUITreeJson("ID", "版本号", "上级ID", null, "");
        }
        public DataTable  GetProductVerInfo(string id)
        {
            return db_ProVerInfo.GetProductVerInfo(id);
        }
        public  bool PostSaveProductVersion(ProductVersionModel emodel)
        {
            if (String.IsNullOrEmpty(emodel.ID))
            {
                //不存在ID，需要创建一个新记录
                return db_ProVerInfo.Add(emodel) > 0;
            }
            else
            {
               //状态未5，发布状态，更新当前版本下所有待发布数据未发布状态
                if(emodel.ZT==5)
                { db_ProVerInfo.UpdateProblem(emodel); }
                else
                {
                  var roVerInfo =  db_ProVerInfo.GetProductVerInfo(emodel.ID);
                    if (roVerInfo.Rows.Count>0)
                    {
                        //同步更新已有数据的版本号
                        if(!emodel.BBH.Equals( roVerInfo.Rows[0]["版本号"].ToString()))
                        {
                            db_ProVerInfo.UpdateProblemVersion(emodel, roVerInfo.Rows[0]["版本号"].ToString());
                        }
                       
                    }
                   
                }
                //存在ID，说明是编辑
                return db_ProVerInfo.Update(emodel) > 0;
            }
        }
        public  bool PostDelProductVer(string id)
        {
            var Fmodel = new ProductVersionModel();
            Fmodel.ID = id;
            return db_ProVerInfo.Delete(Fmodel) > 0;
        }
        public string ProductVerAnnexDataGrid(string ProductVerID)
        {
            var dt = db_ProVerInfo.ProductVerAnnexDataGrid(ProductVerID);

            return Strings.ObjectToJson(dt, true);
        }
        #endregion

        #region 项目产品模块
        public string GetProductByProjectId(string id)
        {
            var dt = db_ProInfo.GetProductByProjectId(id);
            return dt.ToJson();
        }


        #endregion

        //获取所有产品目录信息
        //why:2019-03-07
        public string GetAllProducts()
        {
            DataTable dt = db_ProfunInfo.GetAllProducts();

            return Strings.ObjectToJson(dt);
        }
        /// <summary>
        /// 添加产品版本附件
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool AddVersionFile(ProductVersionFileModel model)
        {
         return db_ProfunInfo.AddVersionFile(model);
        }
        public bool DeleteProductVersionFile(string id)
        {
            return db_ProfunInfo.DeleteProductVersionFile(id);
        }
    }
}