我的项目打开我希望不加载任何数据,以下是我的所有表,我在
BeforeLoadOuterTable,写的代码~~~~~~~~~~~~~~~~~~~~这样是可行了,但我感觉有一点累赘,是否有更好的更简单的代码??
Select Case e.DataTableName
Case "订单"
e.SelectString = "Select * From {订单} Where [_Identify] Is Null"
Case "人员"
e.SelectString = "Select * From {人员} Where [_Identify] Is Null"
Case "经销商信息"
e.SelectString = "Select * From {经销商信息} Where [_Identify] Is Null"
Case "专卖店目标"
e.SelectString = "Select * From {专卖店目标} Where [_Identify] Is Null"
Case "专卖店签约"
e.SelectString = "Select * From {专卖店签约} Where [_Identify] Is Null"
Case "产品VLOOKUP"
e.SelectString = "Select * From {产品VLOOKUP} Where [_Identify] Is Null"
Case "文具领用"
e.SelectString = "Select * From {文具领用} Where [_Identify] Is Null"
Case "目标"
e.SelectString = "Select * From {目标} Where [_Identify] Is Null"
Case "个案申请"
e.SelectString = "Select * From {个案申请} Where [_Identify] Is Null"
Case "文件管理"
e.SelectString = "Select * From {文件管理} Where [_Identify] Is Null"
Case "文具明细"
e.SelectString = "Select * From {文具明细} Where [_Identify] Is Null"
Case "行政区域"
e.SelectString = "Select * From {行政区域} Where [_Identify] Is Null"
Case "企业信息"
e.SelectString = "Select * From {企业信息} Where [_Identify] Is Null"
End Select