图形变换基础:光栅比例变换与矢量运算

需积分: 1 0 下载量 133 浏览量 更新于2024-08-22 收藏 3.86MB PPT 举报
"本资源主要讲述了光栅比例变换在图形变换中的应用,包括数学基础,如矢量、矩阵及其运算,以及二维和三维图形变换的原理。" 在计算机图形学中,光栅比例变换是将几何图形从一个坐标系统转换到另一个坐标系统的关键技术,特别是在二维和三维图形处理中。这个过程涉及到矢量和矩阵的数学概念。 首先,矢量是表示有大小和方向的量,通常由箭头表示,箭头的长度代表大小,箭头的方向代表方向。矢量可以进行加法运算,当两个矢量相加时,结果矢量的起点位于原两矢量起点的同一位置,终点是两矢量终点的连线。此外,矢量还可以与标量(一个只有大小没有方向的数)相乘,称为数乘,这会改变矢量的大小而不改变其方向。 点积是两个矢量的一种运算,它返回的是一个标量值,表示两个矢量在某一方向上的投影乘积。点积的性质包括:两个矢量的点积等于它们的长度乘以它们之间的夹角的余弦值。同时,点积可以用来计算矢量的长度和两个矢量之间的角度。 矢量的叉积是产生第三个矢量的运算,这个新矢量与原始两个矢量垂直,并且根据右手定则确定方向。叉积的模长等于两个矢量的长度乘以它们夹角的正弦值。叉乘在计算平面内的法向量和判断方向等方面非常有用。 接下来,矩阵是二维数组,由行和列的元素组成,通常用于表示线性变换。矩阵的加法是对应元素相加,而数乘则是将每个元素乘以一个标量。矩阵运算还包括矩阵乘法,它在图形变换中扮演着核心角色,例如旋转、缩放和位移等变换都可以用矩阵来描述。 在二维图形变换中,我们可以使用2x2或3x3的矩阵来表示平移、旋转和缩放等操作。而在三维图形变换中,通常使用4x4的矩阵,除了上述的基本变换外,还可以处理透视效果。通过矩阵的乘法,可以组合多个简单的变换,形成复杂的几何变换序列。 光栅比例变换是利用矢量和矩阵的数学工具来实现图形在不同坐标系统间的精确映射,这是计算机图形学中的基本操作,广泛应用于游戏开发、虚拟现实、图像处理等领域。理解这些基础知识对于深入学习图形学至关重要。

SELECT t1.id, t1.[kh] AS '客户', t1.[lrsj] AS '录入时间', t1.[htbh] AS '合同编号', t1.[rq] AS '签订日期', t1.[htqsrq] AS '起始日期', t1.[htjzrq] AS '截止日期', t1.[zjey] AS '总金额', t1.[hjzld] AS '总吨数', t1.[lrsj] AS '创建时间', t1.[chpt] AS '撮合平台', CAST ( t1.[htwj] AS VARCHAR ( MAX ) ) AS '合同文件', STUFF( ( SELECT ',' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.ppcs, ',', '' ) ) = 1 THEN CAST ( REPLACE( t2.ppcs, ',', '' ) AS FLOAT ) END ) FROM uf_xsht_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '品牌', STUFF( ( SELECT ' ' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.hsdjyd, ' ', '' ) ) = 1 THEN CAST ( REPLACE( t2.hsdjyd, ' ', '' ) AS FLOAT ) END ) FROM uf_xsht_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '销售单价', (SELECT SUM ( sjfk ) from uf_xshksj2 WHERE cght=t1.id ) AS '实际已收', (SELECT SUM ( hkje ) from uf_xshksj2 WHERE cght=t1.id ) AS '已收货款', ( SELECT SUM( sjfk ) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id ) AS '订金' FROM uf_xsht t1 INNER JOIN uf_xsht_dt1 t2 ON t1.id = t2.mainid LEFT JOIN uf_xshksj2 t3 ON t1.id = t3.cght GROUP BY t1.id, t1.[kh], t1.[lrsj], t1.[htbh], t1.[rq], t1.[htqsrq], t1.[htjzrq], t1.[zjey], t1.[hjzld], t1.[chpt], CAST ( t1.[htwj] AS VARCHAR ( MAX ) );中按ID查询计算收款比例‘已收比例’,当订金与已收货款的和小于总金额时,比例公式为已收货款除以总金额;否则为订金与已收货款求和再除以总金额

2023-07-13 上传

SELECT t1.id, t1.[kh] AS '客户', t1.[lrsj] AS '录入时间', t1.[htbh] AS '合同编号', t1.[rq] AS '签订日期', t1.[htqsrq] AS '起始日期', t1.[htjzrq] AS '截止日期', t1.[zjey] AS '总金额', t1.[hjzld] AS '总吨数', t1.[lrsj] AS '创建时间', t1.[chpt] AS '撮合平台', CAST ( t1.[htwj] AS VARCHAR ( MAX ) ) AS '合同文件', STUFF( ( SELECT ',' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.ppcs, ',', '' ) ) = 1 THEN CAST ( REPLACE( t2.ppcs, ',', '' ) AS FLOAT ) END ) FROM uf_xsht_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '品牌', STUFF( ( SELECT ' ' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.hsdjyd, ' ', '' ) ) = 1 THEN CAST ( REPLACE( t2.hsdjyd, ' ', '' ) AS FLOAT ) END ) FROM uf_xsht_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '销售单价', (SELECT SUM(sjfk) FROM uf_xshksj2 WHERE cght = t1.id) AS '实际已收', (SELECT SUM(hkje) FROM uf_xshksj2 WHERE cght = t1.id) AS '已收货款', (SELECT SUM(sjfk) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id) AS '订金', CASE WHEN ((SELECT SUM(ISNULL(hkje, 0)) FROM uf_xshksj2 WHERE cght = t1.id) + (SELECT SUM(ISNULL(sjfk, 0)) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id)) < t1.[zjey] THEN (SELECT SUM(ISNULL(hkje, 0)) FROM uf_xshksj2 WHERE cght = t1.id) / t1.[zjey] ELSE ((SELECT SUM(ISNULL(hkje, 0)) FROM uf_xshksj2 WHERE cght = t1.id) + (SELECT SUM(ISNULL(sjfk, 0)) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id)) / t1.[zjey] END AS '已收比例' FROM uf_xsht t1 INNER JOIN uf_xsht_dt1 t2 ON t1.id = t2.mainid LEFT JOIN uf_xshksj2 t3 ON t1.id = t3.cght GROUP BY t1.id, t1.[kh], t1.[lrsj], t1.[htbh], t1.[rq], t1.[htqsrq], t1.[htjzrq], t1.[zjey], t1.[hjzld], t1.[chpt], CAST ( t1.[htwj] AS VARCHAR ( MAX ) );为什么只有第一个有数据

2023-07-14 上传

SELECT t1.id, t1.[kh] AS '客户', t1.[lrsj] AS '录入时间', t1.[htbh] AS '合同编号', t1.[rq] AS '签订日期', t1.[htqsrq] AS '起始日期', t1.[htjzrq] AS '截止日期', t1.[zjey] AS '总金额', t1.[hjzld] AS '总吨数', t1.[lrsj] AS '创建时间', t1.[chpt] AS '撮合平台', CAST ( t1.[htwj] AS VARCHAR ( MAX ) ) AS '合同文件', STUFF( ( SELECT ',' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.ppcs, ',', '' ) ) = 1 THEN CAST ( REPLACE( t2.ppcs, ',', '' ) AS FLOAT ) END ) FROM uf_xsht_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '品牌', STUFF( ( SELECT ' ' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.hsdjyd, ' ', '' ) ) = 1 THEN CAST ( REPLACE( t2.hsdjyd, ' ', '' ) AS FLOAT ) END ) FROM uf_xsht_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '销售单价', (SELECT SUM ( sjfk ) from uf_xshksj2 WHERE cght=t1.id ) AS '实际已收', (SELECT SUM ( hkje ) from uf_xshksj2 WHERE cght=t1.id ) AS '已收货款', ( SELECT SUM( sjfk ) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id ) AS '订金', CASE WHEN ((SELECT SUM (ISNULL( hkje,0) ) from uf_xshksj2 WHERE cght=t1.id ) + (SELECT SUM(ISNULL(sjfk, 0)) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id)) < t1.[zjey] THEN ((SELECT SUM ( ISNULL( hkje,0)) from uf_xshksj2 WHERE cght=t1.id ) / t1.[zjey]) ELSE ((SELECT SUM ( ISNULL( hkje,0) ) from uf_xshksj2 WHERE cght=t1.id ) + (SELECT SUM(ISNULL(sjfk, 0)) FROM uf_xshksj2 WHERE kxlx = 0 AND cght = t1.id)) / t1.[zjey] END AS '已收比例' FROM uf_xsht t1 INNER JOIN uf_xsht_dt1 t2 ON t1.id = t2.mainid LEFT JOIN uf_xshksj2 t3 ON t1.id = t3.cght GROUP BY t1.id, t1.[kh], t1.[lrsj], t1.[htbh], t1.[rq], t1.[htqsrq], t1.[htjzrq], t1.[zjey], t1.[hjzld], t1.[chpt], CAST ( t1.[htwj] AS VARCHAR ( MAX ) )中为什么已付比例除了第一个有值 ,其他却显示空值

2023-07-13 上传

SELECT t1.id, t1.[gf] AS '供方', t1.[htmc] AS '合同名称', t1.[htbh] AS '合同编号', t1.[sjbh] AS '编号', t1.[qdrq] AS '签订日期', t1.[qsrq] AS '起始日期', t1.[jzrq] AS '截止日期', t1.[zje] AS '总金额', t1.[zds] AS '总吨数', t1.[lrsj] AS '创建时间', CONCAT ( MONTH ( t1.[rksj] ), '月' ) AS '入库时间', t1.[chpt] AS '撮合平台', t1.[qsfs] AS '签署方式', t1.[gfjc] AS '供方简称', t1.[cclx] AS '持仓类型', CAST ( t1.[htwj] AS VARCHAR ( MAX ) ) AS '合同文件', STUFF( ( SELECT ',' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.pp, ',', '' ) ) = 1 THEN CAST ( REPLACE( t2.pp, ',', '' ) AS FLOAT ) END ) FROM uf_cght2_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '品牌', STUFF( ( SELECT ',' + CONVERT ( VARCHAR, CASE WHEN ISNUMERIC( REPLACE( t2.hsdj, ',', '' ) ) = 1 THEN CAST ( REPLACE( t2.hsdj, ',', '' ) AS FLOAT ) END ) FROM uf_cght2_dt1 t2 WHERE t1.id = t2.mainid FOR XML PATH ( '' ) ), 1, 1, '' ) AS '采购单价', SUM ( t3.[sjfk] ) AS '实际已付', SUM ( t3.[hkje] ) AS '已付货款', ( SELECT SUM ( sjfk ) FROM uf_cgfksjb WHERE kxlx = 0 AND cght = t1.id ) AS '订金', CASE WHEN (SELECT SUM(sjfk) FROM uf_cgfksjb WHERE kxlx = 0 AND cght = t1.id) + SUM(t3.[hkje]) < t1.[zje] THEN ROUND(SUM(t3.[hkje]) / t1.[zje], 3) ELSE ROUND(((SELECT SUM(sjfk) FROM uf_cgfksjb WHERE kxlx = 0 AND cght = t1.id) + SUM(t3.[hkje])) / t1.[zje],3) END AS '已付比例' FROM uf_cght2 t1 INNER JOIN uf_cght2_dt1 t2 ON t1.id = t2.mainid LEFT JOIN uf_cgfksjb t3 ON t1.id = t3.cght GROUP BY t1.id, t1.[gf], t1.[htmc], t1.[htbh], t1.[sjbh], t1.[qdrq], t1.[qsrq], t1.[jzrq], t1.[zje], t1.[zds], CONCAT ( MONTH ( t1.[rksj] ), '月' ), t1.[chpt], t1.[lrsj], t1.[qsfs], t1.[gfjc], t1.[cclx], CAST ( t1.[htwj] AS VARCHAR ( MAX ) );怎么按签定日期倒序排序

2023-07-13 上传