private DataTable QueryData(ViewQueryBase viewQuery, ref int DataCount)
{
int parentId = -1;
string parentKeyName = string.Empty;
if (thisGridParma.QueryParmaList.Count > 0)
{
parentId = Convert.ToInt32(thisGridParma.QueryParmaList[0].Value);
parentKeyName = thisGridParma.QueryParmaList[0].QueryField.FieldName;
}
if (!string.IsNullOrEmpty(parentKeyName))
{
var subQuery = viewQuery.GetMMSubQuery("T_User_Role", "Role_ID", parentKeyName, parentId);
viewQuery.ViewQueryExs.Add(
new ViewQueryEx()
{
TableAlias = "a",
FieldName = "Role_ID",
SubQuery = subQuery,
CompareType = CompareTypeEnum.IN,
}
);
}
DataCount = viewQuery.QueryCount();
return(viewQuery.Query());
}
