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