/// <summary>
/// 返回销售商品数量
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public static int ProductCount(string where)
{
string sum = B_Lebi_Order_Product.GetValue("sum(Count)", "Order_id in (select id from Lebi_Order where " + where + ")");
if (String.IsNullOrEmpty(sum))
{
sum = 0.ToString();
}
return(Convert.ToInt32(sum));
}
/// <summary>
/// 返回成本
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public static decimal Money_CostCount(string where)
{
List <Lebi_Order_Product> models = B_Lebi_Order_Product.GetList("Order_id in (select id from Lebi_Order where " + where + ") and Price_Cost = 0", "");
if (models.Count > 0)
{
foreach (Lebi_Order_Product m in models)
{
m.Price_Cost = Shop.Bussiness.EX_Product.GetProduct(m.Product_id).Price_Cost;
B_Lebi_Order_Product.Update(m);
}
}
string sum = B_Lebi_Order_Product.GetValue("sum(Price_Cost * Count)", "Order_id in (select id from Lebi_Order where " + where + ")");
if (String.IsNullOrEmpty(sum))
{
sum = 0.ToString();
}
return(Convert.ToDecimal(sum));
}
