jgsearchdkds.pas

ProviceSystem-公积金监管系统中心端

unit JGSearchDkDs;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, ImgList, ToolWin, Grids, DB, DBGrids;

type
  TJGSearchDkDsGL = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    ImageList1: TImageList;
    ImageList2: TImageList;
    StatusBar1: TStatusBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    procedure ToolButton6Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    sNy:string;
  end;

var
  JGSearchDkDsGL: TJGSearchDkDsGL;

implementation

uses dmPJg, JGSearchDkGr;

{$R *.dfm}


procedure TJGSearchDkDsGL.ToolButton6Click(Sender: TObject);
begin
  close;
end;

procedure TJGSearchDkDsGL.FormCreate(Sender: TObject);
begin
  datasource1.DataSet:= DM.cds_Cx;
end;

procedure TJGSearchDkDsGL.DBGrid1DblClick(Sender: TObject);
var
  JGSearchDkGrGL: TJGSearchDkGrGL;
  cmd: string;
begin
  cmd:= 'select * from V_GRDK '+
        ' union '+
        'select ''合计'',''共计''+ convert(varchar(8),count(*)) +''人'','+
        ''''',0,'' '','''','''','''',isnull(sum(DKJE),0),'''',0,0,'+
        'isnull(sum(YHKJE),0),'''','''','''',isnull(sum(HSBS),0),'+
        'isnull(sum(HSJE),0),'''',isnull(sum(TQHKBS),0),isnull(sum(TQHKJE),0),'+
        'isnull(sum(DKYE),0),isnull(sum(YQBS),0),isnull(sum(YQJE),0),'''','+
        ''''',isnull(sum(HXJE),0),'''''+
        ' from V_GRDK '+
        ' order by DKZH';
  DM.GjjCx2(Cmd);
  JGSearchDkGrGL:= TJGSearchDkGrGL.Create(application);
  JGSearchDkGrGL.ShowModal;
end;

end.