/**
|
* 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];
|
|
}
|
}
|
}
|
