wms / wms_NouYaWmsN5 · Files

using Infrastructure;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using ServiceReference1;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Diagnostics;
using System.Linq;
using System.Xml;
using WebApp;
using WebRepository;

namespace WebMvc
{
    /// <summary>
	/// 立库任务表
	/// </summary>
    [Area("task")]
    public class TaskController : BaseController
    {
        private readonly TaskApp _app;
        private IUnitWork _unitWork;

        public TaskController(IAuth authUtil, TaskApp app,IUnitWork unitWork) : base(authUtil)
        {
            _app = app.SetLoginInfo(_loginInfo);
            _unitWork = unitWork;
        }
        #region 视图功能
        /// <summary>
        /// 默认视图Action
        /// </summary>
        /// <returns></returns>
        [Authenticate]
        [ServiceFilter(typeof(OperLogFilter))]
        public ActionResult Index()
        {
            return View();
        }
        /// <summary>
        /// 切片机入库视图
        /// </summary>
        /// <returns></returns>
        [Authenticate]
        [ServiceFilter(typeof(OperLogFilter))]
        public ActionResult PalletIn()
        {
            return View();
        }
        /// <summary>
        /// 临时添加库内物料视图
        /// </summary>
        /// <returns></returns>
        [Authenticate]
        [ServiceFilter(typeof(OperLogFilter))]
        public ActionResult AddLocation()
        {
            return View();
        }
        /// <summary>
        /// PP片从铜箔入空板
        /// </summary>
        /// <returns></returns>
        [Authenticate]
        [ServiceFilter(typeof(OperLogFilter))]
        public ActionResult PPEmptyIn()
        {
            return View();
        }
        #endregion
        #region 获取数据
        /// <summary>
        /// 加载及分页查询
        /// </summary>
        /// <param name="pageRequest">表单请求信息</param>
        /// <param name="entity">请求条件实例</param>
        /// <returns></returns>
        [HttpPost]
        public string Load(PageReq pageRequest, Task entity)
        {
            return JsonHelper.Instance.Serialize(_app.Load(pageRequest, entity));
        }
        #endregion
        #region 提交数据
        /// <summary>
        /// 新增数据
        /// </summary>
        /// <param name="Table_entity">新增实例</param>
        /// <returns></returns>
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string Ins(Task Table_entity)
        {
            try
            {
                _app.Ins(Table_entity);
            }
            catch (Exception ex)
            {
                Result.Status = false;
                Result.Message = ex.Message;
            }
            return JsonHelper.Instance.Serialize(Result);
        }
        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="Table_entity">修改实例</param>
        /// <returns></returns>
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string Upd(Task Table_entity)
        {
            try
            {
                _app.Upd(Table_entity);
            }
            catch (Exception ex)
            {
                Result.Status = false;
                Result.Message = ex.Message;
            }
            return JsonHelper.Instance.Serialize(Result);
        }
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string DelByIds(int[] ids)
        {
            try
            {
                _app.DelByIds(ids);
            }
            catch (Exception ex)
            {
                Result.Status = false;
                Result.Message = ex.Message;
            }
            return JsonHelper.Instance.Serialize(Result);
        }
        #endregion
        #region 导出数据
        /// <summary>
        /// 导出数据
        /// </summary>
        /// <param name="entity">请求条件实例</param>
        /// <returns></returns>
        [HttpPost]
        public string Export(Task entity)
        {
            return JsonHelper.Instance.Serialize(_app.ExportData(entity));
        }
        #endregion
        #region 导出模板
        /// <summary>
        /// 导出模板
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public string GetTemplate()
        {
            var result = new TableData();
            List<Task> listTask = new List<Task>();
            Task entity = _app.FindSingle(u => u.Id > 0);
            if (entity != null)
            {
                listTask.Add(entity);
            }
            else
            {
                listTask.Add(new Task());
            }
 
            result.data = listTask;
            result.count = listTask.Count;

            return JsonHelper.Instance.Serialize(result);
        }
        #endregion
        #region 导入数据
        /// <summary>
        /// 导入数据
        /// </summary>
        /// <param name="excelfile">表单提交的文件信息</param>
        /// <returns></returns>
        [HttpPost]
        public string Import(IFormFile excelfile)
        {
            try
            {
                Response result = _app.ImportIn(excelfile);
                if (!result.Status)
                {
                    Result.Status = false;
                    Result.Message = result.Message;
                }
            }
            catch (Exception ex)
            {
                Result.Status = false;
                Result.Message = ex.Message;
            }
            return JsonHelper.Instance.Serialize(Result);
        }
        #endregion
        #region 自定义方法
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string EmptyContainerBack(string station, string type, string containerCode )
        {
            return JsonHelper.Instance.Serialize(_app.EmptyContainerBack(station,containerCode, type));
        }
        //整托手动任务
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string HandTaskIn(string containerCode, string station, int isBuffer, string isPack, string isFold, string status, string materialCode)
        {
            return JsonHelper.Instance.Serialize(_app.HandTaskInApp(containerCode, station, isBuffer, isPack, isFold, status, materialCode));
        }
        /// <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>
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string AddInventory(string containerCode, string station, string material, string Lot, decimal num, string Batch, string Customer, string Typesetting, string Supplier, decimal ResidualWeight, string Retreat, string Project, string QRcode, string Truss,int Height)
        {
            TableData tab = new TableData();
            string specification = "";
            string nameDescription = "";
            string unit = "";
            string Size = "";
            decimal NumberofSheets = -1;
            decimal Groupnum = -1;
            decimal time = -1;
            Customer = "-1";
            Stopwatch stopwatch = new Stopwatch();
            stopwatch.Start();
            //查询是否启用该接口
            WebStart webStart_get_ima_oa = _unitWork.Find<WebStart>(n => n.InterfaceNmae == "get_ima_oa").FirstOrDefault();
            //排除工单号回库和废铜箔回库
            if (Batch != "000" && material != "1111111111" && webStart_get_ima_oa != null)
            {
                if (webStart_get_ima_oa.IsStart ?? false)
                {
                    try
                    {
                        var materialLength = material.Length;
                        if (materialLength == 10)
                        {
                            //webservice引用
                            ServiceReference2.TIPTOPServiceGateWayPortTypeClient C = new ServiceReference2.TIPTOPServiceGateWayPortTypeClient();
                            ConfigXmlDocument doc = new ConfigXmlDocument();
                            //读取传入的xml
                            var config = AppSettingsJson.GetAppSettings();
                            doc.Load(config.GetSection("NouYaWebService:Url").Value);
                            //将物料号填入
                            XmlNodeList ns = doc.SelectNodes("//Field");
                            foreach (XmlElement node in ns)
                            {
                                if (node.GetAttribute("name") == "ima01")
                                {
                                    node.SetAttribute("value", material);
                                }
                            }
                            //调用方法
                            var response = C.get_ima_oa(doc.InnerXml);
                            //处理回传数据
                            doc.LoadXml(response);
                            XmlElement element = (XmlElement)doc.SelectSingleNode("//Status");
                            string code = element.GetAttribute("code");
                            string name = "";
                            string value = "";
                            if (code == "0")
                            {
                                XmlNodeList nodes = doc.SelectNodes("//Field");
                                foreach (XmlElement node in nodes)
                                {
                                    name = node.GetAttribute("name");
                                    value = node.GetAttribute("value");
                                    if (name == "ima02")
                                    {
                                        nameDescription = value;
                                    }
                                    else if (name == "ima021")
                                    {
                                        specification = value;
                                    }
                                    else if (name == "ima25")
                                    {
                                        unit = value;
                                    }
                                }
                            }
                            else
                            {
                                string description = element.GetAttribute("description");
                                tab.code = 300;
                                tab.msg = "（接口反馈报错）查找物料信息失败:" + description;
                                return JsonHelper.Instance.Serialize(tab);
                            }
                        }
                        else
                        {
                            tab.code = 300;
                            tab.msg = "物料二维码扫描失败，物料号"+ material + "位数错误，请重新扫描二维码！";
                            return JsonHelper.Instance.Serialize(tab);
                        }
                    }
                    catch (Exception ex)
                    {
                        tab.code = 300;
                        tab.msg = "查找物料信息失败:" + ex.Message;
                        return JsonHelper.Instance.Serialize(tab);
                    }
                }
            }

            //查询是否启用该接口
            WebStart webStart_get_sfb = _unitWork.Find<WebStart>(n => n.InterfaceNmae == "get_sfb").FirstOrDefault();
            //排除工单号回库和废铜箔回库
            if (Batch != "000" && (containerCode.Contains("PP") || containerCode.Contains("PJ") || station == "OutStationB07(P3300)") && webStart_get_sfb != null)
            {
                if (webStart_get_sfb.IsStart ?? false)
                {
                    try
                    {
                        var materialLength = material.Length;
                        if (materialLength == 10)
                        {
                            //webservice引用
                            ServiceReference2.TIPTOPServiceGateWayPortTypeClient C2 = new ServiceReference2.TIPTOPServiceGateWayPortTypeClient();
                            ConfigXmlDocument doc = new ConfigXmlDocument();
                            //读取传入的xml
                            var config = AppSettingsJson.GetAppSettings();
                            doc.Load(config.GetSection("NouYaWebPPService:Url").Value);
                            //将物料号填入
                            XmlNodeList ns = doc.SelectNodes("//Field");
                            foreach (XmlElement node in ns)
                            {
                                if (node.GetAttribute("name") == "sfb01")
                                {
                                    node.SetAttribute("value", Lot);
                                }
                            }
                            //批号开头为Z的传KL01
                            if (Lot.StartsWith("Z"))
                            {
                                XmlNodeList Organizations = doc.SelectNodes("//Organization");
                                foreach (XmlElement Organization in Organizations)
                                {
                                    Organization.SetAttribute("name", "KL01");
                                }
                            }
                            
                            //调用方法
                            var response = C2.get_sfb(doc.InnerXml);
                            //处理回传数据
                            doc.LoadXml(response);
                            XmlElement element = (XmlElement)doc.SelectSingleNode("//Status");
                            string code = element.GetAttribute("code");
                            string name = "";
                            string value = "";
                            if (code == "0")
                            {
                                XmlNodeList nodes = doc.SelectNodes("//Field ");
                                if (containerCode.Contains("PP"))
                                {
                                    foreach (XmlElement node in nodes)
                                    {
                                        name = node.GetAttribute("name");
                                        value = node.GetAttribute("value");
                                        if (name == "sfbud10" && !string.IsNullOrEmpty(value))
                                        {
                                            Size = value;
                                        }
                                        //米转张系数
                                        else if (name == "sfbud11" && !string.IsNullOrEmpty(value))
                                        {
                                            NumberofSheets = num / decimal.Parse(value);
                                        }
                                        //组系数
                                        else if (name == "sfbud12" && !string.IsNullOrEmpty(value))
                                        {
                                            Groupnum = decimal.Parse(value);
                                        }
                                        else if (name == "sfb01")
                                        {
                                            if (value != Lot)
                                            {
                                                tab.code = 300;
                                                tab.msg = "回传工单号不统一<" + value + ">";
                                                return JsonHelper.Instance.Serialize(tab);
                                            }
                                        }
                                    }
                                }
                                else if (containerCode.Contains("PJ") || station == "OutStationB07(P3300)")
                                {
                                    foreach (XmlElement node in nodes)
                                    {
                                        name = node.GetAttribute("name");
                                        value = node.GetAttribute("value");
                                        if (name == "sfbud03" && !string.IsNullOrEmpty(value))
                                        {
                                            Customer = value;
                                        }
                                        else if (name == "sfb01")
                                        {
                                            if (value != Lot)
                                            {
                                                tab.code = 300;
                                                tab.msg = "回传工单号不统一<" + value + ">";
                                                return JsonHelper.Instance.Serialize(tab);
                                            }
                                        }
                                    }
                                }
                            }
                            else
                            {
                                string description = element.GetAttribute("description");
                                tab.code = 300;
                                tab.msg = "（接口反馈报错）查找物料信息失败:" + description;
                                return JsonHelper.Instance.Serialize(tab);
                            }
                        }
                        else
                        {
                            tab.code = 300;
                            tab.msg = "物料二维码扫描失败，物料号" + material + "位数错误，请重新扫描二维码！";
                            return JsonHelper.Instance.Serialize(tab);
                        }
                    }
                    catch (Exception ex)
                    {
                        tab.code = 300;
                        tab.msg = "查找物料信息失败:" + ex.Message;
                        return JsonHelper.Instance.Serialize(tab);
                    }
                }
            }
            stopwatch.Stop();
            double millisecond = stopwatch.ElapsedMilliseconds;
            time = decimal.Parse(millisecond.ToString());
            return JsonHelper.Instance.Serialize(_app.AddInventoryApp(containerCode, station, material, Lot, num, Batch, Customer, Typesetting, Supplier, ResidualWeight, Retreat, nameDescription, specification, unit, time, Size, NumberofSheets, Groupnum, Project, QRcode,Truss, Height));
        }
        //站台到站台
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string StationToStation(string containerCode, string startStation, string endStation, string material)
        {
            return JsonHelper.Instance.Serialize(_app.StationToStationApp(containerCode, startStation, endStation, material));
        }
        //空栈板出库
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string EmptyPalletOut(string station, string type,int Roadway)
        {
            return JsonHelper.Instance.Serialize(_app.EmptyPalletOutApp(station, type, Roadway));
        }

        //比对托盘号,占用站台并创建容器
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string PalletIsNo(string Pallet, string station, string type)
        {
            return JsonHelper.Instance.Serialize(_app.PalletIsNo(Pallet, station, type));
        }
        //通过站台查询已锁站台托盘号（暂存区专用）
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string SelStation(string station)
        {
            return JsonHelper.Instance.Serialize(_app.SelStation(station));
        }
        //删除任务数据和库位信息
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string DelTask(int Id, int Isout, string Name)
        {
            return JsonHelper.Instance.Serialize(_app.DelTask(Id, Isout, Name));
        }
        //对比站台
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string FindStation(string Station)
        {
            return JsonHelper.Instance.Serialize(_app.FindStation(Station));
        }
        //PP卷查找站台
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string PPJSelStation(string Station)
        {
            return JsonHelper.Instance.Serialize(_app.PPJSelStation(Station));
        }

        //根据任务主表查询托盘号
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string SelectTaskContainer(int Id)
        {
            return JsonHelper.Instance.Serialize(_app.SelectTaskContainer(Id));
        }
        //任务异常处理
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string AbnormalTask(string code, string type, string Name)
        {
            return JsonHelper.Instance.Serialize(_app.AbnormalTaskApp(code, type, Name));
        }
        //为2楼木板站台创建随机托盘号
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string RandomCon(string station)
        {
            return JsonHelper.Instance.Serialize(_app.RandomCon(station));
        }
        //2楼复核完成
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string Check(string ContainerCode, string station)
        {
            return JsonHelper.Instance.Serialize(_app.Check(ContainerCode, station));
        }
        //2楼复核区清除托盘物料数据
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string CleanInventry(string ContainerCode, string station)
        {
            return JsonHelper.Instance.Serialize(_app.CleanInventry(ContainerCode, station));
        }
        //PP卷1楼空托叠盘
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string btnEmptyStack(string ContainerCode, string station)
        {
            return JsonHelper.Instance.Serialize(_app.btnEmptyStack(ContainerCode, station));
        }
        //修改任务优先级
        [HttpPost]
        [ServiceFilter(typeof(OperLogFilter))]
        public string UpdataPriority(TaskDetail Task, string Priority, string UpName)
        {
            return JsonHelper.Instance.Serialize(_app.UpdataPriority(Task, Priority, UpName));
        }
        #endregion

    }
}