public static DataTable GetClientJXCSummary(int Month, int OrganizeCity, int ClientType)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetClientJXCSummary(Month, OrganizeCity, ClientType, 0, 0));
}
public static DataTable GetClientJXCSummary_BySupplier(int Month, int Supplier)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetClientJXCSummary(Month, 0, 0, Supplier, 0));
}
/// <summary>
/// 查询库存中的产品物流码
/// </summary>
/// <param name="WareHouse"></param>
/// <param name="DisplayMode">1:按产品统计 2:按箱码统计 3:产品码明细</param>
/// <returns></returns>
public static DataTable GetCodeLib(int WareHouse, int DisplayMode)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetCodeLib(WareHouse, DisplayMode, 0, "", 0));
}
/// <summary>
/// 查询门店进销存
/// </summary>
public static DataTable GetClientJXC(int Retailer)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetClientJXC(Retailer));
}
public INV_InventoryBLL(int id, bool bycache)
: base(DALClassName)
{
_dal = (INV_InventoryDAL)_DAL;
FillModel(id, bycache);
}
/// <summary>
/// 获取指定客户两年以内指定产品所有的库存批号信息（以便销售退货时可以选择判断）
/// </summary>
/// <param name="Client"></param>
/// <param name="Product"></param>
/// <returns></returns>
public static IList <INV_Inventory> GetListByClientAndProduct(int Client, int Product)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetListByClientAndProduct(Client, Product));
}
/// <summary>
/// 获取指定客户所有批号某产品的价格
/// </summary>
/// <param name="Client"></param>
/// <param name="Product"></param>
/// <returns></returns>
public static decimal GetClientPriceByProduct(int Client, int Product)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetPriceByProduct(Client, Product, 0, ""));
}
public INV_InventoryBLL(int id)
: base(DALClassName)
{
_dal = (INV_InventoryDAL)_DAL;
FillModel(id);
}
/// <summary>
/// 获取指定客户指定批号某产品的库存数量
/// </summary>
/// <param name="Client"></param>
/// <param name="Product"></param>
/// <param name="LotNumber"></param>
/// <returns></returns>
public static int GetClientQuantityByProduct(int Client, int Product, string LotNumber)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetQuantityByProduct(Client, Product, 0, LotNumber));
}
/// <summary>
/// 获取指定仓库所有批号某产品的库存数量
/// </summary>
/// <param name="WareHouse"></param>
/// <param name="Product"></param>
/// <returns></returns>
public static int GetWareHouseQuantityByProduct(int WareHouse, int Product)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetQuantityByProduct(0, Product, WareHouse, ""));
}
/// <summary>
/// 根据产品物流码扣减门店库存
/// </summary>
/// <param name="PieceCode">物流码</param>
/// <param name="InvCodeLibState">9:零售 10:礼品兑换 11:作废 12:直销配货</param>
/// <returns>0:成功 -1:物流码无效 -2:状态不为在库状态</returns>
public static int DecreaseByPieceCode(string PieceCode, int InvCodeLibState)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.DecreaseByPieceCode(PieceCode, InvCodeLibState));
}
public static int DecreaseQuantity(int WareHouse, int Product, int Quantity)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.DecreaseQuantity(WareHouse, Product, Quantity, ""));
}
/// <summary>
/// 获取指定客户所有仓库内指定产品及批号的库存信息（以便销售退货时可以选择判断）
/// </summary>
/// <param name="Client"></param>
/// <param name="Product"></param>
/// <param name="LotNumber"></param>
/// <returns></returns>
public static INV_Inventory GetInventoryByClientAndProduct(int Client, int Product, string LotNumber)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetInventoryByClientAndProduct(Client, Product, LotNumber));
}
public static DataTable GetClientJXCSummary_ByClient(int Client)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetClientJXCSummary(0, 0, 0, 0, Client));
}
/// <summary>
/// 获取指定仓库所有批号某产品的价格
/// </summary>
/// <param name="WareHouse"></param>
/// <param name="Product"></param>
/// <returns></returns>
public static decimal GetWareHousePriceByProduct(int WareHouse, int Product)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetPriceByProduct(0, Product, WareHouse, ""));
}
/// <summary>
/// 根据物流码查询追溯
/// </summary>
/// <param name="PieceCode"></param>
/// <returns></returns>
public static DataTable TraceQuery(string PieceCode)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.TraceQuery(PieceCode));
}
/// <summary>
/// 查询库存中的产品物流码
/// </summary>
/// <param name="WareHouse"></param>
/// <param name="DisplayMode">1:按产品统计 2:按箱码统计 3:产品码明细</param>
/// <param name="Product"></param>
/// <param name="LotNumber"></param>
/// <param name="State"></param>
/// <returns></returns>
public static DataTable GetCodeLib(int WareHouse, int DisplayMode, int Product, string LotNumber, int State)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetCodeLib(WareHouse, DisplayMode, Product, LotNumber, State));
}
/// <summary>
/// 获取客户库存明细(含有效期信息)
/// </summary>
/// <param name="Client"></param>
/// <param name="WareHouse">仓库</param>
/// <param name="PDTBrand">产品品牌</param>
/// <param name="PDTClassify">产品系列</param>
/// <param name="Product">产品</param>
/// <returns></returns>
public static DataTable GetProductList(int OrganizeCity, int ClientType, int Supplier, int Client, int WareHouse, int PDTBrand, int PDTClassify, int Product)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetProductList(OrganizeCity, ClientType, Supplier, Client, WareHouse, PDTBrand, PDTClassify, Product));
}
///<summary>
///INV_InventoryBLL
///</summary>
public INV_InventoryBLL()
: base(DALClassName)
{
_dal = (INV_InventoryDAL)_DAL;
_m = new INV_Inventory();
}
public static int IncreaseQuantity(int WareHouse, int Product, int Quantity, string LotNumber)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.IncreaseQuantity(WareHouse, Product, Quantity, LotNumber));
}
/// <summary>
/// 查询指定客户的所有仓库内某产品的库存（不限批号）
/// </summary>
/// <param name="Client"></param>
/// <param name="Product"></param>
/// <returns>库存数量</returns>
public static int GetProductQuantityAllWareHouse(int Client, int Product)
{
INV_InventoryDAL dal = (INV_InventoryDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetProductQuantityAllWareHouse(Client, Product, ""));
}
