u_p_mxd.pas

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

unit U_P_MXD;

interface

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

type
  TF_P_MXD = class(TForm)
    QuickRep1: TQuickRep;
    QRBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRBand2: TQRBand;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRShape12: TQRShape;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRShape15: TQRShape;
    QRShape16: TQRShape;
    QRShape17: TQRShape;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRShape21: TQRShape;
    QRShape22: TQRShape;
    QRShape23: TQRShape;
    QRShape24: TQRShape;
    QRShape25: TQRShape;
    QRShape26: TQRShape;
    QRShape27: TQRShape;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    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;
    QRShape28: TQRShape;
    QRShape29: TQRShape;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel33: TQRLabel;
    QRLabel34: TQRLabel;
    QRLabel35: TQRLabel;
    QRLabel36: TQRLabel;
    QRLabel37: TQRLabel;
    QRLabel38: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel40: TQRLabel;
    QRLabel41: TQRLabel;
    QRLabel42: TQRLabel;
    QRLabel43: TQRLabel;
    QRLabel44: TQRLabel;
    QRLabel45: TQRLabel;
    QRLabel46: TQRLabel;
    QRLabel47: TQRLabel;
    QRLabel48: TQRLabel;
    QRLabel50: TQRLabel;
    QRShape30: TQRShape;
    QRShape31: TQRShape;
    QRShape32: TQRShape;
    QRShape33: TQRShape;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRLabel53: TQRLabel;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRMemo1: TQRMemo;
    QRMemo2: TQRMemo;
    QRMemo3: TQRMemo;
    QRMemo4: TQRMemo;
    QRMemo5: TQRMemo;
    QRMemo6: TQRMemo;
    QRMemo7: TQRMemo;
    QRDBText14: TQRDBText;
    QRMemo8: TQRMemo;
    QRMemo9: TQRMemo;
    QRDBText9: TQRDBText;
    QRLabel54: TQRLabel;
    QRLabel56: TQRLabel;
    QRLabel57: TQRLabel;
    ADOQueryMXDDY: TADOQuery;
    QRLabel49: TQRLabel;
    QRLabel51: TQRLabel;
    QRLabel52: TQRLabel;
    QRLabel55: TQRLabel;
    procedure QuickRep1BeforePrint(Sender: TCustomQuickRep;
      var PrintReport: Boolean);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure QuickRep1AfterPreview(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_P_MXD: TF_P_MXD;
  Str1,Str2: string;
  iMXD: Integer;
implementation

uses U_DM,U_MXD,U_MXDCX;

{$R *.DFM}

procedure TF_P_MXD.QuickRep1BeforePrint(Sender: TCustomQuickRep;
  var PrintReport: Boolean);
begin
  {iMXD:=iMXD+1;
  if Odd(iMXD) then
    Exit
  else begin
    ShowMessage('2');  
  end;}
end;

procedure TF_P_MXD.FormCreate(Sender: TObject);
begin
  iMXD:=0;
  if mxdshow=true then
  begin
  DM.ADOQueryMXDCX.Close;
  DM.ADOQueryMXDCX.SQL.Clear;
  DM.ADOQueryMXDCX.SQL.Add('select * from xs_mxd where DingDanNo='''+F_mxd.DBEditDingDanNo.text+'''');
  DM.ADOQueryMXDCX.Open;
  IF DM.ADOQueryMXDCX.FieldByName('FenPi').AsString='False' then
    QRLabel52.Caption :='No';
  IF DM.ADOQueryMXDCX.FieldByName('FenPi').AsString='True' then
    QRLabel52.Caption :='Yes';
  //QRDBText9.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('FenPi').AsString;
  if DM.ADOQueryMXDCX.FieldByName('ZhuanYun').AsString='True' then
     QRLabel55.Caption :='Yes';
  if DM.ADOQueryMXDCX.FieldByName('ZhuanYun').AsString='False' then
     QRLabel55.Caption :='No';
  //QRDBText10.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('ZhuanYun').AsString;
  QRDBText11.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('YunFeiYuFu').AsString;
  QRDBText13.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('YunFeiDaoFu').AsString;
  QRDBText12.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('ZhuangYunDate').AsString;
  QRMemo1.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('MarkNos').AsString;
  QRMemo2.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('HuoWuXinXi').AsString;
  QRMemo3.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('JianSBaoZ').AsString;
  QRMemo4.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('ShuLiang').AsString;
  QRMemo5.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('MaoZhong').AsString;
  QRMemo6.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('JingZhong').AsString;
  QRMemo7.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('ZongJia').AsString;
  QRMemo8.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('WaiShiNote').AsString;
  QRMemo9.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('GongSiNote').AsString;
  Str2:=DM.ADOQueryMXDCX.FieldByName('HuoWuXZH').AsString;
  Str1:='√';
  if Str2='贸易' then
    QRLabel53.Caption:=Str1;
  if Str2='补偿' then
    QRLabel54.Caption:=Str1;
  if Str2='退运' then
    QRLabel56.Caption:=Str1;
  if Str2='其它' then
    QRLabel57.Caption:=Str1;
  QRLabel50.Caption:=formatdatetime('yyyy"年"mm"月"dd"日"',f_mxd.DateTimePicker1.datetime);
  end;
  if mxdcxshow=true then
  begin
  QuickRep1.DataSet:=ADOQueryMXDDY;
  ADOQueryMXDDY.Close;
  ADOQueryMXDDY.SQL.Clear;
  ADOQueryMXDDY.SQL.Add('select * from xs_mxd where DingDanNo='''+F_mxdcx.DBEditDingDanNo.text+'''');
  ADOQueryMXDDY.Open;
  IF DM.ADOQueryMXDCX.FieldByName('FenPi').AsString='False' then
    QRLabel52.Caption :='No';// .Lines.Text:='No';
  IF DM.ADOQueryMXDCX.FieldByName('FenPi').AsString='True' then
    QRLabel52.Caption :='Yes';//.Lines.Text:='Yes';
  //QRDBText9.Lines.Text:=DM.ADOQueryMXDCX.FieldByName('FenPi').AsString;
  if DM.ADOQueryMXDCX.FieldByName('ZhuanYun').AsString='True' then
     QRLabel55.Caption :='Yes';//.Lines.Text:='Yes';
  if DM.ADOQueryMXDCX.FieldByName('ZhuanYun').AsString='False' then
     QRLabel55.Caption :='No';
  QRMemo1.Lines.Text:=ADOQueryMXDDY.FieldByName('MarkNos').AsString;
  QRMemo2.Lines.Text:=ADOQueryMXDDY.FieldByName('HuoWuXinXi').AsString;
  QRMemo3.Lines.Text:=ADOQueryMXDDY.FieldByName('JianSBaoZ').AsString;
  QRMemo4.Lines.Text:=ADOQueryMXDDY.FieldByName('ShuLiang').AsString;
  QRMemo5.Lines.Text:=ADOQueryMXDDY.FieldByName('MaoZhong').AsString;
  QRMemo6.Lines.Text:=ADOQueryMXDDY.FieldByName('JingZhong').AsString;
  QRMemo7.Lines.Text:=ADOQueryMXDDY.FieldByName('ZongJia').AsString;
  QRMemo8.Lines.Text:=ADOQueryMXDDY.FieldByName('WaiShiNote').AsString;
  QRMemo9.Lines.Text:=ADOQueryMXDDY.FieldByName('GongSiNote').AsString;
  Str2:=ADOQueryMXDDY.FieldByName('HuoWuXZH').AsString;
  Str1:='√';
  if Str2='贸易' then
    QRLabel53.Caption:=Str1;
  if Str2='补偿' then
    QRLabel54.Caption:=Str1;
  if Str2='退运' then
    QRLabel56.Caption:=Str1;
  if Str2='其它' then
    QRLabel57.Caption:=Str1;
  if f_mxdcx.DBEdit9.text='' then
    exit;
  QRLabel50.Caption:=formatdatetime('yyyy"年"mm"月"dd"日"',strtodate(f_mxdcx.DBEdit9.text));
  end;
end;

procedure TF_P_MXD.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  F_P_MXD:=nil;
  Action:=caFree;
end;

procedure TF_P_MXD.QuickRep1AfterPreview(Sender: TObject);
begin
  Close;
end;

procedure TF_P_MXD.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin
  if mxdshow=true then
    DM.ADOQueryMXDCX.Close;
  if mxdcxshow=true then
    ADOQueryMXDDY.Close;
end;

end.