/**  
* EC_AcceptWayByOrderDAL.cs
*
* 功 能： 订单收货方式数据访问接口实现类
* 类 名： EC_AcceptWayByOrderDAL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-26 14:42       吴崎均    初版(增加传入Database对象的初始化构造)
* V0.02  2013-5-13 11:17       吴崎均    修改新增修改方法，增加存储调用参数TheAwb
* V0.03  2013-5-13 14:42       吴崎均    修改新增修改方法，增加存储调用参数AcceptTypeId
*
*
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using System.Data.SqlClient;
using System.Data;
using CY.Model;

namespace CY.SQLDAL
{
    /// <summary>
    /// 订单收货方式数据访问接口实现类
    /// </summary>
    public class EC_AcceptWayByOrderDAL : IEC_AcceptWayByOrderDAL
    {

        private Database _dataBase = null;

        public EC_AcceptWayByOrderDAL()
        {
            _dataBase = new Database();
        }

        /// <summary>
        /// 初始化构造
        /// </summary>
        /// <param name="dataBase">数据库操作辅助对象</param>
        public EC_AcceptWayByOrderDAL(Database dataBase)
        {
            _dataBase = dataBase;
        }



        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_AcceptWayByOrder trueModel = model as Model.EC_AcceptWayByOrder;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {	
                    new SqlParameter("@TargetId",trueModel.TargetId ??0),
					new SqlParameter("@City",trueModel.City ??""),
					new SqlParameter("@Accepter",trueModel.Accepter ??""),
					new SqlParameter("@AccepterPhone",trueModel.AccepterPhone ??""),
					new SqlParameter("@AppointCourierCompany",trueModel.AppointCourierCompany ??""),
					new SqlParameter("@AccepterAddress",trueModel.AccepterAddress ??""),
					new SqlParameter("@AccepterPhoneNum",trueModel.AccepterPhoneNum ??""),
					new SqlParameter("@AcceptContacts",trueModel.AcceptContacts ??""),
					new SqlParameter("@FetchAddress",trueModel.FetchAddress ??""),
					new SqlParameter("@FetchPhoneNum",trueModel.FetchPhoneNum ??""),
					new SqlParameter("@FetchContacts",trueModel.FetchContacts ??""),
					new SqlParameter("@InvoiceDemand",trueModel.InvoiceDemand ??""),
                    new SqlParameter("@AcceptTypeId",trueModel.AcceptTypeId ??0),
					new SqlParameter("@Operator",trueModel.Operator ??""),
                    new SqlParameter("@TheAwb",trueModel.TheAwb ??""),
					new SqlParameter("@Remark",trueModel.Remark ??"")
                };
            try
            {
                _dataBase.Query("sp_EC_AcceptWayByOrder_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_AcceptWayByOrder trueModel = model as Model.EC_AcceptWayByOrder;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {	new SqlParameter("@TargetId",trueModel.TargetId),
					new SqlParameter("@City",trueModel.City),
					new SqlParameter("@Accepter",trueModel.Accepter),
					new SqlParameter("@AccepterPhone",trueModel.AccepterPhone),
					new SqlParameter("@AppointCourierCompany",trueModel.AppointCourierCompany),
					new SqlParameter("@AccepterAddress",trueModel.AccepterAddress),
					new SqlParameter("@AccepterPhoneNum",trueModel.AccepterPhoneNum),
					new SqlParameter("@AcceptContacts",trueModel.AcceptContacts),
					new SqlParameter("@FetchAddress",trueModel.FetchAddress),
					new SqlParameter("@FetchPhoneNum",trueModel.FetchPhoneNum),
					new SqlParameter("@FetchContacts",trueModel.FetchContacts),
					new SqlParameter("@InvoiceDemand",trueModel.InvoiceDemand),
                    new SqlParameter("@AcceptTypeId",trueModel.AcceptTypeId),
					new SqlParameter("@Operator",trueModel.Operator),
                    new SqlParameter("@TheAwb",trueModel.TheAwb),
					new SqlParameter("@Remark",trueModel.Remark)
                };
            try
            {
                _dataBase.Query("sp_EC_AcceptWayByOrder_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.EC_AcceptWayByOrder trueModel = model as Model.EC_AcceptWayByOrder;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                {
                    	new SqlParameter("@Keyid",trueModel.Keyid)
                };
            try
            {
                _dataBase.Query("sp_EC_AcceptWayByOrder_DeleteRow", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_AcceptWayByOrder> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 单个查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.EC_AcceptWayByOrder> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 根据TargetId获得收货地址
        /// </summary>
        /// <param name="TargetId">来源id</param>
        /// <returns></returns>
        public Model.EC_AcceptWayByOrder SelectModelByTargetId(int? TargetId)
        {
            if (TargetId == null || TargetId <= 0)
                return null;//错误数据返会空 

            IList<EC_AcceptWayByOrder> result = _dataBase.SelectModel<EC_AcceptWayByOrder>("*", "EC_AcceptWayByOrder", string.Format(" TargetId='{0}' ", TargetId)) as IList<EC_AcceptWayByOrder>;//执行查询

            return (null == result || result.Count == 0) ? null : result[0];//返回结果
        }
    }
}