public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(AlarmInfoContract.AlarmInfos, m => new
{
m.Id,
m.AlarmCode,
AgvName = m.AgvInfo.CarName,
CarPosition_Name = m.CarPosition.MarkPointName,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(TaskInfoContract.TaskInfos, m => new
{
m.Id,
m.TaskNo,
m.TaskName,
m.TaskStatus,
m.TaskType,
TargetPointInfo_Id = m.TargetPointInfo.Id,
TaskCar_Id = m.TaskCar.Id,
RouteInfo_Id = m.RouteInfo.Id,
TargetPointInfoName = m.TargetPointInfo.MarkPointName,
TaskCarName = m.TaskCar.CarName,
RouteInfoName = m.RouteInfo.MarkPoints,
m.Remark,
m.CreatedTime,
m.CreatorUserId,
m.LastUpdatedTime,
m.LastUpdatorUserId,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "读取AGV任务信息列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "读取AGV任务信息列表数据失败！" + ex.ToString())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(DisTaskDispatchInfoContract.DisTaskDispatchInfos, m => new
{
m.Id,
DisStepAction_Id = m.DisStepAction.Id,
DisStepActionName = m.DisStepAction.StepActionName,
DisStepActionCode = m.DisStepAction.StepActionCode,
m.TaskCode,
m.TaskResult,
m.FinishTime,
m.Description,
//ItemCount = DisTaskDispatchItemInfoContract.DisTaskDispatchItemInfos.Count(m2 => m2.DisStepTeachingTaskDispatch.Id == m.Id),
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 IHttpActionResult GetEntProductionLineInfoList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(EntProductionLineInfoContract.EntProductionLineInfo, m => new
{
m.Id,
m.ProductionLineName,
m.ProductionLineCode,
m.Duration,
m.DurationUnit,
DurationUnitName = m.DurationUnit == 3 ? "秒" : "分钟",
EntArea_Id = m.EntArea.Id,
m.EntArea.AreaName,
Enterprise_Id = m.EntArea.EntSite.Enterprise.Id,
m.EntArea.EntSite.Enterprise.EnterpriseName,
EntSite_Id = m.EntArea.EntSite.Id,
m.EntArea.EntSite.SiteName,
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())));
}
}
public IHttpActionResult GetProManufacturingBillInfoList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(ProManufacturingBillInfoContract.ProManufacturingBillInfos, m => new
{
m.Id,
m.BillName,
m.BillCode,
m.BillType,
BillTypeName = m.BillType == 1 ? "BOM" : "BOR",
Product_Id = m.Product.Id,
m.Product.ProductName,
m.Product.ProductCode,
ProductionRule_Id = m.ProductionRule.Id,
m.ProductionRule.ProductionRuleName,
m.ProductionRule.ProductionRuleVersion,
ProductionRuleStatus_Id = m.ProductionRule.ProductionRuleStatus.Id,
m.ProductionRule.ProductionRuleStatus.ProductionRuleStatusCode,
m.ProductionRule.ProductionRuleStatus.ProductionRuleStatusName,
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())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(RoadInfoContract.RoadInfos, m => new
{
m.Id,
m.RoadNo,
m.RoadName,
m.Distance,
m.RoadStatus,
StartMarkPointInfo_Id = m.StartMarkPointInfo.Id,
EndMarkPointInfo_Id = m.EndMarkPointInfo.Id,
StartMarkPointInfoName = m.StartMarkPointInfo.MarkPointName,
EndMarkPointInfoName = m.EndMarkPointInfo.MarkPointName,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(PlanEquipmentRequirementInfoContract.PlanEquipmentRequirementInfos, m => new
{
m.Id,
ProcessRequirementID = m.ProductionProcessRequirement.Id,
ProductionProcess_Id = m.ProductionProcessRequirement.ProductionProcess.Id,
m.ProductionProcessRequirement.ProductionProcess.ProductionProcessName,
m.ProductionProcessRequirement.ProductionProcess.ProductionProcessCode,
Equipment_Id = m.Equipment.Id,
m.Equipment.EquipmentName,
m.Equipment.EquipmentCode,
ProductionRule_Id = m.ProductionProcessRequirement.ProductionSchedule.ProductionRule.Id,
m.ProductionProcessRequirement.ProductionSchedule.ProductionRule.ProductionRuleName,
m.ProductionProcessRequirement.ProductionSchedule.ProductionRule.ProductionRuleVersion,
m.ProductionProcessRequirement.ProductionSchedule.ProductionRule.ProductionRuleStatus.ProductionRuleStatusName,
m.RequireQuantity,
m.ActualQuantity,
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())));
}
}
public IHttpActionResult GetProductionRuleItemInfoList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(ProductionRuleItemInfoContract.ProductionRuleItemInfos, m => new
{
m.Id,
ProductionRule_Id = m.ProductionRule.Id,
m.ProductionRule.ProductionRuleName,
m.ProductionRule.ProductionRuleVersion,
ProductionProcess_Id = m.ProductionProcess.Id,
m.ProductionProcess.ProductionProcessName,
m.ProductionProcess.ProductionProcessCode,
m.ProductionProcessOrder,
m.Duration,
m.DurationUnit,
DurationUnitName = m.DurationUnit == 3 ? "秒" : "分钟",
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(UserManager.Users, m => new
{
m.Id,
m.UserName,
m.NickName,
Password = m.PasswordHash,
m.Email,
m.EmailConfirmed,
m.PhoneNumber,
m.PhoneNumberConfirmed,
m.LockoutEndDateUtc,
m.AccessFailedCount,
m.IsLocked,
m.CreatedTime
}, request);
return(Json(new OperationResult(OperationResultType.Success, "查询用户数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "查询用户数据失败！" + ex.ToString())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(AgvInfoContract.AgvInfos, m => new
{
m.Id,
m.CarNo,
m.CarName,
m.AreaId,
m.ProductLineId,
m.SettingSpeed,
m.Priority,
m.AlarmPowerLevel,
m.Remark,
m.CreatedTime,
m.CreatorUserId,
m.LastUpdatedTime,
m.LastUpdatorUserId,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "读取Agv信息列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "读取Agv信息列表数据失败！" + ex.ToString())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(PlanOrderInfoContract.PlanOrderInfos, m => new
{
m.Id,
m.OrderName,
m.OrderCode,
m.Procurement,
m.ProcurePhone,
m.DeliveryTime,
m.ExpectedFinishTime,
m.ActualStartTime,
m.ActualFinishTime,
m.DeliverAddress,
m.OrderState,
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())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(TaskDetailedInfoContract.TaskDetailedInfos, m => new
{
m.Id,
m.Quantity,
TaskInfo_Id = m.TaskInfo.Id,
m.TaskInfo.TaskName,
Material_Id = m.Material.Id,
m.Material.MaterialName,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(IdentityContract.Roles, m => new
{
m.Id,
m.Name,
m.Remark,
m.IsAdmin,
m.IsSystem,
m.IsDefault,
m.IsLocked,
m.CreatedTime,
OrganizationId = m.Organization == null ? 0 : m.Organization.Id,
OrganizationName = m.Organization.Name,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "查询角色数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "查询角色数据失败！" + ex.ToString())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(DisTaskDispatchItemInfoContract.DisTaskDispatchItemInfos, m => new
{
m.Id,
DisStepTeachingTaskDispatch_Id = m.DisStepTeachingTaskDispatch.Id,
Equipment_Id = m.Equipment.Id,
m.Equipment.EquipmentName,
m.Equipment.EquipmentCode,
EquipmentAction_Id = m.EquipmentAction.Id,
//m.EquipmentAction.EquipmentActionName,
//m.EquipmentAction.EquipmentActionCode,
m.ActionOrder,
m.TaskItemCode,
m.TaskItemResult,
m.FinishTime,
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())));
}
}
public IHttpActionResult GetEntSiteList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(EntSiteInfoContract.EntSiteInfo, m => new
{
m.Id,
m.SiteName,
m.SiteCode,
m.SitePhone,
m.SiteManager,
Enterprise_Id = m.Enterprise.Id,
m.Enterprise.EnterpriseName,
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())));
}
}
public IHttpActionResult PageData1(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(MaterialInfoContract.MaterialInfos.Where(m => m.MaterialType == 1), m => new
{
m.Id,
m.MaterialCode,
m.MaterialName,
m.MaterialType,
m.MaterialUnit,
m.FullPalletQuantity,
m.Specification,
m.UnitWeight,
m.MaxStock,
m.MinStock,
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())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(PlanOrderItemInfoContract.PlanOrderItemInfos, m => new
{
m.Id,
Order_Id = m.Order.Id,
m.Order.OrderName,
m.Order.OrderCode,
Product_Id = m.Product.Id,
m.Product.ProductName,
m.Product.ProductCode,
m.OrderItemName,
m.OrderItemCode,
m.OrderQuantity,
m.RemainQuantity,
m.ProductUnit,
m.OrderState,
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())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(MarkPointInfoContract.MarkPointInfos, m => new
{
m.Id,
m.MarkPointNo,
m.MarkPointName,
m.AreaId,
m.ProductLineId,
m.X,
m.Y,
m.IsVirtualMarkPoint,
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 IHttpActionResult GetEntWorkAttendanceRecordList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(EntWorkAttendanceRecordInfoContract.EntWorkAttendanceRecordInfos, m => new
{
m.Id,
m.EntEmployeeInfo.EntEmployeeCode,
m.EntEmployeeInfo.EntEmployeeName,
EntEmployeeID = m.EntEmployeeInfo.Id,
m.AttendanceDate,
m.StartTime,
m.EndTime,
m.Shifts,
m.LeaveType,
m.LeaveDuration,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(ClientRepository.Entities, m => new
{
m.Id,
m.Name,
m.OAuthClientType,
m.ClientId,
m.Url,
m.LogoUrl,
m.RedirectUrl,
m.RequireConsent,
m.AllowRememberConsent,
m.AllowClientCredentialsOnly,
m.IsLocked,
m.CreatedTime
}, request);
return(Json(new OperationResult(OperationResultType.Success, "查询客户端数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "查询客户端数据失败！" + ex.ToString())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(MatStorageMoveInfoContract.MatStorageMoveInfos, m => new
{
m.Id,
m.FromLocationID,
FromWareHouseLocationCode = MatWareHouseLocationInfoContract.MatWareHouseLocationInfos.Where(x => x.Id.ToString().Contains(m.FromLocationID.ToString())).Select(x => x.WareHouseLocationCode).FirstOrDefault(),
FromWareHouseLocationName = MatWareHouseLocationInfoContract.MatWareHouseLocationInfos.Where(x => x.Id.ToString().Contains(m.FromLocationID.ToString())).Select(x => x.WareHouseLocationName).FirstOrDefault(),
m.ToLocationID,
ToWareHouseLocationCode = MatWareHouseLocationInfoContract.MatWareHouseLocationInfos.Where(x => x.Id.ToString().Contains(m.ToLocationID.ToString())).Select(x => x.WareHouseLocationCode).FirstOrDefault(),
ToWareHouseLocationName = MatWareHouseLocationInfoContract.MatWareHouseLocationInfos.Where(x => x.Id.ToString().Contains(m.ToLocationID.ToString())).Select(x => x.WareHouseLocationName).FirstOrDefault(),
m.StorageMoveCode,
m.StorageMoveReason,
m.Operator,
m.StorageMoveState,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(DisStepActionProcessMapInfoContract.DisStepActionProcessMapInfos, m => new
{
m.Id,
// m.DisStepActionInfo_ID,
StepActionName = m.DisStepActionInfo.StepActionName,
StepActionCode = m.DisStepActionInfo.StepActionCode,
m.DisStepActionInfo,
ProductionProcessInfo_ID = m.ProductionProcessInfo.Id,
ProductionProcessName = m.ProductionProcessInfo.ProductionProcessName,
ProductionProcessCode = m.ProductionProcessInfo.ProductionProcessCode,
m.ProductionProcessInfo,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
string username = User.Identity.Name;
//User user = userManager.Users.Where(x => x.UserName.Equals(username)).FirstOrDefault();
//UserRoleMap userRoleMap = UserRoleMapRepository.Entities.Where(x => x.User.Id == user.Id).First();
//Role role = userRoleMap.Role;
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(EntDepartmentInfoContract.EntDepartmentInfos, m => new
{
m.Id,
m.DepartmentName,
m.DepartmentCode,
m.DepartmentFunction,
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())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(MatInventoryInfoContract.MatInventoryInfos, m => new
{
m.Id,
MatWareHouse_Id = m.MatWareHouse.Id,
WareHouseCode = m.MatWareHouse.WareHouseCode,
WareHouseName = m.MatWareHouse.WareHouseName,
m.InventoryType,
m.InventoryCode,
ItemCount = MatInventoryItemInfoContract.MatInventoryItemInfos.Count(m2 => m2.MatInventory.Id == m.Id),
m.Operator,
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 IHttpActionResult GridData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(CommOpcUaServerNodeMapContract.CommOpcUaServerNodeMapInfos, m => new
{
m.Id,
ServerId = m.OpcUaServer.Id,
m.OpcUaServer.ServerName,
m.OpcUaNode.NodeName,
m.OpcUaNode.NodeUrl,
m.OpcUaNode.Interval,
m.OpcUaNode.Description,
m.OpcUaNode.CreatedTime,
m.OpcUaNode.CreatorUserId,
m.OpcUaNode.LastUpdatedTime,
m.OpcUaNode.LastUpdatorUserId,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "查询OpcUa服务器与通讯点关联数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "查询OpcUa服务器与通讯点关联数据失败！" + ex.ToString())));
}
}
public IHttpActionResult GetProductInfoList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(ProductInfoContract.ProductInfos, m => new
{
m.Id,
m.ProductName,
m.ProductCode,
ProductType_Id = m.ProductType.Id,
m.ProductType.ProductTypeName,
m.ProductType.ProductTypeCode,
m.Specification,
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())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(SecurityContract.Functions, m => new
{
m.Id,
m.Name,
m.Url,
m.FunctionType,
m.OperateLogEnabled,
m.DataLogEnabled,
m.CacheExpirationSeconds,
m.IsCacheSliding,
m.Area,
m.Controller,
m.Action,
m.IsController,
m.IsAjax,
m.IsChild,
m.IsLocked,
m.IsTypeChanged,
m.IsCustom
}, request);
return(Json(new OperationResult(OperationResultType.Success, "查询功能数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "查询功能数据失败！" + ex.ToString())));
}
}
public IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(DeviceServerInfoConract.DeviceServerInfos, m => new
{
m.Id,
m.DeviceServerName,
m.DeviceUrl,
m.DeviceDriveAssemblyName,
m.DeviceDriveClassName,
m.IsLocked,
m.Remark,
m.CreatorUserId,
m.CreatedTime,
m.LastUpdatorUserId,
m.LastUpdatedTime,
}, request);
return(Json(new OperationResult(OperationResultType.Success, "查询设备通讯服务器管理-列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "查询设备通讯服务器管理-列表数失败！" + ex.ToString())));
}
}
public IHttpActionResult GetEntTeamMapInfoList(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(EntTeamMapInfoContract.EntTeamMapInfos, m => new
{
m.Id,
m.EntEmployeeInfo,
m.EntTeamInfo,
EntTeamInfo_Id = m.EntTeamInfo.Id,
m.EntTeamInfo.TeamName,
m.EntTeamInfo.TeamCode,
EntEmployeeInfo_Id = m.EntEmployeeInfo.Id,
m.EntEmployeeInfo.EntEmployeeCode,
m.EntEmployeeInfo.EntEmployeeName,
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 IHttpActionResult PageData(PageRepuestParams requestParams)
{
try
{
GridRequest request = new GridRequest(requestParams);
var page = GetPageResult(EquRunningStateInfoContract.EquRunningStateInfos, m => new
{
m.Id,
EquipmentInfo_Id = m.Equipmentinfo.Id,
m.Equipmentinfo.EquipmentName,
m.Equipmentinfo.EquipmentCode,
m.EquRunningStateTypes,
m.FaultInfo,
m.FaultCode,
m.RunningStateTime,
m.CreatedTime,
m.CreatorUserId,
m.LastUpdatedTime,
m.LastUpdatorUserId,
m.Remark
}, request);
return(Json(new OperationResult(OperationResultType.Success, "读取设备运行状态信息列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "读取设备运行状态信息列表数据失败！" + ex.ToString())));
}
}
