C# (CSharp) MySqlHelper.Command示例

示例#1

        public void Parse_if_one_waydill_exclude()
        {
            var files = new[] { @"..\..\Data\Waybills\h1016416.DBF", @"..\..\Data\Waybills\bi055540.DBF", };

            SetUp(files);

            var sql = string.Format("insert into usersettings.WaybillExcludeFile (Mask, Supplier) value ('*40.DBF', {0});", supplier.Id);

            session.CreateSQLQuery(sql)
            .ExecuteUpdate();

            Process();

            CheckClientDirectory(2, DocType.Waybill);
            var logs = CheckDocumentLogEntry(2);

            CheckDocumentEntry(1);

            Assert.IsTrue(logs.Any(l => l.Addition.Contains($"Разбор документа не производился, применена маска исключения '{"*40.DBF"}'.")));

            With.Connection(c => {
                var helper = new MySqlHelper(c);
                helper.Command("delete from usersettings.WaybillExcludeFile;").Execute();
            });
        }