存储过程把找到的记录的MenuOrder值与离他最近的一条进.docx

螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀膄蒃蒀螆膃膂蚆蚂蝿芅葿薈袈莇蚄袆袈肆蒇螂袇艿蚂螈袆莁薅蚄袅蒃莈羃袄膃薃衿袃芅莆螅袂莈薂蚁羂肇莅薇羁膀薀袆羀莂莃袂罿蒄蚈螇羈膄蒁蚃羇芆蚇蕿羆荿葿袈羆肈蚅螄肅膀蒈蚀肄芃蚃薆肃蒅蒆羅肂膅荿袁肁芇薄螇肀荿莇蚃肀聿薃蕿腿膁莅袇膈芄薁螃膇莆莄虿膆膆蕿蚅膅芈蒂羄膄莀蚇袀 using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Configuration;public partial class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) Add_Table(); if (!IsPostBack) /添加数据 / table.Visible = false; Table2.Visible = false; if (Requestid=null) table1.Visible = false; / table2.Visible = false; DataTable dt = Add_recored(); Add_Records(dt,null); else if (Requestid.ToString() = 1) table1.Visible = true; Table2.Visible = false; / table2.Visible = false; DataTable dt = Add_recored(); Add_Records(dt, null); else if (Requestid.ToString() = 2) /table1.Visible = true; Table2.Visible = true; DataTable dt = Add_recored(); Add_Records(dt, null); private void Add_Records(DataTable dt,TreeNode node) DataView dv = new DataView(dt); if (node = null) dv.RowFilter = parentid=0; else dv.RowFilter = parentid=+node.Value+; foreach (DataRowView item in dv) TreeNode tn = new TreeNode(itemmenuname.ToString(), itemmenuid.ToString(); Add_Records(dt, tn); if (node = null) TreeView1.Nodes.Add(tn); else node.ChildNodes.Add(tn); private DataTable Add_recored() string str_con = ConfigurationManager.ConnectionStringscon.ConnectionString; using (SqlConnection con = new SqlConnection(str_con) using (SqlCommand cmd = new SqlCommand(select * from menutree order by ParentID,MenuOrder, con) DataSet ds = new DataSet(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd) sda.Fill(ds); return ds.Tables0; /添加数据的方法体 protected void LinkButton1_Click(object sender, EventArgs e) Table2.Visible = true; table1.Visible = false; / Add_Table(); private void Add_Table() table1.Visible = false; Create_Table_Title(); /生成表头 DataTable dt = create(); TableRow row = null; TableCell cell = null; foreach (DataRow item in dt.Rows) row = new TableRow(); cell = new TableCell(); cell.Text = itemmenuid.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = itemmenuname.ToString(); row.Cells.Add(cell); cell = new TableCell(); LinkButton link = new LinkButton(); link.Text = 进入栏目; link.PostBackUrl = ; cell.Controls.Add(link); /cell.Text = 栏目设置类; row.Cells.Add(cell); cell = new TableCell(); cell.Text = itemmenupath.ToString(); row.Cells.Add(cell); Table2.Rows.Add(row); cell = new TableCell(); LinkButton lb = new LinkButton(); lb.CommandArgument = itemmenuid.ToString(); lb.CommandName = 1; lb.Command += new CommandEventHandler(lb_Command); lb.Text = -; cell.Controls.Add(lb); row.Cells.Add(cell); cell = new TableCell(); LinkButton llb = new LinkButton(); llb.CommandArgument = itemmenuid.ToString(); llb.CommandName = -1; llb.Command += new CommandEventHandler(lb_Command); llb.Text = +; cell.Controls.Add(llb); row.Cells.Add(cell); Table2.Rows.Add(row); void lb_Command(object sender, CommandEventArgs e) /Response.Write(e.CommandArgument.ToString(); string str_con = ConfigurationManager.ConnectionStringscon.ConnectionString; using (SqlConnection con = new SqlConnection(str_con) using (SqlCommand cmd = new SqlCommand(Sort, con) cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(mid, e.CommandArgument.ToString(); cmd.Parameters.Add(sig, e.CommandName.ToString(); con.Open(); cmd.ExecuteNonQuery(); Server.Transfer(default.aspx?id=2); / Add_Table(); /throw new NotImplementedException(); private void Create_Table_Title() TableRow row = new TableRow(); TableCell cell = new TableCell(); cell.Text = 栏目编号; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 栏目名称; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 栏目类型; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 栏目路径; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 上移; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 下移; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 状态; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 编辑; row.Cells.Add(cell); cell = new TableCell(); cell.Text = 删除; row.Cells.Add(cell); Table2.Rows.Add(row); protected void LinkButton2_Click(object sender, EventArgs e) table1.Visible = true; Table2.Visible = false; protected void LinkButton3_Click(object sender, EventArgs e) Insert(); Server.Transfer(default.aspx?id=1); private void Insert() string str_con = ConfigurationManager.ConnectionStringscon.ConnectionString; using (SqlConnection con = new SqlConnection(str_con) using (SqlCommand cmd = new SqlCommand(insert menutree values(menuid,Parentid,MenuName,MenuPath,menuorder), con) con.Open(); cmd.Parameters.Add(menuid, TextBox1.Text); cmd.Parameters.Add(menuorder, TextBox2.Text); cmd.Parameters.Add(Parentid, TextBox3.Text); cmd.Parameters.Add(MenuName, TextBox4.Text); cmd.Parameters.Add(MenuPath, TextBox5.Text); try cmd.ExecuteNonQuery(); catch (Exception) throw; protected void Button1_Click(object sender, EventArgs e) protected void LinkButton4_Click(object sender, EventArgs e) protected DataTable create() string str_con = ConfigurationManager.ConnectionStringscon.ConnectionString; using (SqlConnection con = new SqlConnection(str_con) using (SqlCommand cmd = new SqlCommand(select * from menutree where parentid=0 order by ParentID,MenuOrder , con) DataSet ds = new DataSet(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd) sda.Fill(ds); return ds.Tables0; 存储过程: create proc Sortmid nvarchar(20), -移动的MenuIDsig INT -这里是方向上,下1向下-1向上ASbeginSET NOCOUNT ON;declare name int -用来存储MenuOrder上一条的 -取值 set name=(select MenuOrder from (select top 100 ROW_NUMBER() over(order by menuorder) as id,MenuID,MenuOrderfrom MenuTree where ParentID=0 order by ParentID, MenuOrder) as ttt where ttt.id=(select from (select top 100 ROW_NUMBER() over(order by menuorder) as id,MenuID,MenuOrderfrom MenuTree where ParentID=0 order by ParentID, MenuOrder ) as ttt where )-print name -把前一参数的MenuOrder存起来declare menuid varchar(20) -取idset menuid=(select MenuID from (select top 100 ROW_NUMBER() over(order by menuorder) as id,MenuID,MenuOrderfrom MenuTree where ParentID=0 order by ParentID, MenuOrder) as mmm where mmm.id=(select from (select top 100 ROW_NUMBER() over(order by menuorder) as id,MenuID,MenuOrderfrom MenuTree where ParentID=0 order by ParentID, MenuOrder ) as ttt where )-print menuid -把前一参数的MenuOrder存起来-select * from MenuTree where ParentID=0 order by ParentID,MenuOrder -print menuiddeclare name1 int-存当前行的MenuOrder值set name1=(select MenuOrder from MenuTree where ) -取当前行的MenuOrder值-print name1update MenuTree set whereupdate MenuTree set where -修改当前的Menuorderend 芈薇薅袁芈芇螁螇袄荿薃蚃羃蒂蝿羁羂膁薂袇羂芄螇螃羁蒆薀蝿羀薈蒃肈罿芈蚈羄羈莀蒁袀羇蒃蚇螆肆膂葿蚂肆芄蚅羀肅莇蒈羆肄蕿蚃袂肃艿薆螈肂莁螁蚄肁蒃薄羃肀膃螀衿膀芅薃螅腿莈螈蚁膈蒀薁肀膇芀莄羆膆莂虿袁膅蒄蒂螇膄膄蚇蚃膄芆蒀羂芃荿蚆袈节蒁葿螄芁膀蚄蚀芀莃蒇聿艿蒅螂羅芈薇薅袁芈芇螁螇袄荿薃蚃羃蒂蝿羁羂膁薂袇羂芄螇螃羁蒆薀蝿羀薈蒃肈罿芈蚈羄羈莀蒁袀羇蒃蚇螆肆膂葿蚂肆芄蚅羀肅莇蒈羆肄蕿蚃袂肃艿薆螈肂莁螁蚄肁蒃薄羃肀膃螀衿膀芅薃螅腿莈螈蚁膈蒀薁肀膇芀莄羆膆莂虿袁膅蒄蒂螇膄膄蚇蚃膄芆蒀羂芃荿蚆袈节蒁葿螄芁膀蚄蚀芀莃蒇聿艿蒅螂羅芈薇薅袁芈芇螁螇袄荿薃蚃羃蒂蝿羁羂膁薂袇羂芄螇螃羁蒆薀蝿羀薈蒃肈罿芈蚈羄羈莀蒁袀羇蒃蚇螆肆膂葿蚂肆芄蚅羀肅莇蒈羆肄蕿蚃袂肃艿薆螈肂莁螁蚄肁蒃薄羃肀膃螀衿膀芅薃螅腿莈螈蚁膈蒀薁肀膇芀莄羆膆莂虿袁膅蒄蒂螇膄膄蚇蚃膄芆蒀羂芃荿蚆袈节蒁葿螄芁膀蚄蚀芀莃蒇聿艿蒅螂羅芈薇薅袁芈芇螁螇袄荿薃蚃羃蒂蝿羁羂膁薂袇羂芄螇螃羁蒆薀蝿羀薈蒃肈罿芈蚈羄羈莀蒁袀羇蒃蚇螆肆膂葿蚂肆芄蚅羀肅莇蒈羆肄蕿蚃袂肃艿薆螈肂莁螁蚄肁蒃薄羃肀膃螀衿膀芅薃螅腿莈螈蚁膈蒀薁肀膇芀莄羆膆莂虿袁膅蒄蒂螇膄膄蚇蚃膄芆蒀羂芃荿蚆袈节蒁葿螄芁膀蚄蚀芀莃蒇聿艿蒅螂羅芈薇薅袁芈芇螁螇袄荿薃蚃羃蒂蝿羁羂膁薂袇羂芄螇螃羁蒆薀蝿羀薈蒃肈罿芈蚈羄羈莀蒁袀羇蒃蚇螆肆膂葿蚂肆芄蚅羀肅莇蒈羆肄蕿蚃袂肃艿薆螈肂莁螁蚄肁蒃薄羃肀膃螀衿膀芅薃螅腿莈螈蚁膈蒀薁肀膇芀莄羆膆莂虿袁膅蒄蒂螇膄膄蚇蚃膄芆蒀羂芃荿蚆袈节蒁葿螄芁膀蚄蚀芀莃蒇聿艿蒅螂羅芈薇薅袁芈芇螁螇袄荿薃蚃羃蒂蝿羁羂膁薂袇羂芄螇螃羁蒆薀蝿羀薈蒃肈罿芈蚈羄羈莀蒁袀羇蒃蚇螆肆膂葿蚂肆芄蚅羀肅