unit pfm_sptuihuod;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Mask, Buttons, Db, DBTables, ComCtrls, DBCtrls;

type
  Tfm_sptuihuodsel = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    BBtnOK: TBitBtn;
    Label3: TLabel;
    SProc1: TStoredProc;
    Query1: TQuery;
    DTPicker1: TDateTimePicker;
    BBtnCancel: TBitBtn;
    Label4: TLabel;
    Label21: TLabel;
    Label20: TLabel;
    Label22: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    ListBox1: TListBox;
    ListBox2: TListBox;
    Edit3: TEdit;
    procedure FormCreate(Sender: TObject);
    procedure BBtnOKClick(Sender: TObject);
    procedure BBtnCancelClick(Sender: TObject);
  private
    { Private declarations }
  public

    mDateTime:TDateTime;
    mLsh:integer;
    mCkmc:string;
    mGysmc:string;
    mJbrm:string;
    mShrm:string;
    mCzym:string;
  { Public declarations }
  end;

var
  fm_sptuihuodsel: Tfm_sptuihuodsel;

implementation

{$R *.DFM}

procedure Tfm_sptuihuodsel.FormCreate(Sender: TObject);
begin

        //初始化流水號
        try
            sproc1.Prepare;
            SProc1.ParamByName('@chTable').asstring:='tb_sptuihuod';
            SProc1.ExecProc;
            edit1.text:=SProc1.parambyname('@intlsh').asstring;
            sproc1.UnPrepare;
        except
        on E:Exception do
          begin
               showmessage('取流水號失敗');
               close;
          end;
        end;
        //提供倉庫列表
        query1.sql.clear;
        query1.sql.add('select ckmc from t_ckxx');
        query1.Open;
        while not query1.Eof do
        begin
            listBox1.items.Add(query1.fieldbyname('ckmc').asstring);
            query1.Next;
        end;
        query1.close;
        //提供供應商列表
        query1.sql.clear;
        query1.sql.add('select gysmc from t_gysxx');
        query1.Open;
        while not query1.Eof do
        begin
            listBox2.items.Add(query1.fieldbyname('gysmc').asstring);
            query1.Next;
        end;
        query1.close;
        //加入初始日期
        dtpicker1.datetime:=now();

end;

procedure Tfm_sptuihuodsel.BBtnOKClick(Sender: TObject);
begin
        if listbox1.itemindex<0 then
        begin
                showmessage('選擇進貨倉庫！');
                exit;
        end;
        if   listbox2.itemindex<0 then
        begin
                showmessage('請選擇供應商名稱');
                exit;
        end;

       mDateTime:=DTpicker1.DateTime;
       mLsh:=strtoint(edit1.text);
       mCkmc:=ListBox1.items.strings[listBox1.itemindex];
       mGysmc:=ListBox2.items.strings[listBox2.itemindex];
       mJbrm:=edit2.text;
       mShrm:=edit3.text;
       mCzym:=edit4.text;
       ModalResult:=mrOK;
end;

procedure Tfm_sptuihuodsel.BBtnCancelClick(Sender: TObject);
begin
        ModalResult:=mrCancel;
end;
end.