qclyjeb.~pas

仓库管理信息系统

unit qclyjeb;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ComCtrls, ExtCtrls, Grids, DBGridEh, FR_DSet,
  FR_DBSet, FR_Class, Menus, PrnDbgeh, StdActns, ActnList, DBGridEhImpExp,
  ActnMan;

type
  Tqclyfrm = class(TForm)
    GroupBox1: TGroupBox;
    Label8: TLabel;
    dtp1: TDateTimePicker;
    Label9: TLabel;
    dtp2: TDateTimePicker;
    Button1: TButton;
    Edit1: TEdit;
    Label1: TLabel;
    Panel1: TPanel;
    Button2: TButton;
    DBGridEh1: TDBGridEh;
    SaveDialog1: TSaveDialog;
    ActionManager1: TActionManager;
    EditCut1: TEditCut;
    EditCopy1: TEditCopy;
    EditPaste1: TEditPaste;
    EditDelete1: TEditDelete;
    FilePrintSetup1: TFilePrintSetup;
    FontEdit1: TFontEdit;
    ColorSelect1: TColorSelect;
    PrintDlg1: TPrintDlg;
    MYPDBGEh: TPrintDBGridEh;
    PopupMenu1: TPopupMenu;
    N2: TMenuItem;
    N5: TMenuItem;
    N6: TMenuItem;
    PrintSetup1: TMenuItem;
    N1: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    procedure FormCreate(Sender: TObject);
    procedure Edit1KeyUp(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FontEdit1Accept(Sender: TObject);
    procedure PrintSetup1Click(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
        date1,date2:tdate;
    year,month,day:Word;
  end;

var
  qclyfrm: Tqclyfrm;

implementation
uses data, main;
{$R *.dfm}

procedure Tqclyfrm.FormCreate(Sender: TObject);
begin
decodedate(now,year,month,day);
  if month=1 then
  begin
    dtp1.Date:=EncodeDate(Year-1,12,26);
    dtp2.Date:=EncodeDate(Year,1,25);
  end
  else
  begin
    dtp1.Date:=EncodeDate(Year,Month-1,26);
    dtp2.Date:=EncodeDate(Year,Month,25);
  end;
  dm.whbmdmads.Open;
  dm.whclbmads.Open;
end;

procedure Tqclyfrm.Edit1KeyUp(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
dm.QCLYADS.Filtered:=false;
if trim(edit1.Text)<>''  then
begin
  dm.QCLYADS.Filter:='材料编码 like %'+trim(edit1.Text)+'%';
  dm.QCLYADS.Filtered:=true;
end;
end;

procedure Tqclyfrm.Button1Click(Sender: TObject);
begin
dm.QCLYADS.Close;
dm.QCLYADS.CommandText:='SELECT 部门ID, 材料编码,'+
    ' SUM(金额) AS 金额 FROM dbo.bmlymxb '+
    ' where 出仓日期>='+
    FormatDateTime('yy-mm-dd',dtp1.Date)+
    ' and 出仓日期<='+
    FormatDateTime('yy-mm-dd',Dtp2.Date)+
    ' and 仓库ID='+''''+mainfrm.CKid+''''+    
    ' GROUP BY 部门ID, 材料编码 '+
    ' ORDER BY 部门ID, 材料编码';
dm.QCLYADS.Open;
end;

procedure Tqclyfrm.Button2Click(Sender: TObject);
begin
close;
end;

procedure Tqclyfrm.FontEdit1Accept(Sender: TObject);
begin
TDBGridEh(ActiveControl).Font:=FontEdit1.Dialog.Font;
TDBGridEh(ActiveControl).FooterFont:=FontEdit1.Dialog.Font;
TDBGridEh(ActiveControl).TitleFont:=FontEdit1.Dialog.Font
end;

procedure Tqclyfrm.PrintSetup1Click(Sender: TObject);
var bt,tj:string;
begin
  bt:='全厂领用金额表';
  tj:=' 出仓日期从：'+
    FormatDateTime('yy-mm-dd',dtp1.Date)+
    '到'+FormatDateTime('yy-mm-dd',Dtp2.Date) ;
  if (ActiveControl is TDBGridEh) then
  begin
    MYPDBGEh.DBGridEh := TDBGridEh(ActiveControl);
    MYPDBGEh.SetSubstitutes(['%[Today]',DateToStr(Now),'%[bt]',bt,'%[tj]',tj]);
    MYPDBGEh.print;
  end;
end;

procedure Tqclyfrm.N1Click(Sender: TObject);
var bt,tj:string;
begin
  bt:='全厂领用金额表';
  tj:=' 出仓日期从：'+
    FormatDateTime('yy-mm-dd',dtp1.Date)+
    '到'+FormatDateTime('yy-mm-dd',Dtp2.Date);
  if (ActiveControl is TDBGridEh) then
  begin
    MYPDBGEh.DBGridEh := TDBGridEh(ActiveControl);
    MYPDBGEh.SetSubstitutes(['%[Today]',DateToStr(Now),'%[bt]',bt,'%[tj]',tj]);
    MYPDBGEh.preview;
  end;
end;

procedure Tqclyfrm.N4Click(Sender: TObject);
var ExpClass:TDBGridEhExportClass;
    Ext:String;
begin
  SaveDialog1.FileName := 'file1';
  if (ActiveControl is TDBGridEh) then
    if SaveDialog1.Execute then
    begin
      case SaveDialog1.FilterIndex of
        1: begin ExpClass := TDBGridEhExportAsXLS; Ext := 'xls'; end;
        2: begin ExpClass := TDBGridEhExportAsCSV; Ext := 'csv'; end;
        3: begin ExpClass := TDBGridEhExportAsHTML; Ext := 'htm'; end;
        4: begin ExpClass := TDBGridEhExportAsRTF; Ext := 'rtf'; end;
        5: begin ExpClass := TDBGridEhExportAsText; Ext := 'txt'; end;
      else
        ExpClass := nil; Ext := '';
      end;
      if ExpClass <> nil then
      begin
        if UpperCase(Copy(SaveDialog1.FileName,Length(SaveDialog1.FileName)-2,3)) <>
           UpperCase(Ext) then
          SaveDialog1.FileName := SaveDialog1.FileName + '.' + Ext;
        SaveDBGridEhToExportFile(ExpClass,TDBGridEh(ActiveControl),
             SaveDialog1.FileName,true);
      end;
    end;
end;

procedure Tqclyfrm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
qclyfrm:=nil;
end;

end.