/**   
* 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
}