//转换表中的值 public static DataTable convert_TableValue(string rankname, string typename, DataTable dt) { for (int i = 0; i < dt.Rows.Count; i++) { switch (rankname) { case "PLOT": dt.Rows[i][0] = DataBaseOperate.get_PlotName(dt.Rows[i][0].ToString()); break; case "COUNTY": dt.Rows[i][0] = DataBaseOperate.getCountyName(dt.Rows[i][0].ToString()); break; case "VILLAGE": dt.Rows[i][0] = DataBaseOperate.getVillName(dt.Rows[i][0].ToString()); break; case "TOWN": dt.Rows[i][0] = DataBaseOperate.getTownName(dt.Rows[i][0].ToString()); break; } dt.Rows[i][2] = DataBaseOperate.get_CropCHName(dt.Rows[i][2].ToString()); if (!typename.Contains("SOILNUTRIENT")) { if (!string.IsNullOrEmpty(dt.Rows[i][3].ToString())) { dt.Rows[i][3] = Math.Round(Convert.ToDecimal(dt.Rows[i][3].ToString()), 3); } } else { dt.Rows[i][3] = DataBaseOperate.get_NutrientCHName(dt.Rows[i][3].ToString()); if (!string.IsNullOrEmpty(dt.Rows[i][4].ToString())) { dt.Rows[i][4] = Math.Round(Convert.ToDecimal(dt.Rows[i][4].ToString()), 3); } } } return(dt); }
private void btn_calculation_Click(object sender, EventArgs e) { int date_count = DataBaseOperate.get_DateCount(dT_maize_s.Value, dT_maize_e.Value, "SOILNUTRIENT_PLOT"); List <string> date_list = DataBaseOperate.get_DateDetail(dT_maize_s.Value, dT_maize_e.Value, "SOILNUTRIENT_PLOT"); int CropCount = DataBaseOperate.get_CropCount(); List <string> CropCode_list = DataBaseOperate.get_CropCode(); int nutrientCount = DataBaseOperate.get_NutrientCount(); List <string> nutrient_list = DataBaseOperate.get_NutrientCode(); //获取Countycount int Countycount = AggregateToCounty.getCountyCount(); //获取具体的CountyCode List <string> CountyCode_list = AggregateToCounty.get_CountyCode(); if (date_count != 0) { for (int i = 0; i < date_count; i++) //datetime循环 { for (int j = 0; j < Countycount; j++) //villagecode循环 { for (int k = 0; k < CropCount; k++) //crop_count循环 { for (int h = 0; h < nutrientCount; h++) { //输入查询限制条件,执行存储过程 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@time", Convert.ToDateTime(date_list[i])), new SqlParameter("@code", CropCode_list[k]), new SqlParameter("@countycode", CountyCode_list[j]), new SqlParameter("@nutrient_code", nutrient_list[h]), new SqlParameter("@sum_result", SqlDbType.Float) }; param[4].Direction = ParameterDirection.Output; string value = AggregateToCounty.get_SoilCountyValue("calc_county_SOILNUTRIENT", param); if (value != "") { DataRow row = dt.NewRow(); row["农场"] = DataBaseOperate.getCountyName(CountyCode_list[j]); row["监测时间"] = Convert.ToDateTime(date_list[i]).ToShortDateString(); row["作物类型"] = DataBaseOperate.get_CropCHName(CropCode_list[k]); row["养分类型"] = DataBaseOperate.get_NutrientCHName(nutrient_list[h]); row["汇总结果"] = float.Parse(value); row["汇总时间"] = DateTime.Now.ToShortDateString(); dt.Rows.Add(row); } } } } } if (dt.Rows.Count == 0) { MessageBox.Show("请检查输入条件或统计数据!"); } else { dataGridView1.DataSource = dt; } } else { MessageBox.Show("此时间段内,没有统计数据!"); } InitDataSet(); }
private void btn_calculation_Click(object sender, EventArgs e) { //开始汇总 int date_count = 0; List <string> date_list = null; switch (lbl_tablename.Text) { case "WATERRETRIEVAL": //处在选择的时间范围内的天数 date_count = DataBaseOperate.get_DateCount(dT_maize_s.Value, dT_maize_e.Value, "WATERRETRIEVAL_PLOT"); //获取具体的时间列表 date_list = DataBaseOperate.get_DateDetail(dT_maize_s.Value, dT_maize_e.Value, "WATERRETRIEVAL_PLOT"); break; case "CHLOROPHYLLRETRIEVAL": date_count = DataBaseOperate.get_DateCount(dT_maize_s.Value, dT_maize_e.Value, "CHLOROPHYLLRETRIEVAL_PLOT"); //获取具体的时间列表 date_list = DataBaseOperate.get_DateDetail(dT_maize_s.Value, dT_maize_e.Value, "CHLOROPHYLLRETRIEVAL_PLOT"); break; case "CROPYIELD": date_count = DataBaseOperate.get_DateCount(dT_maize_s.Value, dT_maize_e.Value, "CROPYIELD_PLOT"); //获取具体的时间列表 date_list = DataBaseOperate.get_DateDetail(dT_maize_s.Value, dT_maize_e.Value, "CROPYIELD_PLOT"); break; case "MATUREPERIOD": date_count = DataBaseOperate.get_DateCount(dT_maize_s.Value, dT_maize_e.Value, "MATUREPERIOD_PLOT"); //获取具体的时间列表 date_list = DataBaseOperate.get_DateDetail(dT_maize_s.Value, dT_maize_e.Value, "MATUREPERIOD_PLOT"); break; } //获取Countycount int Countycount = AggregateToCounty.getCountyCount(); //获取具体的CountyCode List <string> CountyCode_list = AggregateToCounty.get_CountyCode(); //获取CropCount int CropCount = DataBaseOperate.get_CropCount(); //获取具体的CropCode List <string> CropCode_list = DataBaseOperate.get_CropCode(); //开始汇总 if (date_count != 0) { for (int i = 0; i < date_count; i++) //datetime循环 { for (int j = 0; j < Countycount; j++) //villagecode循环 { for (int k = 0; k < CropCount; k++) //crop_count循环 { //输入查询限制条件,执行存储过程 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@time", Convert.ToDateTime(date_list[i])), new SqlParameter("@code", CropCode_list[k]), new SqlParameter("@countycode", CountyCode_list[j]), new SqlParameter("@sum_result", SqlDbType.Float) }; param[3].Direction = ParameterDirection.Output; string value = ""; switch (lbl_tablename.Text) { //计算汇总结果,并加入到datatable中 case "WATERRETRIEVAL": value = AggregateToCounty.get_CountyValue("calc_county_WATERRETRIEVAL", param); break; case "CHLOROPHYLLRETRIEVAL": value = AggregateToCounty.get_CountyValue("calc_county_CHLOROPHYLLRETRIEVAL", param); break; case "CROPYIELD": value = AggregateToCounty.get_CountyValue("calc_county_CROPYIELD", param); break; case "MATUREPERIOD": value = AggregateToCounty.get_CountyValue("calc_county_MATUREPERIOD", param); break; } if (value != "") { DataRow row = dt.NewRow(); row["农场"] = DataBaseOperate.getCountyName(CountyCode_list[j]); row["监测时间"] = Convert.ToDateTime(date_list[i]).ToShortDateString(); row["作物类型"] = DataBaseOperate.get_CropCHName(CropCode_list[k]); row["汇总结果"] = float.Parse(value); row["汇总时间"] = DateTime.Now.ToShortDateString(); dt.Rows.Add(row); } } } } if (dt.Rows.Count == 0) { MessageBox.Show("请检查输入条件或统计数据!"); } else { dataGridView1.DataSource = dt; } } else { MessageBox.Show("此时间段内,没有统计数据!"); } InitDataSet(); }