spkcyjb1.pas

思微POS连锁超市管理系统 (商业代码),几年前的东西了

unit spkcyjb1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, ADODB, ExtCtrls, dxTL, dxDBCtrl, dxDBGrid, dxCntner, StdCtrls,
  Buttons, dxPSCore, dxPSdxTLLnk, dxPSdxDBCtrlLnk, dxPSdxDBGrLnk, Menus;

type
  Tspkcyjb = class(TForm)
    dxDBGrid1: TdxDBGrid;
    DataSource1: TDataSource;
    Panel1: TPanel;
    Panel2: TPanel;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    PopupMenu1: TPopupMenu;
    N1: TMenuItem;
    Excel1: TMenuItem;
    Text1: TMenuItem;
    Html1: TMenuItem;
    dxComponentPrinter1: TdxComponentPrinter;
    ADOTable1: TADOQuery;
    ADOTable1ckcode: TStringField;
    ADOTable1ckname: TStringField;
    ADOTable1spcode: TStringField;
    ADOTable1spname: TStringField;
    ADOTable1lb: TStringField;
    ADOTable1jldw: TStringField;
    ADOTable1bzgg: TBCDField;
    ADOTable1barcode: TStringField;
    ADOTable1kcsl: TBCDField;
    ADOTable1kcsx: TBCDField;
    ADOTable1kcxx: TBCDField;
    ADOTable1mainghs: TStringField;
    ADOTable1ghsname: TStringField;
    ADOTable1bz: TStringField;
    dxDBGrid1ckcode: TdxDBGridMaskColumn;
    dxDBGrid1ckname: TdxDBGridMaskColumn;
    dxDBGrid1spcode: TdxDBGridMaskColumn;
    dxDBGrid1spname: TdxDBGridMaskColumn;
    dxDBGrid1lb: TdxDBGridMaskColumn;
    dxDBGrid1jldw: TdxDBGridMaskColumn;
    dxDBGrid1bzgg: TdxDBGridMaskColumn;
    dxDBGrid1barcode: TdxDBGridMaskColumn;
    dxDBGrid1kcsl: TdxDBGridMaskColumn;
    dxDBGrid1kcsx: TdxDBGridMaskColumn;
    dxDBGrid1kcxx: TdxDBGridMaskColumn;
    dxDBGrid1mainghs: TdxDBGridMaskColumn;
    dxDBGrid1ghsname: TdxDBGridMaskColumn;
    dxDBGrid1bz: TdxDBGridMaskColumn;
    BitBtn6: TBitBtn;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    dxComponentPrinter1Link1: TdxDBGridReportLink;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Button3: TButton;
    SaveDialog1: TSaveDialog;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure Excel1Click(Sender: TObject);
    procedure Text1Click(Sender: TObject);
    procedure Html1Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  spkcyjb: Tspkcyjb;

implementation

uses MainForm1;

{$R *.DFM}

procedure Tspkcyjb.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action := cafree;
end;

procedure Tspkcyjb.BitBtn1Click(Sender: TObject);
begin
  ADOTable1.Close;
  ADOTable1.sql.clear;
  ADOTable1.sql.add('select * from KCYJ_V where spname like :spname and kcsl>kcsx');
  ADOTable1.Parameters[0].Value := Edit1.Text + '%';
  ADOTable1.Open;
end;

procedure Tspkcyjb.BitBtn2Click(Sender: TObject);
begin
  ADOTable1.Close;
  ADOTable1.sql.clear;
  ADOTable1.sql.add('select * from KCYJ_V where spname like :spname and kcsl<kcxx');
  ADOTable1.Parameters[0].Value := Edit1.Text + '%';
  ADOTable1.Open;
end;

procedure Tspkcyjb.BitBtn4Click(Sender: TObject);
begin
  close;
end;

procedure Tspkcyjb.BitBtn5Click(Sender: TObject);
var aa, bb, cc: string;
begin
  if Edit1.Text = '' then aa := '%' else aa := Edit1.Text;
  if Edit2.Text = '' then bb := '%' else bb := Edit2.Text;
  if Edit3.Text = '' then cc := '%' else cc := Edit3.Text;
  ADOTable1.Close;
  ADOTable1.sql.clear;
  ADOTable1.sql.add('select * from KCYJ_V where spname like :spname and (spcode like :code or barcode like :barcode) and ckcode like :ckcode');
  ADOTable1.Parameters[0].Value := aa;
  ADOTable1.Parameters[1].Value := bb;
  ADOTable1.Parameters[2].Value := bb;
  ADOTable1.Parameters[3].Value := cc;
  ADOTable1.Open;
end;

procedure Tspkcyjb.BitBtn3Click(Sender: TObject);
begin
  dxComponentPrinter1.Preview(true, nil);
end;

procedure Tspkcyjb.Excel1Click(Sender: TObject);
begin
  SaveDialog1.Filter := 'Excel表格|*.xls';
  if SaveDialog1.Execute then
  begin
    dxDBGrid1.SaveToXLS(SaveDialog1.FileName, true);
    Application.MessageBox('文件已成功导出.', '提示', MB_OK + MB_ICONINFORMATION);
  end;
end;

procedure Tspkcyjb.Text1Click(Sender: TObject);
begin
  SaveDialog1.Filter := 'Text文件|*.txt';
  if SaveDialog1.Execute then
  begin
    dxDBGrid1.SaveToText(SaveDialog1.FileName, true, ',', '', '');
    Application.MessageBox('文件已成功导出.', '提示', MB_OK + MB_ICONINFORMATION);
  end;
end;

procedure Tspkcyjb.Html1Click(Sender: TObject);
begin
  SaveDialog1.Filter := 'Html文件|*.Html';
  if SaveDialog1.Execute then
  begin
    dxDBGrid1.SaveToHTML(SaveDialog1.FileName, true);
    Application.MessageBox('文件已成功导出.', '提示', MB_OK + MB_ICONINFORMATION);
  end;
end;

procedure Tspkcyjb.BitBtn6Click(Sender: TObject);
begin
  ADOTable1.Close;
  ADOTable1.sql.clear;
  ADOTable1.sql.add('select * from KCYJ_V where spname like :spname and kcsl<0');
  ADOTable1.Parameters[0].Value := Edit1.Text + '%';
  ADOTable1.Open;
end;

procedure Tspkcyjb.Button3Click(Sender: TObject);
begin
  SaveDialog1.Filter := 'Excel表格|*.xls';
  if SaveDialog1.Execute then
  begin
    dxDBGrid1.SaveToXLS(SaveDialog1.FileName, true);
    Application.MessageBox('文件已成功导出.', '提示', MB_OK + MB_ICONINFORMATION);
  end;
end;

end.