/**  
* OA_VisitNoteDAL.cs
*
* 功 能： 订单回访信息数据访问接口实现类
* 类 名： OA_VisitNoteDAL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-5-21 16:10      吴崎均   初版
* V0.02  2013-5-21 16:50      吴崎均   增加更新回访记录方法、根据订单编号获取回访记录
*
*
*
*
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using CY.Model;
using System.Data.SqlClient;
using System.Data;

namespace CY.SQLDAL
{
    /// <summary>
    /// 订单回访信息数据访问接口实现类
    /// </summary>
    public class OA_VisitNoteDAL : IOA_VisitNoteDAL
    {
        Database _dataBase = null;
        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_VisitNoteDAL()
        {
            _dataBase = new Database();
        }

        #region 废代码

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

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

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

        public IEnumerable<Model.OA_VisitNote> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        public IEnumerable<Model.OA_VisitNote> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }
        #endregion

        /// <summary>
        /// 更新回访记录
        /// </summary>
        /// <param name="visitNote">回访记录</param>
        /// <returns></returns>
        public bool UpdateVisitNote(OA_VisitNote visitNote)
        {
            if (visitNote == null)
            {
                return false;
            }
            else { }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                new SqlParameter("@Keyid",visitNote.Keyid){SqlDbType=System.Data.SqlDbType.Int},
                new SqlParameter("@IsVisited",visitNote.IsVisited){SqlDbType=System.Data.SqlDbType.Bit},
                new SqlParameter("@Scores",visitNote.Scores){SqlDbType=System.Data.SqlDbType.VarChar,Size=30},
                new SqlParameter("@Reason",visitNote.Reason){SqlDbType=System.Data.SqlDbType.VarChar,Size=300},
                new SqlParameter("@Advice",visitNote.Advice){SqlDbType=System.Data.SqlDbType.VarChar,Size=300},
                new SqlParameter("@Operator",visitNote.Operator){SqlDbType=System.Data.SqlDbType.VarChar,Size=20}
            };
            try
            {
                _dataBase.Query("sp_OA_VisitNote_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;

        }
        /// <summary>
        /// 根据订单编号获取回访记录
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <returns></returns>
        public OA_VisitNote SelectVisitNoteById(int orderId)
        {

            if (0 >= orderId) return null; else ;
            List<OA_VisitNote> result = null;
            try
            {
                using (IDataReader reader = _dataBase.QueryDataReader("sp_OA_VisitNote_SelectRow", CommandType.StoredProcedure, new SqlParameter("@orderId", orderId)))
                {
                    result = _dataBase.ReadDataToModel<OA_VisitNote>(reader);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return null == result || 0 == result.Count ? null : result[0];

        }
    }
}