/*ใช้ในหน้าสรุปซื้อขาย เรียกจาก ObjectDatasource*/ public static IList <VOTransactionSelect_GridTransaction> List( imSabayaContext context, int fundId, int accountId, DateTime date, int transactionTypeId, int sellingAgentId, int orgUnitId ) { ICriteria crit = context.PersistencySession.CreateCriteria(typeof(MFTransaction)); crit.Add(Expression.Eq("Fund", (Fund)MutualFund.Find(context, fundId))) //.Add(Expression.Eq("RollbackStatus", (byte)0)) .CreateAlias("CurrentState", "currentState") .CreateAlias("CurrentState.State", "state") .Add(Expression.Eq("state.Code", "Released")); if (accountId != 0) { crit.Add(Expression.Eq("Portfolio", MFAccount.Find(context, accountId))); } if (transactionTypeId != 0) { crit.Add(Expression.Eq("Type", InvestmentTransactionType.Find(context, transactionTypeId))); } if (date != DateTime.MinValue) { DateTime minOfToday = date.Date; DateTime maxOfToday = date.Date.AddDays(1).Date.AddMilliseconds(-1); crit.Add(Expression.Between("TransactionTS", minOfToday, maxOfToday)); } if (sellingAgentId != 0) { crit.Add(Expression.Eq("SellingAgent", Organization.Find(context, sellingAgentId))); } IList <MFTransaction> list = crit.List <MFTransaction>(); IList <VOTransactionSelect_GridTransaction> vos = new List <VOTransactionSelect_GridTransaction>(); foreach (MFTransaction tran in list) { vos.Add(new VOTransactionSelect_GridTransaction(context, tran)); } return(vos); }