C# - 如何分别从每个单选 GroupBox 返回 int 值?

问题描述

请允许我澄清我的情况和方法.

Please allow me to clarify my situation and approach.

我有一个 10 列的 excel 文件.前五列包含构成查询条件的数据，而后五列包含构成结果的数据.

我正在尝试使用数据库或excel中的这些数据制作软件(如果数据库很困难)前五列将被链接到哪里到列表或菜单或目前五个不同组中的 RadioButtons.当做出选择并按下提交按钮时，结果将显示为来自 excel 中匹配行的五个数据或数据库.

这就是我想要达到的目标.

That is what I am trying to achieve.

如果我的方法有误，请评论.在此先感谢所有帖子.

Please comment if my approach is wrong. Thanks in advance to all the posts.

---------------------------原始问题----------------------------

--------------------------Original Question----------------------------

我在 WPF 上有 5 个分组框(1 个有 5 个单选按钮，2 个有 3 个，3 个和 4 个有 11 个，5 个有 4 个).根据从每个 groupBox 中选择哪个单选按钮，该软件预计会给出四个参数输出(来自 CSV 或数据库)

I have 5 groupboxes(1 has 5 radiobuttons, 2 has 3, 3 and 4 has 11, and 5 has 4 ) on a WPF.Based on which radiobutton is selected from each groupBox, the software is expected to give four parameters output (from a CSV or a database)

我用过 怎么做我从分组框中选中了哪个单选按钮? King King 给出的代码，并修改它以用于我的目的.

I have used How do I get which radio button is checked from a groupbox? the code from this given by King King, and modified it to use for my purpose.

var checkedRadio = new []{groupBox1, groupBox2, groupBox3, groupBox4, groupBox5}.SelectMany(g=>g.Controls.OfType<RadioButton>().Where(r=>r.Checked));
foreach(var c in checkedRadio)
    MessageBox.Show(c.Name);

这给我的是一个又一个被选中作为消息框的单选按钮.

What this gives me is the radiobuttons selected one after another as message box.

我要感谢 King King 以及其他许多人(超过 20 个)，他们对各种答案的回答帮助我达到了这一点.

I want to thank King King, and the many others (more than 20) whose answers for various answers helped me reach this point.

我遇到的问题是如何使用 foreach 循环将值分配给五个单独的 int，然后使用它来计算最终的 int 值，我可以将其分配给我想要显示的各种结果.

Where I am stuck is how to use the foreach loop to assign values to five separate int and then use it to calculate a final int value which I can assign to various results I want to display.

我尝试在每个 CheckedChanged 事件处理程序中为 int 赋值，但它们都是私有的 void 并且不返回任何内容.我试图将它们更改为返回整数，但我似乎无法破解那个坚果.

I tried to assign values to int in each CheckedChanged event handler but all of them are private void and not returning anything. I tried to change them to return ints but I can't seem to crack that nut.

我确信我的整个方法在这里可能是错误的，但我对此没有太多想法.

I am sure my whole approach could be wrong here, but I have not much idea in this.

//我基本上想要的是在g=5组中给出选项，并根据这5组(excel中的列)的选择，显示数据库中匹配行中4个对应列的结果.我目前的上述方法是一种解决方法，因为我不知道使用数据库.//

//What I basically want is to give options in g=five groups, and based on selections from these five groups (columns in an excel), display results from 4 corresponding columns in the matching row in a database. My present approach above is a workaround since I have no knowledge of working with databases.//

推荐答案

我认为你应该省略将值赋值给 五个分隔 ints，但计算结果值.例如，让我们按位对 groupBoxs 进行编码，并计算一个 位掩码

I think you should omit assigning values to five separated ints, but compute the resulting value. For instance, let's encode groupBoxs by bits, and compute a bit mask

  groupBox1 - 00001 (let it be checked)
  groupBox2 - 00010
  groupBox3 - 00100 (let it be checked)
  groupBox4 - 01000 (let it be checked)
  groupBox5 - 10000
  -----------------
  mask        01101 (13)

因此，如果groupBox1、groupBox3 和groupBox4 被检查，最终掩码将为01101

so if groupBox1, groupBox3 and groupBox4 are checked the final mask will be 01101

var result = new [] {groupBox1, groupBox2, groupBox3, groupBox4, groupBox5}
  .Select((box, index) => new {
    box = box,
    mask = 1 << index
  })
  .Where(item => item.box.Controls
    .OfType<RadioButton>()
    .Any(button => button.Checked))
  .Sum(item => item.mask);

如果您必须使用任意权重，请将它们组织成一个集合，例如数组

In case you have to use arbitrary weights organize them into a collection e.g., array

  double[] weights = new double[] {1.2, 3.58, 4.62, -1.7, 0.9};

  double result = new [] {groupBox1, groupBox2, groupBox3, groupBox4, groupBox5}
    .Select((box, index) => new {
       box = box,
       weight = weights[index]
     }
    .Where(item => item.box.Controls
       .OfType<RadioButton>()
       .Any(button => button.Checked))
    .Sum(item => item.weight);

指导原则保持不变:不要使用分隔值:因为您有一个集合用于控件(组框)，请将相应的值放入集合中 还有

The guiding principle remains the same: do not use separated values: since you have a collection for controls (groupboxes), put corresponding values into a collection as well

这篇关于C# - 如何分别从每个单选 GroupBox 返回 int 值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！