498 Commits

Author SHA1 Message Date
1bdf8af02d Bug fix B2012-298 Error on past procedure before or after Added a MAXRECURSION statement to fix the problem.
Added “Copy Of” to new the procedure numbers when we copy and paste a procedure.
2012-11-09 20:39:35 +00:00
Rich
127a917e1e Added new property "Process Only In Location" to limit the datasets that are converted when "Only Process this Procedure Set" is false. 2012-11-05 21:56:10 +00:00
Rich
173dd85ccf Added "OPTION (MAXRECURSION 10000) to all recursive queries. Remove Change Manager stored procedure "getItemAuditsByItemID" 2012-11-05 21:55:27 +00:00
Rich
59b765e6d8 Added new property "Process Only In Location" to limit the datasets that are converted when "Only Process this Procedure Set" is false.
Save the RevDate from the SET.DBF file.
2012-11-05 21:54:31 +00:00
a319e2d487 If the RO.FST does not exist in the working draft folder, then grab it out of the RO folder 2012-10-31 18:42:50 +00:00
Rich
bbcb9c6935 Fixed search logic for empty search string. Improves performance.
Fixed logic to restore a deleted step.  If the first step is deleted and restored, the change manager fails.
Fixed numerous queries to give proper values if either the number or the number or the title is null.
Added testing examples to vefn_FixSearchString
2012-10-31 15:54:52 +00:00
Rich
2ae02cce49 Added logic to present a message if the "Load 16Bit Approval" fails due to missing data. 2012-10-31 15:54:02 +00:00
Rich
9ca05aa9e4 The rev number is being brought in as is and the Revision Date is being taken from the procedure set file.
Added limits to the process to Create Approved data, so that errors will not occur when processing a zipped Approved set.
2012-10-31 15:53:31 +00:00
62334a105d 2012-10-30 14:14:23 +00:00
1a65b51312 fixed syntax error 2012-10-26 14:38:22 +00:00
75ee5c4141 2012-10-26 10:13:05 +00:00
29f2d79fed include copyright notice for each stored procedure, function, and trigger
added VEREV3PI “WOG - Emergency Response Guidelines Rev. 2 for NSP”
2012-10-25 18:47:22 +00:00
Rich
eed947c044 PROMSFixes.Sql - Changed logic in Stored Procedures and functions to Properly format PATH when the Procedure Number includes a Decimal Point
vefn_SiblingAndChildrenItems
	vesp_SearchItemAndChildren
	vesp_GetROUsagesByProcedure
	vesp_SearchROItemAndChildren
	vefn_SiblingAndChildrenItemsByProc
	Removed duplicate vesp_SearchROItemAndChildren
2012-10-25 17:04:23 +00:00
c5e45bbe3f Bug fix B2012-270, GoTo button in PROMS could not find RO Table for viewing in the RO Editor 2012-10-24 16:08:34 +00:00
05713fc653 2012-10-08 16:43:00 +00:00
314046cd77 2012-10-04 11:11:06 +00:00
Rich
d1e10d79c2 Improved RO Search Performance
Improved Annotation Search Performance
Changed SQL to always do a drop and create rather than an ALTER
Changed SQL to always give a status after a CREATE
2012-09-28 18:40:57 +00:00
e8033fe6d4 2012-09-27 10:26:36 +00:00
cf599335a2 - added stored procedure for use in creating RO Usage Reports 2012-09-13 19:53:05 +00:00
f8040e9a52 2012-09-12 12:59:25 +00:00
99b6a97fd3 2012-09-12 12:58:40 +00:00
aeb64e2479 2012-09-12 12:56:00 +00:00
Rich
9ca49944e3 Cache ROImages so they only have to be read once.
Added Page Number to DebugText.txt when printing.
2012-08-14 16:23:06 +00:00
74b17eb481 2012-08-10 10:39:02 +00:00
68f3e7a0bb 2012-08-08 12:22:14 +00:00
Rich
32e9b47dae Use threading to keep MSWord hangs from hanging the conversion process
Fix logic where RichTextBox 4.1 is used to convert RTF text to a word document
2012-08-07 17:44:46 +00:00
Rich
0e66393289 RichTextBox Processing
Output Config Info for Steps
2012-08-07 17:44:03 +00:00
a13b6a7745 2012-08-01 11:17:00 +00:00
Rich
46385cfa07 Fixed relative location logic to work with absolute locations 2012-07-26 14:15:15 +00:00
Rich
68d862f71f Set the Error Log file name to include the name of the database and the current date and time
Save and Restore the setting to create Red PDFs from MSWORD
Show the total Process Time for the Complete Process
For individual Phases allow the user to decide if they want backups to be created
Set the Database connection string from the settings for individual phases
Handle null condition so that the code doesn't bomb
Handle relative RO paths in the Proc.INI file
Correct the total Step Count by subtracting the number of Sections
2012-07-25 21:40:56 +00:00
Rich
bf9985110a Read and Save MSWord documents with RichTextBox before they are opened in word to reduce manual fixes to accessory pages
Added logic to replace sbkpage, sect, and sectd RTF tokens.
Use one RichTextBox to process text since RichTextBoxes are not released if the RTF value is set
2012-07-25 21:39:01 +00:00
Rich
872ce3286e Show processing time from beginning
Hide Section and Step Progress when just processing Procedures
Add a Progress Bar for Formats
Add backup after individual phases
Adjusted status labels to show processed/total counts
Adjusted size of labels to allow for processed/total counts
Use flag to control if Sections and Steps are shown in progress
Reset Step count when going to a new procedure
Eliminate reset of Step by Section
Add a total count to events to setup progress bar
2012-07-16 17:34:32 +00:00
Rich
7bcfafcc8b Move frmErrors when frmLoader is moved
Shutoff SpellCheck for StepRTB
Use using for temporary StepRTB
Use using for vlnFlexGrid
Added debug output to track StepRTBs and vlnFlexGrids in memory
Limit bottom margin to 0 or above
Dispose of roImage after it is done being used
Dispose of Figure after it is done being used.
Use GetJustRODB so that images are not loaded.
Added ErrorHandler if annotation is deleted after a search
Track create, dispose and finalize
Add static variable to control if SpellCheck is used
Use using for temporary StepRTB
Lazy Load SelectionStack
Clean-up on Dispose
Track create, dispose and finalize
Make MyCopyInfo Lazy Loaded
Use using for temporary StepRTB
Add Dispose method for TableCellEditor
Cleanup on Dispose
Only kill MSWord instances that are invisible
2012-07-13 18:34:57 +00:00
c64ab64568 commented out debug variable 2012-07-12 13:06:30 +00:00
2876f37d2f Default LPI to 6 if none specified in the 16bit data. 2012-07-03 15:53:46 +00:00
b405d88a83 Fixed problem where the sub-formats this was introduced with a fix for a procedure in the Wolf Creek SYS set. 2012-06-27 14:04:51 +00:00
db83de84d8 2012-06-27 13:23:54 +00:00
8ae78444ab 2012-06-26 15:14:40 +00:00
46b11369e6 2012-06-14 13:03:01 +00:00
Rich
0046c61c34 Eliminate an unnecessary save to the clipboard
Name Working Draft DocVersion "Working Draft"
Add XML files to comparison
2012-06-13 15:14:28 +00:00
Rich
dc7ed2ea5c Moved from Volian.Utils.Library directly into DataLoader
Added WCN CAP folder
2012-06-13 14:25:22 +00:00
136a023564 2012-06-11 16:20:03 +00:00
Rich
9b7a8ee6fa Show Memory use to before and after LibDocs
Remove unnecessary debug output
2012-06-08 18:11:54 +00:00
7211bebdbe 2012-06-08 13:09:23 +00:00
2b56e285c2 2012-06-08 13:07:59 +00:00
bd0c8e2157 2012-06-04 12:39:26 +00:00
f5378a0f27 Fixes a bug in importing the 16-bit Approved PDF files. We were not handling invalid (and null) dates when reading through the list of approved procedures (from the SET.dbf file).
If an invalid date is found, the current date is used instead – copied existing logic we have in other places of the DataLoader.
2012-05-31 16:18:44 +00:00
Rich
9f45759050 Reduced memory usage
Add Memory Usage summary to the log file.
GetJustFormat to reduce memory use
Fix code so that children are not disposed while they are being used
Added new method GetJustFormat to reduce memory use
Fix logic so that content is not used after it is disposed
Verify that Content object is not disposed before using Text
Dispose of parts when Content object is disposed
Verify that ContentInfo object is not disposed before using Text
Dispose of parts when ContentInfo object is disposed
Place brackets around DB names to support names containing periods.
Dispose of parts when Item object is disposed
Removed inapproriate Dispose in MakeItem
Dispose of parts when ItemInfo object is disposed
Remove event handler when ItemInfoList object is disposed
Dispose of parts when Transtion object is disposed
Dispose of parts when ZTransition object is disposed
2012-05-29 18:02:17 +00:00
Rich
f5544b7053 Add separate counts for Errors, Warnings and Information
Cleanup memory after transition processing
Adjusted width of Error Count
Added memory usage to output
Added Stored Procedure GetJustFormat
Reduce Memory Use
Removed extra using statement
2012-05-21 13:30:21 +00:00
Rich
508a86a8ac Added memory usage to output
Add separate counts for Errors, Warnings and Information
2012-05-21 13:27:44 +00:00