YG-OPP-WCS-Client/WCS_Client/Frm/MBtn_Sys/FormSet.cs

using Newtonsoft.Json.Linq;
using System;
using System.Linq;
using System.Windows.Forms;
using WCS.Data.Models;
using WCS_Client.UC;
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 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)
        {
        }

        public GetInTaskReply I_WCS_GetInTask(GetInTaskParam param)
        {
            GetInTaskReply reply = null;
            try
            {
                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());
            }
            catch (Exception ex)
            {
                MessageBox.Show(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();
                }
            });
                if (string.IsNullOrWhiteSpace(result))
                {
                    Init();
                    MessageUtil.ShowTips("配置修改成功。");
                }
                else
                {
                    MessageUtil.ShowTips(string.Format("配置修改失败，原因[{0}]", result));
                }
            }
            else
            {
                MessageBox.Show("请悉知，该操作只有管理员权限才能进行更改！");
            }
        }
    }
}