报表增加合计

jingh

2021-03-31 715746486281876dcad7f40e618f1bc82c4baef1

报表增加合计

 SCM/µ¥¾Ý×ÊÁÏ/Gy_BarCodeDetailList.Designer.cs

@@ -70,11 +70,13 @@
            this.txtHBillNo = new System.Windows.Forms.TextBox();
            this.label4 = new System.Windows.Forms.Label();
            this.grdMain = new System.Windows.Forms.DataGridView();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.Tool.SuspendLayout();
            this.pPic.SuspendLayout();
            this.panel1.SuspendLayout();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            // 
            // Tool
@@ -93,7 +95,7 @@
            this.Tool.Location = new System.Drawing.Point(0, 0);
            this.Tool.Name = "Tool";
            this.Tool.Padding = new System.Windows.Forms.Padding(0);
            this.Tool.Size = new System.Drawing.Size(1176, 62);
            this.Tool.Size = new System.Drawing.Size(1276, 62);
            this.Tool.Stretch = true;
            this.Tool.TabIndex = 17;
            this.Tool.Text = "toolStrip1";
@@ -167,7 +169,7 @@
            this.pPic.Location = new System.Drawing.Point(0, 62);
            this.pPic.Margin = new System.Windows.Forms.Padding(4);
            this.pPic.Name = "pPic";
            this.pPic.Size = new System.Drawing.Size(1176, 41);
            this.pPic.Size = new System.Drawing.Size(1276, 41);
            this.pPic.TabIndex = 18;
            // 
            // panel1
@@ -175,7 +177,7 @@
            this.panel1.Controls.Add(this.lbljl);
            this.panel1.Controls.Add(this.lbldj);
            this.panel1.Dock = System.Windows.Forms.DockStyle.Right;
            this.panel1.Location = new System.Drawing.Point(995, 0);
            this.panel1.Location = new System.Drawing.Point(1095, 0);
            this.panel1.Margin = new System.Windows.Forms.Padding(4);
            this.panel1.Name = "panel1";
            this.panel1.Size = new System.Drawing.Size(181, 41);
@@ -217,6 +219,7 @@
            // groupBox1
            // 
            this.groupBox1.BackColor = System.Drawing.Color.Lavender;
            this.groupBox1.Controls.Add(this.grdSum);
            this.groupBox1.Controls.Add(this.textBox8);
            this.groupBox1.Controls.Add(this.label13);
            this.groupBox1.Controls.Add(this.textBox7);
@@ -248,7 +251,7 @@
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
            this.groupBox1.Size = new System.Drawing.Size(1176, 215);
            this.groupBox1.Size = new System.Drawing.Size(1276, 237);
            this.groupBox1.TabIndex = 52;
            this.groupBox1.TabStop = false;
            this.groupBox1.Enter += new System.EventHandler(this.groupBox1_Enter);
@@ -510,22 +513,39 @@
            this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 318);
            this.grdMain.Location = new System.Drawing.Point(0, 340);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1176, 367);
            this.grdMain.Size = new System.Drawing.Size(1276, 345);
            this.grdMain.TabIndex = 53;
            this.grdMain.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.grdMain_CellValueChanged);
            this.grdMain.RowStateChanged += new System.Windows.Forms.DataGridViewRowStateChangedEventHandler(this.grdMain_RowStateChanged);
            // 
            // grdSum
            // 
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(4, 209);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1268, 24);
            this.grdSum.TabIndex = 48;
            // 
            // Gy_BarCodeDetailList
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(1176, 685);
            this.ClientSize = new System.Drawing.Size(1276, 685);
            this.Controls.Add(this.grdMain);
            this.Controls.Add(this.groupBox1);
            this.Controls.Add(this.pPic);
@@ -533,6 +553,7 @@
            this.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2);
            this.Name = "Gy_BarCodeDetailList";
            this.Text = "成品分切检验明细表";
            this.Load += new System.EventHandler(this.Gy_BarCodeDetailList_Load);
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            this.pPic.ResumeLayout(false);
@@ -542,6 +563,7 @@
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);

        }
@@ -588,5 +610,6 @@
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator1;
        private System.Windows.Forms.TextBox textBox8;
        private System.Windows.Forms.Label label13;
        private System.Windows.Forms.DataGridView grdSum;
    }
}

 SCM/µ¥¾Ý×ÊÁÏ/Gy_BarCodeDetailList.cs

@@ -28,6 +28,7 @@
        public const string ModName = "1250";

        public string sDlgWhere = "";  //外窗体递入

        public int selectRow = 0;

        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();

        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();

        /// <summary>

        /// æŸ¥è¯¢

@@ -105,11 +106,33 @@
            var dt = AddDatable(DSet.Tables[0]);

            //

            grdMain.DataSource = dt.DefaultView;

            grdMain.RowHeadersVisible = false;

            //冻结

            //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);

            //string s = frmCondition.cmbHComplete.Text;

            //ClsPub1.DisplayGrid(grdMain, this.Name, s, FrCol);



            ////设置合计列

            string sTotalCol = "";

            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);

            string[] sT;

            sT = sTotalCol.Split(Convert.ToChar(","));

            oSumGrid.BuildTotalCols(sT);

            Total();



        }



        //合计 new

        private void Total()

        {

            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)

            {

                oSumGrid.SetGridsum();

                oSumGrid.TotalAll();

            }

        }





        public DataTable AddDatable(DataTable dt)

        {

            decimal tal = 0;

@@ -239,7 +262,13 @@


        private void grdMain_CellValueChanged(object sender, DataGridViewCellEventArgs e)

        {

        
            
        }



        private void Gy_BarCodeDetailList_Load(object sender, EventArgs e)

        {

            oSumGrid.ogrdMain = grdMain;  //初始化 new

            oSumGrid.oGridsum = grdSum;

        }

    }

}


 SCM/µ¥¾Ý×ÊÁÏ/Gy_BarCodeMain.Designer.cs

@@ -56,11 +56,13 @@
            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.tc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator();
            this.grdSum = new System.Windows.Forms.DataGridView();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            this.groupBox1.SuspendLayout();
            this.pPic.SuspendLayout();
            this.panel1.SuspendLayout();
            this.Tool.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            // 
            // grdMain
@@ -70,18 +72,19 @@
            this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 232);
            this.grdMain.Location = new System.Drawing.Point(0, 275);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1277, 393);
            this.grdMain.Size = new System.Drawing.Size(1277, 350);
            this.grdMain.TabIndex = 57;
            // 
            // groupBox1
            // 
            this.groupBox1.BackColor = System.Drawing.Color.Lavender;
            this.groupBox1.Controls.Add(this.grdSum);
            this.groupBox1.Controls.Add(this.comboBox1);
            this.groupBox1.Controls.Add(this.label8);
            this.groupBox1.Controls.Add(this.dateTimePicker2);
@@ -99,7 +102,7 @@
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
            this.groupBox1.Size = new System.Drawing.Size(1277, 129);
            this.groupBox1.Size = new System.Drawing.Size(1277, 172);
            this.groupBox1.TabIndex = 56;
            this.groupBox1.TabStop = false;
            this.groupBox1.Enter += new System.EventHandler(this.groupBox1_Enter);
@@ -358,6 +361,23 @@
            this.toolStripSeparator9.Name = "toolStripSeparator9";
            this.toolStripSeparator9.Size = new System.Drawing.Size(6, 62);
            // 
            // grdSum
            // 
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(4, 144);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1269, 24);
            this.grdSum.TabIndex = 51;
            // 
            // Gy_BarCodeMain
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
@@ -370,6 +390,7 @@
            this.Margin = new System.Windows.Forms.Padding(3, 2, 3, 2);
            this.Name = "Gy_BarCodeMain";
            this.Text = "检验执行情况表";
            this.Load += new System.EventHandler(this.Gy_BarCodeMain_Load);
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
@@ -379,6 +400,7 @@
            this.panel1.PerformLayout();
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);

        }
@@ -411,5 +433,6 @@
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator1;
        private System.Windows.Forms.ComboBox comboBox1;
        private System.Windows.Forms.Label label8;
        private System.Windows.Forms.DataGridView grdSum;
    }
}

 SCM/µ¥¾Ý×ÊÁÏ/Gy_BarCodeMain.cs

@@ -25,6 +25,7 @@
        public const string ModName = "1250";
        public string sDlgWhere = "";  //外窗体递入
        public int selectRow = 0;
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
        private void cx_Click(object sender, EventArgs e)
        {
@@ -64,7 +65,30 @@
            }
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            //
            grdMain.RowHeadersVisible = false;
            ////设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            Total();

        }


        //合计 new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.TotalAll();
            }
        }


        /// <summary>
        /// ç½‘æ ¼ å¯¼å‡ºEXCEL   ç½‘格，文件名，标题名
        /// </summary>
@@ -164,5 +188,11 @@
        {

        }

        private void Gy_BarCodeMain_Load(object sender, EventArgs e)
        {
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }
    }
}

 SCM/±¨±í/Qk_OutProcessList.Designer.cs

@@ -54,11 +54,13 @@
            this.textBox1 = new System.Windows.Forms.TextBox();
            this.label1 = new System.Windows.Forms.Label();
            this.grdMain = new System.Windows.Forms.DataGridView();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.Tool.SuspendLayout();
            this.pPic.SuspendLayout();
            this.panel1.SuspendLayout();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            // 
            // Tool
@@ -201,6 +203,7 @@
            // groupBox1
            // 
            this.groupBox1.BackColor = System.Drawing.Color.Lavender;
            this.groupBox1.Controls.Add(this.grdSum);
            this.groupBox1.Controls.Add(this.textBox3);
            this.groupBox1.Controls.Add(this.label8);
            this.groupBox1.Controls.Add(this.dateTimePicker2);
@@ -216,7 +219,7 @@
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
            this.groupBox1.Size = new System.Drawing.Size(1157, 129);
            this.groupBox1.Size = new System.Drawing.Size(1157, 192);
            this.groupBox1.TabIndex = 58;
            this.groupBox1.TabStop = false;
            // 
@@ -321,14 +324,31 @@
            this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 232);
            this.grdMain.Location = new System.Drawing.Point(0, 295);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1157, 318);
            this.grdMain.Size = new System.Drawing.Size(1157, 255);
            this.grdMain.TabIndex = 59;
            // 
            // grdSum
            // 
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(4, 164);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1149, 24);
            this.grdSum.TabIndex = 51;
            // 
            // Qk_OutProcessList
            // 
@@ -341,6 +361,7 @@
            this.Controls.Add(this.Tool);
            this.Name = "Qk_OutProcessList";
            this.Text = "墙咔工资统计报表";
            this.Load += new System.EventHandler(this.Qk_OutProcessList_Load);
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            this.pPic.ResumeLayout(false);
@@ -350,6 +371,7 @@
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);

        }
@@ -380,5 +402,6 @@
        private System.Windows.Forms.TextBox textBox1;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.DataGridView grdMain;
        private System.Windows.Forms.DataGridView grdSum;
    }
}

 SCM/±¨±í/Qk_OutProcessList.cs

@@ -26,6 +26,7 @@
        public const string ModName = "1250";
        public string sDlgWhere = "";  //外窗体递入
        public int selectRow = 0;
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
        private void yl_Click(object sender, EventArgs e)
        {
@@ -75,7 +76,29 @@
            //
           var dt= AddDatable(DSet.Tables[0]);
            grdMain.DataSource = dt.DefaultView;

            grdMain.RowHeadersVisible = false;
            ////设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            Total();
        }


        //合计 new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.TotalAll();
            }
        }


        public DataTable AddDatable(DataTable dt)
        {
            decimal tal = 0;
@@ -177,5 +200,11 @@
                MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
            }
        }

        private void Qk_OutProcessList_Load(object sender, EventArgs e)
        {
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }
    }
}

 SCM/±¨±í/Qk_ProcessBillDetail.Designer.cs

@@ -53,9 +53,11 @@
            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.tc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator();
            this.grdSum = new System.Windows.Forms.DataGridView();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            this.groupBox1.SuspendLayout();
            this.Tool.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            // 
            // label3
@@ -83,13 +85,13 @@
            this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 191);
            this.grdMain.Location = new System.Drawing.Point(0, 242);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1220, 429);
            this.grdMain.Size = new System.Drawing.Size(1220, 378);
            this.grdMain.TabIndex = 62;
            // 
            // textBox4
@@ -113,6 +115,7 @@
            // groupBox1
            // 
            this.groupBox1.BackColor = System.Drawing.Color.Lavender;
            this.groupBox1.Controls.Add(this.grdSum);
            this.groupBox1.Controls.Add(this.textBox4);
            this.groupBox1.Controls.Add(this.label3);
            this.groupBox1.Controls.Add(this.textBox3);
@@ -132,7 +135,7 @@
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
            this.groupBox1.Size = new System.Drawing.Size(1220, 129);
            this.groupBox1.Size = new System.Drawing.Size(1220, 180);
            this.groupBox1.TabIndex = 61;
            this.groupBox1.TabStop = false;
            // 
@@ -309,6 +312,23 @@
            this.toolStripSeparator9.Name = "toolStripSeparator9";
            this.toolStripSeparator9.Size = new System.Drawing.Size(6, 62);
            // 
            // grdSum
            // 
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(4, 152);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1212, 24);
            this.grdSum.TabIndex = 50;
            // 
            // Qk_ProcessBillDetail
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
@@ -319,11 +339,13 @@
            this.Controls.Add(this.Tool);
            this.Name = "Qk_ProcessBillDetail";
            this.Text = "生产工序明细表";
            this.Load += new System.EventHandler(this.Qk_ProcessBillDetail_Load);
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);

        }
@@ -353,5 +375,6 @@
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator2;
        private System.Windows.Forms.ToolStripButton tc;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator9;
        private System.Windows.Forms.DataGridView grdSum;
    }
}

 SCM/±¨±í/Qk_ProcessBillDetail.cs

@@ -27,6 +27,7 @@
        public string sDlgWhere = "";  //外窗体递入
        public int selectRow = 0;
        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
@@ -55,7 +56,30 @@
            var dt= AddDatable(DSet.Tables[0]);
            //
            grdMain.DataSource = dt;


            grdMain.RowHeadersVisible = false;
            ////设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            Total();
        }


        //合计 new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.TotalAll();
            }
        }


        private void cx_Click(object sender, EventArgs e)
        {
            
@@ -164,5 +188,11 @@
                MessageBox.Show("将此工作表导出为excel共耗时：" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
            }
        }

        private void Qk_ProcessBillDetail_Load(object sender, EventArgs e)
        {
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }
    }
}

 SCM/±¨±í/Qk_ProcessbillMain.Designer.cs

@@ -58,11 +58,13 @@
            this.txtHBillNo = new System.Windows.Forms.TextBox();
            this.label4 = new System.Windows.Forms.Label();
            this.grdMain = new System.Windows.Forms.DataGridView();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.Tool.SuspendLayout();
            this.pPic.SuspendLayout();
            this.panel1.SuspendLayout();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            // 
            // Tool
@@ -205,6 +207,7 @@
            // groupBox1
            // 
            this.groupBox1.BackColor = System.Drawing.Color.Lavender;
            this.groupBox1.Controls.Add(this.grdSum);
            this.groupBox1.Controls.Add(this.textBox4);
            this.groupBox1.Controls.Add(this.label3);
            this.groupBox1.Controls.Add(this.textBox3);
@@ -224,7 +227,7 @@
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
            this.groupBox1.Size = new System.Drawing.Size(1291, 129);
            this.groupBox1.Size = new System.Drawing.Size(1291, 158);
            this.groupBox1.TabIndex = 57;
            this.groupBox1.TabStop = false;
            // 
@@ -365,15 +368,32 @@
            this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 232);
            this.grdMain.Location = new System.Drawing.Point(0, 261);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1291, 409);
            this.grdMain.Size = new System.Drawing.Size(1291, 380);
            this.grdMain.TabIndex = 58;
            this.grdMain.RowPrePaint += new System.Windows.Forms.DataGridViewRowPrePaintEventHandler(this.grdMain_RowPrePaint);
            // 
            // grdSum
            // 
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(4, 130);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1283, 24);
            this.grdSum.TabIndex = 49;
            // 
            // Qk_ProcessbillMain
            // 
@@ -386,6 +406,7 @@
            this.Controls.Add(this.Tool);
            this.Name = "Qk_ProcessbillMain";
            this.Text = "背景管制报表";
            this.Load += new System.EventHandler(this.Qk_ProcessbillMain_Load);
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            this.pPic.ResumeLayout(false);
@@ -395,6 +416,7 @@
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);

        }
@@ -429,5 +451,6 @@
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.TextBox textBox3;
        private System.Windows.Forms.DataGridView grdMain;
        private System.Windows.Forms.DataGridView grdSum;
    }
}

 SCM/±¨±í/Qk_ProcessbillMain.cs

@@ -26,6 +26,7 @@
        public const string ModName = "1250";
        public string sDlgWhere = "";  //外窗体递入
        public int selectRow = 0;
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
        private void yl_Click(object sender, EventArgs e)
        {
@@ -59,7 +60,29 @@
            }
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            grdMain.RowHeadersVisible = false;
            ////设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            Total();

        }


        //合计 new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.TotalAll();
            }
        }


        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
@@ -175,5 +198,11 @@
                }
            }
        }

        private void Qk_ProcessbillMain_Load(object sender, EventArgs e)
        {
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
        }
    }
}

 SCM/Éú²ú¹ÜÀí/Sc_PackUnionBillList.cs

@@ -324,5 +324,11 @@
            //刷新
            Display();
        }

        private void cmdDataOut_Click(object sender, EventArgs e)
        {
            //DataGridViewToExcel2(grdMain, this.Text, this.Text);
            BLL.ClsPub_BLL.DataGridViewToExcel2(grdMain, this.Text);
        }
    }
}

 SCM/Éú²ú¹ÜÀí/Sc_PackUnionBillList.designer.cs

@@ -56,6 +56,7 @@
            this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator();
            this.bclk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator8 = new System.Windows.Forms.ToolStripSeparator();
            this.cmdDataOut = new System.Windows.Forms.Button();
            ((System.ComponentModel.ISupportInitialize)(this.grdPrint)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.groupBox1.SuspendLayout();
@@ -78,7 +79,7 @@
            // 
            this.grdPrint.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdPrint.Location = new System.Drawing.Point(1029, 182);
            this.grdPrint.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdPrint.Margin = new System.Windows.Forms.Padding(4);
            this.grdPrint.Name = "grdPrint";
            this.grdPrint.RowHeadersWidth = 51;
            this.grdPrint.RowTemplate.Height = 23;
@@ -94,7 +95,7 @@
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(0, 725);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
@@ -106,6 +107,7 @@
            // groupBox1
            // 
            this.groupBox1.BackColor = System.Drawing.Color.Lavender;
            this.groupBox1.Controls.Add(this.cmdDataOut);
            this.groupBox1.Controls.Add(this.button2);
            this.groupBox1.Controls.Add(this.label4);
            this.groupBox1.Controls.Add(this.dtpHEDate);
@@ -121,9 +123,9 @@
            this.groupBox1.Controls.Add(this.btnOK);
            this.groupBox1.Dock = System.Windows.Forms.DockStyle.Top;
            this.groupBox1.Location = new System.Drawing.Point(0, 59);
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.groupBox1.Margin = new System.Windows.Forms.Padding(4);
            this.groupBox1.Name = "groupBox1";
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.groupBox1.Padding = new System.Windows.Forms.Padding(4);
            this.groupBox1.Size = new System.Drawing.Size(1768, 161);
            this.groupBox1.TabIndex = 50;
            this.groupBox1.TabStop = false;
@@ -132,7 +134,7 @@
            // 
            this.button2.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.button2.Location = new System.Drawing.Point(1591, 25);
            this.button2.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.button2.Margin = new System.Windows.Forms.Padding(4);
            this.button2.Name = "button2";
            this.button2.Size = new System.Drawing.Size(149, 46);
            this.button2.TabIndex = 23;
@@ -156,7 +158,7 @@
            this.dtpHEDate.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.dtpHEDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            this.dtpHEDate.Location = new System.Drawing.Point(833, 88);
            this.dtpHEDate.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.dtpHEDate.Margin = new System.Windows.Forms.Padding(4);
            this.dtpHEDate.Name = "dtpHEDate";
            this.dtpHEDate.Size = new System.Drawing.Size(348, 49);
            this.dtpHEDate.TabIndex = 21;
@@ -178,7 +180,7 @@
            this.dtpHBDate.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.dtpHBDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            this.dtpHBDate.Location = new System.Drawing.Point(833, 29);
            this.dtpHBDate.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.dtpHBDate.Margin = new System.Windows.Forms.Padding(4);
            this.dtpHBDate.Name = "dtpHBDate";
            this.dtpHBDate.Size = new System.Drawing.Size(348, 49);
            this.dtpHBDate.TabIndex = 19;
@@ -187,7 +189,7 @@
            // 
            this.btnFQBD.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.btnFQBD.Location = new System.Drawing.Point(1239, 26);
            this.btnFQBD.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.btnFQBD.Margin = new System.Windows.Forms.Padding(4);
            this.btnFQBD.Name = "btnFQBD";
            this.btnFQBD.Size = new System.Drawing.Size(149, 46);
            this.btnFQBD.TabIndex = 18;
@@ -199,7 +201,7 @@
            // 
            this.button1.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.button1.Location = new System.Drawing.Point(1239, 86);
            this.button1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.button1.Margin = new System.Windows.Forms.Padding(4);
            this.button1.Name = "button1";
            this.button1.Size = new System.Drawing.Size(149, 46);
            this.button1.TabIndex = 17;
@@ -211,7 +213,7 @@
            // 
            this.txtHBarCode.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.txtHBarCode.Location = new System.Drawing.Point(224, 88);
            this.txtHBarCode.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.txtHBarCode.Margin = new System.Windows.Forms.Padding(4);
            this.txtHBarCode.Name = "txtHBarCode";
            this.txtHBarCode.Size = new System.Drawing.Size(345, 49);
            this.txtHBarCode.TabIndex = 16;
@@ -231,7 +233,7 @@
            // 
            this.txtHSourceBillNo.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.txtHSourceBillNo.Location = new System.Drawing.Point(224, 30);
            this.txtHSourceBillNo.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.txtHSourceBillNo.Margin = new System.Windows.Forms.Padding(4);
            this.txtHSourceBillNo.Name = "txtHSourceBillNo";
            this.txtHSourceBillNo.Size = new System.Drawing.Size(345, 49);
            this.txtHSourceBillNo.TabIndex = 1;
@@ -241,7 +243,7 @@
            // 
            this.btnTC.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.btnTC.Location = new System.Drawing.Point(1419, 88);
            this.btnTC.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.btnTC.Margin = new System.Windows.Forms.Padding(4);
            this.btnTC.Name = "btnTC";
            this.btnTC.Size = new System.Drawing.Size(149, 46);
            this.btnTC.TabIndex = 13;
@@ -264,7 +266,7 @@
            // 
            this.btnOK.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.btnOK.Location = new System.Drawing.Point(1419, 26);
            this.btnOK.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.btnOK.Margin = new System.Windows.Forms.Padding(4);
            this.btnOK.Name = "btnOK";
            this.btnOK.Size = new System.Drawing.Size(149, 46);
            this.btnOK.TabIndex = 6;
@@ -280,7 +282,7 @@
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 220);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
@@ -364,6 +366,18 @@
            this.toolStripSeparator8.Name = "toolStripSeparator8";
            this.toolStripSeparator8.Size = new System.Drawing.Size(6, 59);
            // 
            // cmdDataOut
            // 
            this.cmdDataOut.Font = new System.Drawing.Font("宋体", 21.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.cmdDataOut.Location = new System.Drawing.Point(1591, 88);
            this.cmdDataOut.Margin = new System.Windows.Forms.Padding(4);
            this.cmdDataOut.Name = "cmdDataOut";
            this.cmdDataOut.Size = new System.Drawing.Size(149, 46);
            this.cmdDataOut.TabIndex = 24;
            this.cmdDataOut.Text = "导出";
            this.cmdDataOut.UseVisualStyleBackColor = true;
            this.cmdDataOut.Click += new System.EventHandler(this.cmdDataOut_Click);
            // 
            // Sc_PackUnionBillList
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
@@ -375,7 +389,7 @@
            this.Controls.Add(this.grdPrint);
            this.Controls.Add(this.grdSum);
            this.KeyPreview = true;
            this.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4);
            this.Margin = new System.Windows.Forms.Padding(4);
            this.Name = "Sc_PackUnionBillList";
            this.Text = "源单列表";
            this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
@@ -419,5 +433,6 @@
        private System.Windows.Forms.Label label4;
        private System.Windows.Forms.DateTimePicker dtpHEDate;
        private System.Windows.Forms.Button button2;
        private System.Windows.Forms.Button cmdDataOut;
    }
}