public void GetReadersTest()
{
using (FileLogger l = new FileLogger("MdbContextTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
MdbContextOptions.GetOptions().CommandTimeout = 120;
using (var ctx = new MdbContext(_cn))
{
l.Debug("Test 1 Start ");
int i = 0;
var drs = ctx.GetReaders(@"
Select * From PayDocs Where Handle = @handle;
Select * From PayDocs Where Handle = @handle1
Select * From PayDocs Where Handle = @handle1+1" ,
new MdbParameter("@handle", 3999750),
new MdbParameter("@handle1", 3999751)
);
foreach (var dr in drs)
{
using (dr)
{
for (; dr.Read(); i++)
{
l.Debug(dr.GetRowJSON());
}
}
}
l.Debug($"Test 1 Finish rows result {i}");
}
}
}
public void GetSysCatReadersTest()
{
using (FileLog l = new FileLog("MdbContextTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
MdbContextOptions.GetOptions().CommandTimeout = 120;
using (var ctx = new MdbContext(_syscat))
{
l.Debug("Test 1 Start ");
int i = 0;
var drs = ctx.GetReaders(@"
select u.ID
,u.StructuralUnitID
,u.AccessLevelID
,u.UserName
,COALESCE(u.DomainName, '') as DomainName
,COALESCE(u.PersonID, 0) as PersonID
,COALESCE(u.Name, '') as Name
,COALESCE(u.JData, '') as JData
from Users u
where u.UserName LIKE '{0}';
select
Upper(r.RoleName) as RoleName
from Users u
inner join Users2Roles ur on u.ID = ur.UserID
inner join Roles r on r.ID = ur.RoleID
where u.UserName LIKE '{0}'" .ToFormat(@"DESKTOP-14MM2MF\sergey")
);
foreach (var dr in drs)
{
using (dr)
{
for (; dr.Read(); i++)
{
l.Debug(dr.GetRowJSON());
}
}
}
l.Debug($"Test 1 Finish rows result {i}");
}
}
}