private void button1_Click(object sender, EventArgs e) { string excelfilename = ""; try { if (this.openFileDialog1.ShowDialog() == DialogResult.OK) { excelfilename = this.openFileDialog1.FileName.Trim(); FileStream fs = new FileStream(excelfilename, FileMode.Open, FileAccess.Read); HSSFWorkbook workbook = new HSSFWorkbook(fs); HSSFSheet sheet = workbook.GetSheetAt(0); ArrayList shx = new ArrayList(); if (sheet != null) { int zhang = sheet.LastRowNum; for (int i = 1; i <= sheet.LastRowNum; i++) { string string1 = ""; HSSFCell cell = sheet.GetRow(i).GetCell(0); if (cell.CellType == 3) { int dn = i + 1; MessageBox.Show("第 " + dn.ToString() + " 行空行!", "管理系统提示", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } if (cell.CellType == 0) { string1 = sheet.GetRow(i).GetCell(0).NumericCellValue.ToString(); } else { string1 = sheet.GetRow(i).GetCell(0).StringCellValue.ToString(); } if (string1.Length != 12) { int dn = i + 1; MessageBox.Show("第 " + dn.ToString() + " 行代码位数不是12位!", "管理系统提示", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } string ss = string1 + sheet.GetRow(i).GetCell(1).StringCellValue; shx.Add(ss); } } fs.Close(); fs.Dispose(); Tools.Uitl uitl = new Uitl(); uitl.DrawTree_XZC(this.treeView1, shx);//画节点树 } } catch (System.Exception ex) { MessageBox.Show(ex.Message, "管理系统提示", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
private void button2_Click(object sender, EventArgs e) { using (DocumentLock documentLock = AcadApplication.DocumentManager.MdiActiveDocument.LockDocument()) //锁住文档以便进行写操作 { string connectionString = Uitl.GetConnectionString(); //写连接字符串 string selstring = "SELECT * FROM DataDic"; if (Tools.DataBasic.Create_Dic_table(connectionString)) { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlDataAdapter Adapter = DataBasic.Dic_Initadapter(selstring, connectionString); DataSet dataset = new DataSet(); Adapter.Fill(dataset, "DataDic");//填充Dataset System.Data.DataTable TB = dataset.Tables["DataDic"]; Tools.Uitl uitl = new Uitl(); ArrayList array = new ArrayList(); int count = TB.Rows.Count; #region 将DataTable的代码和名称天然数组 for (int i = 0; i < count; i++) { DataRow row = TB.Rows[i]; string xzdm = row[0].ToString().Trim(); if (xzdm.Length != 12) { return; } array.Add(xzdm + row[1].ToString().Trim()); } #endregion uitl.DrawTree_XZC(this.treeView1, array);//画节点树 Adapter.Dispose(); connection.Close(); } } }