/// <summary>
/// Soil图片入库
/// </summary>
/// <param name="list_picname"></param>
public static void InsertSoilPicture(string[] list_picname)
{
//string pic_date = list_picname[3].Substring(0, list_picname[3].IndexOf('.'));
byte[] buffer = Return_Buffer();
//string strSql2 = "insert into MONITOR_PICTURE(INDICATOR_NAME,NUTRIENT_CODE,CROP_CODE,MONITORTIME,PIC_MAP) values(@INDICATOR_NAME,@NUTRIENT_CODE,@CROP_CODE,@MONITORTIME,@PIC_MAP)";
SqlConnection con = DataBaseOperate.getSqlCon();
SqlCommand cmd = new SqlCommand("insert_SoilPicture", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@INDICATOR_NAME", list_picname[0]);
cmd.Parameters.AddWithValue("@CROP_CODE", DataBaseOperate.getCrop_Code(list_picname[1]));
cmd.Parameters.AddWithValue("@NUTRIENT_CODE", DataBaseOperate.getNUTRIENT_CODE(list_picname[2]));
cmd.Parameters.AddWithValue("@MONITORTIME", Convert.ToDateTime(list_picname[3]).ToShortDateString());
cmd.Parameters.AddWithValue("@PIC_MAP", buffer);
cmd.ExecuteNonQuery();
}
