uxiugai2.cpp

社区管理系统的公共管理模块

//---------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop

#include "UXiuGai2.h"
#include "UGGGLXT.h"
//---------------------------------------------------------------------
#pragma resource "*.dfm"
TXiuGai2 *XiuGai2;
void OpenSQL(String cmdSQL,TQuery*que)
{
 que->Close();
 que->SQL->Clear();
 que->SQL->Add(cmdSQL);
 que->Open();
}
void UpdataSQL(String cmdSQL,TQuery*que)
{
  que->Close();
  que->SQL->Clear();
  que->SQL->Add(cmdSQL);
  que->ExecSQL();
}

int RedIsExists(String cmdSQL,TQuery *Que)
{
  int Res;
  OpenSQL(cmdSQL,Que);
  Res=Que->RecordCount;
  Que->Close();
  return Res;
}

String CutSpace(char *Str)
{
  String s;
  s="";
  while(*Str)
  {
    if((*Str!=' ')&&(*Str!='　')) s=s+(*Str);
    Str++;
  }
  return s;
}

int EditTry(TEdit *edTemp)
{
  try
  {
    StrToInt(edTemp->Text);
    return 0;
   }
  catch(...)
  {
    MessageBox(0,"该项只能输入数字","输入出错",MB_OK|MB_TASKMODAL|MB_ICONERROR);
    edTemp->SelectAll();
    fmGGGL->ActiveControl=edTemp;
    return 1;
  }
}

int EditTryFloat(TEdit *edTemp)
{
  try
  {
    StrToFloat(edTemp->Text);
    return 0;
   }
  catch(...)
  {
    MessageBox(0,"该项只能输入数字","输入出错",MB_OK|MB_TASKMODAL|MB_ICONERROR);
    edTemp->SelectAll();
    fmGGGL->ActiveControl=edTemp;
    return 1;
  }
}

//---------------------------------------------------------------------
__fastcall TXiuGai2::TXiuGai2(TComponent* AOwner)
	: TForm(AOwner)
{
}
//---------------------------------------------------------------------
void __fastcall TXiuGai2::Button2Click(TObject *Sender)
{
  String cmdSQL;

  cmdSQL="update 设施维护管理 set 设施名称='"+edSSMC->Text+"',维护人员='"
  +edWHRY->Text+"',电话='"+edDH2->Text+"',维护费用="+edWHFY->Text
  +",维护说明='"+meWHSM->Text+"',维护时间="+atWHSJ->DateTime+",管理人员='"+edGLRY->Text
  +"',设施平面图='"+meSSPMT->Text+"' where 设施编号="+edBH3->Text;
  extern void UpdataSQL(String cmdSQL,TQuery*que);
  UpdataSQL(cmdSQL,fmGGGL->queUpdata);
  MessageBox(0,"修改成功","提示",MB_OK|MB_TASKMODAL);
  Close();
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::Button1Click(TObject *Sender)
{

 Close();
}
//---------------------------------------------------------------------------



void __fastcall TXiuGai2::edSSMCExit(TObject *Sender)
{
   edSSMC->Text=CutSpace(edSSMC->Text.c_str());        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edSSMCKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
  if(Key==13) ActiveControl=edWHRY;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edWHRYExit(TObject *Sender)
{
  edWHRY->Text=CutSpace(edWHRY->Text.c_str());         
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edWHRYKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
     if(Key==13)  ActiveControl=edDH2;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edDH2KeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
 if(Key==13) ActiveControl=meSSPMT;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edDH2Exit(TObject *Sender)
{
 edDH2->Text=CutSpace(edDH2->Text.c_str());
 EditTry(edDH2);
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::meSSPMTExit(TObject *Sender)
{
  meSSPMT->Text=CutSpace(meSSPMT->Text.c_str());         
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::meSSPMTKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
   if(Key==13) ActiveControl=atWHSJ;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::atWHSJKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
   if(Key==13) ActiveControl=edWHFY;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edWHFYKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
  if(Key==13) ActiveControl=edGLRY;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edWHFYExit(TObject *Sender)
{
edWHFY->Text=CutSpace(edWHFY->Text.c_str());
EditTry(edWHFY);
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edGLRYExit(TObject *Sender)
{
  edGLRY->Text=CutSpace(edGLRY->Text.c_str());        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::edGLRYKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
  if(Key==13) ActiveControl=meWHSM;        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::meWHSMExit(TObject *Sender)
{
 meWHSM->Text=CutSpace(meWHSM->Text.c_str());        
}
//---------------------------------------------------------------------------

void __fastcall TXiuGai2::meWHSMKeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
  if(Key==13)    ActiveControl=Button2;
}
//---------------------------------------------------------------------------