public DataTable GetMaintenanceDecisionsForRegionSurroundingSections(int regionID, int surveyNum) { if (regionID == 0) { return(new DataTable()); } string regionNum = region.GetRegionNum(regionID); // MAINTE_DECI string sql = string.Format("SELECT * FROM VW_MAINT_DEC_IRI_LSAMPLES where SECTION_NO like '{0}%' and SURVEY_NO={1} ORDER BY SECTION_NO, LANE_TYPE, SAMPLE_NO ", regionNum, surveyNum); return(db.ExecuteQuery(sql)); }
public DataTable GetMaintenancePrioritiesForSectionSurroundingRegionReport(int regionID, bool udiDesc, bool udiAsc, bool priority) { string regionNum = region.GetRegionNum(regionID); string orderByPart = GetOrderByPriorityPart(udiDesc, udiAsc, priority); //string surveypart = string.Format("and SURVEY_NO=(select max(survey_no) from VW_MAINT_PRIO_LANES where section_no like '{0}%') ", regionNum); string sql = string.Format("select * from VW_LATEST_PRIO_LANES where SECTION_ID is not null and section_no like '{0}%' {1} ", regionNum, orderByPart); return(db.ExecuteQuery(sql)); }
public DataTable GetRegionSurroundingSectionsMaintenanceDecisions(int regionID, int surveyNum, bool details, bool notMaintOrders) { string sql = ""; string notInMaintOrdersPart = notMaintOrders ? " and section_id not in (select SECTION_ID from MAINTAIN_ORDER_DET_LOCS where SECTION_ID is not null) " : ""; string regionNum = region.GetRegionNum(regionID); if (details) { if (regionID == 0) { return(new DataTable()); } sql = string.Format("select * from VW_SECTIONS_MAINT_COST where section_no like '{0}%' and SURVEY_NO={1} {2} order by arname, section_no, lane_type ", regionNum, surveyNum, notInMaintOrdersPart); } else { sql = string.Format("select * from VW_SECTIONS_MAINT_COST_SUMMARY where survey_no={0} and section_no like '{1}%' {2} order by arname ", surveyNum, regionNum, notInMaintOrdersPart); } return(db.ExecuteQuery(sql)); }