using DevExpress.XtraEditors; using DevExpress.XtraGrid.Columns; namespace IStation.Win { public partial class ModelScheduleValidView : XtraUserControl { public ModelScheduleValidView() { InitializeComponent(); this.gridView1.SetNormalView(); this.gridView2.SetNormalView(); this.gridView2.OptionsView.ColumnAutoWidth = false; foreach (GridColumn col in gridView2.Columns) { col.MinWidth = 60; } var year = 2024; var month = 1; this.dateEditStart.DateTime = new DateTime(year, month, 1); this.dateEditEnd.DateTime = new DateTime(year, month, DateTime.DaysInMonth(year, month)); } private List _hydraulic_model_record_list = null; //加载 private void barBtnLoad_Click(object sender, EventArgs e) { WaitHelper.ShowWaitForm(); var start_time = this.dateEditStart.DateTime; var end_time = this.dateEditEnd.DateTime; _hydraulic_model_record_list = new IStation.Service.HydraulicModelRecord().GetByDate(start_time, end_time); if (_hydraulic_model_record_list == null || !_hydraulic_model_record_list.Any()) { WaitHelper.HideWaitForm(); XtraMessageBox.Show("无数据!"); return; } SetGridView1(_hydraulic_model_record_list); //SetGridView2(_hydraulic_model_record_list); WaitHelper.HideWaitForm(); } private void SetGridView1(List hydraulic_model_record_list) { var model_valid_vm_list = new List(); if (hydraulic_model_record_list != null && hydraulic_model_record_list.Any()) { foreach (var hydraulic_model_record in hydraulic_model_record_list) { var model_valid_vm = new ModelScheduleValidViewModel(); model_valid_vm.Time = hydraulic_model_record.Time; model_valid_vm.ValueType = hydraulic_model_record.ValueType; model_valid_vm.ModelId = hydraulic_model_record.ModelId; model_valid_vm.ScadaId = hydraulic_model_record.ScadaId; model_valid_vm.ModeValue = hydraulic_model_record.ModeValue; model_valid_vm.ScadaValue = hydraulic_model_record.ScadaValue; model_valid_vm.DifferenceValue = hydraulic_model_record.DifferenceValue; model_valid_vm.Round(); model_valid_vm_list.Add(model_valid_vm); } } this.modelValidViewModelBindingSource.DataSource = model_valid_vm_list; this.modelValidViewModelBindingSource.ResetBindings(false); } private void SetGridView2(List hydraulic_model_record_list) { var model_scada_valid_vm_list = new List(); if (hydraulic_model_record_list != null && hydraulic_model_record_list.Any()) { //foreach (var hydraulic_model_record in hydraulic_model_record_list) //{ // var time = hydraulic_model_record.Time.ToString("G"); // var model_id = hydraulic_model_record.ModelId; // var scada_id = hydraulic_model_record.ScadaId; // var model_scada_id = GetTempId(model_id, scada_id); // DataRow dr = _data_table.Rows.Find(time); // if (dr == null) // { // dr = _data_table.NewRow(); // dr["Time"] = time; // dr[model_id] = hydraulic_model_record.ModeValue; // dr[scada_id] = hydraulic_model_record.ScadaValue; // dr[model_scada_id] = hydraulic_model_record.DifferenceValue; // _data_table.Rows.Add(dr); // } // else // { // dr[model_id] = hydraulic_model_record.ModeValue; // dr[scada_id] = hydraulic_model_record.ScadaValue; // dr[model_scada_id] = hydraulic_model_record.DifferenceValue; // } //} } this.gridControl2.DataSource = model_scada_valid_vm_list; this.gridControl2.RefreshDataSource(); this.gridView2.BestFitColumns(); } } }