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