Dev 统计GridControl界面上当前选中的一行的值

        private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {    
            if( e.Column.FieldName.IndexOf("QTY")>-1)
            {
                int total= 0;
                object val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH1QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH2QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH3QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH4QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH5QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH6QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH7QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH8QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH9QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH10QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH11QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);
                val = gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["MONTH12QTY"]);
                total += val == DBNull.Value ? 0 :Convert.ToInt32(val);

                gridView1.SetRowCellValue(e.RowHandle,gridView1.Columns["SUM"], total);
            }
        }

 

posted @ 2013-08-30 08:58  沙耶  阅读(2626)  评论(0编辑  收藏  举报