https://github.com/subsonic/SubSonic-3.0http://subsonic.codeplex.com/https://code.google.com/archive/p/subsonicvn/downloadshttps://subsonicv ...
https://github.com/subsonic/SubSonic-3.0
http://subsonic.codeplex.com/
https://code.google.com/archive/p/subsonicvn/downloads
https://subsonicvn.googlecode.com/
http://www.codeproject.com/Articles/21244/Creating-a-DAL-with-SubSonic
https://www.sencha.com/forum/showthread.php?37577-ExtJS-.NET-SubSonic-AutoScaffolding-Code-Generation
ALTER PROCEDURE [dbo].[SP_GET_BestPrice_Web] -- Add the parameters for the stored procedure here @InventoryGUID char(32), @CustomerGUID char(32), @Quantity int, @SelectBestPrice tinyint, --0= false just get the CCP price for this customer,1 = true get best price. @BasePrice money, @PricingBandGUID char(32)ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. --SET NOCOUNT ON; -- Declare the return variable here DECLARE @SpecialPrice money IF @SelectBestPrice = 1 BEGIN IF @Quantity = 1 SET @Quantity = 0 -- equivalent abd some pricing use 0 to indicate no qty breaks -- Add the T-SQL statements to compute the return value here SELECT @SpecialPrice = SpecialPrice from (Select Top 1 dbo.FN_CalcSpecialPrice(@BasePrice,AdjustmentMode,CASE WHEN AdjustmentMode = 1 THEN Percentage WHEN AdjustmentMode =3 THEN FixedPrice ELSE DollarAmount END)as SpecialPrice FROM Pricing where Pricing.ActiveStatus = 0 and Pricing.InventoryItemGUID = @InventoryGUID and @Quantity>=QuantityBreak and (Pricing.EntityGUID = @CustomerGUID or (Pricing.PricingBandGUID = @PricingBandGUID and Pricing.EntityGUID='00000000000000000000000000000000') or (PricingBandGUID='00000000000000000000000000000000' and EntityGUID='00000000000000000000000000000000')) order by SpecialPrice) as InventoryPrices END ELSE -- only get CCP price, ignore others BEGIN SELECT @SpecialPrice = SpecialPrice from (Select dbo.FN_CalcSpecialPrice(@BasePrice,AdjustmentMode,CASE WHEN AdjustmentMode = 1 THEN Percentage WHEN AdjustmentMode =3 THEN FixedPrice ELSE DollarAmount END) as SpecialPrice FROM Pricing where Pricing.ActiveStatus = 0 and Pricing.EntityGUID = @CustomerGUID and Pricing.InventoryItemGUID = @InventoryGUID) as InventoryPrices END --Return our special price If @SpecialPrice is NULL or @SpecialPrice = 0 SET @SpecialPrice = @BasePrice RETURN @SpecialPriceEND
原标题:csharp: .NET Object Relationional Mapper (ORM)
关键词:.NET
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。