排序(Sort) #

async function example() {
  await instance.ready()

  const app = instance.Application

  // 添加排序条件
  await app.ActiveDBSheet.Sort.AddSort({
    Index: 2, // 索引 Index，对应 DBSheet 中的列
    IsAscending: true // true 为升序，false 为降序
  })
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 删除排序条件
  await app.ActiveDBSheet.Sort.DeleteSort({
    Index: 2 // 索引 Index，对应 DBSheet 中的列
  })
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 通过索引获取排序条件
  const getCondition = await app.ActiveDBSheet.Sort.GetCondition({
    Index: 1 // 索引
  })
  console.log(getCondition)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  const fieldId = await app.ActiveDBSheet.Field.GetFieldId(1)

  // 通过 fieldId 获取排序条件
  const getConditionById = await app.ActiveDBSheet.Sort.GetConditionById(fieldId)
  console.log(getConditionById)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 获取排序条件数量
  const getConditionsCount = await app.ActiveDBSheet.Sort.GetConditionsCount()
  console.log(getConditionsCount)
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 设置为自动排序
  await app.ActiveDBSheet.Sort.SetAutoSort({ IsAutoSort: true })
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 设置排序的优先级
  await app.ActiveDBSheet.Sort.SetConditionPriority({
    FieldIds: [2, 1, 3] // 索引清单，对应 DBSheet 中需要排序的列
  })
}

async function example() {
  await instance.ready()

  const app = instance.Application

  // 设置排序的升降序
  const result = await app.ActiveDBSheet.Sort.SetIsAscending({
    Index: 1,
    IsAscending: true // true 为升序，false 为降序
  })
  console.log(result)
}