public static string GetJoinEnum(ViewJoinEnum eEnum)
{
switch (eEnum)
{
case ViewJoinEnum.leftjoin:
return(" left join ");
case ViewJoinEnum.crossjoin:
return(" cross join ");
case ViewJoinEnum.fulljoin:
return(" full join ");
case ViewJoinEnum.rightjoin:
return(" right join ");
case ViewJoinEnum.innerjoin:
return(" inner join ");
}
return(string.Empty);
}
/// <summary>
/// 加入join连接
/// </summary>
/// <param name="join"></param>
/// <param name="table1"></param>
/// <param name="table2"></param>
/// <param name="joinfields"></param>
public DataBaseAction AddJoin(ViewJoinEnum join, string table1, string table2, List <QueryField> joinfields)
{
if (ViewList == null)
{
ViewList = new List <ViewHelper>();
}
foreach (var item in ViewList)
{
if (item.TableName1 != table1 || item.TableName2 != table2)
{
continue;
}
item.Joinfields.AddRange(joinfields);
return(this);
}
ViewList.Add(new ViewHelper()
{
Join = join,
TableName1 = table1,
TableName2 = table2,
Joinfields = joinfields
});
return(this);
}
public DataBaseAction AddJoin(ViewJoinEnum join, BaseEntity table1, BaseEntity table2, List <QueryField> joinfields)
{
return(AddJoin(join, table1.TableName, table2.TableName, joinfields));
}
