Byrd

        private IList<MailInfo> Load(int first, int count)
        {
            IList<MailInfo> list = new List<MailInfo>();
            if (count == 0) return list;

            ISession session = DAORepository.Instrance.DbSession;
            using (ITransaction tx = session.BeginTransaction())
            {
                try
                {
                    ICriteria cri = session.CreateCriteria(typeof(MailInfo));
                    cri.SetFirstResult(first);
                    cri.SetMaxResults(count);
                    cri.Add(new Expression.EqExpression("Status", (int)MailStatusType.New));
                    cri.AddOrder(Expression.Order.Desc("CreateTime"));
                    cri.SetLockMode(LockMode.UpgradeNoWait);
                    list = cri.List<MailInfo>();
                    foreach (MailInfo mi in list)
                    {
                        mi.Status = (int)MailStatusType.Lock;
                        session.Update(mi);
                    }
                    tx.Commit();
                }
                catch (Exception ex)
                {
                    tx.Rollback();
                    string err = ex.Message;
                }
                finally
                {
                    session.Close();
                }
            }
            return list;
        }