BaoKai_202508-Wms-Jingwang.ChenPin-Jiangxi/WMS.IData/IStock/IMIStock.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.Model.Stock;
using System.Data;

namespace WMS.IData.IStock
{
    /// <summary>
    /// 库存表
    /// </summary>
    public interface IMIStock
    {
        bool UpdateMisSTS(string STS, string locId, string STORAGE_ID, string goodid, string BARCODE,decimal occupy_num);
        void DeleteMIStock(string ctl, string locid, string goodid);
        void UpdateMisLocSts(string ctl, string location, string sts);
        bool UpdateMis(string num, string locId, string stoid, string goodid);
        bool UpdateMis(string locId, string STORAGE_ID);

        DataSet GET_T_MISTOCK_STATUS(string CTL);
        /// <summary>
        /// 移动库位
        /// </summary>
        /// <param name="locId"></param>
        /// <param name="ctl"></param>
        void UpdateMisLocData(string locId, string oldlocID, string STORAGE_ID,string ctl);
        DataTable GetMisDataOut(string locId, string goodsiD, string BARCODE );
        //DataTable GetMisDataOut_Empty(string LOC, string CTL);
        DataTable GetCtlCount(string locId);
        /// <summary>
        /// 查询空位中的空托盘
        /// </summary>
        /// <returns></returns>
        /// 
        DataTable GetMisDataNullOut(string size);
        DataTable GetMisDataempty();
        DataTable GetMisDataCKCTL(); 
        DataTable GetMisDataCK_empty(string barcode);

        DataTable GetMisDataCK(string barcode);

        DataTable GetMistockLocData(string devid);
        void UpdateMisLocBarCode(string BARCODE, string GOODS_ID, string sts);
        void UpdateMisLoc(string locId, string sts);
        void UpdateYKLoc(string location_id);
        DataTable GetCtMisTable(string locId);
        /// <summary>
        /// 查询库存盘点
        /// </summary>
        /// <returns></returns>
        DataTable GetMistockLocData();
        
        
        /// <summary>
        /// 删除库位明细
        /// </summary>
        /// <param name="barcode"></param>
        /// <param name="locId"></param>
        /// <param name="productId"></param>
        void DeleteMIStock(string locId);
        DataTable GetCTlGoods(string ctl);
        DataTable GetStockTaskLtk(string ck, string kq);
        DataTable GetLoctionGoodLtk(string goodslId);
        /// <summary>
        /// 获取商品的库位
        /// </summary>
        /// <param name="goodsId"></param>
        /// <param name="STORAGE_ID"></param>
        /// <param name="AREA_ID"></param>
        /// <returns></returns>
        DataTable LtkDataMis(string goodsId, string STORAGE_ID, string AREA_ID);
        /// <summary>
        /// 获取库存表
        /// </summary>
        /// <returns>库存表</returns>
        DataTable GetMIStockDT(MIStockModel model);
        DataTable GetLoctionGoods(string localId);
        DataSet GetStockUserName(string name);
        ///// <summary>
        ///// 此方法用于 库存查看窗体功能
        ///// </summary>
        ///// <param name="model"></param>
        ///// <returns></returns>
        //DataTable GetMiStockForLookUp(MIStockModel model);

        /// <summary>
        /// 插入库存表信息
        /// </summary>
        /// <param name="MIStockModel">库存表Model</param>
        string InsertMIStock(MIStockModel model);

        /// <summary>
        /// 修改库存表信息
        /// </summary>
        /// <param name="MIStockModel">库存表Model</param>
        void UpdateMIStock(MIStockModel model);

        /// <summary>
        /// 修改库存表数量
        /// </summary>
        /// <param name="model">库存表</param>
        void UpdateMIStockNum(MIStockModel model);
        DataTable GetNullLocal(string STORAGE_ID);
        
          
        DataSet GetStockName(string name);
        /// <summary>
        /// 修改库存表占用数量
        /// </summary>
        /// <param name="MIStockModel">库存表Model</param>
        void UpdateMIStockOccupyNum(MIStockModel model);

        /// <summary>
        /// 删除库存表信息
        /// </summary>
        /// <param name="MIStock"></param>
        void DeleteMIStock(MIStockModel model);

        /// <summary>
        /// 取上架区为空库位的
        /// </summary>
        /// <returns></returns>
        DataTable GetMiStockNullData(string storage_id, string area_id);

         /// <summary>
        /// 根据商品的编号，获取商品所在库位
        /// </summary>
        /// <param name="goodsId"></param>
        /// <returns></returns>
        DataTable GetMiStockData(string goodsId, string storage_id, string area_id);
        /// <summary>
        /// 商品不在的，未满的库位
        /// </summary>
        /// <param name="goodsId"></param>
        /// <param name="storage_id"></param>
        /// <param name="area_id"></param>
        /// <returns></returns>
        DataTable GetMiStockNotData(string goodsId, string storage_id, string area_id);

       /// <summary>
        /// 获取商品相邻的库位
        /// </summary>
        /// <param name="goodsId"></param>
        /// <returns></returns>
        DataTable GetStockData(string goodsId, string storage_id, string area_id);  
       
       
    }
}