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

namespace WMS.IData.ICK
{
    public interface IPickingWaveGoods
    {


        /// <summary>
        /// 拼盘释放旧托盘
        /// </summary>
        /// <returns></returns>
        void DelCtlPickGoods(string ctl, string STORAGE_ID);

        /// <summary>
        /// 自动获取站台号，平均分配
        /// </summary>
        /// <returns></returns>
        DataSet GetStation(string STORAGE_ID);
        /// <summary>
        /// 根据出库单获取明细
        /// </summary>
        /// <param name="outId"></param>
        /// <returns></returns>
        DataTable GetOutDataId(string outId);
        /// <summary>
        /// 更拣选数量
        /// </summary>
        /// <param name="pickId"></param>
        /// <param name="goodsId"></param>
        /// <param name="picnum"></param>
        void UpdaPickNum(string pickId, string goodsId, decimal picnum);
       
        DataTable GetTaskOutCtStand(string stand);
        DataTable GetLocaStationAllData(string locID);
        /// <summary>
        /// select status is 2
        /// </summary>
        /// <returns></returns>
        DataTable GetTaskOutStatus();
        DataTable GetTaskOutStatus_0();


        DataTable GetTaskOutStatus_Empty();
        DataTable GetTaskMoveStatus();
        /// <summary>
        /// select status is 2
        /// </summary>
        /// <param name="loc"></param>
        /// <returns></returns>
        DataTable GetTaskLocOutStatus(string loc);
        bool GetPickData_BARCODE(string BARCODE);
        bool getPickData(string locid);
        bool getPickDataCount(int num);
        bool getPickDataCount();
        bool getLocS(string locid);

        string getYckLoc(string layer);
        DataTable getDecid(string decid);
        DataTable getRemark(string locid);
        DataTable getyck(string remark,string layer);
        DataTable getYK(string ctl);
        DataTable GetLocDataNo(string goodsId, decimal PACKING_NUM, string STORAGE_ID);
        DataTable HandGoodsSts(string locid);
        void DelHandGoods(string locid);
        void UpDateSort(string locid, string sort);
        /// <summary>
        /// 更新拣选的状态
        /// </summary>
        /// <param name="ctl"></param>
        /// <param name="goodsid"></param>
        /// <param name="barcode"></param>
        /// <param name="GOODS_NUM_SJ"></param>
        /// <param name="out_id"></param>
        /// <param name="status"></param>
        /// <param name="GoodsMeaSure"></param>
        /// <param name="PACKING_NUM"></param>
        /// <param name="goodsVolume"></param>
        void  SerLocWaitInSts(string ctl, string goodsid, string barcode, string GOODS_NUM_SJ, string out_id, string status, string GoodsMeaSure, string PACKING_NUM);
        DataTable GetTaskdataHand();

        DataTable GetDataT_ck_orderDetall();
        /// <summary>
        /// 手动出库
        /// </summary>
        /// <returns></returns>
        /// 
        bool DEL_T_CK_ORDERS(string loc,string goodid);

        //Insert_T_CK_ORDERS
        bool Insert_T_CK_ORDERS(string sqlStr);
        bool getPickDataProductionDate(string goodid, string production_date);
        bool insert_t_ck_ordersDetall(string sqlStr);
        bool GetDataErpData(string ORDER_ID);

        bool update_t_ck_ordersDetall(string orderID, string goodsId);

        bool delete_t_ckorder(string ORDER_ID);
        DataTable GetLocHand();
        void InsertHandGoods(PickingWaveGoodsModel model);
        void UpdateErpData(string CK_ID, string goodsid);
        DataTable GetErpCm(string locid);
        /// <summary>
        /// 写完成
        /// </summary>
        /// <param name="ioComplete"></param>
       // void InsertIoErp(Model.Pak_io_complete ioComplete);
        /// <summary>
        /// 获取ERP数据
        /// </summary>
        /// <returns></returns>
        DataTable GetDataErpData();
        /// <summary>
        /// 任务下发到PLC写重量
        /// </summary>
        /// <param name="locId"></param>
        void UpDateWghMisBak(string barcode, string wgh);
        
        /// <summary>
        /// 下发任务到PLC置Status
        /// </summary>
        /// <param name="ProDucLotId"></param>
        void UpdateStsPIckEnd(string ProDucLotId,string sts);
        /// <summary>
        /// 库存锁住
        /// </summary>
        /// <param name="barcode"></param>
        void UpdateMisStsLock(string barcode);
       
        /// <summary>
        /// 删除明细
        /// </summary>
        /// <param name="ProDucLotId"></param>
        /// <param name="BARCODE"></param>
        /// <param name="localId"></param>
        void DeleteProDucLotIdGoods(string ProDucLotId, string BARCODE, string localId);
        /// <summary>
        /// 删除拣货明细增加备份表
        /// </summary>
        /// <param name="ProDucLotId"></param>
        /// <param name="BARCODE"></param>
        /// <param name="localId"></param>
        void InsertProDucLotIdGoodsBack(string localId, string out_id);
        // void InsertPickingWaveGoodsBack(string pickingID,string goodsId,string localId);
        /// <summary>
        /// 出库更新库位表为空闲
        /// </summary>
        void UpdateLocSts(string locId);
        DataTable GetPickGoodsData(string ctl,string STORAGE_ID);

        DataTable GetGoodsArea(string goodsId);


        void DeletePickingWaveGoodsOut(string out_id);
        void DeletePickingWaveGoods(string locId,string out_id);
        /// <summary>
        /// 立体库获出库单明细
        /// </summary>
        /// <param name="localId"></param>
        /// <param name="goodsId"></param>
        /// <returns></returns>
        DataTable LtkgetPickData(string outStand);
        /// <summary>
        /// 获取捡货明细
        /// </summary>
        /// <returns>捡货明细</returns>
        DataTable GetPickingWaveGoodsDT(PickingWaveGoodsModel model);
        void UpdatePickingWaveSlGoods(string localtion, string goodsId, string number, string puid);
        /// <summary>
        /// 插入捡货明细信息
        /// </summary>
        /// <param name="PickingWaveGoodsModel">捡货明细Model</param>
        /// <returns>捡货明细编号</returns>
        void InsertCK(string pickingid, string oldloc, string newloc, string plcid);
        void InsertPickingWaveGoods(PickingWaveGoodsModel model);
        void InsertTMISTOCK(string loc_id);
        ///// <summary>
        ///// 删除一个捡货单的捡货商品明细
        ///// </summary>
        ///// <param name="pickingID">捡货单ID</param>
        //void DeletePickingWaveGoods(string pickingID);

        /// <summary>
        /// 向备份表中添加一个捡货单的捡货商品明细
        /// </summary>
        /// <param name="pickingID">捡货单ID</param>
        void InsertPickingWaveGoodsBack(string pickingID, string goodsId, string localId);

        /// <summary>
        /// 根据条码获取明细
        /// </summary>
        /// <param name="barcode"></param>
        /// <returns></returns>
        DataTable GetPickDataBarcode(string barcode);

        /// <summary>
        /// 获取该库位的是否已经满
        /// </summary>
        /// <param name="locId"></param>
        /// <returns></returns>
        DataTable getLocIdVolume(string locId);
    }
}