/// <summary> /// 查询钻孔编号列表,输出为Borehole类形式 /// </summary> /// <param name="_projectName">项目名称</param> /// <returns></returns> public static List <Borehole> ReadZkListAsClass(string _projectName) { // 创建连接到设置信息数据库 string sql = "Data Source=" + Program.ReadProgramPath() + "\\" + _projectName + ".gsygeo"; using (SQLiteConnection conn = new SQLiteConnection(sql)) { // 打开连接 conn.Open(); // 新建要返回的类列表 List <Borehole> zklist = new List <Borehole>(); // 循环读取钻孔数据 sql = "select * from zkBasicInfo order by name"; SQLiteDataReader reader = new SQLiteCommand(sql, conn).ExecuteReader(); while (reader.Read()) { Borehole zk = new Borehole(reader["name"].ToString(), Convert.ToDouble(reader["altitude"])); zk.X = Convert.ToDouble(reader["xAxis"]); zk.Y = Convert.ToDouble(reader["yAxis"]); zk.InitialWaterLevel = Convert.ToDouble(reader["initialWaterLevel"]); zk.StableWaterLevel = Convert.ToDouble(reader["stableWaterLevel"]); zk.Layers = BoreholeDataBase.ReadZkLayer(_projectName, reader["name"].ToString()); zk.Samples = BoreholeDataBase.ReadZkSample(_projectName, reader["name"].ToString()); zk.NTests = BoreholeDataBase.ReadZkNTest(_projectName, reader["name"].ToString()); zklist.Add(zk); } // 返回 return(zklist); } }
// TreeView选择节点变化时激活不同的内容控件 private void ProjectTreeView_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e) { // 读取选中节点 TreeViewItem selectedItem = (TreeViewItem)e.NewValue; // 根据选中状况清空窗口中的控件 if (selectedItem == null) { this.ContectGrid.Children.Clear(); return; } if (selectedItem.Header.ToString() != "基本信息" && selectedItem.Parent != null) { this.ContectGrid.Children.Clear(); } // 选中一级节点时 // 选中"基本信息" if (selectedItem.Header.ToString() == "基本信息") { ProjectBasicInfo prjb = new ProjectBasicInfo(); this.ContectGrid.Children.Add(prjb); } // 选中二级、三级节点时 if (selectedItem.Parent != null) { // 读取父节点 TreeViewItem parentItem = (TreeViewItem)selectedItem.Parent; // 选中"钻孔"子节点 if (parentItem.Header.ToString() == "钻孔") { // 读取当前所选钻孔名称 string prj = Program.currentProject; string zkName = selectedItem.Header.ToString(); // 实例化一个Borehole类,并将当前所选钻孔的数据库信息赋值给此实例 Borehole bh = new Borehole(zkName, BoreholeDataBase.ReadAltitude(prj, zkName)); bh.X = BoreholeDataBase.ReadXAxis(prj, zkName); bh.Y = BoreholeDataBase.ReadYAxis(prj, zkName); bh.InitialWaterLevel = BoreholeDataBase.ReadInitialWaterLevel(prj, zkName); bh.StableWaterLevel = BoreholeDataBase.ReadStableWaterLevel(prj, zkName); bh.Layers = BoreholeDataBase.ReadZkLayer(prj, zkName); bh.Samples = BoreholeDataBase.ReadZkSample(prj, zkName); bh.NTests = BoreholeDataBase.ReadZkNTest(prj, zkName); // 实例化BoreholeControl用户控件,并赋值 BoreholeControl bhc = new BoreholeControl(bh); this.ContectGrid.Children.Add(bhc); } // 选取"原位测试"-"静力触探"子节点 if (parentItem.Header.ToString() == "静力触探") { // 读取当前所选触探孔名称 string prj = Program.currentProject; string jkName = selectedItem.Header.ToString(); // 实例化一个CPT类,并将当前所选触探孔的数据库信息赋值给此实例 CPT cpt = new CPT(jkName, CPTDataBase.ReadAltitude(prj, jkName)); cpt.X = CPTDataBase.ReadXAxis(prj, jkName); cpt.Y = CPTDataBase.ReadYAxis(prj, jkName); cpt.Layers = CPTDataBase.ReadJkLayer(prj, jkName); cpt.PsList = CPTDataBase.ReadJkPs(prj, jkName); // 实例化CPTControl用户控件,并赋值 CPTControl cptc = new CPTControl(cpt); this.ContectGrid.Children.Add(cptc); } // 选取"室内试验"-"土工常规"子节点 if (selectedItem.Header.ToString() == "土工常规") { // 实例化一个RoutineSoilTest类列表,并读取数据库信息赋值给此实例 List <RoutineSoilTest> rsts = RoutineSoilTestDataBase.ReadAllData(Program.currentProject); // 实例化RoutineSoilTestControl用户控件,并赋值 RoutineSoilTestControl rstc = new RoutineSoilTestControl(rsts); this.ContectGrid.Children.Add(rstc); } // 选取"室内试验"-"颗粒分析"子节点 if (selectedItem.Header.ToString() == "颗粒分析") { // 实例化一个RoutineSoilTest类列表,并读取数据库信息赋值给此实例 List <GrainAnalysisTest> gats = GrainAnalysisTestDataBase.ReadAllData(Program.currentProject); // 实例化RoutineSoilTestControl用户控件,并赋值 GrainAnalysisTestControl gatc = new GrainAnalysisTestControl(gats); this.ContectGrid.Children.Add(gatc); } } }
/// <summary> /// 方法,绘制单个钻孔柱状图 /// </summary> /// <param name="_drawIndex">柱状图编号,从0开始,用于绘制多个柱状图时计算其摆放位置</param> /// <param name="_projectName">工程名称</param> /// <param name="_companyName">公司名称</param> /// <param name="_zk">钻孔数据</param> /// <param name="_scaleList">比例尺列表</param> /// <param name="_style1">钻孔柱状图的文字样式</param> /// <param name="_style2">剖面图钻孔的文字样式</param> public void DrawZk(int _drawIndex, string _projectName, string[] _company, Borehole _zk, List <double> _scaleList, DxfTextStyle _style1, DxfTextStyle _style2) { // 当钻孔内没有分层时退出 if (_zk.Layers.Count == 0) { return; } // 计算图形横向偏移量,用于绘制多个柱状图时的空间摆放距离 double xDis = _drawIndex * 195; // 绘制钻孔柱状图框架 AddRectangle(0 + xDis, 0, 195 + xDis, 280); AddRectangle(10 + xDis, 20, 185 + xDis, 261); Model.Entities[Model.Entities.Count - 1].LineWeight = 30; double[,] pointKJ = new double[25, 4] { { 10, 254, 185, 254 }, { 10, 247, 57, 247 }, { 63, 247, 185, 247 }, { 10, 240, 185, 240 }, { 10, 220, 185, 220 }, { 131.5, 233, 185, 233 }, { 132.5, 225, 150.5, 225 }, { 152.5, 225, 170.5, 225 }, { 172.5, 225, 184, 225 }, { 30, 261, 30, 240 }, { 57, 254, 57, 240 }, { 63, 254, 63, 240 }, { 90, 261, 90, 240 }, { 110, 261, 110, 240 }, { 137, 254, 137, 240 }, { 157, 254, 157, 240 }, { 22, 240, 22, 20 }, { 30, 240, 30, 20 }, { 42, 240, 42, 20 }, { 52, 240, 52, 20 }, { 62, 240, 62, 20 }, { 77, 240, 77, 20 }, { 131.5, 240, 131.5, 20 }, { 151.5, 240, 151.5, 20 }, { 171.5, 240, 171.5, 20 } }; for (int i = 0; i < 25; i++) { AddLine(pointKJ[i, 0] + xDis, pointKJ[i, 1], pointKJ[i, 2] + xDis, pointKJ[i, 3]); } string[] textKJ = new string[31] { "工程名称", "钻孔编号", "孔口高程", "勘察单位", "钻孔深度", "钻孔日期", "初见水位", "稳定水位", "地\n质\n年\n代", "及\n成\n因", "层\n \n序", "层\n底\n标\n高\n(m)", "层\n底\n深\n度\n(m)", "分\n层\n厚\n度\n(m)", "岩 土 描 述", "标贯/动探", "取 样", "注水试验", "击 数", "深 度(m)", "编 号", "深 度(m)", "渗透系数\n(cm/s)", "深度(m)", "钻 孔 柱 状 图", "制图:", "校核:", "审查:", "核定:", "X:", "Y:" }; double[,] ptextKJ = new double[31, 3] { { 20, 257.5, 20 }, { 20, 250.5, 20 }, { 20, 243.5, 20 }, { 100, 257.5, 20 }, { 100, 250.5, 20 }, { 100, 243.5, 20 }, { 147, 250.5, 20 }, { 147, 243.5, 20 }, { 13, 230, 6 }, { 19, 230, 6 }, { 26, 230, 8 }, { 36, 230, 12 }, { 47, 230, 10 }, { 57, 230, 10 }, { 104.25, 230, 54.5 }, { 141.5, 236.5, 20 }, { 161.5, 236.5, 20 }, { 178.25, 236.5, 13.5 }, { 141.5, 229, 20 }, { 141.5, 222.5, 20 }, { 161.5, 229, 20 }, { 161.5, 222.5, 20 }, { 178.25, 229, 13.5 }, { 178.25, 222.5, 13.5 }, { 97.5, 270, 31 }, { 32, 13, 10 }, { 70, 13, 10 }, { 106, 13, 10 }, { 144, 13, 10 }, { 65.5, 252, 5 }, { 65.5, 245, 5 } }; for (int i = 0; i < textKJ.Length; i++) { DxfMText t = AddMText(textKJ[i], ptextKJ[i, 0] + xDis, ptextKJ[i, 1], ptextKJ[i, 2], 2.5, _style1); if (i == 11 || i == 12 || i == 13 || i == 22) { t.LineSpacingFactor = 0.8; } } // 绘制表头信息 AddMText(_projectName, 60 + xDis, 257.5, 60, 2.5, _style1); AddMText(_zk.Name, 43.5 + xDis, 250.5, 27, 2.5, _style1); AddMText(_zk.Altitude.ToString("0.00") + " m", 43.5 + xDis, 243.5, 27, 2.5, _style1); AddMText(_company[0], 147.5 + xDis, 257.5, 75, 2.5, _style1); AddMText(_zk.Layers[_zk.Layers.Count - 1].Depth.ToString("0.00") + " m", 123.5 + xDis, 250.5, 27, 2.5, _style1); // 计算比例尺 double scale; if (_zk.Layers[_zk.Layers.Count - 1].Depth <= 20) { scale = 100; } else if (_zk.Layers[_zk.Layers.Count - 1].Depth <= 40) { scale = 200; } else if (_zk.Layers[_zk.Layers.Count - 1].Depth <= 100) { scale = 500; } else { scale = 1000; } AddMText("柱\n状\n图\n1:" + scale, 69.5 + xDis, 230, 12, 2.5, _style1); // 绘制分层 for (int i = 0; i < _zk.Layers.Count; i++) { // 分层线及深度标签 double drawY = 220 - _zk.Layers[i].Depth / scale * 1000; AddLine(10 + xDis, drawY, 131.5 + xDis, drawY); AddMText(_zk.Layers[i].Number, 26 + xDis, drawY + 3, 8, 2.5, _style1); AddMText((_zk.Altitude - _zk.Layers[i].Depth).ToString("0.00"), 36 + xDis, drawY + 3, 8, 2.5, _style1); AddMText(_zk.Layers[i].Depth.ToString("0.00"), 47 + xDis, drawY + 3, 8, 2.5, _style1); if (i > 0) { AddMText((_zk.Layers[i].Depth - _zk.Layers[i - 1].Depth).ToString("0.00"), 57 + xDis, drawY + 3, 8, 2.5, _style1); } else { AddMText(_zk.Layers[i].Depth.ToString("0.00"), 57 + xDis, drawY + 3, 8, 2.5, _style1); } // 地质填充 double hatchY1 = drawY; double hatchY2; if (i > 0) { hatchY2 = 220 - _zk.Layers[i - 1].Depth / scale * 1000; } else { hatchY2 = 220; } try { string s = _zk.Layers[i].Name; if (s.Contains("黏")) { s = s.Replace("黏", "粘"); } AddRecHatch(HatchTrans(s), 62 + xDis, hatchY1, 77 + xDis, hatchY2); } catch { AddRecHatch("SOLID", 62 + xDis, hatchY1, 77 + xDis, hatchY2); } // 岩土描述 double presY = hatchY2 - 0.7; DxfMText t = AddMText(_zk.Layers[i].Name + ":" + _zk.Layers[i].Description, 78 + xDis, presY, 54.5, 1.5, _style1); t.AttachmentPoint = AttachmentPoint.TopLeft; } // 绘制标贯/动探 for (int i = 0; i < _zk.NTests.Count; i++) { double drawY = 220 - _zk.NTests[i].Depth / scale * 1000; AddLine(131.5 + xDis, drawY, 151.5 + xDis, drawY); AddMText(_zk.NTests[i].Value.ToString("0"), 141.5 + xDis, drawY + 2, 20, 2.5, _style1); AddMText(_zk.NTests[i].Depth.ToString("0.00"), 141.5 + xDis, drawY - 2, 20, 2.5, _style1); } // 绘制取样 for (int i = 0; i < _zk.Samples.Count; i++) { double drawY = 220 - _zk.Samples[i].Depth * 1000 / scale; AddLine(151.5 + xDis, drawY, 171.5 + xDis, drawY); AddMText(_zk.Samples[i].Name, 161.5 + xDis, drawY + 2, 20, 2.5, _style1); AddMText(_zk.Samples[i].Depth.ToString("0.00"), 161.5 + xDis, drawY - 2, 20, 2.5, _style1); } // 绘制人员信息 AddMText(_company[2], 44 + xDis, 13, 10, 2.5, _style1); AddMText(_company[4], 82 + xDis, 13, 10, 2.5, _style1); AddMText(_company[5], 118 + xDis, 13, 10, 2.5, _style1); AddMText(_company[6], 156 + xDis, 13, 10, 2.5, _style1); // 绘制剖面图钻孔 double distanceY = 280; for (int i = 0; i < _scaleList.Count; i++) { // 计算绘图起始位置 distanceY = distanceY + 40 + _zk.Layers[_zk.Layers.Count - 1].Depth * 1000 / _scaleList[i]; // 绘制钻孔编号、孔口高程、钻孔轴线 AddLine(124 + xDis, distanceY + 10, 136 + xDis, distanceY + 10); AddMText(_zk.Name, 130 + xDis, distanceY + 13.5, 12, 4, _style2); AddMText(_zk.Altitude.ToString("0.00"), 130 + xDis, distanceY + 7, 12, 4, _style2); DxfPolyline2D l = AddLine(130 + xDis, distanceY, 130 + xDis, distanceY - _zk.Layers[_zk.Layers.Count - 1].Depth * 1000 / _scaleList[i]); l.LineWeight = 50; // 绘制分层 for (int j = 0; j < _zk.Layers.Count; j++) { double layerY = distanceY - _zk.Layers[j].Depth * 1000 / _scaleList[i]; double layerYold = distanceY; if (j > 0) { layerYold = distanceY - _zk.Layers[j - 1].Depth * 1000 / _scaleList[i]; } if (j < _zk.Layers.Count - 1) { AddLine(120 + xDis, layerY, 130 + xDis, layerY); } DxfMText text = AddMText(_zk.Layers[j].Depth.ToString("0.00") + "(" + (_zk.Altitude - _zk.Layers[j].Depth).ToString("0.00") + ")", 132 + xDis, layerY, 25, 3, _style2); text.AttachmentPoint = AttachmentPoint.MiddleLeft; try { string s = _zk.Layers[j].Name; if (s.Contains("黏")) { s = s.Replace("黏", "粘"); } AddRecHatch(HatchTrans(s), 120 + xDis, layerY, 130 + xDis, layerYold); } catch { AddRecHatch("SOLID", 120 + xDis, layerY, 130 + xDis, layerYold); } } // 绘制取样 for (int j = 0; j < _zk.Samples.Count; j++) { double sampleY = distanceY - _zk.Samples[j].Depth * 1000 / _scaleList[i]; if (_zk.Samples[j].IsDisturbed) { AddCircle(127.5 + xDis, sampleY, 1, false); } else { AddCircle(127.5 + xDis, sampleY, 1, true); } } // 绘制标贯/动探 for (int j = 0; j < _zk.NTests.Count; j++) { double bgY = distanceY - _zk.NTests[j].Depth * 1000 / _scaleList[i]; DxfMText text = AddMText(_zk.NTests[j].Type.ToString() + "=" + _zk.NTests[j].Value, 120.5 + xDis, bgY, 6, 2.5, _style2); text.AttachmentPoint = AttachmentPoint.MiddleLeft; } // 绘制比例尺标记 double scY = distanceY - _zk.Layers[_zk.Layers.Count - 1].Depth * 1000 / _scaleList[i] / 2; DxfMText t = AddMText("1:" + _scaleList[i], 20 + xDis, scY, 80, 20, _style2); t.AttachmentPoint = AttachmentPoint.MiddleLeft; } }
/// <summary> /// 带参数的构造函数,选取某钻孔时调用 /// </summary> /// <param name="_selectedZk">所选钻孔</param> public BoreholeControl(Borehole _selectedZk) { InitializeComponent(); // 设置当前为旧钻孔,设置删除按钮可用性 this.DeleteZkButton.IsEnabled = true; isNewZk = false; oldZkName = _selectedZk.Name; // 初始化DataTable InitialLayerListDataTable(); InitialSampleListDataTable(); InitialNTestListDataTable(); // 定义各输入框的工具提示 DefineToolTip(); // 设置绑定 this.LayerListDataGrid.DataContext = dtLayer; this.SampleListDataGrid.DataContext = dtSample; this.NTestListDataGrid.DataContext = dtNTest; // 赋值基本信息 this.ZKNameTextBox.Text = _selectedZk.Name; this.ZKAltitudeTextBox.Text = _selectedZk.Altitude.ToString(); this.AxisXTextBox.Text = _selectedZk.X.ToString() != "-0.19880205" ? _selectedZk.X.ToString() : null; this.AxisYTextBox.Text = _selectedZk.Y.ToString() != "-0.19880205" ? _selectedZk.Y.ToString() : null; this.InitialWaterLevelTextBox.Text = _selectedZk.InitialWaterLevel.ToString() != "-0.19880205" ? _selectedZk.InitialWaterLevel.ToString() : null; this.StableWaterLevelTextBox.Text = _selectedZk.StableWaterLevel.ToString() != "-0.19880205" ? _selectedZk.StableWaterLevel.ToString() : null; // 赋值分层列表 for (int i = 0; i < _selectedZk.Layers.Count; i++) { string number = _selectedZk.Layers[i].Number; string name = _selectedZk.Layers[i].Name; string geo = _selectedZk.Layers[i].Geo; string description = _selectedZk.Layers[i].Description; double depth = _selectedZk.Layers[i].Depth; AddRowToLayerListDataTable(number, name, geo, depth, description); } // 赋值取样列表 for (int i = 0; i < _selectedZk.Samples.Count; i++) { string name = _selectedZk.Samples[i].Name; double depth = _selectedZk.Samples[i].Depth; bool isDisturbed = _selectedZk.Samples[i].IsDisturbed; AddRowToSampleListDataTable(name, depth, isDisturbed); } // 赋值标贯/动探列表 for (int i = 0; i < _selectedZk.NTests.Count; i++) { string name = _selectedZk.NTests[i].Name; double depth = _selectedZk.NTests[i].Depth; double value = _selectedZk.NTests[i].Value; ZkNTest.ntype type = _selectedZk.NTests[i].Type; AddRowToNTestListDataTable(name, depth, value, type); } // 更新状态标签 this.IsChangedTextBlock.Text = ""; // 绘图 DrawZk(); }