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);
}
