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);
}
