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() .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); } }); } } }