添加链接权限的字段：
//权限管理
n.Target = "MainFrame";
//折叠
TreeView1.Nodes.Add(n);
n.Expanded = false;
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAd0AAACvCAIAAAA3wpNHAAAV5klEQVR4nO2d32scR4LH9y9pCVtKBkl+MhxsyEtYGPxm7uHIm9/8dm+BNquws6y1IJn0OmosRavIkmesNVmbcaSIjfxTGnCSGxzCjo+LxwF7AvGsd2nvmSbZxnjJHbUPZXfK9aurZ6arezzfD1+M1arurqrp/nRNTffoZwQAAECR+FneFQAAAPAS8DIAABQLeBkAAIoFvAwAAMUCXgYAgGIBLwMAQLGAlwEAoFjAywAAUCx0Xg7DsFKplMvlSqXSarXCMFSVDIKg3W5rCuRO3JZWq5V3XTIkiqJut5vpC9Fqtcrlsu/7RX65ARhqdF5uNBrllHQ6HWtVTwW1CWWAat7d3S2Xy/V6vdVqtVqter1OL2PNZjOKIlomiqJOpxMEgWojYRi2221NASntdrter3e7XXYhvfZkd/npdDpxN1YqlSx2AQDQeZl1GcX3/UajwTqIg9OEniAIfN83NH6lUtnd3aW7TrUXsS31ej3t6lKolPVXqSiKDBtYTnNVY/0YXwAIIWIbwzBstVrNZrP1Mpo+jKIoCAJ2szHcISGtcBAEGEoD0A86L7Mnv34rcTHzQV8Pg3GOdrtt2sqUXo6iqN1uV6vVcrncbDYTW62iXq8HQWDeIsPrTRiG7Frs0JjWOW6jfu/ValXcuPRy2xtSswMAEtF5mTur43frmvGyoZc5s/RGo9FI3Es8P6DysvieQGR3d1e6fW5d6kf2YkadHrtS+sa/2WzG5U1Exm6/XC77vs+uFb8otI3tdlvfNG7jqa4iibzaU/kAZEe6eYxEDN/AisaPPzbkfpV21jWm2+0m1jY2ph6Vl7naUg2x7wNoGda87Xab1WgQBPGMcDnpTQkRBrN0GkF/kYu37/s+VxnxwsZ1fg/zRWy3w8sA9IbOy1EU0fnfarWquR8jCIJWq5X2fowwDKXlB+Vlk5lr3/dpMXFKhJOpai+cl9nBbNy6xEFrjKY53DCZKo9qulqttttt1u9szbkRNHutFYfnbHPY36peLCnxtDu8DEBvyL0c31XWA/1/qmaoKj1USfEHU2xz2BrGvuMGj6yX9TcISjuBnZVmy8QfXcaYNJb9gJFOXHCuj69enIXZJXQ2Oe4H6cUmrmo89Wx+UYlnVOJV4GUAekPu5R5mMFj6PCHZTfWznRhusFlmbiRgf8V+DhYPt+nbfxWaCdl4F2wZcQus+FR70Y/9G41Gp9ORzsk0m032AsOuom9O/Aom3nPC7ovbSA/TIAAAovIyJzL2dqhms0lvM2DLc3oqmpelY3+pN6mFxVljFWxJKibWs7SXzD9MU03asJO23BRzGIaaW/HofY3SX6naxXUOJYoiOhZm26J6YxTPd+N+DAB6Q+5l1enHLudGQ+zAqlBe1tyQF9uH/ejM93127KmXi9Tg8RL6gaG5lxNFxtaTfV263S51ujiPwU0os70hvU+u0+mIUxy0fKPREC/A0kFx7HEAQA+k8zI7GORu7GXP/54/rKOwZ34/2yEGd0nHMpXe1ZB4K57ey+JNxOJUdRAEjUaDKk+/L3bUXK1W46axMy3saNp/QbyK2FKTKyj3ymo6Uz/nAwAwRHk/BicXCjtZyZ3S7Nnb59PY7Knez3ZUUqafB4q7ENWc6ErRy+z7BjqWjMtUKhX6tGS8etxpmlvxVHVj96uZgOaeNKHE+k40KbvfarXaw4Mqw87dR8Hy/u13Ll19e/UiMlI5tn759PUvGt98a/+oS+dl9vzn5DuoL6DgzvzeNhJFETun7Ps+e0Vhn1HmBrCc4BLvLTH53E96J3Wz2dRMCklbxG3B933xkZmYeKQfXyfYtpj3MDc1n8Xj7IWl8c23b3kbjushI57DcyubzTs2j70UXuZumWo2m77vxwpmz1jNs8uJ9O9l0VPE4DlsjWE1o2bpWpVKhV0l3nW9Xo+iiLtxolKpGE7F0jF+pVKJJd7pdHzf393dpV9nwb4JiMuIQ2P22qMfp+vvA3mFvfz902fH1i/Tc3Js1p+Yr5aWtqZWdmY2rh8630Be/dT2plZ2Ssvbk6c2x3+1RI+EI4vnHwRP7ByByV6mp67+obIgCFhDaaZl2+22+XcVaYzA3gLcbDar1eru7i4d/3KF6YhY5eUoikSP7+7ucpVU+cvkzg1xxCravF6vGz64EYYhNz8Tzx6wdY7L67/vQvOsEFvM933pjczsReKV4e6j4I35NWrk189czt8RSN6ZWtkZr3zguN7Mr89c/fq+hYNQ6eX45Kef9XOSEu+KbTQadKFmCNa/kTWwU6V0ylU6k1t+8di3ajuxaMTaiu8DTLwcTwVovMy2Qpyd73a7Kr3Gl0C2gex1UbUiHbyLtQ3DkGs427GarwBstVqvwD0Yj3+Ifj6/5rjegZOrM+du5m4EpCip7U0s1BzXm5xdbHYeZn0cJvy9kjAMuffderloHlnu81mVRPQDN87LUluJ2pU+VcEaLXFWnbsTnHtyTy9oOphVPXjJVoPbi/SbjGgNVY/Lh2Eo7RPpZEUURfrnTdgvZe35q1lz4e3Vi1TK+YsAKV4mT23SUfPjH7IdgiifK5EOi0RziY/SlRX3Y4inPX3qQX/G0u+ES/zyycT7GcR5jFarRZUnPibDIt7UwQ3M4+VSL6tGl6qb21hUW+CGupwiuc6XTm6ISD+cTPwmVfNr7VDcQnf16/t0+gIjZUSe2t6Bk6uO6/1mp5HpofjcyyZfg6CRl9TOXPlut0vvuu3n3W632xXHjybnfD83EmiexdB72eTbM8TtcL0Xf1eJ7/viNYzrDbEA+1v9FDZ9gcovZpMNO4coXn2OoRgv07svSktb+Z//SFEz/eGndDYj0yHzcy9rBj70rlWTbYlvbzO6oTWKoniMmThSprDuMFyFJQzDTqcjek31d0NiuM5UzepymzK/AZw+wqcxKTteznT+V5zyikl8PKcINDsPHdcbf/dM7mc+UvAcnFtzXO/sZ19ldzS+NI9Bv7Gz1Wr1+cAee89AqpFXpsRDy8H+laMwDDXdlejNrIknKOz86cUoirjPhAv7Jx85Fq7cclxv8tRm7qc9UvC87tcd1zte287uaEz43A+AEeF4bdtxvdLydu6nPVLwTK9fc1zvjfm17I5GeBkAQgg5snjecb3ptSu5n/ZI8UOnmLM7GuFlAAghhD5Lcqi2l/s5jxQ/4++ecVwvu6MRXgaAkNjLeZ/wyFAEXgbABvAyYh54GQAbwMuIeeBlAGwALyPmgZcBsAG8jJgHXgbABvAyYh54GQAbwMuIeeBlAGwALyPmgZcBsAG8jJgHXgbABvAyYh54GQAbwMuIeeBlAGwALyPmgZcBsAG8jJgHXgbABkX2MiHEwiqZ1jn3+gw28DIANhhqL4sFTFZRkVGd9VvOuj6DDbwMgA2K42XDCmusJ/7WxJuq5T3Uh6tM2vqbLM838DIANiiOl0Ursf/qS2pUOEAPJpYhSReJwdbHfuBlAGxQQC+TF0oS/2Oyln6hpit624Wq2ub16WFfeQVeBsAGhfIyrZLUTdyvcrGbvgIs4hL2V5oVNSWLEHgZABsUxMu0MokejIuxTVCZUdxCYm8kVtKkIeaFhy7wMgA2KIiXWa+pMPegdKH4o2pTAymQuC9zcn9R4sDLANiggF7ubTnJ28vivqT0sN/iBF4GwAYF9LIKvQ2lhYnWy/ofNftKrHa8JF6L/TfVTgsVeBkAGxTQy70tJ+nHy/ofzeug2hox87KK3F8LMfAyADYooJdV6G1I8vayWNK8Ff3sy2bgZQBsUEAv97BcbFei3dgV+6wbVybepurfQe3LfuBlAGxQNC+nDW1FWrsRYaQsXWLIoZd1fEhtZE1VDWueb+BlAGxQEC+nqnOiv4j2iTvp8v5VSIRBuliNxF1oal6EwMsA2KAgXh54iGL8m2qtLOqQdq1CBV4GwAavqpeRLAIvA2ADeBkxD7wMgA3gZcQ88DIANoCXEfPAywDYAF5GzAMvA2ADeBkxD7wMgA3gZcQ88DIANoCXEfPAywDYAF5GzAMvA2ADeBkxD7wMgA3gZcQ88DIANoCXEfPAywDYAF5GzAMvA2ADeBkxD7wMgA3gZcQ88DIANnjL23Bcb3r9Wu7nPFL8OK4HLwOQOcfWLzuuN7Wyk/s5jxQ8M+duOq53eG4lu6MRXgaAEEJmP77huN5rv/so99MeKXhKy9uO6x1dupDd0QgvA0AIIZ/cuee43oGTq7mf9kjBM7FQc1xv4cqt7I5GeBkAQgj5/umzydlFx/WmP/w09zMfKWxmNq6PnTjtuN6fv/trdkcjvAzAc5b3bzuud3BuLfeTHyls6GA500kMAi8DEPPsxx8Pz604rjfpXcj9/EcKmNLSFr0T4+6jINNDEV4G4CeanYcTs4uO6732/h9ztwBSqJSWtugMxvL+7ayPQ3gZgJc4+9lXdEx08LdnZzau564DJPfMnLs5+d4f6FHxzqWrFg5CeBkAnk/u3KOfAY6dOD2xUCstbR2q7eVuB8R+pn7/p8lTm2O/fJ9K+fT1L+wcgfAyABIeBE+O17bp2RhnvPLBgZOryChkbNZnX/qjSxeanYfWDj94GQAlD4InC1duHV26wAl6pHLwvdFt/pHF87Mf37BpZAq8DADQUaru512FkQNeBgDogJftAy8DAHTAy/aBlwEAOuBl+8DLAAAd8LJ94GUAgA542T7wMgBAB7xsH3gZAKADXrYPvAwAkHD7b+Gz//t/wnj51l/+N9cajRDwMgBAwn/u/0/t7kPywsu3/xa+efHzvCs1KsDLAAAJ9578482Ln//96T+pl/9958ub3z3Ou1KjArwMAJAz/+X9+S/vl6r7H33zl+M3/jvv6owQ8DIAQM7fn/7zzYufl6r7v6j/170n/8i7OiMEvAwAUFK7+7BU3Z//8n7eFRkt4GUAdNx9FCzv337n0tW3Vy+OZv5t49p/rF7KvRr2c2z98unrXzS++db+UQcvAyCn8c23b3kbuX8FcP45cTr/OuSaw3Mrm807No89eBkAnu+fPju2fpmek2Oz/sR8tbS0NbWygz/3Nyqp7U2t7JSWtydPbY7/aokeCUcWzz8Intg5AuFlAF7i7qPgjfk1auTXz1zO3xFI3pla2RmvfOC43syvz1z92sZUO7wMwE88/iH6+fya43oHTq7OnLuZuxGQoqS2N7FQc1xvcnbRwp+VgpcB+Im3Vy9SKecvAqR4mTy1SUfNj3+IMj0O4WUAnnP16/t0+gIjZUSe2t6Bk6uO6/1mp5HpoQgvA/AcevdFaWkr//MfKWqmP/yUzmZkOmSGlwEghJBm56HjeuPvnsn9zEcKnoNza47rnf3sq+yORngZAEIIWbhyy3G9yVObuZ/2SMHzul93XO94bTu7oxFeBoAQQo7Xth3XKy1v537aIwXP9Po1x/XemF/L7miElwEghJAji+cd15teu5L7aY8UP3SKObujEV4GgBBC6LMkh2p7uZ/zSPEz/u4Zx/WyOxrhZQAIib2c9wmPDEXgZQBsAC8j5oGXAbABvIyYB14GwAbwMmIeeBkAG8DLiHngZQBs0IOXCSEZFbYTrkqZ1jDtxg3Ls8Vs9jC8DIAN+vGydIN6gxiuYlhyUK7Ub7mf+iRuOVV5Va9mUXNp4GUAbNCnl1OJRvxtKjdJS5qgqU9iecv1SfsSJHo51fLEwMsA2GCovdxDGWv1ob9l/zWpj0hiz2ta1E9PSgMvA2ADcy9zKyZ6xLA8kXnQsGRvrtTrUlqftPsigkATK29SGenWNLvopyfhZQByI6/xslhyINFslmu4Rlv92I1bToQLVapqE7WX2VZk159c4GUAbJDWy3QtlU30S1T/N5Qgu2tN9UyaYF64t57Rd4i0RaqFiTVXdUufPSkNvAyADXrzMjGYx2ANoinPrSVuIZV2UxVI3Jc5hitq6iOtmLhl81b02ZPwMgC5kcrLRJBsoiYMiw3KJqlWV/VJnxZL1TR954gVttaT0sDLANigZy/r/8NaT+oCYmYT/Y+pdMM1PF7CtUvcQuJO9TvidqrauLSkqvkWelIaeBkAG6S6H0NvB6L1Dis+jgHaRF9A3Box87KKVHXQ94/YUZrmSwsnNjZVT0oDLwNgg0Hdj0EM7EBk4uvnR3MnqkpK+yRtP4jLVaTtTFXzNT2fuG7ajmIDLwNggwHeJ0e03jlk5mWVOvt0pdSbXJWk1ethX6mWs21k0fQwV8z8VUjVk9LAywDYoH8vE8G8msKGHpEWky4xhNOxxsiq+pj7N21narbD1parv6aj0vakeeBlAGzQ//cWqURDXtYckSlGv4WBq1BaGW6zibsQV1G1S4N+d9JdaCqm2fhgexJeBsAGg33ez6QkUegmrpLhNgcSsTIm2x9sHQa+i+x6El4GwAb4XnzEPPAyADaAlxHzwMsA2GDUvEysT0FY2KO1wMsA2GBkvazqELYku1BfWLoL6Y9DHXgZABsMr5cNGyiuJf2/5rdEfQNGDxXLvd/6CbwMgA2G18tiSMpbKcTy4m/Jy3ZO3J1hsSENvAyADUbEy2LDpeWJ1svSjSTWQVOroQu8DIANRsTLqjJEPXym/aPZuHQJSenx4Qq8DIANRsrLtMmqVaS/ImnmMdjtm5QfusDLANhgBL1MFC4mCmUTs/sxSE/zHsMVeBkAG4yOl4niy4nEJdzWiHrgLC6UFjOp3lAEXgbABvCyuITbGlF4Wbo7gvFyH8DLABAyMl4mZjLlFhK1ylX70uxIU71hCbwMgA1GxMv6MpqFROZZzY4Ixst9AC8DQAi8bPw4n/5HcXniBocx8DIANhhSL6dqo0aORD0Klv6oKc8tFH8rLT9cgZcBsMGQernnkPTfjxH/KC0vLaYn907oOfAyADYYTS/TtmsKHDKeuFCt/koGXgbABqPmZaSfwMsA2ABeRswDLwNgA3gZMQ+8DIAN4GXEPPAyADaAlxHzwMsA2OAtb8Nxven1a7mf80jx47gevAxA5hxbv+y43tTKTu7nPFLwzJy76bje4bmV7I5GeBkAQgiZ/fiG43qv/e6j3E97pOApLW87rnd06UJ2RyO8DAAhhHxy557jegdOruZ+2iMFz8RCzXG9hSu3sjsa4WUACCHk+6fPJmcXHdeb/vDT3M98pLCZ2bg+duK043p//u6v2R2N8DIAz1nev+243sG5tdxPfqSwoYPlTCcxCLwMQMyzH388PLfiuN6kdyH38x8pYEpLW/ROjLuPgkwPRXgZgJ9odh5OzC46rvfa+3/M3QJIoVJa2qIzGMv7t7M+DuFlAF7i7Gdf0THRwd+endm4nrsOkNwzc+7m5Ht/oEfFO5euWjgI4WUAeD65c49+Bjh24vTEQq20tHWotpe7HRD7mfr9nyZPbY798n0q5dPXv7BzBMLLAEh4EDw5XtumZ2Oc8coHB06uIqOQsVmffemPLl1odh5aO/zgZQCUPAieLFy5dXTpAifokcrB90a3+UcWz89+fMOmkSnwMgBAR6m6n3cVRg54GQCgA162z78Auu1uRmteLLEAAAAASUVORK5CYII=" alt="" />
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgUAAACRCAIAAADcllwmAAAQG0lEQVR4nO2dz28exRnH+Us2FtjEwn4v5RbRA+KSW9UTN265cd4KRxSVFDmHVWJkp1Fw4thBUUlESBoRBUxwJCBFAYSoGgRSEFLKLwUaUABFRqGaHhasl52d2Wfn3d3Z5/Xno6+q952dfeaZ2Xnm+9qvU+4xLfP+jS+TNJvYuzg4cRkhj+7bt5yk2el3r7W9J7VDTSGh6tbUPa1uXGPMgfUrSZpNzq9GXxrUc+1cOJ2k2Z61c23vSe1QU0ioujXVuh/sWTuXpNn00tnoS4N6rpnli0maPZyttL0ntUNNIaHq1lTrfrB74USSZjPPXYi+NKj/StJsam6h7T2pHWoKyVWrplr3g13zy0mazR6/FH1dUP81sXcxSbO296R2qCkkV62a6sgPoi8KUiH8QAI1heTCD5BW4QcSqCkkF36AtAo/kEBNIbnwA6RV+IEEagrJhR8grcIPJFBTSC7dfmCM8bytdW9Af38EYfy6aQQobJU6SGzE4fADCfgBkmts/WA4rPB2/0CFUE0F3+rmWhPXjPyd/ZlU5ibpIEE4tVrPImzvblvwAyTXOPuB/ULIcJDKlrrBJTlLZuTvbLfXmq8/58oHEdBNGCF4725b8AMkl2I/MO6DbODwg4CwnqvCIE0N55qXf1B5Jp7O/iBhkw17OsPCDyTgB0gu9X5gHOepqTo9PTFdb4PjlHYoUDmcPaPSIGEJe2K6ItddotKAdR/QsPADCfgBkkurHwzfNdxYeG3qnzKuUeQBXbNzdXa9tS95rrpaCrf4sxImGdZemrz9Qi78QAJ+gOTS6ge5jOPD8sA6Cku72bjiD4YMptZdlY2mjh8MvAeoa7611lO4MnUX0/XWM51m9+62BT9Aco2JH9hvjeDjvP9qZcDS2/OJCMfamrhnRPvtViY2dv/KOUoWpFaQykdjzyVsCPxAAn6A5FLsB0bwcb60mydCZcDSIew+pbg6Vw5UOqPSCdqNhav+rDyPJuBxuGZU9zG5hB9IwA+QXFr9YPiugXWQDdwHjfEe6J5RTJUfuEZ0NZqm/UA4rn++tdrr3utZw1p5Durv3W1LU35gZF81Be+fsD3Q6iw6yCds6PYS0+oHpYtiBAdNoU+BsCE8r12NrvT8jcZtIaW3jLJ1Km+sfJqSsP518As/kNCBHwwPF7ydCpuhFNeI/s7CWXSWT2U0eWKNS7Ef+JcpD1i5j+UB5be7Zid/tJ5GU3aAeiZir4k/K09Y/3JVLqY/pvD2YeEHErrxA/uFEOHe84/o71xoFybTQT6uJO3gdVcyWLr9IL/L84RMzWfsf1rGvX2Dn71rlLqjS+J7YtovKq8KJyjsI7m9IPxAQiN+YNzHU919ItzDdgT7qme40gSE3fqQjzyxZqXVD/L+njUy7gdgQhddMoT82VfGlEzQ078yYOlS+IN4Vsy/mAGrXSn8QEKDfmBkn72M7FEO9y/g36ulI5YGqdxjrm4d5FN6VbiGwhUOkFY/qFwjU/X8PAi3jt3iyUTSuTJnez+VbrJas3ZFtrsJV6/0Rtf0K9enqb27bRndD4ajeXamGfmQMt6t69nn9tClLWZoN9p0n4/92n7hSdiffJjGxA9M6Gf54PiemJXJ2Jfy6fujhc3I1NymbahylLA08AMJjX9/UIjv2r2ViZX2F27drXHlG3s4ft3+jefjeuuJMHq9SDQmfoC2ofADCZ19n2xGO8K2EvYMYb/dGtrG7j98l79/N/m4bh99MYOFHyCtwg8kNP59st1iBKeY59Lgt+e1HdkzurEOek9WnjxN2QHdaj7ynOWM+JQH+EH/ZTr5lY5G4QcSGv/+oBB/4D5nTdlJ5xpi0Oj5Wzqc8R6y3eTjj+bP35NAU8IP+i6DHziEH0iI+PNBoU+Bytv9jcZ9ZJfe4h8oSj6eFasc2vV6ROEH/ZJwoaLn2QfhBxJaqilTduQZrx/UiilpNGWnp2eg4f423efjWTH7LjvJ0jUfUfhB32U4/R3CDyQ0+H2y8X4+NWVHWOlrzxClLf7IlW/t9sqAHedTeUk47ujCD/ougx84hB9IaOr7A8+eNO7D1LiPYNctpW8lCXj6Fxrtq/7+beTjX5DhVO20C5ElaysUftA7Va5S9Ax7IvxAQhs1Zar8wFgHlgvPXf6YhUul/Uu79SEf+2ohVGkH/yVPTLnwg77LYAAO4QcSGq8pU/O3JXUj52n7hw4bsW5iLeVTmYZnuOC1FQo/6LsMfuAQfiCBmkJy4Qc9Uq21ip5tdOEHErZ5TaFawg/6K9PC35ONk/ADCdQUkgs/6KmM92/70AA/kEFNIbnwgz4qX41CywAz+K3wAwnUFJILP+idTFf/9kS78AMJ1BSSCz/okfJF2HpdeDHo5A/OFAk/kLDNawrVEn7QU5n2/+2JduEHEqgpJBd+0FPlCxI9jT4LP5BATSG58AOkVfiBBGoKyYUfIK3CDyRQU0gu/ABpFX4ggZpCcuEHSKvwAwnUFJILP0BahR9IoKaQXL30g7XXo68L6r92zD2LH1RCTSG5atVU636we+FEkmYzx16Nvi6o/0rSDD+ohJpCctWqqdb94LFjZ5I0mz50Lvq6oJ5rdmU9SbNd88tt70ntUFNIqLo11bof/OX85STNprKT0ZcG9Vw7F88kafbokVNt70ntUFNIqLo11bofXP740yTNJv78t+hLg3quyfnVJM0OrF9pe09qh5pCQtWtqdb9YPPu3am5hSTNZp67EH11UG81u7K+408HkjT75OattvekdqgpJFFATbXuB8aYQxtXf/k4w19EIIfu++vRJM3mXnqtgw05BlBTqFIBNdWFH2zevfvgvsNJmk0+sxJ9jVAPdf/BF5I0m5pb+Pr7HzvYkGMANYX8CqupLvzAGPPhFzfzn3An51f5RIOGlW/cJM1Ov3utm904HlBTyKXgmurID4wxr1y7nm/fe58+wu890eDE5dmV9clnVvKNy9fIAVBTqKARa6o7PzDGvH/jy9mnFvNcJ+dXdy6emT1+KfoKou41vXR2cv9a/mXX1NzC829/0OU+HCeoKZSrkZrq1A+MMbfvbO6/+Eb+oWZLE08u3fv0EbQdtOOJg8OP/vGTL3/27e2ON+GYQU1tczVYU137Qc5n394+tHH10SOnhqex3TS58GL0HGLpD0sn9198gz8tbRBqKqGmRq6pOH4Axpjp1Y3YKQCMFdTUiOAH0WDvAjQLNTUi+EE02LsAzUJNjQh+EA32LkCzUFMjgh9Eg70L0CzU1IjgB9Fg7wI0CzU1IvhBNNi7AM1CTY0IfhAN9i5As1BTI4IfRIO9C9As1NSI4AfRmF7dQAg1q+9/uhu7shWDH0Tj6lffxU5BPdN8HoQhqKkRwQ9AMfgBQIPgB6AY/ACgQfADUAx+ANAg+AEoBj8AaBD8ABSDHwA0CH4AisEPABoEPwDF4AcADYIfgD6ufvXd5s//M0N+8Mbn/42aEcA4gB+APh7f+Pfah/8xv/rB1a++e+jUW7GTAlAPfgD6+OjWDw+deuubOz/lfvDH8+9cuvF17KQA1IMfgErm37k+/8716dWNv3/8+Z7X/hU7HYBxAD8AlXxz56eHTr01vbrxyIv//OjWD7HTARgH8APFfHLz1tE335t76bVHj5zahnrk6Pnp1Y3fH7sQPZPu9fjJlw+sX/nwi5ux9yCMFfiBSi5//OnD2UqSZttcU0v/2PHEwehpRNSD+w4///YHsfcjjAn4gTJu39ncs3YuPwt2PHFw8pmVnYtnHjh8fubYq4MTl9HYa/b4pQcOn59eOju5f21i72K+Ex7OVj779nbsvQnqwQ808fX3P+5eOJGk2Y65Z+8/+EL0swlF1/TS2dwVZp9a5NdHMCL4gRpu39nMzWDiySV+GkBbmj1+6d6nj+SW8MnNW7H3KSgGP1DDY8fO5GYwe/xS9DMI9Utrr9+3bzlJs13zy5t3+Q9GQiD4gQ5euXY9/zURPxmgUs0evzTx5FKSZkfffC/2bgWt4Ac6yP+aiO8MkEfTS2eTNPvdvsO372zG3rCgEvxAAe/f+DJJs4m9i9FPHNRz5b81Ov3utdh7FlSCHyjgwPqVJM0m51ejHzeo59q5cDpJsz1r52LvWVAJfqCA/B8cTC+djX7coJ5rZvli/s8RYu9ZUAl+oID8z0xnnrsQ/bhB/VeSZlNzC7H3LKgEP1DArvnlJM34M1MkUf7P02LvWVAJfqCA3A+iHzRIhfADCAY/UAB+gOTCDyAY/EAB+AGSCz+AYPADBeAHSC78AILBDxSAHyC58AMIBj9QAH6A5MIPIBj8QAH4AZILP4Bg8AMF4AdILvwAgsEPFIAfILnwAwgGP1AAfoDkwg8gGPxAAfgBkgs/gGDwAwXgB0gu/ACCwQ8UgB8gufADCAY/UAB+gOTCDyAY/EAB3fiBMcbzNiBCx+pg9LAl6nhZ8AMIBj9QwHj4gWeCzeZfOUqhUZ6S3V6ZfFOzkws/gGDwAwV07wd2DpWXTOjJaLcLl8Wfv+Sq+dUPaqUqSUmeduPCDyAY/EABHfiB8f5wYNynmPF+KpcfsrXSq+xj97evGreTlQ4nyaGRyY4o/ACCwQ8U0Jkf2P9beYSZso/Ypbd4Jhh8vJaGLe1vvH4gSUmSZyOTHVH4AQSDHyigbT/IRxl+UWivPKmNwA9GzLBuH2MZgGtedvDSFntlCkgSbnxlbOEHEAx+oIBW/cA4fiYofV16u7Eswe5fOUdJkv4Opo4fFCZbOZwkSeF8W3qOW8IPIBj8QAFd/r4oxz4Zh9sL6VWev6Ut8qvCDq7M7dsLOZeueeni1F3PgImMLvwAgsEPFNDx9wfDJ6z8UDPx/GA4eTsNTzKFDqVTcF21KQzhotXnOMAPYATwAwV0/32yCTrcjftztLGOS0lAYQfTtB9IphCWcK0gYcIPIBj8QAFRfj4IOBldQexG/9tax6ipf4jnq1qa8NalWjkEJ9+G8AMIBj9QQPTfFxn38e255GkX3lXrSC3t42ksnZ1nIHtxCvj7151OsPADCAY/UEA/f19U6Gafs5VjVfasdYB68vT39L8tbffEtF9UXm1W+AEEgx8ooPt/n7zVKG833uPSc/iWtgjxR5ZcGpTZhmvWng5GduL7rzYi/ACCwQ8UEOX/r8KIz3R5iyumZ6ywKfjzkUzWbixEsHFFtru1KvwAgsEPFNClH+QjBh/EdvvWLMKC1E3DM5ZxfDYXDm3EfhNX+AEEgx8ogP8eDpILP4Bg8AMF4AdILvwAgsEPFIAfILnwAwgGP1AAfoDkwg8gGPxAAfgBkgs/gGDwAwXgB0gu/ACCwQ8UgB8gufADCAY/UAB+gOTCDyAY/EAB+AGSCz+AYPADBeAHSC78AILBDxSAHyC58AMIBj9QAH6A5MIPIBj8QAH4AZILP4Bg8AMF4AdILvwAgsEPFPCLH6y9Hv2sQf3Xjrln8QMIAz9QwO6FE0mazRx7NfpZg/qvJM3wAwgDP1DAY8fOJGk2fehc9LMG9VyzK+tJmu2aX469Z0El/wd9xePf1OBxXgAAAABJRU5ErkJggg==" alt="" />
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAN8AAABVCAIAAABGsKbFAAAFkUlEQVR4nO2dwU9TSRzH/UuGBos0UrLJmuyBeDFc9rZHbty4cX4ba1izsKQcZqGmZQkChULYCAEhRAOWChsUDNEVjZA1EUlYUAMR3KLLdlPN7OG5pPbNe32vtG9+he83n8M4nTdvZvpxpu9dOCMQhGrOqB4AgpgGdiJ0AzsRunHJzvWdvd57jwI3Z+u6R8CponH4Vnt8ce3VTh7aFN3O+ecbl3iUaRycci60dA09eOJIniLamTxMNcQm9ZGVXe7wtkYrw+Pnu6aq+u5UD86DE4+/P3G+a8oXmfC2xTxXwroJl3h0az+p2M7dgw/fhgaZxssC18513FC+UkA5vsiE7qj/atjmQV8UO5OHKV1NT1MEOyU4wt+fKG/u1gVd39lTY2d937iupr8/oXxFAC1id8+29DCN1wR7Uum023bOrL7QD3TsmkCKvz/haYowjffee+S2nfoTOn5rAgt8kQmm8a9bupKHKffsfLz5mmnccyWsfP6AOPr5Pvpw1T072+OLTOPe4IDyyQPiVIZGmcYbYpPu2am/4PRFJpRPHhCnqmdaf/3pnp36i6Sq67eVTx7Qh2m8IhByz86aYA/TOF4kATvoL+fdtlP5tEFJADsBXWAnoAvsBHSBnYAusBPQBXYCusBOQBfYCegCOwFdYCegC+wEdIGdgC6wE9AFdjpGCFHUS4yNzS7PYySlBex0jO6EdHbWl9jp1rpg0a3ZgitfruMAOx0j/rdTWn9Uth9pz8Z6s5FYtDG7sFSAnc4Q5vuZHYcc3SKzJjPSltK7OL01NWCnM0Rx7DRbrmoTBaXNzHooXWCnAzK/b5sqOGovZCe7MN8gzT6SjqQUgZ0OsFDK4hKb9UYdRa4foLATdn7xlTuyU5+yWVdmNcaykO2j1Ya91izKly5vYKcthGE/M0vWJaIQe61FV0ImrvUtSgjY6Qxh2L0yFTE2E7lstmiQ1VtWjbSNdJClC+x0hpk0ZkIY6y3UsTBMepV0MFlRvmLHAXY6QxhOUmNB2t6iRlpv/U9jpZD9J4Gdp9FOoxbGsv2ao3phIrrUPOmtpReWLgW2M7b25/KbdyfbTmsDcvphbYyx/2obdhoLdu5FnwLbmdjcvThyv3Hu2fb7f06qnTlrzD41kyyzgbGNtJzVLLOQFeUrdhwKf7KnPn4Kr2x88+tCeGUj9fET7LTT2GiSUdOsHowF+7crFXLbWT+zkge1Y0u+gbmLI/ezDvpStxO4SW47l9+8c8rC9tuG2adfDf328+8vD/794o96wE5gn8Kf7InN3dqxpYbZpy//+tv4KewE9imwnY1zz2rHlha235o1gJ3APgW284+998YnIdgJ8gNv4wFdYCegC+wEdIGdgC6wE9AFdgK6wE5AF9gJ6AI7AV0U2Rm7q3zmgD5lgWuu2vn5L2D33VE+c0AfpnFX7azvG2ca93VOKp85II4/Gmcarwn2uGfnj1PzTOMVfFj55AFxKsPjTON13SPu2Tn/fINp3PPDL8onD4jjDQ4wjbfHF92zM5VOVwRCTONV128rnz8giz8aL/u+nWl8fWfPPTuFEJ1zy5+3Tzy5AxPO/tTLNB64OWvtUuHtTKXTF1q6mMa9rVHlqwAIcq7jBtN4RSC0e/DBbTuFEGuvdvTz3RscwA4KMtHVZBoffbiaU6Si2CmEmFl9oQta3tyN36CgenDeH417W6O6mtYPQ0W3UwjxePO1/2pYH403OFAZHvf3J5SvEXAfX2TC2xbTH4MqAqGhB09sKlREO4UQycNU2/SCvoke4WmKlDd3g9NA2eWOzK++cfjW1n7Svj/FtVPP1n6yc265rnskc6Dg9PBdZLhtesH65ZE0btiJIPkFdiJ0AzsRuoGdCN3AToRuYCdCN7AToRvYidAN7EToBnYidAM7Ebr5D1QYmU9g4N92AAAAAElFTkSuQmCC" alt="" />
页面设计：
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UserRightManger.aspx.cs" Inherits="BioErpWeb.HRSystem.UserRightManger" %> <%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link href="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />
<link href="../Styles/AspNetPagerStyle.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<asp:UpdatePanel id="up_all" runat="server">
<contenttemplate> <cc1:ModalPopupExtender ID="modal_Add" TargetControlID="btnNew" PopupControlID="Panel_Add" runat="server">
</cc1:ModalPopupExtender> <asp:ImageButton ID="imgEditBtn" Width="1" Height="1" runat="server" />
<cc1:ModalPopupExtender ID="Modal_Update" TargetControlID="imgEditBtn" PopupControlID="Panel_Update" runat="server">
</cc1:ModalPopupExtender>
<div>
<asp:Panel ID="Panel_Add" runat="server" CssClass="pLogo">
<table class="tb_mess">
<thead class="name"><caption>权限信息添加</caption></thead>
<tr>
<td>权限名</td><td>
<asp:TextBox ID="txtRightName0" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtRightName0" ErrorMessage="*必须填写"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>备注</td><td>
<asp:TextBox ID="txtReMark0" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtReMark0" ErrorMessage="*必须填写"></asp:RequiredFieldValidator>
</td>
</tr>
<tr><td colspan="2"></td></tr>
<tr><td colspan="2"></td></tr>
<tr><td colspan="2"></td></tr>
<tr>
<td colspan="2" class="bottomtd">
<asp:Button ID="btnAdd" runat="server" Text="提交" onclick="btnAdd_Click" />
<asp:Button ID="Button1" runat="server" Text="关闭" CausesValidation="False"
UseSubmitBehavior="False" /></td>
</tr>
</table>
</asp:Panel>
</div>
<div>
<asp:Panel ID="Panel_Update" runat="server" CssClass="pLogo">
<table class="tb_mess">
<thead class="name"><caption>权限信息编辑</caption></thead>
<tr>
<td>权限名</td><td>
<asp:TextBox ID="txtRightName1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>备注</td><td>
<asp:TextBox ID="txtReMark1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2" class="bottomtd">
<asp:Button ID="btnUpdate" runat="server" CausesValidation="false" Text="提交" onclick="btnUpdate_Click" /><asp:Button ID="btnClose" CausesValidation="false" runat="server" Text="关闭" /></td>
</tr>
</table>
</asp:Panel>
</div> <table class="maintable">
<tr>
<td class="titlebar">
权限管理系统
</td>
</tr>
<tr>
<td style=" text-align:right; padding-right:10px; ">
<asp:Button ID="btnNew" runat="server" Text="添加" BackColor="#CDEAFB" Width="80px" Height="30px" />
</td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" Width="100%" AutoGenerateColumns="False"
runat="server" onrowcommand="GridView1_RowCommand" ShowFooter="True" DataKeyNames="ID">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="check_all" Width="50px" runat="server" />
</ItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="lb_checkall" CausesValidation="false" runat="server" Text="全选" CommandName="allcheck"></asp:LinkButton>
<asp:LinkButton ID="lb_recheckall" CausesValidation="false" CommandName="recheck" runat="server" Text="反选"></asp:LinkButton>
</FooterTemplate>
<FooterStyle HorizontalAlign="Center" Width="60px" />
<ItemStyle HorizontalAlign="Center" Width="50px"/>
</asp:TemplateField> <asp:TemplateField HeaderText="编号">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("ID") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="权限名">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("RightName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="备注">
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Eval("ReMark") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="操作">
<ItemTemplate>
<asp:ImageButton ID="imgEditBtn" Width="50" Height="20" CommandName="imgEdit" CommandArgument='<%#Eval("ID") %>' CausesValidation="false" ImageUrl="~/Web/images/Edit.gif" runat="server" />
<asp:ImageButton ID="imgDeleteBtn" Width="50" Height="20" CommandName="imgDelete" OnClientClick="return confirm('是否确定删除？');" CommandArgument='<%#Eval("ID") %>' ImageUrl="~/Web/images/Delete.gif" runat="server" /> </ItemTemplate>
<FooterTemplate>
<asp:LinkButton ID="lb_delete" runat="server" CommandName="DeleteChecked" Text="删除选中" OnClientClick="return confirm('是否确定删除？');"></asp:LinkButton>
</FooterTemplate>
<FooterStyle Width="150px" HorizontalAlign="Center" />
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td>
<webdiyer:AspNetPager ID="AspNetPager1" CssClass="paginator"
CurrentPageButtonClass="cpb" runat="server"
onpagechanged="AspNetPager1_PageChanged">
</webdiyer:AspNetPager>
</td>
</tr>
</table> </contenttemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>
权限的添加和修改的存储过程：
ALTER PROCEDURE [dbo].[tbRight_ADD]
@RightName nvarchar(50),
@ReMark nvarchar(50) AS
INSERT INTO [tbRight](
[RightName],[ReMark]
)VALUES(
@RightName,@ReMark
) --------修改-----
ALTER PROCEDURE [dbo].[tbRight_Update]
@ID int,
@RightName nvarchar(50),
@ReMark nvarchar(50)
AS
UPDATE [tbRight] SET
[RightName] = @RightName,[ReMark] = @ReMark
WHERE ID=@ID
-- Description: 根据权限id获取权限信息
-- =============================================
ALTER PROCEDURE [dbo].[getRightById]
@id int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT
ID,
RightName,
ReMark
FROM
tbRight
WHERE ID=@id
END
权限查询：
所需组件：Gridview，AspNetPager
调用分页业务方法实现分页查询
权限添加和修改：
使用Ajax组件
ModalPopupExtender
相关属性：
TargetControlID：设置触发事件的控件（如按钮）
PopupControlID：设置要显示的面板
BLL层的代码：
public class UserManagerBLL
{
/// <summary>
/// 添加员工信息
/// </summary>
/// <param name="user">user</param>
public int UserMangerAdd(UserManager user)
{
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@LoginName",user.LoginName),
new SqlParameter("@UserName",user.UserName),
new SqlParameter("@Password",user.Password),
new SqlParameter("@DepartmentId",user.DepartmentId),
new SqlParameter("@RoleId",user.RoleId),
new SqlParameter("@Birthday",user.Birthday),
new SqlParameter("@Mobile",user.Mobile),
new SqlParameter("@Email",user.Email),
new SqlParameter("@Photo",user.Photo),
new SqlParameter("@Address",user.Address),
new SqlParameter("@LastLoginDate",user.LastLoginDate),
new SqlParameter("@Sex",user.Sex),
new SqlParameter("@DisplayOrder",user.DisplayOrder),
new SqlParameter("@Sate",user.Sate)
}; return DataBaseHelper.ExcuteSqlReturnInt("UserManager_ADD", CommandType.StoredProcedure, pars);
} /// <summary>
/// 员工修改
/// </summary>
/// <param name="user">员工对象</param>
/// <returns>int</returns>
public int UserManagerUpdate(UserManager user)
{
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@UserId",user.UserId),
new SqlParameter("@LoginName",user.LoginName),
new SqlParameter("@UserName",user.UserName),
new SqlParameter("@Password",user.Password),
new SqlParameter("@DepartmentId",user.DepartmentId),
new SqlParameter("@RoleId",user.RoleId),
new SqlParameter("@Birthday",user.Birthday),
new SqlParameter("@Mobile",user.Mobile),
new SqlParameter("@Email",user.Email),
new SqlParameter("@Photo",user.Photo),
new SqlParameter("@Address",user.Address),
new SqlParameter("@LastLoginDate",user.LastLoginDate),
new SqlParameter("@Sex",user.Sex),
new SqlParameter("@DisplayOrder",user.DisplayOrder),
new SqlParameter("@Sate",user.Sate)
}; return DataBaseHelper.ExcuteSqlReturnInt("UserManager_Update", CommandType.StoredProcedure, pars); } /// <summary>
/// 根据指定ID返回其对象
/// </summary>
/// <param name="id">userid</param>
/// <returns>UserManager</returns>
public UserManager getuserbyId(string id)
{
UserManager user = new UserManager();
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@userid",id)
};
SqlDataReader reader = DataBaseHelper.SelectSQLReturnReader("getUserByid", CommandType.StoredProcedure, pars);
while (reader.Read())
{
user.LoginName = reader["LoginName"].ToString();
user.UserName = reader["UserName"].ToString();
user.DepartmentId =int.Parse(reader["DepartmentId"].ToString());
user.RoleId = int.Parse(reader["RoleId"].ToString());
user.Birthday =Convert.ToDateTime(reader["Birthday"].ToString());
user.Mobile = reader["Mobile"].ToString();
user.Email = reader["Email"].ToString();
user.Photo = reader["Photo"].ToString();
user.Address = reader["Address"].ToString();
user.LastLoginDate = Convert.ToDateTime(reader["LastLoginDate"].ToString());
user.Sex = reader["Sex"].ToString() == "True" ? true : false;
user.DisplayOrder =int.Parse( reader["DisplayOrder"].ToString());
user.Sate = reader["Sate"].ToString() == "True" ? true : false;
}
reader.Close(); return user; }
}
后台代码的实现：
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
pagebind();
}
} public static int pageindex = 0;
public static int pagesize = 10;
public static string condition = "";
protected void pagebind()
{
this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("tbRight", condition);
this.AspNetPager1.PageSize = pagesize;
this.GridView1.DataSource = SqlComm.getDataByPageIndex("tbRight", "*", "ID", condition, pageindex, pagesize);
this.GridView1.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
tbRight right = new tbRight();
UserRightMangerBLL rightbll = new UserRightMangerBLL();
right.RightName = this.txtRightName0.Text;
right.ReMark = this.txtReMark0.Text;
if (rightbll.UserRightAdd(right) == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('提交失败')", true);
}
else
{
pagebind(); } } protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
pageindex = this.AspNetPager1.CurrentPageIndex - 1;
pagebind();
}
public static tbRight right1;
public static UserRightMangerBLL userrightbll;
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "imgEdit")//编辑
{
string id = e.CommandArgument.ToString();
userrightbll = new UserRightMangerBLL();
right1 = new tbRight();
right1= userrightbll.getUserRightByID(id);
this.txtRightName1.Text = right1.RightName;
this.txtReMark1.Text = right1.ReMark;
this.Modal_Update.Show();
} if (e.CommandName == "imgDelete")//删除单条记录
{
if (SqlComm.DeleteTableByCondition("dbo.tbRight", " where id='" + e.CommandArgument.ToString() + "'"))
{
pagebind();
}
} if (e.CommandName == "allcheck") //全选
{
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
((CheckBox)this.GridView1.Rows[i].FindControl("check_all")).Checked = true;
}
} if (e.CommandName == "recheck") //反选
{
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
if (((CheckBox)this.GridView1.Rows[i].FindControl("check_all")).Checked == true)
{
((CheckBox)this.GridView1.Rows[i].FindControl("check_all")).Checked = false;
}
else
{
((CheckBox)this.GridView1.Rows[i].FindControl("check_all")).Checked = true;
} }
} if (e.CommandName == "DeleteChecked")//删除选中的
{ for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
if (((CheckBox)this.GridView1.Rows[i].FindControl("check_all")).Checked == true)
{
SqlComm.DeleteTableByCondition("tbRight", "where ID=" + this.GridView1.DataKeys[i].Value.ToString());
}
} pagebind(); }
} protected void btnUpdate_Click(object sender, EventArgs e)
{
right1.RightName = this.txtRightName1.Text;
right1.ReMark = this.txtReMark1.Text; if (userrightbll.UserRightUpdate(right1) != 0)
{
pagebind();
//ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('提交成功')", true);
} }
权限的设置：
界面的代码：
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="UserRightSet.aspx.cs" Inherits="BioErpWeb.HRSystem.UserRightSet" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link href="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />
<style type="text/css">
input{ width:60px; }
</style>
<script src="../JS/CheckUserName.js" type="text/javascript"></script>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="maintable">
<tr>
<td class="titlebar"><span>员工权限设置</span></td>
</tr>
<tr>
<td >
<asp:Label ID="lbUser" runat="server" Text="员工姓名"></asp:Label>
<asp:TextBox ID="txtUserName"
runat="server" ontextchanged="txtUserName_TextChanged"></asp:TextBox><asp:Button ID="btnCheckUser" Width="50px" runat="server" Text="选择" OnClientClick="showDialog()" />
</td>
</tr>
<tr>
<td>
<asp:CheckBoxList ID="cblRightList" RepeatLayout="Flow" RepeatDirection="Horizontal" runat="server">
</asp:CheckBoxList>
</td>
</tr>
<tr>
<td class="bottomtd">
<asp:Button ID="btnSave" Width="150" runat="server" Text="保存员工权限信息"
onclick="btnSave_Click" />
</td>
</tr> </table>
</div>
</form>
</body>
</html>
BLL层的代码：
/// <summary>
/// 根据编号获取权限信息
/// </summary>
/// <param name="id">id</param>
/// <returns>tbRight</returns>
public tbRight getUserRightByID(string id)
{
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@id",int.Parse(id))
}; tbRight right = new tbRight();
SqlDataReader reader= DataBaseHelper.SelectSQLReturnReader("getRightById", CommandType.StoredProcedure, pars);
if (reader.Read())
{
right.ID = int.Parse(id);
right.RightName = reader["RightName"].ToString();
right.ReMark = reader["ReMark"].ToString(); }
reader.Close();
return right; } /// <summary>
/// 给用户添加权限
/// </summary>
/// <param name="tbuserright">权限值</param>
/// <returns>int</returns>
public int addtbUserRight(tbUserRight tbuserright)
{
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@RightID",tbuserright.RightID),
new SqlParameter("@UserID",tbuserright.UserID)
};
return DataBaseHelper.ExcuteSqlReturnInt("tbUserRight_Add", CommandType.StoredProcedure, pars);
}
UI层的代码：
public partial class UserRightSet : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
RightListBind();
}
} public void RightListBind()
{
this.cblRightList.DataSource= SqlComm.GetDataByTableName("tbRight").Tables[0];
this.cblRightList.DataTextField = "RightName";
this.cblRightList.DataValueField = "ID";
this.cblRightList.DataBind();
} protected void txtUserName_TextChanged(object sender, EventArgs e)
{
if (txtUserName.Text != "请选择")
{
DataTable dt = SqlComm.GetDataByCondition("tbUserRight", "ID,UserID,RightID", " userid=" + this.txtUserName.Text.Trim()).Tables[0]; //每次重新选择用户后复选框列表中的数据重新设为Flase
CheckBoxListReset(); //重新绑定选中员工的权限至列表
for (int j = 0; j < dt.Rows.Count; j++)
{
for (int i = 0; i < cblRightList.Items.Count; i++)
{ if (cblRightList.Items[i].Value == dt.Rows[j]["RightID"].ToString())
{ cblRightList.Items[i].Selected = true; } }
}
}
}
/// <summary>
/// 重置复选框列表
/// </summary>
private void CheckBoxListReset()
{
for (int i = 0; i < cblRightList.Items.Count; i++)
{ cblRightList.Items[i].Selected = false;
}
} protected void btnSave_Click(object sender, EventArgs e)
{
if (this.txtUserName.Text.Trim() == "" || this.txtUserName.Text.Trim().Length == 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "test", "<script>alert('请先选择要设置权限的用户')</script>");
return; } //删除指定用户的所有权限
DeleteUserRight(this.txtUserName.Text.Trim()); //通过循环遍历给指定用户添加相应权限值
for (int i = 0; i < cblRightList.Items.Count; i++)
{
if (cblRightList.Items[i].Selected)
{
AddUserRight(int.Parse(cblRightList.Items[i].Value.ToString()),int.Parse(this.txtUserName.Text.Trim()));
}
}
CheckBoxListReset();
//清空值
this.txtUserName.Text = ""; }
/// <summary>
/// 根据ＩＤ删除指定员工权限信息
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
private bool DeleteUserRight(string userid)
{
return SqlComm.DeleteTableByCondition("tbUserRight", " where UserID=" + userid); } /// <summary>
/// 给用户添加一个权限信息
/// </summary>
/// <param name="tbuserright">权限信息对象</param>
/// <returns></returns>
private int AddUserRight(int rightid,int userid)
{
UserRightMangerBLL userightbll = new UserRightMangerBLL();
//给用户权限对象赋值
tbUserRight tbuserright = new tbUserRight();
tbuserright.RightID = rightid;
tbuserright.UserID = userid;
//调用相应的业务方法实现给用户添加权限
return userightbll.addtbUserRight(tbuserright);
} }
添加权限的存储过程：
-- Description: 给用户添加一条权限信息
-- =============================================
ALTER PROCEDURE [dbo].[tbUserRight_Add]
@UserID int,
@RightID int
AS
BEGIN SET NOCOUNT ON;
INSERT tbUserRight
(
UserID,
RightID
)
VALUES
(
@UserID,
@RightID
) END
效果：
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA1gAAACRCAIAAABR8o4eAAAPrElEQVR4nO3dwYsj150HcDHJ4qwdNmHxbHxcnNMuwTiEveWwezAmGMxedy+5eU8hJ9+GQAi55LI4EIMvuYTGPT05uWkL920yHXoIHQcnzpjMRgMOEx9E8jdkD21rpKr3fvVULbWq9D6PD4NUeipV/X5V0pdSd8/kxo2n+/ncjS9syRe+/NWnb/7rF7/ywjPPvfDMcy88/ey/PPUP//x3f//c55/6xxuf+9KNG1/svc12BwAYoH4f90899eVnnvmnq5j8zTAMwzAMw6hyCIKGYRiGYRiVjsns8Xwb/vfOXQAANmjjgU0QBAAYB0EQAKBSgiAAQKUEQQCASgmCAACVEgQBAColCAIAVEoQBAColCAIAFApQRDYS2++MgnGa9+96pqvsobea4t36uq7BlRHEAT2Ui5gtZevm64Wa0g+8XLmykOv/DCY2dik9szgpZef0lgIUEQQBPZSeRC8yoTw9r997/t33nzlSRBcrDO4m7vdmCkIApshCAJ7qfdXw3GCXBmrCa93EMy9+tUvXgJ0EAQBlm3wiuA3v7Zyra4kscVBcN1NBeggCAL75ypXzuJ0tVjz5YS1guBinamfMvzs8mHmEuDyS/TbL4AEQRDYPyVh7iqPNsNZ+svftX5G8Elq3NRuAnQTBIH9s6UguJTqVq/2lQXB3KW7lcldF/m292dxgBoJgsD+Kf8t3c7nNh/qHwQXUe+/38z8ZknJpvb+bWiABEEQ2D/bCIKrP9j3aW7LPSUOgq9lUuPdREBsbokgCGySIAjsn8K/xtf53PyEkiD45Ova4JrfYoXxJcbOXRMEgT4EQWCPtX8/97Xvlj4lnPAkCK736yCphNfeth5/aFAQBPoQBIG9lEx+uchVMlaf0vFNbjIXxo8uP7T8+yXL21/+igBFBEFgz3Re/LtiZmr8ku/yehoXIBcPlXw93Zlce2RWgA6CIABApQRBAIBKCYIAAJUSBAEAKiUIAgBUShAEAKiUIAgAUClBEACgUoIgAEClBEEAgEqNKQhuac0AABUSBDfpwtjo2HlDAWC/CYKbdHFx8bcRjk9T18CGIAgA2yYIbpIguMEhCALAtgmCm1RDEJxMJp1LlpdPWkMQBICBGGsQbMeLyaTP6zaeFaykZP01BMHl5LeIeiXT2rcFQQDYrREHweartiJdbsTPyu6VIJiKesGlvnb+K0+BgiAAXIMRB8HyK4IlD13eyM0sfLmqgmDygl87ICZzoSAIAEMw1iC43galQlsj0pVfNQwW7n0QTF78yyU8VwQBYOBGGQST1+eCi4Lx8va/uTmdK9z7INhIdYn6Z6a17wqCALBzYw2C6RfuGwQXE3Izk5PbqgqCjbSXnOarYQAYstEHwdztlQ0quCIYz5x1RcBLguByBFwsDK4aCoIAsEP1BsHGVcDgK+bkd6DJXFhbEGzcSH41nLsrCALAztUbBGcFVwQXaS+OkgtVBcHkVcDktESAFgQBYABGGQSfvFLBz+3Nur7wLZkpCMYpMJiZuysIAsDOjTUI5r7ATW/QlX9G0FfD7TAXX+rLXSAUBAFgOMYXBOPrf8vXCIMxa+W/OOS5Inj9QxAEgG0bXxAcMkFwg0MQBIBtEwQ3SRDc4BAEAWDbBMFNujA2OnbeUADYb4IgAEClRhYEAQDYoDEFwS2tGQCgQoIgAEClBEEAgEoJggAAlRIE5x9/Mr93dnZycvJOa5ycnJyd/fLjT3bfpwrpy8Bp0MBpkMLWSYPWJQjO7907Oz8//2tm3L9//+4v7u28TxXSl4HToIHTIIWtkwatSxCcHx8f/yUcx8fHO+9ThfRl4DRo4DRIYeukQesSBOdHR0d/DsfR0dHO+5Qu9NK4vLtYnpzTmN9Y1VovFKxqz/pSsoO5OY3l5UVu11aDrtKg3DQN2mF3JqvvWoU9UtjCOnfufo8JGjSQRvR7oYAgOD84OHgUjoODg63s0ftvvbR6Vrz+zsrCZ7/6n6/fuVidefP5f//2j977U7PiS2+pJUdD7hiatEZjfuF797j70lWrZKFydYvfBBu3k9XWoM7u9OiRBl1ng5K3gyolW6ywyQokdzY45ttPCWrryO/Ro3hJu0rx8d+5PNnrdWsrCO42CH7rjfezCx+c//ilyX/86Hxl4W/u3Hrx5rd/+vvonGwvXOtNIVhYycmcrEzwUEn1cmd7sJKSztbcoHg3O3dcg7b6cVj4ntNZCoVN7lHuKL1iYZNPbyzsPEFqbtDiUM8d/7lOtauaGyWHx7oEweEGwdnjizdevvn6e42FH77x8uS/fvZ/s/ypVf4ROFs94JJra6+28Lgca1/ytWo/FJylwZmcfF/IzdGgwr5MWu+kcRM1aCCXbHM1UdigmO0Stfe3c3myO0Hd2jM1qLNEhU0M1pO7nWxEv8IKgsMNgr+5c+vFr986/mM7HU7+553Par36djBrHTTxWJ7ZuNFeGM/Zn76sKtnB3MlZ8pSSGxrUKF1up5Yf6jzyNeh6vsEsedtR2MLCtnc5V8lGKdrVSB7P7dMn11ANihuU28d2E5N1yK0k2ayr11MQHM7PCN76+erC51/+wc9/v5h5GQT/dP9n33nx5ncO/jif5RvfY3nhW3DJgT76vrQqljtRc6NzWvvRoNoalGtNUPZkcQrXo0GbbVNJ2RW2vJjJPe2sWOOhZA1zvYtPLg3KNSj5xlIyJ/dQsoOd00oIgvPDw8P4oDk8PNzKHsVXBN/7weXPAn628HLcfP7VWz897zgIZplzOLjdOARzk5MvuqV276wvS9qlCKa1byefm5tQ8qagQevWOXkiaND1nEFxxYIeKWyunrkiJHc2rsDiWXGPOvuoQY2SLhe2pInJyckaxrUt7HuSIDifTqenp6e5I+b09PTd6XQre9T11fDdn3zr2VffupubeVnrro+xWesMnKUOppIls8yBu6XzeWd9SVWyfabFI565Vgc1qLM7QRlL6q9BW2pQsF/JgsdVUthgHzvfc5ITkmtonDjJMmpQZ5vajcjVIVnkZA2D2uZ6XUgQnH/w4OG70+nt27ffbo2jo6PpdPrbBw+3skclvyzy6s2XfnIRB8GSgyA44JYndN7tPHz3oS+pIsS7GczsrE9wMpevtsIGdda5sBEatL3udL47xVVS2FxV2/vY4/gPStee4Mhfq01rVTt32OdGbp1BrzsJgvOPHj1+/8OHv/rgQdKvf/eHjx493soeZf+O4FLmO3/rlZvfuPV2NgjOCvJK+3CJ3zWS7wjLh2Cwnn3oS0GJZmUnajCtMSF+aQ0KCpLc8bhBJdM06Oqt6ezaclnaBVTYzhoGNe88aDuLFhRTg3KtaexsuyBBActPgfYTc29fhQTBfRAcbcExVH4stt8grud83m09r74891D7nWKtp2hQZ5WSNdGgnQuaUvJpp7AlwaJkQruGuQzXuTYN6uxFsjvJN5nOt7Xkmgvf6wKC4FhNukZyfrC2Wf6Ej4+zPTuf493pUdjy7gTTNKiwtkGbNGjnzQrqmZymsLndaRczKELueI6fnjubHPnlbQqqGpSuZIXBOntUVRAEAKiUIAgAUClBEACgUoIgAEClBMH5x5/M752dnZycvNMaJycnZ2e//PiT3fdpjBRWYQEYOEFwfu/e2fn5+V8z4/79+3d/cW/nfRojhVVYAAZOEJwfHx//JRzHx8c779MYKazCAjBwguD86Ojoz+E4Ojq6nmYEf8ZseU7nSkoWXsMfcNptYTv/GlZ7YVwThW0UM/cX9daq/6AKC1AhQXB+cHCQ+9+pL8fBwcGW9ij+KE1OuOIfn2x/fvf7+5MDL+ysK4j0qIPCNvY3KM6kFa+DUgynsAAVEgR3/LH6ackKLpYkPxcXD637eXkNH6W7Tdi5ysQVVtjyCucKEt8dcmEBKiQIDiKv5G5Plq6mtD8mG9Pi28sLCz9696yw7eo1itCeqbAlFW5XrPDAHlphASokCA7ii7bckkYQbEwo/1gNQuT27Kqwy8EuOeJGlGSUmgubq227CMnJQy4sQIUEwUFcX5mFPzJfEgQ7Q0+PbDTewpbsUWE6VNhkbRvHZHB7RIUFqJAgOD88PIw/Vg8PD7fxusFn4eKjLvfvYg2NGyW3Gx+i2/tM3VVhZ2FELnyiwsYlaux1oyCFIW9ohQWokCA4n06np6enuc/U09PTd6fTbbchF1PiONg7CK6VjcZY2M4MESfv8mLWVthZeBz2KNqgCgtQIUFw/sGDh+9Op7dv3367NY6OjqbT6W8fPNxqDzo/Uxv/tlNLMtY0PjI7s9E+FbY8Q8TVUNhcbXNFKL89wMICVEgQnH/06PH7Hz781QcPkn79uz989Ojx9hrQ/rTrDCuz1Wg4W/NjuDMb7UFhSzLEcg3b/ypsXNuScJaMjEMuLECFBMGdia+pNKJM8EFbsnB5nTVcX+nMEMkbQakVdnmnOnetHdeCAKewADskCA5FZ6rLJcWS9cxS0Sdez6gldzZ5N1cWhY0r0E7Yi9AW7LjCAgyNIAgAUClBEACgUiMLggAAbNCYguCW1gwAUCFBEACqdmGMfFyl+4IgAFTt4uJiZox2CIIAQH+C4KiHIAgA9LfZIDiZTDY1M/0nS7e5bY0X6nzp5YUlK19/k7uHIAgA9LeNIFiS3nokp1way42SbUuGucXMzpfe4Ob1G4IgANDfBoNgI0glb8ejsbZ1w1M8oWTzlm/EQTAXK3Phcq1NLR+CIADQ33UGwXjhBjegvXw5osVBcHkvggxauAuFqbf3EAQBgP42FQSXw01hhAqm9ctPhY+WB8HcmoOdbc/ssanlQxAEAPrbSBCctK60te8Gy8uvt/UOgo3olnxKY0IQBDu3pPG66yba8iEIAgD9bfyr4Tj0FF4z68xqwQbkHmpnwdyWJHck91quCDYIggAwGtv4GcHk3dlq/OrMi523Ozcg+bq5JbNUEGwvLNyS5Wm5UfL0ziEIAgD9bSkIBnFnJ1cES143CIK9rwiWb16/IQgCAP1t77eGOyNU8m5ycuEltPIgmLsiuPxCuWuB8aPJu4Xr7DEEQQCgv238jODy3VlZVEquLRnUOjeg89HCy43JUJhcW3BFMJc4O7e2cAiCAEB/1/kzgu3lyWxX/gVrO4Stm8lmfQNrybOCTU1uSY8hCAIA/W32v5gzrnkIggBAf4LgqIcgCAD0JwiOegiCAEB/F8bIx1W6LwgCAFRqZEEQAIANGk0QBABg4ARBAIBKCYIAAJUSBAEAKiUIAgBUShAEAKiUIAgAUClBEACgUoIgAEClBEEAgEoJggAAlRIEAQAqJQgCAFRKEAQAqJQgCABQKUEQAKBSgiAAQKUEQQCASgmCAACVEgQBAColCAIAVEoQBAColCAIAFCp/weqasBzs9Jp+AAAAABJRU5ErkJggg==" alt="" />