private void btn_InDatabase_Click(object sender, EventArgs e) { int result = 0; string sVI_TYPE = this.cbx_VIType.Text.Trim(); string sVI_STATYPE = this.cbx_StaValueType.Text.Trim(); float fVI = 0.00f; for (int i = 1; i < dtInfo.Rows.Count - 1; i++) { string str = dtInfo.Rows[i][5].ToString(); bool b = float.TryParse(str, out fVI); if (!b || str.Contains("正")) { str = "0.00"; } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PLOTID", dtInfo.Rows[i]["地块编号"]), new SqlParameter("@MONITORTIME", dtInfo.Rows[i]["监测时间"]), new SqlParameter("@CROP_CODE", 10), new SqlParameter("@VI_TYPE", sVI_TYPE), new SqlParameter("@VI_STATYPE", sVI_STATYPE), new SqlParameter("@VI_VALUE", str), new SqlParameter("@SENSORTYPE", 1), new SqlParameter("@RECORDTIME", DateTime.Now) }; result = DataBaseOperate.InsertDatabase("insert_Plot_VI", param); } if (result > 0) { MessageBox.Show("入库成功!"); } }
private void btn_InDatabase_Click(object sender, EventArgs e) { int result = 0; string code2 = DataBaseOperate.getNUTRIENT_CODE(res[2]);//获取NUTRIENT_CODE string crop_code = DataBaseOperate.getCrop_Code(res[1]); for (int i = 1; i < dtInfo.Rows.Count - 1; i++) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PLOTID", dtInfo.Rows[i]["地块编号"]), new SqlParameter("@MONITORTIME", dtInfo.Rows[i]["监测时间"]), new SqlParameter("@CROP_CODE", crop_code), new SqlParameter("@NUTRIENT_CODE", code2), new SqlParameter("@SOIL_NUTRIENT", dtInfo.Rows[i][5]), new SqlParameter("@RECORDTIME", DateTime.Now) }; result = DataBaseOperate.InsertDatabase("insert_Plot_SOILNUTRIENT", param); } if (result > 0) { MessageBox.Show("入库成功!"); } }
private void btn_InDatabase_Click(object sender, EventArgs e) { //判断入库的结果 int result = 0; //判断入库到那个表当中 switch (res[0]) { case "CROPYIELD": string code1 = DataBaseOperate.getCrop_Code(res[1]); //获取crop_Code for (int i = 1; i < dtInfo.Rows.Count - 1; i++) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PLOTID", dtInfo.Rows[i]["地块编号"]), new SqlParameter("@MONITORTIME", dtInfo.Rows[i]["监测时间"]), new SqlParameter("@CROP_CODE", code1), new SqlParameter("@CROP_YIELD", dtInfo.Rows[i][5]), new SqlParameter("@RECORDTIME", DateTime.Now) }; result = DataBaseOperate.InsertDatabase("insert_Plot_CROPYIELD", param); } if (result > 0) { MessageBox.Show("入库成功!"); } break; case "MATUREPERIOD": string code3 = DataBaseOperate.getCrop_Code(res[1]); //获取crop_Code for (int i = 1; i < dtInfo.Rows.Count - 1; i++) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PLOTID", dtInfo.Rows[i]["地块编号"]), new SqlParameter("@MONITORTIME", dtInfo.Rows[i]["监测时间"]), new SqlParameter("@CROP_CODE", code3), new SqlParameter("@MATURE_PERIOD", dtInfo.Rows[i][5]), new SqlParameter("@RECORDTIME", DateTime.Now) }; result = DataBaseOperate.InsertDatabase("insert_Plot_MATUREPERIOD", param); } if (result > 0) { MessageBox.Show("入库成功!"); } break; case "WATERRETRIEVAL": string code4 = DataBaseOperate.getCrop_Code(res[1]); //获取crop_Code for (int i = 1; i < dtInfo.Rows.Count - 1; i++) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PLOTID", dtInfo.Rows[i]["地块编号"]), new SqlParameter("@MONITORTIME", dtInfo.Rows[i]["监测时间"]), new SqlParameter("@CROP_CODE", code4), new SqlParameter("@WATERVALUE", dtInfo.Rows[i][5]), new SqlParameter("@RECORDTIME", DateTime.Now) }; result = DataBaseOperate.InsertDatabase("insert_Plot_WATERRETRIEVAL", param); } if (result > 0) { MessageBox.Show("入库成功!"); } break; case "CHLOROPHYLLRETRIEVAL": string code5 = DataBaseOperate.getCrop_Code(res[1]); //获取crop_Code for (int i = 1; i < dtInfo.Rows.Count - 1; i++) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PLOTID", dtInfo.Rows[i]["地块编号"]), new SqlParameter("@MONITORTIME", dtInfo.Rows[i]["监测时间"]), new SqlParameter("@CROP_CODE", code5), new SqlParameter("@CHLOROPHYLLVALUE", dtInfo.Rows[i][5]), new SqlParameter("@RECORDTIME", DateTime.Now) }; result = DataBaseOperate.InsertDatabase("insert_Plot_CHLOROPHYLLRETRIEVAL", param); } if (result > 0) { MessageBox.Show("入库成功!"); } break; } }