YG-PVC-WCS/WCS_Client/Frm/MBtn_AgvTask/FrmAddWorkshopTask.cs

using DevComponents.DotNetBar;
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 WCS.Data.Models;
using WCS_Client.UC;

namespace WCS_Client.Frm
{
    public partial class FrmAddWorkshopTask : Office2007Form
    {
        public FrmAddWorkshopTask()
        {
            InitializeComponent();
        }

        private void btnCancel_Click_1(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnUpdateP_Click_1(object sender, EventArgs e)
        {
            if (cbworkshopno.Text == "" || cbprolineno.Text == "")
            {
                MessageUtil.ShowTips("车间编号和生产线不能为空！");
                return;
            }
            string msg=BaseWorkflow.AddWorkShopTask(cbworkshopno.Text, cbprolineno.Text);
            MessageUtil.ShowTips(msg);
            this.Close();
        }

        private void cbprolineno_DropDown(object sender, EventArgs e)
        {
            cbprolineno.Items.Clear();
            TryCachHelper.TryExecute((db) =>
            {
                var txtcbworkshopno = db.Queryable<WCS_EQUIPMENTROUTE>()
                               .Where(v => v.ROUTE_SONPOS.StartsWith("Pvc"))
                               .Where(v => !v.ROUTE_SONPOS.Contains("Emp"))
                               .Where(v => !v.ROUTE_SONPOS.Contains("Back"))
                               .Where(v => !v.ROUTE_SONPOS.Contains("Prepare")).ToList();
                var ROUTE_SONPOS = txtcbworkshopno.Where(v => v.ROUTE_SONPOS.Split('_')[1].ToString() == cbworkshopno.Text).Select(v => v.ROUTE_SONPOS).Distinct().ToList();
                if (ROUTE_SONPOS.Any())
                {
                    foreach (var i in ROUTE_SONPOS)
                        cbprolineno.Items.Add(i);
                }
            });
        }
    }
}