/**  
* EC_OrderPrintParameterDAL.cs
*
* 功 能： 订单印刷参数操作SQL实现
* 类 名： EC_OrderPrintParameterDAL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-5-6              周刚    添加方法
* V0.02  2013-6-1 14:02        吴崎均  增加修改信息方法 
*
*/
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_OrderPrintParameterDAL : IEC_OrderPrintParameterDAL
    {
        private Database _dataBase = null;
        /// <summary>
        /// 初始化构造 
        /// </summary>
        public EC_OrderPrintParameterDAL()
        {
            _dataBase = new Database();
        }
        /// <summary>
        /// 初始化构造(外部)
        /// </summary>
        /// <param name="dataBase"></param>
        public EC_OrderPrintParameterDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }
        /// <summary>
        /// 根据编号获取订单印刷选项对象
        /// </summary>
        /// <param name="orderId"></param>
        /// <returns></returns>
        public Model.EC_OrderPrintParameter GetModel(int orderId)
        {
            string condition = string.Empty;
            condition = " orderId=" + orderId;
            IList<EC_OrderPrintParameter> result = _dataBase.SelectModel<EC_OrderPrintParameter>("*", "EC_OrderPrintParameter", condition);
            return null == result || result.Count == 0 ? null : result[0];
        }
        /// <summary>
        /// 添加订单印刷选项
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_OrderPrintParameter trueModel = model as Model.EC_OrderPrintParameter;
            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("@OrderId", SqlDbType.Int,4),
                    printPar
                };
                parameters[0].Value = trueModel.OrderId;
                try
                {
                    _dataBase.Query("EC_OrderPrintParameter_ADD", 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_OrderPrintParameter trueModel = model as Model.EC_OrderPrintParameter;
            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("@OrderId", SqlDbType.Int,4),
                    printPar
                };
                parameters[0].Value = trueModel.OrderId;
                try
                {
                    _dataBase.Query("sp_EC_OrderPrintParameter_Update", CommandType.StoredProcedure, parameters);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return true;
           
        }

        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            throw new NotImplementedException();
        }
    }
}