/// <summary>
/// 多表查询
/// </summary>
/// <returns></returns>
private Task <int> Test2()
{
//两张表
var uQueryUser = DB.CreateQuery <EntityModel.User>();
var uQueryRelate = DB.CreateQuery <EntityModel.Relate>();
#region 查询全部
var allQuery = from b in uQueryUser
join c in uQueryRelate
on b.Relate_ID equals c.ID
select new EntityModel.User
{
ID = b.ID,
Name = b.Name,
Relate_ID = b.ID,
RelateName = c.Name
};
var p1 = allQuery.ToList();
#endregion
#region 条件查询
var p2 = allQuery.Where(b => b.ID > 1).ToList <EntityModel.User>();
#endregion
#region 条件分页查询
QueryArgs queryAga = new QueryArgs();
var wlist = new List <WhereField>();
WhereField wf = new WhereField()
{
WhereType = WhereType.Like,
Field = "test_name",
Value = "用户"
};
wlist.Add(wf);
queryAga.WhereFields = wlist;
var result = DB.CreateComQuery().Query <User>(allQuery, queryAga);//.toResult();
#endregion
#region json 分页查询
QuerySearchModel qsModel = new QuerySearchModel();
string str = JsonHelper.Serialize(wlist);
qsModel.Filters = str;
var args = qsModel.toQuery();
var result1 = DB.CreateComQuery().Query <User>(allQuery, args);
#endregion
return(Task.FromResult(1));
}
public override bool Validate(out Dictionary <string, string> errors)
{
errors = new Dictionary <string, string>();
if (string.IsNullOrEmpty(Name))
{
errors.Add(nameof(Name), "Criterio name is mandatory.");
}
if (criterioType == QCriterioType.Unspecified)
{
errors.Add(nameof(CriterioType), "Criterio type is mandatory.");
}
if (string.IsNullOrEmpty(categoryDesc))
{
errors.Add(nameof(CategoryDesc), "Category is mandatory.");
}
if (DatabaseName.IsInvalid())
{
errors.Add(nameof(DatabaseName), "Check DatabaseName.");
}
if (string.IsNullOrEmpty(whereTable))
{
errors.Add(nameof(WhereTable), "TableName is mandatory.");
}
if (string.IsNullOrEmpty(whereField))
{
errors.Add(nameof(WhereField), "FieldName is mandatory.");
}
if (Name.HasTrailingSpaces())
{
errors.Add(nameof(Name), "Trailing spaces are not allowed.");
}
if (WhereField.HasTrailingSpaces())
{
errors.Add(nameof(WhereField), "Trailing spaces are not allowed.");
}
if (WhereTable.HasTrailingSpaces())
{
errors.Add(nameof(WhereTable), "Trailing spaces are not allowed.");
}
if (string.IsNullOrEmpty(crjCode))
{
errors.Add(nameof(CrjCode), "CrjCode is mandatory.");
}
return(errors.Count == 0);
}
/// <summary>
/// 单表查询
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
private Task <int> Test1()
{
var uQuery = DB.CreateQuery <EntityModel.User>();
#region 查询全部
var allList = uQuery.ToList();
#endregion
#region 条件查询
var p = uQuery.Where(b => b.ID > 0 && b.Name.Contains("用户")).ToList <EntityModel.User>();
#endregion
#region 条件分页查询
QueryArgs queryAga = new QueryArgs();
var wlist = new List <WhereField>();
WhereField wf = new WhereField()
{
WhereType = WhereType.Like,
Field = "test_name",
Value = "用户"
};
wlist.Add(wf);
queryAga.WhereFields = wlist;
var result = DB.CreateComQuery().Query <User>(uQuery, queryAga);//.toResult();
#endregion
#region json 分页查询
QuerySearchModel qsModel = new QuerySearchModel();
string str = JsonHelper.Serialize(wlist);
qsModel.Filters = str;
var args = qsModel.toQuery();
var result1 = DB.CreateComQuery().Query <User>(uQuery, args);
#endregion
return(Task.FromResult(1));
}
