unit glch_un;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, frmbase_un, bsMessages, bsSkinData, BusinessSkinForm, ADODB, DB,
  bsSkinCtrls, StdCtrls, bsSkinGrids, bsDBGrids, bsdbctrls, bsSkinHint;

type
  Tglch_frm = class(Tbase_frm)
    bsSkinPanel1: TbsSkinPanel;
    bsSkinDBGrid2: TbsSkinDBGrid;
    bsSkinPanel2: TbsSkinPanel;
    bsSkinStdLabel1: TbsSkinStdLabel;
    bsSkinStdLabel2: TbsSkinStdLabel;
    bsSkinSpeedButton1: TbsSkinSpeedButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    spgtlh: TADOStoredProc;
    bsSkinSpeedButton2: TbsSkinSpeedButton;
    bsSkinScrollBar3: TbsSkinScrollBar;
    bsSkinScrollBar4: TbsSkinScrollBar;
    bsSkinPanel3: TbsSkinPanel;
    bsSkinSpeedButton3: TbsSkinSpeedButton;
    bsSkinHint1: TbsSkinHint;
    bsSkinSpeedButton5: TbsSkinSpeedButton;
    bsSkinSpeedButton6: TbsSkinSpeedButton;
    bsSkinSpeedButton7: TbsSkinSpeedButton;
    bsSkinSpeedButton8: TbsSkinSpeedButton;
    procedure bsSkinSpeedButton1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure bsSkinDBGrid2CellClick(Column: TbsColumn);
    procedure bsSkinSpeedButton2Click(Sender: TObject);
    procedure bsSkinSpeedButton3Click(Sender: TObject);
    procedure bsSkinSpeedButton5Click(Sender: TObject);
    procedure bsSkinSpeedButton6Click(Sender: TObject);
    procedure bsSkinSpeedButton7Click(Sender: TObject);
    procedure bsSkinSpeedButton8Click(Sender: TObject);
  private
 
    { Private declarations }
  public
    { Public declarations }
  end;

var
  glch_frm: Tglch_frm;

implementation
       uses golb,data_un;
{$R *.dfm}


procedure Tglch_frm.bsSkinSpeedButton1Click(Sender: TObject);
begin
  inherited;
close;
end;

procedure Tglch_frm.FormShow(Sender: TObject);
begin
  inherited;
bsSkinStdLabel2.Caption:=golb.hrxxid;
ADOQuery1.open;
end;

procedure Tglch_frm.bsSkinDBGrid2CellClick(Column: TbsColumn);
var b:integer;
begin
  inherited;
  b:=bsSkinMessage1.MessageDlg('是否將此手機另外分配給：'+ADOQuery1.FieldValues['fname'],mtInformation, [mbYes, mbNo, mbCancel],0);
        if b=mryes then
              begin
                //ShowMessage('按YES');
                //存儲過程參數：操作類型 （insert,del,edit）手機流水線號，柜臺號,流水號類別GL，個數為 4；
                    try
                          with spgtlh do
                            begin
                              //Parameters.ParamValues['@IDType']:='GL';
                             // Parameters.ParamValues['@numb']:=4;
                              Parameters.ParamValues['@act']:=2;
                              Parameters.ParamValues['@gtlhid']:=golb.hrxxid;
                              
                              Parameters.ParamValues['@gtid']:=ADOQuery1.FieldValues['fid'];
                              ExecProc;

                             end ;
                    except
                        on E:Exception do
                             begin
                              bsSkinMessage1.MessageDlg('失敗！'+#13#10+E.Message,mterror,[mbOk],0);
                              Abort;
                              end;

                    end;
               close;
            end;

          if b=mrNO then
            begin
            end;
          if b=mrCancel then
               begin
              CLOSE;
             end;
end;

procedure Tglch_frm.bsSkinSpeedButton2Click(Sender: TObject);
var b:integer;
begin
  inherited;
    b:=bsSkinMessage1.MessageDlg('是否將此手機停止分配',mtInformation, [mbYes, mbNo, mbCancel],0);
        if b=mryes then
              begin
                //ShowMessage('按YES');
                //存儲過程參數：操作類型 （insert,del,edit）手機流水線號，柜臺號,流水號類別GL，個數為 4；
                    try
                          with spgtlh do
                            begin
                              //Parameters.ParamValues['@IDType']:='GL';
                             // Parameters.ParamValues['@numb']:=4;
                              Parameters.ParamValues['@act']:=3;
                              Parameters.ParamValues['@gtlhid']:=golb.hrxxid;
                             // Parameters.ParamValues['@gtid']:=ADOQuery1.FieldValues['fid'];
                              ExecProc;
                             end ;
                    except
                        on E:Exception do
                             begin
                              bsSkinMessage1.MessageDlg('失敗！'+#13#10+E.Message,mterror,[mbOk],0);
                              Abort;
                              end;

                    end;
  close;
end;
if b=mrNO then
            begin
            end;
          if b=mrCancel then
               begin
              CLOSE;
             end;

end;

procedure Tglch_frm.bsSkinSpeedButton3Click(Sender: TObject);
var b:integer;
begin
  inherited;
  b:=bsSkinMessage1.MessageDlg('是否將此手機另外分配給：'+ADOQuery1.FieldValues['fname'],mtInformation, [mbYes, mbNo, mbCancel],0);
        if b=mryes then
              begin
                //ShowMessage('按YES');
                //存儲過程參數：操作類型 （insert,del,edit）手機流水線號，柜臺號,流水號類別GL，個數為 4；
                    try
                          with spgtlh do
                            begin
                              //Parameters.ParamValues['@IDType']:='GL';
                             // Parameters.ParamValues['@numb']:=4;
                              Parameters.ParamValues['@act']:=2;
                              Parameters.ParamValues['@gtlhid']:=golb.hrxxid;
                              
                              Parameters.ParamValues['@gtid']:=ADOQuery1.FieldValues['fid'];
                              ExecProc;

                             end ;
                    except
                        on E:Exception do
                             begin
                              bsSkinMessage1.MessageDlg('失敗！'+#13#10+E.Message,mterror,[mbOk],0);
                              Abort;
                              end;

                    end;
               close;
            end;

          if b=mrNO then
            begin
            end;
          if b=mrCancel then
               begin
              CLOSE;
             end;

end;

procedure Tglch_frm.bsSkinSpeedButton5Click(Sender: TObject);
begin
  inherited;
ADOQuery1.First;
end;

procedure Tglch_frm.bsSkinSpeedButton6Click(Sender: TObject);
begin
  inherited;
ADOQuery1.Prior;
end;

procedure Tglch_frm.bsSkinSpeedButton7Click(Sender: TObject);
begin
  inherited;
ADOQuery1.Next;
end;

procedure Tglch_frm.bsSkinSpeedButton8Click(Sender: TObject);
begin
  inherited;
ADOQuery1.Last;
end;

end.