tclbxz.pas

来自「日昌餐饮管理系统是用Delphi7+SQL写的管理系统」· PAS 代码 · 共 92 行

unit tclbxz;

interface

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

type
  TtclbForm = class(TForm)
    CheckListBox1: TCheckListBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    DBGrid2: TDBGrid;
    Query2: TQuery;
    UpdateSQL1: TUpdateSQL;
    DataSource2: TDataSource;
    procedure FormActivate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBGrid2DblClick(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  tclbForm: TtclbForm;

implementation

uses cdwh;

{$R *.dfm}

procedure TtclbForm.FormActivate(Sender: TObject);
begin
     query2.ParamByName('cs').AsString:=gjsswhForm.query1bh.Value;
     query2.Open;
end;

procedure TtclbForm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     query2.Close;
end;

procedure TtclbForm.DBGrid2DblClick(Sender: TObject);
begin
     if query2.RecordCount>0 then
     query2.Delete;
     query2.ApplyUpdates;
end;

procedure TtclbForm.BitBtn1Click(Sender: TObject);
var i,j:integer;
    stt:string;
begin
     if edit1.Text='' then begin
       showmessage('请输入可选数量');
       edit1.SetFocus;
       exit;
     end;
     Query2.Append;
     Query2.FieldByName('zcbh').Value:=gjsswhForm.query1bh.Value;
     Query2.FieldByName('pclb').Value:='';
     Query2.FieldByName('pcbh').Value:='';
     for i:=0 to checklistbox1.Items.Count -1 do
     begin
       if checklistbox1.Checked[i] then
       begin
         j:=pos('——',checklistbox1.Items.Strings[i]);
         stt:=copy(checklistbox1.Items.Strings[i],j+4,10);
         Query2.FieldByName('pclb').Value:=Query2.FieldByName('pclb').Value+stt+';';
       end;
     end;
     Query2.FieldByName('sl').AsInteger:=strtoint(edit1.text);
     Query2.Post;
     query2.ApplyUpdates;
end;

procedure TtclbForm.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  If Not(Key in ['0'..'9',#32,#8,#13]) Then key:=#0;
end;

end.