注意事项： 1、请注意正确理解需求，免得做无用功。 2、交货时需提供源代码和MSSQL的脚本。 3、最晚周五交货 Task # 1: Create a new C # Console project (a project without a user interface) called ParkwayPatientRegistryAllScriptsExporter. Create a method in this program called ParseAllergies that takes a file name as a parameter. This method should parse a file in the format of the "SampleData_Allergies.csv" file that I'm attaching. Below are examples of the first three records that should be extracted - and note that they come from a single row of data even though in this case they should be three separate inserted records. And each of these should be inserted into a SQL Server database table that you create. You can call the database "Parkway" and the table can be called "Allergies". *** And here is the specific logic to use when parsing: First, locate the keyword "Numerator". After finding that in the file, start parsing everything under that line (don't parse anything above that location within the file; only all the data that comes below "Numerator"). Also, ignore the row that has column names like "Patient Name", etc. For the rows that you parse for data, look for each of these key words: "Drug Classes : " and "Medispan Drug : ". If a row doesn't have either of these key words then skip that row. If a row does have at least one of these key words then parse the data that comes after each key word to get the allergy description value (some rows may have more than one and in that case each should be a separate record to insert in the database). Also, for each record that you get the allergy description for, also parse the last name and the first name (not the middle initial). Then insert these three fields in the database for each record. I think this should make sense when you look at the attached example combined with this email. record # 1: lastName: Lackney firstName: Daniel allergyDescription: Sulfa Drugs record # 2: lastName: Lackney firstName: Daniel allergyDescription: Codeine Phosphate *ANALGESICS - OPIOID* record # 3: lastName: Lackney firstName: Daniel allergyDescription: TraMADol HCl *ANALGESICS - OPIOID*" Task # 2: Create a new method in this same program called ParseDiagnosis. This method should also take a file name as a parameter. This method should parse a file in the format of the "SampleData_Diagnosis.csv" file that I'm attaching. Below are examples of the first two records that should be extracted - and note that they come from a single row of data even though in this case they should be two separate inserted records. And each of these should be inserted into a SQL Server database table that you create. You can call the table "Diagnosis". *** And here is the specific logic to use when parsing: First, locate the keyword "Numerator". After finding that in the file, start parsing everything under that line (don't parse anything above that location within the file; only all the data that comes below "Numerator"). Also, ignore the row that has column names like "Patient Name", etc. For the rows that you parse for data, look for parenthesis and specifically only numeric characters or a period within parenthesis. If you don't find any of those within a particular row then ignore that row. Also, each row can contain more than one of these diagnosis code values within parenthesis and if there is more than one then each should result in a separate record to be inserted into the table. Also, one other bit of logic is that if the same row has more than one of the same code values then don't insert duplicates (the example below actually had more than one 244.9 value in that same row but this should not be duplicated in the database). Also, for each record that you get the diagnosis code for, also parse the last name and the first name (not the middle initial) and also the diagnosis date. Then insert these four fields in the database for each record. I think this should make sense when you look at the attached example combined with this email. record # 1: lastName: Adamson firstName: Margaret Diagnosis Code: 244.9 Diagnosis Date: 5/12/2014 record # 2: lastName: Adamson firstName: Margaret Diagnosis Code: 401.1 Diagnosis Date: 5/12/2014
2019-09-22 10:09:00