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