/**
|
* EC_DemandPrintParameterDAL.cs
|
*
|
* 功 能： 需求印刷参数操作SQL实现
|
* 类 名： EC_DemandPrintParameterDAL
|
*
|
* Ver 变更日期 负责人 变更内容
|
* ───────────────────────────────────
|
* V0.01 2013-5-22 11:57 吴崎均 初版
|
* V0.02 2013-6-1 14:00 吴崎均 增加修改与根据编号获取信息方法
|
*
|
*/
|
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_DemandPrintParameterDAL
|
{
|
private Database _dataBase = null;
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public EC_DemandPrintParameterDAL()
|
{
|
_dataBase = new Database();
|
}
|
/// <summary>
|
/// 初始化构造(外部参数)
|
/// </summary>
|
/// <param name="dataBase"></param>
|
public EC_DemandPrintParameterDAL(Database dataBase)
|
{
|
_dataBase = dataBase;
|
}
|
|
|
/// <summary>
|
/// 增加需求印刷选项
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_DemandPrintParameter trueModel = model as Model.EC_DemandPrintParameter;
|
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("@TargetId", SqlDbType.Int,4),
|
printPar
|
};
|
parameters[0].Value = trueModel.TargetId;
|
try
|
{
|
_dataBase.Query("sp_EC_DemandPrintParameter_Insert", 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_DemandPrintParameter trueModel = model as Model.EC_DemandPrintParameter;
|
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("@TargetId", SqlDbType.Int,4),
|
printPar
|
};
|
parameters[0].Value = trueModel.TargetId;
|
try
|
{
|
_dataBase.Query("sp_EC_DemandPrintParameter_Update", CommandType.StoredProcedure, parameters);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 获取需求印刷选项对象
|
/// </summary>
|
/// <param name="demandId"></param>
|
/// <returns></returns>
|
public Model.EC_DemandPrintParameter GetModel(int demandId)
|
{
|
string condition = string.Empty;
|
condition = " TargetId=" + demandId;
|
IList<EC_DemandPrintParameter> result = _dataBase.SelectModel<EC_DemandPrintParameter>("*", "EC_DemandPrintParameter", condition);
|
return null == result || result.Count == 0 ? null : result[0];
|
}
|
|
}
|
}
|
