using HH.WCS.JingyuNongfu.util;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WCS.JingyuNongfu.wms
{




    //---------------------------------------工单信息---------------------------------------

   
    [ST("坯盖工单表")]
    public class WorkOrder : BaseModel
    {
        //public DateTime T_CREATE { get; set; }
        /// <summary>
        /// 数据编号ID
        /// </summary>
        //public string SQL_id { get; set; }
        /// <summary>
        /// 批次号
        /// </summary>
       // public string S_BatchNo { get; set; }
        /// <summary>
        /// 产线号
        /// </summary>
        public string S_PLineNo { get; set; }
        /// <summary>
        /// 瓶盖机机无，翻斗机线边区连接到翻斗机暂存区
        /// </summary>
        public string S_LinkLineNO { get; set; }
        /// <summary>
        /// 连接区域,瓶盖机连接v8或无；翻斗机连接线边区
        /// </summary>
        public string S_Area { get; set; }
        public string S_Area2 { get; set; }
        //SQL_LinkLineNo2
        [SugarColumn(ColumnName = "S_LinkLineNo2")]
        public string S_LinkLineNO1 { get; set; }
        /// <summary>
        /// 即产即用
        /// </summary>
        public string S_UsingNow { get; set; }//SQL_UsingNow    "Y"|"N"
        /// <summary>
        /// 外调
        /// </summary>
       // public string S_Out { get; set; }//SQL_Out    "Y"|"N"
        /// <summary>
        /// 工单状态
        /// </summary>
        public string S_WorkState { get; set; }//SQL_State
        /// <summary>
        /// 工单号
        /// </summary>
        public string S_WorkNo { get; set; }//SQL_WorkNo
        /// <summary>
        /// 物料编码
        /// </summary>
        public string S_ItemCode { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        public string S_ItemName { get; set; }//SQL_ItemName
        /// <summary>
        /// 总数
        /// </summary>
        public string S_Total { get; set; }//SQL_Total
        /// <summary>
        /// 即产即用数量
        /// </summary>
       // public string S_UsingNowTotal { get; set; }

        /// <summary>
        /// 每批运输数量
        /// </summary>
        public string S_PCNumber { get; set; }//SQL_PCNumber
        public string S_PCNumber1 { get; set; }//SQL_PCNumber
        /// <summary>
        /// 计数（已执行数量）
        /// </summary>
        public string S_Current { get; set; }//SQL_Current
        /// <summary>
        /// 当前工单执行时间
        /// </summary>
        //public string S_Modify { get; set; }//SQL_Modify
        /// <summary>
        /// 当前工单结束时间
        /// </summary>
       // public string S_PLAN_END { get; set; }
        /// <summary>
        /// 是、否
        /// </summary>
        public string S_AutoComplete { get; set; }


    }

   
    [ST("成品工单表")]
    public class WorkOrder1 : BaseModel
    {
        /// <summary>
        /// 批次号
        /// </summary>
        public string S_BatchNo { get; set; }
        /// <summary>
        /// 产线号
        /// </summary>
        public string S_PLineNo { get; set; }
        /// <summary>
        /// 状态
        /// </summary>
        public string S_WorkState { get; set; }//SQL_State
        /// <summary>
        /// 工单号
        /// </summary>
        public string S_WorkNo { get; set; }//SQL_WorkNo
        /// <summary>
        /// 物料编码
        /// </summary>
        public string S_ItemCode { get; set; }
        public string SQL_ItemName { get; set; }
        public string SQL_Area { get; set; }
        public string S_TrayType { get; set; }
        public int maxTask { get; set; }
        public int trayHeight { get; set; }
        public string S_ItemLayer { get; set; }
        /// <summary>
        /// 是/否  有码和无码模式
        /// </summary>
        public string withCode { get; set; }
        public string SQL_Area1 { get; set; }
        public string SQL_Area2 { get; set; }
        public string S_ORDER_TYPE { get; set; }
    }
    
    [ST("移库工单表")]
    public class WorkOrder2 : BaseModel
    {

        /// <summary>
        /// 状态
        /// </summary>
        public string SQL_State { get; set; }//SQL_State
        /// <summary>
        /// 工单号
        /// </summary>
        public string SQL_WorkNo { get; set; }//SQL_WorkNo

        public string start_area { get; set; }
        public string end_area { get; set; }
        public int start_row { get; set; }
        public int end_row { get; set; }
        public int priority { get; set; }

        public string note { get; set; }
        public string size { get; set; }
        public string IsUnlock { get; set; }
        /// <summary>
        /// 移库任务数量
        /// </summary>
        public int number { get; set; }
        /// <summary>
        /// 当前移库数量
        /// </summary>
        public int current { get; set; }
    }

    [ST("顶升机工单表")]
    public class WorkOrder3 : BaseModel
    {
        /// <summary>
        /// 状态
        /// </summary>
        public string S_WorkState { get; set; }//SQL_State
        /// <summary>
        /// 产线号
        /// </summary>
        public string S_PLineNo { get; set; }
        /// <summary>
        /// 工单号
        /// </summary>
        public string S_WorkNo { get; set; }//SQL_WorkNo
  
    }

    [ST("领料工单表")]
    public class OutWorkOrder : BaseModel
    {
        /// <summary>
        /// 工单号
        /// </summary>
        public string WorkNo { get; set; }
        /// <summary>
        /// 领料单号
        /// </summary>
        public string WorkFromNo { get; set; }
        public string ItemCode { get; set; }
        public string ItemName { get; set; }
        public int OutAreaNum { get; set; }
        public string DeviceNo { get; set; }
        public int CurrQty { get; set; }
    }

    [ST("成品空托入库计划表")]
    public class CPEmptyIn : BaseModel
    {
        public string cntrType { get; set; }
        public string area { get; set; }
        public int priority { get; set; }
        public int startRow { get; set; }
        public string endArea { get; set; }
        public int endRow { get; set; }
    }
    [ST("成品空托出库库计划表")]
    public class CPEmptyOut : BaseModel
    {
        public string cntrType { get; set; }
        public string area { get; set; }
        public int priority { get; set; }
        public int row { get; set; }

    }
    
    [ST("富勒托盘表")]
    public class ThirdPartTrayInfo : BaseModel
    {
        /// <summary>
        /// 产线号
        /// </summary>
        public string deviceName { get; set; }
        /// <summary>
        /// 工单号
        /// </summary>
        public string workNo { get; set; }
        /// <summary>
        /// 托盘码
        /// </summary>
        public string trayCode { get; set; }
        /// <summary>
        /// 托盘数量
        /// </summary>
        public string trayNum { get; set; }
        /// <summary>
        /// 富勒接收到托盘码的时间
        /// </summary>
        public string dateTime { get; set; }
        /// <summary>
        /// 批次号--同标准托规
        /// </summary>
        public string batchNo { get; set; }
        /// <summary>
        /// 标准托规
        /// --生产下线：因存在中途切换 生产物料 动作；因此将 批次号、物料层高以及托规 存在于物料信息接口
        /// --不一定每次都有值，当首次托规与 trayNum 相同时，需更新至 Mobox 工单对应字段
        /// --后续收到托规时，先判断当前物料托规 与 工单托规是否相同，不同即代表换物料了
        /// </summary>
        public string trayRule { get; set; }
        /// <summary>
        /// 物料层高-6、7、8--同标准托规
        /// </summary>
        public string itemLayer { get; set; }
    }

    [ST("物料区域优先级表")]
    public class ItemZonePriInfo : BaseModel
    {
        public string S_ITEM_CODE { get; set; }
        public string S_ITEM_NAME { get; set; }
        public string S_AREA_CODE { get; set; }
        public string S_TRAY_TYPE { get; set; }
        public int S_PRIORITY { get; set; }
    }
    /// <summary>
    /// 移库单执行时创建，调富勒后更新IsNotice=1，移库单完成时State=1，IsNotice=0，再次通知富勒后删除
    /// </summary>
    public class MoveOrderNotice : BaseModel
    {
        /// <summary>
        /// 移库单号
        /// </summary>
        public string OrderNo { get; set; }
        public string StartArea { get; set; }
        public string EndArea { get; set; }
        /// <summary>
        /// wcs遍历移库单，发现执行中的就检查此表，如果没数据就插入，state是0，移库单完成时state更新成1。
        /// </summary>
        public int State { get; set; }
        /// <summary>
        /// 0是没通知，1是已通知
        /// </summary>
        public int IsNotice { get; set; }
    }

    /// <summary>
    /// 入库完成或者移库完成时写入，通知富勒后删除
    /// </summary>
    public class InOutRecord : BaseModel
    {
        /// <summary>
        /// 一般是2个托盘，用逗号分开
        /// </summary>
        public string TrayInfo { get; set; }
        /// <summary>
        /// 输送线下线起点库位是空，移库任务需要包含
        /// </summary>
        public string StartArea { get; set; } = "";
        public string EndArea { get; set; }
        public string WorkOrder { get; set; } = "";
        /// <summary>
        /// 0是入库（入库有上游工单信息），1是移库
        /// </summary>
        public int IsMove { get; set; }
    }
    public class PgZsjReportMesInfo : BaseModel
    {

        public string WorkOrder { get; set; }
        public string ItemName { get; set; }
        public string Qty { get; set; }
        public string CntrCode { get; set; }
        /// <summary>
        /// 是否连线(1非即产即用，2即产即用)  
        /// </summary>
        public int WorkType { get; set; }

    }
    public class PgFdjReportMesFeedInfo : BaseModel
    {

        public string WorkOrder { get; set; }
        public string CntrCode { get; set; }
        /// <summary>
        /// 是否连线(1非即产即用，2即产即用)  
        /// </summary>
        public int WorkType { get; set; }

    }
    public class PgReportFluxInfo : BaseModel
    {

        public string WorkOrder { get; set; }
        public string ItemName { get; set; }
        /// <summary>
        /// 多个托盘数量拼接
        /// </summary>
        public string Qty { get; set; }
        /// <summary>
        /// 多个托盘号拼接
        /// </summary>
        public string CntrCode { get; set; }
        public string BindTime { get; set; }

        public string Loc { get; set; }
        /// <summary>
        /// 1入库 2出库
        /// </summary>
        public int ActionType { get; set; }
        /// <summary>
        /// 入库state默认1，出库state默认0，卸货完成变成1，否则卸货完成时候找不到之前的领料单了，不方便扩展
        /// </summary>
        public int State { get; set; }


    }
}