YG-PVC-WCS/WCS_Client/Frm/MBtn_Sys/FormSet.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Newtonsoft.Json.Linq;
using WCS.Data.Models;
using WCS_Client.UC;
using WCS_Client;
using WCS_Client.Utility;

namespace WCS_Client.Frm.MBtn_Sys
{
    public partial class FormSet : Form
    {
        public FormSet()
        {
            InitializeComponent();
            Init();
        }
        private void Init()
        {
            string result = TryCachHelper.TryExecute((db) =>
            {
                //var MatureRoomMinTemperat = db.Queryable<WCS_SYSSET>().First(v => v.SET_ID == "MinTemperat");//最小温度要求
                //txt_MinTemperat.Text = MatureRoomMinTemperat.SET_VALUE.ToString();
                //var MatureRoomMaxTemperat = db.Queryable<WCS_SYSSET>().First(v => v.SET_ID == "MaxTemperat");//最大温度要求
                //txt_MaxTemperat.Text = MatureRoomMaxTemperat.SET_VALUE.ToString();
                var sets = db.Queryable<WCS_SYSSET>().Where(v => v.SET_TYPE == "AgvDisable" || v.SET_TYPE == "MatureRoom").ToList();
                foreach (var item in sets)
                {
                    if (item.SET_ID.Trim() == "Agv_4#")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtn4RoomEnable.Checked = true;
                            rdoBtn4RoomDisable.Checked = false;
                        }
                        else
                        {
                            rdoBtn4RoomEnable.Checked = false;
                            rdoBtn4RoomDisable.Checked = true;
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_5#")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtn5RoomEnable.Checked = true;
                            rdoBtn5RoomDisable.Checked = false;
                        }
                        else
                        {
                            rdoBtn5RoomEnable.Checked = false;
                            rdoBtn5RoomDisable.Checked = true;
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_6#")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtn6RoomEnable.Checked = true;
                            rdoBtn6RoomDisable.Checked = false;
                        }
                        else
                        {
                            rdoBtn6RoomEnable.Checked = false;
                            rdoBtn6RoomDisable.Checked = true;
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_7#")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtn7RoomEnable.Checked = true;
                            rdoBtn7RoomDisable.Checked = false;
                        }
                        else
                        {
                            rdoBtn7RoomEnable.Checked = false;
                            rdoBtn7RoomDisable.Checked = true;
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_18#")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtn18RoomEnable.Checked = true;
                            rdoBtn18RoomDisable.Checked = false;
                        }
                        else
                        {
                            rdoBtn18RoomEnable.Checked = false;
                            rdoBtn18RoomDisable.Checked = true;
                        }
                    }
                    else if (item.SET_ID.Trim() == "1508")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtnMatureRAEnable.Checked = true;
                            rdoBtnMRADisable.Checked = false;
                        }
                        else
                        {
                            rdoBtnMatureRAEnable.Checked = false;
                            rdoBtnMRADisable.Checked = true;
                        }
                    }
                    else if (item.SET_ID.Trim() == "1509")
                    {
                        if (item.SET_VALUE.Trim() == "0")
                        {
                            rdoBtnMatureRBEnable.Checked = true;
                            rdoBtnMRBDisable.Checked = false;
                        }
                        else
                        {
                            rdoBtnMatureRBEnable.Checked = false;
                            rdoBtnMRBDisable.Checked = true;
                        }
                    }
                }
            });
        }
        /// <summary>
        /// 获取入库任务
        /// </summary>
        /// <param name="param"></param>
        public void CreateInTask(GetInTaskParam param)
        {
            WCS_TASK wcstask = null;
            string result = TryCachHelper.TryExecute((db) => {
                wcstask = db.Queryable<WCS_TASK>().First(v => v.TASK_BOXBARCODE == param.ContainerBarCode);
                if (wcstask == null)
                {
                    var reply = I_WCS_GetInTask(param);
                    if (reply.ResType)
                    {
                        //添加wcs任务
                        wcstask = new WCS_TASK();
                        wcstask.TASK_WMSNO = reply.WMSTaskNum;
                        wcstask.TASK_COMTYPE = reply.TaskType;
                        wcstask.TASK_SYSTYPE = "WMS";
                        wcstask.TASK_POSIDFROM = param.EquipmentNo;//起点地址
                        wcstask.TASK_POSIDCUR = param.EquipmentNo;
                        wcstask.TASK_POSIDNEXT = param.EquipmentNo;
                        wcstask.TASK_POSIDMOVE = "";
                        wcstask.TASK_PRIORITY = reply.Priority;
                        wcstask.TASK_WKSTATUS = 0;
                        wcstask.TASK_WHID = reply.WareHouseName;
                        wcstask.TASK_ADDUSERNO = "WMS";
                        wcstask.TASK_ADDDATETIME = DateTime.Now;
                        wcstask.TASK_EDITUSERNO = "WMS";
                        wcstask.TASK_EDITDATETIME = DateTime.Now;
                        wcstask.TASK_NOTES = "";
                        wcstask.TASK_RGVNO = "";
                        wcstask.TASK_BOXBARCODE = param.ContainerBarCode;
                        if (string.IsNullOrWhiteSpace(reply.TunnelNum))
                        {
                            wcstask.TASK_POSIDTO = reply.EndPostion;
                            wcstask.TASK_SRMNO = reply.EndPostion;
                        }
                        //else
                        //{
                        //    wcstask.TASK_EndTunnelNum = ConveyorHelper.AssignSrm(param.EquipmentNo, reply.TunnelNum);
                        //    wcstask.TASK_POSIDTO = wcstask.TASK_EndTunnelNum;
                        //    wcstask.TASK_SRMNO = wcstask.TASK_EndTunnelNum;
                        //}
                        int id = db.Insertable(wcstask).ExecuteReturnIdentity();
                        if (id <= 0)
                        {
                            throw new Exception(string.Format("WMS任务[{0}]添加WCS任务失败", reply.WMSTaskNum));
                        }
                        else
                        {
                            wcstask.TASK_NO = id;
                        }
                    }
                    else
                    {
                        throw new Exception(reply.ResMessage);
                    }
                }
            });
            if (string.IsNullOrWhiteSpace(result))
            {
                MessageBox.Show("添加空盘入库任务成功");
            }
            else
            {
                MessageBox.Show("添加空盘入库任务失败.原因：[{0}]", result);
            }
        }

        public GetInTaskReply I_WCS_GetInTask(GetInTaskParam param)
        {
            GetInTaskReply reply = null;
            try
            {
                //Log4netHelper.Logger_Info.Info(string.Format("开始：WCS调用WMS接口函数I_WCS_GetInTask。参数：[{0}]", WebApiHelper.GetJson(param)));
                JArray ja = new JArray();
                ja.Add(WebApiHelper.GetJson(param));
                //调用MES接口
                JObject jobj = WebApiHelper.SendInfoToWebAPI("http://192.168.16.2:8081/api/Task/I_WCS_GetInTask", "", "Post", ja);
                reply = WebApiHelper.ParseFromJson<GetInTaskReply>(jobj.ToString());
                //Log4netHelper.Logger_Info.Info(string.Format("结束：WCS调用WMS接口函数I_WCS_GetInTask。参数：[{0}]反馈结果:[{1}]", WebApiHelper.GetJson(param), WebApiHelper.GetJson(reply)));
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                //Log4netHelper.Logger_Error.ErrorFormat(ex.ToString());
            }
            return reply;
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            if (CurrentHelper.User.Use_RoleId == 1)
            {
                string result = TryCachHelper.TryExecute((db) =>
            {
                var tasks = db.Queryable<Middle_AGVTask>().ToList();
                var sets = db.Queryable<WCS_SYSSET>().Where(v => v.SET_TYPE == "AgvDisable" || v.SET_TYPE == "MatureRoom").ToList();
                foreach (var item in sets)
                {
                    if (item.SET_ID.Trim() == "Agv_4#")
                    {
                        if (rdoBtn4RoomEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtn4RoomDisable.Checked)
                        {
                            if (tasks.Any(v => v.Task_Workshop == item.SET_ID) && item.SET_VALUE != "1")
                            {
                                throw new Exception(string.Format("4车间当前存在AGV任务，请将任务执行完成，再禁用AGV。"));
                            }
                            else
                            {
                                item.SET_VALUE = "1";
                            }
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_5#")
                    {
                        if (rdoBtn5RoomEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtn5RoomDisable.Checked)
                        {
                            if (tasks.Any(v => v.Task_Workshop == item.SET_ID) && item.SET_VALUE != "1")
                            {
                                throw new Exception(string.Format("5车间当前存在AGV任务，请将任务执行完成，再禁用AGV。"));
                            }
                            else
                            {
                                item.SET_VALUE = "1";
                            }
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_6#")
                    {
                        if (rdoBtn6RoomEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtn6RoomDisable.Checked)
                        {
                            if (tasks.Any(v => v.Task_Workshop == item.SET_ID) && item.SET_VALUE != "1")
                            {
                                throw new Exception(string.Format("6车间当前存在AGV任务，请将任务执行完成，再禁用AGV。"));
                            }
                            else
                            {
                                item.SET_VALUE = "1";
                            }
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_7#")
                    {
                        if (rdoBtn7RoomEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtn7RoomDisable.Checked)
                        {
                            if (tasks.Any(v => v.Task_Workshop == item.SET_ID) && item.SET_VALUE != "1")
                            {
                                throw new Exception(string.Format("7车间当前存在AGV任务，请将任务执行完成，再禁用AGV。"));
                            }
                            else
                            {
                                item.SET_VALUE = "1";
                            }
                        }
                    }
                    else if (item.SET_ID.Trim() == "Agv_18#")
                    {
                        if (rdoBtn18RoomEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtn18RoomDisable.Checked)
                        {
                            if (tasks.Any(v => v.Task_Workshop == item.SET_ID) && item.SET_VALUE != "1")
                            {
                                throw new Exception(string.Format("18车间当前存在AGV任务，请将任务执行完成，再禁用AGV。"));
                            }
                            else
                            {
                                item.SET_VALUE = "1";
                            }
                        }
                    }
                    else if (item.SET_ID.Trim() == "1508")
                    {
                        if (rdoBtnMatureRAEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtnMRADisable.Checked)
                        {
                            item.SET_VALUE = "1";
                        }
                    }
                    else if (item.SET_ID.Trim() == "1509")
                    {
                        if (rdoBtnMatureRBEnable.Checked)
                        {
                            item.SET_VALUE = "0";
                        }
                        else if (rdoBtnMRBDisable.Checked)
                        {
                            item.SET_VALUE = "1";
                        }
                    }
                    db.Updateable(item).UpdateColumns(it => it.SET_VALUE).ExecuteCommand();
                }

                //var MatureRoomMinTemperat = db.Queryable<WCS_SYSSET>().First(v => v.SET_ID == "MinTemperat");//最小温度要求
                //MatureRoomMinTemperat.SET_VALUE = txt_MinTemperat.Text.Trim();
                //db.Updateable(MatureRoomMinTemperat).UpdateColumns(it => it.SET_VALUE).ExecuteCommand();
                //var MatureRoomMaxTemperat = db.Queryable<WCS_SYSSET>().First(v => v.SET_ID == "MaxTemperat");//最大温度要求
                //MatureRoomMaxTemperat.SET_VALUE = txt_MaxTemperat.Text.Trim();
                //db.Updateable(MatureRoomMaxTemperat).UpdateColumns(it => it.SET_VALUE).ExecuteCommand();
            });
                if (string.IsNullOrWhiteSpace(result))
                {
                    Init();
                    MessageUtil.ShowTips("配置修改成功。");
                }
                else
                {
                    MessageUtil.ShowTips(string.Format("配置修改失败，原因[{0}]", result));
                }
            }
            else 
            {
                MessageBox.Show("请悉知，该操作只有管理员权限才能进行更改！");
            }
        }

        //private void btnCreateOutInTask_Click(object sender, EventArgs e)
        //{
        //    string barcode = string.Empty;
        //    string loc_no = string.Empty;
        //    string srmno = string.Empty;
        //    string fromTunnelNum = string.Empty;
        //    if (radioButton1.Checked)
        //    {
        //        loc_no = "AR-14-1-1-1";
        //        barcode = "TPA00001";
        //        srmno = "srm05";
        //        fromTunnelNum = "6";
        //    }
        //    else if (radioButton2.Checked)
        //    {
        //        loc_no = "AR-12-1-1-1";
        //        barcode = "TPA00005";
        //        srmno = "srm04";
        //        fromTunnelNum = "5";
        //    }
        //    if (radioButton3.Checked)
        //    {
        //        loc_no = "AR-15-1-1-1";
        //        barcode = "TPA00006";
        //        srmno = "srm05";
        //        fromTunnelNum = "6";
        //    }
        //    else if (radioButton4.Checked)
        //    {
        //        loc_no = "AR-13-1-1-1";
        //        barcode = "TPA00007";
        //        srmno = "srm04";
        //        fromTunnelNum = "5";
        //    }
        //    if (radioButton5.Checked)
        //    {
        //        loc_no = "AR-14-2-1-1";
        //        barcode = "TPA00008";
        //        srmno = "srm05";
        //        fromTunnelNum = "6";
        //    }
        //    else if (radioButton6.Checked)
        //    {
        //        loc_no = "AR-15-2-1-1";
        //        barcode = "TPA00009";
        //        srmno = "srm05";
        //        fromTunnelNum = "6";
        //    }

        //    if (string.IsNullOrWhiteSpace(barcode))
        //    {
        //        MessageUtil.ShowTips("请选择要生成环线任务的条码");
        //        return;
        //    }

        //    WCS_TASK wcstask = null;
        //    string result = TryCachHelper.TryExecute((db) =>
        //    {

        //        var task = db.Queryable<WCS_TASK>().First(v => v.TASK_BOXBARCODE == barcode);
        //        if (task == null)
        //        {
        //            //添加wcs任务
        //            wcstask = new WCS_TASK();
        //            wcstask.TASK_WMSNO = barcode;
        //            wcstask.TASK_COMTYPE = 2;
        //            wcstask.TASK_SYSTYPE = "WMS";
        //            wcstask.TASK_POSIDFROM = loc_no;
        //            wcstask.TASK_POSIDCUR = loc_no;
        //            wcstask.TASK_POSIDNEXT = loc_no;
        //            wcstask.TASK_POSIDTO = "1117";
        //            wcstask.TASK_POSIDMOVE = "";
        //            wcstask.TASK_PRIORITY = 1;
        //            wcstask.TASK_WKSTATUS = 0;
        //            wcstask.TASK_WHID = "PVC原膜立库";
        //            wcstask.TASK_SRMNO = srmno;
        //            wcstask.TASK_ADDUSERNO = "WMS";
        //            wcstask.TASK_ADDDATETIME = DateTime.Now;
        //            wcstask.TASK_EDITUSERNO = "WMS";
        //            wcstask.TASK_EDITDATETIME = DateTime.Now;
        //            wcstask.TASK_NOTES = "";
        //            wcstask.TASK_RGVNO = "";
        //            wcstask.TASK_BOXBARCODE = barcode;
        //            wcstask.TASK_FromTunnelNum = fromTunnelNum;
        //            wcstask.TASK_ITEM2 = "2";
        //            wcstask.TASK_ITEM3 = "1";

        //            int id = db.Insertable(wcstask).ExecuteReturnIdentity();
        //            if (id <= 0)
        //            {
        //                throw new Exception(string.Format("条码[{0}]添加WCS任务出库失败", barcode));
        //            }
        //            else
        //            {
        //                wcstask.TASK_NO = id;
        //            }
        //        }
        //        else
        //        {
        //            throw new Exception(string.Format("条码[{0}]存在环线任务。", barcode));
        //        }
        //    });
        //    if (string.IsNullOrWhiteSpace(result))
        //    {
        //        MessageUtil.ShowTips("添加环线任务成功");
        //    }
        //    else
        //    {
        //        MessageUtil.ShowError(string.Format("添加环线任务失败.原因：[{0}]", result));
        //    }
        //}
    }

}