public List <OEE_MachineDailyDownRecordDTO> GetDTTimeInfo(OEEFourQParamModel searchModel)
{
var query = from downRecord in DataContext.OEE_MachineDailyDownRecord
where downRecord.BG_Organization_UID == searchModel.BG_Organization_UID &&
downRecord.Plant_Organization_UID == searchModel.Plant_Organization_UID &&
downRecord.StationID == searchModel.StationID &&
downRecord.OEE_MachineInfo_UID == searchModel.OEE_MachineInfo_UID &&
downRecord.OEE_DownTimeCode.Is_Enable == true
select new OEE_MachineDailyDownRecordDTO()
{
Plant_Organization_UID = downRecord.Plant_Organization_UID,
BG_Organization_UID = downRecord.BG_Organization_UID,
FunPlant_Organization_UID = downRecord.FunPlant_Organization_UID,
StationID = downRecord.StationID,
OEE_MachineInfo_UID = downRecord.OEE_MachineInfo_UID,
OEE_DownTimeCode_UID = downRecord.OEE_DownTimeCode_UID,
DownDate = downRecord.DownDate,
ShiftTimeID = downRecord.ShiftTimeID,
StartTime = downRecord.StartTime,
EndTIme = downRecord.EndTIme,
DownTime = downRecord.DownTime,
Is_Enable = downRecord.OEE_DownTimeCode.Is_Enable,
Type_Name = downRecord.OEE_DownTimeCode.OEE_DownTimeType.Type_Name,
OEE_DownTimeType_UID = downRecord.OEE_DownTimeCode.OEE_DownTimeType.OEE_DownTimeType_UID
};
query = query.Where(p => p.DownDate >= searchModel.StartTime && p.DownDate <= searchModel.EndTime);
return(query.ToList());
}
public PagedListModel <OEE_ImprovementPlanDTO> QueryActionInfoByCreateDate(OEEFourQParamModel serchModel, Page page)
{
var query = from improvementPlan in DataContext.OEE_ImprovementPlan
where improvementPlan.Plant_Organization_UID == serchModel.Plant_Organization_UID &&
improvementPlan.BG_Organization_UID == serchModel.BG_Organization_UID &&
improvementPlan.StationID == serchModel.StationID &&
improvementPlan.OEE_MachineInfo_UID == serchModel.OEE_MachineInfo_UID
select new OEE_ImprovementPlanDTO
{
ImprovementPlan_UID = improvementPlan.ImprovementPlan_UID
,
Plant_Organization_UID = improvementPlan.Plant_Organization_UID
,
Plant_Organization_Name = improvementPlan.System_Organization2.Organization_Name
,
BG_Organization_UID = improvementPlan.BG_Organization_UID
,
BG_Organization_Name = improvementPlan.System_Organization1.Organization_Name,
FunPlant_Organization_UID = improvementPlan.FunPlant_Organization_UID
,
FunPlant_Organization_Name = improvementPlan.System_Organization.Organization_Name,
Project_UID = improvementPlan.Project_UID
,
ProjectName = improvementPlan.GL_Line.System_Project.Project_Name,
LineID = improvementPlan.LineID
,
LineName = improvementPlan.GL_Line.LineName,
StationID = improvementPlan.StationID
,
StationName = improvementPlan.GL_Station.StationName,
OEE_MachineInfo_UID = improvementPlan.OEE_MachineInfo_UID
,
MeetingType_UID = improvementPlan.MeetingType_UID
,
MachineName = improvementPlan.OEE_MachineInfo.MachineNo,
ImprovementPlan_ID = improvementPlan.ImprovementPlan_ID
,
ImprovementPlan_Name = improvementPlan.ImprovementPlan_Name
,
Audience = improvementPlan.Audience
,
Responsible = improvementPlan.Responsible
,
Status = improvementPlan.Status
,
Commit_Date = improvementPlan.Commit_Date
,
Due_Date = improvementPlan.Due_Date
,
Close_Date = improvementPlan.Close_Date
,
Created_UID = improvementPlan.Created_UID
,
Created_Date = improvementPlan.Created_Date
,
Problem_Description = improvementPlan.Problem_Description
,
Root_Cause = improvementPlan.Root_Cause
,
CACP_Description = improvementPlan.CACP_Description
,
Comment = improvementPlan.Comment
,
Modified_UID = improvementPlan.Modified_UID
,
Modified_Date = improvementPlan.Modified_Date
,
Attachment1 = improvementPlan.Attachment1
,
Attachment6 = improvementPlan.Attachment6
,
Attachment2 = improvementPlan.Attachment2
,
Attachment4 = improvementPlan.Attachment4
,
Attachment5 = improvementPlan.Attachment5
,
DirDueDate = improvementPlan.DirDueDate
};
var startDate = Convert.ToDateTime(serchModel.ActionCreateData.ToString("yyyy-MM-dd 00:00:00"));
var endDate = Convert.ToDateTime(serchModel.ActionCreateData.ToString("yyyy-MM-dd 23:59:59"));
query = query.Where(p => p.Created_Date >= startDate && p.Created_Date <= endDate);
var totalCount = query.Count();
query = query.OrderByDescending(m => m.Modified_Date).GetPage(page);
return(new PagedListModel <OEE_ImprovementPlanDTO>(totalCount, query.ToList()));
}
