/// <summary>
/// 根据库房获得对应库位的筛选条件
/// </summary>
/// <param name="sWHID">WHID</param>
/// <returns></returns>
public string GetBINIDFilter(string sWHID)
{
// 库位数据实体类
DataEntity.DAEBIBIN dAEBIBIN = new DataEntity.DAEBIBIN();
string sFilter = string.Empty;
// 查询
string sBINIDs = dAEBIBIN.GetAllBINIDByWHID(sWHID);
if (sBINIDs.Length > 0)
{
sFilter = "WH_BI_BIN.BINID IN ( " + sBINIDs + " )";
}
return(sFilter);
}
/// <summary>
/// 获得库房ID的筛选条件
/// </summary>
public string GetWHIDFilter()
{
// 库位数据实体类
DataEntity.DAEBIBIN dAEBIBIN = new DataEntity.DAEBIBIN();
string sFilter = string.Empty;
// 查询
string sWHIDs = dAEBIBIN.GetWHHasBIN();
if (sWHIDs.Length > 0)
{
sFilter = " WH_BI_WareHouse.WHID IN ( " + sWHIDs + ")";
}
return(sFilter);
}