根据您之前指出的表和字段名称，以及您只有2个方程式处理的事实，我修改了代码以便您可以简单地传递等式的名称来执行：

Given your Table and Field Names as you previously indicated, and the fact that you only have 2 Equations to deal with, I''ve revised the code so that you can simply pass the Name of the Equation to execute:

唯一的问题是我有37个参数值并且方程式根据股票详细信息而不同。我有50个不同的方程式。您建议我在这做什么？

The only problem with this is that i have 37 parameter values and the equations are different based upon the Stock Details. I have something like 50 different equations. What would you suggest i do here?

以下是参数值：


ParameterID ParameterShortDesc ParameterLongDesc值

1宽度宽度300

2深度深度300

3高度570

4 BBackVoid Base Back Void 22

5 WBackVoid Wall Back Void 22

6 TBackVoid Tall BackVoid 22

7 WShelfSetBack Wall Shelf Back Back 10

8 BShelfSetBack Base Shelf Set Back 10

9 TShelfSetBack高架后背10

10凹槽槽深度9

11 CarcT胎体厚度18

12抽屉抽屉侧面厚度140

13 RailT导轨厚度140

14 BackT背部厚度140

15 PlinthH Plinth高度150

16 FrameSW框架样式宽度36

17 FrameTH框架顶部高度36

18 FrameBH框架底部高度36

19 FrameRH框架导轨高度36

20 DoorSW门型宽度72

21 DoorTH门顶高度72

22 DoorBH门底高度72

23抽屉抽屉侧面高度72

24抽屉抽屉前端高度140

25抽屉抽屉背部高度140

26抽屉面板抽屉面板高度150

27抽屉深度抽屉抽屉深筋膜高度320

28 Tenon Tenon 9

29 Play Play 2

30调整调整1

36 MullionWid竖框宽度90

37 MidRailWid中轨宽度140


这里有一些公式：


SSBOMID StkID SubStkID数量WithGrain AcrossGrain Edged MaterialID

1 135 148 1宽度 - CarcT * 2 Depth-Bbackvoid-CarcT两者1

2 135 170 1高度深度均为1

3 135 171 1高度深度均为1

4 135 149 1宽度 - CarcT * 2 Depth-Bbackvoid-CarcT-BshelfSetBack均为1

5 135 133 1高度 - 车宽 - 车辆均为1

6 137 148 1宽度 - CarcT * 2深度 - Bbackvoid-CarcT均为1

7 137 170 1高度深度均为1

8 137 171 1高度深度均为1

9 137 185 1宽度 - CarcT * 2 RailT均为1

10 137 149 1宽度 - CarcT * 2 Depth-Bbackvoid-CarcT-BShelfSetBack两者1

11 137 185 1宽度 - Carct * 2 RailT两者1

12 137 173 1深度 - Bbackvoid-Carct MidRailWid两者1

13 137 173 1深度 - Bbackvoid-carct MidrailWid两者1

14 139 170 1高度深度两者1

15 139 171 1高度深度均为1

16 139 148 1宽度 - CarcT * 2深度 - Bbackvoid-CarcT均为1

17 139 185 1宽度 - CarcT * 2 RailT两者1

18 139 149 1宽度 - CarcT * 2 Depth-BBackVoid-CarcT两者1

19 136 170 1高度深度两者1

20 136 171 1高度深度均为1

21 136 148 1宽度 - CarcT * 2深度 - Bbackvoid-CarcT均为1

22 136 149 1 Width-CarcT * 2 Depth-Bbackvoid-CarcT-BShelfSetBack Both 1

23 136 185 1 Width-CarcT * 2 RailT Both 1

24 136 133 1宽度CarcT * 2高度-C arcT Both 1

25 136 174 1 Height-CarcT * 2 MullionWid Both 1

26 138 170 1 Height Depth Both 1

27 138 171 1高​​度深度均为1

28 138 148 1宽度 - CarcT-BBackVoid宽度 - CarcT-BBackVoid两者1

29 138 150 1宽度 - CarcT-BBackVoid宽度 - CarcT- BBackVoid两者1

30 138 149 1 Width-CarcT-BBackVoid-BShelfSetBack Width-CarcT-BBackVoid-BShelfSetBack两者1

31 138 133 1宽度 - CarcT-BBackVoid宽度 - CarcT-BBackVoid-CarcT两者1

32 138 133 1宽度 - CarcT-BBackVoid宽度 - CarcT-BBackVoid-CarcT两者1


你觉得我怎么样？需要做什么？

Here are the parameter values:

ParameterID ParameterShortDesc ParameterLongDesc Value
1 Width Width 300
2 Depth Depth 300
3 Height Height 570
4 BBackVoid Base Back Void 22
5 WBackVoid Wall Back Void 22
6 TBackVoid Tall BackVoid 22
7 WShelfSetBack Wall Shelf Set Back 10
8 BShelfSetBack Base Shelf Set Back 10
9 TShelfSetBack Tall Shelf Set Back 10
10 Groove Groove Depth 9
11 CarcT Carcass Thickness 18
12 DrawerST Drawer Side Thickness 140
13 RailT Rail Thickness 140
14 BackT Back Thickness 140
15 PlinthH Plinth Height 150
16 FrameSW Frame Style Width 36
17 FrameTH Frame Top Height 36
18 FrameBH Frame Bottom Height 36
19 FrameRH Frame Rail Height 36
20 DoorSW Door Style Width 72
21 DoorTH Door Top Height 72
22 DoorBH Door Bottom Height 72
23 DrawerSH Drawer Side Height 72
24 DrawerFH Drawer Front Height 140
25 DrawerBH Drawer Back Heigth 140
26 DrawerFasciaH Drawer Fascia Height 150
27 DrawerDeepFasciaH Drawer Deep Fascia Height 320
28 Tenon Tenon 9
29 Play Play 2
30 Adjustment Adjustment 1
36 MullionWid Mullion Width 90
37 MidRailWid Mid Rail Width 140

And here are some of the equations:

SSBOMID StkID SubStkID Qty WithGrain AcrossGrain Edged MaterialID
1 135 148 1 Width-CarcT*2 Depth-Bbackvoid-CarcT Both 1
2 135 170 1 Height Depth Both 1
3 135 171 1 Height Depth Both 1
4 135 149 1 Width-CarcT*2 Depth-Bbackvoid-CarcT-BshelfSetBack Both 1
5 135 133 1 Height-CarcT Width-CarcT Both 1
6 137 148 1 Width-CarcT*2 Depth-Bbackvoid-CarcT Both 1
7 137 170 1 Height Depth Both 1
8 137 171 1 Height Depth Both 1
9 137 185 1 Width-CarcT*2 RailT Both 1
10 137 149 1 Width-CarcT*2 Depth-Bbackvoid-CarcT-BShelfSetBack Both 1
11 137 185 1 Width-Carct*2 RailT Both 1
12 137 173 1 Depth-Bbackvoid-Carct MidRailWid Both 1
13 137 173 1 Depth-Bbackvoid-carct MidrailWid Both 1
14 139 170 1 Height Depth Both 1
15 139 171 1 Height Depth Both 1
16 139 148 1 Width-CarcT*2 Depth-Bbackvoid-CarcT Both 1
17 139 185 1 Width-CarcT*2 RailT Both 1
18 139 149 1 Width-CarcT*2 Depth-BBackVoid-CarcT Both 1
19 136 170 1 Height Depth Both 1
20 136 171 1 Height Depth Both 1
21 136 148 1 Width-CarcT*2 Depth-Bbackvoid-CarcT Both 1
22 136 149 1 Width-CarcT*2 Depth-Bbackvoid-CarcT-BShelfSetBack Both 1
23 136 185 1 Width-CarcT*2 RailT Both 1
24 136 133 1 Width-CarcT*2 Height-CarcT Both 1
25 136 174 1 Height-CarcT*2 MullionWid Both 1
26 138 170 1 Height Depth Both 1
27 138 171 1 Height Depth Both 1
28 138 148 1 Width-CarcT-BBackVoid Width-CarcT-BBackVoid Both 1
29 138 150 1 Width-CarcT-BBackVoid Width-CarcT-BBackVoid Both 1
30 138 149 1 Width-CarcT-BBackVoid-BShelfSetBack Width-CarcT-BBackVoid-BShelfSetBack Both 1
31 138 133 1 Width-CarcT-BBackVoid Width-CarcT-BBackVoid-CarcT Both 1
32 138 133 1 Width-CarcT-BBackVoid Width-CarcT-BBackVoid-CarcT Both 1

What do you think i need to do?