private static MyOrdersResultModel DoLoadOrders(string memberId, GridPageModel data)
{
try
{
if (null != data && null != data.filter && null != data.filter.Filters && data.filter.Filters.Any())
{
var filter = data.filter.Filters.FirstOrDefault();
if (null != filter && null != filter.Filters && filter.Filters.Any())
{
var anyFilter = filter.Filters.FirstOrDefault();
if (null != anyFilter && null != anyFilter.Value)
{
var filteredOrders = _myOrdersSource.SearchMyOrders(anyFilter.Value.ToString(), memberId);
if (null != filteredOrders && filteredOrders.Any())
{
return(new MyOrdersResultModel
{
Items = filteredOrders.Skip(data.skip).Take(data.take),
TotalCount = filteredOrders.Count()
});
}
return(new MyOrdersResultModel {
Items = new List <MyOrdersViewModel>(), TotalCount = 0
});
}
}
}
var orders = _myOrdersSource.GetMyOrders(memberId);
if (null == orders)
{
LoggerHelper.Error("_myOrdersSource is returning null for " + memberId);
return(new MyOrdersResultModel {
Items = new List <MyOrdersViewModel>(), TotalCount = 0
});
}
if (null == data)
{
return(new MyOrdersResultModel {
Items = orders, TotalCount = orders.Count
});
}
return(new MyOrdersResultModel
{
Items = orders.Skip(data.skip).Take(data.take),
TotalCount = orders.Count
});
}
catch (Exception ex)
{
LoggerHelper.Error("DoLoadOrders MyOrdersController is throwing error " + memberId);
return(new MyOrdersResultModel {
Items = new List <MyOrdersViewModel>(), TotalCount = 0
});
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pager">分页model</param>
/// <param name="search">查询model</param>
/// <returns></returns>
public object GetPager(GridPageModel pager, SearchModel search)
{
using (var dbScope = _dbScopeFactory.Create())
{
var db = dbScope.DbContexts.Get <WebDbContext>();
var query = from p in db.SysAccounts
select p;
return(new PagedList <SysAccount>(query, pager).ToPager());
}
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="pager"></param>
/// <param name="search"></param>
/// <returns></returns>
public object GetPager(GridPageModel pager, SearchModel search)
{
var result = new Dictionary <string, object>();
using (var dbScope = _dbScopeFactory.Create())
{
var db = dbScope.DbContexts.Get <WebDbContext>();
var query = from p in db.SysRoles
where (!string.IsNullOrEmpty(search.SearchKey) ? p.RoleName.Contains(search.SearchKey) : p.RoleName == p.RoleName)
select p;
return(new PagedList <SysRole>(query, pager).ToPager());
}
}
/// <summary>
/// 获取用户分页列表
/// </summary>
/// <param name="pager"></param>
/// <param name="search"></param>
/// <param name="studented">只获取学生类型的</param>
/// <returns></returns>
public object GetPager(GridPageModel pager, AccountModel.Search search, bool studented = false)
{
using (var dbScope = _dbScopeFactory.CreateReadOnly())
{
var db = dbScope.DbContexts.Get <WebDbContext>();
var tempQuery = from p in db.SysAccounts
join aa in db.SysAccountRoles on p.Id equals aa.UserId into tempA
from a in tempA.DefaultIfEmpty()
join bb in db.SysRoles on a.RoleId equals bb.Id into tempB
from b in tempB.DefaultIfEmpty()
where (string.IsNullOrEmpty(search.SearchKey) ? true : (p.RealName.Contains(search.SearchKey) || p.UserName.Contains(search.SearchKey))) &&
(search.usertype.HasValue ? p.UserType == search.usertype.Value : true) &&
(studented ? p.UserType == (int)SysEnum.UserType.学生 : true)
select new AccountModel.Full
{
CreateDate = p.CreateDate,
HeadPoint = p.HeadPoint,
Id = p.Id,
IsEnabled = p.IsEnabled,
Password = p.Password,
RealName = p.RealName,
RoleName = b.RoleName,
UserName = p.UserName,
UserType = p.UserType
};
var tempTable = tempQuery.ToList();
var query = from p in tempTable
group p by new { p.CreateDate, p.HeadPoint, p.Id, p.IsEnabled, p.Password, p.RealName, p.UserName, p.UserType } into g
select g.Aggregate((now, next) => new AccountModel.Full
{
CreateDate = g.Key.CreateDate,
HeadPoint = g.Key.HeadPoint,
Id = g.Key.Id,
IsEnabled = g.Key.IsEnabled,
Password = g.Key.Password,
RealName = g.Key.RealName,
RoleName = now.RoleName + "," + next.RoleName,
UserName = g.Key.UserName,
UserType = g.Key.UserType
});
return(new PagedList <AccountModel.Full>(query.ToList(), pager).ToPager());
}
}
private static ContactResultModel DoLoadContacts(string memberId, GridPageModel data)
{
try
{
if (null != data && null != data.filter && null != data.filter.Filters && data.filter.Filters.Any())
{
var filter = data.filter.Filters.FirstOrDefault();
if (null != filter && null != filter.Filters && filter.Filters.Any())
{
var anyFilter = filter.Filters.FirstOrDefault();
if (null != anyFilter && null != anyFilter.Value)
{
var filteredContacts = _contactsSource.SearchContacts(memberId, anyFilter.Value.ToString());
if (null != filteredContacts && filteredContacts.Any())
{
return(new ContactResultModel
{
Items = filteredContacts.Skip(data.skip).Take(data.take).ToList(),
TotalCount = filteredContacts.Count()
});
}
return(new ContactResultModel {
Items = new List <ContactViewModel>(), TotalCount = 0
});
}
}
}
var contacts = _contactsSource.GetContacts(memberId);
if (null == contacts)
{
LoggerHelper.Error("_contactsSource is returning null for " + memberId);
return(new ContactResultModel
{
Items = new List <ContactViewModel>(),
TotalCount = 0
});
}
if (null == data)
{
return(new ContactResultModel {
Items = contacts, TotalCount = contacts.Count
});
}
return(new ContactResultModel
{
Items = contacts.Skip(data.skip).Take(data.take).ToList(),
TotalCount = contacts.Count
});
}
catch (Exception ex)
{
LoggerHelper.Exception("System.Exception", ex, "DoLoadContacts ContactsController is throwing error for " + memberId);
return(new ContactResultModel
{
Items = new List <ContactViewModel>(),
TotalCount = 0
});
}
}
private Task <ContactResultModel> LoadContacts(string memberId, GridPageModel data)
{
return(Task <ContactResultModel> .Factory.StartNew(() => DoLoadContacts(memberId, data)));
}
public async Task <ContactResultModel> Post(GridPageModel data)
{
var memberId = User.Identity.Name;
return(await LoadContacts(memberId, data));
}
private Task <MyOrdersResultModel> LoadMyOrders(string memberId, GridPageModel data)
{
return(Task <MyOrdersResultModel> .Factory.StartNew(() => DoLoadOrders(memberId, data)));
}
public async Task <MyOrdersResultModel> Post(GridPageModel data)
{
var memberId = User.Identity.Name;
return(await LoadMyOrders(memberId, data));
}
