/// <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();
}
}