using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IDAL.Inquiry;
|
using CY.Model;
|
using System.Data.SqlClient;
|
using System.Data;
|
using System.Transactions;
|
using CY.Infrastructure.Common;
|
namespace CY.SQLDAL
|
{
|
/// <summary>
|
/// 纸张类别相关操作--SQL数据库操作
|
/// </summary>
|
public class PaperTypeDAL : IPaperTypeDAL
|
{
|
|
private Database _dataBase = null;
|
|
public PaperTypeDAL()
|
{
|
_dataBase = new Database();
|
}
|
|
/// <summary>
|
/// 新增纸张类别
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.SysInquiry_PaperType trueModel = model as Model.SysInquiry_PaperType;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
SqlParameter[] parameters = {
|
new SqlParameter("@PaperTypeName", SqlDbType.VarChar,50),
|
new SqlParameter("@Status", SqlDbType.Int,4),
|
new SqlParameter("@OrderNum", SqlDbType.Int,4)};
|
parameters[0].Value = trueModel.PaperTypeName;
|
parameters[1].Value = trueModel.Status;
|
parameters[2].Value = trueModel.OrderNum;
|
try
|
{
|
_dataBase.Query("SysInquiry_PaperType_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)
|
{
|
bool isSuccess = true;
|
PaperInfoDAL _paperInfoDAL = new PaperInfoDAL(_dataBase);
|
using (TransactionScope scope = new TransactionScope())
|
{
|
Model.SysInquiry_PaperType trueModel = model as Model.SysInquiry_PaperType;
|
if (trueModel == null)
|
{
|
isSuccess = false;
|
}
|
else
|
{
|
SqlParameter[] parameters = {
|
new SqlParameter("@PaperTypeName", SqlDbType.VarChar,50),
|
new SqlParameter("@Status", SqlDbType.Int,4),
|
new SqlParameter("@OrderNum", SqlDbType.Int,4),
|
new SqlParameter("@KeyId", SqlDbType.Int,4)};
|
parameters[0].Value = trueModel.PaperTypeName;
|
parameters[1].Value = trueModel.Status;
|
parameters[2].Value = trueModel.OrderNum;
|
parameters[3].Value = trueModel.KeyId;
|
try
|
{
|
_dataBase.Query("SysInquiry_PaperType_Update", CommandType.StoredProcedure, parameters);
|
isSuccess = true;
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
if (isSuccess)
|
{
|
SysInquiry_PaperInfo paperModel = new SysInquiry_PaperInfo();
|
paperModel.PaperTypeId = trueModel.KeyId;
|
if (trueModel.Status == 1)
|
{
|
paperModel.Status = true;
|
}
|
else
|
{
|
paperModel.Status = false;
|
}
|
isSuccess = _paperInfoDAL.UpdatePaperStatus(paperModel);
|
}
|
if (isSuccess)
|
scope.Complete();
|
}
|
}
|
return isSuccess;
|
}
|
/// <summary>
|
/// 删除纸张类别
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
return false;
|
}
|
|
/// <summary>
|
/// 分页返回纸张类别列表
|
/// </summary>
|
/// <param name="brandName">类别名称</param>
|
/// <param name="pagination">分页参数</param>
|
/// <returns></returns>
|
public IEnumerable<Model.SysInquiry_PaperType> SelectModelPage(string typeName,int status,Infrastructure.Query.Pagination pagination)
|
{
|
string condition=string.Empty;
|
condition = " 1=1 ";
|
if (!string.IsNullOrEmpty(typeName))
|
{
|
condition = " and PaperTypeName like '%" + typeName + "%'";
|
}
|
if (status != -1)
|
{
|
condition += " and Status=" + status;
|
}
|
return _dataBase.SelectModelPage<SysInquiry_PaperType>(pagination, "*", "SysInquiry_PaperType", "OrderNum", "OrderNum", condition);
|
}
|
|
/// <summary>
|
/// 根据主键返回品牌实体
|
/// </summary>
|
/// <param name="keyid">主键ID</param>
|
/// <returns>品牌实体</returns>
|
public SysInquiry_PaperType SelectModelByKey(int keyid)
|
{
|
string condition=string.Empty;
|
condition=" KeyId="+keyid;
|
IList<SysInquiry_PaperType> result = _dataBase.SelectModel<SysInquiry_PaperType>("*", "SysInquiry_PaperType", condition);
|
return null == result || result.Count == 0 ? null : result[0];
|
}
|
|
/// <summary>
|
/// 判断是否有相同的纸张类别名称
|
/// </summary>
|
/// <param name="brandName"></param>
|
/// <returns></returns>
|
public bool IsExistsPaperTypeName(string typeName)
|
{
|
string condition=string.Empty;
|
condition = " PaperTypeName='" + typeName + "'";
|
IList<SysInquiry_PaperType> result = _dataBase.SelectModel<SysInquiry_PaperType>("*", "SysInquiry_PaperType", condition);
|
if(result!=null&&result.Count!=0)
|
{
|
return true;
|
}
|
else
|
{
|
return false;
|
}
|
}
|
|
|
/// <summary>
|
/// 返回所有有效的纸张类别列表
|
/// </summary>
|
/// <returns></returns>
|
public IEnumerable<SysInquiry_PaperType> GetPaperTypeList()
|
{
|
string condition = string.Empty;
|
condition = " Status=1 order by OrderNum ";
|
IList<SysInquiry_PaperType> result = _dataBase.SelectModel<SysInquiry_PaperType>("*", "SysInquiry_PaperType", condition);
|
return result;
|
}
|
|
/// <summary>
|
/// 获取最新排序顺序
|
/// </summary>
|
/// <returns></returns>
|
public int GetOrderNumByMax()
|
{
|
int orderNum = 1;
|
IList<SysInquiry_PaperType> result = _dataBase.SelectModel<SysInquiry_PaperType>(" MAX(OrderNum)+1 AS OrderNum ", "SysInquiry_PaperType", string.Empty);
|
if (result != null && result.Count > 0)
|
{
|
orderNum = result[0].OrderNum.Value;
|
}
|
return orderNum;
|
}
|
}
|
}
|
