/// <summary> /// 收货确认后,更新订单产品的收货数量 /// </summary> /// <param name="torder"></param> public static void UpdateShouHuoCount(Lebi_Transport_Order torder) { if (torder.Type_id_TransportOrderStatus != 223) { return; } Lebi_Order order = B_Lebi_Order.GetModel(torder.Order_id); if (order == null) { return; } List <Lebi_Order_Product> ops = B_Lebi_Order_Product.GetList("Order_id=" + torder.Order_id + "", ""); List <Lebi_Transport_Order> torders = B_Lebi_Transport_Order.GetList("Order_id=" + torder.Order_id + " and Type_id_TransportOrderStatus=223", ""); //bool shouhuoall = true; foreach (Lebi_Order_Product op in ops) { //op.Count_Received = 0; foreach (Lebi_Transport_Order to in torders) { foreach (TransportProduct p in GetTransportProduct(to)) { if (p.Product_id == op.Product_id) { op.Count_Received = op.Count_Received + p.Count; if (op.Count_Shipped < op.Count_Received) { op.Count_Received = op.Count_Shipped; } break; } } } //if (op.Count_Received < op.Count_Shipped) // shouhuoall = false; B_Lebi_Order_Product.Update(op);//更新收货数量 } order.IsReceived = 1; order.IsReceived_All = 1; ops = B_Lebi_Order_Product.GetList("Order_id=" + torder.Order_id + "", ""); foreach (Lebi_Order_Product op in ops) { if (op.Count_Received < op.Count_Shipped) { order.IsReceived_All = 0; } } order.Time_Received = System.DateTime.Now; B_Lebi_Order.Update(order); if (order.IsReceived_All == 1)//全部收货完成 { Order.Received(order); } }
/// <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)); }