u_p_bgd.pas

相关的销售服务管理行业的一个软件

unit U_P_BGD;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  QuickRpt, ExtCtrls, Qrctrls, Db, ADODB;

type       
  TF_P_BGD = class(TForm)
    QuickRep1: TQuickRep;
    QRBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRBand2: TQRBand;
    QRLabel3: TQRLabel;
    QRLabel2: TQRLabel;
    QRShape15: TQRShape;
    QRShape37: TQRShape;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRShape21: TQRShape;
    QRShape22: TQRShape;
    QRShape23: TQRShape;
    QRShape24: TQRShape;
    QRShape25: TQRShape;
    QRShape26: TQRShape;
    QRShape27: TQRShape;
    QRShape28: TQRShape;
    QRShape29: TQRShape;
    QRShape30: TQRShape;
    QRShape31: TQRShape;
    QRShape32: TQRShape;
    QRShape33: TQRShape;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRLabel22: TQRLabel;
    QRLabel23: TQRLabel;
    QRLabel24: TQRLabel;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel33: TQRLabel;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRDBText14: TQRDBText;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    QRDBText20: TQRDBText;
    QRDBText21: TQRDBText;
    QRDBText22: TQRDBText;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRDBText25: TQRDBText;
    QRDBText26: TQRDBText;
    QRDBText27: TQRDBText;
    QRDBText28: TQRDBText;
    QRDBText29: TQRDBText;
    QRDBText30: TQRDBText;
    QRDBText31: TQRDBText;
    QRMemo1: TQRMemo;
    QRBand3: TQRBand;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRLabel34: TQRLabel;
    QRLabel35: TQRLabel;
    QRLabel36: TQRLabel;
    QRLabel37: TQRLabel;
    QRLabel38: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel40: TQRLabel;
    QRLabel41: TQRLabel;
    QRLabel42: TQRLabel;
    QRShape11: TQRShape;
    QRShape12: TQRShape;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRShape34: TQRShape;
    QRShape35: TQRShape;
    QRLabel43: TQRLabel;
    QRLabel44: TQRLabel;
    QRLabel45: TQRLabel;
    QRLabel46: TQRLabel;
    QRLabel47: TQRLabel;
    QRLabel48: TQRLabel;
    QRLabel49: TQRLabel;
    QRLabel50: TQRLabel;
    QRLabel52: TQRLabel;
    QRLabel53: TQRLabel;
    QRLabel54: TQRLabel;
    QRLabel55: TQRLabel;
    QRLabel56: TQRLabel;
    QRLabel57: TQRLabel;
    QRLabel58: TQRLabel;
    QRLabel59: TQRLabel;
    QRMemo2: TQRMemo;
    QRDBText32: TQRDBText;
    QRDBText33: TQRDBText;
    QRDBText34: TQRDBText;
    QRDBText35: TQRDBText;
    QRDBText36: TQRDBText;
    QRLabel51: TQRLabel;
    QRDBText37: TQRDBText;
    QRDBText38: TQRDBText;
    QRDBText39: TQRDBText;
    QRShape10: TQRShape;
    QRShape40: TQRShape;
    QRShape41: TQRShape;
    QRShape42: TQRShape;
    QRDBText40: TQRDBText;
    QRDBText41: TQRDBText;
    QRDBText42: TQRDBText;
    QRDBText43: TQRDBText;
    QRDBText44: TQRDBText;
    QRDBText45: TQRDBText;
    QRDBText46: TQRDBText;
    QRDBText47: TQRDBText;
    ADOQueryBGDBB: TADOQuery;
    ADOQueryBGDBB1: TADOQuery;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure QuickRep1AfterPreview(Sender: TObject);
    procedure QuickRep1BeforePrint(Sender: TCustomQuickRep;
      var PrintReport: Boolean);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_P_BGD: TF_P_BGD;
  iBGD: Integer;
implementation



uses U_DM, U_BGD, U_BGDCX;

{$R *.DFM}

procedure TF_P_BGD.FormCreate(Sender: TObject);
begin
  iBGD:=0;
  if BGDCXshow=true then
  begin
  QuickRep1.DataSet:=ADOQueryBGDBB;
  ADOQueryBGDBB1.Close;
  ADOQueryBGDBB1.Sql.Clear;
  ADOQueryBGDBB1.sql.Add('select * from xs_bgd where DingDanNo='''+F_BGDCX.DBEditDingDanNo.Text+'''');
  ADOQueryBGDBB1.Open;
  ADOQueryBGDBB.Close;
  ADOQueryBGDBB.sql.Clear;
  ADOQueryBGDBB.sql.Add('select * from XS_BGDchild  where XS_BGDchild.DingDanNo='''+F_BGDCX.DBEditDingDanNo.Text+''' order by xianghao');
  ADOQueryBGDBB.Open;
  QRDBText1.Lines.Text:=ADOQueryBGDBB1.fieldbyname('YuLuRuNo').asstring;
  QRDBText2.Lines.Text:=ADOQueryBGDBB1.fieldbyname('HaiGuanNo').asstring;
  QRDBText3.Lines.Text:=ADOQueryBGDBB1.fieldbyname('ChuKouPort').asstring;
  QRDBText4.Lines.Text:=ADOQueryBGDBB1.fieldbyname('JingYingUint').asstring;
  QRDBText5.Lines.Text:=ADOQueryBGDBB1.fieldbyname('FaHuoUnit').asstring;
  QRDBText6.Lines.Text:=ADOQueryBGDBB1.fieldbyname('BeiAnNo').asstring;
  QRDBText7.Lines.Text:=ADOQueryBGDBB1.fieldbyname('ChuKouDate').asstring;
  QRDBText8.Lines.Text:=ADOQueryBGDBB1.fieldbyname('ShenBaoDate').asstring;
  QRDBText9.Lines.Text:=ADOQueryBGDBB1.fieldbyname('YunShuBy').asstring;
  QRDBText10.Lines.Text:=ADOQueryBGDBB1.fieldbyname('YunShuVehicle').asstring;
  QRDBText11.Lines.Text:=ADOQueryBGDBB1.fieldbyname('TiYunDanNo').asstring;
  QRDBText12.Lines.Text:=ADOQueryBGDBB1.fieldbyname('MaoYiBy').asstring;
  QRDBText13.Lines.Text:=ADOQueryBGDBB1.fieldbyname('ZhengTax').asstring;
  QRDBText14.Lines.Text:=ADOQueryBGDBB1.fieldbyname('JieHuiBy').asstring;
  QRDBText15.Lines.Text:=ADOQueryBGDBB1.fieldbyname('XuKeZhengNo').asstring;
  QRDBText16.Lines.Text:=ADOQueryBGDBB1.fieldbyname('PiZhunNo').asstring;
  QRDBText17.Lines.Text:=ADOQueryBGDBB1.fieldbyname('HeTongNo').asstring;
  QRDBText18.Lines.Text:=ADOQueryBGDBB1.fieldbyname('JiZhXNo').asstring;