All pastes #37633 Raw Edit

Unnamed

public text v1 · immutable
#37633 ·published 2006-01-20 20:03 UTC
rendered paste body
var
 	stDrvName,
	stPrnName,
	stPrnInfo,rp,rf,tx  	String
	i,S,cc              	SmallInt
	r							report

	ReportInfo   			ReportPrintInfo
	prnOptions				printerOptionInfo
   objWinfaxSend  		OLEAuto

	TCUser,TCRec,TCComp,
	sourceTC					Tcursor

	PP,DP,CP,OP,BP,
   WP,SP,EP,SE,
	FP,U,UN,UCN,
	SN,SSN,SW,SV,SF,
	strTb,TCDel,TCDis
   ,TCTer,Tcent			String
	destTb,tb 				Table

	ss,SA1,SA2,SCI1,
   SPR1,SC1,SPC1
   ,SCE,SGF,H ,eU 			string
   
endvar

	self.frame.style = Inside3DFrame

	Action(Datapostrecord)

	rp = ReportName
	s  = quoteno
;********    User Info

U = LoginName ; GetNetUserName()
eU = EnteredBy
UN = anotherarray["zUN"] ;
UCN = anotherarray["zUCN"] ;

If CompNo = PWCompanyNo then

 else
   TCUser.open("sysUser.db")
   scan TCUser for TCUser.SPUser = eU and TCUser.SCompanyNo = CompNo : 
        If NOT TCUser.SUserNo.isblank() then
	        ;	PP  = TCUser.SPrinter
	        ;	CP  = TCUser.SPrinterCopy
	        ;	OP  = TCUser.SPrinterOrder
	        ;	DP  = TCUser.SPrinterDefault
	        ;	WP  = TCUser.SPrinterWorkOrder
	        ;	SP  = TCUser.SPrinterPickingSlip
	        ;	BP  = TCUser.SPrinterBarCode

	        ;	EP  = TCUser.SPrinterEmail
	        ;	FP  = TCUser.SPrinterFax

		     U	 = TCUser.SPUser
		     UN	 = TCUser.SUserNo
		     UCN = TCUser.SCompanyNo
		     SE  = TCUser.SEmail

           TCComp.open("sys.db")
             TCComp.Locate("CompanyNo",UCN)
             SN   = TCComp.Name
             SSN  = TCComp.SubName
		       SW   = TCComp.Website
		       SV   = TCComp.Phone
		       SF   = TCComp.Fax

		       SA1  = TCComp.Address1
		       SA2  = TCComp.Address2
		       SCI1 = TCComp.City
		       SPR1 = TCComp.Province
		       SC1  = TCComp.Country
	          SPC1 = TCComp.PCode
	          SCE  = TCComp.Email
		     TCComp.Close()
        endif
   endscan
   TCUser.Close()

endif


 strtb = ":PRIV:ReportNo.DB"
 tb.attach(strtb)

 if isTable(tb) then

		TCRec.open(":PRIV:ReportNo.DB")
		TCRec.edit()

		TCRec.rCompanyNo = UCN
		TCRec.SUserNo = UN
		TCRec.Quote   = s

		TCRec.EndEdit()
		TCRec.Close()
	 else
		sourceTC.open("ReportNo.DB")
		destTb.attach(":PRIV:ReportNo.DB")

		sourceTC.copy(destTb)

		TCRec.open(":PRIV:ReportNo.DB")
		TCRec.edit()

		TCRec.rCompanyNo = UCN
		TCRec.SUserNo = UN
		TCRec.Quote   = s

		TCRec.EndEdit()
		TCRec.Close()

 endif

 IF  FaxNo <> "" then
		 objWinfaxSend.open("WinFax.SDKSend8.0")
		 objWinfaxSend.LeaveRunning()
		 objWinfaxSend.setPrintFromApp(1)

	    objWinfaxSend.SetNumber (FaxNo)
		 objWinfaxSend.SetTo (Contact)
		 objWinfaxSend.SetCompany (CustomerName)
		 objWinfaxSend.SetPriority(3)
		 objWinfaxSend.AddRecipient()

		 objWinfaxSend.ShowSendScreen(0)
		 objWinfaxSend.Done ( )
		 objWinfaxSend.Send(1)
		 If printerSetCurrent(anotherarray["zFP"]) then
		 	 
		 		if printerSetOptions(prnOptions) then
		 		 	ReportInfo.PanelOptions = PrintClipToWidth
					ReportInfo.Name = rp
					r.print(ReportInfo)
				  else
					errorShow("Could not set printer options.")
				endIf
		  else
			 msgStop("Printer setup", "A printer Named " +" ' "+ FP +" ' "+ "is not installed !")
		 endif
  	  	objWinfaxSend.close()
			return
 	else
		msgStop("No Fax Number", "No Fax Number Found !")
endif