unitmencz.pas

一个音像租赁店铺的管理软件,可以维护影片库信息和会员信息,及日常业务的实现(出租/归还).这是我学delphi整一个月的纪念品,有些简单,不过我还是希望和大家分享一下我的成长历程.

unit UnitMenCZ;

interface

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

type
  TfrmMenCZ = class(TForm)
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    DBEdit9: TDBEdit;
    Label10: TLabel;
    DBEdit10: TDBEdit;
    Label11: TLabel;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    DBEdit12: TDBEdit;
    Button1: TButton;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Select(Sender: TObject);
    procedure ComboBox2Select(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmMenCZ: TfrmMenCZ;

implementation

uses UnitDM, UnitComCZ;

{$R *.dfm}

procedure TfrmMenCZ.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=caFree;
  frmMenCZ:=nil;
end;

procedure TfrmMenCZ.FormCreate(Sender: TObject);
var
  selectedID:String;
begin
  DM.MenCZDS.Append;
  {影片部分}
  if DM.AllFilmDS.fieldByName('状态').AsString='可借' then
    selectedID:=DM.AllFilmDS.fieldByName('影片号').AsString
  else
    selectedID:='';

  DM.AllFilmDS.First;
  while not DM.AllFilmDS.Eof do
  begin
    if DM.AllFilmDS.FieldByName('状态').AsString='可借' then
    ComboBox1.Items.Add(DM.AllFilmDS.FieldByname('影片号').AsString);
    DM.AllFilmDS.Next;
  end;

  if selectedID='' then
    ComboBox1.ItemIndex:=0
  else
    ComboBox1.Text:=selectedID;
    
  ComboBox1.OnSelect(self);
  {会员部分}
  selectedID:=DM.MenberDS.FieldByName('会员号').AsString;
  DM.MenberDS.Refresh;
  DM.MenberDS.First;
  while not DM.MenberDS.Eof do
  begin
    ComboBox2.Items.Add(DM.MenberDS.FieldByName('会员号').AsString);
    DM.MenberDS.Next;
  end;
  ComboBox2.Text:=selectedID;
  ComboBox2.OnSelect(self);
end;

procedure TfrmMenCZ.ComboBox1Select(Sender: TObject);
begin
  DM.AllFilmDS.Locate('影片号',ComboBox1.Text,[]);
  DBEdit9.Text:=DM.AllFilmDS.FieldByName('影片号').AsString;
  DBEdit11.Text:=DM.AllFilmDS.FieldByName('需要押金').AsString;
end;

procedure TfrmMenCZ.ComboBox2Select(Sender: TObject);
begin
  DM.MenberDS.Locate('会员号',ComboBox2.Text,[]);
  DBEdit10.Text:=DM.MenberDS.FieldByName('会员号').AsString;
end;

procedure TfrmMenCZ.Button1Click(Sender: TObject);
begin
  if DM.MenberDS.FieldByName('可用片次').AsInteger=0 then
    begin
      ShowMessage('该会员已经没有会费，出租失败！');
      Exit;
    end
  else if DM.MenberDS.FieldByName('可用片次').AsInteger=1 then
    begin
      ShowMessage('提示：该会员会费不多了！');
    end;
  DM.MenCZDS.UpdateBatch();
  DM.MenCZDS.Refresh;
  DM.AllFilmDS.Locate('影片号',ComboBox1.Text,[]);
  DM.AllFilmDS.Edit;
  DM.AllFilmDS.FieldByName('状态').AsString:='已借出';
  DM.AllFilmDS.UpdateBatch();

  ShowMessage('出租成功');
  frmMenCZ.Close;
end;

end.