/// <summary> /// 获取需要打包的库存数量 /// </summary> /// <param name="Customer_Id">客户标识</param> /// <param name="User_Id">用户标识</param> /// <param name="Unit_Id">组织标识</param> /// <returns></returns> public int GetStockBalanceCount(string Customer_Id, string User_Id, string Unit_Id) { LoggingSessionInfo loggingSessionInfo = GetLoggingSessionInfo(Customer_Id, User_Id, Unit_Id); int iCount = 0; StockBalanceService stockBalanceService = new StockBalanceService(); iCount = stockBalanceService.GetStockBalanceCountByUnitId(loggingSessionInfo, Unit_Id); return(iCount); }
/// <summary> /// 需要打包的库存集合 /// </summary> /// <param name="Customer_Id">客户标识</param> /// <param name="User_Id">用户标识</param> /// <param name="Unit_Id">组织标识</param> /// <param name="startRow">开始行</param> /// <param name="rowsCount">每页行数</param> /// <returns>未打包的库存集合</returns> public IList <StockBalanceInfo> GetStockBalanceList(string Customer_Id, string User_Id, string Unit_Id, int startRow, int rowsCount) { IList <StockBalanceInfo> stockBalanceInfoList = new List <StockBalanceInfo>(); LoggingSessionInfo loggingSessionInfo = GetLoggingSessionInfo(Customer_Id, User_Id, Unit_Id); StockBalanceService stockBalanceService = new StockBalanceService(); stockBalanceInfoList = stockBalanceService.GetStockBalanceByUnitId(loggingSessionInfo, Unit_Id, rowsCount, startRow); return(stockBalanceInfoList); }
/// <summary> /// 批量保存调整单 /// </summary> /// <param name="loggingSessionInfo">登录model</param> /// <param name="inoutInfoList">调整单集合</param> /// <returns></returns> public bool SetAJInfoList(LoggingSessionInfo loggingSessionInfo, IList <InoutInfo> inoutInfoList) { MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).BeginTransaction(); string strError = string.Empty; try { bool bReturn = false; foreach (InoutInfo inoutInfo in inoutInfoList) { //新建 bReturn = SetAJInfo(loggingSessionInfo, false, inoutInfo, out strError); if (!bReturn) { break; } //审批 if (new cBillService().CanApproveBill(loggingSessionInfo, "", inoutInfo.order_id)) { bReturn = new InoutService().SetInoutOrderStatus(loggingSessionInfo, inoutInfo.order_id, BillActionType.Approve, out strError); if (!bReturn) { break; } } //影响库存 bReturn = new StockBalanceService().SetStockBalance(loggingSessionInfo, inoutInfo.order_id); if (!bReturn) { break; } } MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).CommitTransaction(); return(true); } catch (Exception ex) { MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).RollBackTransaction(); throw (ex); } }
/// <summary> /// 获取单个SKU库存 /// </summary> public string GetStockNumData() { var stockService = new StockBalanceService(CurrentUserInfo); decimal num = 0; string key = string.Empty; string content = string.Empty; string unit_id = string.Empty; string warehouse_id = string.Empty; if (Request("id") != null && Request("id") != string.Empty) { key = Request("id").ToString().Trim(); } if (Request("unit_id") != null && Request("unit_id") != string.Empty) { unit_id = Request("unit_id").ToString().Trim(); } if (Request("warehouse_id") != null && Request("warehouse_id") != string.Empty) { warehouse_id = Request("warehouse_id").ToString().Trim(); } var stockInfo = stockService.GetStockBalanceListByUnitIdWarehouseId(unit_id, warehouse_id, null, key, 1, 0); if (stockInfo != null && stockInfo.StockBalanceInfoList != null && stockInfo.StockBalanceInfoList.Count > 0) { num = stockInfo.StockBalanceInfoList[0].end_qty; } var jsonData = new JsonData(); jsonData.totalCount = "1"; jsonData.data = num; content = jsonData.ToJSON(); return(content); }