otherstorage.pas

完整的delphi书籍源代码,大家有空的时候自己慢慢看看

unit OtherStorage;

interface

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

type
  TOtherStorageFrm = class(TForm)
    GroupBox1: TGroupBox;
    Edit1: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    DateTimePicker1: TDateTimePicker;
    ComboBox3: TComboBox;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Button1: TButton;
    Button2: TButton;
    ADOTable1: TADOTable;
    ADOTable2: TADOTable;
    ADOQuery1: TADOQuery;
    Memo1: TMemo;
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure ComboBox2Change(Sender: TObject);
    procedure ComboBox3Change(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  OtherStorageFrm: TOtherStorageFrm;

implementation

{$R *.dfm}

procedure TOtherStorageFrm.FormCreate(Sender: TObject);
begin
  DateTimePicker1.date:=date;
  ADOtable1.first;
   while not ADOtable1.eof do
      begin
       combobox1.items.insert(-1,ADOtable1.fieldbyname('ProductCode').asstring);
       combobox2.items.insert(-1,ADOtable1.fieldbyname('ProductName').asstring);
       ADOtable1.Next;
      end;

   ADOtable2.first;
   while not ADOtable2.eof do
      begin
       combobox3.items.insert(-1,ADOtable2.fieldbyname('StorageName').asstring);
       ADOtable2.Next;
      end;
end;

procedure TOtherStorageFrm.ComboBox1Change(Sender: TObject);
begin
     with ADOQuery1 do
     begin
       close;
       sql.clear;
       sql.add('select * from Product where ProductCode='+''''+ComboBox1.text+'''');
       open;
       first;
       ComboBox2.text:=fieldbyname('ProductName').asstring;
       Edit2.text:=fieldbyname('Spec').asstring;
       Edit4.text:=fieldbyname('Unit').asstring;
       
     end;
end;

procedure TOtherStorageFrm.ComboBox2Change(Sender: TObject);
begin
    with ADOQuery1 do
     begin
       close;
       sql.clear;
       sql.add('select * from Product where ProductName='+''''+ComboBox2.text+'''');
       open;
       first;
       ComboBox1.text:=fieldbyname('ProductCode').asstring;
       Edit2.text:=fieldbyname('Spec').asstring;
       Edit4.text:=fieldbyname('Unit').asstring;

     end;
end;

procedure TOtherStorageFrm.ComboBox3Change(Sender: TObject);
begin
    with ADOQuery1 do
     begin
       close;
       sql.clear;
       sql.add('select * from OtherStoType where StorageName='+''''+ComboBox3.text+'''');
       open;
       first;
       Edit3.text:=fieldbyname('StorageType').asstring;
     end;
end;

procedure TOtherStorageFrm.Button2Click(Sender: TObject);
begin
   OtherStorageFrm.hide;
end;

procedure TOtherStorageFrm.Button1Click(Sender: TObject);
begin

  if edit1.text='' then
     showmessage('请填写对方名称！')
  else
   if combobox1.text='' then
     showmessage('请选择货品！')
   else
    if  combobox3.text='' then
     showmessage('请选择库存变动！')
     else
      if edit5.text='' then
       showmessage('请填写变动数量！')
   else
    begin
    with ADOQuery1 do
     begin
       close;
       sql.clear;
       sql.add('insert into OtherStorage (ObjectName,StorageDate,ProductCode,ProductName,');
       sql.add('Spec,Unit,Quantity,StorageName,StorageType,Remark)values (' );
       sql.add(''''+edit1.text+''''+','+''''+datetostr(DateTimePicker1.DATE)+''''+',');
       sql.add(''''+combobox1.text+''''+','+''''+combobox2.text+''''+',');
       sql.add(''''+edit2.text+''''+','+''''+edit4.text+''''+',');
       sql.add(''''+edit5.text+''''+','+''''+combobox3.text+''''+',');
       sql.add(''''+edit3.text+''''+','+''''+memo1.text+''''+')');
       execsql;
    end;
   showmessage('请库存变动登记成功！')
  end;
end;

end.