public string getLocalizedPrice(PurchasingType type) { if (m_StoreController != null) { switch (type) { case PurchasingType.S15000: return(m_StoreController.products.all[0].metadata.localizedPriceString); break; case PurchasingType.S80000: return(m_StoreController.products.all[1].metadata.localizedPriceString); break; case PurchasingType.S500000: return(m_StoreController.products.all[2].metadata.localizedPriceString); break; default: return(null); } } else { return(null); } }
/// <summary> /// 根据商品ID,供应商ID,仓库ID获取是否有该商品的采购记录 价格为-1是未定价,0为赠品 /// </summary> /// <param name="goodsID"></param> /// <param name="companyID"></param> /// <param name="warehouseID"></param> /// <param name="ptype"></param> /// <param name="pstate"></param> /// <returns></returns> public IList <PurchasingDetailInfo> GetPurchasingDetail(Guid goodsID, Guid companyID, Guid warehouseID, PurchasingType ptype, PurchasingState pstate) { var parms = new[] { new SqlParameter(PARM_GOODS_ID, SqlDbType.UniqueIdentifier), new SqlParameter(PARM_COMPANY_ID, SqlDbType.UniqueIdentifier), new SqlParameter(PARM_WAREHOUSEID, SqlDbType.UniqueIdentifier), new SqlParameter(PARM_PURCHASING_STATE, SqlDbType.Int), new SqlParameter(PARM_PURCHASING_TYPE, SqlDbType.Int) }; parms[0].Value = goodsID; parms[1].Value = companyID; parms[2].Value = warehouseID; parms[3].Value = (int)pstate; parms[4].Value = (int)ptype; var pList = new List <PurchasingDetailInfo>(); using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_BY_COMPANYID_WAREHOUSEID_GOODSID, parms)) { while (rdr.Read()) { var pinfo = new PurchasingDetailInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr[3] == DBNull.Value ? "" : rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetGuid(6), rdr[7] == DBNull.Value ? -1 : rdr.GetDecimal(7), rdr.GetDouble(8), rdr[9] == DBNull.Value ? 0 : rdr.GetDouble(9), rdr.GetInt32(10), rdr[11] == DBNull.Value ? null : rdr.GetString(11), rdr.GetGuid(12), rdr.IsDBNull(13) ? 0 : rdr.GetInt32(13), rdr.IsDBNull(14) ? 0 : Convert.ToDouble(rdr[14]), rdr.IsDBNull(15) ? 0 : Convert.ToInt32(rdr[15]), rdr.IsDBNull(16) ? 0 : Convert.ToInt32(rdr[16])) { CPrice = rdr[17] == DBNull.Value ? 0 : rdr.GetDecimal(17) }; pList.Add(pinfo); } } return(pList); }