The Source Code - Multilevel Security for Relational Databases - page 244

select = “select name from
dbo.[D2-” + GlobalClasses.
globals.UserLabel + “]
where “ + PredicateSTR;
}
else if (PredicateSTR.
Split(' = ')[0].Trim().
ToUpper() = = “SALARY” ||
PredicateSTR.Split(“in”.
ToCharArray(),2)[0].Trim().
ToUpper() = = “SALARY”)
{
select = “select name from
dbo.[D3-” + GlobalClasses.
globals.UserLabel + “]
where “ + PredicateSTR;
}
foreach (DataRow DR in
GlobalClasses.
DBOperations.
GetData(select).
Tables 0].Rows)
{
upd atePredicate =
updatePredicate +”'” +
DR[“name”].ToString() +
“',”;
}
upd atePredicate
= updatePredicate.
Remove(updatePredicate.
Length - 1);
updatePredicate = “(“+
updatePredicate +”)”;
foreach (string s in
AttributeARR)
{
if (s.Split(' = ')[0].
Trim().ToUpper() = =
“DEPARTMENT”)
{
UpdateStr = “Update dbo.
[D2-” +
GlobalClasses.
globals.UserLabel +