public AddInfomation(string pipingid) { InitializeComponent(); PipingDetailInfo detailInfo = service.GetInfo(MainWindow.loginUser.UserName, pipingid).ext; keyId = detailInfo.PipingDetectionInfo.KeyID; pipingId = pipingid; TextBox1.Text = detailInfo.PipingDetectionInfo.VideoFile; TextBox2.Text = detailInfo.PipingDetectionInfo.LayingYear; TextBox3.Text = detailInfo.PipingDetectionInfo.TubulationType; TextBox4.Text = detailInfo.PipingDetectionInfo.DetectionDirect; TextBox5.Text = detailInfo.PipingDetectionInfo.DetectionAddress; TextBox6.Text = detailInfo.PipingDetectionInfo.StartWellNo; TextBox7.Text = detailInfo.PipingDetectionInfo.StartPointDepth; TextBox8.Text = detailInfo.PipingDetectionInfo.TubulationMaterial; TextBox9.Text = detailInfo.PipingDetectionInfo.TubulationLength; TextBox10.Text = detailInfo.PipingDetectionInfo.DetectionFun; TextBox11.Text = detailInfo.PipingDetectionInfo.EndWellNo; TextBox12.Text = detailInfo.PipingDetectionInfo.EndPointDepth; TextBox13.Text = detailInfo.PipingDetectionInfo.TubulationDiameter; TextBox14.Text = detailInfo.PipingDetectionInfo.DetectionLength; TextBox15.Text = detailInfo.PipingDetectionInfo.DetectionTime; //drawing.Text = gcPictInfo.PictureFilePath; List <PipingPictureInfo> picInfo = detailInfo.PipingPictureInfoes; PipingPictureInfo gcPic = new PipingPictureInfo(); foreach (var i in picInfo) { if (i.PictureType == 1) { AddImgGrid(i.PictureFilePath); } else { drawing.Text = i.PictureFilePath; gcPic = i; } imgList.Add(i.PictureFilePath); } picInfo.Remove(gcPic); // 加载图片信息 for (int i = 0; i <= pictureInfo.Children.Count - 1; i++) { StackPanel infos = (StackPanel)((Grid)pictureInfo.Children[i]).Children[2]; ((TextBox)infos.Children[3]).Text = picInfo[i].Grade; ((TextBox)infos.Children[2]).Text = picInfo[i].Score; ((TextBox)infos.Children[4]).Text = picInfo[i].PipingInternalState; ((TextBox)infos.Children[5]).Text = picInfo[i].PictureRemark; ((TextBox)infos.Children[1]).Text = picInfo[i].DefectCode; ((TextBox)infos.Children[0]).Text = picInfo[i].Distance; remark.Text = picInfo[i].Remark; } }
//保存数据到数据库 private void Save(object sender, RoutedEventArgs e) { PipingDetailInfo detailInfo = new PipingDetailInfo(); string pipingID = pipingId ?? string.Format("{0}", DateTime.Now.ToString("yyyyMMddHHmmss")); List <PipingPictureInfo> pictInfoList = new List <PipingPictureInfo>(); PipingDetectionInfo detectionInfo = new PipingDetectionInfo(); // 加载图片信息 for (int i = 1; i <= pictureInfo.Children.Count; i++) { StackPanel infos = (StackPanel)((Grid)pictureInfo.Children[i - 1]).Children[2]; PipingPictureInfo pictInfo = new PipingPictureInfo(); pictInfo.PipingID = pipingID; pictInfo.PictureID = i.ToString(); pictInfo.Grade = ((TextBox)infos.Children[3]).Text.Trim(); pictInfo.Score = ((TextBox)infos.Children[2]).Text.Trim(); pictInfo.PipingInternalState = ((TextBox)infos.Children[4]).Text; pictInfo.PictureRemark = ((TextBox)infos.Children[5]).Text; pictInfo.PictureType = 1; pictInfo.DefectCode = ((TextBox)infos.Children[1]).Text; pictInfo.Distance = ((TextBox)infos.Children[0]).Text; pictInfo.Remark = remark.Text; pictInfo.PictureFilePath = imgList[i - 1]; pictInfo.IsDelete = 0; pictInfo.IsEnable = 1; pictInfo.AddPerson = MainWindow.loginUser.UserName; pictInfo.AddTime = System.DateTime.Now; pictInfo.KeyID = Guid.NewGuid().ToString("N"); pictInfoList.Add(pictInfo); } if (!string.IsNullOrEmpty(drawing.Text)) { // 工程图纸信息 PipingPictureInfo gcPictInfo = new PipingPictureInfo(); gcPictInfo.PictureID = string.Format("0"); gcPictInfo.PictureFilePath = drawing.Text; gcPictInfo.PictureRemark = "工程图纸"; gcPictInfo.AddPerson = MainWindow.loginUser.UserName; gcPictInfo.PipingID = pipingID; gcPictInfo.PictureType = 0; gcPictInfo.KeyID = Guid.NewGuid().ToString("N"); pictInfoList.Add(gcPictInfo); } // 管道检测信息 detectionInfo.PipingID = pipingID; detectionInfo.VideoFile = TextBox1.Text; detectionInfo.LayingYear = TextBox2.Text; detectionInfo.TubulationType = TextBox3.Text; detectionInfo.DetectionDirect = TextBox4.Text; detectionInfo.DetectionAddress = TextBox5.Text; detectionInfo.StartWellNo = TextBox6.Text; detectionInfo.StartPointDepth = TextBox7.Text; detectionInfo.TubulationMaterial = TextBox8.Text; detectionInfo.TubulationLength = TextBox9.Text; detectionInfo.DetectionFun = TextBox10.Text; detectionInfo.EndWellNo = TextBox11.Text; detectionInfo.EndPointDepth = TextBox12.Text; detectionInfo.TubulationDiameter = TextBox13.Text; detectionInfo.DetectionLength = TextBox14.Text; detectionInfo.DetectionTime = TextBox15.Text; detectionInfo.AddPerson = MainWindow.loginUser.UserName; detectionInfo.AddTime = System.DateTime.Now; detectionInfo.IsDelete = 0; detectionInfo.IsEnable = 1; detectionInfo.KeyID = Guid.NewGuid().ToString("N"); ResponseMessage result = new ResponseMessage(); if (null != pictInfoList.Find(p => !string.IsNullOrEmpty(p.PictureFilePath))) { foreach (var i in pictInfoList) { detailInfo.PipingPictureInfoes.Add(i); } } else { System.Windows.Forms.MessageBox.Show(string.Format("数据录入失败,数据格式错误!")); return; } detailInfo.PipingDetectionInfo = detectionInfo; result = service.AddOrModify(detailInfo); if (result.code == "0") { System.Windows.Forms.MessageBox.Show(string.Format("数据录入成功!")); this.Close(); } else { System.Windows.Forms.MessageBox.Show(string.Format("数据录入失败,数据格式错误!")); } }