//public static StockCard FindStockCard(MySql.Data.MySqlClient.MySqlCommand cmd, long periodId)
//{
// cmd.CommandText = String.Format("select * from table_stockcard where period_id = {0}", periodId);
// MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
// StockCard sc = StockCard.TransformReader(r);
// r.Close();
// return sc;
//}
public static IList FindStockCardByPeriod(MySql.Data.MySqlClient.MySqlCommand cmd, long periodId)
{
cmd.CommandText = String.Format("select * from table_stockcard where period_id = {0}", periodId);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
IList sc = StockCard.TransforReaderList(r);
r.Close();
return(sc);
}
public IList GetStockCardInfoList(int partID)
{
OpenConnection();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = m_connection;
Period p = PeriodRepository.FindCurrentPeriod(cmd);
cmd.CommandText = StockCard.FindByPartPeriod(partID, p.ID);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
IList stockcards = StockCard.TransforReaderList(r);
r.Close();
IList stockInfoList = new ArrayList();
foreach (StockCard sc in stockcards)
{
StockCardInfo sci = new StockCardInfo(sc.BALANCE, sc.BOOKED, sc.BACK_ORDER, sc.WAREHOUSE);
sci.WAREHOUSE = StockCardRepository.FindWarehouse(cmd, sc.WAREHOUSE.ID);
stockInfoList.Add(sci);
}
return(stockInfoList);
}
public StockCardInfo GetStockCardInfo(int partID)
{
OpenConnection();
StockCardInfo result = new StockCardInfo();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = m_connection;
Period p = PeriodRepository.FindCurrentPeriod(cmd);
cmd.CommandText = StockCard.FindByPartPeriod(partID, p.ID);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
IList stockcards = StockCard.TransforReaderList(r);
r.Close();
foreach (StockCard sc in stockcards)
{
result.BACKORDER += sc.BACK_ORDER;
result.BALANCE += sc.BALANCE;
result.BOOKED += sc.BOOKED;
}
return(result);
}
