public IList <InKu> getInkusByCangkuid(String cangkuid)
{
IList <InKu> list = new List <InKu>();
String sql = "select * from in_table where storehouse_id='" + cangkuid + "'";
MySqlDataReader reader = helper.GetReader(sql);
Product_service pro_ser = new Product_service();
while (reader.Read())
{
InKu inku = new InKu();
inku.In_id = reader["idin_table"].ToString();
inku.Pro_id = reader["in_product"].ToString();
inku.In_time = reader["in_time"].ToString();
inku.In_num = Convert.ToInt32(reader["in_num"].ToString());
inku.Cangku_id = reader["storehouse_id"].ToString();
list.Add(inku);
}
return(list);
}
public IList <Outku> getOutkusByCangkuid(String cangkuid)
{
IList <Outku> list = new List <Outku>();
String sql = "select * from out_table where storehouse_id='" + cangkuid + "'";
MySqlDataReader reader = helper.GetReader(sql);
Product_service pro_ser = new Product_service();
while (reader.Read())
{
Outku outku = new Outku();
outku.Out_id = reader["idout_table"].ToString();
outku.Pro_id = reader["out_product"].ToString();
outku.Out_time = reader["out_time"].ToString();
outku.Out_num = Convert.ToInt32(reader["out_num"].ToString());
outku.Cangku_id = reader["storehouse_id"].ToString();
list.Add(outku);
}
return(list);
}
