宜昌华友成品库管理软件
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

49 lines
1.4 KiB

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;
}
}
}