Dim dr As DataRow Dim dlzh As String = Forms("主界面").Controls("姓名").Text dlzh = dlzh.Trim("登","录","账","号","[","]",":"," ") DataTables("账户管理").LoadFilter= "[用户账号] = '" & dlzh & "'" DataTables("账户管理").Load dr = DataTables("账户管理").Find("[用户账号] = '" & dlzh & "'") If dr("木质素纤维") = False Then MessageBox.Show("对不起!您没有生成报表的权限!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Warning) Else Dim flg As New SaveExcelFlags flg.RowNumber = True flg.CellStyle = True Tables("木质素纤维").SaveExcel("D:\excel\木质素纤维试验报告F.xls","木质素纤维试验报告F_Table1",flg) Dim Proc As New Process Proc.File = "D:\excel\木质素纤维试验报告F.xls" Proc.Start() End If
|