dfm_del.pas

仓库管理系统 仓库管理系统

unit dfm_del;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ComCtrls, StdCtrls, Buttons, ExtCtrls, Grids, DBGrids, Db, DBTables, Mask,
  DBCtrls, ADODB;

type
  Tdfmdel = class(TForm)
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Panel2: TPanel;
    delbtn: TBitBtn;
    postbtn: TBitBtn;
    quitbtn: TBitBtn;
    dssale: TDataSource;
    Label11: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label1: TLabel;
    Label2: TLabel;
    ComboBox1: TComboBox;
    ADOQuery1: TADOQuery;
    atblbranch: TADOTable;
    aqrysale: TADOQuery;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure quitbtnClick(Sender: TObject);
    procedure postbtnClick(Sender: TObject);
    procedure delbtnClick(Sender: TObject);
    procedure ComboBox1Enter(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dfmdel: Tdfmdel;

implementation

uses  dbmRainbowMis, chHeadUnit;

{$R *.DFM}

procedure Tdfmdel.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  atblbranch.Close;
  action:=cafree;
end;

procedure Tdfmdel.quitbtnClick(Sender: TObject);
begin
  close;
end;

procedure Tdfmdel.postbtnClick(Sender: TObject);
var
  fstr:String;
begin
  fstr:='SELECT t_saledet.bmh, t_saledet.rq, t_saledet.spbh, t_saledet.sl, t_saledet.sjje FROM t_saledet'
       +' WHERE t_saledet.bmh like ''%s'' AND ([t_saledet.rq])>=#%s# and ([t_saledet.rq])<=#%s#';
  with aqrysale do
  begin
    close;
    sql.Clear ;
    sql.Add(Format(fstr,[trim(ComboBox1.text)+'%',datetostr(DateTimePicker1.Date),datetostr(DateTimePicker2.Date)]));
    Prepared;
    open;
  end;
end;

procedure Tdfmdel.delbtnClick(Sender: TObject);
var
  fstr:String;
begin
  if Application.MessageBox('你确定要删除这些数据吗?','系统提示',MB_OKCANCEL)
    = IDOK then
  begin
    fstr:='delete FROM t_saledet'
        +' WHERE t_saledet.bmh like ''%s'' AND ([t_saledet.rq])>=#%s# and ([t_saledet.rq])<=#%s#';
    with ADOQuery1 do
    begin
      close;
      sql.Clear ;
      sql.Add(Format(fstr,[trim(ComboBox1.text)+'%',datetostr(DateTimePicker1.Date),datetostr(DateTimePicker2.Date)]));
      Prepared;
      ExecSQL;
    end;
    postbtnClick(postbtn);
  end;
end;

procedure Tdfmdel.ComboBox1Enter(Sender: TObject);
begin
  chHeadunit.combolist(combobox1,Atblbranch,'bmh','bmmc',1);
end;

procedure Tdfmdel.FormCreate(Sender: TObject);
begin
  atblbranch.Open;
end;

end.