换算比例

yusijie

2022-11-25 af74d787372fe679d9301cad7178b3ad6acb31cb

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
 
namespace BaseSet
{
    public partial class Gy_DataIn_HaiYan :BLL.Gy_DataInTmp
    {
        public Gy_DataIn_HaiYan()
        {
            InitializeComponent();
        }
 
        public int kname = 0;
        public int pname = 1;
        public int ptuhao = 2;
        public int jixing = 3;
        public int pcolour = 4;
        public int qita = 5;
        //
        public int strg1 = 6;
        public int strg2 = 7;
        public int strg3 = 8;
        public int strg4 = 9;
        public int strg5 = 10;
        public int strg6 = 11;
        public int strg7 = 12;
        public int strg8 = 13;
        public int strg9 = 14;
        public int strg10 = 15;
        public int strg11 = 16;
        public int strg12 = 17;
        public int strg13 = 18;
        public int strg14 = 19;
        //
        public int strm1 = 31;
        public int strm2 = 32;
        public int strm3 = 33;
        public int strm4 = 34;
        public int strm5 = 35;
        public int strm6 = 36;
        public int strm7 = 37;
        public int strm8 = 38;
        public int strm9 = 39;
        public int strm10 = 40;
        public int strm11 = 41;
        public int strm12 = 42;
        public int strm13 = 43;
        public int strm14 = 44;
        public int strm15 = 45;
        public int strm16 = 46;
        //
        public const int HBeginRow = 2;         //ÓÐЧÊý¾Ý£¬¿ªÊ¼ÐÐÊý
        //
        public DAL.ClsProduct_Add oBill = new DAL.ClsProduct_Add();
 
        /// <summary>
        ///  ³õʼ»¯½çÃæ
        /// </summary>
        public override void initData()
        {
            base.initData();
            base.sSheetName = "Sheet2"; 
            base.ModRightName = "Gy_DataIn_HotWater";
            base.ModRightNameCheck = base.ModRightName + base.ModRightNameCheck;
            base.ModRightNameClose = base.ModRightName + base.ModRightNameClose;
            base.ModRightNameDelete = base.ModRightName + base.ModRightNameDelete;
            base.ModRightNameEdit = base.ModRightName + base.ModRightNameEdit;
            base.ModRightNameMoney = base.ModRightName + base.ModRightNameMoney;
            base.ModRightNameQty = base.ModRightName + base.ModRightNameQty;
            //
            DBUtility.Gy_BaseFun.SetComboxYear(cmbHYear);
            DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod);
            //
        }
 
        public override void Sub_DataIn()
        {
            //base.Sub_DataIn();
            //
            for (int i = HBeginRow; i <= grdMain.Rows.Count - 1; i++)
            {
                if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[kname].Value) != "")
                {
                    //дÈëÀà
                    if (WriteClass(i))
                    {
                        //±£´æ¼Ç¼
                        if (!oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo))
                        {
                            MessageBox.Show("µ¼Èëʧ°Ü!Ô­Òò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
                            return;
                        }
                    }
                }
            }
            MessageBox.Show("µ¼ÈëÍê±Ï");
            grdMain.DataSource = null;
        }
 
        //дÈëÀ࠴ӿؼþ
        private bool WriteClass(int row)
        {
            //дÈëÐÅÏ¢
            oBill.omodel1.kname = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[kname].Value);
            oBill.omodel1.pname = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[pname].Value);
            oBill.omodel1.ptuhao = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[ptuhao].Value);
            oBill.omodel1.jixing = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[jixing].Value);
            oBill.omodel1.pcolour = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[pcolour].Value);
            oBill.omodel1.qita = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[qita].Value);
            //
            oBill.omodel2.strg1 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg1].Value);
            oBill.omodel2.strg2 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg2].Value);
            oBill.omodel2.strg3 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg3].Value);
            oBill.omodel2.strg4 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg4].Value);
            oBill.omodel2.strg5 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg5].Value);
            oBill.omodel2.strg6 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg6].Value);
            oBill.omodel2.strg7 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg7].Value);
            oBill.omodel2.strg8 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg8].Value);
            oBill.omodel2.strg9 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg9].Value);
            oBill.omodel2.strg10 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg10].Value);
            oBill.omodel2.strg11 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg11].Value);
            oBill.omodel2.strg12 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg12].Value);
            oBill.omodel2.strg13 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg13].Value);
            oBill.omodel2.strg14 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strg14].Value);
            //
            oBill.omodel3.strm1 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm1].Value);
            oBill.omodel3.strm2 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm2].Value);
            oBill.omodel3.strm3 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm3].Value);
            oBill.omodel3.strm4 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm4].Value);
            oBill.omodel3.strm5 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm5].Value);
            oBill.omodel3.strm6 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm6].Value);
            oBill.omodel3.strm7 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm7].Value);
            oBill.omodel3.strm8 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm8].Value);
            oBill.omodel3.strm9 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm9].Value);
            oBill.omodel3.strm10 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm10].Value);
            oBill.omodel3.strm11 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm11].Value);
            oBill.omodel3.strm12 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm12].Value);
            oBill.omodel3.strm13 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm13].Value);
            oBill.omodel3.strm14 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm14].Value);
            oBill.omodel3.strm15 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm15].Value);
            oBill.omodel3.strm16 = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[strm16].Value);
            return true;
        }
 
 
 
    }
}