/// <summary> /// 得到某个出库单下所有货品的总价 /// </summary> /// <param name="intContractId">出库单id</param> /// <returns>某个出库单下所有货品的总价</returns> public static decimal getPriceTotal(int intContractId) { string strSQL = @" SELECT id_goods, amount FROM checkout_record WHERE id_contract = @id_contract"; MySqlParameter[] aryParams = new MySqlParameter[1]; aryParams[0] = new MySqlParameter("@id_contract", intContractId); DataTable objDT = HelperMySql.GetDataTable(strSQL, aryParams); if (objDT == null || objDT.Rows.Count <= 0) { return(0); } int intGoodsId = 0; decimal dcmAmount = 0; decimal dcmPriceUnit = 0; decimal dcmPriceTotal = 0; ModelSalesGoods modelSalesGoods; for (int i = 0; i < objDT.Rows.Count; i++) { intGoodsId = Convert.ToInt32(objDT.Rows[i]["id_goods"]); dcmAmount = Convert.ToDecimal(objDT.Rows[i]["amount"]); modelSalesGoods = DalSalesGoods.getById(intGoodsId); dcmPriceUnit = modelSalesGoods != null ? modelSalesGoods.price_unit : 0; dcmPriceTotal += dcmPriceUnit * dcmAmount; } return(dcmPriceTotal); }
/// <summary> /// 将某盘点单中所有货品的库存量全部清0 /// </summary> /// <param name="intContractId">盘点单id</param> public static void clearZero(int intContractId) { int intGoodsId; // 找出所有在此盘点单中的货品 string strSQL = @" SELECT goods.id, goods.amount_stock FROM sales_goods goods LEFT JOIN inventory_record inventory ON inventory.id_goods = goods.id WHERE inventory.id_contract = @id_contract "; MySqlParameter[] aryParams = new MySqlParameter[1]; aryParams[0] = new MySqlParameter("@id_contract", intContractId); DataTable objDT = HelperMySql.GetDataTable(strSQL, aryParams); if (objDT == null || objDT.Rows.Count <= 0) { return; } for (int i = 0; i < objDT.Rows.Count; i++) { intGoodsId = Convert.ToInt32(objDT.Rows[i]["id"]); // 执行清零操作 DalSalesGoods.clearAmountStock(intGoodsId); } }