protected void Page_Load(object sender, EventArgs e) { if (RoleCheck.hasRole("adminrole", CurrentUser)) { isAdmin = true; //管理员能查看自己新建的项目或者 部门已提交或者通过或者退回的项目 roleWhere = " and (StartDeptGuid='" + bm + "' or (ProState is not null and ProState!='退回'))"; } else { if (RoleCheck.hasRole("checkrole", CurrentUser)) { isCheck = true; } else { isBaseRole = true; //部门只能查看本部门的项目 roleWhere = " and StartDeptGuid='" + bm + "'"; } } //未删除 baseWhere = " and sysstatus!=-1"; sqlWhere = baseWhere + roleWhere; }