//获取所有的仓库信息
public IList <CangKu> getAllCangku()
{
IList <CangKu> list = new List <CangKu>();
String sql = "select * from storehouse";
MySqlDataReader reader = helper.GetReader(sql);
while (reader.Read())
{
CangKu cangku = new CangKu();
cangku.Cangku_id = (int)reader["storehouse_id"];
cangku.Cangku_name = reader["storehouse_name"].ToString();
list.Add(cangku);
}
return(list);
}
//根据仓库号查询仓库
public CangKu getCangKuByID(int id)
{
CangKu cangku = new CangKu();
String sql = "select * from storehouse where id='" + id + "'";
MySqlDataReader reader = helper.GetReader(sql);
while (reader.Read())
{
cangku.Cangku_id = (int)reader["storehouse_id"];
cangku.Cangku_name = reader["storehouse_name"].ToString();
}
return(cangku);
}
//初始化数据
public void InitialData()
{
User_service myservice = new User_service();
IList <User> userlist = myservice.getAllUsers();
IList <CangKu> cangkulist = myservice.getAllCangku();
// IList<Product> productlist = myservice.getAllProduct();
this.dataGridView1.Rows.Clear();
//this.dataGridView2.Rows.Clear();
this.Userdataview.Rows.Clear();
for (int i = 0; i < userlist.Count; i++)
{
User user = userlist[i];
String[] row = { user.Userid.ToString(), user.Username, user.Password, user.Limit.ToString() };
this.Userdataview.Rows.Add(row);
}
for (int j = 0; j < cangkulist.Count; j++)
{
CangKu cangku = cangkulist[j];
String[] row1 = { cangku.Cangku_id.ToString(), cangku.Cangku_name };
this.dataGridView1.Rows.Add(row1);
}
/* for (int k = 0; k < productlist.Count;k++ )
* {
* Product product = productlist[k];
* String[] row2 = { product.Pro_id.ToString(),product.Pro_name};
* this.dataGridView2.Rows.Add(row2);
* }
*/
/*
* String connectionString = "server = localhost; database = menagesystem; user id = root; password = 123456;";
* MySqlConnection connection = new MySqlConnection(connectionString);
* String sql = "select *from product";
* DataSet ds = new DataSet();
* MySqlDataAdapter da = new MySqlDataAdapter(sql,connection);
* da.Fill(ds, "product");
* dataGridView2.DataSource = ds.DefaultViewManager;
*/
}
