/**
|
* LF_OrderFileDAL.cs
|
*
|
* 功 能： 卖家文件空间扩展类
|
* 类 名： LF_OrderFileDAL
|
*
|
* Ver 变更日期 负责人 变更内容
|
* ───────────────────────────────────
|
* V0.01 2013-6-17 16:26 吴崎均 初版
|
*
|
*/
|
using System;
|
using System.Data;
|
using System.Text;
|
using System.Data.SqlClient;
|
using CY.Infrastructure.Domain;
|
using CY.Model;
|
using CY.SQLDAL;
|
using System.Collections.Generic;
|
namespace CY.SQLDAL
|
{
|
/// <summary>
|
/// 数据访问类:LF_OrderFiles
|
/// </summary>
|
public partial class LF_SellerFileSpaceDAL
|
{
|
|
Database _dataBase;
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public LF_SellerFileSpaceDAL()
|
{
|
_dataBase = new Database();
|
}
|
#region BasicMethod
|
|
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(IAggregateRoot model)
|
{
|
LF_SellerFileSpace orderFile = model as LF_SellerFileSpace;
|
SqlParameter[] parameters = {
|
new SqlParameter("@returnValue", SqlDbType.Int,4),
|
new SqlParameter("@SellerId", SqlDbType.UniqueIdentifier,16),
|
new SqlParameter("@SpaceName", SqlDbType.VarChar,50),
|
new SqlParameter("@Operator", SqlDbType.VarChar,50)};
|
parameters[0].Value = Guid.NewGuid();
|
parameters[3].Value = orderFile.SpaceName;
|
parameters[5].Value = orderFile.Operator;
|
|
try
|
{
|
_dataBase.Query("sp_LF_SellerFileSpace_Insert", CommandType.StoredProcedure, parameters);
|
return 1.Equals(parameters[0].Value);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
|
|
}
|
/// <summary>
|
/// 更新一条数据
|
/// </summary>
|
public bool UpdateModel(IAggregateRoot model)
|
{
|
LF_SellerFileSpace orderFile = model as LF_SellerFileSpace;
|
SqlParameter[] parameters = {
|
new SqlParameter("@returnValue", SqlDbType.Int,4),
|
new SqlParameter("@SellerId", SqlDbType.UniqueIdentifier,16),
|
new SqlParameter("@AllotSize", SqlDbType.Decimal,5),
|
new SqlParameter("@SpaceLevel", SqlDbType.Int,4),
|
new SqlParameter("@Operator", SqlDbType.VarChar,50)};
|
parameters[0].Value = Guid.NewGuid();
|
parameters[1].Value = orderFile.AllotSize;
|
parameters[2].Value = orderFile.SpaceName;
|
parameters[3].Value = orderFile.SpaceLevel.HasValue?orderFile.SpaceLevel:0;
|
parameters[4].Value = orderFile.Operator;
|
|
try
|
{
|
_dataBase.Query("sp_LF_SellerFileSpace_Update", CommandType.StoredProcedure, parameters);
|
return 1.Equals(parameters[0].Value);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
|
}
|
|
/// <summary>
|
/// 删除一条数据
|
/// </summary>
|
public bool Delete(Guid sellerId)
|
{
|
|
|
SqlParameter[] parameters = { new SqlParameter("@returnValue", SqlDbType.Int, 4), new SqlParameter("@SellerId", SqlDbType.UniqueIdentifier) };
|
parameters[1].Value = sellerId;
|
try
|
{
|
|
_dataBase.Query("sp_LF_SellerFileSpace_DeleteRow", CommandType.StoredProcedure, parameters);
|
return 1.Equals(parameters[0].Value);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
|
}
|
|
/// <summary>
|
/// 得到一个对象实体
|
/// </summary>
|
public LF_OrderFile GetModel(Guid sellerId)
|
{
|
|
List<LF_OrderFile> result = null;
|
try
|
{
|
|
using (IDataReader dataReader = _dataBase.QueryDataReader("sp_LF_SellerFileSpace_SelectRow", CommandType.StoredProcedure, new SqlParameter("@SellerId", sellerId)))
|
{
|
result = _dataBase.ReadDataToModel<LF_OrderFile>(dataReader);
|
}
|
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
|
return null == result || 0 == result.Count ? null : result[0];
|
}
|
|
|
}
|
|
#endregion BasicMethod
|
}
|
