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
|
{
|
public class EC_AcceptWayByCustomersDAL : IEC_AcceptWayByCustomersDAL
|
{
|
|
private Database _dataBase = null;
|
|
public EC_AcceptWayByCustomersDAL()
|
{
|
_dataBase = new Database();
|
}
|
|
public EC_AcceptWayByCustomersDAL(Database database)
|
{
|
_dataBase = database;
|
}
|
|
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_AcceptWayByCustomers trueModel = model as Model.EC_AcceptWayByCustomers;
|
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("@Operator",trueModel.Operator),
|
new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
|
new SqlParameter("@AcceptTypeId",trueModel.AcceptTypeId),
|
new SqlParameter("@Remark",trueModel.Remark)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_AcceptWayByCustomers_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_AcceptWayByCustomers trueModel = model as Model.EC_AcceptWayByCustomers;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{new SqlParameter("@Keyid",trueModel.Keyid),
|
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("@Operator",trueModel.Operator),
|
new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
|
new SqlParameter("@AcceptTypeId",trueModel.AcceptTypeId),
|
new SqlParameter("@Remark",trueModel.Remark)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_AcceptWayByCustomers_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_AcceptWayByCustomers trueModel = model as Model.EC_AcceptWayByCustomers;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@Keyid",trueModel.Keyid)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_AcceptWayByCustomers_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_AcceptWayByCustomers> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
|
{
|
throw new NotImplementedException();
|
}
|
|
/// <summary>
|
/// 单个查询
|
/// </summary>
|
/// <param name="query"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.EC_AcceptWayByCustomers> SelectAllModel(Infrastructure.Query.Query query)
|
{
|
throw new NotImplementedException();
|
}
|
|
/// <summary>
|
/// 根据TargetId获得收货地址
|
/// </summary>
|
/// <param name="TargetId">来源id</param>
|
/// <returns></returns>
|
public Model.EC_AcceptWayByCustomers SelectModelByTargetId(Guid TargetId)
|
{
|
if (TargetId == null)
|
return null;//错误数据返会空
|
|
IList<EC_AcceptWayByCustomers> result = _dataBase.SelectModel<EC_AcceptWayByCustomers>("*", "EC_AcceptWayByCustomers", string.Format(" TargetId='{0}' ", TargetId)) as IList<EC_AcceptWayByCustomers>;//执行查询
|
|
return (null == result || result.Count == 0) ? null : result[0];//返回结果
|
}
|
}
|
}
|
