/// <summary>
/// 库存查询
/// </summary>
/// <param name="loggingSessionInfo">登录信息集合</param>
/// <param name="unit_id">组织标识</param>
/// <param name="warehouse_id">仓库标识</param>
/// <param name="item_code">商品号码</param>
/// <param name="item_name">商品名称</param>
/// <param name="typeValue">类型</param>
/// <param name="yearMonth">年月</param>
/// <param name="maxRowCount">最大数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public StockBalanceInfo SearchStockBalance(LoggingSessionInfo loggingSessionInfo
, string unit_id
, string warehouse_id
, string item_code
, string item_name
, string typeValue
, string yearMonth
, int maxRowCount
, int startRowIndex
)
{
StockBalanceInfo stockBalanceInfo = new StockBalanceInfo();
Hashtable _ht = new Hashtable();
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
_ht.Add("UnitId", unit_id);
_ht.Add("WarehouseId", warehouse_id);
_ht.Add("ItemCode", item_code);
_ht.Add("ItemName", item_name);
_ht.Add("TypeValue", typeValue);
_ht.Add("YearMonth", yearMonth);
int iCount = cSqlMapper.Instance().QueryForObject <int>("StockBalance.SearchCount", _ht);
IList <StockBalanceInfo> stockBalanceInfoList = new List <StockBalanceInfo>();
stockBalanceInfoList = cSqlMapper.Instance().QueryForList <StockBalanceInfo>("StockBalance.Search", _ht);
stockBalanceInfo.icount = iCount;
stockBalanceInfo.StockBalanceInfoList = stockBalanceInfoList;
return(stockBalanceInfo);
}
/// <summary>
/// 根据组织门店获取库存
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="unit_id">组织标识</param>
/// <param name="warehouse_id">门店标识</param>
/// <param name="maxRowCount">最大数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public StockBalanceInfo GetStockBalanceListByUnitIdWarehouseId(LoggingSessionInfo loggingSessionInfo
, string unit_id
, string warehouse_id
, int maxRowCount
, int startRowIndex
)
{
try
{
Hashtable _ht = new Hashtable();
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
_ht.Add("UnitId", unit_id);
_ht.Add("WarehouseId", warehouse_id);
_ht.Add("TypeValue", "1");
StockBalanceInfo stockBalanceInfo = new StockBalanceInfo();
int iCount = cSqlMapper.Instance().QueryForObject <int>("StockBalance.SearchCount", _ht);
IList <StockBalanceInfo> stockBalanceInfoList = new List <StockBalanceInfo>();
stockBalanceInfoList = cSqlMapper.Instance().QueryForList <StockBalanceInfo>("StockBalance.Search", _ht);
stockBalanceInfo.icount = iCount;
stockBalanceInfo.StockBalanceInfoList = stockBalanceInfoList;
return(stockBalanceInfo);
}
catch (Exception ex) {
throw (ex);
}
}
/// <summary>
/// 库存查询
/// </summary>
/// <param name="unit_id">组织标识</param>
/// <param name="warehouse_id">仓库标识</param>
/// <param name="item_name">商品名称</param>
/// <param name="maxRowCount">最大数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public StockBalanceInfo SearchStockBalance(string unit_id
, string warehouse_id
, string item_name
, string sku_id
, int maxRowCount
, int startRowIndex
)
{
StockBalanceInfo stockBalanceInfo = new StockBalanceInfo();
if (item_name == null)
{
item_name = "";
}
Hashtable _ht = new Hashtable();
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
_ht.Add("UnitId", unit_id);
_ht.Add("WarehouseId", warehouse_id);
//_ht.Add("ItemCode", item_code);
_ht.Add("ItemName", item_name);
//_ht.Add("TypeValue", typeValue);
//_ht.Add("YearMonth", yearMonth);
int iCount = stockBalanceService.GetSearchStockBalanceCount(_ht);
IList <StockBalanceInfo> stockBalanceInfoList = new List <StockBalanceInfo>();
DataSet ds = stockBalanceService.GetSearchStockBalanceInfoList(_ht);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
stockBalanceInfoList = DataTableToObject.ConvertToList <StockBalanceInfo>(ds.Tables[0]);
}
stockBalanceInfo.icount = iCount;
stockBalanceInfo.StockBalanceInfoList = stockBalanceInfoList;
return(stockBalanceInfo);
}
/// <summary>
/// 根据组织门店获取库存
/// </summary>
/// <param name="unit_id">组织标识</param>
/// <param name="warehouse_id">门店标识</param>
/// <param name="item_name">商品名称</param>
/// <param name="maxRowCount">最大数量</param>
/// <param name="startRowIndex">开始数量</param>
/// <returns></returns>
public StockBalanceInfo GetStockBalanceListByUnitIdWarehouseId(
string unit_id, string warehouse_id, string item_name,
string sku_id, int maxRowCount, int startRowIndex)
{
try
{
if (item_name == null)
{
item_name = "";
}
Hashtable _ht = new Hashtable();
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
_ht.Add("UnitId", unit_id);
_ht.Add("WarehouseId", warehouse_id);
_ht.Add("SkuId", sku_id);
_ht.Add("ItemName", item_name);
_ht.Add("TypeValue", "1");
StockBalanceInfo stockBalanceInfo = new StockBalanceInfo();
int iCount = stockBalanceService.GetSearchStockBalanceCount(_ht);
IList <StockBalanceInfo> stockBalanceInfoList = new List <StockBalanceInfo>();
DataSet ds = stockBalanceService.GetSearchStockBalanceInfoList(_ht);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
stockBalanceInfoList = DataTableToObject.ConvertToList <StockBalanceInfo>(ds.Tables[0]);
}
stockBalanceInfo.icount = iCount;
stockBalanceInfo.StockBalanceInfoList = stockBalanceInfoList;
return(stockBalanceInfo);
}
catch (Exception ex) {
throw (ex);
}
}
