你的位置:首页 > ASP.net教程

[ASP.net教程]csharp: .NET Object Relationional Mapper (ORM)


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

  

StoredProcedure sp = SPs.SpGetBestPriceWeb(inventoryItemGUID, customerGUID, 1, 1, item.ItmExTaxPrice, "0000000000");sp.Command.AddReturnParameter();sp.Execute();string spResult = sp.Command.Parameters.Find(delegate(QueryParameter qp){  return qp.Mode == ParameterDirection.ReturnValue;}).ParameterValue.ToString();decimal specialPrice = Convert.ToDecimal(spResult);

  

using System; using System.Text; using System.Data;using System.Data.SqlClient;using System.Data.Common;using System.Collections;using System.Collections.Generic;using System.ComponentModel;using System.Configuration; using System.