| | |
|---|
| | | /// <param name="_CateId"></param> |
|---|
| | | /// <param name="IsSearch"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public IEnumerable<Model.OA_ShebeiManage> GetDataByCate(Guid _MemberId,int? _CateId,bool IsSearch) |
|---|
| | | public IEnumerable<Model.OA_ShebeiManage> GetDataByCate(Guid _MemberId,string _CateId,bool IsSearch, int? Status) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | |
|---|
| | | if (_MemberId != Guid.Empty) |
|---|
| | | condition += " and MemberId = '" + _MemberId + "'"; |
|---|
| | | |
|---|
| | | if (_CateId>0) |
|---|
| | | condition += " and CateId = '" + _CateId + "'"; |
|---|
| | | if (!string.IsNullOrEmpty(_CateId)) |
|---|
| | | condition += " and CateId in ( " + _CateId + ")"; |
|---|
| | | |
|---|
| | | if (!IsSearch) |
|---|
| | | condition += " and AllNum > ReceiveNum and Status = '1' "; |
|---|
| | | |
|---|
| | | if (Status.HasValue && Status > 0) |
|---|
| | | condition += " and Status = '" + Status + "'"; |
|---|
| | | |
|---|
| | | return _dataBase.SelectModel<Model.OA_ShebeiManage>(" * ", " OA_ShebeiManage ", condition); |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
