using Bro.M071.DBManager; using Bro.M071.Model.Model; using Bro.UI.Model.Winform; 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; namespace Bro.M071.Process.UI { [MenuNode("M071_DataForm", "数据查询界面", 3, "M071Node", true)] public partial class M071_DataForm : MenuFrmBase { public ProductionMeasurementRecordsManager _productionMeasurementRecordsManager = new ProductionMeasurementRecordsManager(); public MeasurementUnitResultManager _measurementUnitResultManager = new MeasurementUnitResultManager(); public M071_DataForm() { InitializeComponent(); InitialProductionRecordsLayout(); InitialMeasurementResultLayout(); } #region 产品记录 private void InitialProductionRecordsLayout() { comboBoxPResult.DataSource = new List() { "", "OK", "NG" }; } private void buttonQuery_Click(object sender, EventArgs e) { ProductionMeasurementRecordsRequest recordsRequest = new ProductionMeasurementRecordsRequest(); recordsRequest.ProductionCode = textBoxPCode.Text; recordsRequest.ProductionBarcode = textBoxPBarCode.Text; recordsRequest.ProductionResult = comboBoxPResult.SelectedItem?.ToString(); recordsRequest.StartTime = Convert.ToDateTime(dateTimePStartTime.Value.ToString("D").ToString()); recordsRequest.EndTime = Convert.ToDateTime(dateTimePEndTime.Value.AddDays(1).ToString("D").ToString()).AddSeconds(-1); var queryData = _productionMeasurementRecordsManager.GetProductionMeasurementRecords(recordsRequest); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = queryData; labelTotal.Text = $"数量:{recordsRequest.TotalNum} 总页数:{recordsRequest.TotalPage}"; textBoxPageNum.Text = recordsRequest.PageNum.ToString(); } #endregion #region 测量结果 private void InitialMeasurementResultLayout() { comboBoxResult_MR.DataSource = new List() { "", "OK", "NG" }; comboBoxMeasurementType_MR.DataSource = new List() { "", "Slant", "HeightAlignment", "FullRowHeightAlignment" }; } private void buttonQuery_MR_Click(object sender, EventArgs e) { MeasurementUnitResultRequest recordsRequest = new MeasurementUnitResultRequest(); recordsRequest.ProductionCode = textBoxPCode_MR.Text; recordsRequest.ProductionBarcode = textBoxtextBoxPBarCode_MR.Text; recordsRequest.MeasurementName = textBoxMeasurementName_MR.Text; recordsRequest.MeasurementType = comboBoxMeasurementType_MR.SelectedItem?.ToString(); recordsRequest.MeasurementResult = comboBoxResult_MR.SelectedItem?.ToString(); recordsRequest.StartTime = Convert.ToDateTime(dateTimePickerStartTime_MR.Value.ToString("D").ToString()); recordsRequest.EndTime = Convert.ToDateTime(dateTimePickerEndTime_MR.Value.AddDays(1).ToString("D").ToString()).AddSeconds(-1); var queryData = _measurementUnitResultManager.GetMeasurementUnitResult(recordsRequest); dataGridView2.AutoGenerateColumns = false; dataGridView2.DataSource = queryData; labelTotal_MR.Text = $"数量:{recordsRequest.TotalNum} 总页数:{recordsRequest.TotalPage}"; textBoxPageNum_MR.Text = recordsRequest.PageNum.ToString(); } #endregion } }