public GoodsSiteModel GetGoodsSite(EnumStoreHouse storeHouse, int rowth, int columnth, int layerth)
{
GoodsSiteModel goodsSite = null;
string whereStr = "";
List <GoodsSiteModel> goodsSiteList = null;
if (storeHouse == EnumStoreHouse.A1库房)
{
whereStr = "GoodsSiteRow = " + rowth + " and GoodsSiteColumn = " + columnth + " and GoodsSiteLayer ="
+ layerth + " and LogicStoreAreaID = 4 and GoodsSiteRunStatus != '" + EnumGSRunStatus.异常.ToString() + "'";
}
else if (storeHouse == EnumStoreHouse.B1库房)
{
whereStr = "GoodsSiteRow = " + rowth + " and GoodsSiteColumn = " + columnth + " and GoodsSiteLayer ="
+ layerth + " and LogicStoreAreaID = 2 and GoodsSiteRunStatus != '" + EnumGSRunStatus.异常.ToString() + "'";;
}
goodsSiteList = GetModelList(whereStr);
if (goodsSiteList.Count > 0)
{
goodsSite = goodsSiteList[0];
}
return(goodsSite);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ECAMSDataAccess.GoodsSiteModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ECAMSDataAccess.GoodsSiteModel model)
{
return(dal.Add(model));
}