v_discount.sql

来自「用visual c＋＋＆sql开发的企业固定资产管理系统。」· SQL 代码 · 共 12 行

CREATE VIEW dbo.v_DisCount
AS
SELECT Id, AId, AName, OrgPrice, Ratio, UseDate, UsedYear, 
      UsedYear * 12 AS UseMonth, dbo.GetUM(UsedYear, UseDate) AS CcMonth, 
      ROUND((1 - Ratio) / (UsedYear * 12), 3) AS RatioMonth, ROUND((1 - Ratio) 
      / (UsedYear * 12) * OrgPrice, 2) AS DisPerMonth, 
      ROUND(OrgPrice - OrgPrice * (dbo.GetUM(UsedYear, UseDate) * (1 - Ratio)) 
      / (UsedYear * 12), 2) AS LastPrice, ROUND(OrgPrice * (dbo.GetUM(UsedYear, UseDate) * (1 - Ratio)) 
      / (UsedYear * 12), 2) AS DisPrice
FROM dbo.Assets
WHERE (IsAudit = 1) AND (UseDate < GETDATE()) AND (IsDiscount = 1)