public ActionResult List(DateTime?startDate, DateTime?endDate, PunishTypeEnum?punishType)
{
var request = new GridRequest(Request);
var query = _PunishScoreRecordContract.Entities;
if (startDate.HasValue)
{
query = query.Where(p => p.CreatedTime >= startDate.Value.Date);
}
if (endDate.HasValue)
{
var endTime = endDate.Value.Date.AddDays(1).AddSeconds(-1);
query = query.Where(p => p.CreatedTime <= endTime);
}
if (punishType.HasValue)
{
query = query.Where(p => p.PunishType == punishType.Value);
}
var allScore = query.OrderByDescending(p => p.CreatedTime)
.Skip(request.PageCondition.PageIndex)
.Take(request.PageCondition.PageSize);
var da = allScore.Select(r => new
{
Id = r.Id,
r.PunishScore,
r.CreatedTime,
PunishType = r.PunishType.ToString(),
r.PunishAdminId,
MemberName = r.PunishAdmin.Member.MemberName,
Operator = r.Operator.Member.MemberName,
r.PunishAdmin.Department.DepartmentName,
r.Remarks
}).ToList()
.Select(r => new
{
Id = r.Id,
r.PunishScore,
r.CreatedTime,
PunishType = r.PunishType.ToString(),
r.PunishAdminId,
MemberName = r.MemberName,
Operator = r.Operator,
r.DepartmentName,
r.Remarks
}).ToList();
GridData <object> data = new GridData <object>(da, query.Count(), request.RequestInfo);
return(Json(data));
}
//----------------------------------------------------------------------------------------------------
public GridRequest GetGridRequest()
{
var rtn = new GridRequest();
rtn.TableType = this.ViewModel.TableType;
rtn.Id = this.ViewModel.Id;
rtn.DisplayTopNRows = this.ViewModel.DisplayTopNRows;
this.ViewOptions.Update_FiltersAndSorts();
rtn.FilterFields = this.ViewModel.FilterAndSort.FilterFields;
rtn.SortFields = this.ViewModel.FilterAndSort.SortFields;
return(rtn);
}
public async Task <ActionResult> List()
{
GridRequest request = new GridRequest(Request);
string SuccessionName = Request["SuccessionName"];
string ToExamineResult = Request["ToExamineResult"];
string DepartmentId = Request["DepartmentId"];
Expression <Func <ClassApplication, bool> > predicate = FilterHelper.GetExpression <ClassApplication>(request.FilterGroup);
int PageIndex = request.PageCondition.PageIndex + 1;
int PageSize = request.PageCondition.PageSize;
var listData = _classApplicationContract.ClassApplications.Where(predicate);
var depId_list = Utils.GetCurUserDepartList(AuthorityHelper.OperatorId, _administratorContract, false).Select(x => Convert.ToInt32(x.Value)).ToList();
if (depId_list.Count() > 0)
{
listData = listData.Where(x => depId_list.Contains(x.Admin.DepartmentId.Value));
}
if (!string.IsNullOrEmpty(DepartmentId))
{
int depId = Convert.ToInt32(DepartmentId);
listData = listData.Where(x => x.Admin.DepartmentId.Value == depId);
}
if (!string.IsNullOrEmpty(ToExamineResult))
{
int toExamine = Convert.ToInt32(ToExamineResult);
listData = listData.Where(x => x.ToExamineResult == toExamine);
}
var data = await Task.Run(() =>
{
var count = 0;
listData = listData.Where(x => x.Admin.Member.RealName.Contains(SuccessionName));
count = listData.Count();
var list = listData.OrderByDescending(c => c.CreatedTime).Skip(request.PageCondition.PageIndex *PageSize).Take(PageIndex *PageSize).Select(x => new
{
x.Id,
admin_DepartmentName = x.Admin.Department.DepartmentName,
x.Admin.Member.RealName,
x.CreatedTime,
x.Day,
x.OffDay,
x.SuccessionDep.DepartmentName,
x.UpdatedTime,
x.ToExamineResult,
x.IsDeleted,
x.AdminId,
SuccessionName = x.Succession.Member.RealName
});
return(new GridData <object>(list, count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult List(string bigProdNum)
{
if (string.IsNullOrEmpty(bigProdNum) || bigProdNum.Length > 7)
{
return(Json(OperationResult.Error("参数错误")));
}
GridRequest gr = new GridRequest(Request);
var managedStoreIds = _storeContract.QueryManageStoreId(AuthorityHelper.OperatorId.Value);
if (managedStoreIds == null || !managedStoreIds.Any())
{
return(Json(OperationResult.Error("权限不足")));
}
//获取权限之外且不是独立库存的店铺
var outPermissionAndNotIndependentStoreIds = _storeContract.Stores
.Where(s => !s.IsDeleted && s.IsEnabled)
.Where(s => !managedStoreIds.Contains(s.Id))
.Where(s => !s.StoreType.IndependentStorage)
.Select(s => s.Id).ToList();
var list = _productContract.Products.Where(c => !c.IsDeleted && c.IsEnabled)
.Where(c => c.BigProdNum.StartsWith(bigProdNum))
.Select(c => new SearchEnry
{
Id = c.Id,
ProductNumber = c.ProductNumber,
ThumbnailPath = c.ThumbnailPath ?? c.ProductOriginNumber.ThumbnailPath,
IconPath = c.Color.IconPath,
BrandName = c.ProductOriginNumber.Brand.BrandName,
SizeName = c.Size.SizeName,
CategoryName = c.ProductOriginNumber.Category.CategoryName,
ColorName = c.Color.ColorName,
SeasonName = c.ProductOriginNumber.Season.SeasonName,
TagPrice = c.ProductOriginNumber.TagPrice,
Cou = _inventoryContract.Inventorys.Where(i => i.IsEnabled && !i.IsDeleted)
.Where(i => i.ProductId == c.Id)
.Where(i => i.Status == (int)InventoryStatus.Default && !i.IsLock)
.Where(i => managedStoreIds.Contains(i.StoreId) || outPermissionAndNotIndependentStoreIds.Contains(i.StoreId))
.Count()
}).ToList();
GridData <object> grdat = new GridData <object>(list, list.Count, Request);
return(Json(grdat));
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(MaterialStorageLogInfoContract.MaterialStorageLogInfos, m => new
{
m.Id,
MatWareHouse_Id = m.MaterialBatch.MatWareHouseLocation.MatWareHouse.Id,
WareHouseCode = m.MaterialBatch.MatWareHouseLocation.MatWareHouse.WareHouseCode,
WareHouseName = m.MaterialBatch.MatWareHouseLocation.MatWareHouse.WareHouseName,
MatWareHouseArea_Id = m.MaterialBatch.MatWareHouseLocation.MatWareHouseArea.Id,
WareHouseAreaCode = m.MaterialBatch.MatWareHouseLocation.MatWareHouseArea.WareHouseAreaCode,
WareHouseAreaName = m.MaterialBatch.MatWareHouseLocation.MatWareHouseArea.WareHouseAreaName,
MatWareHouseLocation_Id = m.MaterialBatch.MatWareHouseLocation.Id,
WareHouseLocationCode = m.MaterialBatch.MatWareHouseLocation.WareHouseLocationCode,
WareHouseLocationName = m.MaterialBatch.MatWareHouseLocation.WareHouseLocationName,
WareHouseLocationType = m.MaterialBatch.MatWareHouseLocation.WareHouseLocationType,
Material_ID = m.Material.Id,
MaterialCode = m.Material.MaterialCode,
MaterialName = m.Material.MaterialName,
MaterialType = m.Material.MaterialType,
MaterialUnit = m.Material.MaterialUnit,
BatchCode = m.MaterialBatch.BatchCode,
InStorageBillCode = MaterialInStorageInfoContract.MaterialInStorageInfos.Where(x => x.Id.ToString().Contains(m.InStorageID.ToString())).Select(x => x.InStorageBillCode).FirstOrDefault(),
OutStorageBillCode = MaterialOutStorageInfoContract.MaterialOutStorageInfos.Where(x => x.Id.ToString().Contains(m.OutStorageID.ToString())).Select(x => x.OutStorageBillCode).FirstOrDefault(),
m.StorageChangeType,
m.InStorageID,
m.OutStorageID,
m.ChangedAmount,
m.OriginalAmount,
m.CurrentAmount,
m.Remark,
m.CreatedTime,
m.CreatorUserId,
m.LastUpdatedTime,
m.LastUpdatorUserId,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "读取物料库存日志信息列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "读取物料库存日志信息列表数据失败！" + ex.ToString())));
}
}
public async Task <GridResult> ObterTodosPorProjeto(Guid projetoId, GridRequest request = null)
{
var result = new GridResult();
var data = (await _criterioRepository.SearchAsync(x => x.ProjetoId == projetoId))
.OrderBy(x => x.Ordem).Select(x => x);
if (request == null)
{
result.Total = data.Count();
result.Data = data.Select(x => new { x.Id, x.ProjetoId, x.Ordem, x.Titulo, x.Descricao, x.Peso });
return(result);
}
data = string.IsNullOrWhiteSpace(request.Search) ?
data : data.Where(x =>
x.Titulo.IndexOf(request.Search, StringComparison.OrdinalIgnoreCase) >= 0 ||
x.Descricao.IndexOf(request.Search, StringComparison.OrdinalIgnoreCase) >= 0);
result.Total = data.Count();
if (!string.IsNullOrWhiteSpace(request.OrderBy))
{
if (request.Direction == Direction.Descendent)
{
data =
request.OrderBy == "titulo" ? data.OrderByDescending(x => x.Titulo) :
request.OrderBy == "peso" ? data.OrderByDescending(x => x.Peso) :
request.OrderBy == "ordem" ? data.OrderByDescending(x => x.Ordem) :
request.OrderBy == "descricao" ? data.OrderByDescending(x => x.Descricao) : data;
}
else
{
data =
request.OrderBy == "titulo" ? data.OrderBy(x => x.Titulo) :
request.OrderBy == "peso" ? data.OrderBy(x => x.Peso) :
request.OrderBy == "ordem" ? data.OrderBy(x => x.Ordem) :
request.OrderBy == "descricao" ? data.OrderBy(x => x.Descricao) : data;
}
}
if (request.PageSize > 0 && request.Page > 0)
{
data = data.Skip((request.Page - 1) * request.PageSize).Take(request.Page * request.PageSize);
}
result.Data = data.Select(x => new { x.Id, x.ProjetoId, x.Ordem, x.Titulo, x.Descricao, x.Peso });
return(result);
}
/// <summary>
/// 获取有效数据
/// </summary>
/// <returns></returns>
public async Task <ActionResult> ValidList()
{
GridRequest request = new GridRequest(Request);
Expression <Func <OnlinePurchaseProductItem, bool> > predicate = FilterHelper.GetExpression <OnlinePurchaseProductItem>(request.FilterGroup);
CheckResultEdo edo = ReadCookie(Request);
var data = await Task.Run(() =>
{
int count = 0;
int pageIndex = request.PageCondition.PageIndex;
int pageSize = request.PageCondition.PageSize;
IQueryable <Product> listProduct = _productContract.Products.Where(w => w.IsEnabled && !w.IsDeleted);
OnlinePurchaseProduct onlinePurchaseProduct = _onlinePurchaseProductContract.OnlinePurchaseProducts.FirstOrDefault(x => x.UniqueCode == edo.UniqueCode);
List <string> listNumber = onlinePurchaseProduct.OnlinePurchaseProductItems.AsQueryable()
.Where <OnlinePurchaseProductItem, int>(predicate, request.PageCondition, out count)
.Select(x => x.BigProdNum).Distinct().ToList();
List <ProductEdo> listProductEdo = new List <ProductEdo>();
List <Product> listEntity = listProduct.Where(x => listNumber.Any(k => k == x.BigProdNum) == true).ToList();
string strColor = string.Empty;
string strSize = string.Empty;
string strImagePath = string.Empty;
string strBrandName = string.Empty;
string strCategoryName = string.Empty;
foreach (string number in listNumber)
{
IEnumerable <Product> entities = listEntity.Where(x => x.BigProdNum == number);
List <string> listColors = listEntity.Select(x => x.Color.ColorName).Distinct().ToList();
List <string> listSize = listEntity.Select(x => x.Size.SizeName).Distinct().ToList();
strColor = ExpendTostring(listColors);
strSize = ExpendTostring(listSize);
Product product = entities.FirstOrDefault();
strImagePath = product.ProductOriginNumber.ThumbnailPath;
strBrandName = product.ProductOriginNumber == null ? "" : product.ProductOriginNumber.Brand.BrandName;
strCategoryName = product.ProductOriginNumber == null ? "" : product.ProductOriginNumber.Category.CategoryName;
listProductEdo.Add(new ProductEdo
{
Id = number,
ColorName = strColor,
SizeName = strSize,
ImagePath = strImagePath,
ColorCount = listColors.Count(),
SizeCount = listSize.Count(),
BrandName = strBrandName,
CategoryName = strCategoryName,
BigProdNum = number
});
}
return(new GridData <object>(listProductEdo, count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> GetGridData()
{
GridRequest request = new GridRequest(Request);
Expression <Func <DemoEntity, bool> > predicate = FilterHelper.GetExpression <DemoEntity>(request.FilterGroup);
GridData <object> data = await Task.Run(() =>
{
int total;
var rows = _demoContract.DemoEntities.Where <DemoEntity, int>(predicate, request.PageCondition, out total)
.Select(m => new { m.Id, m.Name, m.Remark, m.CreatedTime }).ToList();
return(new GridData <object>(rows, total));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
//yxk 2015-10-23修改
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
public async Task <ActionResult> List()
{
GridRequest request = new GridRequest(Request);
Expression <Func <Brand, bool> > predicate = FilterHelper.GetExpression <Brand>(request.FilterGroup);
var data = await Task.Run(() =>
{
Func <List <Brand>, List <Brand> > getTree = null;
getTree = (source) =>
{
var children = source.OrderBy(o => o.Sequence).ThenBy(o => o.Id);
List <Brand> tree = new List <Brand>();
foreach (var child in children)
{
tree.Add(child);
var chil = _brandContract.Brands.Where(c => c.ParentId == child.Id).ToList();
if (child.ParentId == null)
{
child.Products = chil.SelectMany(s => s.Products).ToList();//为了 下边的统计 ProductCount用
}
tree.AddRange(getTree(chil));
}
return(tree);
};
var parents = _brandContract.Brands.Where(m => m.ParentId == null).ToList();
var list = getTree(parents).AsQueryable().Where(predicate)
.Select(m => new
{
ParentId = m.ParentId == null ? "" : m.ParentId.ToString(),
m.BrandName,
m.BrandCode,
m.DefaultDiscount,
ProductCount = m.Products.Count,
//m.BrandLevel,
m.IconPath,
m.Description,
m.Id,
m.IsDeleted,
m.IsEnabled,
m.Sequence,
m.UpdatedTime,
m.CreatedTime,
m.Operator.Member.MemberName,
IsStory = (m.BrandStory ?? "").Trim().Length > 0
}).ToList();
return(new GridData <object>(list, list.Count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public void NullLowestOnNoNullableTrhows()
{
Assert.Throws <ArgumentException>(() =>
{
var sort = new[] { new GridSort("A", treatNullLowest: true) };
var request = new GridRequest()
{
Sort = sort
};
var query = request.WrapQuery(Collection);
});
}
public override void CreateExcel()
{
GridRequest request = new GridRequest(Request);
var filterGroup = request.FilterGroup;
Expression <Func <TemporaryCard, bool> > predicate = FilterHelper.GetExpression <TemporaryCard>(filterGroup);
var temporaryCards = HrContract.TemporaryCards.Where(predicate).Select(m => new
{
m.Card,
m.EmpNo,
m.EmpName,
});
Excel(temporaryCards, "temporaryCards" + DateTime.Now.ToString("yyyyMMddhhmmss"));
}
public ActionResult GridData(int?id)
{
int total;
GridRequest request = new GridRequest(Request);
var datas = GetQueryData <TemporaryCard, int>(HrContract.TemporaryCards, out total, request).Select(m => new
{
m.Id,
m.Card,
m.EmpNo,
m.EmpName
});
return(Json(new GridData <object>(datas, total), JsonRequestBehavior.AllowGet));
}
public virtual async Task <GridResult <TViewModel> > List(GridRequest request)
{
try
{
return(await Task.Run(() => _repository.GridList(request, _defaultSortFieldName)));
}
catch (Exception ex)
{
Log.Error(ex);
return(new GridResult <TViewModel> {
Status = "error", Message = "Error: " + ex.Message
});
}
}
public void to_data_request_with_ascending_sort_order()
{
var request = new GridRequest<CaseGrid>(){
page = 2,
rows = 15,
sidx = "field1",
sord = "asc"
}.ToDataRequest();
request.Page.ShouldEqual(2);
request.ResultsPerPage.ShouldEqual(15);
request.SortColumn.ShouldEqual("field1");
request.SortAscending.ShouldBeTrue();
}
public ActionResult GridData(int?id)
{
int total;
GridRequest request = new GridRequest(Request);
var datas = GetQueryData <Factory, int>(SiteManagementContract.Factorys, out total, request).Select(m => new
{
m.Id,
m.Text,
m.Value,
m.CreatedTime,
});
return(Json(new GridData <object>(datas, total), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 取得图文消息一览
/// </summary>
/// <returns></returns>
public ActionResult GetArticleList()
{
var gridRequest = new GridRequest(Request);
var expression = FilterHelper.GetExpression <ArticleInfo>(gridRequest.FilterGroup);
// TODO: how to add App ID to expression
var appId = int.Parse(Request["AppId"]);
expression = expression.AndAlso(x => x.AppId == appId);
var rowCount = gridRequest.PageCondition.RowCount;
var listEx = this.GetArticleListPrivate(expression, gridRequest.PageCondition);
return(base.GetPageResult(listEx, gridRequest));
}
public async Task <IActionResult> Get([FromHeader] GridRequest request)
{
var data = await _userService.GetAll(request);
if (data == null)
{
return(new BadRequestResult());
}
var users = data.Results != null?_outputConverter.Map <List <UserListModel> >(data.Results) : null;
var result = users.GetPagedResult(data.PageSize, data.CurrentPage, data.RowCount);
return(Ok(result));
}
public void SortOnWrongPropertyThrows()
{
Assert.Throws <ArgumentException>(() =>
{
var sort = new[] { new GridSort("X") };
var request = new GridRequest()
{
Sort = sort
};
var query = request.WrapQuery(Collection);
});
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(MaterialInStorageInfoContract.MaterialInStorageInfos, m => new
{
m.Id,
m.InStorageBillCode,
m.InStorageType,
m.ScheduleID,
MaterialID = m.MaterialID,
MaterialCode = MaterialInfoContract.MaterialInfos.Where(x => x.Id.ToString().Contains(m.MaterialID.ToString())).Select(x => x.MaterialCode).FirstOrDefault(),
MaterialName = MaterialInfoContract.MaterialInfos.Where(x => x.Id.ToString().Contains(m.MaterialID.ToString())).Select(x => x.MaterialName).FirstOrDefault(),
FullPalletQuantity = MaterialInfoContract.MaterialInfos.Where(x => x.Id.ToString().Contains(m.MaterialID.ToString())).Select(x => x.FullPalletQuantity).FirstOrDefault(),
m.Quantity,
m.PalletQuantity,
m.PalletID,
PalletCode = MatPalletInfoContract.MatPalletInfos.Where(x => x.Id.ToString().Contains(m.PalletID.ToString())).Select(x => x.PalletCode).FirstOrDefault(),
PalletName = MatPalletInfoContract.MatPalletInfos.Where(x => x.Id.ToString().Contains(m.PalletID.ToString())).Select(x => x.PalletName).FirstOrDefault(),
MatSupplierID = m.MatSupplierID,
SupplierCode = MatSupplierInfoContract.MatSupplierInfos.Where(x => x.Id.ToString().Contains(m.MatSupplierID.ToString())).Select(x => x.SupplierCode).FirstOrDefault(),
SupplierName = MatSupplierInfoContract.MatSupplierInfos.Where(x => x.Id.ToString().Contains(m.MatSupplierID.ToString())).Select(x => x.SupplierName).FirstOrDefault(),
//m.PalletFinishQuantity,
m.InStorageTime,
m.FinishTime,
m.InStorageStatus,
//m.CreateUser,
m.AuditPerson,
m.AuditStatus,
m.Description,
m.Remark,
m.CreatedTime,
m.CreatorUserId,
m.LastUpdatedTime,
m.LastUpdatorUserId,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "读取物料入库信息列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "读取物料入库信息列表数据失败！" + ex.ToString())));
}
}
//yxk 2015-9-
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
public async Task <ActionResult> List()
{
GridRequest request = new GridRequest(Request);
Expression <Func <Purchase, bool> > predicate = FilterHelper.GetExpression <Purchase>(request.FilterGroup);
var availableStorageIds = CacheAccess.GetManagedStorage(_storageContract, _administratorContract).Select(i => i.Id).ToList();
var data = await Task.Run(() =>
{
var count = 0;
var list = (from m in _purchaseContract.Purchases.Where(c => !c.IsDeleted && c.IsEnabled)
.Where(c => availableStorageIds.Contains(c.ReceiverStorageId.Value) || availableStorageIds.Contains(c.StorageId.Value))
.Where <Purchase, int>(predicate, request.PageCondition, out count)
select new
{
ParentId = "",
m.PurchaseNumber,
FactoryName = m.StoreCartId.HasValue && m.OriginFlag == StoreCardOriginFlag.工厂 ? m.StoreCart.Factory.FactoryName:"",
StorageOut = _storageContract.Storages.Where(c => c.Id == m.StorageId).FirstOrDefault().StorageName,
// m.StorageId,
ReceiverStore = _storeContract.Stores.Where(c => c.Id == m.ReceiverId).FirstOrDefault().StoreName,
ReceiverStoreId = _storeContract.Stores.Where(c => c.Id == m.ReceiverId).FirstOrDefault().Id,
// m.ReceiverId,
ReceiverStorage = _storageContract.Storages.Where(c => c.Id == m.ReceiverStorageId).FirstOrDefault().StorageName,
m.PurchaseStatus,
m.Notes,
ProductNum = "",
m.Id,
m.IsDeleted,
m.IsEnabled,
m.Sequence,
m.UpdatedTime,
m.CreatedTime,
m.Operator.Member.MemberName,
Quantity = -1,
OrderBlankNumber = m.Orderblanks.Where(x => x.IsEnabled && !x.IsDeleted).OrderByDescending(s => s.CreatedTime).FirstOrDefault().OrderBlankNumber ?? "",
StyleCount = m.PurchaseItems.Where(w => !w.IsNewAdded).Select(s => s.Product.BigProdNum).Distinct().Count(),
StyleCountReal = m.PurchaseItems.Select(s => s.Product.BigProdNum).Distinct().Count(),
StyleCountRealed = m.PurchaseItems.Where(w => w.PurchaseItemProducts.Any()).Select(s => s.Product.BigProdNum).Distinct().Count(),
PieceCount = m.PurchaseItems.Where(w => !w.IsNewAdded).Sum(s => s.Quantity),
PieceCountReal = m.PurchaseItems.Sum(s => s.Quantity),
PieceCountRealed = m.PurchaseItems.SelectMany(s => s.PurchaseItemProducts).Count(),
//OriginFlag = m.StoreCart != null ? (m.StoreCart.OriginFlag + "") : "未知"
OriginFlag = m.OriginFlag + "",
}).ToList();
return(new GridData <object>(list, count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult List()
{
var count = 0;
OperationResult resul = new OperationResult(OperationResultType.Error);
GridRequest request = new GridRequest(Request);
Expression <Func <VideoEquipment, bool> > predicate = FilterHelper.GetExpression <VideoEquipment>(request.FilterGroup);
List <int> s_List = _storeContract.QueryManageStoreId(AuthorityHelper.OperatorId.Value);
int PageIndex = request.PageCondition.PageIndex + 1;
var allVideo = _videoEquipmentContract.VideoEquipments.Where(x => s_List.Contains(x.StoreId));
var da = allVideo
.Where <VideoEquipment, int>(predicate, request.PageCondition, out count)
//.Skip(request.PageCondition.PageIndex * request.PageCondition.PageSize).Take(PageIndex * request.PageCondition.PageSize)
.Select(c => new
{
c.VideoName,
c.snNumber,
c.Store.StoreName,
c.Id,
c.CreatedTime,
c.Operator.Member.MemberName,
c.IsDeleted,
c.IsEnabled
}).ToList();
List <object> list = new List <object>();
foreach (var item in da)
{
//int useCount = GetUseVideoCount(item.Id);
var datasource = new
{
VideoName = item.VideoName,
snNumber = item.snNumber,
StoreName = item.StoreName,
useCount = 0,
item.Id,
channelPicUrl = GetChannelPicUrl(item.snNumber),
CreatedTime = item.CreatedTime,
MemberName = item.MemberName,
isOnline = CheckIsOnline(item.snNumber),
item.IsEnabled,
item.IsDeleted
};
list.Add(datasource);
}
GridData <object> data = new GridData <object>(list, count, request.RequestInfo);
return(Json(data));
}
public ActionResult GetUseList()
{
GridRequest request = new GridRequest(Request);
int id = 0;
string idStr = Request.Form["Id"].ToString();
Int32.TryParse(idStr, out id);
var seachVideo = _videoJurisdictionContract.VideoJurisdictions.Where(x => x.VideoEquipmentId == id &&
x.IsDeleted == false && x.IsEnabled == true);
var da = seachVideo.OrderByDescending(c => c.CreatedTime).ThenByDescending(c => c.Id).Skip(request.PageCondition.PageIndex).Take(request.PageCondition.PageSize).Select(c => new
{
c.Id,
c.Member.MemberName,
c.MemberId,
OperatorName = c.Operator.Member.MemberName,
c.CreatedTime,
c.Member.MobilePhone
});
List <object> list = new List <object>();
foreach (var item in da)
{
var member = _memberContract.Members.Where(x => x.Id == item.MemberId).FirstOrDefault();
var storeName = string.Empty;
var departmentName = string.Empty;
if (member != null)
{
storeName = _storeContract.Stores.Where(x => x.Id == member.StoreId).Select(x => x.StoreName).FirstOrDefault();
departmentName = GetDepartmentName(member.Id);
}
var dataSource = new
{
item.Id,
storeName,
item.MemberName,
item.OperatorName,
item.CreatedTime,
item.MemberId,
item.MobilePhone,
departmentName = departmentName
};
list.Add(dataSource);
}
GridData <object> data = new GridData <object>(list, seachVideo.Count(), request.RequestInfo);
return(Json(data));
}
/// <summary>
/// 获取考勤数据列表
/// </summary>
/// <returns></returns>
public async Task <ActionResult> AdminList()
{
GridRequest request = new GridRequest(Request);
var rule = request.FilterGroup.Rules.Where(x => x.Field == "AdminId").FirstOrDefault();
string strAdminId = rule.Value.ToString();
request.FilterGroup.Rules.Remove(rule);
int adminId = int.Parse(strAdminId);
Expression <Func <Administrator, bool> > predicate = FilterHelper.GetExpression <Administrator>(request.FilterGroup);
var data = await Task.Run(() =>
{
var count = 0;
List <Administrator> listAdmin = _administratorContract.Administrators.Where(x => x.IsDeleted == false && x.IsEnabled == true).ToList();
Administrator admin = listAdmin.FirstOrDefault(x => x.Id == adminId);
//bool res = admin.JobPosition == null && admin.JobPosition.IsLeader;
List <Administrator> listEntity = new List <Administrator>();
List <int> listDepartId = new List <int>();
if (admin.JobPosition == null)
{
if (admin.JobPosition.IsLeader == true)
{
listEntity = listAdmin.Where(x => x.DepartmentId == admin.DepartmentId).ToList();
}
ICollection <Department> listDepart = admin.JobPosition.Departments;
if (listDepart != null && listDepart.Count() > 0)
{
listDepartId = listDepart.Select(x => x.Id).ToList();
listEntity.AddRange(listAdmin.Where(x => listDepartId.Contains(x.DepartmentId ?? 0)));
}
}
if (adminId == admin.Department.SubordinateId)
{
List <Department> listDepart = admin.Department.Children.ToList();
if (listDepart != null)
{
List <int> childrenId = listDepart.Select(x => x.Id).ToList();
listEntity.AddRange(listAdmin.Where(x => childrenId.Contains(x.DepartmentId ?? 0)).ToList());
}
}
var list = listEntity.Distinct().AsQueryable().Where <Administrator, int>(predicate, request.PageCondition, out count).Select(x => new
{
x.Id,
x.Member.RealName,
});
return(new GridData <object>(list, count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
public ActionResult VaildViewList(string uid)
{
GridRequest request = new GridRequest(Request);
int count = 0;
int pageIndex = request.PageCondition.PageIndex;
int pageSize = request.PageCondition.PageSize;
var validListFromCache = (List <Product_Model>)SessionAccess.Get(SESSION_KEY_VALID_LIST + uid) ?? new List <Product_Model>();
count = validListFromCache.Count;
var index = 1;
var resData = validListFromCache.Skip(pageIndex).Take(pageSize).Select(p => new { Id = index++, ProductBarcode = p.ProductBarcode }).ToList();
var data = new GridData <object>(resData, count, request.RequestInfo);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public void to_data_request_with_descending_sort_order()
{
var request = new GridRequest <CaseGrid>()
{
page = 2,
rows = 15,
sidx = "field1",
sord = "desc"
}.ToDataRequest();
request.Page.ShouldEqual(2);
request.ResultsPerPage.ShouldEqual(15);
request.SortColumn.ShouldEqual("field1");
request.SortAscending.ShouldBeFalse();
}
public GridResponse GridDelete([FromGridRequest] string requestString)
{
try
{
var request = GridRequest.Deserialize(requestString);
var range = dbContext.Employee.Where(e => request.Selected.Contains(e.Id));
dbContext.Employee.RemoveRange(range);
dbContext.SaveChanges();
return(GridResponse.Success);
}
catch (Exception ex)
{
return(GridResponse.Error(GetMessage(ex)));
}
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
public async Task <ActionResult> ColorList()
{
GridRequest request = new GridRequest(Request);
Expression <Func <Color, bool> > predicate = FilterHelper.GetExpression <Color>(request.FilterGroup);
var data = await Task.Run(() => {
var count = 0;
var list = _colorContract.Colors.Where <Color, int>(predicate, request.PageCondition, out count).Select(m => new {
m.ColorName,
m.Id,
}).ToList();
return(new GridData <object>(list, count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
public async Task <ActionResult> List()
{
try
{
GridRequest request = new GridRequest(Request);
var rule_CompanyGoodsCategoryName = request.FilterGroup.Rules.FirstOrDefault(r => r.Field == "CompanyGoodsCategoryName_Search");
if (rule_CompanyGoodsCategoryName != null)
{
request.FilterGroup.Rules.Remove(rule_CompanyGoodsCategoryName);
}
Expression <Func <GoodsPurchasing, bool> > predicate = FilterHelper.GetExpression <GoodsPurchasing>(request.FilterGroup);
var data = await Task.Run(() =>
{
if (rule_CompanyGoodsCategoryName != null && rule_CompanyGoodsCategoryName.Value.ToString().Trim() != "")
{
string name = rule_CompanyGoodsCategoryName.Value.ToString();
predicate = predicate.And(p => p.CompanyGoodsCategory.CompanyGoodsCategoryName.Contains(name));
}
var count = 0;
var list = _GoodsPurchasingContract.Entities.Where <GoodsPurchasing, int>(predicate, request.PageCondition, out count).ToList().OrderBy(c => c.CreatedTime).
Select(s => new
{
s.Id,
s.CompanyGoodsCategory.CompanyGoodsCategoryName,
s.CompanyGoodsCategory.ImgAddress,
s.TotalAmount,
s.Quantity,
AdminName = s.Admin == null ? "" : s.Admin.Member.RealName,
s.IsDeleted,
s.IsEnabled,
s.CreatedTime,
OperatorName = s.Operator.Member.RealName,
}).ToList();
return(new GridData <object>(list, count, request.RequestInfo));
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, ex.ToString()), JsonRequestBehavior.AllowGet));
}
}
//public override List<AppUserView> GetListEx(Expression<Func<A, bool>> predicate, PageCondition ConPage)
//{
// string strKeyWord = Request["txtKeyWord"];
// var q = GetListPrivate(ref predicate, ConPage, strKeyWord);
// return q;
//}
public override ActionResult GetList()
{
GridRequest req = new GridRequest(Request);
string strKeyWord = Request["txtKeyWord"];
var q = _appUserService.QueryUser(strKeyWord, AccountManageID, req.PageCondition);
return(Json(new
{
sEcho = Request["draw"],
iTotalRecords = req.PageCondition.RowCount,
iTotalDisplayRecords = req.PageCondition.RowCount,
aaData = q.ToList()
}, JsonRequestBehavior.AllowGet));
}
private void RequestMaps()
{
if (PlayerId != -1)
{
var player = Session.Objects.Get(PlayerId);
var ul = Geometry.MapToGrid(player.Position.Add(-500));
var br = Geometry.MapToGrid(player.Position.Add(500));
for (int y = ul.Y; y <= br.Y; y++)
{
for (int x = ul.X; x <= br.X; x++)
{
GridRequest.Raise(new Point2D(x, y));
}
}
}
}
public ActionResult GridData(int?id)
{
GridRequest request = new GridRequest(Request);
var page = GetPageResult(IdentityContract.Roles, m => new
{
m.Id,
m.Name,
m.Remark,
m.IsAdmin,
m.IsSystem,
m.IsLocked,
m.CreatedTime
}, request);
return(Json(page.ToGridData(), JsonRequestBehavior.AllowGet));
}
