Пример #1
0
        private static void checkDateInOut(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var invalidUsl = (from u in bill.Reestr.USL where u.Kol_Usl == 1
                                 && u.Date_In != u.Date_Out
                                 && !(u.CODE_USL.StartsWith("0100") || u.CODE_USL.StartsWith("1000"))
                                 && !(u.IsFullStationar || u.IsDayStationar) select u).ToList();
            if(invalidUsl.Any())
            {
                context.ReportError(@"Даты начала и окончания услуги не равны при количестве = 1");
                invalidUsl.ForEach(x => context.ReportProgress(@"    -> {0}", x));
            }
        }
Пример #2
0
        public static void ValidateBills(IBackgroundContext context, LpuExecParams executorParams)
        {
            if (context.CancellationPending) return;

            context.ProgressSeparator();
            context.ReportProgress(@"ПРОВЕРКА СЧЕТОВ");
            context.ReportProgress("");
            using (var dataContext = new BillsValidatorDataContext())
            {
                var dir = Properties.Settings.Default.DataDir;
                dataContext.Load(context, dir, dir, dir);
                if (context.CancellationPending) return;
                foreach (var bill in dataContext.Bills.TakeWhile(x => !context.CancellationPending))
                {
                    validateBill(context, dataContext, bill);
                }
            }
            context.ProgressSeparator('-');
        }
Пример #3
0
        private static void checkForDoubleUsl(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var dupGroups = from u in bill.Reestr.USL
                            where !(u.CODE_USL.StartsWith("0090") || u.CODE_USL.StartsWith("1090") || u.CODE_USL.StartsWith("00184"))
                            group u by u.PacientRow.ID_PAC + " " + u.DATE_IN + " " + u.DATE_OUT + " " + u.CODE_USL
                            into g
                            where g.Count() > 1
                            select g;

            foreach (var dupGroup in dupGroups)
            {
                context.ReportError(@"Дублирование услуг");
                foreach (var uslRow in dupGroup)
                {
                    context.ReportProgress(@"    > {0}", uslRow);
                }
            }
        }
Пример #4
0
        private static void checkForCrossPeriods(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var fullStationar = (from u in bill.Reestr.USL where u.IsFullStationar select u).ToList();
            foreach (var usl in fullStationar.TakeWhile(x => !context.CancellationPending))
            {
                var stacUsl = usl;
                var crossUsl = (from c in bill.Reestr.USL
                               where c != stacUsl && c.PacientRow.PersRow == stacUsl.PacientRow.PersRow
                               && (new DateRange(c.Date_In, c.Date_Out)).Intersects(new DateRange(stacUsl.Date_In, stacUsl.Date_Out))
                               select c).ToList();
                crossUsl = crossUsl.Where(x => !x.IsFullStationar).ToList();
                if (crossUsl.Count > 0)
                {
                    context.ReportError(@" Оказание услуг во время нахождения в кругл.стационаре {0}", stacUsl.PacientRow.ToString());
                    context.ReportProgress(@"    Стац. {0}", stacUsl.ToShortString());
                    crossUsl.ForEach(x => context.ReportProgress(@"    -> {0}", x.ToShortString()));
                }
            }
        }
Пример #5
0
        private static void checkForExpertDs(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var fileName = Utils.GetOptionsFileName(@"ExpertDs.txt");
            if (!File.Exists(fileName))
            {
                context.ReportError(@"Файл {0} не найден. Проверка экспертных диагнозов не проводится", fileName);
                return;
            }
            var allLines = File.ReadAllLines(fileName);
            var expertDsAll = getDsList(allLines, 0);

            var expertUslAll = (from u in bill.Reestr.USL
                                 from d in expertDsAll
                                 where Regex.IsMatch(u.DS, @"^" + d + @".*$") //&& u.DS != @"R10.4"
                                 select u).GroupBy(x => x.DS);

            foreach (var invGroup in expertUslAll)
            {
                context.ReportProgress(@"Диагноз требующий проведения предварительной экспертизы {0}", invGroup.Key);
                invGroup.ToList().ForEach(x => context.ReportProgress(@"    -> {0}", x));
            }
        }
Пример #6
0
        private static void validateRequeredFields(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            foreach (var fieldName in new[] { "VERSION", "DATA", "FILENAME", "FILENAME1" })
                validateRequeredField(context, dataContext, bill.Persons.ZGLV, fieldName, "Persons.ZGLV");

            foreach (var fieldName in new[] { "ID_PAC", "FAM", "IM", "OT", "W", "DR" })
                validateRequeredField(context, dataContext, bill.Persons.PERS, fieldName, "Persons.PERS");

            foreach (var fieldName in new[] { "FAM_P", "IM_P", "OT_P", "W_P", "DR_P" })
                validateRequeredField(context, dataContext, bill.Persons.PERS.Where(x => !x.IsFAM_PNull()),
                    fieldName, "Persons.PERS");

            foreach (var fieldName in new[] { "VERSION", "DATA", "FILENAME" })
                validateRequeredField(context, dataContext, bill.Reestr.ZGLV, fieldName, "Reestr.ZGLV");

            foreach (var fieldName in new[] { "CODE", "CODE_MO", "YEAR", "MONTH", "NSCHET", "DSCHET", "PLAT", "SUMMAV" })
                validateRequeredField(context, dataContext, bill.Reestr.SCHET, fieldName, "Reestr.SCHET");

            foreach (var fieldName in new[] { "N_ZAP", "PR_NOV" })
                validateRequeredField(context, dataContext, bill.Reestr.ZAP, fieldName, "Reestr.ZAP");

            foreach (var fieldName in new[] { "ID_PAC", "VPOLIS", "NPOLIS", "NOVOR" })
                validateRequeredField(context, dataContext, bill.Reestr.PACIENT, fieldName, "Reestr.PACIENT");

            foreach (var fieldName in new[] { "IDCASE", "USL_OK", "VIDPOM", "PODR", "LPU", "PROFIL"
                , "DET", "NHISTORY", "DATE_1", "DATE_2", "DS1", "RSLT", "ISHOD", "PRVS", "IDDOKT", "IDSP", "SUMV" })
                validateRequeredField(context, dataContext, bill.Reestr.SLUCH, fieldName, "Reestr.SLUCH");

            foreach (var fieldName in new[] { "IDSERV", "LPU", "PROFIL", "DET", "DATE_IN", "DATE_OUT", "DS",
                "CODE_USL", "KOL_USL", "TARIF", "SUMV_USL", "PRVS", "CODE_MD" })
                validateRequeredField(context, dataContext, bill.Reestr.USL, fieldName, "Reestr.USL");
        }
Пример #7
0
        private static void validateRequeredField(IBackgroundContext context, BillsValidatorDataContext dataContext, 
            IEnumerable<DataRow> rows, string colName, string tableName)
        {
            if (context.CancellationPending) return;

            (from c in rows.TakeWhile(x => !context.CancellationPending) where c[colName] == "" select c).GroupBy(x => 1).ToList().
                ForEach( group =>
                             {
                                 context.ReportError(@"Не заполнено обязательное поле {0} в {1}", colName, tableName);
                                 group.ToList().ForEach(x => context.ReportProgress(@"    {0}", x));
                             });
        }
Пример #8
0
        private static void validatePolicyKind(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var validKinds = new[] {"1", "2", "3"};

            var invalidPolicies = (from p in bill.Reestr.PACIENT where !validKinds.Contains(p.VPOLIS) select p).ToList();

            if (invalidPolicies.Any())
            {
                context.ReportError(@"Неверный вид полиса");
                invalidPolicies.ForEach(x => context.ReportProgress(@"    -> {0} {1} вид полиса {2}",
                    x.PersRow.Fio, x.PersRow.DR, x.VPOLIS));
            }
        }
Пример #9
0
        private static void validateFrmr(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if(context.CancellationPending) return;

            validateFrmrSluch(context, bill);
            validateFrmrUsl(context, bill);
        }
Пример #10
0
        private static void validateBill(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            context.ProgressSeparator();
            context.ReportProgress(@"Проверка файла {0}", bill.LFileName);
            if (!validateBillStructure(context, bill)) return;
            context.ReportProgress(@"Счет " + bill.Schet.ToString() + " " + bill.Zglv.ToString());
            context.ReportProgress("");
            validateFrmr(context, dataContext, bill);
            validatePolicyKind(context, dataContext, bill);
            checkForCrossPeriods(context, dataContext, bill);
            validateRequeredFields(context, dataContext, bill);
            checkForPersonDuplicates(context, dataContext, bill);
            checkForInvalidPolicies(context, dataContext, bill);
            if (bill.BillType == BillType.Common)
            {
                //checkForInvalidDs(context, dataContext, bill);
                //checkForExpertDs(context, dataContext, bill);
            }
               // checkForDoubleUsl(context, dataContext, bill);
            checkDateInOut(context, dataContext, bill);
        }
Пример #11
0
        private static void checkForPersonDuplicates(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var duplicates = new List<PERS_LIST.PERSRow>();
            foreach (var currPers in bill.Persons.PERS.TakeWhile(x => !context.CancellationPending))
            {
                var person = currPers;
                if(!duplicates.Contains(person))
                {
                    List<PERS_LIST.PERSRow> persDup;
                    if(person.SmoPacient != null)
                        persDup = (from c in bill.Persons.PERS where c != person
                                       && c.SmoPacient == person.SmoPacient select c).ToList();
                    else
                        persDup = (from c in bill.Persons.PERS
                                   where c != person && c.Fio == person.Fio && c.DR == person.DR select c).ToList();

                    if(persDup.Count > 0)
                    {
                        context.ReportError(" Повторные записи пациента в списке пролеченных {0}", person.ToString());
                        persDup.ForEach(x => context.ReportProgress(@"    -> {0}", x));
                        duplicates.AddRange(persDup);
                    }
                }
            }
        }
Пример #12
0
        private static void checkForInvalidPolicies(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            if (dataContext.SmoPacients.ContainsKey(bill.SmoCode))
            {
                var invPers = (from c in bill.Persons.PERS
                               let pac = (from p in bill.Reestr.PACIENT where p.PersRow == c select p).FirstOrDefault()
                               where c.SmoPacient == null select new {Person = c, Pacient = pac } );

                invPers.GroupBy(x => 1).ToList()
                    .ForEach(group =>
                                 {
                                     context.ReportError(@"Пациенты на найдены в БД СМО");
                                     group.ToList().ForEach(x => context.ReportProgress(@"    {0}", ((object)x.Pacient ?? x.Person).ToString()));
                                 });
            }
        }
Пример #13
0
        private static void checkForInvalidDs(IBackgroundContext context, BillsValidatorDataContext dataContext, BillData bill)
        {
            if (context.CancellationPending) return;

            var fileName = Utils.GetOptionsFileName(@"InvalidDs.txt");
            if(!File.Exists(fileName))
            {
                context.ReportError(@"Файл {0} не найден. Проверка диагнозов не проводится", fileName);
                return;
            }
            var allLines = File.ReadAllLines(fileName);
            var invalidDsAll = getDsList(allLines, 0);
            var invalidDsChildren = getDsList(allLines, 1);
            var invalidDsAdult = getDsList(allLines, 2);

            var invalidUslAll = (from u in bill.Reestr.USL
                                from d in invalidDsAll
                                where Regex.IsMatch(u.DS, @"^" + d + @".*$")
                                select u).GroupBy(x => x.DS);

            foreach (var invGroup in invalidUslAll)
            {
                context.ReportError(@"Неоплачиваемый диагноз {0}", invGroup.Key);
                invGroup.ToList().ForEach(x => context.ReportProgress(@"    -> {0}", x));
            }

            var invalidUslChildren = (from u in bill.Reestr.USL
                                     from d in invalidDsChildren
                                     where Regex.IsMatch(u.DS, @"^" + d + @".*$") && u.DET == "1"
                                     select u).GroupBy(x => x.DS);

            foreach (var invGroup in invalidUslChildren)
            {
                context.ReportError(@"Неоплачиваемый диагноз для детей {0}", invGroup.Key);
                invGroup.ToList().ForEach(x => context.ReportProgress(@"    -> {0}", x));
            }

            var invalidUslAdult = (from u in bill.Reestr.USL
                                     from d in invalidDsAdult
                                     where Regex.IsMatch(u.DS, @"^" + d + @".*$") && u.DET == "1"
                                     select u).GroupBy(x => x.DS);

            foreach (var invGroup in invalidUslAdult)
            {
                context.ReportError(@"Неоплачиваемый диагноз для взрослых {0}", invGroup.Key);
                invGroup.ToList().ForEach(x => context.ReportProgress(@"    -> {0}", x));
            }
        }