public void changeDisporder(Int32 nodeAID, Int32 nodeBID) { isSucces = true; string connectionString = DBSource.ConnectionStringPBox; int nodeAID_Disporder = 0; int nodeBID_Disporder = 0; string commandTextA = "SELECT * FROM FileNode WHERE node_id=" + nodeAID; string commandTextB = "SELECT * FROM FileNode WHERE node_id=" + nodeBID; helperPBox = new dBHelper(connectionString); if (helperPBox.Load(commandTextA, "node_id") == true) { foreach (DataRow dr in helperPBox.DataSet.Tables[0].Rows) { nodeAID_Disporder = int.Parse(dr["disporder"].ToString()); } } if (helperPBox.Load(commandTextB, "node_id") == true) { foreach (DataRow dr in helperPBox.DataSet.Tables[0].Rows) { nodeBID_Disporder = int.Parse(dr["disporder"].ToString()); } } string commandTextC1 = "update FileNode set disporder = " + nodeBID_Disporder + " WHERE node_id=" + nodeAID; string commandTextC2 = "update FileNode set disporder = " + nodeAID_Disporder + " WHERE node_id=" + nodeBID; isSucces = isSucces && helperPBox.ExecuteNonQuery(commandTextC1); isSucces = isSucces && helperPBox.ExecuteNonQuery(commandTextC2); }
public void deleteFileNode(Int32 nodeID) { isSucces = true; string connectionString = DBSource.ConnectionStringPBox; helperPBox = new dBHelper(connectionString); //1、先删除节点下的所有文件数据 string commandText = "SELECT * FROM FileMemo WHERE file_nodeid=" + nodeID; if (helperPBox.Load(commandText, "file_nodeid") == true) { foreach (DataRow dr in helperPBox.DataSet.Tables[0].Rows) { int curFileID = int.Parse(dr["file_id"].ToString()); isSucces = isSucces && deleteFileData(curFileID); } } //2、删除节点下的所有文件描述信息 commandText = "delete FROM FileMemo WHERE file_nodeid=" + nodeID; isSucces = isSucces && helperPBox.ExecuteNonQuery(commandText); //3、再删除节点下所有子节点 commandText = "SELECT * FROM FileNode WHERE parent_id=" + nodeID; if (helperPBox.Load(commandText, "node_id") == true) { foreach (DataRow dr in helperPBox.DataSet.Tables[0].Rows) { int curNodeID = int.Parse(dr["node_id"].ToString()); deleteFileNode(curNodeID); } } //4、删除自己 commandText = "SELECT * FROM FileNode WHERE node_id=" + nodeID; if (helperPBox.Load(commandText, "node_id") == true) { if (helperPBox.DataSet.Tables[0].Rows.Count == 1) { helperPBox.DataSet.Tables[0].Rows[0].Delete(); try { if (helperPBox.Save() == true) { isSucces = isSucces && true; } else { isSucces = isSucces && false; MessageBox.Show("Delete failed"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }