gzgl_print_ybb.pas

制造业工装信息管理系统 制造业工装信息管理系统

{-----------------------------------------------------------------------------
 Unit Name: pppp
 Author:    水石工作室 
 Purpose:
 History:
-----------------------------------------------------------------------------}
unit GZGL_print_YBB;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
   DBGrids, StdCtrls, ComCtrls, Buttons, ExtCtrls, Grids
  ;

type
  TFrmGZGL_Print_YBB = class(TForm)
    Panel4: TPanel;
    Label16: TLabel;
    Image1: TImage;
    Label1: TLabel;
    Panel1: TPanel;
    pag1: TPageControl;
    Tab1: TTabSheet;
    Pnl_lst: TPanel;
    Lst1: TListBox;
    lst2: TListBox;
    Pnl_contralBar: TPanel;
    btn_del1: TSpeedButton;
    btn_add1: TSpeedButton;
    btn_delALL: TSpeedButton;
    btn_addALL: TSpeedButton;
    Panel8: TPanel;
    btn_next1: TSpeedButton;
    SpeedButton6: TSpeedButton;
    Tab2: TTabSheet;
    Panel5: TPanel;
    DBGrid2: TDBGrid;
    Tab3: TTabSheet;
    btn_preview: TSpeedButton;
    btn_print: TSpeedButton;
    Panel10: TPanel;
    SpeedButton9: TSpeedButton;
    btn_back3: TSpeedButton;
    Btn_exit: TSpeedButton;
    Panel2: TPanel;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    EDT_Y: TEdit;
    EDT_M: TEdit;
    Panel6: TPanel;
    btn_next2: TSpeedButton;
    btn_back2: TSpeedButton;
    btn_fixdata: TSpeedButton;
    lab_info: TLabel;
    lab_start: TLabel;
    lab_over: TLabel;
    btn_getdata: TSpeedButton;
    procedure lst2DblClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure btn_del1Click(Sender: TObject);
    procedure btn_add1Click(Sender: TObject);
    procedure btn_delALLClick(Sender: TObject);
    procedure btn_addALLClick(Sender: TObject);
    procedure Lst1DblClick(Sender: TObject);
    procedure btn_previewClick(Sender: TObject);
    procedure btn_fixdataClick(Sender: TObject);
    procedure btn_next2Click(Sender: TObject);
    procedure Tab1Show(Sender: TObject);
    procedure EDT_YKeyUp(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure pag1Changing(Sender: TObject; var AllowChange: Boolean);
    procedure btn_back2Click(Sender: TObject);
    procedure btn_back3Click(Sender: TObject);
    procedure btn_getdataClick(Sender: TObject);
    procedure btn_next1Click(Sender: TObject);
    procedure btn_printClick(Sender: TObject);
    procedure Btn_exitClick(Sender: TObject);
  private
    procedure emptyTbl;
    procedure GetBaseData;
    procedure FixGetedData;
    procedure CountGetedData;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmGZGL_Print_YBB: TFrmGZGL_Print_YBB;

implementation

uses GZGL_DModule, GZGL_Main, GZGL_reports;

{$R *.dfm}

procedure TFrmGZGL_Print_YBB.FormShow(Sender: TObject);
var
  s:string;
begin
  pag1.ActivePageIndex:=0;
  with dmd do begin
    if not Tbl_GZ.Active then Tbl_gz.Open;
    if not Tbl_lb.Active then Tbl_lB.Open;
    if not Tbl_YBB.Active then Tbl_YBB.Open;
  end;
  //添加车型列表
  with dmd.TbL_lb do begin
    first;
    while not eof do begin
      s:=fieldbyname('lbmc').AsString;
      if s<>'' then begin
        lst1.Items.Add(s);
      end;
      next
    end;
  end;
  Image1.Picture:=FRMGZGL_Main.IMG_LOGO.Picture;

  EmptyTbl;
end;

{-----------------------------------------------------------------------------
  开始操作列表框
-----------------------------------------------------------------------------}
//添加单个
procedure TFrmGZGL_Print_YBB.btn_add1Click(Sender: TObject);
var
  i,id:integer;
  s:string;
begin
  id:=lst1.ItemIndex;
  if id>=0 then begin
    s:=lst1.items[id];
    for i:=0 to lst2.Count-1 do begin
      if s=lst2.Items[i] then begin
        exit;
      end;
    end;
    lst2.Items.Add(lst1.items[id]);
  end;
end;
//删除添加单个
procedure TFrmGZGL_Print_YBB.btn_del1Click(Sender: TObject);
var
  i:integer;
begin
  i:=lst2.ItemIndex;
  if i>=0 then
    lst2.Items.Delete(I)
end;
//添加所有
procedure TFrmGZGL_Print_YBB.btn_addALLClick(Sender: TObject);
begin
  lst2.Items:=lst1.items;
end;
procedure TFrmGZGL_Print_YBB.btn_delALLClick(Sender: TObject);
begin
  lst2.Clear;
end;
procedure TFrmGZGL_Print_YBB.lst1DblClick(Sender: TObject);
begin
  btn_add1Click(Sender);
end;
procedure TFrmGZGL_Print_YBB.Lst2DblClick(Sender: TObject);
begin
  btn_DEL1Click(Sender);
end;
{-----------------------------------------------------------------------------
  结束操作列表框
-----------------------------------------------------------------------------}

procedure TFrmGZGL_Print_YBB.btn_getdataClick(Sender: TObject);
var
  s:string;
begin
  if lst2.Count<1 then begin
    s:='喂，喂，懂不懂呵，连车型都没有报什么表！';
    pag1.ActivePageIndex:=0;
    MessageBox(application.handle,pchar(s),'错误',mb_ICONerror+mb_ok);
    exit;
  end;
  if (strlen(pchar(edt_y.Text))<>4)or(strlen(pchar(edt_m.Text))<>2) then begin
    s:='伙计，烦劳您输够4位日期和2位月份！';
    MessageBox(application.handle,pchar(s),'错误',mb_ICONerror+mb_ok);
    pag1.ActivePageIndex:=0;
    exit;
  end;
  pag1.ActivePageIndex:=1;
  lab_start.Caption:='开始于：'+timetostr(now);
  lab_over.Caption:='结束于：';
  lab_info.Caption:='正在处理数据......';
  self.Refresh;
  lab_info.Caption:='初始化报表......';
  emptyTbl;
  lab_info.Caption:='获取报表数据......';
  GetBaseData;
  lab_info.Caption:='整理获得数据......';
  CountGetedData;

  lab_over.Caption:='结束于：'+timetostr(now);
  lab_info.Caption:='数据处理完毕';
end;
//
procedure TFrmGZGL_Print_YBB.btn_previewClick(Sender: TObject);
begin
  with frmGZGL_Reports do begin
    Lab_Y.Caption:=EDT_Y.text+'年'+edt_m.text+'月';
    Lab_Y2.Caption:=Lab_Y.Caption;
  end;
  try
    FrmGZGL_Reports.QR_YBB.Preview;
  except

  end;
end;
//
procedure TFrmGZGL_Print_YBB.btn_printClick(Sender: TObject);
begin
  try
    //FrmGZGL_Reports.QR_YBB.print;
  except

  end;
end;
//
procedure TFrmGZGL_Print_YBB.btn_fixdataClick(Sender: TObject);
begin
  FixGetedData;
end;
//
procedure TFrmGZGL_Print_YBB.emptyTbl;
var
  s:string;
begin
  if dmd.Tbl_YBB.RecordCount<1 then exit;
  with dmd.qry_temp do begin
    s:='delete from 月末报表 ';
    if active then close;
    sql.Clear;