Example #1
0
        public AlarmTemporaryModel GetAlarmTemporaryModel(int did)
        {
            IQueryable <AlarmTemporaryModel> source = from record in base.DataContext.AlarmTemporaryInfos
                                                      join rule in base.DataContext.AlarmRuleInfos on record.RuleDID equals rule.RuleDID
                                                      join content in base.DataContext.AlarmContentInfos on rule.AlarmTypeDID equals content.DID
                                                      //join craft in base.DataContext.CraftInfos on record.CraftDID equals craft.CraftDID
                                                      //join process in base.DataContext.ProcessInfos on record.ProcessDID equals process.ProcessDID
                                                      join facility in base.DataContext.FacilityInfos on record.FacilityDID equals facility.FacilityDID
                                                      //join unit in base.DataContext.UnitInfos on record.UnitDID equals unit.UnitDID
                                                      join alarmLocationImage in base.DataContext.AlarmLocationImageInfos on rule.AlarmLocationImageDID equals alarmLocationImage.DID
                                                      join solution in base.DataContext.SolutionInfos on rule.SolutionDID equals solution.DID
                                                      join solutionImage in base.DataContext.SolutionImageInfos on rule.SolutionImageDID equals solutionImage.DID
                                                      join reason in base.DataContext.AlarmReasonInfos on rule.AlarmTypeDID equals reason.DID
                                                      join alarmType in base.DataContext.AlarmTypeInfos on rule.AlarmTypeDID equals alarmType.DID
                                                      where record.AlarmTemporaryDID == did
                                                      select new AlarmTemporaryModel
            {
                AlarmContent = content.Content,
                DID          = record.FacilityDID,
                AlarmTime    = record.AlarmTime,
                DisposeTime  = record.DisposeTime,
                Duration     = record.Duration,
                FacilityName = facility.MMName,
                //ProcessName = process.Name,
                //UnitName = unit.Name,
                //CraftName = craft.Name,
                //AlarmCount = (int?)record.AlarmCount,
                //Address = record.Address,
                //AlarmLocationImagePath = alarmLocationImage.Path,
                //AlarmReasonText = reason.Content,
                //BatteryBarCode = record.BatteryBarCode,
                //CraftDID = record.CraftDID,
                //DisposeState = (int?)record.DisposeState,
                //FacilityDID = record.FacilityDID,
                //Handler = record.Handler,
                //ProcessDID = record.ProcessDID,
                //Remark = record.Remark,
                //RuleDID = record.RuleDID,
                //SolutionImagePath = solutionImage.Path,
                //SolutionText = solution.Content,
                //UnitDID = record.UnitDID,
                AlarmTypeName = alarmType.Type
            };
            AlarmTemporaryModel alarmTemporaryModel = source.FirstOrDefault <AlarmTemporaryModel>();

            if (alarmTemporaryModel != null)
            {
                alarmTemporaryModel.FieldValues = this.GetAlarmRuleFieldValues(alarmTemporaryModel.RuleDID);
            }
            return(alarmTemporaryModel);
        }
Example #2
0
        private void Page_Loaded(object sender, RoutedEventArgs e)
        {
            AlarmTemporaryGetResponse temporaryGetResponse = LocalApi.Execute(new AlarmTemporaryGetRequest()
            {
                AlarmTemporaryDID = this.AlarmTemporaryDID
            });

            if (temporaryGetResponse.AlarmTemporary == null)
            {
                return;
            }
            this.model = temporaryGetResponse.AlarmTemporary;
            List <FieldRow> fieldRowList1 = new List <FieldRow>();
            List <FieldRow> fieldRowList2 = fieldRowList1;
            FieldRow        fieldRow1     = new FieldRow();

            fieldRow1.FieldName = "报警编号";
            string string1 = this.model.RuleDID.ToString();

            fieldRow1.FieldValue = string1;
            fieldRowList2.Add(fieldRow1);
            List <FieldRow> fieldRowList3 = fieldRowList1;
            FieldRow        fieldRow2     = new FieldRow();

            fieldRow2.FieldName = "报警时间";
            string string2 = this.model.AlarmTime.ToString("yyyy-MM-dd HH:mm:ss");

            fieldRow2.FieldValue = string2;
            fieldRowList3.Add(fieldRow2);
            List <FieldRow> fieldRowList4 = fieldRowList1;
            FieldRow        fieldRow3     = new FieldRow();

            fieldRow3.FieldName = "报警内容";
            string alarmContent = this.model.AlarmContent;

            fieldRow3.FieldValue = alarmContent;
            fieldRowList4.Add(fieldRow3);
            List <FieldRow> fieldRowList5 = fieldRowList1;
            FieldRow        fieldRow4     = new FieldRow();

            fieldRow4.FieldName = "报警部件";
            string unitName = this.model.UnitName;

            fieldRow4.FieldValue = unitName;
            fieldRowList5.Add(fieldRow4);
            List <FieldRow> fieldRowList6 = fieldRowList1;
            FieldRow        fieldRow5     = new FieldRow();

            fieldRow5.FieldName = "所在工位";
            string facilityName = this.model.FacilityName;

            fieldRow5.FieldValue = facilityName;
            fieldRowList6.Add(fieldRow5);
            fieldRowList1.Add(new FieldRow()
            {
                FieldName  = "报警类型",
                FieldValue = this.model.AlarmTypeName
            });
            List <FieldRow> fieldRowList7 = fieldRowList1;
            FieldRow        fieldRow6     = new FieldRow();

            fieldRow6.FieldName = "异常原因";
            string alarmReason = this.model.AlarmReason;

            fieldRow6.FieldValue = alarmReason;
            fieldRowList7.Add(fieldRow6);
            List <FieldRow> fieldRowList8 = fieldRowList1;
            FieldRow        fieldRow7     = new FieldRow();

            fieldRow7.FieldName = "解决方案";
            string solutionText = this.model.SolutionText;

            fieldRow7.FieldValue = solutionText;
            fieldRowList8.Add(fieldRow7);
            List <FieldRow> fieldRowList9 = fieldRowList1;
            FieldRow        fieldRow8     = new FieldRow();

            fieldRow8.FieldName = "报警地址";
            string address = this.model.Address;

            fieldRow8.FieldValue = address;
            fieldRowList9.Add(fieldRow8);
            foreach (AlarmFieldValue fieldValue in this.model.FieldValues)
            {
                fieldRowList1.Add(new FieldRow()
                {
                    FieldName  = fieldValue.FieldDescription,
                    FieldValue = fieldValue.FieldValue
                });
            }
            //string urlstring = "C:/" + this.model.AlarmLocationImagePath;
            string urlstring = System.Environment.CurrentDirectory + this.model.AlarmLocationImagePath;

            if (System.IO.File.Exists(urlstring))
            {
                this.imgAlarmLocation.Source = new BitmapImage(new Uri(urlstring, UriKind.Absolute));
            }
            else
            {
                urlstring = urlstring = System.Environment.CurrentDirectory + "/ErrorPic/Error.jpg";
            }
            this.imgAlarmLocation.Source = new BitmapImage(new Uri(urlstring, UriKind.Absolute));
            this.dataGrid.ItemsSource    = fieldRowList1;
        }
Example #3
0
        public AlarmTemporaryModel GetAlarmTemporaryModel(int did)
        {
            Database equipDB = dataProvider.EQUIPDataBase;
            string   sql     = string.Format(
                @"select temp.alarm_temporary_did
						    , temp.rule_did
						    , cr.craft_did
						    , p.process_did
						    , f.facility_did
						    , u.unit_did
                            , temp.alarm_time
						    , temp.dispose_state
						    , temp.dispose_time
						    , temp.handler
						    , temp.duration
						    , temp.address
						    , temp.remark
	                        , rule.alarm_content
	                        , rule.alarm_reason
	                        , sl.content
	                        , slimage.path
	                        , image.path
	                        , cr.craft_name
	                        , u.unit_name
	                        , p.process_name
	                        , f.MMName
	                        , almtp.type
                    from alarm_temporary temp 
                    join facility_info f on f.facility_did = temp.facility_did
                    join alarm_rule rule on rule.rule_did = temp.rule_did
                    join craft cr on cr.craft_did = rule.craft_did
                    join unit u on u.unit_did = rule.unit_did
                    join alarm_type almtp on almtp.did = rule.alarm_type_did
                    join process p on p.process_did = f.process_did
					left join alarm_location_image image on image.did = rule.alarm_location_image_did
					left join solution sl on sl.did = rule.solution_did
					left join solution_image slimage on slimage.did = rule.solution_image_did
					where temp.alarm_temporary_did = {0};"
                , did);

            DataSet   ds = equipDB.ExecuteDataSet(CommandType.Text, sql);
            DataTable tb = ds.Tables[0];

            if (tb != null && tb.Rows.Count > 0)
            {
                AlarmTemporaryModel model = new AlarmTemporaryModel();

                model.DID         = int.Parse(tb.Rows[0][0].ToString());
                model.RuleDID     = tb.Rows[0][1].ToString();
                model.CraftDID    = int.Parse(tb.Rows[0][2].ToString());
                model.ProcessDID  = int.Parse(tb.Rows[0][3].ToString());
                model.FacilityDID = int.Parse(tb.Rows[0][4].ToString());
                model.UnitDID     = int.Parse(tb.Rows[0][5].ToString());
                model.AlarmTime   = DateTime.Parse(tb.Rows[0][6].ToString());
                if (tb.Rows[0][7].ToString() != "")
                {
                    model.DisposeState = 0;
                }
                int.Parse(tb.Rows[0][7].ToString());
                if (tb.Rows[0][8].ToString() != "")
                {
                    model.DisposeTime = DateTime.Parse(tb.Rows[0][8].ToString());
                }
                model.Handler = tb.Rows[0][9].ToString();
                if (tb.Rows[0][10].ToString() != "")
                {
                    model.Duration = int.Parse(tb.Rows[0][10].ToString());
                }
                model.Address                = tb.Rows[0][11].ToString();
                model.Remark                 = tb.Rows[0][12].ToString();
                model.AlarmContent           = tb.Rows[0][13].ToString();
                model.AlarmReason            = tb.Rows[0][14].ToString();
                model.SolutionText           = tb.Rows[0][15].ToString();
                model.SolutionImagePath      = tb.Rows[0][16].ToString();
                model.AlarmLocationImagePath = tb.Rows[0][17].ToString();
                model.CraftName              = tb.Rows[0][18].ToString();
                model.UnitName               = tb.Rows[0][19].ToString();
                model.ProcessName            = tb.Rows[0][20].ToString();
                model.FacilityName           = tb.Rows[0][21].ToString();
                model.AlarmTypeName          = tb.Rows[0][22].ToString();

                model.FieldValues = this.GetAlarmRuleFieldValues(model.RuleDID);
                return(model);
            }
            else
            {
                throw new Exception("执行GetAlarmTemporaryModel未查询到数据");
            }
        }