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("数据库入库成功！");
}
}
