private void btnConnectMySQL_Click(object sender, RoutedEventArgs e)
 {
     foreach(DataRow row in dt.Rows) {
         Data data = new Data();
         data.Name = row[1].ToString();
         data.Acceptance = row[2].ToString();
         data.Record = row[3].ToString();
         data.TotalArea = double.Parse(row[4].ToString());
         data.Amount = decimal.Parse(row[6].ToString());
         data.PaddyArea = double.Parse(row[7].ToString());
         data.DryArea = data.TotalArea - data.PaddyArea;
         DataOperator.InsertData(data);
     }
     MessageBox.Show("上传完成");
 }
 public static bool InsertData(Data data)
 {
     StringBuilder sqlInsert = new StringBuilder();
     sqlInsert.Append("insert into ");
     sqlInsert.Append(Constant.TABLE);
     sqlInsert.Append(" (");
     sqlInsert.Append("`LandDevelopmentProject`.`GUID`,");
     sqlInsert.Append("`LandDevelopmentProject`.`NAME`,");
     sqlInsert.Append("`LandDevelopmentProject`.`RECORD`,");
     sqlInsert.Append("`LandDevelopmentProject`.`ACCEPTANCE`,");
     sqlInsert.Append("`LandDevelopmentProject`.`AMOUNT`,");
     sqlInsert.Append("`LandDevelopmentProject`.`TOTALAREA`,");
     sqlInsert.Append("`LandDevelopmentProject`.`PADDYAREA`,");
     sqlInsert.Append("`LandDevelopmentProject`.`DRYAREA`");
     sqlInsert.Append(") values (");
     sqlInsert.Append("@GUID,");
     sqlInsert.Append("@NAME,");
     sqlInsert.Append("@RECORD,");
     sqlInsert.Append("@ACCEPTANCE,");
     sqlInsert.Append("@AMOUNT,");
     sqlInsert.Append("@TOTALAREA,");
     sqlInsert.Append("@PADDYAREA,");
     sqlInsert.Append("@DRYAREA)");
     MySqlParameter[] pt = new MySqlParameter[]            {
         new MySqlParameter("@GUID",data.Guid),
         new MySqlParameter("@NAME", data.Name),
         new MySqlParameter("@RECORD", data.Record),
         new MySqlParameter("@ACCEPTANCE", data.Acceptance),
         new MySqlParameter("@AMOUNT", data.Amount),
         new MySqlParameter("@TOTALAREA", data.TotalArea),
         new MySqlParameter("@PADDYAREA", data.PaddyArea),
         new MySqlParameter("@DRYAREA", data.DryArea)
     };
     try {
         MySqlHelper.ExecuteNonQuery(Constant.strConntection(), CommandType.Text, sqlInsert.ToString(), pt);
     } catch (Exception ex) {
         return false;
         throw ex;
     }
     return true;
 }