dbo.NewTSGUID()---全局唯一ID（销售合同的表头数据插到物品调价单_客户单）

--将 dbo.NewTSGUID() 函数的结果赋值给变量 @Djguid
Set @Djguid=dbo.NewTSGUID()

生成一个新的全局唯一ID，并将其保存到名为 @Djguid 的变量中，以便后续在查询或业务处理中使用

在做存储过程中把销售合同里的物品和报价价格审核时插入到客户报价定价单中（做插入时，目标表中的必填字段一定要插入字段，不可空）

alter  Procedure [dbo].[Sp_Sp_XSGL_XSHT_KHJGQD] @Djlsh Int As
Begin
	--物品调价单_客户
	Declare @Djguid NVarchar(64),@Djlsh_Des Int,@DDH NVarchar(20),@Year Int,@Month Int,@Day Int
	Create Table #t_djh(DJH Varchar(20))
	Insert Into #t_djh Exec Sp_getdjh 'WPTJD_KH','',@Year,@Month,@Day,1
	Select @DDH=DJH
	From #t_djh
	Drop Table #t_djh

	Set @Djguid=dbo.NewTSGUID()--使用系统函数生成全局唯一ID号:GUID
    --把当前销售合同的表头数据插如到物品调价单_客户单表头，并且单据流水号也插进表头
	Insert Into WPTJD_KHH(DjGuid,HTH,GSDM,GSMC,TJDH,TJRQ,KHBM,KHMC,    JGDJ,SXRQ1,   SXRQ2,JGLX,ZDR,ZDRID,ZDSJ)
				Select   @Djguid,HTH,GSDM,GSMC,@DDH,GETDATE(),KHBM,KHMC,'无',GETDATE(),GETDATE()+149,'含税价',ZDR,ZDRID,ZDSJ
	From XSHTH 
	Where DJLSH=@DJLSH  --后台使用存储过程时，会获取当前流水号，

	--把销售合同的表体数据插如到物品调价单_客户单插表体
Select @Djlsh_Des=Djlsh   --从表头获取DJLSH，赋值到@Djlsh_Des，方便表体插入相同单据流水号
	From  WPTJD_KHH
	Where WPTJD_KHH.DjGuid=@Djguid

	Insert Into WPTJD_KHB(DjLsh,DjGuid,DjBth,    HH,WPBH,WPBM,WPHH,WPMC,HHPM,BZFS,CM,SCBH,SCBM,   SCMC,SCHHPM,   YJGYXQZ,   XSDJ_OLD,     XSDJ_NEW,TDJ,TYJ,ZFLDM,ZFL,JLDW)
				Select  @Djlsh_Des,@Djguid,DjBth,hh,CPBH,WPBM,WPBM,WPMC,HHPM,BZFS,GG,BCPBH,BCPBM,BCPMC,BCPHHPM,
				isnull((select top 1
				SXRQ2 from KHJGQDH k where xshtb.WPBM=k.WPBM and XSHTB.WPMC=k.WPMC  order by SXRQ1 desc),'')rq,
				isnull((select top 1 XSDJ from KHJGQDH k where xshtb.WPBM=k.WPBM and XSHTB.WPMC=k.WPMC  order by SXRQ1 desc),'0')olDjg ,    JG,JG,0,'',	'',	''				   
    From XSHTB 
	Where DJLSH=@DJLSH
	END