using System;
using System.Linq;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.ServiceModel;
using SiaSun.LMS.Model;
using System.Reflection;

namespace SiaSun.LMS.Implement
{
    [ServiceBehavior(IncludeExceptionDetailInFaults = true, 
     InstanceContextMode = InstanceContextMode.Single, 
     ConcurrencyMode = ConcurrencyMode.Multiple, 
     MaxItemsInObjectGraph = int.MaxValue)]
    public partial class S_StorageService : S_BaseService, SiaSun.LMS.Interface.I_StorageService
    {
        public S_StorageService()
        {
        }
        /// <summary>
        /// 校验托盘是否是指定库存类型
        /// </summary>
        /// <param name="STOCK_BARCODE"></param>
        /// <param name="AREA_TYPE"></param>
        /// <param name="sResult"></param>
        /// <returns></returns>
        public bool StorageCheck(string STOCK_BARCODE,
                                 string AREA_TYPE,
                                 out string sResult)
        {
            bool bResult = true;

            sResult = string.Empty;

            DataTable dt = this.GetList(string.Format("SELECT * FROM V_STORAGE_LIST WHERE STOCK_BARCODE='{0}' AND AREA_TYPE = '{1}' ", STOCK_BARCODE, AREA_TYPE.ToString()));

            if (dt.Rows.Count == 0)
            {
                bResult =false;            
            }

            return bResult;
        }



    }
}