public StockCardEntry(StockCard stockCard, EventItem item) { STOCK_CARD = stockCard; STOCK_CARD_ENTRY_TYPE = item.STOCK_CARD_ENTRY_TYPE; TRANSACTION_DATE = item.EVENT.TRANSACTION_DATE; AMOUNT = item.GetAmountInSmallestUnit(); UNIT = item.PART.UNIT; item.STOCK_CARD_ENTRY = this; EVENT_ITEM = item; }
public static string FindByEventItem(int id, StockCardEntryType type) { return(String.Format("Select * from table_stockcardentry where eventitem_id ={0} and sce_stockcardentrytype = '{1}'", id, type.ToString())); }
public static StockCardEntry FindStockCardEntryByEventItem(MySql.Data.MySqlClient.MySqlCommand cmd, int itemID, StockCardEntryType scetype) { cmd.CommandText = StockCardEntry.FindByEventItem(itemID, scetype); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); StockCardEntry res = StockCardEntry.TransformReader(r); r.Close(); return(res); }