csharp: .NET Object Relationional Mapper (ORM)- SubSonic

来源:转载

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.Xml; using System.Xml.Serialization;using SubSonic; using SubSonic.Utilities;// <auto-generated />namespace Southwind{ public partial class SPs{ /// <summary> /// Creates an object wrapper for the CustOrderHist Procedure /// </summary> public static StoredProcedure CustOrderHist() { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrderHist", DataService.GetInstance("Southwind"), ""); return sp; } /// <summary> /// Creates an object wrapper for the CustOrdersDetail Procedure /// </summary> public static StoredProcedure CustOrdersDetail() { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersDetail", DataService.GetInstance("Southwind"), ""); return sp; } /// <summary> /// Creates an object wrapper for the CustOrdersOrders Procedure /// </summary> public static StoredProcedure CustOrdersOrders() { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersOrders", DataService.GetInstance("Southwind"), ""); return sp; } /// <summary> /// Creates an object wrapper for the Employee Sales By Country Procedure /// </summary> public static StoredProcedure EmployeeSalesByCountry() { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Employee Sales By Country", DataService.GetInstance("Southwind"), ""); return sp; } /// <summary> /// Creates an object wrapper for the Sales by Year Procedure /// </summary> public static StoredProcedure SalesByYear() { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Sales by Year", DataService.GetInstance("Southwind"), ""); return sp; } /// <summary> /// Creates an object wrapper for the Ten Most Expensive Products Procedure /// </summary> public static StoredProcedure TenMostExpensiveProducts() { SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Ten Most Expensive Products", DataService.GetInstance("Southwind"), ""); return sp; } } }

分享给朋友:
您可能感兴趣的文章:
随机阅读: