using System; using System.Collections.Generic; using System.Data; using System.Linq; using Edu.Model.ViewModel.User; using Edu.Model.Entity.User; using Edu.Common.Enum.User; using System.Text; using Edu.Common.Enum; namespace Edu.Repository.User { /// /// 数据字典仓储层 /// public partial class Rb_dictvalueRepository : BaseRepository { /// /// 表名称 /// public string TableName { get { return nameof(RB_Dictvalue); } } /// /// 获取分页列表 /// /// /// /// /// /// public List GetPageList(int pageIndex, int pageSize, RB_Dictvalue_Extend where, out long count) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" SELECT * FROM {0} WHERE 1=1 ", TableName); sb.AppendFormat(" AND {0}={1} ", nameof(RB_Dictvalue_Extend.Status), (int)DateStateEnum.Normal); if (where != null) { if (where.RB_Group_id > 0) { sb.AppendFormat(" AND {0}={1} ", nameof(RB_Dictvalue_Extend.RB_Group_id), where.RB_Group_id); } if (!string.IsNullOrEmpty(where.Content)) { sb.AppendFormat(" AND {0} LIKE '%{1}%' ", nameof(RB_Dictvalue_Extend.Name), where.Content.Trim()); } } return GetPage(pageIndex, pageSize, out count, sb.ToString()).ToList(); } /// /// 获取条件下所有的字典 /// /// /// public List GetList(RB_Dictvalue_Extend where) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" SELECT * FROM {0} WHERE 1=1 ", TableName); if (where != null) { if (where.Status >= 0) { sb.AppendFormat(" AND {0}={1} ", nameof(RB_Dictvalue_Extend.Status), (int)where.Status); } if (!string.IsNullOrEmpty(where.Name)) { sb.AppendFormat(" AND {0}='{1}' ", nameof(RB_Dictvalue_Extend.Name), where.Name.Trim()); } if (!string.IsNullOrEmpty(where.Code)) { sb.AppendFormat(" AND {0}='{1}' ", nameof(RB_Dictvalue_Extend.Code), where.Code.Trim()); } if (where.RB_Group_id > 0) { sb.AppendFormat(" AND {0}={1} ", nameof(RB_Dictvalue_Extend.RB_Group_id), where.RB_Group_id); } if (!string.IsNullOrEmpty(where.DictKey)) { sb.AppendFormat(" AND {0}='{1}' ", nameof(RB_Dictvalue_Extend.DictKey), where.DictKey.Trim()); } } return Get(sb.ToString()).ToList(); } } }