wms / wms_NouYaWmsN5 · Files

using Infrastructure;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Linq.Expressions;
using Microsoft.CodeAnalysis.CSharp.Syntax;
using WebRepository;

namespace WebApp
{
    /// <summary>
    /// 立库任务表
    /// </summary>
    public partial class TaskApp
    {
        private IUnitWork _unitWork;
        public IRepository<Task> _app;
        public IRepository<Container> _appc;
        public IRepository<Inventory> _appi;
        public IRepository<Location> _appl;
        public IRepository<ReceiptDetail> _apprd;
        public IRepository<ReceiptHeader> _apprh;
        public IRepository<ShipmentHeader> _apph;
        public IRepository<ShipmentDetail> _appsd;
        public IRepository<TaskDetail> _apptd;
        public IRepository<InventoryTransaction> _appit;
        private BaseDBContext _context;
        private static IHostingEnvironment _hostingEnvironment;

        private IAuth _auth;
        ExcelHelper imp = new ExcelHelper(_hostingEnvironment);

        public TaskApp(IUnitWork unitWork, IAuth auth, IRepository<Inventory> inventory, IRepository<InventoryTransaction> inventoryTransaction, IRepository<Container> Icontainer, IRepository<ReceiptHeader> receiptHeader, IRepository<ReceiptDetail> receiptDetail, IRepository<Task> repository, IRepository<Location> repositoryl, IRepository<ShipmentHeader> repositoryh, IRepository<TaskDetail> repositorytd, IRepository<ShipmentDetail> repositorysd, IHostingEnvironment hostingEnvironment, BaseDBContext context )
        {
            _unitWork = unitWork;
            _app = repository;
            _appl = repositoryl;
            _apph = repositoryh;
            _appsd = repositorysd;
            _apptd = repositorytd;
            _apprd = receiptDetail;
            _apprh = receiptHeader;
            _appc = Icontainer;
            _appi = inventory;
            _appit = inventoryTransaction;
            _hostingEnvironment = hostingEnvironment;
            _context = context;
            _auth = auth;

        }

        public TaskApp SetLoginInfo(LoginInfo loginInfo)
        {
            _app._loginInfo = loginInfo;
            _appl._loginInfo = loginInfo;
            _apph._loginInfo = loginInfo;
            _appsd._loginInfo = loginInfo;
            _apptd._loginInfo = loginInfo;
            _appc._loginInfo = loginInfo;
            _apprd._loginInfo = loginInfo;
            _apprh._loginInfo = loginInfo;
            _appi._loginInfo = loginInfo;
            _appit._loginInfo = loginInfo;
            return this;
        }

        public TableData Load(PageReq pageRequest, Task entity)
        {
            var result = new TableData();
            var data = _app.Find(EntityToExpression<Task>.GetExpressions(entity));
            data = data.Where(u => u.LastStatus != TaskStatus.已经完成);

            GetData(data, result, pageRequest);
            result.count = data.Count();

            return result;
        }

        public void Ins(Task entity)
        {
            _app.Add(entity);
        }

        public void Upd(Task entity)
        {
            _app.Update(entity);
        }

        public void DelByIds(int[] ids)
        {
            foreach (var item in ids)
            {
                Task entity = _app.FindSingle(u => u.Id == item);
                TaskDetail td = _unitWork.Find<TaskDetail>(n => n.TaskNo == entity.TaskNo).FirstOrDefault();
                Container con = _unitWork.Find<Container>(n => n.Code == td.ContainerCode).FirstOrDefault();
                Location loc = _unitWork.Find<Location>(n => n.ContainerCode == td.ContainerCode).FirstOrDefault();
                if (con.IsLock == 0 && loc.Status != LocationStatus.任务锁定中)
                {
                    break;
                }
                else
                {
                    if (loc != null)
                    {
                        _unitWork.Update<Location>(n => n.ContainerCode == td.ContainerCode, n => new Location
                        {
                            Status = LocationStatus.空仓位,
                            ContainerCode = ""
                        });
                    }
                    if (con != null && con.LocationCode != null)
                    {
                        con.LocationCode = "";
                        _unitWork.Update(con);
                    }
                    List<Inventory> invs = _unitWork.Find<Inventory>(n => n.ContainerCode == td.ContainerCode).ToList();
                    if (invs != null)
                    {
                        foreach (Inventory inv in invs)
                        {
                            inv.LocationCode = "";
                            _unitWork.Update(inv);
                        }
                    }
                    _app.Delete(entity);
                    _unitWork.Delete<TaskDetail>(u => u.TaskNo.Equals(entity.TaskNo));
                }

            }
        }

        public Task FindSingle(Expression<Func<Task, bool>> exp)
        {
            return _app.FindSingle(exp);
        }

        public IQueryable<Task> Find(Expression<Func<Task, bool>> exp)
        {
            return _app.Find(exp);
        }
        //模板导入
        public Response ImportIn(IFormFile excelfile)
        {
            Response result = new Infrastructure.Response();
            List<Task> exp = imp.ConvertToModel<Task>(excelfile);
            string sErrorMsg = "";

            for (int i = 0; i < exp.Count; i++)
            {
                try
                {
                    Task e = exp[i];
                    e.Id = null;
                    _app.Add(e);
                }
                catch (Exception ex)
                {
                    sErrorMsg += "第" + (i + 2) + "行:" + ex.Message + "<br>";
                    result.Message = sErrorMsg;
                    break;
                }
            }
            if (sErrorMsg.Equals(string.Empty))
            {
                if (exp.Count == 0)
                {
                    sErrorMsg += "没有发现有效数据, 请确定模板是否正确， 或是否有填充数据！";
                    result.Message = sErrorMsg;
                }
                else
                {
                    result.Message = "导入完成";
                }
            }
            else
            {
                result.Status = false;
                result.Message = result.Message;
            }
            return result;
        }

        public TableData ExportData(Task entity)
        {
            return _app.ExportData(entity);
        }

        public TableData Query(Task entity)
        {
            var result = new TableData();
            var data = _app.Find(EntityToExpression<Task>.GetExpressions(entity));

            GetData(data, result);
            result.count = data.Count();

            return result;
        }
        public void GetData(IQueryable<Task> data, TableData result, PageReq pageRequest = null)
        {
            _app.GetData(data, result, pageRequest);
        }
        //添加有料回库任务
        public TableData AddTaskBackInfo(TaskDetail tDetail, int? roadWay, string containercode, string materialCode)
        {
            TableData strError = new TableData();
            var taskNo = "";
            using (var tran = _context.Database.BeginTransaction())
            {
                try
                {
                    var status = TaskStatus.待下发任务;
                    if (tDetail.Station == "EntranceStationD01(P1000)")
                    {
                        List<Inventory> invs = _unitWork.Find<Inventory>(n =>
                            n.ContainerCode == containercode && n.LocationCode == "TrussStation").ToList();
                        if (invs.Count() > 0)
                        {
                            status = TaskStatus.新建任务;
                        }
                    }
                    if (tDetail.Station == "EntranceStationD02(P1004)" && containercode.Contains("N5PP"))
                    {
                        roadWay = 2;
                    }
                    //建立回库任务
                    Task task = new Task();
                    TaskDetail taskDetail = new TaskDetail();
                    if (tDetail.TaskType == TaskType.出库查看 || tDetail.TaskType == TaskType.盘点)
                    {
                        taskNo = tDetail.Station + _app.GetTaskNo(TaskNo.查看容器回库);
                    }
                    else
                    {
                        taskNo = tDetail.Station + _app.GetTaskNo(TaskNo.容器回库);
                    }
                    Location loc = null;
                    
                    if (roadWay == 3)
                    {
                        var tasks = _unitWork.Find<TaskDetail>(n => n.TaskNo != null).ToList();
                        StationRoadway stationRoadway = _unitWork.Find<StationRoadway>(n => n.StationCode == tDetail.Station).FirstOrDefault();
                        if (_unitWork.IsExist<Location>(n => n.ContainerCode == tDetail.ContainerCode))
                        {
                            if (_unitWork.IsExist<Inventory>(n => n.ContainerCode == tDetail.ContainerCode && n.TaskStatus == InventoryTaskType.有盘点任务))
                            {
                                loc = _unitWork.Find<Location>(n => n.ContainerCode == tDetail.ContainerCode).FirstOrDefault();
                                List<Inventory> list = _unitWork.Find<Inventory>(n => n.ContainerCode == tDetail.ContainerCode && n.Qty < 0).ToList();
                                foreach (Inventory inventory in list)
                                {
                                    _unitWork.Delete(inventory);
                                    InventoryTransaction inventoryTransaction = new InventoryTransaction
                                    {
                                        Type = TransactionType.盘点,
                                        Lot = inventory.Lot,
                                        ContainerCode = inventory.ContainerCode,
                                        Position = inventory.Position,
                                        TaskSteps = inventory.TaskSteps,
                                        LocationCode = "",
                                        SourceCode = inventory.SourceCode,
                                        MaterialCode = inventory.MaterialCode,
                                        Batch = inventory.Batch,
                                        TaskQty = inventory.Qty,
                                        Qty = inventory.Qty,
                                        QrCode = inventory.QrCode,
                                        Status = inventory.Status,
                                        Supplier = inventory.Supplier,
                                        ResidualWeight = inventory.ResidualWeight,
                                        Retreat = inventory.Retreat,
                                        Specification = inventory.Specification,
                                        NameDescription = inventory.NameDescription,
                                        Unit = inventory.Unit,
                                        Size = inventory.Size,
                                        OldBatch = inventory.OldBatch,
                                        Combo = inventory.Combo,
                                        NumberofSheets = inventory.NumberofSheets,
                                        Groupnum = inventory.Groupnum,
                                        StackingNumber = inventory.StackingNumber,
                                        CreateTime = inventory.CreateTime,
                                        UpdateTime = DateTime.Now
                                    };
                                    _appit.Add(inventoryTransaction);
                                }
                            }
                        }
                        if (loc == null)
                        {
                            if (_unitWork.GetCount<Location>(n => n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay && n.ContainerCode == "") < 6)
                            {
                                tran.Rollback();
                                strError.msg = "空仓位小于6个";
                                return strError;
                            }
                            while (true)
                            {
                                if (stationRoadway.StationPlace == StationPlace.巷道北面)
                                {
                                    loc = (from loca in _unitWork.Find<Location>(n => n.RowIndex == 1 && !tasks.Select(a => a.DestinationLocation).Contains(n.ContiguousCode) && !tasks.Select(a => a.SourceLocation).Contains(n.ContiguousCode) && n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay && n.ContainerCode == "")
                                           join cLoca in _unitWork.Find<Location>(n => n.ContainerCode == "" && n.Status != LocationStatus.任务锁定中 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay)
                                               on loca.ContiguousCode equals cLoca.Code
                                           select loca)
                                    .OrderBy(n => n.RowIndex == 1 ? 0 : n.RowIndex).ThenBy(b => b.MaxHeight).ThenBy(a => a.Layer).ThenBy(y => y.Row).FirstOrDefault();
                                }
                                else if (stationRoadway.StationPlace == StationPlace.巷道南面)
                                {
                                    loc = (from loca in _unitWork.Find<Location>(n => n.RowIndex == 1 && !tasks.Select(a => a.DestinationLocation).Contains(n.ContiguousCode) && !tasks.Select(a => a.SourceLocation).Contains(n.ContiguousCode) && n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay && n.ContainerCode == "")
                                           join cLoca in _unitWork.Find<Location>(n => n.ContainerCode == "" && n.Status != LocationStatus.任务锁定中 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay)
                                               on loca.ContiguousCode equals cLoca.Code
                                           select loca)
                                    .OrderBy(n => n.RowIndex == 1 ? 0 : n.RowIndex).ThenBy(b => b.MaxHeight).ThenBy(a => a.Layer).ThenByDescending(y => y.Row).FirstOrDefault();
                                }
                                if (loc == null)
                                {
                                    if (stationRoadway.StationPlace == StationPlace.巷道北面)
                                    {
                                        loc = (from loca in _unitWork.Find<Location>(n => n.RowIndex == 2 && !tasks.Select(a => a.DestinationLocation).Contains(n.ContiguousCode) && !tasks.Select(a => a.SourceLocation).Contains(n.ContiguousCode) && n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay && n.ContainerCode == "")
                                               join cLoca in _unitWork.Find<Location>(n => n.Status != LocationStatus.任务锁定中 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay)
                                                   on loca.ContiguousCode equals cLoca.Code
                                               select loca)
                                        .OrderBy(n => n.RowIndex == 1 ? 0 : n.RowIndex).ThenBy(b => b.MaxHeight).ThenBy(a => a.Layer).ThenBy(y => y.Row).FirstOrDefault();
                                    }
                                    else if (stationRoadway.StationPlace == StationPlace.巷道南面)
                                    {
                                        loc = (from loca in _unitWork.Find<Location>(n => n.RowIndex == 2 && !tasks.Select(a => a.DestinationLocation).Contains(n.ContiguousCode) && !tasks.Select(a => a.SourceLocation).Contains(n.ContiguousCode) && n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay && n.ContainerCode == "")
                                               join cLoca in _unitWork.Find<Location>(n => n.Status != LocationStatus.任务锁定中 && n.IsStop == false && n.Roadway == stationRoadway.RoadWay)
                                                   on loca.ContiguousCode equals cLoca.Code
                                               select loca)
                                       .OrderBy(n => n.RowIndex == 1 ? 0 : n.RowIndex).ThenBy(b => b.MaxHeight).ThenBy(a => a.Layer).ThenByDescending(y => y.Row).FirstOrDefault();
                                    }
                                }
                                if (loc == null)
                                {
                                    tran.Rollback();
                                    strError.msg = "未找到仓位";
                                    return strError;
                                }
                                else
                                {
                                    if (_unitWork.IsExist<TaskDetail>(a => (a.DestinationLocation == loc.ContiguousCode || a.SourceLocation == loc.ContiguousCode) && a.Roadway == 1))
                                    {
                                        continue;
                                    }
                                    int i = _unitWork.Update<Location>(n => n.Id == loc.Id && n.Version == loc.Version, n => new Location
                                    {
                                        Status = LocationStatus.任务锁定中,
                                        ContainerCode = tDetail.ContainerCode,
                                        UpdateTime = DateTime.Now
                                    });
                                    if (i == 1)
                                    {
                                        break;
                                    }
                                }
                            }
                        }

                        
                        task.TaskNo = taskNo;
                        task.OrderCode = taskNo;
                        task.BusinessType = BusinessType.入库_其他入库单;
                        task.FirstStatus = status;
                        task.LastStatus = status;
                        task.CreateTime = DateTime.Now;
                        _app.Add(task);

                        taskDetail.TaskNo = taskNo;
                        taskDetail.OrderCode = taskNo;
                        taskDetail.TaskType = TaskType.容器回库;
                        taskDetail.ContainerCode = containercode;
                        taskDetail.SourceLocation = tDetail.Station;
                        taskDetail.DestinationLocation = loc.Code;
                        taskDetail.OderQty = 0;
                        taskDetail.ContainerQty = 0;
                        taskDetail.HadQty = 0;
                        taskDetail.Roadway = roadWay;
                        taskDetail.Station = tDetail.Station;
                        taskDetail.Status = status;
                        taskDetail.Priority = 99;
                        taskDetail.MaterialCode = materialCode;
                        taskDetail.CreateTime = DateTime.Now;
                        _apptd.Add(taskDetail);

                        Container UpConSta = _unitWork.Find<Container>(n => n.Code == containercode).FirstOrDefault();
                        UpConSta.Status = LocationStatus.有货;
                        UpConSta.LocationCode = loc.Code;
                        if (UpConSta.Code.Contains("N5PJ") && UpConSta.Type == ContainerType.空托盘组)
                        {
                            UpConSta.Type = ContainerType.普通栈板;
                        };
                        _unitWork.Update(UpConSta);
                        tran.Commit();
                        strError.data = taskNo;

                        List<Inventory> inventories = _unitWork.Find<Inventory>(n => n.ContainerCode == containercode).ToList();
                        //更新同个容器中其它物料对应新的回库仓位
                        if (inventories.Count > 0)
                        {
                            foreach (Inventory inv in inventories)
                            {
                                if (inv.LocationCode != loc.Code)
                                {
                                    inv.LocationCode = loc.Code;
                                    //inv.SourceCode = taskDetail.OrderCode;
                                    _appi.Update(inv);
                                }
                            }
                        }

                    }
                    else
                    {
                        if (_unitWork.IsExist<Location>(n => n.ContainerCode == tDetail.ContainerCode))
                        {
                            if (_unitWork.IsExist<Inventory>(n => n.ContainerCode == tDetail.ContainerCode && n.TaskStatus == InventoryTaskType.有盘点任务))
                            {
                                loc = _unitWork.Find<Location>(n => n.ContainerCode == tDetail.ContainerCode).FirstOrDefault();
                                List<Inventory> list = _unitWork.Find<Inventory>(n => n.ContainerCode == tDetail.ContainerCode && n.Qty < 0).ToList();
                                foreach (Inventory inventory in list)
                                {
                                    _unitWork.Delete(inventory);
                                    InventoryTransaction inventoryTransaction = new InventoryTransaction
                                    {
                                        Type = TransactionType.盘点,
                                        Lot = inventory.Lot,
                                        ContainerCode = inventory.ContainerCode,
                                        Position = inventory.Position,
                                        TaskSteps = inventory.TaskSteps,
                                        LocationCode = "",
                                        SourceCode = inventory.SourceCode,
                                        MaterialCode = inventory.MaterialCode,
                                        Batch = inventory.Batch,
                                        TaskQty = inventory.Qty,
                                        Qty = inventory.Qty,
                                        QrCode = inventory.QrCode,
                                        Status = inventory.Status,
                                        Supplier = inventory.Supplier,
                                        ResidualWeight = inventory.ResidualWeight,
                                        Retreat = inventory.Retreat,
                                        Specification = inventory.Specification,
                                        NameDescription = inventory.NameDescription,
                                        Unit = inventory.Unit,
                                        Size = inventory.Size,
                                        OldBatch = inventory.OldBatch,
                                        Combo = inventory.Combo,
                                        NumberofSheets = inventory.NumberofSheets,
                                        Groupnum = inventory.Groupnum,
                                        StackingNumber = inventory.StackingNumber,
                                        CreateTime = inventory.CreateTime,
                                        UpdateTime = DateTime.Now
                                    };
                                    _appit.Add(inventoryTransaction);
                                }
                            }
                        }
                        task.TaskNo = taskNo;
                        task.OrderCode = taskNo;
                        task.BusinessType = BusinessType.入库_其他入库单;
                        task.FirstStatus = status;
                        task.LastStatus = status;
                        task.CreateTime = DateTime.Now;
                        _app.Add(task);

                        taskDetail.TaskNo = taskNo;
                        taskDetail.OrderCode = taskNo;
                        taskDetail.TaskType = TaskType.容器回库;
                        taskDetail.ContainerCode = containercode;
                        taskDetail.SourceLocation = tDetail.Station;
                        taskDetail.DestinationLocation = _unitWork.Find<Location>(n => n.Roadway == roadWay).Select(u => u.Type).FirstOrDefault();
                        taskDetail.OderQty = 0;
                        taskDetail.ContainerQty = 0;
                        taskDetail.HadQty = 0;
                        taskDetail.Roadway = roadWay;
                        taskDetail.Station = tDetail.Station;
                        taskDetail.Status = status;
                        taskDetail.Priority = 99;
                        taskDetail.MaterialCode = materialCode;
                        taskDetail.CreateTime = DateTime.Now;
                        _apptd.Add(taskDetail);

                        Container UpConSta = _unitWork.Find<Container>(n => n.Code == containercode).FirstOrDefault();
                        UpConSta.Status = LocationStatus.有货;
                        _unitWork.Update(UpConSta);
                        tran.Commit();
                        strError.data = taskNo;
                    }

                    
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    strError.msg = ex.Message;
                    return strError;
                }
                return strError;
            }
        }

        /// <summary>
        /// 创建空托回库任务
        /// </summary>
        /// <param name="station">站台</param>
        /// <param name="location"></param>
        /// <param name="containercode">托盘号</param>
        /// <returns></returns>
        public string AddEmptyTaskBack(Station station, string containercode, string type)
        {
            string strError = "";
            //创建任务和调用WCS下发任务接口下发任务，任何回库任务都是立即下发给WCS
            using (var tran = _context.Database.BeginTransaction())
            {
                try
                {
                    var config = AppSettingsJson.GetAppSettings();
                    var start = int.Parse(config.GetSection("SpecialTime:Start").Value);
                    var end = int.Parse(config.GetSection("SpecialTime:End").Value);
                    StationRoadway stationRoadway = _unitWork.Find<StationRoadway>(n => n.StationCode == station.Code).FirstOrDefault();
                    var Roadway = stationRoadway.RoadWay;
                    if (station.Code == "EntranceStationD02(P1004)" && containercode.Contains("N5PP"))
                    {
                        Roadway = 2;
                    }
                    Location loc = null;
                    while (true)
                    {
                        var tasks = _unitWork.Find<TaskDetail>(n => n.TaskNo != null).ToList();
                        if (_unitWork.GetCount<Location>(n => n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == Roadway && n.ContainerCode == "") < 6)
                        {
                            strError = "空仓位小于6个";
                            return strError;
                        }
                        loc = (from loca in _unitWork.Find<Location>(n => n.RowIndex == 1 && !tasks.Select(a => a.DestinationLocation).Contains(n.ContiguousCode) && !tasks.Select(a => a.SourceLocation).Contains(n.ContiguousCode) && n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == Roadway && n.ContainerCode == "")
                               join cLoca in _unitWork.Find<Location>(n => n.ContainerCode == "" && n.Status != LocationStatus.任务锁定中 && n.IsStop == false && n.Roadway == Roadway)
                               on loca.ContiguousCode equals cLoca.Code
                               select loca)
                              .OrderBy(n => n.RowIndex == 1 ? 0 : n.RowIndex).ThenBy(b => b.MaxHeight).ThenBy(a => a.Layer).ThenBy(y => y.Row).FirstOrDefault();
                        
                        if (loc == null)
                        {
                            loc = (from loca in _unitWork.Find<Location>(n => n.RowIndex == 2 && !tasks.Select(a => a.DestinationLocation).Contains(n.ContiguousCode) && !tasks.Select(a => a.SourceLocation).Contains(n.ContiguousCode) && n.Status == LocationStatus.空仓位 && n.IsStop == false && n.Roadway == Roadway && n.ContainerCode == "")
                                   join cLoca in _unitWork.Find<Location>(n => n.Status != LocationStatus.任务锁定中 && n.IsStop == false && n.Roadway == Roadway)
                                   on loca.ContiguousCode equals cLoca.Code
                                   select loca)
                                  .OrderBy(n => n.RowIndex == 1 ? 0 : n.RowIndex).ThenBy(b => b.MaxHeight).ThenBy(a => a.Layer).ThenBy(y => y.Row).FirstOrDefault();
                        }
                        //更新仓位对应的容器，如果回库分配的不是原仓位则更新仓位且锁定
                        if (loc == null)
                        {
                            strError = "未找到仓位";
                            return strError;
                        }
                        else
                        {
                            if (_unitWork.IsExist<TaskDetail>(a =>(a.DestinationLocation == loc.ContiguousCode || a.SourceLocation == loc.ContiguousCode) && (a.Roadway == 1 || a.Roadway == 3)))
                            {
                                continue;
                            }
                            int i = _unitWork.Update<Location>(n => n.Id == loc.Id && n.Version == loc.Version, n => new Location
                            {
                                Status = LocationStatus.任务锁定中,
                                ContainerCode = containercode,
                                UpdateTime = DateTime.Now
                            });

                            if (i == 1)
                            {
                                break;
                            }
                        }
                    }
                    var pro = 99;
                    TaskDetail taskDetail = new TaskDetail();
                    Task task = new Task(); 
                    var tno = "";
                    if (type == "p_2")
                    {
                        tno = station.Code + _app.GetTaskNo(TaskNo.空托盘组入库);
                    }
                    else
                    {
                        tno = station.Code + _app.GetTaskNo(TaskNo.空托盘入库);
                    }
                    task.TaskNo = tno;
                    task.OrderCode = tno;
                    task.BusinessType = BusinessType.入库_其他入库单;
                    task.FirstStatus = TaskStatus.待下发任务;
                    task.LastStatus = TaskStatus.待下发任务;
                    task.CreateTime = DateTime.Now;
                    _app.Add(task);

                    taskDetail.TaskNo = tno;
                    taskDetail.OrderCode = tno;
                    taskDetail.TaskType = TaskType.空容器入库;
                    taskDetail.ContainerCode = containercode;
                    taskDetail.SourceLocation = station.Code;
                    taskDetail.DestinationLocation = loc.Code;
                    taskDetail.OderQty = 0;
                    taskDetail.ContainerQty = 0;
                    taskDetail.HadQty = 0;

                    taskDetail.Roadway = stationRoadway.RoadWay;
                    taskDetail.Station = station.Code;
                    taskDetail.Status = TaskStatus.待下发任务;
                    taskDetail.Priority = pro;
                    taskDetail.CreateTime = DateTime.Now;
                    _apptd.Add(taskDetail);
                    tran.Commit();
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    strError = ex.Message;
                    return strError;
                }
                return strError;
            }
        }

        /// <summary>
        /// 空托回库
        /// </summary>
        /// <param name="station">站台</param>
        /// <param name="type">托盘类型</param>
        /// <param name="containerCode">托盘号</param>
        /// <returns></returns>
        public TableData EmptyContainerBack(string station, string containerCode, string type)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                //Station st = new Station();
                Station st = _unitWork.Find<Station>(n => n.Code == station && n.Containercode == containerCode).FirstOrDefault();
                if (st == null)
                {
                    tab.code = 300;
                    tab.msg = "站台无此托盘:" + containerCode;
                    return tab;
                }
                TaskDetail taskdel = _unitWork.Find<TaskDetail>(n => n.ContainerCode == containerCode && n.TaskType != TaskType.整盘出库 && n.TaskType != TaskType.分拣出库).FirstOrDefault();
                if (taskdel != null)
                {
                    tab.code = 300;
                    tab.msg = "该托盘已有任务！";
                    return tab;
                }
                Inventory inv = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode).FirstOrDefault();
                if (inv != null)
                {
                    tab.code = 300;
                    tab.msg = "该托盘有物料不能空板入！";
                    return tab;
                }
                if (_unitWork.IsExist<Location>(n => n.ContainerCode == containerCode && n.ContainerCode != ""))
                {
                    tab.code = 300;
                    tab.msg = "库内存在该托盘！";
                }
                else
                {
                    var contype = type;
                    Container container = _unitWork.Find<Container>(n => n.Code == containerCode).FirstOrDefault();
                    if (container != null)
                    {
                        container.Type = contype;
                        _unitWork.Update(container);
                    }
                    string str = AddEmptyTaskBack(st, containerCode, contype);
                    if (str == "")
                    {
                        tab.code = 200;
                        tab.msg = "空托回库任务建立成功！";
                    }
                    else
                    {
                        tab.code = 300;
                        tab.msg = str + "，建立空托回库任务失败！";
                    }
                }
            }
            catch (Exception ex)
            {
                tab.code = 300;
                tab.msg += ex.Message;
            }
            return tab;
        }
        // <summary>
        /// 整托手动入库
        /// </summary>
        public TableData HandTaskInApp(string containerCode, string station, int isBuffer, string isPack, string isFold, string status, string materialCode)
        {
            TableData response = new TableData();
            response.code = 200;
            try
            {
                Station s = _unitWork.Find<Station>(n => n.Code == station && n.Containercode != "").FirstOrDefault();
                if (s == null)
                {
                    if (station == "TrussStation")
                    {
                        s = _unitWork.Find<Station>(n => n.Code == "EntranceStationD01(P1000)").FirstOrDefault();
                    }
                    else
                    {
                        response.code = 500;
                        response.msg = "当前站台没有托盘占用，请重新扫描！";
                        return response;
                    }
                }
                //if (station == "EntranceStationD02(P1004)")
                //{
                //    if (containerCode.Contains("N5PP"))
                //    {
                //        response.code = 500;
                //        response.msg = "当前站台不允许入PP有货托盘！";
                //        return response;
                //    }
                //}
                if (station == "OutStationB07(P3300)")
                {
                    isPack = "Ispack";
                }
                StationRoadway stationRoadway = _unitWork.Find<StationRoadway>(n => n.StationCode == s.Code).FirstOrDefault();
                Inventory Inventory = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode).FirstOrDefault();
                if (Inventory == null)
                {
                    response.code = 500;
                    response.msg = "该托盘未添加物料,请重新扫描物料二维码！";
                    return response;
                }
                else if ((Inventory.Position == 1 || Inventory.Position == 2) && station == "TrussStation")
                {
                    List<Inventory> Inv =
                        _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode).ToList();
                    if (Inv.Count == 1)
                    {
                        response.code = 500;
                        response.msg = "该托盘为双物料托盘，目前只入库一个，不允许入库！！";
                        return response;
                    }
                    else if (Inv.Count > 2)
                    {
                        response.code = 500;
                        response.msg = "该托盘为双物料托盘，目前已超过两个，请联系技术人员";
                        return response;
                    }
                }
                Container container = _unitWork.Find<Container>(n => n.Code == s.Containercode).FirstOrDefault();
                if (container == null)
                {
                    response.code = 500;
                    response.msg = "库内未找到该托盘！";
                    return response;
                }
                containerCode = container.Code;
                if (_unitWork.IsExist<TaskDetail>(n => n.ContainerCode == containerCode && n.TaskType != TaskType.整盘出库 && n.TaskType != TaskType.分拣出库))
                {
                    response.code = 500;
                    response.msg = "该托盘有任务正在执行！";
                    return response;
                }
                
                TableData str = new TableData();
                if (isBuffer == 0)
                {
                    TaskDetail taskDetail = new TaskDetail
                    {
                        Station = s.Code,
                        TaskType = TaskType.出库查看,
                        ContainerCode = containerCode
                    };
                    str = AddTaskBackInfo(taskDetail, stationRoadway.RoadWay, containerCode, materialCode);
                    if (!string.IsNullOrEmpty(str.msg))
                    {
                        response.code = 500;
                        response.msg = "失败:" + str.msg;
                        return response;
                    }
                }
                else
                {
                    Task ptask = new Task();
                    var ctaskNo = _app.GetTaskNo(TaskNo.站台到站台);
                    ptask.TaskNo = ctaskNo;
                    ptask.OrderCode = ctaskNo;
                    ptask.BusinessType = BusinessType.出库_其他出库单;
                    ptask.FirstStatus = TaskStatus.待下发任务;
                    ptask.LastStatus = TaskStatus.待下发任务;
                    ptask.CreateTime = DateTime.Now;


                    TaskDetail ptaskDetail = new TaskDetail();
                    ptaskDetail.TaskType = TaskType.站台到站台;
                    ptaskDetail.Roadway = stationRoadway.RoadWay;
                    ptaskDetail.TaskNo = ctaskNo;
                    ptaskDetail.OrderCode = ctaskNo;
                    ptaskDetail.ContainerCode = containerCode;
                    ptaskDetail.SourceLocation = s.Code;
                    ptaskDetail.DestinationLocation = "InStationB06(P3316)";
                    ptaskDetail.Station = "InStationB06(P3316)";
                    ptaskDetail.OderQty = 0;
                    ptaskDetail.ContainerQty = 0;
                    ptaskDetail.HadQty = 0;
                    ptaskDetail.Status = TaskStatus.待下发任务;
                    ptaskDetail.Priority = 99;
                    ptaskDetail.CreateTime = DateTime.Now;

                    _unitWork.Add(ptask);
                    _unitWork.Add(ptaskDetail);
                }
                List<Inventory> inventories = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode).ToList();
                foreach (Inventory inventory in inventories)
                {
                    inventory.IsPack = isPack;
                    inventory.IsFold = isFold;
                    inventory.Status = status;
                    _appi.UpdateByTracking(inventory);

                    InventoryTransaction inventoryTransaction = new InventoryTransaction();
                    inventoryTransaction.Type = TransactionType.入库;
                    inventoryTransaction.Lot = inventory.Lot;
                    inventoryTransaction.QrCode = inventory.QrCode;
                    inventoryTransaction.ContainerCode = inventory.ContainerCode;
                    inventoryTransaction.TaskSteps = inventory.TaskSteps;
                    inventoryTransaction.Position = inventory.Position;
                    inventoryTransaction.UserDef1 = str.data;
                    inventoryTransaction.SourceCode = inventory.SourceCode;
                    inventoryTransaction.LocationCode = "";
                    inventoryTransaction.MaterialCode = inventory.MaterialCode;
                    inventoryTransaction.Batch = inventory.Batch;
                    inventoryTransaction.Qty = inventory.Qty;
                    inventoryTransaction.Status = inventory.Status;
                    inventoryTransaction.IsPack = isPack;
                    inventoryTransaction.IsFold = isFold;
                    inventoryTransaction.Status = status;
                    inventoryTransaction.Supplier = inventory.Supplier;
                    inventoryTransaction.ResidualWeight = inventory.ResidualWeight;
                    inventoryTransaction.Retreat = inventory.Retreat;
                    inventoryTransaction.Specification = inventory.Specification;
                    inventoryTransaction.NameDescription = inventory.NameDescription;
                    inventoryTransaction.Unit = inventory.Unit;
                    inventoryTransaction.Size = inventory.Size;
                    inventoryTransaction.OldBatch = inventory.OldBatch;
                    inventoryTransaction.Combo = inventory.Combo;
                    inventoryTransaction.NumberofSheets = inventory.NumberofSheets;
                    inventoryTransaction.Groupnum = inventory.Groupnum;
                    inventoryTransaction.StackingNumber = inventory.StackingNumber;
                    inventoryTransaction.CreateTime = inventory.CreateTime;
                    inventoryTransaction.UpdateTime = DateTime.Now;
                    _appit.Add(inventoryTransaction);
                }
                if (s.Code == "OutStationB07(P3300)")
                {
                    s.Containercode = "";
                    _unitWork.Update(s);
                    StoreStation store = _unitWork.Find<StoreStation>(n => n.ContainerCode == containerCode).FirstOrDefault();
                    if (store == null)
                    {
                        StoreStation storeStation = new StoreStation
                        {
                            StationCode = "InStationB06(P3316)",
                            ContainerCode = containerCode,
                            Status = StoreStationStatus.任务中,
                            CreateTime = DateTime.Now
                        };
                        _unitWork.Add(storeStation);

                    }
                }
            }
            catch (Exception ex)
            {
                response.code = 500;
                response.msg = ex.Message;
            }
            return response;
        }

        /// <summary>
        /// 添加物料库存
        /// </summary>
        /// <param name="containerCode">容器编码</param>
        /// <param name="station">站台</param>
        /// <param name="material">物料号</param>
        /// <param name="Lot">批号</param>
        /// <param name="num">数量</param>
        /// <param name="Batch">批次</param>
        /// <param name="Customer">客户编号</param>
        /// <param name="Typesetting">排版数量</param>
        /// <param name="Supplier">供应商</param>
        /// <param name="ResidualWeight">厚度</param>
        /// <param name="Retreat">退料人</param>
        /// <returns></returns>
        public TableData AddInventoryApp(string containerCode, string station, string material, string Lot, decimal num, string Batch, string Customer, string Typesetting, string Supplier, decimal ResidualWeight, string Retreat, string nameDescription, string specification, string unit, decimal time, string Size, decimal NumberofSheets, decimal Groupnum, string Project,string QRCode, string Truss,int Height)
        {
            TableData response = new TableData();
            response.code = 200;
            try
            {
                //if (station == "EntranceStationD02(P1004)")
                //{
                //    if (containerCode.Contains("N5PP"))
                //    {
                //        response.code = 300;
                //        response.msg = "当前站台不允许入PP物料";
                //        return response;
                //    }
                //}
                string OldBatch = Batch;
                if (Batch == "" || Batch == null)
                {
                    response.code = 300;
                    response.msg = "扫描到批次为空，请重新扫描";
                    return response;
                }
                else
                {
                    int batch = 0;
                    if (!int.TryParse(Batch, out batch))
                    {
                        var year = _unitWork.Find<Cycle>(n => n.Type == "year" && n.Original == Batch.Substring(1, 1)).FirstOrDefault();
                        var month = _unitWork.Find<Cycle>(n => n.Type == "month" && n.Original == Batch.Substring(2, 1)).FirstOrDefault();
                        var day = _unitWork.Find<Cycle>(n => n.Type == "day" && n.Original == Batch.Substring(3, 1)).FirstOrDefault();
                        if (year != null && month != null && day != null)
                        {
                            Batch = year.Translate + month.Translate + day.Translate;
                        }
                        else
                        {
                            response.code = 300;
                            response.msg = "批次错误，解析失败！";
                            return response;
                        }
                    }
                }
                Station s = _unitWork.Find<Station>(n => n.Code == station && n.Containercode == containerCode).FirstOrDefault();
                if (s == null )
                {
                    if (station == "ProductStationB03")
                    {
                        s = _unitWork.Find<Station>(n => n.Code == "ProductStationB03").FirstOrDefault();
                    }
                    else
                    {
                        if (station == "EntranceStationD01")
                        {
                            s = _unitWork.Find<Station>(n => n.Code == "EntranceStationD01(P1000)" && n.Containercode == containerCode).FirstOrDefault();
                        }
                    }
                    if (s == null)
                    {
                        response.code = 300;
                        response.msg = "未找到该站台:" + station;
                        return response;
                    }
                }
                Container container = _unitWork.Find<Container>(n => n.Code == containerCode).FirstOrDefault();
                if (container != null && container.IsLock != ContainerLock.盘点锁)
                {
                    TaskDetail taskDetail = _unitWork.Find<TaskDetail>(n => n.ContainerCode == container.Code)
                        .FirstOrDefault();
                    if (taskDetail != null)
                    {
                        if (taskDetail.ContainerCode.Contains("N5TB"))
                        {
                            TaskDetail OuttaskDetail = _unitWork.Find<TaskDetail>(n => n.ContainerCode == container.Code && n.TaskType == TaskType.空容器出库 && n.DestinationLocation == "EntranceStationD01(P1000)").FirstOrDefault();
                            if (OuttaskDetail != null)
                            {
                                response.code = 300;
                                response.msg = "该托盘空板出库任务正在执行，请等待出库任务完成后扫描物料！！";
                                return response;
                            }
                            else
                            {
                                response.code = 300;
                                response.msg = "该托盘有任务正在执行！！";
                                return response;
                            }
                        }
                        else
                        {
                            response.code = 300;
                            response.msg = "该托盘有任务正在执行！！";
                            return response;
                        }
                    }
                    //2楼复核物料
                    if (s.Code == "ProductStationB03")
                    {
                        //List<Inventory> inventoriesNum = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode && n.LocationCode == "ProductStationB03").ToList();
                        //Inventory inventory = new Inventory
                        //{
                        //    Batch = Batch,
                        //    LocationCode = "ProductStationB03",
                        //    QrCode = QRCode,
                        //    TaskSteps = 1,
                        //    Lot = Lot,
                        //    MaterialCode = material,
                        //    Status = InventoryStatus.良品,
                        //    ContainerStatus = ContainerStatus.满,
                        //    Qty = num,
                        //    Position = inventoriesNum.Count() + 1,
                        //    ContainerCode = containerCode,
                        //    Combo = Typesetting,
                        //    TaskStatus = InventoryTaskType.任务锁定中,
                        //    Supplier = Supplier,
                        //    ResidualWeight = ResidualWeight,
                        //    OldBatch = OldBatch,
                        //    NameDescription = nameDescription,
                        //    Specification = specification,
                        //    Unit = unit,
                        //    Size = Size,
                        //    NumberofSheets = 0,
                        //    Groupnum = 0,
                        //    CostPrice = time,
                        //    StackingNumber = Groupnum,
                        //    Project = Project,
                        //    Customer = Customer,
                        //    Height = Height
                        //};
                        //_appi.Add(inventory);
                        //InventoryTransaction inventoryTransaction = new InventoryTransaction
                        //{
                        //    Type = "2楼复核",
                        //    SourceCode = inventory.SourceCode,
                        //    ContainerCode = inventory.ContainerCode,
                        //    Position = inventory.Position,
                        //    TaskSteps = inventory.TaskSteps,
                        //    MaterialCode = inventory.MaterialCode,
                        //    QrCode = QRCode,
                        //    Batch = inventory.Batch,
                        //    Lot = inventory.Lot,
                        //    Qty = inventory.Qty,
                        //    Supplier = inventory.Supplier,
                        //    ResidualWeight = inventory.ResidualWeight,
                        //    Retreat = inventory.Retreat,
                        //    Specification = inventory.Specification,
                        //    NameDescription = inventory.NameDescription,
                        //    Unit = inventory.Unit,
                        //    Size = inventory.Size,
                        //    NumberofSheets = inventory.NumberofSheets,
                        //    Groupnum = inventory.Groupnum,
                        //    OldBatch = inventory.OldBatch,
                        //    Combo = inventory.Combo,
                        //    Status = inventory.Status,
                        //    LocationCode = inventory.LocationCode,
                        //    StackingNumber = inventory.StackingNumber,
                        //    CreateTime = inventory.CreateTime,
                        //    UpdateTime = DateTime.Now,
                        //    Height = inventory.Height
                        //};
                        //_unitWork.Add(inventoryTransaction);

                        //response.code = 200;
                        //response.msg = "托盘号" + inventory.ContainerCode + "上位置为" + inventory.Position + "的物料复核成功！";
                        //return response;
                        List<Inventory> inventories1 = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode && n.LocationCode == "ExitStationB02(P3328)").ToList();
                        if (inventories1.Count() > 0)
                        {
                            
                            Inventory Repeatinv = _unitWork.Find<Inventory>(n => n.QrCode == QRCode && n.ContainerCode == containerCode && n.TaskSteps == 1).FirstOrDefault();
                            if (Repeatinv != null)
                            {
                                response.code = 300;
                                response.msg = "该物料已经复核过<br/>请按顺序扫描下个物料！";
                                return response;
                            }
                            //物料总数
                            int InvCount = inventories1.Count();
                            //需要重新复核物料
                            int Errinv = inventories1.Where(n => n.TaskSteps == 99).Count();
                            //已经重新复核物料数量
                            int InvCount1 = inventories1.Where(n => n.TaskSteps == 1).Count();
                            //未复核物料数量
                            int InvCount3 = inventories1.Where(n => n.TaskSteps == 0).Count();
                            //物料重新复核
                            if (Errinv > 0)
                            {
                                Inventory inventory = new Inventory
                                {
                                    Batch = Batch,
                                    LocationCode = "ExitStationB02(P3328)",
                                    TaskSteps = 1,
                                    QrCode = QRCode,
                                    Lot = Lot,
                                    MaterialCode = material,
                                    Status = InventoryStatus.良品,
                                    ContainerStatus = ContainerStatus.满,
                                    Qty = num,
                                    Position = InvCount1 + 1,
                                    ContainerCode = containerCode,
                                    Combo = Typesetting,
                                    TaskStatus = InventoryTaskType.任务锁定中,
                                    Supplier = Supplier,
                                    ResidualWeight = ResidualWeight,
                                    OldBatch = OldBatch,
                                    NameDescription = nameDescription,
                                    Specification = specification,
                                    Unit = unit,
                                    Size = Size,
                                    NumberofSheets = 0,
                                    Groupnum = 0,
                                    CostPrice = time,
                                    StackingNumber = Groupnum,
                                    Project = Project,
                                    Customer = Customer,
                                    Height = Height,
                                    CreateTime = DateTime.Now
                                };
                                _appi.Add(inventory);
                                InventoryTransaction inventoryTransaction = new InventoryTransaction
                                {
                                    Type = "2楼重新复核",
                                    SourceCode = inventory.SourceCode,
                                    UserDef1 = "",
                                    ContainerCode = inventory.ContainerCode,
                                    Position = inventory.Position,
                                    TaskSteps = inventory.TaskSteps,
                                    MaterialCode = inventory.MaterialCode,
                                    QrCode = QRCode,
                                    Batch = inventory.Batch,
                                    Lot = inventory.Lot,
                                    Qty = inventory.Qty,
                                    Supplier = inventory.Supplier,
                                    ResidualWeight = inventory.ResidualWeight,
                                    Retreat = inventory.Retreat,
                                    Specification = inventory.Specification,
                                    NameDescription = inventory.NameDescription,
                                    Unit = inventory.Unit,
                                    Size = inventory.Size,
                                    NumberofSheets = inventory.NumberofSheets,
                                    Groupnum = inventory.Groupnum,
                                    OldBatch = inventory.OldBatch,
                                    Combo = inventory.Combo,
                                    Status = inventory.Status,
                                    LocationCode = inventory.LocationCode,
                                    StackingNumber = inventory.StackingNumber,
                                    CreateTime = inventory.CreateTime,
                                    UpdateTime = DateTime.Now,
                                    Height = inventory.Height
                                };
                                _unitWork.Add(inventoryTransaction);

                                response.code = 200;
                                response.msg = "托盘" + inventory.ContainerCode + "位置为" + inventory.Position + "的物料复核成功！";
                                return response;
                            }
                            else if (InvCount3 > 0)
                            {
                                //已复核数量
                                int InvCount2 = InvCount - InvCount3;
                                Inventory inv = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode && n.LocationCode == "ExitStationB02(P3328)" && n.QrCode == QRCode).FirstOrDefault();
                                if (inv != null)
                                {
                                    Inventory inventory = new Inventory
                                    {
                                        Batch = Batch,
                                        LocationCode = inv.LocationCode,
                                        SourceCode = inv.SourceCode,
                                        ReceiptCode = inv.ReceiptCode,
                                        QrCode = QRCode,
                                        TaskSteps = 1,
                                        ReceiptId = inv.ReceiptId,
                                        ReceiptDetailId = inv.ReceiptDetailId,
                                        Lot = Lot,
                                        MaterialCode = material,
                                        Status = InventoryStatus.良品,
                                        ContainerStatus = ContainerStatus.满,
                                        Qty = num,
                                        Position = InvCount2 + 1,
                                        ContainerCode = containerCode,
                                        Combo = Typesetting,
                                        TaskStatus = InventoryTaskType.任务锁定中,
                                        Supplier = Supplier,
                                        ResidualWeight = ResidualWeight,
                                        Retreat = inv.Retreat,
                                        OldBatch = OldBatch,
                                        NameDescription = nameDescription,
                                        Specification = specification,
                                        Unit = unit,
                                        Size = Size,
                                        NumberofSheets = 0,
                                        Groupnum = 0,
                                        CostPrice = time,
                                        StackingNumber = Groupnum,
                                        Project = Project,
                                        Customer = Customer,
                                        SourceLine = inv.SourceLine,
                                        Checkud = inv.Checkud,
                                        Remark = inv.Remark,
                                        Height = inv.Height,
                                        ErpWareCell = inv.ErpWareCell
                                    };
                                    _appi.Add(inventory);
                                    InventoryTransaction inventoryTransaction = new InventoryTransaction
                                    {
                                        Type = "2楼复核",
                                        SourceCode = inv.SourceCode,
                                        UserDef1 = "",
                                        ContainerCode = inv.ContainerCode,
                                        Position = inventory.Position,
                                        TaskSteps = inv.TaskSteps,
                                        MaterialCode = inv.MaterialCode,
                                        QrCode = QRCode,
                                        Batch = inv.Batch,
                                        Lot = inv.Lot,
                                        Qty = inv.Qty,
                                        Supplier = inv.Supplier,
                                        ResidualWeight = inv.ResidualWeight,
                                        Retreat = inv.Retreat,
                                        Specification = inv.Specification,
                                        NameDescription = inv.NameDescription,
                                        Unit = inv.Unit,
                                        Size = inv.Size,
                                        NumberofSheets = inv.NumberofSheets,
                                        Groupnum = inv.Groupnum,
                                        OldBatch = inv.OldBatch,
                                        Combo = inv.Combo,
                                        Customer = inv.Customer,
                                        Status = inv.Status,
                                        LocationCode = inv.LocationCode,
                                        StackingNumber = inv.StackingNumber,
                                        CreateTime = inv.CreateTime,
                                        UpdateTime = DateTime.Now,
                                        Height = inv.Height
                                    };
                                    _unitWork.Add(inventoryTransaction);
                                    _appi.Delete(inv);

                                    response.code = 200;
                                    response.msg = "托盘" + inv.ContainerCode + "位置为" + inventory.Position + "的物料复核成功！";
                                    return response;
                                }
                                else
                                {
                                    response.code = 300;
                                    response.msg = "托盘号"+ containerCode + "上没有二维码是" + QRCode + "的物料！！";
                                    return response;
                                }
                            }
                            else
                            {
                                response.code = 300;
                                response.msg = "复核区未找到托盘号上" + containerCode + "待复核的物料！";
                                return response;
                            }
                        }
                        else
                        {
                            response.code = 300;
                            response.msg = "复核区未找到托盘号" + containerCode + "的物料！";
                            return response;
                        }
                    }
                    if (s.Containercode != container.Code)
                    {
                        response.code = 300;
                        response.msg = "该托盘未占用" + s.Name + "站台";
                        return response;
                    }

                    if (!_unitWork.IsExist<Station>(n => n.Code == containerCode))
                    {
                        containerCode = container.Code;
                        container.Status = ContainerStatus.满;
                        _unitWork.Update(container);
                    }
                    Inventory IsInv = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode).FirstOrDefault();
                    if (IsInv != null)
                    {
                        //if ((s.Type == 10 || s.Code == "EntranceStationY01") && s.IsPass == 1 && material != "000")
                        //{
                        //    List<Inventory> invs = _unitWork.Find<Inventory>(n => n.ContainerCode == containerCode).ToList();
                        //    if (invs.Count() > 0)
                        //    {
                        //        response.code = 300;
                        //        response.msg = "托盘号：" + containerCode + "上已经绑定了单据物料<br/>物料二维码为：" + invs[0].QrCode + "<br/>绑定单据号为" + invs[0].SourceCode;
                        //        return response;
                        //    }
                        //}
                        Inventory Onlyinv = new Inventory();
                        Inventory TBinv = new Inventory();
                        //PP片批次唯一
                        if (containerCode.StartsWith("N5PP") && OldBatch != "000")
                        {
                            Onlyinv = _unitWork.Find<Inventory>(n => n.OldBatch == OldBatch).FirstOrDefault();
                            if (Onlyinv != null)
                            {
                                response.code = 300;
                                response.msg = "<br/>托盘号:" + containerCode + "上批次为:" + OldBatch + "的物料二维码已经扫过,请扫描下一个物料二维码";
                                return response;
                            }
                        }
                        //铜箔批号(工单号)唯一
                        else if (containerCode.StartsWith("N5TB"))
                        {
                            TBinv = _unitWork.Find<Inventory>(n => n.Lot == Lot).FirstOrDefault();
                            if (TBinv != null)
                            {
                                response.code = 300;
                                response.msg = "<br/>托盘号:" + containerCode + "上工单号为:" + Lot + "的物料二维码已经扫过,请扫描下一个物料二维码";
                                return response;
                            }
                        }
                        //PP卷批次唯一
                        else if (containerCode.StartsWith("N5PJ") || s.Code == "OutStationB07(P3300)")
                        {
                            TBinv = _unitWork.Find<Inventory>(n => n.OldBatch == OldBatch).FirstOrDefault();
                            if (TBinv != null)
                            {
                                response.code = 300;
                                response.msg = "<br/>托盘号:" + containerCode + "上批次为:" + OldBatch + "的物料二维码已经扫过,请扫描下一个物料二维码";
                                return response;
                            }
                        }
                    }
                    ReceiptDetail recep = _unitWork.Find<ReceiptDetail>(n => n.Project == QRCode && n.Status == 0).OrderByDescending(n => n.CreateTime).FirstOrDefault();
                    string NewSourceCode = "无单据号";
                    string NewReceiptCode = "";
                    string NewMoCode = "正常数据";
                    int? NewReceiptCodeId = 0;
                    int? NewReceiptDetailId = 0;
                    string OutType = "0";
                    decimal? NewNum = num;
                    string Checkud = "";
                    string Remark = "";
                    var truss = 0;
                    var WarehouseType = "";
                    //入库仓
                    string WH = "";
                    //线边仓
                    string LWH = "";
                    //线边仓储位
                    string LWHSL = "";
                    if (containerCode.Contains("N5TB"))
                    {
                        WarehouseType = "TB_WareCell";
                    }
                    else if (containerCode.Contains("N5PP"))
                    {
                        WarehouseType = "PP_WareCell";
                    }
                    else if (containerCode.Contains("N5PJ"))
                    {
                        WarehouseType = "PJ_WareCell";
                    }
                    //特殊仓库
                    string SpecialWarehouse = "";
                    //物性卡控Y不允许出
                    string IsoutControl = "";
                    //ERP仓位
                    string ErpWareCell = "";
                    //绑定入库单信息
                    if (recep != null)
                    {
                        Checkud = recep.Checkud;
                        Remark = recep.Remark;
                        NewNum = recep.Qty;
                        ReceiptHeader recepH = _unitWork.Find<ReceiptHeader>(n => n.SourceCode == recep.SourceCode).FirstOrDefault();
                        if (recepH != null && recepH.SupplierCode != "")
                        {
                            Supplier = recepH.SupplierCode;
                        }
                        SpecialWarehouse = recepH.WarehouseType;
                        NewSourceCode = recep.SourceCode;
                        NewReceiptCode = recep.ReceiptCode;
                        NewReceiptCodeId = recep.ReceiptId;
                        NewReceiptDetailId = recep.Id;
                        ErpWareCell = recep.ErpWareCell;
                        OutType = recep.SourceLine;
                        WH = recepH.WH;
                        LWH = recepH.LWH;
                        LWHSL = recepH.LWHSL;
                        recep.QtyCompleted += recep.Qty;
                        if (recep.MoCode == "余料退库")
                        {
                            NewMoCode = "余料退库";
                        }
                        else if (recep.MoCode == "叫料退库")
                        {
                            NewMoCode = "叫料退库";
                        }
                        else if (recep.MoCode == "D621")
                        {
                            NewMoCode = "D621";
                        }

                        if (recep.Qty == recep.QtyCompleted && recep.Status < ReceiptHeaderStatus.回传)
                        {
                            recep.Status = ReceiptHeaderStatus.过账;
                        }
                        else
                        {
                            recep.Status = ReceiptHeaderStatus.收货;
                        }
                        recep.UpdateTime = DateTime.Now;
                        _unitWork.Update(recep);

                        ReceiptHeader receh = _unitWork.Find<ReceiptHeader>(n => n.SourceCode == recep.SourceCode).FirstOrDefault();
                        if (receh != null)
                        {
                            receh.FirstStatus = ReceiptHeaderStatus.收货;
                            receh.UpdateTime = DateTime.Now;
                            _unitWork.Update(receh);
                        }
                        response.data = recep.SourceCode;
                    }
                    else
                    {
                        Station PassStation = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                        StationRoadway stationRoadway = _unitWork.Find<StationRoadway>(n => n.StationCode == station).FirstOrDefault();
                        if (stationRoadway == null || PassStation == null)
                        {
                            response.code = 300;
                            response.msg = "站台错误！！";
                            return response;
                        }
                        //铜箔
                        if (stationRoadway.RoadWay == 1 && PassStation.IsPass == 1)
                        {
                            response.code = 300;
                            response.msg = "MES错误：铜箔仓无单据号，禁止入库";
                            return response;
                        }
                        //PP片
                        if (stationRoadway.RoadWay == 2 && PassStation.IsPass == 1 && material != "000")
                        {
                            response.code = 300;
                            response.msg = "MES错误：PP片仓无单据号，禁止入库";
                            return response;
                        }
                        //PP卷卡控
                        else if (stationRoadway.RoadWay == 3 && PassStation.IsPass == 1)
                        {
                            response.code = 300;
                            response.msg = "MES错误：PP卷仓无单据号，禁止入库";
                            return response;
                        }
                        response.data = "无单据号";
                    }
                    
                    List<Inventory> inventories =
                        _unitWork.Find<Inventory>(n => n.ContainerCode == container.Code).ToList();
                    //铜箔桁架判断
                    if (station == "TrussStation" && Truss == "One")
                    {
                        if (inventories.Any())
                        {
                            response.code = 300;
                            response.msg = "当前为一个物料一个托盘模式，入库口托盘已经有一个物料，不允许多放物料";
                            return response;
                        }
                        else
                        {
                            truss = 3;
                        }
                    }
                    else if (station == "TrussStation" && Truss == "Two")
                    {
                        if (!inventories.Any())
                        {
                            truss = 1;
                        }
                        else if (inventories.Count() == 1)
                        {
                            truss = 2;
                        }
                        else
                        {
                            response.code = 300;
                            response.msg = "当前托盘上已经有两个物料，不允许多放物料！！";
                            return response;
                        }
                    }
                    //PP卷入库绑定物料位置
                    StationRoadway stationRoadway1 = _unitWork.Find<StationRoadway>(n => n.StationCode == s.Code).FirstOrDefault();
                    if (stationRoadway1 != null && stationRoadway1.RoadWay == 3)
                    {
                        if (inventories.Count() > 0)
                        {
                            truss = inventories.Count() + 1;
                        }
                        else
                        {
                            truss = 1;
                        }
                    }
                    //铜箔桁架
                    if (station == "TrussStation")
                    {
                        Inventory inventory = new Inventory
                        {
                            WarehouseType = WarehouseType,
                            Batch = Batch,
                            LocationCode = station,
                            TaskSteps = TaskSteps.初始,
                            SourceCode = NewSourceCode,
                            ReceiptCode = NewReceiptCode,
                            SpecialWarehouse = SpecialWarehouse,
                            QrCode = QRCode,
                            ReceiptId = NewReceiptCodeId,
                            ReceiptDetailId = NewReceiptDetailId,
                            Lot = Lot,
                            MaterialCode = material,
                            Status = InventoryStatus.良品,
                            ContainerStatus = ContainerStatus.满,
                            Qty = NewNum,
                            Position = truss,
                            ContainerCode = containerCode,
                            Combo = Typesetting,
                            TaskStatus = InventoryTaskType.任务锁定中,
                            Supplier = Supplier,
                            ResidualWeight = ResidualWeight,
                            Retreat = NewMoCode,
                            OldBatch = OldBatch,
                            NameDescription = nameDescription,
                            Specification = specification,
                            Unit = unit,
                            Size = Size,
                            NumberofSheets = 0,
                            Groupnum = 0,
                            CostPrice = time,
                            StackingNumber = Groupnum,
                            Project = Project,
                            Customer = Customer,
                            SourceLine = OutType,
                            Checkud = Checkud,
                            Remark = Remark,
                            Height = Height,
                            IsoutControl = IsoutControl,
                            ErpWareCell = ErpWareCell
                        };
                        _appi.Add(inventory);
                    }
                    else
                    {
                        Inventory inventory = new Inventory
                        {
                            WarehouseType = WarehouseType,
                            Batch = Batch,
                            LocationCode = s.Code,
                            SourceCode = NewSourceCode,
                            ReceiptCode = NewReceiptCode,
                            SpecialWarehouse = SpecialWarehouse,
                            QrCode = QRCode,
                            TaskSteps = TaskSteps.初始,
                            ReceiptId = NewReceiptCodeId,
                            ReceiptDetailId = NewReceiptDetailId,
                            Lot = Lot,
                            MaterialCode = material,
                            Status = InventoryStatus.良品,
                            ContainerStatus = ContainerStatus.满,
                            Qty = NewNum,
                            Position = truss,
                            ContainerCode = containerCode,
                            Combo = Typesetting,
                            TaskStatus = InventoryTaskType.任务锁定中,
                            Supplier = Supplier,
                            ResidualWeight = ResidualWeight,
                            Retreat = NewMoCode,
                            OldBatch = OldBatch,
                            NameDescription = nameDescription,
                            Specification = specification,
                            Unit = unit,
                            Size = Size,
                            NumberofSheets = 0,
                            Groupnum = 0,
                            CostPrice = time,
                            StackingNumber = Groupnum,
                            Project = Project,
                            Customer = Customer,
                            SourceLine = OutType,
                            Checkud = Checkud,
                            Remark = Remark,
                            Height = Height,
                            IsoutControl = IsoutControl,
                            ErpWareCell = ErpWareCell,
                            WH = WH,
                            LWH = LWH,
                            LWHSL = LWHSL
                        };
                        _appi.Add(inventory);
                    }
                    
                }
                else
                {
                    response.code = 300;
                    response.msg = "未找到此托盘数据或占用,托盘号为：" + containerCode;
                    return response;
                }
                int count = _unitWork.Find<Inventory>(n => n.ContainerCode == container.Code).Count();
                response.msg = count.ToString();
            }
            catch (Exception ex)
            {
                response.code = 500;
                response.msg = ex.Message + "%" + ex.Source + "%" + ex.InnerException;
            }
            return response;
        }

        // <summary>
        /// 站台到站台
        /// </summary>
        public TableData StationToStationApp(string containerCode, string startStation, string endStation,string material)
        {
            TableData response = new TableData();
            response.code = 200;
            int tastdetail = _unitWork.Find<TaskDetail>(n => n.ContainerCode == containerCode).Count();
            if (tastdetail > 0)
            {
                response.code = 300;
                response.msg = "该托盘已经有正在执行的任务."; ;
                return response;
            }
            IStationTaskApp stationTaskApp = new IStationTaskApp(_unitWork, _auth, _context, _apprh);
            response = stationTaskApp.StationTask(containerCode, startStation, endStation);
            if (response.code == 200)
            {
                response.msg = "任务创建成功";
                return response;
            }
            else
            {
                response.code = 300;
                response.msg = "任务创建失败" + response.msg;
                return response;
            }
        }
        //手动空板补给
        public Response EmptyPalletOutApp(string station, string type,int Roadway = 0)
        {
            Response response = new Response();
            try
            {
                var LocType = LocationStatus.空容器;
                if (type == ContainerType.空托盘组)
                {
                    LocType = LocationStatus.空容器组;
                }
                StationRoadway stationRoadway = null;
                Station sta = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                if (sta.Type == StationType.PP片上胶站台)
                {
                    //用PP片入库位置找出PP片空栈板补给仓位
                    StationToStation stationToStation = _unitWork.Find<StationToStation>(n => n.EndStation == station).FirstOrDefault();
                    stationRoadway = (from sr in _unitWork.Find<StationRoadway>(n => n.StationCode == stationToStation.StartStation)
                        join st in _unitWork.Find<Station>(n => n.Code == stationToStation.StartStation && n.IsEmpty == 1 && n.Containercode == "")
                            on sr.StationCode equals st.Code
                        select sr).FirstOrDefault();
                }
                else
                {
                    stationRoadway = (from sr in _unitWork.Find<StationRoadway>(n => n.StationCode == station)
                        join st in _unitWork.Find<Station>(n => n.Code == station && n.IsEmpty == 1 && n.Containercode == "")
                            on sr.StationCode equals st.Code
                        select sr).FirstOrDefault();
                }

                if (stationRoadway == null)
                {
                    var iscon = "";
                    Station Stcon = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                    iscon = Stcon.Containercode;
                    if (string.IsNullOrEmpty(Stcon.Containercode))
                    {
                        StationToStation stationTo = _unitWork.Find<StationToStation>(n => n.EndStation == station).FirstOrDefault();
                        if (stationTo != null)
                        {
                            Station station1 = _unitWork.Find<Station>(n => n.Code == stationTo.StartStation).FirstOrDefault();
                            if (station1 != null && !string.IsNullOrEmpty(station1.Containercode))
                            {
                                iscon = station1.Containercode;
                            }
                        }
                    }
                    response.Code = 300;
                    response.Message = "站台占用失败，" + Stcon.Name + "站台已被" + iscon + "占用！";
                    return response;
                }

                int count = _unitWork.Find<TaskDetail>(u => u.DestinationLocation == stationRoadway.StationCode && u.Status >= TaskStatus.新建任务 && u.Status < TaskStatus.已经完成 && (u.TaskType == TaskType.容器出库 || u.TaskType == TaskType.空容器出库 || u.TaskType == TaskType.站台到站台)).Count();
                if (count > 0)
                {
                    response.Code = 300;
                    response.Message = "已有该站台出库任务！";
                    return response;
                }
                if (stationRoadway != null)
                {
                    List<Station> list = (from st in _unitWork.Find<Station>(n => n.Type == StationType.空板暂存区站台)
                                          join sts in _unitWork.Find<StationToStation>(n => n.EndStation == stationRoadway.StationCode)
                                           on st.Code equals sts.StartStation
                                          select st).ToList();
                    if (list.Count > 0)
                    {
                        foreach (Station stat in list)
                        {
                            List<StoreStation> cons = _unitWork.Find<StoreStation>(n => n.StationCode == stat.Code).OrderBy(n => n.CreateTime).ToList();
                            foreach (StoreStation con in cons)
                            {
                                var Tostation = _unitWork.Find<TaskDetail>(n => n.ContainerCode == con.ContainerCode && n.TaskType == TaskType.站台到站台).Count();
                                if (Tostation < 1)
                                {
                                    Task ptask = new Task();
                                    TaskDetail ptaskDetail = new TaskDetail();
                                    var taskNo = "SD" + _app.GetTaskNo(TaskNo.空板补充);
                                    ptask.TaskNo = taskNo;
                                    ptask.OrderCode = taskNo;
                                    ptask.BusinessType = BusinessType.出库_其他出库单;
                                    ptask.FirstStatus = TaskStatus.待下发任务;
                                    ptask.LastStatus = TaskStatus.待下发任务;
                                    ptask.CreateTime = DateTime.Now;
                                    _unitWork.Add(ptask);

                                    ptaskDetail.TaskNo = taskNo;
                                    ptaskDetail.OrderCode = taskNo;
                                    ptaskDetail.TaskType = TaskType.站台到站台;
                                    ptaskDetail.ContainerCode = con.ContainerCode;
                                    ptaskDetail.SourceLocation = stat.Code;
                                    ptaskDetail.DestinationLocation = stationRoadway.StationCode;
                                    ptaskDetail.OderQty = 0;
                                    ptaskDetail.ContainerQty = 0;
                                    ptaskDetail.HadQty = 0;
                                    ptaskDetail.Roadway = stationRoadway.RoadWay;
                                    ptaskDetail.Station = stationRoadway.StationCode;
                                    if (con.Status == StoreStationStatus.任务中)
                                    {
                                        ptaskDetail.Status = TaskStatus.新建任务;
                                    }
                                    else
                                    {
                                        ptaskDetail.Status = TaskStatus.待下发任务;
                                    }
                                    ptaskDetail.Priority = 99;
                                    ptaskDetail.CreateTime = DateTime.Now;
                                    _unitWork.Add(ptaskDetail);
                                    if (con.Status == StoreStationStatus.到达站台)
                                    {
                                        _unitWork.Delete(con);
                                    }
                                    return response;
                                }
                                else
                                {
                                    continue;
                                }
                            }

                        }
                        Container containerempty = null;
                        if (stationRoadway.StationPlace == StationPlace.巷道北面)
                        {
                            containerempty = (from con in _unitWork.Find<Container>(n => n.Type == type && n.Status == ContainerStatus.空 && n.IsLock == 0)
                                              join loc in _unitWork.Find<Location>(n => n.Roadway == stationRoadway.RoadWay && n.Status == LocType)
                                              on con.LocationCode equals loc.Code
                                              orderby loc.RowIndex == 2 ? 0 : loc.RowIndex, loc.Row
                                              select con).FirstOrDefault();
                        }
                        else if (stationRoadway.StationPlace == StationPlace.巷道南面)
                        {
                            containerempty = (from con in _unitWork.Find<Container>(n => n.Type == type && n.Status == ContainerStatus.空 && n.IsLock == 0)
                                              join loc in _unitWork.Find<Location>(n => n.Roadway == stationRoadway.RoadWay && n.Status == LocType)
                                              on con.LocationCode equals loc.Code
                                              orderby loc.RowIndex == 2 ? 0 : loc.RowIndex, loc.Row descending
                                              select con).FirstOrDefault();
                        }
                        else
                        {
                            containerempty = (from con in _unitWork.Find<Container>(n => n.Type == type && n.Status == ContainerStatus.空 && n.IsLock == 0)
                                              join loc in _unitWork.Find<Location>(n => n.Roadway == stationRoadway.RoadWay && n.Status == LocType)
                                              on con.LocationCode equals loc.Code
                                              orderby loc.RowIndex == 2 ? 0 : loc.RowIndex
                                              select con).FirstOrDefault();
                        }

                        string endStation = list.First().Code;
                        if (containerempty == null)
                        {
                            response.Code = 300;
                            if (LocType == ContainerType.空托盘组)
                            {
                                response.Message = "库内无空托盘组！";
                            }
                            else
                            {
                                response.Message = "库内无空托盘！";
                            }
                            return response;
                        }
                        //建立容器出库任务
                        if (!_unitWork.IsExist<TaskDetail>(n => (n.Status >= TaskStatus.新建任务 && n.Status < TaskStatus.已经完成) && n.ContainerCode == containerempty.Code))
                        {
                            int ptdcount = _unitWork.Find<TaskDetail>(n => (n.Status >= TaskStatus.新建任务 && n.Status < TaskStatus.已经完成) && n.DestinationLocation == stationRoadway.StationCode).Count();
                            if (ptdcount < 1)
                            {
                                Task ptask = new Task();
                                TaskDetail ptaskDetail = new TaskDetail();
                                var taskNo = "SD" + _app.GetTaskNo(TaskNo.空板补充);
                                ptask.TaskNo = taskNo;
                                ptask.OrderCode = taskNo;
                                ptask.BusinessType = BusinessType.出库_其他出库单;
                                ptask.FirstStatus = TaskStatus.待下发任务;
                                ptask.LastStatus = TaskStatus.待下发任务;
                                ptask.CreateTime = DateTime.Now;
                                _unitWork.Add(ptask);

                                ptaskDetail.TaskNo = taskNo;
                                ptaskDetail.OrderCode = taskNo;
                                ptaskDetail.TaskType = TaskType.空容器出库;
                                ptaskDetail.ContainerCode = containerempty.Code;
                                ptaskDetail.SourceLocation = containerempty.LocationCode;
                                ptaskDetail.DestinationLocation = endStation;
                                ptaskDetail.OderQty = 0;
                                ptaskDetail.ContainerQty = 0;
                                ptaskDetail.HadQty = 0;
                                ptaskDetail.Roadway = stationRoadway.RoadWay;
                                ptaskDetail.Station = endStation;
                                ptaskDetail.Status = TaskStatus.待下发任务;
                                ptaskDetail.Priority = 99;
                                ptaskDetail.CreateTime = DateTime.Now;
                                _unitWork.Add(ptaskDetail);

                                containerempty.IsLock = 1;
                                _unitWork.Update(containerempty);

                                StoreStation storeStation = new StoreStation
                                {
                                    StationCode = endStation,
                                    ContainerCode = containerempty.Code,
                                    Status = StoreStationStatus.任务中,
                                    CreateTime = DateTime.Now
                                };
                                _unitWork.Add(storeStation);

                                Location loc = _unitWork.Find<Location>(n => n.Code == containerempty.LocationCode).FirstOrDefault();
                                _unitWork.Update<Location>(n => n.Id == loc.Id && n.Version == loc.Version, n => new Location
                                {
                                    Status = LocationStatus.任务锁定中
                                });

                                Task ptasksts = new Task();
                                TaskDetail ptaskDetailsts = new TaskDetail();
                                var taskNosts = "SD" +  _app.GetTaskNo(TaskNo.空板补充);
                                ptasksts.TaskNo = taskNosts;
                                ptasksts.OrderCode = taskNosts;
                                ptasksts.BusinessType = BusinessType.出库_其他出库单;
                                ptasksts.FirstStatus = TaskStatus.待下发任务;
                                ptasksts.LastStatus = TaskStatus.待下发任务;
                                ptasksts.CreateTime = DateTime.Now;
                                _unitWork.Add(ptasksts);

                                ptaskDetailsts.TaskNo = taskNosts;
                                ptaskDetailsts.OrderCode = taskNosts;
                                ptaskDetailsts.TaskType = TaskType.站台到站台;
                                ptaskDetailsts.ContainerCode = containerempty.Code;
                                ptaskDetailsts.SourceLocation = endStation;
                                ptaskDetailsts.DestinationLocation = stationRoadway.StationCode;
                                ptaskDetailsts.OderQty = 0;
                                ptaskDetailsts.ContainerQty = 0;
                                ptaskDetailsts.HadQty = 0;
                                ptaskDetailsts.Roadway = stationRoadway.RoadWay;
                                ptaskDetailsts.Station = stationRoadway.StationCode;
                                ptaskDetailsts.Status = TaskStatus.新建任务;
                                ptaskDetailsts.Priority = 99;
                                ptaskDetailsts.CreateTime = DateTime.Now;
                                _unitWork.Add(ptaskDetailsts);
                                return response;
                            }
                            else
                            {
                                response.Code = 300;
                                response.Message = "异常：站台:" + stationRoadway.StationCode + "已有任务！";
                                return response;
                            }
                        }
                        else
                        {
                            response.Code = 300;
                            response.Message = "异常：" + containerempty.Code + "托盘已有任务！";
                            return response;
                        }

                    }

                    List<Container> containers;
                    var StaRo = stationRoadway.RoadWay;
                    if (Roadway == 2)
                    {
                        StaRo = 2;
                    }
                    //****************成品空板补给小板优先出临仓位是空仓位的
                    //****************
                    if (stationRoadway.StationPlace == StationPlace.巷道北面)
                    {
                        containers = (from con in _unitWork.Find<Container>(n => n.Type == type && n.Status == ContainerStatus.空 && n.IsLock == 0)
                                     join loc in _unitWork.Find<Location>(n => n.Roadway == StaRo && n.Status == LocType)
                                     on con.LocationCode equals loc.Code
                                     orderby loc.RowIndex == 2 ? 0 : loc.RowIndex, loc.Row
                                     select con).ToList();
                    }
                    else if (stationRoadway.StationPlace == StationPlace.巷道南面)
                    {
                        containers = (from con in _unitWork.Find<Container>(n => n.Type == type && n.Status == ContainerStatus.空 && n.IsLock == 0)
                                     join loc in _unitWork.Find<Location>(n => n.Roadway == StaRo && n.Status == LocType)
                                     on con.LocationCode equals loc.Code
                                     orderby loc.RowIndex == 2 ? 0 : loc.RowIndex, loc.Row descending
                                     select con).ToList();
                    }
                    else
                    {
                        containers = (from con in _unitWork.Find<Container>(n => n.Type == type && n.Status == ContainerStatus.空 && n.IsLock == 0)
                                     join loc in _unitWork.Find<Location>(n => n.Roadway == StaRo && n.Status == LocType)
                                     on con.LocationCode equals loc.Code
                                     orderby loc.RowIndex == 2 ? 0 : loc.RowIndex
                                     select con).ToList();
                    }
                    Container container = null;
                    foreach (Container con in containers)
                    {
                        if (_unitWork.IsExist<TaskDetail>(n => n.ContainerCode == con.Code))
                        {
                            continue;
                        }
                        else
                        {
                            container = con;
                            break;
                        }
                    }

                    if (container == null)
                    {
                        if (LocType == LocationStatus.空容器组)
                        {
                            response.Message = "库内无空托盘组！";
                        }
                        else
                        {
                            response.Message = "库内无空托盘！";
                        }
                        response.Code = 300;
                        return response;
                    }

                    var pro = 99;
                    //建立容器出库任务
                    if (!_unitWork.IsExist<TaskDetail>(n => (n.Status >= TaskStatus.新建任务 && n.Status < TaskStatus.已经完成) && n.ContainerCode == container.Code))
                    {
                        int ptdcount = _unitWork.Find<TaskDetail>(n => (n.Status >= TaskStatus.新建任务 && n.Status < TaskStatus.已经完成) && n.DestinationLocation == stationRoadway.StationCode).Count();
                        if (ptdcount < 1)
                        {
                            Task ptask = new Task();
                            TaskDetail ptaskDetail = new TaskDetail();
                            var taskNo = "SD" + _app.GetTaskNo(TaskNo.空板补充);
                            ptask.TaskNo = taskNo;
                            ptask.OrderCode = taskNo;
                            ptask.BusinessType = BusinessType.出库_其他出库单;
                            ptask.FirstStatus = TaskStatus.待下发任务;
                            ptask.LastStatus = TaskStatus.待下发任务;
                            ptask.CreateTime = DateTime.Now;
                            _unitWork.Add(ptask);

                            ptaskDetail.TaskNo = taskNo;
                            ptaskDetail.OrderCode = taskNo;
                            ptaskDetail.TaskType = TaskType.空容器出库;
                            ptaskDetail.ContainerCode = container.Code;
                            ptaskDetail.SourceLocation = container.LocationCode;
                            ptaskDetail.DestinationLocation = stationRoadway.StationCode;
                            ptaskDetail.OderQty = 0;
                            ptaskDetail.ContainerQty = 0;
                            ptaskDetail.HadQty = 0;
                            ptaskDetail.Roadway = stationRoadway.RoadWay;
                            ptaskDetail.Station = stationRoadway.StationCode;
                            ptaskDetail.Status = TaskStatus.待下发任务;
                            ptaskDetail.Priority = pro;
                            ptaskDetail.CreateTime = DateTime.Now;
                            _unitWork.Add(ptaskDetail);

                            container.IsLock = 1;
                            _unitWork.Update(container);

                            List<Location> loc = _unitWork.Find<Location>(n => n.ContainerCode == container.Code).ToList();
                            if (loc.Count() > 0)
                            {
                                foreach (Location la in loc)
                                {
                                    _unitWork.Update<Location>(n => n.Id == la.Id && n.Version == la.Version, n => new Location
                                    {
                                        Status = LocationStatus.任务锁定中
                                    });
                                }
                            }
                        }
                        else
                        {
                            response.Code = 300;
                            response.Message = "异常：站台:" + stationRoadway.StationCode + "已有任务！";
                            return response;
                        }
                    }
                    else
                    {
                        response.Code = 300;
                        response.Message = "异常：" + container.Code + "托盘已有任务！";
                        return response;
                    }

                }
                else
                {
                    response.Code = 300;
                    response.Message = "此站台暂时不能补给空栈板！";
                    return response;
                }
            }
            catch (Exception ex)
            {
                response.Code = 300;
                response.Message = ex.Message;
            }
            return response;
        }

        // <summary>
        /// 对比托盘号,占用站台并创建容器
        /// </summary>
        public TableData PalletIsNo(string Pallet, string station, string type)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                if (_unitWork.IsExist<Location>(n => n.ContainerCode == Pallet))
                {
                    if (!_unitWork.IsExist<Inventory>(n => n.ContainerCode == Pallet && n.TaskStatus == InventoryTaskType.有盘点任务))
                    {
                        tab.code = 300;
                        tab.msg = "该托盘已在库内，并且不是盘点状态";
                        return tab;
                    }
                }
                TaskDetail IsTaskDetail = _unitWork.Find<TaskDetail>(n => n.ContainerCode == Pallet  && n.Status >= TaskStatus.新建任务 && n.Status < TaskStatus.已经完成).FirstOrDefault();
                if (IsTaskDetail != null)
                {
                    tab.code = 300;
                    tab.msg = "错误:托盘号已经有任务正在执行！！";
                    return tab;
                }
                Station Station = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                if (Station == null)
                {
                    tab.code = 300;
                    tab.msg = "没有找到站台";
                    return tab;
                }
                if (Station.Code == "EntranceStationB01(P3106)")
                {
                    TaskDetail tad = _unitWork.Find<TaskDetail>(n => n.DestinationLocation == "ExitStationB01(P3100)" && n.Status >= TaskStatus.下达任务).FirstOrDefault();
                    if (tad != null)
                    {
                        tab.code = 300;
                        tab.msg = "提升机已有出库任务在执行，不允许入库！！";
                        return tab;
                    }
                }
                if (Station.Code == "ProductStationB01" || Station.Code == "ProductStationB02")
                {
                    TaskDetail tad = _unitWork.Find<TaskDetail>(n => n.DestinationLocation == Station.Code).FirstOrDefault();
                    if (tad != null)
                    {
                        tab.code = 300;
                        tab.msg = "已有"+ Station .Name + "站台出库任务，不允许入库！！";
                        return tab;
                    }
                }
                Station PalletStation = _unitWork.Find<Station>(n => n.Containercode == Pallet).FirstOrDefault();
                if (Station.Type == StationType.PP片上胶站台)
                {
                    //用PP片入库位置找出PP片空栈板补给仓位
                    Station s = (from se in _unitWork.Find<Station>(n => n.IsEmpty == 1 && n.IsStop == 0 && n.Containercode == Pallet)
                        join sts in _unitWork.Find<StationToStation>(a => a.EndStation == station)
                            on se.Code equals sts.StartStation
                        select se).FirstOrDefault();
                    if (s != null)
                    {
                        s.Containercode = "";
                        s.UpdateBy = "wms";
                        s.UpdateTime = DateTime.Now;
                        _unitWork.Update(s);
                    }
                }
                else if (PalletStation != null)
                {
                    if (PalletStation.Code != station)
                    {
                        tab.code = 300;
                        tab.msg = "该托盘已经占用了另一个站台，<br>站台为：" + PalletStation.Name;
                        return tab;
                    }
                }
                //PP卷2楼复核区
                if (Station.Code == "ProductStationB03")
                {
                    List<Inventory> inventories = _unitWork.Find<Inventory>(n => n.ContainerCode == Pallet && n.LocationCode == "ExitStationB02(P3328)").ToList();
                    if (inventories.Count() > 0)
                    {
                        //异常物料数量
                        List<Inventory> Errinventories = _unitWork.Find<Inventory>(n => n.ContainerCode == Pallet && n.LocationCode == "ExitStationB02(P3328)" && n.TaskSteps == 99).ToList();
                        //重新复核物料数量
                        List<Inventory> Newinventories = _unitWork.Find<Inventory>(n => n.ContainerCode == Pallet && n.LocationCode == "ExitStationB02(P3328)" && n.TaskSteps == 1).ToList();
                        if (Errinventories.Count() > 0)
                        {
                            tab.count = Errinventories.Count();
                            tab.data = 99;
                        }
                        else
                        {
                            tab.count = inventories.Count();
                        }
                        return tab;
                    }
                    else
                    {
                        tab.code = 300;
                        tab.msg = "复核区未找到托盘位" + Pallet + "的物料！";
                        return tab;
                    }
                }
                //允许托盘号在站台上覆盖
                if (Station.Containercode.Trim() == "" || Station.Containercode == Pallet || ((Station.Type == StationType.PP片叠配站台 || station == "EntranceStationB01(P3106)" || station == "EntranceStationC01(P2046)") && Station.Containercode != ""))
                {
                    Container Container = _unitWork.Find<Container>(n => n.Code == Pallet).FirstOrDefault();
                    StationRoadway sta = _unitWork.Find<StationRoadway>(n => n.StationCode == station).FirstOrDefault();
                    if (Container == null)
                    {
                        Container con = new Container();
                        con.Code = Pallet;
                        con.LocationCode = station;
                        con.IsLock = ContainerLock.任务锁;
                        con.Status = ContainerStatus.空;
                        con.Type = type;
                        con.PrintCount = 0;
                        con.CreateTime = DateTime.Now;
                        _unitWork.Add(con);

                    }
                    else if (Container != null && Container.IsLock == ContainerLock.未锁)
                    {
                        tab.code = 300;
                        tab.msg = "库内已有该托盘，或容器状态错误";
                        return tab;
                    }
                    //else if (Container != null)
                    //{
                    //    if (Container.Type != type)
                    //    {
                    //        tab.code = 300;
                    //        tab.msg = "选择托盘类型与系统托盘类型不符合，请联系管理员！！";
                    //        return tab;
                    //    }
                    //}
                    if (Station.Containercode.Trim() == "")
                    {
                        Station.Containercode = Pallet;
                        Station.UpdateTime = DateTime.Now;
                        _unitWork.Update(Station);
                    }
                    if (Station.Containercode != Pallet)
                    {
                        TaskDetail taskDetail = _unitWork.Find<TaskDetail>(n => n.ContainerCode == Station.Containercode && n.Status >= TaskStatus.新建任务 && n.Status < TaskStatus.已经完成).FirstOrDefault();
                        if (taskDetail == null)
                        {
                            tab.code = 300;
                            tab.msg = "错误:托盘号" + Station.Containercode + "还在占用该站台，请先为" + Station.Containercode + "托盘创建回库任务";
                            return tab;
                        }
                        else if (taskDetail.Status < TaskStatus.下达任务)
                        {
                            tab.code = 300;
                            tab.msg = "错误:托盘号" + Station.Containercode + "任务已经创建</br>但还未下发，请等待30秒后再操作";
                            return tab;
                        }
                        else
                        {
                            Station.Containercode = Pallet;
                            Station.UpdateTime = DateTime.Now;
                            _unitWork.Update(Station);
                        }
                    }
                }
                else
                {
                    tab.code = 300;
                    tab.msg = "托盘号错误,站台数据托盘为：" + Station.Containercode + "</br>扫描到的托盘号为：" + Pallet + "";
                    return tab;
                }
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        /// <summary>
        /// 通过站台查询已锁站台托盘号（暂存区专用）
        /// </summary>
        /// <param name="station">暂存区站台号</param>
        /// <returns></returns>
        public TableData SelStation(string station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                Station Station = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                if (Station == null)
                {
                    tab.code = 300;
                    tab.msg = "没有找到站台";
                    return tab;
                }
                else
                {
                    if (Station.Code == "TrussStation")
                    {
                        Station = _unitWork.Find<Station>(n => n.Code == "EntranceStationD01(P1000)").FirstOrDefault();
                    }
                    if (Station.Containercode == "" && !Station.Code.Contains("BufferStationB"))
                    {
                        tab.code = 300;
                        tab.msg = "当前站台没有托盘占用";
                        return tab;
                    }
                    else
                    {
                        List<Inventory> invs = _unitWork.Find<Inventory>(n => n.ContainerCode == Station.Containercode).ToList();
                        if (invs.Count > 0)
                        {
                            foreach (Inventory inv in invs)
                            {
                                if (Station.Code.Contains("BufferStationA") && Station.IsPass == 1)
                                {
                                    ReceiptDetail rec = _unitWork.Find<ReceiptDetail>(n => n.Project == inv.QrCode).OrderByDescending(n => n.CreateTime).FirstOrDefault();
                                    if (rec != null)
                                    {
                                        inv.SourceCode = rec.SourceCode;
                                        inv.Remark = rec.Remark;
                                        inv.Checkud = rec.Checkud;
                                        _unitWork.Update(inv);
                                        rec.Status = ReceiptHeaderStatus.过账;
                                        _unitWork.Update(rec);
                                        ReceiptHeader receh = _unitWork.Find<ReceiptHeader>(n => n.SourceCode == rec.SourceCode).FirstOrDefault();
                                        if (receh != null)
                                        {
                                            receh.FirstStatus = ReceiptHeaderStatus.过账;
                                            receh.UpdateTime = DateTime.Now;
                                            _unitWork.Update(receh);
                                        }
                                    }
                                    else
                                    {
                                        inv.SourceCode = "无单据";
                                        _unitWork.Update(inv);
                                        tab.code = 300;
                                        tab.msg = "无入库单据禁止入库！！";
                                        return tab;
                                    }
                                }
                            }
                            tab.data = Station;
                        }
                        else if (Station.Code.Contains("BufferStationB") || station.Contains("Truss"))
                        {
                            tab.data = Station;
                        }
                        else
                        {
                            tab.code = 300;
                            tab.msg = "占用该站台的托盘没有库存信息！！";
                            return tab;
                        }
                    }
                }

            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        /// <summary>
        /// 删除任务数据
        /// </summary>
        /// <param name="station">站台号</param>
        /// <returns></returns>
        public TableData DelTask(int Id, int Isout,string Name)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                Task entity = _app.FindSingle(u => u.Id == Id);
                TaskDetail tdNo = _unitWork.Find<TaskDetail>(n => n.TaskNo == entity.TaskNo).FirstOrDefault();
                List<TaskDetail> tds = _unitWork.Find<TaskDetail>(n => n.ContainerCode == tdNo.ContainerCode).OrderBy(n => n.Status).ToList();
                var Issued = 1;
                foreach (var td in tds)
                {
                    var isBeing = 0;
                    Task task = _unitWork.Find<Task>(n => n.TaskNo == td.TaskNo).FirstOrDefault();
                    Container con = _unitWork.Find<Container>(n => n.Code == td.ContainerCode).FirstOrDefault();
                    List<Location> loc = _unitWork.Find<Location>(n => n.ContainerCode == td.ContainerCode).ToList();
                    List<Station> sta = _unitWork.Find<Station>(n => n.Containercode == td.ContainerCode).ToList();
                    List<Inventory> invs = _unitWork.Find<Inventory>(n => n.ContainerCode == td.ContainerCode).ToList();
                    Location LocOne = _unitWork.Find<Location>(n => n.ContainerCode == td.ContainerCode).FirstOrDefault();
                    if (td != null && td.Status >= TaskStatus.下达任务)
                    {
                        //任务已经下发
                        Issued = 2;
                    }
                    else if(td != null && td.Status < TaskStatus.下达任务 && Issued != 2)
                    {
                        //任务未下发
                        Issued = 3;
                    }
                    var LocType = LocationStatus.空容器;
                    tab.count = Issued;
                    //库内
                    if (Isout == 0)
                    {
                        if (td.ContainerCode == "empty")
                        {
                            tab.code = 300;
                            tab.msg = "该任务不允许库内删除！";
                            return tab;
                        }
                        if (con != null)
                        {
                            if (con.Type == ContainerType.空托盘组)
                            {
                                LocType = LocationStatus.空容器组;
                            }
                            con.IsLock = 0;
                            if (!td.SourceLocation.Contains("BufferStation"))
                            {
                                con.LocationCode = LocOne.Code;
                            }
                            if (td.TaskType == TaskType.移库)
                            {
                                con.LocationCode = td.SourceLocation;
                            }
                            _unitWork.Update(con);
                        }
                        Location location = new Location();
                        if (td.TaskType == TaskType.整盘入库 || td.TaskType == TaskType.空容器入库 || td.TaskType == TaskType.容器回库 || td.TaskType == TaskType.补充入库)
                        {
                            location = _unitWork.Find<Location>(n => n.Code == td.DestinationLocation).FirstOrDefault();
                            if (loc == null)
                            {
                                tab.code = 300;
                                tab.msg = "入库任务未找到仓位，禁止库内删除";
                                return tab;
                            }
                        }
                        
                        if (loc.Count() > 0)
                        {
                            foreach (Location lo in loc)
                            {
                                if (td.TaskType == TaskType.空容器出库 || td.TaskType == TaskType.空容器入库)
                                {
                                    _unitWork.Update<Location>(n => n.ContainerCode == td.ContainerCode, n => new Location
                                    {
                                        Status = LocType,
                                    });
                                }
                                else if (td.TaskType == TaskType.移库)
                                {
                                    //移库任务库内删除，起始仓位根据容器判断托盘是否有货，目的仓位清空
                                    if (con != null)
                                    {
                                        if (con.Status != ContainerStatus.空)
                                        {
                                            _unitWork.Update<Location>(n => n.Code == td.SourceLocation, n => new Location
                                            {
                                                Status = LocationStatus.有货,
                                                ContainerCode = td.ContainerCode
                                            });
                                        }
                                        else
                                        {
                                            _unitWork.Update<Location>(n => n.Code == td.SourceLocation, n => new Location
                                            {
                                                Status = LocType,
                                                ContainerCode = td.ContainerCode
                                            });
                                        }
                                        _unitWork.Update<Location>(n => n.Code == td.DestinationLocation, n => new Location
                                        {
                                            Status = LocationStatus.空仓位,
                                            ContainerCode = ""
                                        });
                                    }
                                }
                                else if (td.TaskType != TaskType.站台到站台)
                                {
                                    _unitWork.Update<Location>(n => n.ContainerCode == td.ContainerCode, n => new Location
                                    {
                                        Status = LocationStatus.有货,
                                    });
                                }
                            }
                        }
                        else if (!td.SourceLocation.Contains("BufferStation"))
                        {
                            tab.code = 300;
                            tab.msg = "库内并没有" + td.ContainerCode + "该托盘的数据";
                            return tab;
                        }
                        if (invs.Count() > 0)
                        {
                            foreach (Inventory inv in invs)
                            {
                                if (td.TaskType == TaskType.移库)
                                {
                                    inv.LocationCode = td.SourceLocation;
                                }
                                inv.TaskStatus = InventoryTaskType.无任务;
                                _unitWork.Update(inv);
                            }
                        }
                        if (sta.Count() > 0)
                        {
                            foreach (Station st in sta)
                            {
                                if (td.SourceLocation.Contains("BufferStation") && td.SourceLocation == st.Code)
                                {
                                    continue;
                                }
                                else
                                {
                                    st.Containercode = "";
                                    _unitWork.Update(st);
                                }
                            }
                        }
                        
                        
                        if (td != null)
                        {
                            td.Error += Name + "执行库内手动删除" + DateTime.Now;
                            _unitWork.Update(td);
                            TaskDetailHistory taskDetailHistory = new TaskDetailHistory();
                            td.CopyTo(taskDetailHistory);
                            taskDetailHistory.Id = null;
                            _unitWork.Add(taskDetailHistory);
                            _unitWork.Delete<TaskDetail>(u => u.TaskNo.Equals(task.TaskNo));
                        }
                        if (task != null)
                        {
                            TaskHistory taskHistory = new TaskHistory();
                            task.CopyTo(taskHistory);
                            taskHistory.Id = null;
                            _unitWork.Add(taskHistory);
                            _app.Delete(task);
                        }
                    }
                    //库外删除，清空库存，容器改为库外，清空库位
                    else if (Isout == 1)
                    {
                        if (td != null && td.TaskType == TaskType.容器回库 && invs.Count() > 0)
                        {
                            foreach (var inv in invs)
                            {
                                ReceiptDetail receiptDetail = _unitWork
                                    .Find<ReceiptDetail>(n => n.Project == inv.QrCode && n.Status > 0).FirstOrDefault();
                                if (receiptDetail != null)
                                {
                                    receiptDetail.Status = 0;
                                    receiptDetail.QtyCompleted = 0;
                                    _unitWork.Update(receiptDetail);
                                }
                            }
                        }
                        if (loc.Count() > 0)
                        {
                            if (td.TaskType == TaskType.站台到站台)
                            {
                                isBeing = 1;
                            }
                            else
                            {
                                foreach (Location lo in loc)
                                {
                                    _unitWork.Update<Location>(n => n.ContainerCode == td.ContainerCode, n => new Location
                                    {
                                        Status = LocationStatus.空仓位,
                                        ContainerCode = ""
                                    });
                                }
                            }
                        }

                        if (td.ContainerCode == "empty")
                        {
                            invs = _unitWork.Find<Inventory>(n => n.Id == td.InventoryId).ToList();
                        }
                        if (invs.Count() > 0)
                        {
                            foreach (Inventory inv in invs)
                            {
                                InventoryTransaction inventoryTransaction = new InventoryTransaction();
                                inventoryTransaction.Type = "Delete";
                                inventoryTransaction.Lot = inv.Lot;
                                inventoryTransaction.QrCode = inv.QrCode;
                                inventoryTransaction.ContainerCode = inv.ContainerCode;
                                inventoryTransaction.Position = inv.Position;
                                inventoryTransaction.TaskSteps = inv.TaskSteps;
                                inventoryTransaction.SourceCode = inv.SourceCode;
                                inventoryTransaction.LocationCode = "";
                                inventoryTransaction.MaterialCode = inv.MaterialCode;
                                inventoryTransaction.Batch = inv.Batch;
                                inventoryTransaction.Qty = inv.Qty;
                                inventoryTransaction.Status = inv.Status;
                                inventoryTransaction.IsPack = inv.IsPack;
                                inventoryTransaction.IsFold = inv.IsFold;
                                inventoryTransaction.Status = inv.Status;
                                inventoryTransaction.Supplier = inv.Supplier;
                                inventoryTransaction.ResidualWeight = inv.ResidualWeight;
                                inventoryTransaction.Retreat = inv.Retreat;
                                inventoryTransaction.Specification = inv.Specification;
                                inventoryTransaction.NameDescription = inv.NameDescription;
                                inventoryTransaction.Unit = inv.Unit;
                                inventoryTransaction.Size = inv.Size;
                                inventoryTransaction.OldBatch = inv.OldBatch;
                                inventoryTransaction.Combo = inv.Combo;
                                inventoryTransaction.NumberofSheets = inv.NumberofSheets;
                                inventoryTransaction.Groupnum = inv.Groupnum;
                                inventoryTransaction.StackingNumber = inv.StackingNumber;
                                inventoryTransaction.CreateTime = inv.CreateTime;
                                inventoryTransaction.SpecialWarehouse = inv.SpecialWarehouse;
                                inventoryTransaction.IsoutControl = inv.IsoutControl;
                                inventoryTransaction.UpdateTime = DateTime.Now;
                                inventoryTransaction.UpdateBy = Name + "手动删除";
                                _appit.Add(inventoryTransaction);
                                _unitWork.Delete(inv);
                            }
                        }
                        if (sta.Count() > 0)
                        {
                            foreach (Station st in sta)
                            {
                                if (st.IsOccupy != 1)
                                {
                                    st.Containercode = "";
                                    _unitWork.Update(st);
                                }
                            }
                        }
                        if (con != null && isBeing == 0)
                        {
                            con.Status = ContainerStatus.空;
                            con.IsLock = 1;
                            con.LocationCode = "";
                            _unitWork.Update(con);
                        }

                        StoreStation storeStation = _unitWork.Find<StoreStation>(N => N.ContainerCode == td.ContainerCode)
                            .FirstOrDefault();
                        if (storeStation != null)
                        {
                            TaskDetailHistory taskDetailHistory = new TaskDetailHistory
                            {
                                TaskNo = "",
                                TaskType = "库外删除",
                                ContainerCode = storeStation.ContainerCode,
                                Station = storeStation.StationCode,
                                Status = 99,
                                Error = Name + "执行库外手动删除暂存区托盘信息" + DateTime.Now,
                                CreateTime = DateTime.Now
                            };
                            _unitWork.Add(taskDetailHistory);
                            _unitWork.Delete(storeStation);
                        }
                        if (td != null)
                        {
                            td.Error = Name + "执行库外手动删除" + DateTime.Now;
                            _unitWork.Update(td);
                            TaskDetailHistory taskDetailHistory = new TaskDetailHistory();
                            td.CopyTo(taskDetailHistory);
                            taskDetailHistory.Id = null;
                            _unitWork.Add(taskDetailHistory);
                            _unitWork.Delete<TaskDetail>(u => u.TaskNo.Equals(td.TaskNo));
                        }
                        if (task != null)
                        {
                            TaskHistory taskHistory = new TaskHistory();
                            task.CopyTo(taskHistory);
                            taskHistory.Id = null;
                            _unitWork.Add(taskHistory);
                            _app.Delete(task);
                        }
                    }
                }
                //if (entity != null)
                //{
                //    TaskHistory taskHistory = new TaskHistory();
                //    entity.CopyTo(taskHistory);
                //    taskHistory.Id = null;
                //    _unitWork.Add(taskHistory);
                //    _app.Delete(entity);
                //}
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        //根据扫描站台数据查找站台
        public TableData FindStation(string Station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                Station Sta = _unitWork.Find<Station>(n => n.Code == Station && n.IsStop == 0).FirstOrDefault();
                if (Sta == null)
                {
                    tab.code = 300;
                    tab.msg = "站台" + Station + "不存在或者已被禁用，请重新扫描！！";
                    return tab;
                }
                else
                {
                    tab.data = Sta;
                }
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        //批量查找站台
        public TableData PPJSelStation(string Station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                List<Station> s = (from se in _unitWork.Find<Station>(n =>  n.IsStop == 0)
                    join sts in _unitWork.Find<StationToStation>(a => a.StartStation == Station)
                        on se.Code equals sts.EndStation
                    select se).ToList();
                if (s.Count() > 0)
                {
                    tab.data = s;
                }
                else
                {
                    tab.code = 300;
                    tab.msg = "未找到站台";
                    return tab;
                }
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        //根据任务主表查询托盘号
        public TableData SelectTaskContainer(int Id)
        {
            TableData tab = new TableData();
            try
            {
                Task task = _unitWork.Find<Task>(n => n.Id == Id).FirstOrDefault();
                if (task != null)
                {
                    TaskDetail taskDetail = _unitWork.Find<TaskDetail>(n =>n.TaskNo == task.TaskNo ).FirstOrDefault();
                    if (taskDetail != null)
                    {
                        tab.code = 200;
                        tab.data = taskDetail;
                    }
                }
               
            }
            catch (Exception ex)
            {
                tab.code = 300;
                tab.msg = ex.Message;
            }
            return tab;
        }

        //任务异常处理
        public Response AbnormalTaskApp(string code, string type, string Name)
        {
            Response<AbType> response = new Response<AbType>();
            try
            {
                TaskDetail taskDetail = _unitWork.Find<TaskDetail>(n => n.TaskNo == code).FirstOrDefault();
                Location loc = new Location();
                if (taskDetail != null)
                {
                    if (taskDetail.TaskType == TaskType.整盘入库 || taskDetail.TaskType == TaskType.空容器入库 || taskDetail.TaskType == TaskType.容器回库 || taskDetail.TaskType == TaskType.补充入库)
                    {
                        loc = _unitWork.Find<Location>(n => n.Code == taskDetail.DestinationLocation).FirstOrDefault();
                        if (loc == null)
                        {
                            response.Code = 300;
                            response.Message = "入库任务未找到仓位，禁止手动完成";
                            return response;
                        }
                    }
                    if (taskDetail != null && type == "Finish")
                    {
                        taskDetail.Error = Name + "任务手动完成" + DateTime.Now;
                        _unitWork.Update(taskDetail);
                    }
                }
                
                ApiRequest apiRequest = new ApiRequest("WCS");
                AbType abType = new AbType
                {
                    code = code,
                    type = type
                };
                response = apiRequest.Post<Response<AbType>>(JsonHelper.Instance.Serialize(abType), "WcsWebApi/AbnormalTask", "任务异常处理");
                if (response.Code != 200)
                {
                    response.Code = 300;
                    response.Message = response.Message;
                }
            }
            catch (Exception ex)
            {
                response.Code = 300;
                response.Message = ex.Message;
            }
            return response;
        }

        /// <summary>
        /// 为2楼木板站台创建随机托盘号
        /// </summary>
        /// <param name="station">暂存区站台号</param>
        /// <returns></returns>
        public TableData RandomCon(string station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                
                string Container = "";
                Station station1 = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                if (string.IsNullOrEmpty(station1.Containercode))
                {
                    string[] containers = Guid.NewGuid().ToString().Split('-');
                    Container = containers[0];
                }
                else
                {
                    Container = station1.Containercode;
                }
                tab.data = Container;
                return tab;
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        /// <summary>
         /// 2楼复核完成
         /// </summary>
         /// <param name="station">站台号</param>
         /// <returns></returns>
        public TableData Check(string ContainerCode, string station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                //重新复核的物料
                List<Inventory> Errinventories = _unitWork.Find<Inventory>(n => n.ContainerCode == ContainerCode && n.LocationCode == "ExitStationB02(P3328)" && n.TaskSteps == 99).ToList();
                //已复核的物料
                List<Inventory> inventories2 = _unitWork.Find<Inventory>(n => n.ContainerCode == ContainerCode && n.LocationCode == "ExitStationB02(P3328)" && n.TaskSteps == 1).ToList();
                //正在包装打印的物料
                List<Inventory> BaleInventories = _unitWork.Find<Inventory>(n => n.LocationCode == "BalerStation" && n.TaskSteps == 3).ToList();
                if (BaleInventories.Count() > 0)
                {
                    tab.code = 300;
                    tab.msg = "装箱打印区还有"+ BaleInventories.Count() + "笔未完成的物料，请在库存管理里面确认是否正确！！";
                    return tab;
                }
                if (Errinventories.Count() > 0 )
                {
                    if (inventories2.Count() > 0)
                    {
                        foreach (var Errinventorie in Errinventories)
                        {
                            InventoryTransaction inventoryTransaction = new InventoryTransaction
                            {
                                Type = "2楼重新复核删除物料",
                                SourceCode = Errinventorie.SourceCode,
                                UserDef1 = "",
                                ContainerCode = Errinventorie.ContainerCode,
                                Position = Errinventorie.Position,
                                TaskSteps = Errinventorie.TaskSteps,
                                MaterialCode = Errinventorie.MaterialCode,
                                QrCode = Errinventorie.QrCode,
                                Batch = Errinventorie.Batch,
                                Lot = Errinventorie.Lot,
                                Qty = Errinventorie.Qty,
                                Supplier = Errinventorie.Supplier,
                                ResidualWeight = Errinventorie.ResidualWeight,
                                Retreat = Errinventorie.Retreat,
                                Specification = Errinventorie.Specification,
                                NameDescription = Errinventorie.NameDescription,
                                Unit = Errinventorie.Unit,
                                Size = Errinventorie.Size,
                                NumberofSheets = Errinventorie.NumberofSheets,
                                Groupnum = Errinventorie.Groupnum,
                                OldBatch = Errinventorie.OldBatch,
                                Combo = Errinventorie.Combo,
                                Customer = Errinventorie.Customer,
                                Status = Errinventorie.Status,
                                LocationCode = Errinventorie.LocationCode,
                                StackingNumber = Errinventorie.StackingNumber,
                                CreateTime = Errinventorie.CreateTime,
                                UpdateTime = DateTime.Now,
                                Height = Errinventorie.Height
                            };
                            _unitWork.Add(inventoryTransaction);
                            _unitWork.Delete(Errinventorie);
                        }
                    }
                    else
                    {
                        tab.code = 300;
                        tab.msg = "托盘号" + ContainerCode + "上的物料已被标记为异常，需要重新复核！！";
                        return tab;
                    }
                }
                //托盘上的所有物料
                List<Inventory> inventories1 = _unitWork.Find<Inventory>(n => n.ContainerCode == ContainerCode && n.LocationCode == "ExitStationB02(P3328)").OrderByDescending(a => a.Position).ToList();
                //未复核的物料
                List<Inventory> inventories = _unitWork.Find<Inventory>(n => n.ContainerCode == ContainerCode && n.LocationCode == "ExitStationB02(P3328)" && n.TaskSteps == 0).ToList();
                
                if (inventories.Count() > 0)
                {
                    tab.code = 300;
                    tab.msg = "托盘号"+ ContainerCode + "上的位置为"+ inventories.First().Position + "的物料未复核";
                    return tab;
                }
                if (inventories1.Count() == inventories2.Count() && inventories.Count() == 0)
                {
                    foreach (var inventorie1 in inventories1)
                    {
                        //if (inventories1.Count() <= 9 && inventories1.Count() >= 8)
                        //{
                        //    switch (inventorie1.Position)
                        //    {
                        //        case 1:
                        //            inventorie1.Position = 4;
                        //            break;
                        //        case 2:
                        //            inventorie1.Position = 3;
                        //            break;
                        //        case 3:
                        //            inventorie1.Position = 2;
                        //            break;
                        //        case 4:
                        //            inventorie1.Position = 1;
                        //            break;
                        //        case 5:
                        //            inventorie1.Position = 7;
                        //            break;
                        //        case 6:
                        //            inventorie1.Position = 6;
                        //            break;
                        //        case 7:
                        //            inventorie1.Position = 5;
                        //            break;
                        //        case 8:
                        //            inventorie1.Position = inventories1.Count();
                        //            break;
                        //        case 9:
                        //            inventorie1.Position = inventories1.Count() - 1;
                        //            break;
                        //    }
                        //}
                        //else if (inventories1.Count() <= 7 && inventories1.Count() >= 5)
                        //{
                        //    switch (inventorie1.Position)
                        //    {
                        //        case 1:
                        //            inventorie1.Position = 4;
                        //            break;
                        //        case 2:
                        //            inventorie1.Position = 3;
                        //            break;
                        //        case 3:
                        //            inventorie1.Position = 2;
                        //            break;
                        //        case 4:
                        //            inventorie1.Position = 1;
                        //            break;
                        //        case 5:
                        //            inventorie1.Position = inventories1.Count();
                        //            break;
                        //        case 6:
                        //            inventorie1.Position = inventories1.Count() - 1;
                        //            break;
                        //        case 7:
                        //            inventorie1.Position = inventories1.Count() - 2;
                        //            break;
                        //    }
                        //}
                        //else if (inventories1.Count() <= 4 && inventories1.Count() >= 1)
                        //{
                        //    switch (inventorie1.Position)
                        //    {
                        //        case 1:
                        //            inventorie1.Position = inventories1.Count();
                        //            break;
                        //        case 2:
                        //            inventorie1.Position = inventories1.Count() - 1;
                        //            break;
                        //        case 3:
                        //            inventorie1.Position = inventories1.Count() - 2;
                        //            break;
                        //        case 4:
                        //            inventorie1.Position = inventories1.Count() - 3;
                        //            break;
                        //    }
                        //}
                        
                        inventorie1.TaskSteps = 2;
                        _unitWork.Update(inventorie1);
                    }
                }
                return tab;
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        /// <summary>
        /// 2楼复核区清除托盘物料数据
        /// </summary>
        /// <param name="station">站台号</param>
        /// <returns></returns>
        public TableData CleanInventry(string ContainerCode, string station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                if (station == "ProductStationB03")
                {
                    List<Inventory> inventories = _unitWork.Find<Inventory>(n => n.ContainerCode == ContainerCode && n.LocationCode == "ExitStationB02(P3328)").ToList();
                    if (inventories.Count() > 0)
                    {
                        foreach (var inv in inventories)
                        {
                            inv.TaskSteps = 99;
                            inv.UpdateTime = DateTime.Now;
                            inv.UpdateBy = "CleanInventry";
                            _unitWork.Update(inv);
                        }
                    }
                    else
                    {
                        tab.code = 300;
                        tab.msg = "托盘号" + ContainerCode + "没有在复核区的物料！";
                        return tab;
                    }
                }
                else
                {
                    tab.code = 300;
                    tab.msg = "只允许复核区使用该功能！";
                    return tab;
                }
                return tab;
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        /// <summary>
        /// PP卷1楼空托叠盘
        /// </summary>
        /// <param name="station">站台号</param>
        /// <returns></returns>
        public TableData btnEmptyStack(string ContainerCode, string station)
        {
            TableData tab = new TableData();
            tab.code = 200;
            try
            {
                Container container = _unitWork.Find<Container>(n => n.Code == ContainerCode).FirstOrDefault();
                Station Station = _unitWork.Find<Station>(n => n.Code == station).FirstOrDefault();
                if (Station == null || Station.Code != "EntranceStationB01(P3106)")
                {
                    tab.code = 500;
                    tab.msg = "站台扫描错误！";
                    return tab;
                }
                if (container == null)
                {
                    tab.code = 500;
                    tab.msg = "库内未找到该托盘！";
                    return tab;
                }
                if (_unitWork.IsExist<TaskDetail>(n => n.ContainerCode == ContainerCode && n.TaskType != TaskType.整盘出库 && n.TaskType != TaskType.分拣出库))
                {
                    tab.code = 500;
                    tab.msg = "该托盘有任务正在执行！";
                    return tab;
                }
                TaskDetail taskDetailOut = _unitWork.Find<TaskDetail>(n => n.DestinationLocation == "ExitStationB01(P3100)" && n.Status >= TaskStatus.下达任务).FirstOrDefault();
                TaskDetail taskDetailIn = _unitWork.Find<TaskDetail>(n => n.SourceLocation == "EntranceStationB02(P3101)").FirstOrDefault();
                if (taskDetailIn != null)
                {
                    tab.code = 300;
                    tab.msg = "叠盘机有入库任务正在执行，请等待任务执行完成！";
                    return tab;
                }
                if (taskDetailOut != null)
                {
                    tab.code = 300;
                    tab.msg = "提升机有出库任务正在执行，请等待任务执行完成！";
                    return tab;
                }
                else
                {
                    Task ptask = new Task();
                    var ctaskNo = "DB" + _app.GetTaskNo(TaskNo.站台到站台);
                    ptask.TaskNo = ctaskNo;
                    ptask.OrderCode = ctaskNo;
                    ptask.BusinessType = BusinessType.出库_其他出库单;
                    ptask.FirstStatus = TaskStatus.待下发任务;
                    ptask.LastStatus = TaskStatus.待下发任务;
                    ptask.CreateTime = DateTime.Now;


                    TaskDetail ptaskDetail = new TaskDetail();
                    ptaskDetail.TaskType = TaskType.站台到站台;
                    ptaskDetail.Roadway = 3;
                    ptaskDetail.TaskNo = ctaskNo;
                    ptaskDetail.OrderCode = ctaskNo;
                    ptaskDetail.ContainerCode = container.Code;
                    ptaskDetail.SourceLocation = Station.Code;
                    ptaskDetail.DestinationLocation = "EntranceStationB02(P3101)";
                    ptaskDetail.Station = "EntranceStationB02(P3101)";
                    ptaskDetail.OderQty = 0;
                    ptaskDetail.ContainerQty = 0;
                    ptaskDetail.HadQty = 0;
                    ptaskDetail.Status = TaskStatus.待下发任务;
                    ptaskDetail.Priority = 99;
                    ptaskDetail.CreateTime = DateTime.Now;

                    _unitWork.Add(ptask);
                    _unitWork.Add(ptaskDetail);
                }
                return tab;
            }
            catch (Exception ex)
            {
                tab.code = 500;
                tab.msg = ex.Message;
            }
            return tab;
        }
        //修改任务优先级
        public Response UpdataPriority(TaskDetail Task, string Priority, string UpName)
        {
            Response<AbType> response = new Response<AbType>();
            response.Code = 200;
            try
            {
                TaskDetail taskDetail = _unitWork.Find<TaskDetail>(n => n.Id == Task.Id).FirstOrDefault();
                if (taskDetail != null)
                {
                    taskDetail.Priority = int.Parse(Priority);
                    taskDetail.Error = "，修改人：" + UpName + "将优先级修改为" + Priority + ",时间为:" + DateTime.Now;
                    _unitWork.Update(taskDetail);
                }
                else
                {
                    response.Code = 300;
                    response.Message = "未找到任务明细，请刷新后重新！";
                }
            }
            catch (Exception ex)
            {
                response.Code = 300;
                response.Message = ex.Message;
            }
            return response;
        }
    }
}