/**
|
* EC_OrderPrintParameterDAL.cs
|
*
|
* 功 能： 订单印刷参数操作SQL实现
|
* 类 名： EC_OrderPrintParameterDAL
|
*
|
* Ver 变更日期 负责人 变更内容
|
* ───────────────────────────────────
|
* V0.01 2013-5-6 周刚 添加方法
|
* V0.02 2013-6-1 14:02 吴崎均 增加修改信息方法
|
*
|
*/
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IDAL.EC;
|
using CY.Model;
|
using System.Xml;
|
using System.Data.SqlTypes;
|
using System.Data.SqlClient;
|
using System.Data;
|
|
namespace CY.SQLDAL
|
{
|
/// <summary>
|
/// 订单印刷参数操作接口--SQL实现
|
/// </summary>
|
public class EC_OrderPrintParameterDAL : IEC_OrderPrintParameterDAL
|
{
|
private Database _dataBase = null;
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public EC_OrderPrintParameterDAL()
|
{
|
_dataBase = new Database();
|
}
|
/// <summary>
|
/// 初始化构造(外部)
|
/// </summary>
|
/// <param name="dataBase"></param>
|
public EC_OrderPrintParameterDAL(Database dataBase)
|
{
|
_dataBase = dataBase;
|
}
|
/// <summary>
|
/// 根据编号获取订单印刷选项对象
|
/// </summary>
|
/// <param name="orderId"></param>
|
/// <returns></returns>
|
public Model.EC_OrderPrintParameter GetModel(int orderId)
|
{
|
string condition = string.Empty;
|
condition = " orderId=" + orderId;
|
IList<EC_OrderPrintParameter> result = _dataBase.SelectModel<EC_OrderPrintParameter>("*", "EC_OrderPrintParameter", condition);
|
return null == result || result.Count == 0 ? null : result[0];
|
}
|
/// <summary>
|
/// 添加订单印刷选项
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_OrderPrintParameter trueModel = model as Model.EC_OrderPrintParameter;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
|
using (XmlTextReader rdr = new XmlTextReader(trueModel.PrintParameter, XmlNodeType.Document, null))
|
{
|
|
SqlXml sqlXml = new SqlXml(rdr);
|
SqlParameter printPar = new SqlParameter("@PrintParameter", SqlDbType.Xml, sqlXml.Value.Length);
|
printPar.Value = sqlXml;
|
SqlParameter[] parameters = {
|
new SqlParameter("@OrderId", SqlDbType.Int,4),
|
printPar
|
};
|
parameters[0].Value = trueModel.OrderId;
|
try
|
{
|
_dataBase.Query("EC_OrderPrintParameter_ADD", CommandType.StoredProcedure, parameters);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
return true;
|
}
|
/// <summary>
|
/// 修改订单印刷选项
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
|
{ Model.EC_OrderPrintParameter trueModel = model as Model.EC_OrderPrintParameter;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
|
using (XmlTextReader rdr = new XmlTextReader(trueModel.PrintParameter, XmlNodeType.Document, null))
|
{
|
|
SqlXml sqlXml = new SqlXml(rdr);
|
SqlParameter printPar = new SqlParameter("@PrintParameter", SqlDbType.Xml, sqlXml.Value.Length);
|
printPar.Value = sqlXml;
|
SqlParameter[] parameters = {
|
new SqlParameter("@OrderId", SqlDbType.Int,4),
|
printPar
|
};
|
parameters[0].Value = trueModel.OrderId;
|
try
|
{
|
_dataBase.Query("sp_EC_OrderPrintParameter_Update", CommandType.StoredProcedure, parameters);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
return true;
|
|
}
|
|
public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
throw new NotImplementedException();
|
}
|
}
|
}
|
