ZLPMS/PMS.DBService/Product/CPWTGCService.cs

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

namespace PMS.DBService.Product
{
    /// <summary>
    /// 创建者：冉利
    /// 创建日期：2018/1/15
    /// 功能描述：产品问题过程数据层
    /// </summary>
    public class CPWTGCService : DataServiceBase
    {
        /// <summary>
        /// 获取产品问题过程处理流程
        /// </summary>
        /// <param name="cpID"></param>
        /// <returns></returns>
        public DataTable GetClc(string cpID)
        {
            var dt = this.ProcedureBuilder.Procedure("B_产品问题过程.p_获取处理流程")
                .Paramter("问题id_In", cpID)
                .ParamterOut("Result_list", true);
            dt.Execute();
            return dt.ParameterValue<DataTable>("Result_list");
        }

        /// <summary>
        /// 获取产品问题过程处理内容
        /// </summary>
        /// <param name="iD"></param>
        /// <returns></returns>
        public DataTable GetCommunicates(string iD)
        {
            var dt = this.ProcedureBuilder.Procedure("B_产品问题过程.p_产品问题过程沟通内容_Select")
                    .Paramter("问题ID_In",iD)
                    .ParamterOut("Resultlist", true);
            dt.Execute();
            return dt.ParameterValue<DataTable>("Resultlist");
        }
        /// <summary>
        /// 产品问题沟通内容保存
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public string SubmitContent(CPWTGCModel model)
        {
            var dt = this.ProcedureBuilder.Procedure("B_产品问题过程.p_产品问题过程_Insert")
                   .Paramter("问题ID_In",model.WTID)
                   .Paramter("沟通内容_In",model.GTNR)
                    .Paramter("记录时间_In",model.JLSJ)
                     .Paramter("记录人ID_In",model.JLRID)
                   .ParamterOut("Result_out", DbType.String, 400);
            dt.Execute();
            return dt.ParameterValue<String>("Result_out");
        }
    }
}