Exemplo n.º 1
0
        private void simpleButton8_Click(object sender, EventArgs e)
        {
            try
            {
                if (comboBoxEdit_SensorName.Text.Trim() == string.Empty)
                {
                    XtraMessageBox.Show("请选择设备名称");
                    return;
                }
                if (comboBoxEdit_GasName.Text.Trim() == string.Empty)
                {
                    XtraMessageBox.Show("请选择气体名称");
                    return;
                }
                TimeSpan ts  = dateEdit_end.DateTime - dateEdit_Start.DateTime;
                TimeSpan ts1 = new TimeSpan(0, 0, 0, 1);
                if (ts < ts1)
                {
                    XtraMessageBox.Show("截止时间必须大于起始时间");
                    return;
                }
                Equipment eq = mainList.Find(c => c.Name == comboBoxEdit_SensorName.Text.Trim() && c.GasName == comboBoxEdit_GasName.Text.Trim() && c.Address == Convert.ToByte(comboBoxEdit_Address.Text.Trim()));

                List <Alert> data = AlertDal.GetListByTime(eq.ID, dateEdit_Start.DateTime, dateEdit_end.DateTime);
                if (data == null || data.Count < 1)
                {
                    gridControl3.DataSource = null;
                    LogLib.Log.GetLogger(this).Warn("数据库中没有记录");
                    return;
                }
                selectEq = eq;
                gridControl3.DataSource = data;
                gridView3.BestFitColumns();
            }
            catch (Exception ex)
            {
                LogLib.Log.GetLogger(this).Warn(ex);
            }
        }
Exemplo n.º 2
0
        private void btn_searchAlert_Click(object sender, EventArgs e)
        {
            TimeSpan ts  = dateEdit_EndAlert.DateTime - dateEdit_StartAlert.DateTime;
            TimeSpan ts1 = new TimeSpan(0, 0, 0, 1);

            if (ts < ts1)
            {
                XtraMessageBox.Show("截止时间必须大于起始时间");
                return;
            }
            //Equipment eq = mainList.Find(c => c.Name == comboBoxEdit_SensorName.Text.Trim() && c.GasName == comboBoxEdit_GasName.Text.Trim());

            List <Alert> data = AlertDal.GetListByTime(dateEdit_StartAlert.DateTime, dateEdit_EndAlert.DateTime);

            if (data == null || data.Count < 1)
            {
                gridControl_Alert.DataSource = null;
                LogLib.Log.GetLogger(this).Warn("数据库中没有记录");
                return;
            }
            gridControl_Alert.DataSource = data;
            gridView_Alert.BestFitColumns();
        }
Exemplo n.º 3
0
        /// <summary>
        /// 删除查询到的数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            try
            {
                if (selectEq == null)
                {
                    return;
                }
                //if (Gloabl.Userinfo.Level != EM_UserType.Admin)
                //{
                //    XtraMessageBox.Show("只有管理员才能删除数据");
                //    return;
                //}

                TimeSpan ts  = dateEdit_end.DateTime - dateEdit_Start.DateTime;
                TimeSpan ts1 = new TimeSpan(0, 0, 0, 1);
                if (ts < ts1)
                {
                    XtraMessageBox.Show("截止时间必须大于起始时间");
                    return;
                }
                if (XtraMessageBox.Show("数据将要被删除,是否继续", "注意", MessageBoxButtons.YesNo) != System.Windows.Forms.DialogResult.Yes)
                {
                    return;
                }

                int count = AlertDal.DeleteByTime(selectEq.ID, dateEdit_Start.DateTime, dateEdit_end.DateTime);
                gridControl3.DataSource = null;
                selectEq = null;
                XtraMessageBox.Show(string.Format("本次删除{0}条数据", count));
            }
            catch (Exception ex)
            {
                LogLib.Log.GetLogger(this).Warn(ex);
            }
        }
Exemplo n.º 4
0
        // 读取主表类容
        private void readMain(Equipment eq)
        {
            Command cd = new Command(eq.Address, 0x00, 0x00, 3);

            if (Gloabl.IsAdmin)
            {
                this.Invoke(new Action <string>(addText), "W: " + Parse.byteToHexStr(cd.SendByte));
            }

            if (!CommandResult.GetResult(cd))
            {
                if (eq.lostNum >= 10)
                {
                    eq.IsConnect = false;
                }
                else
                {
                    eq.lostNum++;
                }
                return;
            }
            else
            {
                eq.IsConnect = true;
                eq.lostNum   = 0;
            }
            if (Gloabl.IsAdmin)
            {
                this.Invoke(new Action <string>(addText), "R: " + Parse.byteToHexStr(cd.ResultByte));
            }

            EquipmentData data = Parse.GetRealData(cd.ResultByte, eq);

            data.EquipmentID = eq.ID;

            // 添加数据库
            EquipmentDataDal.AddOne(data);

            eq.Chroma = data.Chroma;


            // 绘制曲线
            if (eq.ID == Convert.ToInt32(seriesOne.Tag))
            {
                this.Invoke(new Action <EquipmentData>(c => addPoint(c)), data);
            }
            if (eq.AlertType == 0)
            {
                eq.ChromaAlertStr = Gloabl.NormalStr;
            }
            else
            {
                // 报警记录
                if (eq.ChromaAlertStr != data.ChromaAlertStr)
                {
                    if (eq.ChromaAlertStr.Equals(Gloabl.NormalStr, StringComparison.OrdinalIgnoreCase))
                    {
                        Alert art = new Alert();
                        art.AlertName   = data.ChromaAlertStr;
                        art.EquipmentID = eq.ID;
                        eq.AlertObject  = AlertDal.AddOneR(art);
                    }
                    else
                    {
                        eq.AlertObject.EndTime = DateTime.Now;
                        AlertDal.UpdateOne(eq.AlertObject);
                        if (!eq.ChromaAlertStr.Equals(data.ChromaAlertStr, StringComparison.OrdinalIgnoreCase))
                        {
                            Alert art = new Alert();
                            art.AlertName   = data.ChromaAlertStr;
                            art.EquipmentID = eq.ID;
                            eq.AlertObject  = AlertDal.AddOneR(art);
                        }
                    }
                    eq.ChromaAlertStr = data.ChromaAlertStr;
                }
                else
                {
                    if (!eq.ChromaAlertStr.Equals(Gloabl.NormalStr, StringComparison.OrdinalIgnoreCase))
                    {
                        eq.AlertObject.EndTime = DateTime.Now;
                        if (!AlertDal.UpdateOne(eq.AlertObject))
                        {
                            Alert art = new Alert();
                            art.AlertName   = data.ChromaAlertStr;
                            art.EquipmentID = eq.ID;
                            eq.AlertObject  = AlertDal.AddOneR(art);
                        }
                    }
                }
            }
        }
Exemplo n.º 5
0
        public static void AddAlert(Equipment newData, Equipment originalData)
        {
            if (newData.Chroma >= originalData.A2)
            {
                newData.ChromaAlertStr = "高报警";
            }
            else if (newData.Chroma >= originalData.A1 && newData.Chroma < originalData.A2)
            {
                newData.ChromaAlertStr = "低报警";
            }
            else
            {
                newData.ChromaAlertStr = "无报警";
            }

            if (originalData.ChromaAlertStr != newData.ChromaAlertStr)
            {
                if (originalData.ChromaAlertStr == "无报警" || string.IsNullOrWhiteSpace(originalData.ChromaAlertStr))
                {
                    Alert art = new Alert();
                    art.AlertName            = newData.ChromaAlertStr;
                    art.EquipmentID          = originalData.ID;
                    originalData.AlertObject = AlertDal.AddOneR(art);
                }
                else
                {
                    originalData.AlertObject.EndTime = DateTime.Now;
                    AlertDal.UpdateOne(originalData.AlertObject);
                    if (!string.IsNullOrWhiteSpace(newData.ChromaAlertStr))
                    {
                        Alert art = new Alert();
                        art.AlertName            = newData.ChromaAlertStr;
                        art.EquipmentID          = originalData.ID;
                        originalData.AlertObject = AlertDal.AddOneR(art);
                    }
                }
                originalData.ChromaAlertStr = newData.ChromaAlertStr;
            }
            else
            {
                if (!string.IsNullOrWhiteSpace(originalData.ChromaAlertStr))
                {
                    originalData.AlertObject.EndTime = DateTime.Now;
                    if (!AlertDal.UpdateOne(originalData.AlertObject))
                    {
                        Alert art = new Alert();
                        art.AlertName            = newData.ChromaAlertStr;
                        art.EquipmentID          = originalData.ID;
                        originalData.AlertObject = AlertDal.AddOneR(art);
                    }
                }
                //Trace.WriteLine(string.Format("[{1}]  {0}:相同报警", eq.SensorType, DateTime.Now.ToLongTimeString()));
            }

            //if (eq.THAlertStr != data.THAlertStr)
            //{
            //    if (!string.IsNullOrWhiteSpace(eq.THAlertStr))
            //    {
            //        eq.THAlertObject.EndTime = DateTime.Now;
            //        AlertDal.UpdateOne(eq.THAlertObject);
            //        if (!string.IsNullOrWhiteSpace(data.THAlertStr))
            //        {
            //            Alert art = new Alert();
            //            art.AlertName = data.THAlertStr;
            //            art.EquipmentID = eq.ID;
            //            eq.THAlertObject = AlertDal.AddOneR(art);
            //        }
            //    }
            //    else
            //    {
            //        Alert art = new Alert();
            //        art.AlertName = data.THAlertStr;
            //        art.EquipmentID = eq.ID;
            //        eq.THAlertObject = AlertDal.AddOneR(art);
            //    }
            //    eq.THAlertStr = data.THAlertStr;
            //}
            //else
            //{
            //    if (!string.IsNullOrWhiteSpace(eq.THAlertStr))
            //    {
            //        eq.THAlertObject.EndTime = DateTime.Now;
            //        AlertDal.UpdateOne(eq.THAlertObject);
            //    }
            //}
        }