usqydy.pas

已经投入使用的商业级管理系统：液化气管理系统。 附带全部源码

unit USQYDY;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, ToolWin, GridsEh, DBGridEh, Buttons, ExtCtrls, DB,
  frxClass, frxDBSet, frxPreview;

type
  TFSQYDY = class(TForm)
    DBGridEh1: TDBGridEh;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    DataSource1: TDataSource;
    frxDBDataset1: TfrxDBDataset;
    frxReport1: TfrxReport;
    procedure ToolButton6Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure DBGridEh1DblClick(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FSQYDY: TFSQYDY;

implementation
  uses MAIN,U_dm,UADDSQY,UsysConst,UsysPub;
{$R *.dfm}

procedure TFSQYDY.ToolButton6Click(Sender: TObject);
begin
  SELF.Close;
end;

procedure TFSQYDY.FormShow(Sender: TObject);
var
  strSQL:String;
begin
  strSQL:='select * from JG送气员';
  RunSQL(DM.ADOQ_SQY,strSQL,0);
end;

procedure TFSQYDY.ToolButton1Click(Sender: TObject);
begin
  strCZZT:='ADD';
  try
    Application.CreateForm(TFADDSQY, FADDSQY);
    FADDSQY.ShowModal;
  finally
    FADDSQY.Free;
  end;
end;

procedure TFSQYDY.ToolButton2Click(Sender: TObject);
begin
  if DM.ADOQ_SQY.RecordCount<=0 then
    abort;
  strCZZT:='MODIFY';
  try
    Application.CreateForm(TFADDSQY, FADDSQY);
    FADDSQY.ShowModal;
  finally
    FADDSQY.Free;
  end;
end;

procedure TFSQYDY.ToolButton5Click(Sender: TObject);
begin
 // frxReport1.Preview:=frxPreview1;
//  frxReport1.PrepareReport(True);
//  frxReport1.ShowPreparedReport;
//  frxReport1.frReport1.PrintPreparedReport('1',1,True,frAll)
//    frReport1.Preview:=frPreview1;
//    frReport1.PrepareReport;
//    frReport1.ShowPreparedReport;
end;

procedure TFSQYDY.DBGridEh1DblClick(Sender: TObject);
begin
  strCZZT:='MODIFY';
  try
    Application.CreateForm(TFADDSQY, FADDSQY);
    FADDSQY.ShowModal;
  finally
    FADDSQY.Free;
  end;
end;

procedure TFSQYDY.ToolButton3Click(Sender: TObject);
var
  strSQL,strID,strmc:string;
begin
  if DM.ADOQ_SQY.RecordCount<=0 then
    abort;
  strID:=Trim(DM.ADOQ_SQY.fieldbyname('送气员ID').AsString);
  strmc:=Trim(DM.ADOQ_SQY.fieldbyname('送气员').AsString);
  case messagebox(handle,pchar('真的要删除【'+strmc+'】吗？'),MsgBxCaption,mb_iconquestion+MB_YESNO) of
  ID_yes:
  begin
    strSQL:='delete from JG送气员 where (送气员ID='+''''+strID+''''+')';
    if RunSQL(DM.m_clADOQry_Temp,strSQL,1) then
    begin
      strSQL:='select * from JG送气员';
      RunSQL(DM.ADOQ_SQY,strSQL,0);
    end
    else
    begin
      Application.MessageBox('删除数据出错！',MsgBxCaption,MB_OK);
    end;
  end;
  ID_no: abort;
  END;
end;

End.