unit Acr500_01;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, BAS200_10, dxExEdtr, ActnList, DB, ADODB, Menus, dxCntner, dxTL,
  dxDBCtrl, dxDBGrid, ExtCtrls, ComCtrls, ToolWin, StdCtrls,
  wwdbdatetimepicker, Buttons, dxDBTLCl, dxGrClms;

type
  TAcr500_01Form = class(TBas200_10Form)
    lblDate: TLabel;
    sbSearch: TSpeedButton;
    edtFromDate: TwwDBDateTimePicker;
    edtToDate: TwwDBDateTimePicker;
    ADOQuery1A500A_001: TWideStringField;
    ADOQuery1A500A_002: TDateTimeField;
    ADOQuery1A500A_003: TIntegerField;
    ADOQuery1A500A_004: TFloatField;
    ADOQuery1A500A_006: TMemoField;
    ADOQuery1A500A_007: TWideStringField;
    ADOQuery1A500A_008: TDateTimeField;
    ADOQuery1A500A_009: TWideStringField;
    ADOQuery1A500A_010: TDateTimeField;
    ADOQuery1H150_002: TWideStringField;
    ADOQuery1H150_003: TWideStringField;
    ADOQuery1A500A_005: TIntegerField;
    ADOQuery1A500A_011: TIntegerField;
    ADOQuery1A500A_012: TBCDField;
    ADOQuery1A500A_013: TIntegerField;
    ADOQuery1G100_002: TWideStringField;
    dxDBGrid1A500A_001: TdxDBGridColumn;
    dxDBGrid1A500A_002: TdxDBGridDateColumn;
    dxDBGrid1A500A_003: TdxDBGridMaskColumn;
    dxDBGrid1A500A_004: TdxDBGridMaskColumn;
    dxDBGrid1A500A_005: TdxDBGridMaskColumn;
    dxDBGrid1A500A_006: TdxDBGridMemoColumn;
    dxDBGrid1A500A_007: TdxDBGridColumn;
    dxDBGrid1A500A_008: TdxDBGridDateColumn;
    dxDBGrid1A500A_009: TdxDBGridColumn;
    dxDBGrid1A500A_010: TdxDBGridDateColumn;
    dxDBGrid1G100_002: TdxDBGridColumn;
    dxDBGrid1A500A_011: TdxDBGridMaskColumn;
    dxDBGrid1A500A_012: TdxDBGridCurrencyColumn;
    dxDBGrid1A500A_013: TdxDBGridMaskColumn;
    dxDBGrid1H150_002: TdxDBGridColumn;
    dxDBGrid1H150_003: TdxDBGridColumn;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure sbSearchClick(Sender: TObject);
    procedure ADOQuery1A500A_013GetText(Sender: TField; var Text: String;
      DisplayText: Boolean);
  private
    { Private declarations }
    ADisType:array[0..4] of string;
  public
    procedure SetInterface; override;
    procedure InsertEvent; override;
    procedure UpdateEvent; override;
    procedure DeleteEvent; override;
    procedure BrowseEvent; override;
    procedure ReportGetValue(const ParName: String; var ParValue: Variant); override;
    { Public declarations }
  end;

var
  Acr500_01Form: TAcr500_01Form;

implementation

uses Acr500_02, CommFun, SYSDATA,CshComm;

{$R *.dfm}

procedure TAcr500_01Form.SetInterface;
begin
  inherited;
  Caption:=GetDBString('Acr50001001');  //Caption
  ADOQuery1A500A_001.DisplayLabel:=GetDBString('Acr50001002');  //折扣單號
  ADOQuery1A500A_002.DisplayLabel:=GetDBString('Acr50001003');  //折扣日期
  ADOQuery1A500A_004.DisplayLabel:=GetDBString('Acr50001004');  //折扣金額
  ADOQuery1A500A_005.DisplayLabel:=GetDBString('Acr50001005');  //銷售單號
  ADOQuery1A500A_007.DisplayLabel:=GetDBString('Acr50001006');  //制單人員
  ADOQuery1A500A_008.DisplayLabel:=GetDBString('Acr50001007');  //制單日期
  ADOQuery1A500A_009.DisplayLabel:=GetDBString('Acr50001008');  //修改人員
  ADOQuery1A500A_010.DisplayLabel:=GetDBString('Acr50001009');  //修改日期
  ADOQuery1H150_003.DisplayLabel:=GetDBString('Acr50001010');  //折扣人員
  lblDate.Caption:=GetDBString('Acr50001011');  //日期

  ADisType[1]:=GetDBString('Acr50001012');  //按任務工單折扣
  ADisType[0]:=GetDBString('Acr50001013');  //按銷售訂單折扣
end;

procedure TAcr500_01Form.FormCreate(Sender: TObject);
var
  ADate:TDateTime;
begin
  inherited;
  ADate:=GetServerDate;
  edtFromDate.Date:=GetMonthFirstDate(ADate);
  edtToDate.Date:=GetMonthEndDate(ADate);
  sbSearch.Click;
end;

procedure TAcr500_01Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
//
end;

procedure TAcr500_01Form.BrowseEvent;
begin
  inherited;
  Acr500_02Form:=TAcr500_02Form.Create(Application);
  Acr500_02Form.OpenData(ADOQuery1.FieldByName('A500A_001').AsString);
  Acr500_02Form.ShowModal;
end;

procedure TAcr500_01Form.DeleteEvent;
var
  ACode:String;
  AQuery:TADOQuery;
  AType:string;
begin
  inherited;
  AQuery:=TADOQuery.Create(nil);
  AQuery.Connection:=SYSDM.ADOC;

  ACode:=ADOQuery1.FieldByName('A500A_001').AsString;
  AQuery.Close;
  AQuery.SQL.Clear;
  AQuery.SQL.Add('select A500B_003 as FCode from ACR500B where A500B_001='+''''+ACode+'''');
  AQuery.open;
  AQuery.First;

  SYSDM.qryQuery.Close;
  SYSDM.qryQuery.SQL.Clear;
  SYSDM.qryQuery.SQL.Add('delete from ACR500B where A500B_001='+''''+ACode+'''');
  SYSDM.qryQuery.ExecSQL;

  if ADOQuery1.FieldByName('A500A_013').AsInteger=0 then
    AType:='ACR510A'
  else
    AType:='ACR510B';

  AQuery.First;
  while not AQuery.Eof do
  begin
    UpdateORD510B(AQuery.fieldByName('FCode').Value,'DEL');
    if AType='ACR500B' then UpdateTAS533(AQuery.fieldByName('FCode').Value,'DEL');
    AQuery.Next;
  end;
  DeleteTableRecord(ADOQuery1,'ACR500A','A500A_001='+''''+ACode+'''');

end;

procedure TAcr500_01Form.InsertEvent;
begin
  inherited;
//新增
  Acr500_02Form:=TAcr500_02Form.Create(Application);
  Acr500_02Form.OpenData('');
  Acr500_02Form.ActInsert.Execute;
  Acr500_02Form.ShowModal;
end;

procedure TAcr500_01Form.ReportGetValue(const ParName: String;
  var ParValue: Variant);
begin
  inherited;

end;

procedure TAcr500_01Form.UpdateEvent;
begin
  inherited;
//修改
  Acr500_02Form:=TAcr500_02Form.Create(Application);
  Acr500_02Form.OpenData(ADOQuery1.FieldByName('A500A_001').AsString);
  Acr500_02Form.ActUpdate.Execute;
  Acr500_02Form.ShowModal;
end;

procedure TAcr500_01Form.sbSearchClick(Sender: TObject);
begin
  inherited;
//查詢
  if (edtFromDate.Text='') or (edtToDate.Text='') then
  begin
    ShowMsg('UMS10000319');  //起止日期不可為空
    if edtFromDate.Text='' then edtFromDate.SetFocus else edtToDate.SetFocus;
    Abort;
  end;
  if edtFromDate.Date>edtToDate.Date then
  begin
    ShowMsg('UMS10000320');  //結束日期不能小于起始日期
    edtToDate.SetFocus;
    Abort;
  end;

  Screen.Cursor:=crHourGlass;
  ADOQuery1.DisableControls;
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select A.*,');
  ADOQuery1.SQL.Add('    B.H150_002,B.H150_003,C.G100_002');
  ADOQuery1.SQL.Add('from ACR500A A,Hrm150 B,GLD100 C');
  ADOQuery1.SQL.Add('where A.A500A_003=B.H150_001 and A.A500A_011=C.G100_001');
  ADOQuery1.SQL.Add('order by A.A500A_001');
  ADOQuery1.Open;
  ADOQuery1.EnableControls;
  ARecordCount:=GetDataSetCount(ADOQuery1);
  Screen.Cursor:=crDefault;
end;

procedure TAcr500_01Form.ADOQuery1A500A_013GetText(Sender: TField;
  var Text: String; DisplayText: Boolean);
begin
  inherited;
  if ADOQuery1.IsEmpty then Exit;
  Text:=ADisType[Sender.AsInteger];

end;

initialization
  RegisterClass(TAcr500_01Form);

finalization
  UnRegisterClass(TAcr500_01Form);

end.