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