formquery.cpp

速达开源ERP系统

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

#include <vcl.h>
#pragma hdrstop

#include "FormQuery.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "RecBaseForm"
#pragma link "SDGrid"
#pragma link "DateEdit"
#pragma link "fpanel"
#pragma link "SDComboBox"
#pragma link "SDEdit"
#pragma resource "*.dfm"
TfrmFormQuery *frmFormQuery;
#include "sdappserver_tlb.h"
//---------------------------------------------------------------------------
__fastcall TfrmFormQuery::TfrmFormQuery(TComponent* Owner)
        : TRecBaseForm(Owner,euSdFormQuery,"")
{
}
//---------------------------------------------------------------------------
AnsiString __fastcall TfrmFormQuery::GetFieldValue(int FieldIndex)
{
    WideString S;
    S = ReadFieldValue(comServer,FieldIndex);
    return(S);
}

//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::ClearControl(bool BringToNext)
{
    if(!BringToNext)
    {
      seFormQueryField->Text   ="";
      seFormQueryDesc->Text    ="";
      scFormQueryType->ItemIndex =-1; 
      seFormQueryLine->Text    ="";
      chkFormQueryBtn->Checked =false;         //是否有Button
      seFormQueryFormID->Text  ="";     //查询Form ID
      seFormQueryWhere->Text   ="";     //过滤条件
      chkFormQueryWait->Checked =false;     //是否需启动等待Form
    }
}

//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::GetDataFromComObject()
{
    seFormQueryField->Text=GetFieldValue(fiFormQueryField);
    sgFormQuery->LocateGrid(1,seFormQueryField->Text);
    scFormQueryType->LocateKey(GetFieldValue(fiFormQueryType));
    scFormQueryType->Text=scFormQueryType->ItemData[0];
    seFormQueryDesc->Text =GetFieldValue(fiFormQueryDesc);
    seFormQueryLine->Text =GetFieldValue(fiFormQueryLine);
    chkFormQueryBtn->Checked=GetFieldValue(fiFormQueryBtn)=="1"? true:false;
    seFormQueryFormID->Text=GetFieldValue(fiFormQueryFormID);
    seFormQueryWhere->Text=GetFieldValue(fiFormQueryWhere);
    chkFormQueryWait->Checked=GetFieldValue(fiFormQueryWait)=="1"? true:false;
}

//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::SendDataToComObject()
{
    WriteFieldValue(comServer,fiFormQueryName,WideString(scFormQueryName->Text));
    WriteFieldValue(comServer,fiFormQueryField,WideString(seFormQueryField->Text));
    WriteFieldValue(comServer,fiFormQueryType,WideString(scFormQueryType->ItemData[1]));
    WriteFieldValue(comServer,fiFormQueryDesc,WideString(seFormQueryDesc->Text));
    WriteFieldValue(comServer,fiFormQueryLine,WideString(seFormQueryLine->Text));
    WriteFieldValue(comServer,fiFormQueryBtn,chkFormQueryBtn->Checked ?"1":"0");
    WriteFieldValue(comServer,fiFormQueryFormID,WideString(seFormQueryFormID->Text));
    WriteFieldValue(comServer,fiFormQueryWhere,WideString(seFormQueryWhere->Text));
    WriteFieldValue(comServer,fiFormQueryWait,chkFormQueryWait->Checked ?"1":"0");
}
//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::WaitUserInput()
{
    seFormQueryLine->SetFocus();
}
//---------------------------------------------------------------------------
AnsiString __fastcall TfrmFormQuery::GetDataToGrid()
{
    AnsiString  s;
    scFormQueryType->LocateKey(GetFieldValue(fiFormQueryType));
    s = "\t" + GetFieldValue(fiFormQueryLine) +
        "\t" + GetFieldValue(fiFormQueryField)+
        "\t" + GetFieldValue(fiFormQueryDesc) +
        "\t" + scFormQueryType->Text ;
    return(s);
}
//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::RefreshGridData(int mAction)
{
    AnsiString ItemStr;

    ItemStr = GetDataToGrid();
    // 新增
    if (mAction ==  0)
    {
        sgFormQuery->AddItem(ItemStr);
    }
    // 修改
    else if(mAction == 1)
    {
        int i = sgFormQuery->Row;
        sgFormQuery->RemoveItem(i);
        sgFormQuery->AddItem(ItemStr,i);
    }
    // 删除    0
    else if(mAction ==  2)
    {
        sgFormQuery->RemoveItem(sgFormQuery->Row);
    }
}
//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::FillGridWithData()
{
    AnsiString ItemStr;
    comServer->MoveFirst();
    sgFormQuery->RowCount  = 1;
    while(comServer->Eof == 0)
    {
        ItemStr=GetDataToGrid();
        sgFormQuery->AddItem(ItemStr);
        comServer->MoveNext();
    }
}
//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::InitEditControl()
{
    ClientGroup->AddComponent(2,true,true,false, scFormQueryName,scFormQueryName->Name);
    ClientGroup->AddComponent(2,false,false,true,FloatPanel1,FloatPanel1->Name);
    ClientGroup->AddComponent(2,true,true,false, sgFormQuery,sgFormQuery->Name);
    FillComboBox(scFormQueryName,"SELECT FormName,FORMCAPTION,FORMID FROM sdForm order By FormName","FormName","FORMCAPTION","FORMID");
    scFormQueryType->AddItems("字符型","1");
    scFormQueryType->AddItems("数字型","2");
    scFormQueryType->AddItems("布尔型","3");
    scFormQueryType->AddItems("日期型","4");
    ClearControl(false);
}
//---------------------------------------------------------------------------void __fastcall TfrmFormQuery::scFormQueryNameClick(TObject *Sender)
void __fastcall TfrmFormQuery::scFormQueryNameClick(TObject *Sender)
{
      AnsiString s;
      s = Trim(scFormQueryName->Text);
      scFormQueryName->LocateKey(scFormQueryName->Text);
      seFormQueryCaption->Text=scFormQueryName->ItemData[1];
      s = " FormQueryName = '" + s + "'";
      comServer->FilterString = WideString(s);
      comServer->OrderString = WideString("FormQueryLine");
      comServer->Query();
      FillGridWithData();
      comServer->MoveFirst();
      GetDataFromComObject();
}
//---------------------------------------------------------------------------
void __fastcall TfrmFormQuery::sgFormQueryClick(TObject *Sender)
{
    if (sgFormQuery->Row > 0)
      comServer->LocateByKey(WideString(scFormQueryName->Text+sgFormQuery->TextMatrix[sgFormQuery->Row][2]));
    if (!comServer->Eof)
      GetDataFromComObject();

}
//---------------------------------------------------------------------------

void __fastcall TfrmFormQuery::FormShow(TObject *Sender)
{
       scFormQueryName->ItemIndex=0;
       scFormQueryName->LocateKey(scFormQueryName->Text);
       seFormQueryCaption->Text=scFormQueryName->ItemData[1];
       AnsiString s;
       s = Trim(scFormQueryName->Text);
       scFormQueryName->LocateKey(scFormQueryName->Text);
       seFormQueryCaption->Text=scFormQueryName->ItemData[1];
       s = " FormQueryName = '" + s + "'";
       comServer->FilterString = WideString(s);
       comServer->OrderString = WideString("FormQueryLine");
       comServer->Query();
       FillGridWithData();
       comServer->MoveFirst();
       GetDataFromComObject();
}
//---------------------------------------------------------------------------