using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using CoreFS.CA06; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec { public partial class FrmJyx : FrmBase { private string _choicePlineCode = ""; public string ChoicePlineCode { get { return _choicePlineCode; } set { _choicePlineCode = value; } } private string _choicePlineName = ""; public string ChoicePlineName { get { return _choicePlineName; } set { _choicePlineName = value; } } private DataTable _dtPline = null; public FrmJyx(DataTable dtPline, string choicePlineCode, OpeBase ob) { InitializeComponent(); _dtPline = dtPline; this.ob = ob; GridHelper.CopyDataToDatatable(dtPline, dataTable1, true); foreach (var row in ultraGrid1.Rows) { if (choicePlineCode.Contains(row.GetValue("PHY_TYPE"))) { row.Cells["chk"].Value = true; row.Update(); } } } //private void Query() //{ // string plineName = labelTextBox1.Text.Trim(); // string factoryDesc = labelComboBox1.Text.ToString2(); // string checkStationDesc = labelComboBox2.Text.ToString2(); // if (labelTextBox1.Checked && labelComboBox1.Checked && labelComboBox2.Checked) // { // _dtPline.DefaultView.RowFilter = "plineName like '%" + plineName + "%' and factoryDesc like '%" + factoryDesc + "%' and checkStationDesc like '%" + checkStationDesc + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (labelTextBox1.Checked && labelComboBox1.Checked) // { // _dtPline.DefaultView.RowFilter = "plineName like '%" + plineName + "%' and factoryDesc like '%" + factoryDesc + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (labelTextBox1.Checked && labelComboBox2.Checked) // { // _dtPline.DefaultView.RowFilter = "plineName like '%" + plineName + "%' and checkStationDesc like '%" + checkStationDesc + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (labelComboBox1.Checked && labelComboBox2.Checked) // { // _dtPline.DefaultView.RowFilter = "factoryDesc like '%" + factoryDesc + "%' and checkStationDesc like '%" + checkStationDesc + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (labelTextBox1.Checked) // { // _dtPline.DefaultView.RowFilter = "plineName like '%" + plineName + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (labelComboBox1.Checked) // { // _dtPline.DefaultView.RowFilter = "factoryDesc like '%" + factoryDesc + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else if (labelComboBox2.Checked) // { // _dtPline.DefaultView.RowFilter = "checkStationDesc like '%" + checkStationDesc + "%'"; // DataTable dt = _dtPline.DefaultView.ToTable(); // GridHelper.CopyDataToDatatable(dt, dataTable1, true); // } // else // { // GridHelper.CopyDataToDatatable(_dtPline, dataTable1, true); // } // foreach (var row in ultraGrid1.Rows) // { // row.Cells["chk"].Value = true; // row.Update(); // } //} private void Submit() { var rows = ultraGrid1.Rows.Where(a=>a.GetValue("chk") == "True"); if (rows.Count() == 0) { MessageUtil.ShowWarning("请选择一行记录!"); return; } _choicePlineCode = string.Join(",", rows.Select(a => a.GetValue("PHY_TYPE")).ToArray()); _choicePlineName = string.Join(",", rows.Select(a => a.GetValue("PHY_TYPE")).ToArray()); this.DialogResult = System.Windows.Forms.DialogResult.OK; } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "确认": Submit(); break; case "关闭": this.Close(); break; } } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { e.Cell.Row.Update(); } private void ChoicePlineFrm_Load(object sender, EventArgs e) { //ClsBaseInfo.FillComBaseInfo(labelComboBox1.ComboBox, "4105", ob, false); //ClsBaseInfo.FillComBaseInfo(labelComboBox2.ComboBox, "4106", ob, false); //string factoryDescs = ""; //foreach (DataRow dr in dataTable1.Rows) //{ // if (factoryDescs == "") // { // if (dr["factoryDesc"].ToString() != "") // { // factoryDescs = "'" + dr["factoryDesc"].ToString() + "'"; // } // } // else // { // if (dr["factoryDesc"].ToString() != "") // { // factoryDescs += ", '" + dr["factoryDesc"].ToString() + "'"; // } // } //} //factoryDescs = factoryDescs.Trim('\''); ////((DataTable)labelComboBox1.ComboBox.DataSource).DefaultView.RowFilter = "BASENAME IN ('" + factoryDescs + "')"; //string checkDescs = ""; //foreach (DataRow dr in dataTable1.Rows) //{ // if (checkDescs == "") // { // if (dr["checkStationDesc"].ToString() != "") // { // checkDescs = "'" + dr["checkStationDesc"].ToString() + "'"; // } // } // else // { // if (dr["checkStationDesc"].ToString() != "") // { // checkDescs += ", '" + dr["checkStationDesc"].ToString() + "'"; // } // } //} //checkDescs = checkDescs.Trim('\''); //((DataTable)labelComboBox2.ComboBox.DataSource).DefaultView.RowFilter = "BASENAME IN ('" + checkDescs + "')"; } } }