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