public List <Authorize> GetAuthorizeByPid(string pid, string accountTypeID)
{
var e = ExtLinq.True <Authorize>();
e = e.And(x => x.PID == pid);
e = e.And(x => x.AccountTypeID == accountTypeID);
e = e.And(x => (x.DeleteMark == null ? false : x.DeleteMark) != true);
var list = authorizeApp.IQueryable(e).ToList();
return(list);
}
//public List<Authorize> GetAuthorizeByPid(string pid, string accountTypeID)
//{
// var e = ExtLinq.True<Authorize>();
// e = e.And(x => x.PID == pid);
// e = e.And(x => x.AccountTypeID == accountTypeID);
// e = e.And(x => (x.DeleteMark == null ? false : x.DeleteMark) != true);
// var list = authorizeApp.IQueryable(e).ToList();
// return list;
//}
public List <Authorize> GetAuthorizeButtonList(Pagination pagination, string authorizeID, string keyword)
{
var e = ExtLinq.True <Authorize>();
//e = e.And(x => x.PID == pid);
//e = e.And(x => x.AccountTypeID == accountTypeID);
e = e.And(x => x.PID == authorizeID);
e = e.And(x => x.AuthorizeType == ((int)AuthorizeType.Button).ToString());
e = e.And(x => (x.DeleteMark == null ? false : x.DeleteMark) != true);
List <Authorize> list = null;
if (pagination != null)
{
if (pagination.sord == "asc")
{
if (pagination.sidx == "AuthorizeName")
{
list = authorizeButtonApp.IQueryable(e).OrderBy(x => x.AuthorizeName).ToList();
}
else if (pagination.sidx == "SortCode")
{
list = authorizeButtonApp.IQueryable(e).OrderBy(x => x.SortCode).ToList();
}
else if (pagination.sidx == "Split")
{
list = authorizeButtonApp.IQueryable(e).OrderBy(x => x.Split).ToList();
}
else//IsPublic
{
list = authorizeButtonApp.IQueryable(e).OrderBy(x => x.IsPublic).ToList();
}
}
else
{
if (pagination.sidx == "AuthorizeName")
{
list = authorizeButtonApp.IQueryable(e).OrderByDescending(x => x.AuthorizeName).ToList();
}
else if (pagination.sidx == "SortCode")
{
list = authorizeButtonApp.IQueryable(e).OrderByDescending(x => x.SortCode).ToList();
}
else if (pagination.sidx == "Split")
{
list = authorizeButtonApp.IQueryable(e).OrderByDescending(x => x.Split).ToList();
}
else//IsPublic
{
list = authorizeButtonApp.IQueryable(e).OrderByDescending(x => x.IsPublic).ToList();
}
//list = authorizeButtonApp.IQueryable(e).OrderByDescending(x => x.SortCode).ToList();
}
}
else
{
list = authorizeButtonApp.IQueryable(e).OrderBy(x => x.SortCode).ToList();
}
if (keyword != null && keyword != "")
{
list = list.Where(x => x.AuthorizeName.Contains(keyword)).ToList();
}
return(list);
}