public static List <string> getSixthName(string Fifthname) { string code = DataBaseOperate.getVillCode(Fifthname); string strsql = string.Format("SELECT FULLNAME FROM PLOT_DKINFO where JMZ='{0}'", code); return(ReturnMultiValue(strsql)); }
private void btn_Input_Click(object sender, EventArgs e) { int reslut = 0; for (int i = 0; i < dt.Rows.Count; i++) { string VillageCode = DataBaseOperate.getVillCode(dt.Rows[i][0].ToString()); DateTime MONITORTIME = Convert.ToDateTime(dt.Rows[i][1]); string CROP_CODE = DataBaseOperate.get_CropCode(dt.Rows[i][2].ToString()); string nutrient_code = DataBaseOperate.get_NutrientCode(dt.Rows[i][3].ToString()); float value = float.Parse(dt.Rows[i][4].ToString()); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@VILLAGECODE", VillageCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@NUTRIENT_CODE", nutrient_code), new SqlParameter("@SOIL_NUTRIENT", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToVillage.insert_Village_SOILNUTRIENT("insert_Village_SOILNUTRIENT", param); } if (reslut > 0) { MessageBox.Show("数据库入库成功!"); } }
public static DataTable getPlotSelectResult(string tablename, string cropName, DateTime date1, DateTime date2, string Villagename) { string cropcode = DataBaseOperate.get_CropCode(cropName); string Villagecode = DataBaseOperate.getVillCode(Villagename); string strsql = string.Format("select * from {0} where CROP_CODE='{1}' and MONITORTIME between '{2}' and '{3}' and PLOTID in (select PlotID from PLOT_DKINFO where JMZ='{4}')", tablename, cropcode, date1, date2, Villagecode); return(return_DataTable(strsql)); }
public Dictionary <string, string> return_Dicts(List <string> list_value) { Dictionary <string, string> dicts = new Dictionary <string, string>(); string column1 = ""; switch (rankname) { case "PLOT": column1 = DataBaseOperate.get_PlotCodeName(list_value[0]); break; case "COUNTY": column1 = DataBaseOperate.getCountyCode(list_value[0]); break; case "VILLAGE": column1 = DataBaseOperate.getVillCode(list_value[0]); break; case "TOWN": column1 = DataBaseOperate.getTownCode(list_value[0]); break; } dicts.Add(DataManager.get_TableEName(dataGridView1.Columns[0].Name), column1); dicts.Add(DataManager.get_TableEName(dataGridView1.Columns[1].Name), list_value[1]); dicts.Add(DataManager.get_TableEName(dataGridView1.Columns[2].Name), DataBaseOperate.get_CropCode(list_value[2])); if (tablename.Contains("SOILNUTRIENT")) { dicts.Add(DataManager.get_TableEName(dataGridView1.Columns[3].Name), DataBaseOperate.get_NutrientCode(list_value[3])); dicts.Add(DataManager.get_TableEName(dataGridView1.Columns[4].Name), list_value[4]); } else { dicts.Add(DataManager.get_TableEName(dataGridView1.Columns[3].Name), list_value[3]); } return(dicts); }
private void treeView2_AfterSelect(object sender, TreeViewEventArgs e) { rankCHname = e.Node.Text; if (rankCHname.EndsWith("农场")) { rankname = "COUNTY"; treeNodeEName = DataBaseOperate.getCountyCode(rankCHname); } else if (rankCHname.EndsWith("作业区")) { rankname = "TOWN"; treeNodeEName = DataBaseOperate.getTownCode(rankCHname); } else if (rankCHname.EndsWith("作业站")) { rankname = "VILLAGE"; treeNodeEName = DataBaseOperate.getVillCode(rankCHname); } else { rankname = "PLOT"; treeNodeEName = DataBaseOperate.get_PlotCodeName(rankCHname); } }
//数据库入库 private void btn_Input_Click(object sender, EventArgs e) { int reslut = 0; SqlParameter[] param = null; for (int i = 0; i < dt.Rows.Count; i++) { string VillageCode = DataBaseOperate.getVillCode(dt.Rows[i][0].ToString()); DateTime MONITORTIME = Convert.ToDateTime(dt.Rows[i][1]).Date; string CROP_CODE = DataBaseOperate.get_CropCode(dt.Rows[i][2].ToString()); float value = float.Parse(dt.Rows[i][3].ToString()); switch (lbl_tablename.Text) { case "WATERRETRIEVAL": param = new SqlParameter[] { new SqlParameter("@VILLAGECODE", VillageCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@WATERVALUE", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToVillage.insert_Village("insert_Village_WATERRETRIEVAL", param); break; case "CHLOROPHYLLRETRIEVAL": param = new SqlParameter[] { new SqlParameter("@VILLAGECODE", VillageCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@CHLOROPHYLLVALUE", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToVillage.insert_Village("insert_Village_CHLOROPHYLLRETRIEVAL", param); break; case "CROPYIELD": param = new SqlParameter[] { new SqlParameter("@VILLAGECODE", VillageCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@CROP_YIELD", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToVillage.insert_Village("insert_Village_CROPYIELD", param); break; case "MATUREPERIOD": param = new SqlParameter[] { new SqlParameter("@VILLAGECODE", VillageCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@MATURE_PERIOD", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToVillage.insert_Village("insert_Village_MATUREPERIOD", param); break; } } if (reslut > 0) { MessageBox.Show("数据库入库成功!"); } }