public static Period FindNextPeriod(MySql.Data.MySqlClient.MySqlCommand cmd)
{
Period crnt = PeriodRepository.FindCurrentPeriod(cmd);
cmd.CommandText = "select * from table_period";
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
IList periods = Period.TransformReaderList(r);
r.Close();
int crntdx = periods.IndexOf(crnt);
int next = crntdx + 1;
if (next > periods.Count)
{
return(null);
}
return(periods[next] as Period);
}
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);
}
