protected override string JoinTable(JoinTableParameters p)
{
switch (p.JoinTableName.ToLower())
{
case "scr_role_user":
return string.Format("inner join scr_role_user {1} on {0}.Role_ID = {1}.Role_ID ", p.MainTableAlias, p.JoinTableAlias);
case "scr_role_function":
return string.Format("inner join scr_role_function {1} on {0}.Role_ID = {1}.Role_ID ", p.MainTableAlias, p.JoinTableAlias);
case "scr_role_resource":
return string.Format("inner join scr_role_resource {1} on {0}.Role_ID = {1}.Role_ID ", p.MainTableAlias, p.JoinTableAlias);
default:
return "";
}
}
protected override string JoinTable(JoinTableParameters p)
{
return "";
}
protected override string JoinTable(JoinTableParameters p)
{
return string.Empty;
}
protected override string JoinTable(JoinTableParameters p)
{
throw new NotImplementedException();
}
