public JoinOnCondition(string table1, string table2, string table1Field, string table2Field, TableJoinMode mode)
{
Table1 = table1;
Table1Field = table1Field;
Table2 = table2;
Table2Field = table2Field;
Mode = mode;
}
/// <summary>
/// 获取JOIN的sql表达式
/// </summary>
/// <param name="md"></param>
/// <returns></returns>
public static string GetJoinMode(TableJoinMode md)
{
if (md == TableJoinMode.InnerJoin)
{
return("inner join");
}
if (md == TableJoinMode.LeftJoin)
{
return("left join");
}
if (md == TableJoinMode.OuterJoin)
{
return("outer join");
}
if (md == TableJoinMode.RightJoin)
{
return("right join");
}
if (md == TableJoinMode.Join)
{
return("join");
}
return("join");
}