/**
|
* 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];//返回结果
|
}
|
}
|
}
|
