/**  
* EC_DemandPrintParameterDAL.cs
*
* 功 能： 需求印刷参数操作SQL实现
* 类 名： EC_DemandPrintParameterDAL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-5-22 11:57       吴崎均  初版
* V0.02  2013-6-1 14:00        吴崎均  增加修改与根据编号获取信息方法 
*
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL.EC;
using CY.Model;
using System.Xml;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using System.Data;

namespace CY.SQLDAL
{
    /// <summary>
    /// 需求印刷参数操作SQL实现
    /// </summary>
    public class EC_DemandPrintParameterDAL
    {
        private Database _dataBase = null;
        /// <summary>
        /// 初始化构造 
        /// </summary>
        public EC_DemandPrintParameterDAL()
        {
            _dataBase = new Database();
        }
        /// <summary>
        /// 初始化构造(外部参数)
        /// </summary>
        /// <param name="dataBase"></param>
        public EC_DemandPrintParameterDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }


        /// <summary>
        /// 增加需求印刷选项
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_DemandPrintParameter trueModel = model as Model.EC_DemandPrintParameter;
            if (trueModel == null)
            {
                return false;
            }

            using (XmlTextReader rdr = new XmlTextReader(trueModel.PrintParameter, XmlNodeType.Document, null))
            {

                SqlXml sqlXml = new SqlXml(rdr);
                SqlParameter printPar = new SqlParameter("@PrintParameter", SqlDbType.Xml, sqlXml.Value.Length);
                printPar.Value = sqlXml;
                SqlParameter[] parameters = {
					new SqlParameter("@TargetId", SqlDbType.Int,4),
                    printPar
                };
                parameters[0].Value = trueModel.TargetId;
                try
                {
                    _dataBase.Query("sp_EC_DemandPrintParameter_Insert", CommandType.StoredProcedure, parameters);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return true;
        }

        /// <summary>
        /// 修改需求印刷选项
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_DemandPrintParameter trueModel = model as Model.EC_DemandPrintParameter;
            if (trueModel == null)
            {
                return false;
            }

            using (XmlTextReader rdr = new XmlTextReader(trueModel.PrintParameter, XmlNodeType.Document, null))
            {

                SqlXml sqlXml = new SqlXml(rdr);
                SqlParameter printPar = new SqlParameter("@PrintParameter", SqlDbType.Xml, sqlXml.Value.Length);
                printPar.Value = sqlXml;
                SqlParameter[] parameters = {
					new SqlParameter("@TargetId", SqlDbType.Int,4),
                    printPar
                };
                parameters[0].Value = trueModel.TargetId;
                try
                {
                    _dataBase.Query("sp_EC_DemandPrintParameter_Update", CommandType.StoredProcedure, parameters);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return true;
        }

        /// <summary>
        /// 获取需求印刷选项对象
        /// </summary>
        /// <param name="demandId"></param>
        /// <returns></returns>
        public Model.EC_DemandPrintParameter GetModel(int demandId)
        {
            string condition = string.Empty;
            condition = " TargetId=" + demandId;
            IList<EC_DemandPrintParameter> result = _dataBase.SelectModel<EC_DemandPrintParameter>("*", "EC_DemandPrintParameter", condition);
            return null == result || result.Count == 0 ? null : result[0];
        }

    }
}