public CJQY GetData(string CJQYBM) { string getSql = @"select CJQYBM,NumFarmer,CountArea FROM CJQYTable WHERE CJQYBM = @CJQYBM"; OleDbCommand cmd = new OleDbCommand(); cmd = con.CreateCommand(); cmd.Parameters.Add(new OleDbParameter("@CJQYBM", CJQYBM)); cmd.CommandText = getSql; con.Open(); OleDbDataReader reader = cmd.ExecuteReader(); CJQY cjqy = new CJQY(); if (!reader.HasRows) { cjqy = null; } else { while (reader.Read()) { cjqy.CJQYBM = reader["CJQYBM"].ToString(); cjqy.NumFarmer = reader["NumFarmer"].ToString(); cjqy.CountArea = reader["CountArea"].ToString(); } } con.Close(); return(cjqy); }
public bool Insert(CJQY cjqy) { string insertSql = "insert into CJQYTable(CJQYBM,NumFarmer,CountArea) values(@CJQYBM,@NumFarmer,@CountArea)"; OleDbCommand cmd = new OleDbCommand(); cmd = con.CreateCommand(); cmd.CommandText = insertSql; cmd.Parameters.Add(new OleDbParameter("@CJQYBM", cjqy.CJQYBM)); cmd.Parameters.Add(new OleDbParameter("@NumFarmer", cjqy.NumFarmer)); cmd.Parameters.Add(new OleDbParameter("@CountArea", cjqy.CountArea)); con.Open(); int infCount = cmd.ExecuteNonQuery(); bool returnInfo = false; if (infCount == 1) { returnInfo = true; } con.Close(); return(returnInfo); }