报表增加合计

jingh

2021-03-31 715746486281876dcad7f40e618f1bc82c4baef1

 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;
        }
    }
}