| | |
| | | fromSource += string.Format(" and a.PaymentUnit like '%{0}%'", PaymentUnit); |
| | | } |
| | | |
| | | return _dataBase.SelectModelPage<Model.OA_FirmAccountRecord>(pa, target, fromSource, "a.LastUpdateTime DESC"); |
| | | return _dataBase.SelectModelPage<Model.OA_FirmAccountRecord>(pa, target, fromSource, "a.Keyid DESC"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | |
| | | } |
| | | if (!string.IsNullOrEmpty(PaymentUnit)) |
| | | { |
| | | fromSource += string.Format(" and a.PaymentUnit='{0}'", PaymentUnit); |
| | | fromSource += string.Format(" and a.PaymentUnit like '%{0}%'", PaymentUnit); |
| | | } |
| | | |
| | | IList<Model.OA_FirmAccountRecord> m_OA_FirmAccountRecordList = _dataBase.SelectModel<Model.OA_FirmAccountRecord>(target, fromSource + " group by RecordTypeId"); |