public PagedListModel <Machine_CustomerDTO> QueryMachine_CustomerInfo(Machine_CustomerDTO searchModel, Page page) { int totalcount; var result = machine_YieldRepository.QueryMachine_CustomerInfo(searchModel, page, out totalcount).ToList(); var bd = new PagedListModel <Machine_CustomerDTO>(totalcount, result); return(bd); }
/// <summary> /// 获取初始化列表数据 /// </summary> /// <param name="search"></param> /// <param name="page"></param> /// <returns></returns> public ActionResult QueryMachine_CustomerInfo(Machine_CustomerDTO search, Page page) { search.Plant_Organization_UID = GetPlantOrgUid(); var apiUrl = string.Format("MachineYieldReport/QueryMachine_CustomerInfoAPI"); var responMessage = APIHelper.APIPostAsync(search, page, apiUrl); var result = responMessage.Content.ReadAsStringAsync().Result; return(Content(result, "application/json")); }
public IQueryable <Machine_CustomerDTO> QueryMachine_CustomerInfo(Machine_CustomerDTO searchModel, Page page, out int totalcount) { var query = from machine_Customer in DataContext.Machine_Customer select new Machine_CustomerDTO { Machine_Customer_UID = machine_Customer.Machine_Customer_UID, MES_Customer_Name = machine_Customer.MES_Customer_Name, PIS_Customer_Name = machine_Customer.PIS_Customer_Name, Created_UID = machine_Customer.Created_UID, Created_Date = machine_Customer.Created_Date, Modified_UID = machine_Customer.Modified_UID, Modified_Date = machine_Customer.Modified_Date, Is_Enable = machine_Customer.Is_Enable, Plant_Organization_UID = machine_Customer.Plant_Organization_UID, BG_Organization_UID = machine_Customer.BG_Organization_UID, FunPlant_Organization_UID = machine_Customer.FunPlant_Organization_UID, Plant_Organization = machine_Customer.System_Organization.Organization_Name, BG_Organization = machine_Customer.System_Organization1.Organization_Name, FunPlant_Organization = machine_Customer.System_Organization2.Organization_Name, Createder = machine_Customer.System_Users.User_Name, Modifieder = machine_Customer.System_Users1.User_Name, DataSourceType = machine_Customer.DataSourceType }; if (searchModel.Plant_Organization_UID != 0) { query = query.Where(m => m.Plant_Organization_UID == searchModel.Plant_Organization_UID); } if (searchModel.BG_Organization_UID != 0) { query = query.Where(m => m.BG_Organization_UID == searchModel.BG_Organization_UID); } if (searchModel.FunPlant_Organization_UID != null && searchModel.FunPlant_Organization_UID != 0) { query = query.Where(m => m.FunPlant_Organization_UID == searchModel.FunPlant_Organization_UID); } if (!string.IsNullOrWhiteSpace(searchModel.MES_Customer_Name)) { query = query.Where(m => m.MES_Customer_Name == searchModel.MES_Customer_Name); } if (!string.IsNullOrWhiteSpace(searchModel.PIS_Customer_Name)) { query = query.Where(m => m.PIS_Customer_Name == searchModel.PIS_Customer_Name); } if (searchModel.Is_Enable != null) { query = query.Where(m => m.Is_Enable == searchModel.Is_Enable); } if (searchModel.DataSourceType != null) { query = query.Where(m => m.DataSourceType == searchModel.DataSourceType); } totalcount = query.Count(); query = query.OrderByDescending(m => m.Modified_Date).GetPage(page); return(query); }