cpkccsh.pas

仓库管理信息系统

unit cpkccsh;

interface

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

type
  Tfrm_cpkccsh = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    DBNavigator1: TDBNavigator;
    Edit1: TEdit;
    dblk_cplx: TDBLookupComboBox;
    dbgeh_cpzl: TDBGridEh;
    Panel2: TPanel;
    Label3: TLabel;
    Edit2: TSpinEdit;
    ActionManager1: TActionManager;
    EditCut1: TEditCut;
    EditCopy1: TEditCopy;
    EditPaste1: TEditPaste;
    EditDelete1: TEditDelete;
    FilePrintSetup1: TFilePrintSetup;
    FontEdit1: TFontEdit;
    ColorSelect1: TColorSelect;
    PrintDlg1: TPrintDlg;
    SaveDialog1: TSaveDialog;
    MYPDBGEh: TPrintDBGridEh;
    PopupMenu1: TPopupMenu;
    N2: TMenuItem;
    N5: TMenuItem;
    N6: TMenuItem;
    PrintSetup1: TMenuItem;
    N1: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N7: TMenuItem;
    N8: TMenuItem;
    N9: TMenuItem;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure Edit1KeyUp(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure dblk_cplxCloseUp(Sender: TObject);
    procedure FontEdit1Accept(Sender: TObject);
    procedure PrintSetup1Click(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N8Click(Sender: TObject);
    procedure N9Click(Sender: TObject);
    procedure MYPDBGEhBeforePrint(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure Edit2Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
     year,month,day:Word;
  end;

var
  frm_cpkccsh: Tfrm_cpkccsh;

implementation
uses data;

{$R *.dfm}

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

procedure Tfrm_cpkccsh.FormCreate(Sender: TObject);
begin
decodedate(now,year,month,day);
edit2.Value:=year;
dm.zlads_cplx.Close;
dm.cshads_cpkc.Close;
dm.cshads_cpkc.Parameters.ParamByName('nf').Value:=year;
dm.zlads_cplx.open;
dm.cshads_cpkc.open;
end;

procedure Tfrm_cpkccsh.Edit1KeyUp(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
if (key=vk_return) and (not dm.cshads_cpkc.Modified) then
begin
  dblk_cplx.KeyValue:=null;
  dm.cshads_cpkc.Filtered:=false;
  IF TRIM(EDIT1.Text)<>'' THEN
  BEGIN
      dm.cshads_cpkc.Filter:='产品ID like '+''''+
      trim(edit1.Text)+'%'+'''';
      dm.cshads_cpkc.Filtered:=true;
  END;
end;
end;

procedure Tfrm_cpkccsh.dblk_cplxCloseUp(Sender: TObject);
begin
edit1.Text:='';
dm.cshads_cpkc.Filtered:=false;
if dblk_cplx.KeyValue<>null then
begin
  dm.cshads_cpkc.Filter:='分类ID='+''''+dblk_cplx.KeyValue+'''';
  dm.cshads_cpkc.Filtered:=true;
end;
end;

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

procedure Tfrm_cpkccsh.PrintSetup1Click(Sender: TObject);
var bt,tj:string;
begin
  bt:=inttostr(year)+'年产品年初库存表';
  if (ActiveControl is TDBGridEh) then
  begin
    MYPDBGEh.DBGridEh := TDBGridEh(ActiveControl);
    MYPDBGEh.SetSubstitutes(['%[Today]',DateToStr(Now),'%[bt]',bt,'%[tj]',tj]);
    MYPDBGEh.print;
  end;
end;

procedure Tfrm_cpkccsh.N1Click(Sender: TObject);
var bt,tj:string;
begin
  bt:=inttostr(year)+'年产品年初库存表';
  if (ActiveControl is TDBGridEh) then
  begin
    MYPDBGEh.DBGridEh := TDBGridEh(ActiveControl);
    MYPDBGEh.SetSubstitutes(['%[Today]',DateToStr(Now),'%[bt]',bt,'%[tj]',tj]);
    MYPDBGEh.Preview;
  end;
end;

procedure Tfrm_cpkccsh.N8Click(Sender: TObject);
begin
TDBGridEh(ActiveControl).Columns
  [TDBGridEh(ActiveControl).SelectedIndex].Visible:=false;
if TDBGridEh(ActiveControl).SelectedIndex<
  TDBGridEh(ActiveControl).Columns.Count-1 then
TDBGridEh(ActiveControl).SelectedIndex:=
  TDBGridEh(ActiveControl).SelectedIndex+1;
end;

procedure Tfrm_cpkccsh.N9Click(Sender: TObject);
var i:integer;
begin
  for i:=1 to TDBGridEh(ActiveControl).Columns.Count-1 do
  begin
      begin
        TDBGridEh(ActiveControl).Columns[i].Visible:=true;
      end;
  end;
end;

procedure Tfrm_cpkccsh.MYPDBGEhBeforePrint(Sender: TObject);
begin
if TDBGridEh(ActiveControl).DataSource.DataSet.RecordCount=0 then
abort;
end;

procedure Tfrm_cpkccsh.N4Click(Sender: TObject);
var ExpClass:TDBGridEhExportClass;
    Ext:String;
begin
  SaveDialog1.FileName := '';
  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 Tfrm_cpkccsh.Edit2Change(Sender: TObject);
begin
dm.cshads_cpkc.Close;
dm.cshads_cpkc.Parameters.ParamByName('nf').Value:=edit2.Value;
dm.cshads_cpkc.open;
end;

end.