private static async void doQuery()
{
QueryCmd qc = new QueryCmd(DBType.MySql, "server=192.168.1.226;database=PMERP;Persist Security Info=False;uid=itlife;pwd=1qaz@WSX");
var userRoles = await qc.GetQueryResult <Role>($"SELECT r.* FROM PMERP.User_Role ur JOIN PMERP.Role r ON r.Id = ur.Role_Id WHERE ur.User_Id = '1a7e021d-09ed-4d8c-adc7-39c5be0befd5';");
List <string> qry = new List <string>();
qry.Add("select Id,Path,Name from [File]");
qry.Add("select * from [User]");
qry.Add("select * from [Group]");
string s = "select * from [User];";
var _user = qc.GetQueryResult <User>(s);
var result = qc.GetManyQueryResult(qry);
IEnumerable <object> _file = result.ToList()[0];
var r = _file.Cast <File>().Where(p => p.Privilege == "O");
var _User = result.ToList()[1] as IEnumerable <User>;
foreach (var f in result)
{
//foreach (var r in f)
// Console.WriteLine($"Id={r.Id}, Path={r.Path}, Name={r.Name}");
}
}
