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

namespace PMS.DBService.MoblieProblemRegist
{
    public class Productproblemprocessservice : 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(ProductProblemProcessModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            return model.Insert();
        }

        /// <summary>
        /// 增加数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(ProductProblemProcessModel 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(ProductProblemProcessModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);

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

            return model.Update(where, string.Empty);
        }


        /// <summary>
        /// 更新数据库记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Update(ProductProblemProcessModel 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(ProductProblemProcessModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);

            return model.Delete("ID");
        }

        /// <summary>
        /// 删除数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Delete(ProductProblemProcessModel 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 ProductProblemProcessModel Select(ProductProblemProcessModel model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            model.Select();
            return model;
        }

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

        /// <summary>
        /// 调用存储过程
        /// </summary>
        /// <returns></returns>
		public void CallProcedure(ProductProblemProcessModel model)
        {
            this.ProcedureBuilder
                .Procedure("p_PT_产品问题过程_INSERT")
                .Paramter("ID_IN", model.ID)
                .Paramter("性质_IN", model.XZ)
                .Paramter("问题ID_IN", model.WTID)
                .Paramter("流程ID_IN", model.LCID)
                .Paramter("状态_IN", model.ZT)
                .Paramter("工作量_IN", model.GZL)
                .Paramter("单位_IN", model.CW)
                .Paramter("耗时_IN", model.HS)
                .Paramter("记录时间_IN", model.JLSJ)
                .Paramter("记录人ID_IN", model.JLRID)
                .Paramter("记录人_IN", model.JLR)
                .Paramter("描述_IN", model.MS)
                .Paramter("附件_IN", model.FJ)
                .Execute();
        }
    }
}