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_SpecialForumsDAL : IEC_SpecialForumsDAL
|
{
|
|
private Database _dataBase = null;
|
|
public EC_SpecialForumsDAL()
|
{
|
_dataBase = new Database();
|
}
|
|
public EC_SpecialForumsDAL(Database database)
|
{
|
_dataBase = database;
|
}
|
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_SpecialForums trueModel = model as Model.EC_SpecialForums;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@SpecialOrderId",trueModel.SpecialOrderId),
|
new SqlParameter("@PSF_Forumsid",trueModel.PSF_Forumsid),
|
new SqlParameter("@PSF_Component",trueModel.PSF_Component),
|
new SqlParameter("@PSF_PNum",trueModel.PSF_PNum),
|
new SqlParameter("@PSF_PressesDesk",trueModel.PSF_PressesDesk),
|
new SqlParameter("@PSF_PrintedColorPositive",trueModel.PSF_PrintedColorPositive),
|
new SqlParameter("@PSF_PrintedColorRear",trueModel.PSF_PrintedColorRear),
|
new SqlParameter("@PSF_Typesetting",trueModel.PSF_Typesetting),
|
new SqlParameter("@PSF_PrintedPositive",trueModel.PSF_PrintedPositive),
|
new SqlParameter("@PSF_PrintedCount",trueModel.PSF_PrintedCount),
|
new SqlParameter("@PSF_LastNum",trueModel.PSF_LastNum),
|
new SqlParameter("@PSF_PaperSource",trueModel.PSF_PaperSource),
|
new SqlParameter("@PSF_PaperName",trueModel.PSF_PaperName),
|
new SqlParameter("@PSF_MaterialSpecifications",trueModel.PSF_MaterialSpecifications),
|
new SqlParameter("@PSF_BigPaperCount",trueModel.PSF_BigPaperCount),
|
new SqlParameter("@PSF_OpenSpecifications",trueModel.PSF_OpenSpecifications),
|
new SqlParameter("@PSF_OpenWidth",trueModel.PSF_OpenWidth),
|
new SqlParameter("@PSF_OpenLength",trueModel.PSF_OpenLength),
|
new SqlParameter("@PSF_PlateSource",trueModel.PSF_PlateSource),
|
new SqlParameter("@PSF_CTPSpecType",trueModel.PSF_CTPSpecType),
|
new SqlParameter("@PSF_FilmType",trueModel.PSF_FilmType),
|
new SqlParameter("@PSF_CTPCount",trueModel.PSF_CTPCount),
|
new SqlParameter("@PSF_PSSpec",trueModel.PSF_PSSpec),
|
new SqlParameter("@PSF_PSCount",trueModel.PSF_PSCount),
|
new SqlParameter("@PSF_Note",trueModel.PSF_Note),
|
new SqlParameter("@PSF_PaperId",trueModel.PSF_PaperId)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_SpecialForums_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_SpecialForums trueModel = model as Model.EC_SpecialForums;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@Keyid",trueModel.Keyid),
|
new SqlParameter("@SpecialOrderId",trueModel.SpecialOrderId),
|
new SqlParameter("@PSF_Forumsid",trueModel.PSF_Forumsid),
|
new SqlParameter("@PSF_Component",trueModel.PSF_Component),
|
new SqlParameter("@PSF_PNum",trueModel.PSF_PNum),
|
new SqlParameter("@PSF_PressesDesk",trueModel.PSF_PressesDesk),
|
new SqlParameter("@PSF_PrintedColorPositive",trueModel.PSF_PrintedColorPositive),
|
new SqlParameter("@PSF_PrintedColorRear",trueModel.PSF_PrintedColorRear),
|
new SqlParameter("@PSF_Typesetting",trueModel.PSF_Typesetting),
|
new SqlParameter("@PSF_PrintedPositive",trueModel.PSF_PrintedPositive),
|
new SqlParameter("@PSF_PrintedCount",trueModel.PSF_PrintedCount),
|
new SqlParameter("@PSF_LastNum",trueModel.PSF_LastNum),
|
new SqlParameter("@PSF_PaperSource",trueModel.PSF_PaperSource),
|
new SqlParameter("@PSF_PaperName",trueModel.PSF_PaperName),
|
new SqlParameter("@PSF_MaterialSpecifications",trueModel.PSF_MaterialSpecifications),
|
new SqlParameter("@PSF_BigPaperCount",trueModel.PSF_BigPaperCount),
|
new SqlParameter("@PSF_OpenSpecifications",trueModel.PSF_OpenSpecifications),
|
new SqlParameter("@PSF_OpenWidth",trueModel.PSF_OpenWidth),
|
new SqlParameter("@PSF_OpenLength",trueModel.PSF_OpenLength),
|
new SqlParameter("@PSF_PlateSource",trueModel.PSF_PlateSource),
|
new SqlParameter("@PSF_CTPSpecType",trueModel.PSF_CTPSpecType),
|
new SqlParameter("@PSF_FilmType",trueModel.PSF_FilmType),
|
new SqlParameter("@PSF_CTPCount",trueModel.PSF_CTPCount),
|
new SqlParameter("@PSF_PSSpec",trueModel.PSF_PSSpec),
|
new SqlParameter("@PSF_PSCount",trueModel.PSF_PSCount),
|
new SqlParameter("@PSF_Note",trueModel.PSF_Note),
|
new SqlParameter("@PSF_PaperId",trueModel.PSF_PaperId)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_SpecialForums_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_SpecialForums trueModel = model as Model.EC_SpecialForums;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@Keyid",trueModel.Keyid)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_SpecialForums_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_SpecialForums> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
|
{
|
throw new NotImplementedException();
|
}
|
|
/// <summary>
|
/// 单个查询
|
/// </summary>
|
/// <param name="query"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.EC_SpecialForums> SelectAllModel(Infrastructure.Query.Query query)
|
{
|
throw new NotImplementedException();
|
}
|
|
}
|
}
|
