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();
}
}
}