主题：单元格绘图问题求助？

汗，那你就这样测试，就例子我测试没问题

 

If e.Table.name = "窗口1_table2" Then
    If e.Col.name Like "*户型" AndAlso e.text > "" Then
        e.StartDraw()
        Dim cs() As Char = {"栋","幢", "-", "#", "/"}
        Dim fnt As New Font("宋体",9)
        Dim drs As List(Of DataRow) = DataTables("表C").Select("小区地址 = '" & e.Row("小区地址") & "'")
        For Each dr As DataRow In drs
            Dim ary() As String = dr("楼号").split(cs)
            If ary.length = 2 Then
                If ary(0) & "幢" = e.Row("小区楼号") AndAlso ary(1).length >= e.text.length AndAlso ary(1).Substring(0, e.text.length) = e.text Then
                    e.text = ""
                    Dim msg As String = dr("消售情况")
                    e.Graphics.DrawString(msg,fnt,Brushes.Red,e.x+1, e.y+1)
                    Exit For
                End If
            End If
        Next
        e.EndDraw()
       
    End If
End If

If e.Table.name = "窗口1_table2" Then     If e.Col.name Like "*户型" AndAlso e.text > "" Then         Dim cs() As Char = {"栋","幢", "-", "#", "/"}         Dim fnt As New Font("宋体",9)         Dim drs As List(Of DataRow) = DataTables("表C").Select("小区地址 = '" & e.Row("小区地址") & "'")         For Each dr As DataRow In drs             If dr("楼号").split(cs)(0) & "幢" = e.Row("小区楼号") AndAlso dr("楼号") Like "*" & e.text & "*" Then                 e.style = dr("消售情况")                 Exit For             End If         Next     End If End If 大红袍老师，我想在上面这个代码的基础上改，21楼主要指定的msg是绘制文字，搞得不是很清楚，老师别生气，我比较笨，理解的很慢！求指点应该怎么改？

看懂21楼啊。和13楼的也一样啊，你设置好对应的样式，就没问题。

我讲不清，我把您给我的代码放到案例里面，传上来！我是想要填充效果的。

看图，每十层以上的必然对应有去掉“1”的十层以下的标记

此主题相关图片如下：qq截图20160315210208.jpg

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:单元格绘图求助？.table

哦，多写了两句代码

 

If e.Table.name = "窗口1_table2" Then
    If e.Col.name Like "*户型" AndAlso e.text > "" Then
        Dim cs() As Char = {"栋","幢", "-", "#", "/"}
        Dim fnt As New Font("宋体",9)
        Dim drs As List(Of DataRow) = DataTables("表C").Select("小区地址 = '" & e.Row("小区地址") & "'")
        For Each dr As DataRow In drs
            Dim ary() As String = dr("楼号").split(cs)
            If ary.length = 2 Then
                If ary(0) & "幢" = e.Row("小区楼号") AndAlso ary(1).length >= e.text.length AndAlso ary(1).Substring(0, e.text.length) = e.text Then
                    e.style = dr("消售情况")
                    Exit For
                End If
            End If
        Next
    End If
End If

感谢大红袍老师！感谢指点！