public static List <model.good> find_all()//查询出所有客户 { MySqlConnection conn = Util.Util.getConn(); String sql = "select * from good"; MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); DataSet ds = new DataSet(); Console.WriteLine("ds:" + ds); da.Fill(ds); conn.Close(); //获得DataSet里的数据 List <model.good> rs = new List <model.good>(); if (ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)//判断DataSet里是否有值 { rs = new List <model.good>(); int count = ds.Tables[0].Rows.Count;//获得表的行数 for (int i = 0; i < count; i++) { model.good r = new model.good(); r.Id = (int)ds.Tables[0].Rows[i]["id"]; r.Good_number = (string)ds.Tables[0].Rows[i]["good_number"]; r.Good_name = (string)ds.Tables[0].Rows[i]["good_name"]; r.Good_type = (string)ds.Tables[0].Rows[i]["good_type"]; r.Good_unit = (string)ds.Tables[0].Rows[i]["good_unit"]; r.Good_price = (double)ds.Tables[0].Rows[i]["good_price"]; rs.Add(r); } } return(rs); }
public static List <model.good> selectAll(String number) { MySqlConnection conn = Util.Util.getConn(); MySqlDataReader dataReader = null; MySqlCommand command = null; List <model.good> kehus = new List <model.good>(); model.good r = new model.good(); try { command = conn.CreateCommand(); command.CommandText = "SELECT * FROM good where good_number='" + number + "'"; dataReader = command.ExecuteReader(); Console.WriteLine(); while (dataReader.Read()) { r.Id = dataReader.GetInt16(0); r.Good_number = dataReader.GetString(1); r.Good_name = dataReader.GetString(2); r.Good_type = dataReader.GetString(3); r.Good_unit = dataReader.GetString(4); r.Good_price = dataReader.GetDouble(5); kehus.Add(r); } } catch (Exception) { MessageBox.Show("查询出错!"); } finally { if (!dataReader.IsClosed) { dataReader.Close(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(kehus); }
private void good_update_Load(object sender, EventArgs e) { Console.Write("!!!!!" + number); model.good r = dao.goodDaoz.select(number); Number.Text = r.Good_number; }