BaoKai_202508_Wms_Jingwang_DianBan_Jiangxi/WMS.IData/IRK/IAutoRkData.cs

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

namespace WMS.IData.IRK
{
    public interface IAutoRkData
    {
        DataTable GetExceData2();
        /// <summary>
        /// 根据仓库查询入库站台
        /// </summary>
        /// <param name="STORAGE_ID"></param>
        /// <returns></returns>
        DataTable GetStandStorage(string STORAGE_ID);
        /// <summary>
        /// 查询站台
        /// </summary>
        /// <param name="goodsId"></param>
        /// <param name="STORAGE_ID"></param>
        /// <returns></returns>
        DataSet GetdecStationData(string goodsId, string STORAGE_ID);
        /// <summary>
        /// 查询可以入库的站台和堆垛机
        /// </summary>
        /// <returns></returns>
        DataTable GetDecData(string STORAGE_ID);
        /// <summary>
        /// 查询入库上架数据
        /// </summary>
        /// <returns></returns>
        DataTable GetRkData(string taskType);
        /// <summary>
        /// 更新库位、物料、数量
        /// </summary>
        /// <param name="ctl"></param>
        /// <param name="locId"></param>
        /// <param name="goodsId"></param>
        /// <param name="sheNum"></param>
        void UpadateTaskData(string ctl, string locId, string barcode, string pskw, decimal sheNum, decimal psNum);
        /// <summary>
        /// 更新订单Status
        /// </summary>
        /// <param name="ctl"></param>
        /// <param name="goodsId"></param>
        void DeleteGoodInfo(string ctl, string goodsId);
        /// <summary>
        /// 更新订单状态
        /// </summary>
        /// <param name="ctl"></param> 
        void  UpdateOrderSts(string ctl, string status);
        /// <summary>
        /// 删除入库单据
        /// </summary>
        /// <param name="ctl"></param>
        void DeleteTaskData(string ctl);
        DataTable GetPlcIdOpLoc(string plcId);
        void UpdateOpSts(string plcID);
        void   UpdateDecDataSts(string decId, string sts,string STORAGE_ID);
        bool UpdateConveSts(List<string> lis, string conveID);
        DataTable GetConveyorModeData(string decid);
        DataTable GetFdData(string decId, string station);
        DataTable GetTasks(string decId);
        DataTable GetTasks2(string decId);
        void UpdateEcxeOutData(string plcid,string status);
        void UpdateEcxeData(string LOT_ID, string status);
        DataTable GetexceData();
        void DeleteEcxeOutData(string plcid);
        void DeleteEcxeData(string plcid);
        /// <summary>
        /// tow scansts
        /// </summary>
        /// <param name="code"></param>
        void UpdateScan2Sts(string code);
        /// <summary>
        /// two scan
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        DataTable GetScan2Data(string code);

        /// </summary>
        /// <param name="locID"></param>
        void UpdatePlcIdData(string locID);
        #region 接口
        void UpdatePlcData();
        DataTable GetCodeWmsData(string palletID);
        DataTable GetPlcDataHigh(string hgID);
        /// <summary>
        /// 返回wms需要下发的批次
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        DataTable GetWmsData(string ctl);

        void DelteWaitIn( string PalletID);


        DataTable GetCtlDataOn(string ctl,string STORAGE_ID);

        #endregion
        DataSet GetTaksAllData();
        /// <summary>
        /// 
        /// </summary>
        /// <param name="Sheet_no"></param>
        /// <param name="Pdc_no"></param>
        /// <param name="PalletID"></param>
        void SerLocWaitInSts( string Sheet_no);
        /// <summary>
        /// 根据托盘条码获取数据
        /// </summary>
        /// <param name="palletID"></param>
        /// <returns></returns>
        DataTable GetCodeData(string palletID);
        /// <summary>
        /// 获取库位编号
        /// </summary>
        /// <param name="decId"></param>
        /// <returns></returns>
        DataTable GetLocDataRow(string decId, string Hgh);
        /// <summary>
        /// 写到备份表
        /// </summary>
        /// <param name="Sheet_no"></param>
        /// <param name="Pdc_no"></param>
        void InserLocWaitIn(string PalletID);
 
       
         
          /// <summary>
        /// 取消任务 更改改批次的任务为下发
        /// </summary>
        /// <param name="lotId"></param>
        void UpdateProductSts(string lot_id);
       
          /// <summary>
        /// 查询空库位
        /// </summary>
        /// <returns></returns>
        DataTable GetNullLocal(string sts);
        
     
       
        /// <summary>
        /// 查询小车库位
        /// </summary>
        /// <param name="volume"></param>
        /// <param name="devId"></param>
        /// <returns></returns>
        DataTable GetCarLocalData(string devId);
        /// <summary>
        /// 查询批次信息
        /// </summary>
        /// <returns></returns>
        DataTable GetProduceDataList();

     

        /// <summary>
        /// 查询空库位
        /// </summary>
        /// <returns></returns>
        DataTable GetNullLocalData();
        /// <summary>
        /// 入库完成后改更为完成 生产表
        /// </summary>
        /// <param name="ProDucLotId"></param>
        /// <param name="barcode"></param>
        void UpdateProductInSts(string lotId, string goodsId, string ProDucLotId);
 
        /// <summary>
        /// 插入明细商品
        /// </summary>
        /// <param name="goodsInfo"></param>
        void InsertGoodsInfoShelf(AutoRkGoodsInfo goodsInfo);

       
        /// <summary>
        /// 更新主表Status
        /// </summary>
        /// <param name="lotId"></param>
        void UpdateInSts(string lotId);
        /// <summary>
        /// 更新库位表为占用
        /// </summary>
        /// <param name="locId"></param>
        void UpdateLocSts(string locId);

        /// <summary>
        /// 查询需要入库的任务
        /// </summary>
        /// <returns></returns>
        DataTable GetTaskInData(string sts);

     

        /// <summary>
        /// 写入历史数据库
        /// </summary>
        /// <param name="barcode"></param>
        /// <param name="lotid"></param>
        void InsertUpGoodsBak(string ctl, string goodsId);


        /// <summary>
        /// 删除数据库
        /// </summary>
        /// <param name="barcode"></param>
        /// <param name="lotid"></param>
        void DelTaskGoodInfo(string lotId, string goodsId, string ProDucLotId);

        /// <summary>
        /// 获取上架单信息
        /// </summary>
        /// <returns></returns>
        DataTable GetUpShelfGoodsData(string station);
        /// <summary>
        /// PLC返回查询入库的信息
        /// </summary>
        /// <param name="locId"></param>
        /// <returns></returns>
        DataTable GetTaskLocInTask(string locId);
        /// <summary>
        /// 获取上架单明细信息
        /// </summary>
        /// <param name="PRODUCTION_id"></param>
        /// <returns></returns>
        DataTable GetOnShelfGoodsData();

        /// <summary>
        /// 更改数据状态
        /// </summary>
        /// <param name="locId"></param>
        /// <param name="STATUS"></param>
        void UpdateLocCtlSts(string locId, string STATUS,string STORAGE_ID);
        void UpdateLocislockSts(string locId, string STATUS, string STORAGE_ID);
        /// <summary>
        /// 查询库位的个数和库位
        /// </summary>
        /// <param name="product"></param>
        /// <returns></returns>
        DataTable GetMisLocProduct(string product);
         /// <summary>
        /// 查容积能够满足的库位
        /// </summary>
        /// <returns></returns>
        DataTable GetInMzLocalData(string volume);
     
        /// <summary>
        /// 查询该批次有多少需要入口的条码
        /// </summary>
        /// <param name="ProdcutId"></param>
        /// <returns></returns>
        DataTable GetLocMisVolume(string ProdcutId);
        /// <summary>
        /// 入库完成删除生产明细
        /// </summary>
        /// <param name="lotId"></param>
        /// <param name="barcode"></param>
        void DeleProductInfoInSts(string goodsId);

        /// <summary>
        /// 入库完成删除生产表
        /// </summary>
        /// <param name="lotId"></param>
        /// <param name="barcode"></param>
        void DeleProductInSts(string ProDucLotId);

           // <summary>
        /// 入库完成删除生产明细 写入历史数据库
        /// </summary>
        /// <param name="barcode"></param>
        /// <param name="lotid"></param>
        void InsertProductInfoBak(string goodsId,string lotid);

          // <summary>
        /// 入库完成删除生产表 写入历史数据库
        /// </summary>
        /// <param name="barcode"></param>
        /// <param name="lotid"></param>
        void InsertProductBak(string ProDucLotId);
  
        /// <summary>
        /// 查询改条码是否已经入库
        /// </summary>
        /// <param name="barcode"></param>
        /// <returns></returns>
        DataTable GetMisLocId(string goodsId);


        /// <summary>
        /// 查询该库位是否已经存放满
        /// </summary>
        /// <param name="locid_id"></param>
        /// <returns></returns>
        DataTable GetLocIdVolume(string locid_id);

      
        /// <summary>
        ///查询空库位
        /// </summary>
        /// <param name="sts"></param>
        /// <returns></returns>
        DataTable GetNotNullGoodIdLocal(decimal hgt);

        /// <summary>
        /// 查询空库位
        /// </summary>
        /// <returns></returns>
        DataTable GetNotNullLocal();

        string GetPlcId();
        /// <summary>
        /// 删除单据
        /// </summary>
        /// <param name="Sheet_no"></param>
        /// <param name="Pdc_no"></param>
        void DeleteTaskData(string Sheet_no, string Pdc_no);


    }
}