//
// GET: /User/
public ActionResult Index(string name, int role = 0, int page = 1)
{
int count;
int pageSize = 15;
var query = CRL.Package.RoleAuthorize.EmployeeBusiness.Instance.GetLambdaQuery();
if (!string.IsNullOrEmpty(name))
{
query.Where(b => b.Name.Like("%" + name + "%"));
}
if (role > 0)
{
query.Where(b => b.Role == role);
}
query.Page(pageSize, page);
query.OrderBy(b => b.Id, true);
//todo 分页
var list = query.ToList();
count = query.RowCount;
var pageObj = new PageObj <CRL.Package.RoleAuthorize.Employee>(list, page, count, pageSize);
var roles = CRL.Package.RoleAuthorize.RoleBusiness.Instance.QueryList();
//var selectList = new SelectList(roles, "id", "Name", "24");
ViewBag.Role = roles;
return(View(pageObj));
}
public ActionResult Index(string k, string c = "", int page = 1, int pageSize = 15)
{
int count;
count = 0;
//使用缓存搜索
var query = new CRL.ExpressionJoin <Product>(BLL.ProductManage.Instance.AllCache, b => b.ProductStatus == CRL.Package.Product.ProductStatus.已上架);
if (!string.IsNullOrEmpty(k))
{
query.And(b => b.ProductName.Contains(k));
}
if (!string.IsNullOrEmpty(c))
{
query.And(b => b.CategoryCode.StartsWith(c));
}
var products = query.ToList().OrderByDescending(b => b.Id);
count = products.Count();
var result = products.Skip((page - 1) * pageSize).Take(pageSize).ToList();
var pageObj = new PageObj <Product>(result, page, count, pageSize);
return(View(pageObj));
}
public ActionResult Product(int page = 1, int pageSize = 15)
{
var query = ProductManage.Instance.GetLambdaQuery();
query.Where(b => b.SupplierId == CurrentUser.Id);
var result = query.ToList();
int count = query.RowCount;
var pageObj = new PageObj<Product>(result, page, count, pageSize);
return View(pageObj);
}
public ActionResult Transaction(TransactionType type = TransactionType.现金, int page = 1, int pageSize = 15)
{
ViewBag.TransactionType = type;
var query = BLL.Transaction.TransactionManage.Instance.GetLambdaQuery();
var accountId = BLL.Transaction.AccountManage.Instance.GetAccountId(CurrentUser.Id, AccountType.会员, type);
query.Where(b => b.AccountId == accountId);
var result = query.ToList();
int count = query.RowCount;
var pageObj = new PageObj<CRL.Package.Account.Transaction>(result, page, count, pageSize);
return View(pageObj);
}
//
// GET: /Proxy/
public ActionResult Index(int page = 1, int pageSize = 100)
{
var query = BLL.ProxyPool.IpProxyManage.Instance.GetLambdaQuery();
query.Page(pageSize, page);
query.OrderBy(b => b.Id, true);
var result = query.ToList();
int count = query.RowCount;
var pageObj = new PageObj <BLL.ProxyPool.IpProxy>(result, page, count, pageSize);
return(View(pageObj));
}
public ActionResult Product(int page = 1, int pageSize = 15)
{
var query = ProductManage.Instance.GetLambdaQuery();
query.Where(b => b.SupplierId == CurrentUser.Id);
var result = query.ToList();
int count = query.RowCount;
var pageObj = new PageObj <Product>(result, page, count, pageSize);
return(View(pageObj));
}
public ActionResult Transaction(TransactionType type = TransactionType.现金, int page = 1, int pageSize = 15)
{
ViewBag.TransactionType = type;
var query = BLL.Transaction.TransactionManage.Instance.GetLambdaQuery();
var accountId = BLL.Transaction.AccountManage.Instance.GetAccountId(CurrentUser.Id, AccountType.会员, type);
query.Where(b => b.AccountId == accountId);
var result = query.ToList();
int count = query.RowCount;
var pageObj = new PageObj <CRL.Package.Account.Transaction>(result, page, count, pageSize);
return(View(pageObj));
}
public ActionResult Product(int page = 1, int pageSize = 15)
{
var sup = SupplierManage.Instance.GetCurrent();
//var query = ProductManage.Instance.GetLambdaQuery().Where(b => b.SupplierId == sup.Id);
var query = sup.Products.GetQuery();
query.Page(pageSize, page);
query.OrderBy(b => b.Id, false);
var result = query.ToList();
int count = query.RowCount;
var pageObj = new PageObj <Product>(result, page, count, pageSize);
return(View(pageObj));
}
public ActionResult Index(string k, string c = "", int page = 1, int pageSize = 15)
{
int count;
count = 0;
var query = new CRL.ExpressionJoin<Product>(b => b.ProductStatus == CRL.Package.Product.ProductStatus.已上架);
if (!string.IsNullOrEmpty(k))
{
query.And(b => b.ProductName.Contains(k));
}
if (!string.IsNullOrEmpty(c))
{
query.And(b => b.CategoryCode.StartsWith(c));
}
//使用缓存搜索
IEnumerable<Product> products = BLL.ProductManage.Instance.QueryFromCache(query.GetExpression());
products = products.OrderByDescending(b => b.Id);
count = products.Count();
var result = products.Skip((page - 1) * pageSize).Take(pageSize).ToList();
var pageObj = new PageObj<Product>(result, page, count, pageSize);
return View(pageObj);
}
//
// GET: /User/
public ActionResult Index(string name,int role=0,int page=1)
{
int count;
int pageSize = 15;
var query = CRL.Package.RoleAuthorize.EmployeeBusiness.Instance.GetLambdaQuery();
if (!string.IsNullOrEmpty(name))
{
query.Where(b => b.Name.Like("%" + name + "%"));
}
if (role > 0)
{
query.Where(b=>b.Role==role);
}
query.Page(pageSize, page);
query.OrderBy(b => b.Id, true);
//todo 分页
var list = query.ToList();
count = query.RowCount;
var pageObj = new PageObj<CRL.Package.RoleAuthorize.Employee>(list, page, count, pageSize);
var roles = CRL.Package.RoleAuthorize.RoleBusiness.Instance.QueryList();
//var selectList = new SelectList(roles, "id", "Name", "24");
ViewBag.Role = roles;
return View(pageObj);
}
