private void InitAlarmTypes() { var types = AlarmTypeName.GetAlarmTypes(); ComboBoxItem cbi = new ComboBoxItem("none", "--无--"); cbi.Tag = null; cboAlarmType.Items.Add(cbi); foreach (var item in types) { ComboBoxItem cbii = new ComboBoxItem(item.Name, item.Name); cbii.Tag = item; cboAlarmType.Items.Add(cbii); } cboAlarmType.SelectedIndex = 0; }
private void btnSearch_Click(object sender, EventArgs e) { List <Maticsoft.Model.SMT_DOOR_INFO> doors = new List <Maticsoft.Model.SMT_DOOR_INFO>(); if (cboDoor.SelectedNode != null && cboDoor.SelectedNode.Level > 0) { doors = GetSelectNodes <Maticsoft.Model.SMT_DOOR_INFO>(cboDoor.SelectedNode); } if (dtpStart.Value >= dtpEnd.Value) { WinInfoHelper.ShowInfoWindow(this, "开始时间大于结束时间!"); return; } string doorIds = "";//门列表 foreach (var item in doors) { doorIds += item.ID + ","; } doorIds = doorIds.TrimEnd(','); string strWhere = ""; if (!string.IsNullOrWhiteSpace(doorIds)) { strWhere = "DOOR_ID in (" + doorIds + ") and "; } if (cboAlarmType.SelectedItem != null) { ComboBoxItem item = (ComboBoxItem)cboAlarmType.SelectedItem; if (item.Tag != null) { AlarmTypeName typeName = (AlarmTypeName)item.Tag; strWhere += " ALARM_TYPE=" + (int)typeName.Reason + " and "; } } strWhere += "ALARM_TIME >='" + dtpStart.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and ALARM_TIME <='" + dtpEnd.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'"; pageDataGridView.Reset(); pageDataGridView.SqlWhere = strWhere; DoSearch(true); }