DBHelperÀà

µ÷Óãº

string sql = "select * from Base_SysMenu where Menu_Id in(select Menu_Id from Base_UserRight where User_ID=@UserID) and DeleteMark=0 and Menu_Type=1 order by SortCode desc";
DbHelper db = new DbHelper();
DbCommand cmd = db.GetSqlStringCommond(sql);
db.AddInParameter(cmd, "@UserID", DbType.String, roleid);
return db.ExecuteDataTable(cmd);