sortselect.cpp

企业员工考勤和工资管理系统

//---------------------------------------------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "SortSelect.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TFormSortSelect *FormSortSelect;
//---------------------------------------------------------------------------
__fastcall TFormSortSelect::TFormSortSelect(TComponent* Owner)
  : TForm(Owner)
{
}

//---------------------------------------------------------------------
void __fastcall TFormSortSelect::SetItem(TDBGrid *pGrid)
{
  ComboBox1->Clear();
  ComboBox2->Clear();
  ComboBox3->Clear();
  ComboBoxColumn->Clear();
  for (int i = 0; i < pGrid->Columns->Count; i++)
  {
    ComboBox1->Items->Add(pGrid->Columns->Items[i]->Title->Caption);
    ComboBox2->Items->Add(pGrid->Columns->Items[i]->Title->Caption);
    ComboBox3->Items->Add(pGrid->Columns->Items[i]->Title->Caption);
    ComboBoxColumn->Items->Add(pGrid->Columns->Items[i]->FieldName);
  }
}
//---------------------------------------------------------------------------
void __fastcall TFormSortSelect::BitBtn1Click(TObject *Sender)
{
  
  sSort = "";
  if (ComboBox1->ItemIndex != -1)
  {
    sSort = sSort + ComboBoxColumn->Items->Strings[ComboBox1->ItemIndex];
    if (CheckBox1->Checked) sSort = sSort + " " + "ASC,";
    else sSort = sSort + " " + "DESC," ;
  }

  if (ComboBox2->ItemIndex != -1)
  {
    sSort = sSort + ComboBoxColumn->Items->Strings[ComboBox2->ItemIndex];
    if (CheckBox2->Checked) sSort = sSort + " " + "ASC,";
    else sSort = sSort + " " + "DESC,";
  }

  if (ComboBox3->ItemIndex != -1)
  {
    sSort = sSort + ComboBoxColumn->Items->Strings[ComboBox3->ItemIndex];
    if (CheckBox3->Checked) sSort = sSort + " " + "ASC,";
    else sSort = sSort + " " + "DESC,";
  }
}
//---------------------------------------------------------------------------