unit11.pas

商品销售管理系统

unit Unit11;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, StdCtrls, DBCtrls, Mask;

type
  TForm11 = class(TForm)
    GroupBox2: TGroupBox;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit3: TDBEdit;
    GroupBox1: TGroupBox;
    Edit1: TEdit;
    Label1: TLabel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit5: TDBEdit;
    Label7: TLabel;
    DBEdit6: TDBEdit;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    DBMemo1: TDBMemo;
    Label14: TLabel;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form11: TForm11;

implementation

uses Unit3, Unit1;

{$R *.dfm}

procedure TForm11.Button1Click(Sender: TObject);
begin
  with adoquery1 do
begin
  close;
  sql.clear;
  sql.add('select * from 合同');
  sql.add('where 合同编号 = :合同编号');
  parameters.parambyname('合同编号').value := edit1.text;
  open;
  edit1.Clear;
end;
if dbedit1.Text='' then
showmessage('没有此信息,请重新查询');
end;

procedure TForm11.Button2Click(Sender: TObject);
begin
   adoquery1.Post;
    adoquery1.sql.add('update 合同 set 合同编号= :合同编号,合同名=:合同名,商品编号=:商品编号,合同期限=:合同期限,合同签定日期=:合同签定日期,合同开始日期=:合同开始日期,合同结束日期:=合同结束日期');
    adoquery1.SQL.Add('员工姓名=:员工姓名,供应商姓名=:供应商姓名,总共货款=:总共货款,已付货款=:已付货款,所欠货款=:所欠货款,说明=:说明');
    adoquery1.sql.Add('where 合同号= :合同号');
    showmessage('修改成功');
end;

procedure TForm11.Button3Click(Sender: TObject);
begin
 adoquery1.Delete;
    adoquery1.SQL.Add('delete from 合同 where 合同编号= :合同编号,合同名=:合同名,商品编号=:商品编号,合同期限=:合同期限,合同签定日期=:合同签定日期,合同开始日期:=合同开始日期,合同结束日期:=合同结束日期');
    adoquery1.SQL.Add('员工姓名=:员工姓名,供应商姓名=:供应商姓名,总共货款=:总共货款,已付货款=:已付货款,所欠货款=:所欠货款,说明=:说明');
    adoquery1.sql.Add('where 合同号= :合同号');
    showmessage('删除成功');
end;

procedure TForm11.Button4Click(Sender: TObject);
begin
form11.Close;
form3.show;

end;

end.