unit cw_kfspgl;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, DBCtrls, StdCtrls, Mask, Grids, DBGrids, Buttons,
  DBTables, DB;

type
  TForm3 = class(TForm)
    T_sp: TTable;
    DS_sp: TDataSource;
    Label1: TLabel;
    Q_repeat: TQuery;
    Q_lb: TQuery;
    SpeedButton1: TSpeedButton;
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    GroupBox2: TGroupBox;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Button1: TButton;
    SP_bm: TMaskEdit;
    SP_mc: TEdit;
    SP_lx: TComboBox;
    SP_dj: TMaskEdit;
    SP_dw: TEdit;
    SP_py: TMaskEdit;
    sp_kc: TComboBox;
    sp_mj: TMaskEdit;
    DBNavigator1: TDBNavigator;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Q_spTypeNo: TQuery;
    Label17: TLabel;
    dz: TComboBox;
    procedure FormShow(Sender: TObject);
    procedure SP_bmExit(Sender: TObject);
    procedure SP_bmKeyPress(Sender: TObject; var Key: Char);
    procedure SP_mcExit(Sender: TObject);
    procedure SP_mcKeyPress(Sender: TObject; var Key: Char);
    procedure SP_lxKeyPress(Sender: TObject; var Key: Char);
    procedure SP_djKeyPress(Sender: TObject; var Key: Char);
    procedure sp_mjKeyPress(Sender: TObject; var Key: Char);
    procedure SP_dwKeyPress(Sender: TObject; var Key: Char);
    procedure SP_pyKeyPress(Sender: TObject; var Key: Char);
    procedure sp_kcKeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

{$R *.dfm}

procedure TForm3.FormShow(Sender: TObject);
begin
  SP_bm.EditMask:='0000;1; ';
  SP_bm.SetFocus;
  Sp_mc.Text:='';
  Sp_dj.Text:='0';
  sp_mj.Text:='0';
  sp_dw.Text:='';
  sp_py.Text:='';
  sp_kc.Text:='';
  Q_lb.Active:=False;
  Q_lb.Close;
  Q_lb.Open;
   sp_lx.Clear;
  Q_lb.Active:=True;
while not Q_lb.Eof do
        begin
          sp_lx.Items.Add(Q_lb.FieldByName('TypeName').AsString);
          Q_lb.Next;
        end;


end;

procedure TForm3.SP_bmExit(Sender: TObject);
begin
  Q_repeat.Close;
  Q_repeat.SQL.Clear;
  Q_repeat.SQL.Add('select * from Menu where MenuNo='''+SP_bm.Text+'''');
  Q_repeat.Open;
  if not Q_repeat.Eof then
    begin
      sp_bm.Clear;
      sp_bm.SetFocus;
      MessageDlg('您輸入的編碼有重復，請重新輸入！',mtError,[mbok],0);
    end;

end;

procedure TForm3.SP_bmKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.SP_mcExit(Sender: TObject);
begin
  Q_repeat.Close;
  Q_repeat.SQL.Clear;
  Q_repeat.SQL.Add('select * from Menu where MenuName='''+SP_mc.Text+'''');
  Q_repeat.Open;
  if not Q_repeat.Eof then
    begin
      sp_mc.Clear;
      sp_mc.SetFocus;
      MessageDlg('您輸入的名稱有重復，請重新輸入！',mtError,[mbok],0);
    end;

end;

procedure TForm3.SP_mcKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.SP_lxKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.SP_djKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.sp_mjKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.SP_dwKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.SP_pyKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.sp_kcKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm3.Button1Click(Sender: TObject);
 var
  SelectSplb:string;
  splbno:integer;
begin
 if (length(sp_mc.Text)=0) or (length(sp_kc.Text)=0) then
  begin
   MessageDlg('輸入錯誤，請重新輸入！',mtError,[mbok],0);
   end
  else
   begin
//根據當前輸入的商品類別取出Dtype表中該類商品的TypeNo;
     SelectSplb:=SP_lx.Text;
     Q_spTypeNo.SQL.Clear;
     Q_spTypeNo.SQL.Add('select * from Dtype where Typename='''+SelectSplb+'''');
     Q_spTypeNo.Open;
     splbno:=Q_spTypeNo.FieldByName('TypeNo').Asinteger;
     Q_spTypeNo.Close;
//結束
 T_sp.Open;
 T_sp.Append;
 T_sp['MenuNo']:=sp_bm.Text;
 T_sp['MenuName']:=Sp_mc.Text;
 T_sp['MenuType']:=splbno;
 T_sp['TypeName']:=sp_lx.Text;
 T_sp['Price']:=StrToFloat(sp_dj.Text);
 T_sp['SalePrice']:=StrToFloat(sp_mj.Text);
 T_sp['Unit']:=sp_dw.Text;
 T_sp['py']:=sp_py.Text;
 T_sp['kc']:=sp_kc.Text;
 T_sp['dz']:=dz.Text;
 T_sp.Post;
 T_sp.Close;
 T_sp.Open;
 sp_bm.Clear;
 sp_mc.Clear;
 sp_dj.Clear;
 sp_dw.Clear;
 sp_py.Clear;
 sp_bm.SetFocus;
 end;

end;

procedure TForm3.SpeedButton1Click(Sender: TObject);
begin
 close;
end;

end.