/// <summary>
/// 获得组织信息列表数据【分页】
/// </summary>
/// <returns></returns>
public List <OrganizeEntity> GetList(Pagination pagination)
{
var expression = ExtLinq.True <OrganizeEntity>();
ResultClass <List <OrganizeEntity> > _ret = service.FindList(expression, pagination);
if (_ret.Result)
{
return(_ret.ResultData.OrderBy(t => t.F_CreatorTime).ToList());
}
return(new List <OrganizeEntity>());
}
/// <summary>
/// 使用sql查询
/// </summary>
/// <param name="enCode"></param>
/// <returns></returns>
public List <OrganizeEntity> FildSql(string enCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(enCode);
return(service.FindList(strSql.ToString()).ToList());
}
/// <summary>
/// 获取组织机构列表数据
/// </summary>
/// <returns></returns>
public List <OrganizeEntity> GetListData()
{
string findSql = @"select *from [dbo].[Sys_Organize] where F_DeleteMark=0 and F_EnabledMark=1
and F_MedicalInsuranceHandleNo is not null
and F_MedicalInsuranceAccount is not null and F_EnCode<>'yb'";
return(service.FindList(findSql));
}
public List <OrganizeEntity> GetList(Pagination pagination, string keyword)
{
var expression = ExtLinq.True <OrganizeEntity>();
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.F_FullName.Contains(keyword));
}
expression = expression.And(t => t.F_ParentId == "0");
return(service.FindList(expression, pagination));
}
public List <Organize> GetList(Pagination pagination, string keyword)
{
var e = ExtLinq.True <Organize>();
e = e.And(x => (x.DeleteMark == null?false:x.DeleteMark) != true);
if (!string.IsNullOrEmpty(keyword))
{
e = e.And(x => x.OrgName.Contains(keyword));
}
List <Organize> list = null;
if (pagination != null)
{
if (pagination.sord == "asc")
{
if (pagination.sidx == "OrgName")
{
list = organize.IQueryable(e).OrderBy(x => x.OrgName).ToList();
}
else if (pagination.sidx == "OrgCode")
{
list = organize.IQueryable(e).OrderBy(x => x.OrgCode).ToList();
}
else if (pagination.sidx == "OrgType")
{
list = organize.IQueryable(e).OrderBy(x => x.OrgType).ToList();
}
else if (pagination.sidx == "OrgProp")
{
list = organize.IQueryable(e).OrderBy(x => x.OrgProp).ToList();
}
else if (pagination.sidx == "OrgContact")
{
list = organize.IQueryable(e).OrderBy(x => x.OrgContact).ToList();
}
else if (pagination.sidx == "CreatorTime")
{
list = organize.IQueryable(e).OrderBy(x => x.CreatorTime).ToList();
}
else if (pagination.sidx == "IsEnable")
{
list = organize.IQueryable(e).OrderBy(x => x.IsEnable).ToList();
}
else//IsPublic
{
list = organize.IQueryable(e).OrderBy(x => x.ReMark).ToList();
}
}
else
{
if (pagination.sidx == "OrgName")
{
list = organize.IQueryable(e).OrderByDescending(x => x.OrgName).ToList();
}
else if (pagination.sidx == "OrgCode")
{
list = organize.IQueryable(e).OrderByDescending(x => x.OrgCode).ToList();
}
else if (pagination.sidx == "OrgType")
{
list = organize.IQueryable(e).OrderByDescending(x => x.OrgType).ToList();
}
else if (pagination.sidx == "OrgProp")
{
list = organize.IQueryable(e).OrderByDescending(x => x.OrgProp).ToList();
}
else if (pagination.sidx == "OrgContact")
{
list = organize.IQueryable(e).OrderByDescending(x => x.OrgContact).ToList();
}
else if (pagination.sidx == "CreatorTime")
{
list = organize.IQueryable(e).OrderByDescending(x => x.CreatorTime).ToList();
}
else if (pagination.sidx == "IsEnable")
{
list = organize.IQueryable(e).OrderByDescending(x => x.IsEnable).ToList();
}
else//IsPublic
{
list = organize.IQueryable(e).OrderByDescending(x => x.ReMark).ToList();
}
//list = authorizeButtonApp.IQueryable(e).OrderByDescending(x => x.SortCode).ToList();
}
list = list.Skip(pagination.rows * (pagination.page - 1)).Take(pagination.rows).ToList();
}
else
{
list = organize.FindList(e, pagination);
}
return(list);
}