如何使用asp.net&amp ;;基于数量和价格获得SubTotal C＃ [英] How to get SubTotal based on Quantity and Price Using asp.net & C#

问题描述

public void SalePrice()
    {
        double originalPrice, discountPercentage, discountAmount, salePrice;
        con.Open();
        SqlCommand sqlcom = new SqlCommand("USP_SalePriceCalculation", con);
        sqlcom.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(sqlcom);
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            // Get item's original price.
            originalPrice = double.Parse(dt.Rows[0]["actprice"].ToString());

            // Get discount percentage.
            discountPercentage = double.Parse(dt.Rows[0]["Discount"].ToString());

            // Create decimal representation of %  (move point left two places)
            discountPercentage = discountPercentage / 100;

            // Calculate amount of the discount.
            discountAmount = originalPrice * discountPercentage;

            // Calculate sale price.
            salePrice = originalPrice - discountAmount;

            // Display sale price as Currency ("c")
            lblPrice.Text = salePrice.ToString("c", Cultures.INDIA);
        }
        con.Close();        
    }
    public static class Cultures
    {
        public static readonly CultureInfo INDIA =
            CultureInfo.GetCultureInfo("en-IN");
    }

现在我想根据SalePrice和Quantity（文本框）计算SubTotal

任何人都帮我解释如何计算SubTotal？

Now i want to Calcualate SubTotal Based on that SalePrice and Quantity(textbox)
Any one help me that how to calculate SubTotal?

推荐答案

很简单

It is simple

SalePrice();
var unitPrice =  long.Parse(lblPrice.Text);
var qty = int.Parse(txbQty.Text);

var subTotal = unitPrice * qty;

通过salePrice（）你有适用于所有产品的折扣价。所以小计是所有总数的总和。

By salePrice() you have the discounted price that applies to all products. So subtotal is the sum of all totals.

为什么你不能在SQL Server中实现相同的，尝试以下查询在SQL服务器端实现相同。

Hi,

Why can't you implement the same in SQL Server,try below query to achieve the same in SQL server side.

select sum(col) as SubTotal
from tablename
Group by Quantity, Price

这篇关于如何使用asp.net&amp ;;基于数量和价格获得SubTotal C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！