/// <summary> /// 筛选数据函数 /// </summary> /// <param name="_zk">钻孔编号</param> /// <param name="_layer">分层编号</param> private void SelectData(string _zk, string _layer) { if (_zk == "全部钻孔") { _zk = ""; } if (_layer == "全部分层") { _layer = ""; } if (_layer != "") { _layer = _layer.Substring(0, _layer.IndexOf(" ")); } List <RoutineSoilTest> rsts = RoutineSoilTestDataBase.SelectByZkAndLayer(Program.currentProject, _zk, _layer); RefreshTestDataListDataGrid(rsts); }
/// <summary> /// 筛选统计数据 /// </summary> /// <returns></returns> public static List <StatisticRST> SelectStatisticData() { // 定义统计数据列表 List <StatisticRST> statisticList = new List <StatisticRST>(); // 定义分层编号列表、分层岩土名称列表、试验类型列表 List <string> layerNumberList = ProjectDataBase.ReadLayerNumberList(Program.currentProject); List <string> layerNameList = ProjectDataBase.ReadLayerNameList(Program.currentProject); // 在分层编号列表中循环,赋值统计数据列表 for (int i = 0; i < layerNumberList.Count; i++) { // 层号、岩土名称 string layerNumber = layerNumberList[i]; string layerName = layerNameList[i]; // 读取分层试验数据 List <RoutineSoilTest> rsts = RoutineSoilTestDataBase.SelectByZkAndLayer(Program.currentProject, "", layerNumber); List <double> datalist_waterLevel = new List <double>(); List <double> datalist_density = new List <double>(); List <double> datalist_specificGravity = new List <double>(); List <double> datalist_voidRatio = new List <double>(); List <double> datalist_saturation = new List <double>(); List <double> datalist_liquidLimit = new List <double>(); List <double> datalist_plasticLimit = new List <double>(); List <double> datalist_plasticIndex = new List <double>(); List <double> datalist_liquidityIndex = new List <double>(); List <double> datalist_compressibility = new List <double>(); List <double> datalist_modulus = new List <double>(); List <double> datalist_frictionAngle = new List <double>(); List <double> datalist_cohesion = new List <double>(); List <double> datalist_permeability = new List <double>(); for (int j = 0; j < rsts.Count; j++) { datalist_waterLevel.Add(rsts[j].waterLevel); datalist_density.Add(rsts[j].density); datalist_specificGravity.Add(rsts[j].specificGravity); datalist_voidRatio.Add(rsts[j].voidRatio); datalist_saturation.Add(rsts[j].saturation); datalist_liquidLimit.Add(rsts[j].liquidLimit); datalist_plasticLimit.Add(rsts[j].plasticLimit); datalist_plasticIndex.Add(rsts[j].plasticIndex); datalist_liquidityIndex.Add(rsts[j].liquidityIndex); datalist_compressibility.Add(rsts[j].compressibility); datalist_modulus.Add(rsts[j].modulus); datalist_frictionAngle.Add(rsts[j].frictionAngle); datalist_cohesion.Add(rsts[j].cohesion); datalist_permeability.Add(rsts[j].permeability); } // 赋值统计数据列表 statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[0], datalist_waterLevel, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[1], datalist_density, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[2], datalist_specificGravity, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[3], datalist_voidRatio, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[4], datalist_saturation, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[5], datalist_liquidLimit, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[6], datalist_plasticLimit, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[7], datalist_plasticIndex, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[8], datalist_liquidityIndex, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[9], datalist_compressibility, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[10], datalist_modulus, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[11], datalist_frictionAngle, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[12], datalist_cohesion, 6)); statisticList.Add(new StatisticRST(layerNumber, layerName, typeList[13], datalist_permeability, 6)); } // 返回 return(statisticList); }