sql记录

sql记录

select * from sys_right_reg a where a.right_name='执行科室设置'; select * from sys_right_reg a where a.right_name='是否有手工记账权限' for update;

    let that = this as any;
    let UserIdItems = this.resKsTpepple.map(axis => axis.UserId).join("','");
    new Dict({
      dict: {
        id: DictId.SysUserDictId,
        name: DictId.SysUserDictName
        // id: 'A10003',
        // name: '系统人员字典'
      },
      serVal: "",
      where: `unit_id= '` + this.SelectedTeam['UnitId'] + `'` + `and dept_id= '` + this.SelectedTeam.DeptId + `'` + `and user_id not in ` + `('` + UserIdItems + `')`,
      selected: async function (row: any) {
        that.TeamDetail.UserName = row.name;
        that.TeamDetail.UserId = row.id;
        try {
          let resExsitOperatorId = await that.mgr.IfExsistOperateid(row.id);
          if (resExsitOperatorId) {
            that.$message({
              message: '该用户已经设置过班组了，请选择其它用户!',
              type: 'warning',
              duration: 1500,
            });
            that.TeamDetail.UserId = "";
            that.TeamDetail.UserName = "";
            return;
          }
        } catch (error) {
          UI.ShowException(error);
        }

      }, close: function (row: any) {
        // alert("字典关闭");
      }
    });
  }