/// <summary> /// 将金额从转后为string,即将金额加小数点 /// </summary> /// <param name="money">要转换的金额</param> /// <returns>转换后的金额</returns> public static string MoneyIntToString(string money, int decimalNum, string pointNum, string moneySymbol, BusinessEnum.ControlSwitch isShowMoneySymbol, bool isSet) { string strPointNum = decimalNum.ToString();//"100";d string strMoney = money; int length = strMoney.Length; int intPointLen = strPointNum.Length; if (length < intPointLen) { strMoney = strMoney.PadLeft(intPointLen, '0'); } switch (pointNum) { case "0": // 不显示货币小数点 strMoney = money.Substring(0, strMoney.Length - intPointLen + 1); break; case "1": // 显示货币小数点 strMoney = strMoney.Insert(strMoney.Length - intPointLen + 1, "."); break; } if ((isShowMoneySymbol == BusinessEnum.ControlSwitch.Run) && (isSet)) { strMoney = moneySymbol + strMoney; } return(strMoney); }
/// <summary> /// 检测某商品库存是否还有 /// </summary> /// <param name="mcdCode">商品编号</param> /// <returns>结果 False:库存不足 True:库存足</returns> public bool CheckGoodsStock(string mcdCode, int sellPrice, BusinessEnum.ControlSwitch isRunStock) { int intStockNum = 0; bool result = false; string strPaId = string.Empty; // 检测是否启用库存 if (isRunStock == BusinessEnum.ControlSwitch.Stop) { // 不启用库存 return(true); } DbOper dbOper = new DbOper(); dbOper.DbFileName = _m_DbFileName; try { string strSql = @"select sum(SurNum) as SurNum from t_vm_painfo where mcdcode = '" + mcdCode + "' and sellprice = " + sellPrice; DataSet dataSet = dbOper.dataSet(strSql); if (dataSet.Tables.Count > 0) { if (dataSet.Tables[0].Rows.Count > 0) { string strStockNum = dataSet.Tables[0].Rows[0]["SurNum"].ToString(); if (!string.IsNullOrEmpty(strStockNum)) { intStockNum = Convert.ToInt32(strStockNum); if (intStockNum > 0) { // 库存够 result = true; } } } } // 如果数据库中的库存够,则检查内存中的该商品库存是否够 if (result) { for (int i = 0; i < GoodsList_Show.Count; i++) { if ((GoodsList_Show[i].McdCode == mcdCode) && (GoodsList_Show[i].Price == sellPrice)) { if (GoodsList_Show[i].SurNum < 1) { result = false; } break; } } } } catch { result = false; } return(result); }