/// <summary> /// 批量保存系统词典 /// </summary> /// <returns></returns> public static void SaveItem(System.Windows.Forms.TreeView treeView) { DataTable Dt = null; string sqlstr = null; try { Dt = new DataTable(); DataSet ds = new DataSet(); sqlstr = "select * from SysDictionary where 1=0"; ds = SQLDbHelper.Query(sqlstr); Dt = ds.Tables[0]; for (int i = 0; i < treeView.Nodes[0].Nodes.Count; i++) { for (int j = 0; j < treeView.Nodes[0].Nodes[i].Nodes.Count; j++) { DataRow Dr = Dt.NewRow(); Dr["ItemName"] = treeView.Nodes[0].Nodes[i].Text; Dr["Items"] = treeView.Nodes[0].Nodes[i].Nodes[j].Text; Dt.Rows.Add(Dr); } } SQLDbHelper.ExecuteSql("Delete from SysDictionary"); SQLDbHelper.UpdateTable(ds, sqlstr); } catch (Exception Err) { throw Err; } finally { //DbHelperSQL._connection.Close(); //Member.Common.DbHelper._connection.Close(); } }