private void btn_Input_Click(object sender, EventArgs e) { int reslut = 0; for (int i = 0; i < dt.Rows.Count; i++) { string TownCode = DataBaseOperate.getTownCode(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("@TOWNCODE", TownCode), 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 = AggregateToTown.insert_Town_SOILNUTRIENT("insert_town_SOILNUTRIENT", param); } if (reslut > 0) { MessageBox.Show("数据库入库成功!"); } }
public static DataTable getVillageSelectResult(string tablename, string cropName, DateTime date1, DateTime date2, string townname) { string cropcode = DataBaseOperate.get_CropCode(cropName); string towncode = DataBaseOperate.getTownCode(townname); string strsql = string.Format("select * from {0} where CROP_CODE='{1}' and MONITORTIME between '{2}' and '{3}' and VILLAGECODE in (select VillCode from VILLAGE where TowCode='{4}')", tablename, cropcode, date1, date2, towncode); 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 TownCode = DataBaseOperate.getTownCode(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("@TOWNCODE", TownCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@WATERVALUE", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToTown.insert_Town("insert_Town_WATERRETRIEVAL", param); break; case "CHLOROPHYLLRETRIEVAL": param = new SqlParameter[] { new SqlParameter("@TOWNCODE", TownCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@CHLOROPHYLLVALUE", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToTown.insert_Town("insert_Town_CHLOROPHYLLRETRIEVAL", param); break; case "CROPYIELD": param = new SqlParameter[] { new SqlParameter("@TOWNCODE", TownCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@CROP_YIELD", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToTown.insert_Town("insert_Town_CROPYIELD", param); break; case "MATUREPERIOD": param = new SqlParameter[] { new SqlParameter("@TOWNCODE", TownCode), new SqlParameter("@MONITORTIME", MONITORTIME), new SqlParameter("@CROP_CODE", CROP_CODE), new SqlParameter("@MATURE_PERIOD", value), new SqlParameter("@RECORDTIME", DateTime.Now.ToShortDateString()) }; reslut = AggregateToTown.insert_Town("insert_Town_MATUREPERIOD", param); break; } } if (reslut > 0) { MessageBox.Show("数据库入库成功!"); } }