C# localization globalization architecture

全球化架构

发布于 2024-07-05 18:21:39 字数 588 浏览 7 评论 0原文

我需要在数据库中存储电子商务解决方案的产品。每个产品都应该有描述性信息，例如名称、描述等。

我需要将任何产品本地化为 x 种语言。

到目前为止，我所做的就是创建任何应该本地化的列和 nvarchar(MAX)，然后我存储这样的 XML 字符串：

<cultures>
    <culture code="en-us">Super fast laptop</culture>
    <culture code="da-dk">Super hurtig bærbar</culture>
</cultures>

当我从数据库加载它时，将其加载到我的业务逻辑对象时，我将 XML 字符串解析为 Dictionary，其中键是文化/语言代码。

因此，当我想显示产品名称时，我会这样做：

lblName.Text = product.Name["en-us"];

有人有更好的解决方案吗？

原文

I need to store products for an e-commerce solution in a database. Each product should have descriptive information, such as name, description etc.

I need any product to be localized to x number of languages.

What I've done so far, is to make any column that should be localized and nvarchar(MAX) and then i store an XML string like this:

<cultures>
    <culture code="en-us">Super fast laptop</culture>
    <culture code="da-dk">Super hurtig bærbar</culture>
</cultures>

And when I load it from the database, into my business logic objects, I parse the XML string to a Dictionary<string, string> where the key is the culture/language code.

So when I want to display the name of a product, I do this:

lblName.Text = product.Name["en-us"];

Does anyone have a better solution?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

美羊羊 2024-07-12 18:21:39

您应该将当前语言存储在某个地方（例如，在 singleton 中）并且在product.Name 属性中使用语言设置来获取正确的字符串。这样，您只需为每个字段编写一次特定于语言的代码，而不必考虑使用该字段的每个地方的语言。

例如，假设您的单例是在 Localizer 类中定义的，该类存储与当前语言对应的枚举：

public class Product
{
  private idType id;
  public string Name
  {
    get
    {
      return Localizer.Instance.GetLocalString(id, "Name");
    }
  }
}

其中 GetLocalString 看起来像：

  public string GetLocalString(idType objectId, string fieldName)
  {
    switch (_currentLanguage)
    {
      case Language.English:
        // db access code to retrieve your string, may need to include the table
        // the object is in (e.g. "Products" "Orders" etc.)
        db.GetValue(objectId, fieldName, "en-us");
        break;
    }
  }

You should store the current language somewhere (in a singleton, for instance) and in the product.Name property use the language setting to get the correct string. This way you only have to write the language specific code once for each field rather than thinking about languages everywhere the field is used.

For example, assuming your singleton is defined in the Localizer class that stores an enum corresponding to the current language:

public class Product
{
  private idType id;
  public string Name
  {
    get
    {
      return Localizer.Instance.GetLocalString(id, "Name");
    }
  }
}

Where GetLocalString looks something like:

  public string GetLocalString(idType objectId, string fieldName)
  {
    switch (_currentLanguage)
    {
      case Language.English:
        // db access code to retrieve your string, may need to include the table
        // the object is in (e.g. "Products" "Orders" etc.)
        db.GetValue(objectId, fieldName, "en-us");
        break;
    }
  }

回复收藏 0 原文