// Insert user control code here
//
public string MenuUserClientID="0";
public string MenuUserRoleNo="0";
public string MenuUserParentNo="0";
void BindMenu()
{
string sqlStr = "status = 1 and parentNo = "+MenuUserParentNo;
sqlStr += " and ( menuNo in (select parentNo from t_menulayout where menuNo in (select parentNo from v_menugrants where clientID = '"+this.MenuUserClientID+"' and roleNo = " + this.MenuUserRoleNo+"))";
sqlStr += " or menuNo in (select parentNo from v_menugrants where clientID = '"+this.MenuUserClientID+"' and roleNo = " + this.MenuUserRoleNo+"))";