有二个表,一个是 客户数据表 , 另一个是 片区统计
要求在片区统计表里面统计客户数据表里的客户所在片区,接星期统计,如下显示:
![dvubb 图片点击可在新窗口打开查看](skins/default/filetype/png.gif)
此主题相关图片如下:qq图片20150520111426.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2015-5/201552011214625406.png)
下面是我的表:
下面是我的代码,写了个开头,后面不知道怎么写了:
If e.DataCol.Name = "片区" Then
Dim cns() As String = {"星期一","星期二","星期三","星期四","星期五","星期六","星期日"}
If e.NewValue = Nothing Then
For Each cn As String In cns
e.DataRow(cn) = Nothing
Next
Else
Dim filter As String = "(片区 = '" & e.DataRow("片区") & "' or 片区 like '%," & e.DataRow("片区") & "' or 片区 like '%," & e.DataRow("片区") & ",%' or 片区 like '" & e.DataRow("片区") & ",%')"
For i As Integer = 0 To cns.Length - 1
e.DataRow(cns(i)) = DataTables("客户数据").compute("count(片区)", .............................
Next
End If
End If
[此贴子已经被作者于2015/5/20 11:24:24编辑过]