/// <summary> /// 窗体登陆时加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void PreWarningResultQuery_Load(object sender, EventArgs e) { #region 设定默认的时间 _dtpStartTime.ValueChanged -= _dtpStartTime_ValueChanged; _dtpEndTime.ValueChanged -= _dtpStartTime_ValueChanged; _dtpEndTime.Value = DateTime.Now; _dtpStartTime.Value = DateTime.Now.AddDays(-1); _dtpStartTime.ValueChanged += _dtpStartTime_ValueChanged; _dtpEndTime.ValueChanged += _dtpStartTime_ValueChanged; #endregion //加载预警类型 //AddWarningType(); var workingFace = WorkingFace.FindAll(); _cbxSelWorkSurface.Items.Add("全部"); _cbxSelWorkSurface.SelectedIndex = 0; foreach (var t in workingFace) { _cbxSelWorkSurface.Items.Add(t.WorkingFaceName); } //设置farpoint显示行列数 _fpTunelInfo.ActiveSheet.RowCount = 0; for (var i = 5; i < COLUMN_COUNT; i++) { _fpTunelInfo.ActiveSheet.Columns[i].Visible = false; } //Mark By QinKai,若添加新的预警依据项,需要更改的内容 //加载预警依据的类别 var WaringItemTypeNames = Enum.GetNames(typeof(WarningReasonItems)); cbWarningType.SelectedIndex = 0; for (var index = 0; index < WaringItemTypeNames.Length; index++) { infoCells[_iDetailsRowHeaderCount + index, 0].Text = WaringItemTypeNames[index]; infoCells[WaringItemTypeNames.Length + _iDetailsRowHeaderCount * 2 + index, 0].Text = WaringItemTypeNames[index]; } }
private void beDelete_ButtonClick(object sender, ButtonPressedEventArgs e) { if (!Alert.confirm("确认删除数据?")) { return; } switch (_typeFlag) { case FlagManangingMineName: // 矿井名称管理 DeleteInfo <Mine>(); gridControl1.DataSource = CollectionHelper.ConvertTo(Mine.FindAll()); break; case FlagManangingHorizontal: // 水平名称管理 DeleteInfo <Horizontal>(); gridControl1.DataSource = CollectionHelper.ConvertTo(Horizontal.FindAll()); break; case FlagManangingMiningArea: // 采区名称管理 DeleteInfo <MiningArea>(); gridControl1.DataSource = CollectionHelper.ConvertTo(MiningArea.FindAll()); break; case FlagManangingWorkingFace: // 工作面名称管理 DeleteInfo <WorkingFace>(); gridControl1.DataSource = CollectionHelper.ConvertTo(WorkingFace.FindAll()); break; case FlagManangingCoalSeam: // 煤层名称管理 DeleteInfo <CoalSeams>(); gridControl1.DataSource = CollectionHelper.ConvertTo(CoalSeams.FindAll()); break; } }
public static List <WorkingFaceHc> FindAll() { var results = new List <WorkingFaceHc>(); using (new SessionScope()) { var workingFaces = WorkingFace.FindAll(); results.AddRange(from workingFace in workingFaces let tunnelZy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_ZY) let tunnelFy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_FY) let tunnelQy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_QY) let tunnelOther = workingFace.Tunnels.Where(u => u.TunnelType == TunnelTypeEnum.OTHER).ToList() where tunnelZy != null && tunnelFy != null && tunnelQy != null select new WorkingFaceHc { WorkingFace = workingFace, TunnelZy = tunnelZy, TunnelFy = tunnelFy, TunnelQy = tunnelQy, TunnelOther = tunnelOther }); } return(results); }
/// <summary> /// 带参数的构造方法 /// </summary> /// <param name="typeFlag"></param> /// <param name="id"></param> public CommonManagement(int typeFlag, int id) { InitializeComponent(); Id = id; _typeFlag = typeFlag; switch (typeFlag) { case FlagManangingMineName: { // 窗口标题 Text = @"矿井名称管理"; AddIdColumn("编号", "MineId"); // 矿井名称 gridView1.Columns.Add(new GridColumn { Caption = @"矿井名称", FieldName = "MineName", VisibleIndex = gridView1.Columns.Count }); AddDeleteButton(); gridControl1.DataSource = CollectionHelper.ConvertTo(Mine.FindAll()); } break; case FlagManangingHorizontal: { Text = @"水平名称管理"; AddIdColumn("编号", "HorizontalId"); // 矿井名称 gridView1.Columns.Add(new GridColumn { Caption = @"水平名称", FieldName = "HorizontalName", VisibleIndex = gridView1.Columns.Count }); gridView1.Columns.Add(new GridColumn { Caption = @"所在矿区", FieldName = "Mine", ColumnEdit = lueMine, VisibleIndex = gridView1.Columns.Count, FilterMode = ColumnFilterMode.DisplayText }); AddDeleteButton(); lueMine.DataSource = Mine.FindAll(); gridControl1.DataSource = CollectionHelper.ConvertTo(Horizontal.FindAll()); } break; case FlagManangingMiningArea: { Text = @"采区名称管理"; AddIdColumn("编号", "MiningAreaId"); // 矿井名称 gridView1.Columns.Add(new GridColumn { Caption = @"采区名称", FieldName = "MiningAreaName", VisibleIndex = gridView1.Columns.Count }); // 所属水平 gridView1.Columns.Add(new GridColumn { Caption = @"所在水平", FieldName = "Horizontal", ColumnEdit = lueHorizontal, VisibleIndex = gridView1.Columns.Count, FilterMode = ColumnFilterMode.DisplayText }); AddDeleteButton(); lueHorizontal.DataSource = Horizontal.FindAll(); gridControl1.DataSource = CollectionHelper.ConvertTo(MiningArea.FindAll()); } break; case FlagManangingWorkingFace: { Text = @"工作面名称管理"; AddIdColumn("编号", "WorkingFaceId"); // 矿井名称 gridView1.Columns.Add(new GridColumn { Caption = @"工作面名称", FieldName = "WorkingFaceName", VisibleIndex = gridView1.Columns.Count }); gridView1.Columns.Add(new GridColumn { Caption = @"所在采区", FieldName = "MiningArea", ColumnEdit = lueMiningArea, VisibleIndex = gridView1.Columns.Count, FilterMode = ColumnFilterMode.DisplayText }); AddDeleteButton(); lueMiningArea.DataSource = MiningArea.FindAll(); gridControl1.DataSource = CollectionHelper.ConvertTo(WorkingFace.FindAll()); } break; case FlagManangingCoalSeam: { //// 窗口标题 Text = @"煤层名称管理"; gridView1.Columns.Add(new GridColumn { Caption = @"编号", FieldName = "CoalSeamsId", MaxWidth = 60, VisibleIndex = gridView1.Columns.Count }); // 矿井名称 gridView1.Columns.Add(new GridColumn { Caption = @"煤层名称", FieldName = "CoalSeamsName", VisibleIndex = gridView1.Columns.Count }); AddDeleteButton(); gridControl1.DataSource = CollectionHelper.ConvertTo(CoalSeams.FindAll()); } break; } }