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);
}
