private void InitializeManualCode() { Type DataTableType; DataTable CacheRegionDT = TDataCache.GetCacheableDataTableFromCache("PostcodeRegionList", String.Empty, null, out DataTableType); DataTable CacheRegionRangeDT = TDataCache.GetCacheableDataTableFromCache("PostcodeRegionRangeList", String.Empty, null, out DataTableType); PPostcodeRangeTable RangeTable = (PPostcodeRangeTable)TDataCache.GetCacheableDataTableFromCache("PostcodeRangeList", String.Empty, null, out DataTableType); FMainDS.PPostcodeRegion.Merge(CacheRegionDT); FMainDS.PPostcodeRegionRange.Merge(CacheRegionRangeDT); foreach (PostcodeRegionsTDSPPostcodeRegionRangeRow Row in FMainDS.PPostcodeRegionRange.Rows) { PPostcodeRangeRow RangeRow = (PPostcodeRangeRow)RangeTable.Rows.Find(new object[] { Row.Range }); Row.From = RangeRow.From; Row.To = RangeRow.To; } FMainDS.AcceptChanges(); FPetraUtilsObject.ApplySecurity(TSecurityChecks.SecurityPermissionsSetupScreensEditingAndSaving); }
private void NewRowManual(ref PPostcodeRangeRow ARow) { string NewName = Catalog.GetString("NEWRANGE"); int CountNewDetail = 0; if (FMainDS.PPostcodeRange.Rows.Find(new object[] { NewName }) != null) { while (FMainDS.PPostcodeRange.Rows.Find(new object[] { NewName + CountNewDetail.ToString() }) != null) { CountNewDetail++; } NewName += CountNewDetail.ToString(); } ARow.Range = NewName; }
private void InitializeManualCode() { Type DataTableType; DataTable CacheRegionDT = TDataCache.GetCacheableDataTableFromCache("PostcodeRegionList", String.Empty, null, out DataTableType); DataTable CacheRegionRangeDT = TDataCache.GetCacheableDataTableFromCache("PostcodeRegionRangeList", String.Empty, null, out DataTableType); PPostcodeRangeTable RangeTable = (PPostcodeRangeTable)TDataCache.GetCacheableDataTableFromCache("PostcodeRangeList", String.Empty, null, out DataTableType); FMainDS.PPostcodeRegion.Merge(CacheRegionDT); FMainDS.PPostcodeRegionRange.Merge(CacheRegionRangeDT); foreach (PostcodeRegionsTDSPPostcodeRegionRangeRow Row in FMainDS.PPostcodeRegionRange.Rows) { PPostcodeRangeRow RangeRow = (PPostcodeRangeRow)RangeTable.Rows.Find(new object[] { Row.Range }); Row.From = RangeRow.From; Row.To = RangeRow.To; } FMainDS.AcceptChanges(); }