public IQueryable <OEE_DownTimeCodeDTO> QueryOEE_DownTimeCodes(OEE_DownTimeCodeDTO searchModel, Page page, out int totalcount)
{
var query = (from M in DataContext.OEE_DownTimeCode
where M.GL_Line.IsEnabled == true && M.GL_Station.IsEnabled == true
select new OEE_DownTimeCodeDTO
{
OEE_DownTimeCode_UID = M.OEE_DownTimeCode_UID,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID,
OEE_DownTimeType_UID = M.OEE_DownTimeType_UID,
Project_UID = M.Project_UID,
LineID = M.LineID,
StationID = M.StationID,
Error_Code = M.Error_Code,
Upload_Ways = M.Upload_Ways,
Level_Details = M.Level_Details,
Error_Reasons = M.Error_Reasons,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Modify_UID = M.Modify_UID,
Modify_Date = M.Modify_Date,
Plant_Organization_Name = M.System_Organization.Organization_Name,
BG_Organization_Name = M.System_Organization1.Organization_Name,
FunPlant_Organization_Name = M.System_Organization2.Organization_Name,
EnumDownTimeCodeType = M.OEE_DownTimeType.Type_Name,
ProjectName = M.System_Project.Project_Name,
LineName = M.GL_Line.LineName,
StationName = M.GL_Station.StationName,
Modifyer = M.System_Users.User_Name
}).Union(
from M in DataContext.OEE_DownTimeCode
where M.GL_Line.IsEnabled == true && M.GL_Station.IsEnabled != true
select new OEE_DownTimeCodeDTO
{
OEE_DownTimeCode_UID = M.OEE_DownTimeCode_UID,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID,
OEE_DownTimeType_UID = M.OEE_DownTimeType_UID,
Project_UID = M.Project_UID,
LineID = M.LineID,
StationID = M.StationID,
Error_Code = M.Error_Code,
Upload_Ways = M.Upload_Ways,
Level_Details = M.Level_Details,
Error_Reasons = M.Error_Reasons,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Modify_UID = M.Modify_UID,
Modify_Date = M.Modify_Date,
Plant_Organization_Name = M.System_Organization.Organization_Name,
BG_Organization_Name = M.System_Organization1.Organization_Name,
FunPlant_Organization_Name = M.System_Organization2.Organization_Name,
EnumDownTimeCodeType = M.OEE_DownTimeType.Type_Name,
ProjectName = M.System_Project.Project_Name,
LineName = M.GL_Line.LineName,
StationName = M.GL_Station.StationName,
Modifyer = M.System_Users.User_Name
}).Union(
from M in DataContext.OEE_DownTimeCode
where M.GL_Line == null && M.GL_Station == null
select new OEE_DownTimeCodeDTO
{
OEE_DownTimeCode_UID = M.OEE_DownTimeCode_UID,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID,
OEE_DownTimeType_UID = M.OEE_DownTimeType_UID,
Project_UID = M.Project_UID,
LineID = M.LineID,
StationID = M.StationID,
Error_Code = M.Error_Code,
Upload_Ways = M.Upload_Ways,
Level_Details = M.Level_Details,
Error_Reasons = M.Error_Reasons,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Modify_UID = M.Modify_UID,
Modify_Date = M.Modify_Date,
Plant_Organization_Name = M.System_Organization.Organization_Name,
BG_Organization_Name = M.System_Organization1.Organization_Name,
FunPlant_Organization_Name = M.System_Organization2.Organization_Name,
EnumDownTimeCodeType = M.OEE_DownTimeType.Type_Name,
ProjectName = M.System_Project.Project_Name,
LineName = M.GL_Line.LineName,
StationName = M.GL_Station.StationName,
Modifyer = M.System_Users.User_Name
}
);
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 != 0 && searchModel.FunPlant_Organization_UID != null)
{
query = query.Where(m => m.FunPlant_Organization_UID == searchModel.FunPlant_Organization_UID);
}
if (searchModel.OEE_DownTimeType_UID != 0)
{
query = query.Where(m => m.OEE_DownTimeType_UID == searchModel.OEE_DownTimeType_UID);
}
if (searchModel.Project_UID != 0)
{
query = query.Where(m => m.Project_UID == searchModel.Project_UID);
}
if (searchModel.LineID != 0 && searchModel.LineID != null)
{
query = query.Where(m => m.LineID == searchModel.LineID);
}
if (searchModel.StationID != 0 && searchModel.StationID != null)
{
query = query.Where(m => m.StationID == searchModel.StationID);
}
if (!string.IsNullOrWhiteSpace(searchModel.Error_Code))
{
query = query.Where(m => m.Error_Code == searchModel.Error_Code);
}
if (!string.IsNullOrWhiteSpace(searchModel.Upload_Ways))
{
query = query.Where(m => m.Upload_Ways == searchModel.Upload_Ways);
}
if (!string.IsNullOrWhiteSpace(searchModel.Level_Details))
{
query = query.Where(m => m.Level_Details == searchModel.Level_Details);
}
if (!string.IsNullOrWhiteSpace(searchModel.Error_Reasons))
{
query = query.Where(m => m.Error_Reasons == searchModel.Error_Reasons);
}
if (!string.IsNullOrWhiteSpace(searchModel.Modifyer))
{
query = query.Where(m => m.Modifyer == searchModel.Modifyer);
}
//if (searchModel.Applicant_Date.Year != 1)
//{
// DateTime nextday = searchModel.Applicant_Date.AddDays(1);
// query = query.Where(m => m.Applicant_Date >= searchModel.Applicant_Date & m.Applicant_Date < nextday);
//}
//if (searchModel.Approver_Date.Year != 1)
//{
// DateTime nextday = searchModel.Approver_Date.AddDays(1);
// query = query.Where(m => m.Approver_Date >= searchModel.Approver_Date & m.Applicant_Date < nextday);
//}
if (searchModel.IsEnabled != null)
{
query = query.Where(m => m.Is_Enable == searchModel.IsEnabled);
}
//query = query.Where(m => m.Is_Enable == searchModel.Is_Enable);
totalcount = query.Count();
query = query.OrderByDescending(m => m.Modify_Date).GetPage(page);
return(query);
}
public IHttpActionResult QueryDownTimeCodeListAPI(OEE_DownTimeCodeDTO search)
{
var result = _OEE_Service.QueryDownTimeCodeList(search);
return(Ok(result));
}
public List <OEE_DownTimeCodeDTO> QueryDownTimeCodeList(OEE_DownTimeCodeDTO search)
{
var query = (from M in DataContext.OEE_DownTimeCode
where M.GL_Line.IsEnabled == true && M.GL_Station.IsEnabled == true
select new OEE_DownTimeCodeDTO
{
OEE_DownTimeCode_UID = M.OEE_DownTimeCode_UID,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID,
OEE_DownTimeType_UID = M.OEE_DownTimeType_UID,
Project_UID = M.Project_UID,
LineID = M.LineID,
StationID = M.StationID,
Error_Code = M.Error_Code,
Upload_Ways = M.Upload_Ways,
Level_Details = M.Level_Details,
Error_Reasons = M.Error_Reasons,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Modify_UID = M.Modify_UID,
Modify_Date = M.Modify_Date,
Plant_Organization_Name = M.System_Organization.Organization_Name,
BG_Organization_Name = M.System_Organization1.Organization_Name,
FunPlant_Organization_Name = M.System_Organization2.Organization_Name,
EnumDownTimeCodeType = M.OEE_DownTimeType.Type_Name,
ProjectName = M.System_Project.Project_Name,
LineName = M.GL_Line.LineName,
StationName = M.GL_Station.StationName,
Modifyer = M.System_Users.User_Name
}).Union(
from M in DataContext.OEE_DownTimeCode
where M.GL_Line.IsEnabled == true && M.GL_Station.IsEnabled != true
select new OEE_DownTimeCodeDTO
{
OEE_DownTimeCode_UID = M.OEE_DownTimeCode_UID,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID,
OEE_DownTimeType_UID = M.OEE_DownTimeType_UID,
Project_UID = M.Project_UID,
LineID = M.LineID,
StationID = M.StationID,
Error_Code = M.Error_Code,
Upload_Ways = M.Upload_Ways,
Level_Details = M.Level_Details,
Error_Reasons = M.Error_Reasons,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Modify_UID = M.Modify_UID,
Modify_Date = M.Modify_Date,
Plant_Organization_Name = M.System_Organization.Organization_Name,
BG_Organization_Name = M.System_Organization1.Organization_Name,
FunPlant_Organization_Name = M.System_Organization2.Organization_Name,
EnumDownTimeCodeType = M.OEE_DownTimeType.Type_Name,
ProjectName = M.System_Project.Project_Name,
LineName = M.GL_Line.LineName,
StationName = M.GL_Station.StationName,
Modifyer = M.System_Users.User_Name
}).Union(
from M in DataContext.OEE_DownTimeCode
where M.GL_Line == null && M.GL_Station == null
select new OEE_DownTimeCodeDTO
{
OEE_DownTimeCode_UID = M.OEE_DownTimeCode_UID,
Plant_Organization_UID = M.Plant_Organization_UID,
BG_Organization_UID = M.BG_Organization_UID,
FunPlant_Organization_UID = M.FunPlant_Organization_UID,
OEE_DownTimeType_UID = M.OEE_DownTimeType_UID,
Project_UID = M.Project_UID,
LineID = M.LineID,
StationID = M.StationID,
Error_Code = M.Error_Code,
Upload_Ways = M.Upload_Ways,
Level_Details = M.Level_Details,
Error_Reasons = M.Error_Reasons,
Remarks = M.Remarks,
Is_Enable = M.Is_Enable,
Modify_UID = M.Modify_UID,
Modify_Date = M.Modify_Date,
Plant_Organization_Name = M.System_Organization.Organization_Name,
BG_Organization_Name = M.System_Organization1.Organization_Name,
FunPlant_Organization_Name = M.System_Organization2.Organization_Name,
EnumDownTimeCodeType = M.OEE_DownTimeType.Type_Name,
ProjectName = M.System_Project.Project_Name,
LineName = M.GL_Line.LineName,
StationName = M.GL_Station.StationName,
Modifyer = M.System_Users.User_Name
}
);
if (search.Plant_Organization_UID != 0)
{
query = query.Where(m => m.Plant_Organization_UID == search.Plant_Organization_UID);
}
if (search.BG_Organization_UID != 0)
{
query = query.Where(m => m.BG_Organization_UID == search.BG_Organization_UID);
}
if (search.FunPlant_Organization_UID != 0 && search.FunPlant_Organization_UID != null)
{
query = query.Where(m => m.FunPlant_Organization_UID == search.FunPlant_Organization_UID);
}
if (search.OEE_DownTimeType_UID != 0)
{
query = query.Where(m => m.OEE_DownTimeType_UID == search.OEE_DownTimeType_UID);
}
if (search.Project_UID != 0)
{
query = query.Where(m => m.Project_UID == search.Project_UID);
}
if (search.LineID != 0 && search.LineID != null)
{
query = query.Where(m => m.LineID == search.LineID);
}
if (search.StationID != 0 && search.StationID != null)
{
query = query.Where(m => m.StationID == search.StationID);
}
if (!string.IsNullOrWhiteSpace(search.Error_Code))
{
query = query.Where(m => m.Error_Code == search.Error_Code);
}
if (!string.IsNullOrWhiteSpace(search.Upload_Ways))
{
query = query.Where(m => m.Upload_Ways == search.Upload_Ways);
}
if (!string.IsNullOrWhiteSpace(search.Level_Details))
{
query = query.Where(m => m.Level_Details == search.Level_Details);
}
if (!string.IsNullOrWhiteSpace(search.Error_Reasons))
{
query = query.Where(m => m.Error_Reasons == search.Error_Reasons);
}
if (search.IsEnabled != null)
{
query = query.Where(m => m.Is_Enable == search.IsEnabled);
}
query = query.OrderByDescending(m => m.Modify_Date);
return(query.ToList());
}
public string AddOrEditOEE_DownTimeCodeAPI(OEE_DownTimeCodeDTO dto, bool isEdit)
{
var result = _OEE_Service.AddOrEditOEE_DownTimeCode(dto, isEdit);
return(result);
}
