unitcomgh.pas

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

unit UnitComGH;

interface

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

type
  TfrmComGH = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Button1: TButton;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    Button2: TButton;
    Edit2: TEdit;
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Select(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
    SerialNO:array of Integer;
  public
    { Public declarations }
  end;

var
  frmComGH: TfrmComGH;

implementation

uses UnitDM,UnitPub;

{$R *.dfm}

procedure TfrmComGH.FormCreate(Sender: TObject);
var
  index:Integer;
begin
  index:=0;

  DM.ComCZDS.Close;
  DM.ComCZDS.CommandText:='select * from 一般租赁 where 已归还 = 0';
  DM.ComCZDS.Open;

  SetLength(SerialNO,DM.ComCZDS.RecordCount);

  DM.ComCZDS.First;
  while not DM.ComCZDS.Eof do
  begin
    SerialNO[index]:=DM.ComCZDS.fieldByName('序号').AsInteger;
    ComboBox1.Items.Add(DM.ComCZDS.FieldByName('影片号').AsString);
    DM.ComCZDS.Next;
    index:=index+1;
  end;
  ComboBox1.ItemIndex:=0;
  Combobox1.OnSelect(self);
end;

procedure TfrmComGH.ComboBox1Select(Sender: TObject);
var
  moneyreq:TDateTime;
begin
  if ComboBox1.Items.Count=0 then
    Exit;
  DM.ComCZDS.Locate('序号',SerialNO[ComboBox1.ItemIndex],[]);
  Edit1.Text:=DateTimeToStr(Now());
  DM.AllFilmDS.Locate('影片号',ComboBox1.Text,[]);
  moneyreq:=GetInterval(DM.ComCZDS.FieldByName('租借日期').AsDateTime,Now())*DM.AllFilmDS.FieldByName('日租金').AsFloat;
  Edit2.Text:=Format('%.2f',[int(moneyreq)]);
end;

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

procedure TfrmComGH.Button1Click(Sender: TObject);
begin
  if ComboBox1.Text='' then
  begin
    ShowMessage('请选择归还的影片号先！');
    Exit;
  end;

  ShowMessage('应收取租金：'+Edit2.Text+'     并返还押金：'+DBEdit2.Text);

  DM.ComCZDS.Edit;
  DM.ComCZDS.FieldByName('归还日期').AsString:=Edit1.Text;
  DM.ComCZDS.FieldByName('应付租金').AsString:=Edit2.Text;
  DM.ComCZDS.FieldByName('已归还').AsBoolean:=True;
  DM.ComCZDS.UpdateBatch();

  DM.AllFilmDS.Locate('影片号',ComboBox1.Text,[]);
  DM.AllFilmDS.Edit;
  DM.AllFilmDS.FieldByName('状态').AsString:='可借';
  DM.AllFilmDS.UpdateBatch();

  DM.ComCZDS.Close;
  DM.ComCZDS.CommandText:='select * from 一般租赁';
  DM.ComCZDS.Open;

  ShowMessage('成功归还');
  frmComGH.Close;
end;

procedure TfrmComGH.Button2Click(Sender: TObject);
begin
  frmComGH.Close;
end;

end.