ERP仓库管理系统（九）

需求分析：

　　1.设计库房表，至少包括两个字段，库房名称，库房所属公司的ID（在客户资质审批表中找到对应公司的ID）

2.设计增、删、改、查一套程序，其中的删除要做限制，只要有库存数据存在则不允许删除对应库房的记录。

3.库房管理权限为高级权限，程序开发开始后，到配一个新的权限值。

新增的原理：

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUAAAADoCAIAAAARyqrKAAAgAElEQVR4nO2c+XMb55nn5w+ISHSjT4CRHWc2cXmmJpXsMZtJZTOZndmqyc5kNjPxTDm+4iOO7eiyY/mQrfugRJHiDRIEwBsgiYs4ed/gLfGAJOqWEzsHQ5bHK2jLmYA4en9gGYW8ALpfEuILoer51qdQb7/9vG8/3ehPlfQD8ScSBALJ2/xJrhuAQCDbDwgMgeRxQGAIJI8DAkMgeRwQGALJ44DAEEgeh6jA8Xg8Go2WL96tu/3JkSu/AwCEt2fvdK38MhaLxeNxkm9m/oacwPF4fGNj40nn5DcX1v/tvvTcHwAA5Z8+2fjLmd992+Tf2NgAh3FCSOB4PB4Oh7/f4v+y78Z/vxP7/n3pn38PACjf+1T61u3YEz03v1/ZEg6HwWHFEBI4Go3eu3dPrHDsHvzoscD614L/8Zc3ogDwR9yMfv3KH7469UmR57p674mVW7djsRiZ9zN/Q0jgSCRiHJrkqt1894rou1XU/8tHhn4FAH/E8K92D34kuFa4zovU/jP1Tc2RSITM+5m/ISTwxsZGw8AEW+Xm7EHBfU3jv6Pt/RAAEDS+24LjMmuZow6c1ZkaNzY2yLyf+RvCArs4+7Lgvqbx39b23gUABI3vluAIspZZ6kAxCIwTogJzlS7etiy6VrS+20U9dwEAQeu9KdqDnHmW2g8CY4WwwN28bUl0XdX6bhX13AEABK33pmhf5swz1P4zIDBOSAo8zlU4eeui6Lyi9d4o8t8GAASt57poW+Tapql9IDBWCArcP86VO/jOS6LjstZzvch7EwAQtO5rYtcC1zpF7TsFAuMkFwLbg1r3tZy/K8BDiNa1InZd4lomQWDMEBWYLbNzlnnBtqx1rWjd1wEAQdN9Vei4yDYHqD0ndUYQWDkkBR5jS62ceU6wLmqcV7Sua/mLJEkEVuHUp9Zsr7eHBI3jsmCZY5vGqT0nQGCcEBa4i2ufEbouaZyXtd1X8xdJkpLHSDAXbukq+M3k/OFkg8YRFMyzbOMY9bPjIDBOCArcN8aUdLJt03zHRdG+rHFezl8kSUo7Tj2FE/z61DYwK/MF0bbEt08zxhHV68dAYJyQFHiUKbGwrZO8ZU60LWkcy/kIcl+pM5uTD+pa+AWZxvmFaF3k26YY47Dq9aMgME7ICnzOzLYEePOsaF3Q2JfyF0mS0o5TDzNNpi3bnM8U/DYybf7wI3Zd4lsDjGFQ9doREBgnBAXuHWXOtrNN43z7tNh5SWNdyF8kSUoeI5EpxpnfUkGm5PwRbQ+x4yLfPMHoB1SvHtYZTSCwYkgKPMIUt7FNY3zblNg5r7Feyl8kSUp84lTinMV8kjLLMS/6MCN2zPHNY4y+DwTGDFGB1WdaGNMI1xIQLLNi53z+snlTiUFqUusVZ9IWyJcln800zi8E8wzXOMrU9ap++gEIjBOyAp9uYYzDXPOEYJ4RO+bykcQdpT0lvxCzMrlAfpXMA8/5g9oeQvs0ZxpR63oKX3kfBMYJOYH1PSPqU82MYYhrGhfap0XLbP4iSVLqOHlSZhVOWer+mJvnO0LbFGccVtf6C39yCATGCUmBh+mTjeqGQbZxjG+bEswz+YskSanjxM1iLpQpQMoUV2HWPPzwrQHWMEjXeAtffg8ExglZgU+Y1PX9rHGEbwkIbVP5iyRJqePkSZlVmco2H1SmSmQV5mPP+YPaKnzzBKsfoKs8hS+9CwLjhKzAx4zqul7WMMQ3TQgtk/mLJEnJg+TPTPXJZ5FDxXqcVfIb5gt84xhb30dXugtffAcExglBgf1D9FGDuraH1Q/yjWNC00Q+krijzXHqfOIsUiy/VeqpbTSW84eTPbxplNX10uXdIDBmyAp8RK+u9bH6ft40KjSNAwACbxxmdX663Fn4wkEQGCdkBT5cT1d7mbo+zjjMm0YBAIEzDDE1PrrMXvDjt3QGEFg5JAUepA/X0VVuRtfDGQZ54wgAIHD6AabaQ5XaCp4HgbFCUGDfIP2Bjq50MbV+rmGANwwBAAKn72eq3FSpteD5n4PAOCEr8KEautzJ1Hi5+j6+YQAAELi6XqaymyrpLHjuTRAYJyQFHqAPVdPlDqbaw9X18vo+AEDgdD1MhZM611Hw3AEQGCcEBfYOUO9V0WU2psrF6fx8fS8AILC1PvUFO3XWXPAsCIwVsgK/W0mVWtUV3Wytj9P5AQCBrfGoy2yq4vaCZ/aDwDghKXA/9U45db5TXeFgazyczgcACGy1W13apTrTWvD0XhAYJ0QFVr19QVXSQV+wM9UutsYDAAhMZTd9vlN1umXXj/bqDEYQWDEEBfb0q94qU5210GU2prKbrXYDAAJT4aRLOgpPNu96ag8IjBNyAnun5lVvnlcVt9PnrUy5k610AQACU2ani82Fxxt3/eurnt4+EFgx5AReuH6TeqNEdcxEn2rhSzrEMisAIKjPtKmOGgveq/3C//yBx+cHgRVDTuDV1dXvljYxh3XCceMXi1t3n2sHAATxZCP1XnXBa0e//L0frq6ugsCKISRwJBJZX193DY+Lp5u1JwyPnDA8dtoEAAiPHNezb5z906dfNbRZ1tfXI5EImfczf0NI4Fgsdv/+/WAwaPH1vdzQ+Z3zpr841QAACH92tOalUp3F0R0MBkOhUDQaJfN+5m8ICRyPxzf/FR0MBgOBwAjk8zx2rP6xY/W57uIhSiAQCAaDm/9+jsfjZN7P/A0hgSVJisfj4XA4FAqtra2tQj7PpsC57uIhytraWigUCofDYC9OyAksSVI8Ho/FYpFIZAPyeTYFznUXD1EikUg0GgV7MUNUYEhqNgXOdReQfA0InOOAwJBsAgLnOCAwJJuAwDkOCAzJJiBwjgMCQ7IJCJzjgMCQbAIC5zggMCSbgMA5DggMySYgcI4DAkOyCQic44DAkGwCAuc4IDAkm4DAOQ4IDMkmIHCOAwJDsgnpv0b66P/ef+/iL74xdPubM78GAIS/D3z09tSNjz4NwV8jYYbo3wNP3PrlI/q+79z9/bNx6UUJAFCe/H38f9z47G/t0xM37oLDOCH3ixzhcPifOoa+PPjLr1/9w9+uSd/7dwBA+ZvfSP/12sZXBn7xjaNV8Df9OCEkcDQavXfvnljVre39cPfwr78y8+lfLH0GAMl8ben3f3bp/31p5NeC8wq999TKzVuxWIzM+5m/IferlMahSbbKzTsui57r2p67RX2/AAAErf+O4LzCWeap/cX1jc3wq5SKIfe70A0DE2yVm7MHBfc1jf+OtvdDAEDQ+G4LjsusZY46cFZnatyA34VWCmGBXZx9WXCtaP23tb13AQDFd0twBDnzLHWgGATGCVGBuUoXb1sSXSta362injsAgKD13hTty5x5ltoPAmOFsMDdvG1J7L6q9d3M+bsCPIRovTdE+zLXPkPtPwMC44SkwONchZPvWhCdV7TeG0W+WwCAoPVcF62LXNs0te80CIwTggL3j3PlDr7zkugIat3Xi7w3AQBB67omdi1wrZPUvlMgME4IC2znOy6K9qDWfa3IcwMAELSuFbHzEtcySe09pTOCwMohKjBbZuMs84J1SdN9Veu+DgAIGucVoWOebZqg9pwEgXFCUuAxttTKmWcF66LGeUXrWsk5kiRtoybTKpzdFBfKbLKN/be0ZNv9P0A0jsuCZY5tGqf2nACBcUJQ4L4x9nwn1z4jdF7SOILa7iu5RZKkxGems/IDmSWpSVuZephpc5yzWS7ZxuYPHI19mTfPsKZR1c+Og8A4ISowU9LBtk7xHfOibVnjCOYQSZLSjlNrkj9x6tMWyM/gbI5zdrNAMfjF5L8X0bbEt00zxhHV68dAYJyQFHiUKbGwrZO8ZU60LWocy7lCkiScmdSknko7g7l/pqsk74zTvMxZ+eIt7UwG0brAt00yxiHVa0dBYJyQFfismW2e4M0zYteCxraYEyRJwp9P9J9allqffCo1mC3JVyoWIGdxdsuUnHw7YtclviXANAyqXjsCAuOEoMC9o0xxG9s0zrdNi50XNdYFwmx2gl+wOU7+TDtA6pFT8lfcaj3SjEyBTHDayBVixzzfPM7o+1WvHtYZTSCwYkgKPMIUt7KNo3zbpNgxr+m6mCvSdphakzrYHCd/yi/JVIZcUb4+9RIyNVvaCieEvxrRMss3jTH1faqffgAC44SowOrTLYxphGsJCJZZsXM+V0iSpDgjM785mXaTxKm0SbsJTnFqM4oN4xTj3BRhBPMM1ziiruspfOV9EBgnxAU2DnPNE4J5RuyYyxWSJOHMIEGKkZnkmtRi+R5w6re6baYvQnEVTic7h9A+zZlG1DoQGDfkBNb3jKhPNTGGIa5pXGifFi2zuUKSJMUZZD65YHMss0lqsXwPW62XqcSfTD6Lc3dkENomWeOQutZX+JNDIDBOSAo8TJ9oVOsH2MZRvnVSaJ/OFZIkJY+TD5GyxCmkJu0SpBh5AvI9yO+cdl6+B8VJpFXM+p2GbwmwDYN0tbfw5fdAYJyQFfi4SV3fxxqH+ZaA0DqVKyRJwp/f7B+zMvlUco3MDsgpmZ1x5hM9yCT1vpDOZa640/BN46y+n65yF770LgiME4IC+4fpY0a1rpdtGOKbxoXmQK6QJAlzfrN55FTqTNr51CWKO2ypW5mdt7RD8m0qTu40fOMYW9dHV7gKX3wHBMYJSYGH6KMN6lo/qx/gG8eEpokckqlPpABZkvhMnkF2y3SJ1FUybSTvjHMv8sWKm+BchQy8aYTV9dDl3YUvvA0C44SswEf06hofW9/Pm0aExjEAQOCNw2ytn77gKHzhoM4AAiuHrMCH6+lqD1PXyxmGeNMoACBwDYNMjZcqsxf8+C0QGCckBR6kD+voKjej6+EaBnnjMAAgcPoBptpDlVoLnv85CIwTggL7Bun3a+mKbqbWx+n7ecMQACBw9X1MlYs631Xw/JsgME7ICnyohi53MtVerr6P1/cDAAJX18tUdFMlnQXPvQEC44SkwAP0oWr6gp2pdnN1Pby+DwAQOJ2fqXBQ5ywFzx4AgXFCUGDvAPVuJVVmU1e6WJ2fq+sBAAS21qu+YKfOmgue2Q8C44SswO9UUKVd6gonW+PldH4AQGCrPeoyq6q4reCZfSAwTkgK3K96p5w636kud7A1bq7WCwAIbJVLXdqlOtO66+m9OoMRBFYMWYEPXlCds9AXbEyVi63xAAACU+mkz3cUnmre9aM9IDBOCArs6Ve9VaY6a6FLrUxFN1vlBgAEptxJn+soPNm86ykQGCvkBPZOzasOnFWdbqNLOtkLdq7CyVV0A0Ay6vNW6nRb4VHjF/7PC56eXhBYMeQEXrh+i36zRHVYz5xsEs+Ztec7AQCBOd2qOqwvOFjxhb/+x4XFRRBYMeQEXl1d/ZuKNv6oXnO8YfeZpkfPtgIAQtFJo/rdysIXDr567Mzq6ioIrBhCAkcikfX1ddfI+D/rOjQnTbuP6b900gAACLuP1rF7Tnzzxb2BQGB9fT0SiZB5P/M3hASOxWL3798PBoP9/f2GTttBg/nl2lYAQHipuulgZf3AwEAwGAyFQtFolMz7mb8hJHA8Ht/8V3QwGAwEAiOQz/N4lePxKkeuu3iIEggEgsHg5r+f4/E4mfczf0NIYEmS4vF4OBwOhUJra2urkM+zKXCuu3iIsra2FgqFwuEw2IsTcgJLkhSPx2OxWCQS2YB8nk2Bc93FQ5RIJBKNRsFezBAVGJKaTYFz3QUkXwMC5zggMCSbgMA5DggMySYgcI4DAkOyCQic44DAkGwCAuc4IDAkm4DAOQ4IDMkmIHCOAwJDsgkInOOAwJBsAgLnOCAwJJuAwDkOCAzJJiBwjgMCQ7JJDgT+OPTZzG8/nf1dCJj9XeirOt9Xdb6ct/GQMP2bT8i/kHkd0n+NVDZ15c+9V/7u5r3v/+o/AADh28uf/K+hm2UTS/DXSJgh+vfAlsXrX7LM/PVH0aci0rMxAED5l8+k7/4y8kTnzN5mBziME3K/yBEOh8XSzi8Nf/zEpfvf+jD+3V9LAIDwV3diX1v67Et9d79xvBb+ph8nhASORqNNI9N8lUv03dL2/eLRsdWvTH0CAH/E9L//p8n1ot67nG2J2neqb3QcfhNLMeR+ldIwGGCr3Jw9KLivafx3tL0fAgCCxn9bcFxmLXPUgbN1jU3wq5SKIfe70A0DEyAwII/Gd+tzgYt1psYN+F1opRAVmKty8bZl0bWi9d8u6rkLAAha3y3BHuTMsyAwZsgKXNnN25ZE11Wt71ZRzx0AQNB6b4r2Zc48Q+0/AwLjhLjA1kWx+6rWd7PIfxsAELTeG6JtiWsHgXFDUOD+ca7cwXctiI7LWs/1It8tAEDQuq+J1gWudYradxoExglxgTsviY6g1n29yHsTABC0rmti1wLXOkntOwUC44SswBfsfMdF0basda0UeW4AAIK2+6rQeZFrDlB7T+mMILByiArMltk485xgXdJ0X9W6rgEAgsZ5RbDMs00T1J6TIDBOSAo8xpZ2ceZZoWtB47ysda3khERLD3DD7RVse+GD2k1micxXuaPfjsYRFCyzbOMYtecECIwTggL3jTHnO9m2ab7zougIapxXdhRJkpLHiWQqVkzanRUPM01m6gQpUCzD3xOzse3NPyhE+zLfPsOaRlU/Ow4C44SkwKNMSQfbOsVb5kXbksYR3GkkSUIGipWYBcmHmcabhziRv1ym3ra0M/IoFNuQueiOfmWidZFvm2KMw6rXj4HAOCEr8DkL2xLgLbOibVFjX9ppJElCBoqV+AWpmytustW25dtDJuWvjjSpeAmZr3JHvzLRusC3TjKGIdVrR0FgnJAV+Gw72zzBt8+IXZc0tkVipG0JKchUqViguDPOdWVmMCszLUR62Op1CSN2XuRbJpiGAdWrR3RGEwisGIIC944wxW1s0xjfNiV2XtRYLxFDkiT5mcQh5jz+tdIept1280HJ74zUJyYzJVNvOMU5QeyY55vHGX2/6tXDIDBOyAp8ppVtHOVbJ8WOOU3XxZ0jcd3EYeIzeZBcn/aUzBKZSyseym+b9gHKXwinPcx6zC90h7440TLLNY4y9b2qn34AAuOEqMDq0y2McZhrmRDMs2LH3E4jSVLaQeJQplJ+HueiiUMkitvKtKfYW6Y+FbvC7GSnEczTnGlErespfOV9EBgnhAVuZozDXPOEYJ4h8DZI2K942kqZHeQjb47M5TJNKvYs30bqfKZPxYvuNEL7NGcaVuv8ha8cAoFxQk5gfc8IfbJJ3TC4+d9gwTyz00iSlHaQOExbiQQpwL+ozKH8tjLtbW8ytSa5jbTPROar3NGvjG+dZA1D6hpf4U9AYKyQFHiYPtGo1g+wphG+dVJon95pJElKfCYPkHHqYaat8C+afIgkU0tpd0gswWwJs8+039E27u6Bw7dMsA0DdLWn8OX3QGCckBX4uFFd18cah/nmCaF1cqeRJCntWPFQfqstVW7jupmulXat/GNP3SGxKu3nVu/ugcM3jbP1/XSlu/Cld0FgnBAU2D9EHzWodT1swyDfOC40B3YUSZISnzjFitlqZXIbmIcyk9msTW0s+eFs9UHt6LfGm0bZul66wlX44jsgME4IC9ygrvWz+gG+cVRoGt85JElKHmdK2nrFDbdUmThELpraA7Jqew1j9pnaJM4TwH8I24Y3jbC6HrrcWfjC2yAwTsgKfFivrvGy9X28cURoHAMABN4wxNT66AuOgh8f1BlAYOWQFHiQPlxHV3kYXS9nGOKNIwCAwDUMMtVeqsxe8OO3QGCckBX4Ax1d6WJ0fq5hgDcOAwACp+9nqt1UqbXg+Z+DwDghKLBvkH6/lq7oZmp8nL6fbxgEAASuvo+pdFHnuwqeexMExglJgQfoQ9V0uYOp9nD1vby+HwAQOF0PU+GkSjoKnnsDBMYJWYHfq6Iv2JkqN1fXw9f3AgACp/Mz5Q7qnKXg2QMgME4ICuwdoN6tpEqt6sputtbH1fUAAAJb41VfsKmK2wue2Q8C44SswO9UUKVd6gonW+PldD4AQGCr3eoyq6q4reCZfSAwTkgK3K96u5wq6VCX29lqN1frBQAEtspFl3aqTrfsenovCIwTsgIfLFOds9BlNqbKxVa7AQCBqXDSJR2Fp5p3/WiPzmAEgRVDUGBPv+qtMlWxmS61MhXdbJUbABCYcid9rqPwRNOup0BgrJAT2Dc9r9pfrDrZTBeb2VIrf8EBAAj0WQt1srnwcP0XvveUx98DAiuGnMCLN24xb5VSH9SxJ0zas+1FJRYAQOBONave1xUcOLfr23+/uroKAiuGkMCRSGRtbe2Ms1c4YdQeb3j0dONjxc0AgLD7hIF5u7zw3147UaVbX1+PRCJk3s/8DSGBo9FoKBRaXl4+2uUVTzVpj9TvPqYHAATtBzWPv3HqSE3D8vJyKBSKRqNk3s/8DSGB4/H4xsbG6upqMBgMBAL2/iG9pw/Qe/oer3I8XuXIeRsPCfWunkAgEAwGN//9HI/Hybyf+RtCAkuSFI/Hw+FwKBRaW1v7LeTzbAqc6y4eoqytrYVCoXA4DPbihJzAkiTF4/FYLBaJRDYgn2dT4Fx38RAlEolEo1GwFzNEBYakZlPgXHcBydeAwDkOCAzJJiBwjgMCQ7IJCJzjgMCQbAIC5zggMCSbgMA5DggMySYgcI4DAkOyCQic44DAkGwCAuc4IDAkm4DAOQ4IDMkmIHCOAwJDsgkInOOAwJBsAgLnOCAwJJuQ/mukaDRqvfGrmuurhxY/Bg4tfvyEOfCEOZDzNh4SyoMfTX68FovF4K+RMEP074E3NjZ+aBv/b7O/ffLT2DOfSQCA8A+r4f8y/qtvNbg24K/58ULuFznC4fBrztEve1b+6sP4Dz6TfvgHAPgjnvyD9A/3pG/fiT7hu/b9imb4m36ckPtNrHv37onl9t2DH/3p1Cdfvxr+5u0YACD855Xw4zOfftF7g9lzYuXW7VgsRub9zN+Q+1VK49AkX+0WXCsa/60vDnz06MhvAADhkaGPRfc1rvMStf9MfVMz/CqlYsj9LnTDwARb5ebsQcF9TeO/o+39EAAQNL7bguMya5mjDpzVmRo34HehlUJe4GXBfU3jv63tvQsACBrfLcERZC1z1IFiEBgnRAXmKl28bVl0rWh9t4t67gIAgtZ7U7QHOfMstR8Exgphgbt525Louqr13SrquQMACFrvTdG+zJlnqP1nQGCckBR4nKtw8tZFsfuK1nuzyH8bABC0nuuibYlrm6b2gcBYIShw/zhX7uA7L4mOy1rP9SLvTQBA0LqviV0LXOsUte80CIyTXAhsD2rd13L+rgAPIVrXiti1wLVMUvtOgcA4ISowe8HOWeYF27LWtaJ1XwcABE33VaHjItccoPae1BlBYOWQFHiMLbVy5jnBuqhxXtG6rskjSZLijPx89sVZrsJc/mD7x39u27iLTHlQT0/juCxY5tmmcWrPCRAYJ4QF7uLaZ4SuBY3zsrb7alokSVIcyCxJTabitPWZupK5Os515dfKF2TZSerk9m4B5/lvo2EEjSMomGfZxjHqZyAwVggK3DfGlHSybdN8x0XRvqxxXs6EJEnIZ/J8pvq0BfIzyFnkFE4UL4c/L1OD2Uba3TI9HGS5Yv2W7m6rzy2BaFvi26cZ04jq9WMgME5ICjzKlFjY1kneMifaljSO5bSkXZ56Ku1MYj55t0w7p71Wpq5wSO4q0yBTb/hlW2pSsXhLPct8v1m2kUC0LvJtU4xxGATGDFmBz5nZlgBvnhWtCxr7kgyJhckzyCDtqdRkKk7dKrVY/nIyk5uHOD1v9XKZFma6ffkHsqVHtyUwG0AQuy7xrQHGMKh67QgIjBOCAveOMmfb2aZxvn1a7LqksS5kQpIk5DPtAKlHTqWWpa1BIlMsM5/2lmUay7Rt2oLEVjKR71a+c8WBzD3KPDqcx5iK2HmRb55g9AOqVw/rjCYQWDEkBR5hitvYpjG+bUrsnNdYL6VFkqTUweY4+VN+Sdqy5PlMZ9Nui38W6SRtY8nFqZG/EGbbODsjp9I+9u09DcxXIu0+Yscc3zzG6PtAYMwQFVh9ppUxjXCtAcEyJ3bOyyBJUqbJ1FObl0gMUrPt4kyXw2w7cShzO5h3jZzF70G+Pnlzxee21e9L/ltLi2CZ4RpHmbpe1U8/AIFxQlbg0y2McZhrnhDMM2LHXFpS1yafSnwixckFqeO0xcipTP0obpu2Z6RVzIvKl2V6tjjNZLpBzB5S5+UP0zaP87SF9mnONKLW9RS+8j4IjBOyAp9qZgxDXPO40D4tWmZlkCQJGSTGyTOKxTI7Z1ooswqzDHN/mRvZ3iTmvWyjB5lbk28S5+tLRmib4ozD6lp/4U8OgcA4ISewvmeYPtmobhhkG8f4tinBPJOJzSWJMXIqbX3yALl0pmJkYdpixUtj1si3jdzyVtemfXppI/OoFevTPjfFGZyvLxm+NcAaBukab+HL74HAOCEr8AmTur6fNY3wLQGhbUqezYWpk2krk08l18jvkHZJpmYwyxLBbFtxPnFpmWxv2y11lfahZdoBebDy30gyfPMEqx+gqz2FL4HAWCEr8DGjuq6XNQzxTRNCy6QMm6s2B8mTyEza+dQlqcXIqtSy1E7SHiZPpj2VqQ2ZiyLzW1qLNINE/plj7owzue0lfOMYW99HV7oLX3wHBMYJQYH9Q/RRg7q2h20Y5BvHhKaJtGzWIzOJz+SZRDGyBLl06nzqbqn1qctTm8x0Fr8y0+NKvdPUhTJX3MYS+U4Ub3YbF00Lbxpldb10RTcIjBmyAh/Rq2t9rL6fN40KTeMAgMAbh1mdny53Fr5wEATGCVmBD9fT1V6mvo8zDvOmUQBA4AxDTI2PvuAo+PFBnQEEVg5JgQfpw3V0lZvR9XCGQd44AgAInH6AqfZQpbaC598CgXFCUGDfIP2Bjq50MTo/1zDAG4YAAIHT9zNVbqrUWvD8z7VWq9QAAAJHSURBVEFgnJAV+FANXe5karxcfR/fMAAACFxdL1PZTZV0Fjz3JgiME5ICD9CHqulyB1Pt4ep7eX0fACBwuh6mwkmVdBQ89wYIjBOiAlPvVdFlNqbKxen8fH0vACBwtT51uZ06ay549gAIjBOCAnsHqHcrqVKruqKbrfVxOj8AILA1HnWZTVXcXvDMfhAYJyQF7qfeKafOd6orHGyNh9P5AACBrXary7pUZ1oLnt4HAuOEqMCqty+oSjroC3am2s3WeAAAgansps93qk637Hp6r85gBIEVQ1bgt8pUZy10mY2p7Gar3QCAwFQ46ZKOwpPNu57aAwLjhJzA3ql51c9LVcVm+ryVKXeylS4AQGAuOOiz5sITjbv+9TVPbx8IrBhyAvtmLlIHzqmOm+hTLXxJh1hmA4BkhDIrfaZddcxYcKj2C3/3Lx6/HwRWDDmBF2/cfuJEPfOBjj9uLCpu3X2uHQAQhJON1KGagtePf/l/P7m6ugoCK4aQwJFIZH193TU8Lp5q0h43PHrS+NjpRgBAeOR4A/tmSeE/PmNot6yvr0ciETLvZ/6GkMCxWOz+/fvBYNDi6/1BreU75xu1R+oAAOHPj9W+XFZncXQHg8FQKBSNRsm8n/kbQgLH4/GNjY3V1dVgMBgIBEYgkAwJBALBYHDz38/xeJzM+5m/ISSwJEnxeDwcDodCobW1tVUIJEPW1tZCoVA4HAZ7cUJOYEmS4vF4LBaLRCIbEEiGRCKRaDQK9mKGqMAQCOTBBgSGQPI4IDAEksf5/4bnHPfJUWyGAAAAAElFTkSuQmCC" alt="" />

仓库管理员的新增和修改：

ALTER PROCEDURE [dbo].[BioErpStockUsers_ADD]

@StockID int,

@UserID int

 AS

	INSERT INTO [BioErpStockUsers](

	[StockID],[UserID]

	)VALUES(

	@StockID,@UserID

	)

ALTER PROCEDURE [dbo].[BioErpStockUsers_Update]

@ID int,

@StockID int,

@UserID int

 AS

	UPDATE [BioErpStockUsers] SET

	[StockID] = @StockID,[UserID] = @UserID

	WHERE ID=@ID

仓库信息的新增和修改存储过程：

--修改：删除了LeaderUserID字段，新增加@ID输出参数

------------------------------------

ALTER PROCEDURE [dbo].[BioErpStockTable_ADD]

--输出的参数

@ID int output,

@StockName nvarchar(80),

@FarhterCompany int,

@StockAddress nvarchar(100),

@IsDel bit

 AS

	INSERT INTO [BioErpStockTable](

	[StockName],[FarhterCompany],[StockAddress],[IsDel]

	)VALUES(

	@StockName,@FarhterCompany,@StockAddress,@IsDel

	)

	--赋值   @@为全局变量  获取当前表的最大表示列（与下面的是等效的）

 SET @ID=@@IDENTITY

-- SELECT @ID=MAX(ID) FROM BioErpStockTable

修改的存储过程：

ALTER PROCEDURE [dbo].[BioErpStockTable_Update]

@ID int,

@StockName nvarchar(80),

@FarhterCompany int,

@StockAddress nvarchar(100),

@IsDel bit

 AS

	UPDATE [BioErpStockTable] SET

	[StockName] = @StockName,[FarhterCompany] = @FarhterCompany,[StockAddress] = @StockAddress,[IsDel] = @IsDel

	WHERE ID=@ID

实现的效果图：

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkgAAAEyCAIAAACOLbjCAAAgAElEQVR4nO2dP2jbeOO4NXa8oUOH7/A1vMMVOryCDhf4LuftF+hQQ4czvEMRNxymQwnvcJguh7mhiAzFdAgiQ8AZAs4QcIaAswScIeAMAWcIKEMGDR00ZPBwg36DbFnW349t2dLHeh4eev7zkSw7qZ77yLKr6N8MRETErVFxAAAAtghlPHYQERG3RsKGiIhbpZL7wVBERMQMVcbPNiIi4tZI2BARcatUmof9BHPfPsTFHY/uh72zrnHYzt3uSWd0NxiPx+OxPR7n/sqszTFigUw63b952M99+xAXdXQ36J11hzcD82GUu6O7Ye+8O7ob5P6yIJZHwobbZvekM7obWo8j69G0nvLXfBh1Tzq5vyyI5ZGw4bZpHLYnUbFMqwDYlmUctnN/WRDLY2rYEjCdpz3nXnVulelbCBCkf9/VLxr65d7Mi0b/vpv3di3D5LkUfvsLFTZ7FjYA2BBLhs35YTi3Pzk3iqtt286F6lxWxzfNsTXc5BMoOMZNq/do9K2ZvUfDuGnlvV0LM7jvGbet3qPRezSM29bgvpf3FsUiHjbzYTS8GQ5vh8ObgfW0lgoSNoDNkxI2559xhE8tL2mu1pPpnKue41t9PLZDC3Y1Ret5V+/1nY/duQH3urY/DCzV+6hoZ1HbEO9oX90JrSfomRYzZqj/our3c8N6HxVF8d24iMZDs/2jYdgz2z8axkMzPLL3UUkh8HIJvxqK/2VfysF9r3Or963OcNwbjnt9q9O51Qf3vbQF53/iK7jQs5gPW6yjh9HodmjbtvVk9S/7g+tB6iJLOQ3bP+NxFi9FMR0jFsnFw/Y8dK6VgObDyDlT/Y6vW4G2jfbVnf2R75aR/osyf8u493swY+FbRHaCgdU6/4ydMy25GtNFRqGwubd3td+X6Urrvt7+0QjYuq+nLZhREu71HUXT91VlqY13Hdz3OretvtXp2i13+7t2q291OrettLbl8yyMw7b1OEquVO/ObFyYI8u2n6zhzXBwNRjeDAfXg8jBnd8U9a9+csCSxxiH7VVfBEQUdvGw3e46V0pA82HknKpznry2H/rjsbfgdB8XE5hZP37RR76HEwtbN7FawX1r73dV39d29vVAq3q/+xZyN+NM29kfjfbVyY2L56F1V28/aQFbdxsJ272+M51o9n4P/j+EoIP7nnHT6j0ZHavpfwodq9l7Moyb5Lbl8yxmYYuxd2c2Lizt3G5c2L3r4eCqP7wdju5G/YueO6D177TZ87+bnb/U5CHqX30vroQNcZMuHrbLF86lEtB8GDknqs/XznHFPm+MnyeTttH+jnY2+V/v3j++C2kuNWPbidv9uenSzqZTMbeyc7ka6b/s6PdzkVsuCa6t25r+qAVs3dbSFlw5Cff6juJ/6SLmx6lOqvZoGI974WdhPO657xfGty2fZ5Ectt6dqZ1bzfPx3rFVO7Tqp2bvZmTeDTvHneHtwDey3/q32roKLG7U/90c+G7p/JY2hrAhbtylZmwhZ2E7Vp3j185RxTmqjE9rlmW5S3kzqknevGnZ7PJI/2U6VYo7bPiLPrrXd5Sd5Le7IsM2NxuL5Hd37zwJm+NtXuTtYg4ees2bmv6gBWze1AYPyQfxepqys7N4irxXwJun+l+N3u/TmajIxt/3jOtW96HdfmiEn4Jr+6HRfWgb13Ft6wV/kMKPvsqzMA7bZkzYevdW48Juntt7x1b9u1X/bmkndvN6bBx1hrfD4e1wPmxRvyfBsKWNIWyIG3fhsPX+Vpx9xdlXnG8vnO8/OQevnMOKc/TaOVadI9U5eu0cVpyDinPwyjmrWU+mt+B03xTa2c2iMt889+ECM7aosAlHq6dF7BBH+i/+WcW0r5Nd6mSRhSaO/btu66yhn+/pV43WTV2/C9q6qetXDf18r3XW6N9FHt7sacqOfj/Sf/HvxL1ti+cXXf/d93qGM3+mCZ6FYVzqnTtdv9PC2z+v1rnTjUs95lmEH2vtzyIubP1Hu3HtuHO1+oFV/241TuzGldM87A5vh6O7ofmQdABzSQkb4sZNO90/9KVwvW+vx3+/cL4qEX5/5RxUnO8V5/sr5/ur8fHu6H44WfC0rnzszNYzudrRlHr32R5+VdWvw/GzPb5tqW9bQ9/DdT8q2uki31l3WlcURVHU1m343k7MTLDenT5WaNlh662qvlUmmydm+7zZutSal7Xmda11U4+0eV1rXtZal1r7vBm1kskrM362h1/VmKcj5Oy1XVDjQq9+eV398rpxVI17Fo2jqjvGuNCTn8WKLvQsIsPWf7QbV+PZXO3Aq1pneDsc3Q/nFzHqSeFVW1emdZQ4RFHqR3NhW/1FQERBFw7b8Lxh/lVx/lai3f/J+fbK2f/JOVDN/Z3Rw8hdquudy+5267Sufh1G7PhWC9vwq6p87Ay/qurXTutteMGONr/y8bM9fh623vq3Ydh6669IR1MWLOuzbVzojaPd9u1e67qeYPt2r3G0K5SE0Msi7tJh8z+d5mUtvP3Ny1rMxsc8ixVcMWzmo9m8srQz31zteFK10Z1btZT30vxO3lc7qk9OD4ly8JdK2BDzcuGwmU9m/8+qs//K+aJE+Jfi/P3C+fqTc7zb/7NqPplzi9+2VKXeneVquuO7banufG6yB5/FJhi225YaOX25banKZF7l7QS7H2ezsfGznTpjGz/b/rBNFp/NNSO7GO2kbTd7rat687IWsHVVb98kVM3OKwlx7p3vhp/F3vlu2oL5he1hZD6OrKeJ/ZtR49yqn1n1A0ubHYHsjO6HgZFT3bCNBl/mT338d3PwNDJ+U5tXs8GBMfXDwKpM64mwIW7UhcNm/7AGZ8boy2tnv+L8qUT41wvnsDr68rp/atg/rMmCty11Ol1z51XjZ3u24/Pi4Q7zTZJEwtb9OJ0IPtvj4E6woynK3FHQFN2wDVuzw4/DyeQvcDQ1TeNCbxzutq/3mpf15kVt5mW9fb3XOEyoml20sDVOd+eewkWteVFrnMoQtseR+TjqnRmNU7NxZtVOLO10UjXzYWg+RlZtLmyzUF011aiwGb/NYjY3nrAh5uTiYXu2zCez+6U2/Fxxvu84XyvOlxfOn4rz5YXz9ytnv+IcVIefK90vNfNxZD9PwjbdwfmDYY99hygn9QrFY+H32GJ2gt307/XoTN+fC++LJ1O9JY5Jaoe7+tVe60LbO6/tnddaF5p+taelVM0uXNhOdt3t99s4iQib0Ou85mfhD5t9vWdfNqyDn3pnWuNk1Di3G+cj/bjrDoip2gIzNuM3RVFqxlMobNMKEjbEzbtw2MbPtm1b5sOo+1e99+GF+UUdf6s6h7vO4e74W9X8ovY+vOj+VTcfRrZtZbihkmpc6NrBrn65p1/t6Vd7+uWedpBatcK5d1rbOwt5Wst9w6Jfc1/Yxpd1+0qzjlX7+FX/pN696Axu+olJmwtb8MZJ32qG17zfjLkxhzUvguqXPjM2xFxcJmzjZ9u2LevJHJx3up+rnfcvOu+Uzjul8/5F93N1cN6xnkyq5jlp20VDv2jIWLXxs619r4b/jQLtezX3DYt+wb2wPY7Gl/XxlWZfN6xLzbo1rMfJwUlrYxI2xI27ZNhc7R+W9WSaD6PR/dB9H956Mmfvq+FU79R5Gavm336/hX0u/rDZV3v2Tcu+M6yHnvU43FzPCBtifq4UNsQCOjndP/HrIjcsYUPcpIQNt83OsWE+jNbwD9Aso21Z5uOoc2zk/rIglsfUf2g0/3/kG3EhhzeD3nl3dD+0f1i5az6Oeufd4c1g8lcu7xdnXea9I0P0qzQP+wnmvn2ISzi6H/bOusZhO3e7J53R3WD8vO0ByL2siD6V3LcAERExQ5XuiYGIiLg1KvrJABERcWskbIiIuFUSNkRE3CoJGyIibpWEDRERt0rChoiIWyVhQ0TErZKwISLiVknYEBFxqyRsiEXR/ae3MxzsHyO48kVXu8SWL/qCeCRvxpq2AWWU3wPEQqgoivannm3bFt31i1fNj7fZCRGKXDBy81LXk7C1tA1d+SVAzF//HnnRMCzUieUGJ29n+EJ4nf5mx42Pe0GWG4Bllt8MxJwN76Mj99qKorz630rymNSVLDp49UdJ6Jnggya8Poqi7Py6G19k9m8llR88Yp6KF2WhsPn37CI7/YQ2hBsjQng7RTYj/LwSxrjs/Lor8oJgqeT3ADEf4/bscQMURXn1vxWRoijZvV0nkhnBRRIuhJ9yQvnEHwhLKz9+xJxNSFRgmDdjWygwIuuPGxO3JYuuc5X32BK2QfAqlk1+9og5G5eE8DA3bKk7/dS7xAeLREVwDSIt9A9LWHnk1dQ1Y3nkZ4+Ys8uFLXVXvlBREtaZ0B6Rlgg+u9Rt8C8Vd6M7L/QO2Ob+k8W85GePmLOCu35l/uSRhJGBu8TTInKvyIAlnl3qgiJb5YUt958p5ithQ8zZyLlI5LC1hi28GXGDo6ZSwflTYHDkh7iTNyNh+5OfLGFDwoaYswklC0xZBM+KDCweVyb/1cBZlHGrWnSDk9OVvIaE7QmvPxw2kRzitsoPHjFnFwqb4LJ6KGzJCYz8eEBcGuNWKNiShboYeTXwWIHLhA35wSPmb2onBGMQeVdCsSIvp4Zq6Y1Jfo6RgwVfuqUXx62UHzwiIm6VhA0REbdKwoaIiFslYUNExK2SsCEi4lZJ2BARcaskbIiIuFUSNkRE3CoJG25a9a2KiBL56n9evXr1Kvddh7iEDTen+lat/lrtX/StJ8sBAHkwf9ivft396eVPue9GRCRsuCHVt6q+r1uWZZyPEFE6R8/j7r0lRdsU07JxFfWTQe7bIIXVX6tUDVFqB/b41Yd67juTVAnbqhI2EdW3qvVE1RClt/tj/Op/XuW+S0mWsK2qG7bh7RATVN+q4/HY/9djcDWIs3/ZH9xTQcTF7Bz36/+3W31Zydb6/+12jvuzR7HG6ls19x1vsoRtVb2w5f3mbqFR36qO4xgXI8/B1SBu8PBm2L/o929M/3hETHb3X2r/wBjfDbO1f2Ds/kv1HoWwlULCJkI4bP3LftzgwfVgPB73L/q96/x3FoiyWH1ZGd8N7RMjW8d3w+rLyuyBZAmbopC35SVsIrhh61yanglh61/0Pf2LrKZRTfqnLmt7l6b+h5r872FW/kjaHv0Ptfq32bk0O0fNasTIfv1ndzVq/Wi6ST839Uuz83ct4sHeGdk9dyyF1ZeV8e3QOjbsea3pn9b8LeExkY5vh9WXFe9RWk+ErQQSNhESwtY66O9972v7/fr+LHWWZVmPZsZhcysSYb/+c20v4ka1fhwcPB+/uaX0P9Tq18nlvXdK9avZOW5WfKO9e4Ob9LWWnExEEasvK+ObgXXUjrT9Z7P2QXNt/9mMvCXS8c1gLmyP8oTNT+7bJJeETYRJ2K5Mz/5F7IzNo3/R9y+ymkb153r1XVO/MjvHzcrPTd29/Wtdedes/1zf867GUP0aXmFz71NokjdZc7/+bvoQ7lXvISZXfWt+V698Mvy3RD0cYorVlxX7ZmAdtiOtfdC8v1m1D1r7v83ALXEL2m7Ypo/SlCJsgZIRtkUlbCK4YetemZ5e2FqH/eZBv/GtX9/v7/492PlroP45Oa+kf9H3L7KaRvVNs/21XvnUb39Sq5+alXdG98psvlOqX/v1N/WmO+xrXXlnhBdvf1KrXycDKp/63SuzezxZQ8SYif36m5hIvmm23TW4F7x1XpnNd2r9OKunjOWy+rJiX/etAz3S9n/3AiXzX27/dy9uQfu6X31Z8R5FjrBN/qNEHJNkAiciYRMhHLbeeS91qd55L7u/9kb1TbN9ZTbfKYpSb16Z7U9q5VOz+qbZvooJm683/mg136n1k+m9J9M4zcZMeuYt271yb5w+xNS2O9ub5nZu5XnvIlFG3bCZ31uu1vwF63tr0rZ/HL9u1fzDTJ/W91YgbHsPsoUteB9hE5CwiTAJ27Xp2TubhC1hxtY76/kXWU2j+qbZvja7+3XFvXA90N4olU+D7vVAe1NvusP268o7ozu9XPk0cC+3P6nVfd+qlHr1neLe0v6kusPmxviW7U4ea/oQs+1RK2+a7f165Y1a+TRozx3VDAxGTLf6smIe6P1fXyfYerdb+6DZP2zX2get9W43eRHzQK++rHiP0pAibP65GhlbQsImwjRslqcXtgR6Zz3/IlF65zqq2kn46vzIN832tVFV6tontbo/HfzOmFbH6l5b07BZ3WurPRkWvDwZpkwXuR5ob1TtZH7MJGxWO/wm3Jtme7JCd5Nmg7vXVvNdeMsRhZyE7f+pcbbe79Y+aNaT5bf2QWu9301Yahq2yaPIFzaTti0uYRMhHLbuade9K2HG1j3tZvfXvlN909TeK5XPA+9ydd9qvle1k/mwve90ry13PjcL2+e5sLU/q4qizKUuMGa/Xvk8cG90L0x0D11eW83PzfZ1Zxa26Zjme8KGS1p9WTEP2/33O5G2PtRqHzTz0XQNXG59qMUtaB62/WHT7iUPG4ciRSRsIrhh691Ynl7YZof7Q3RPu/5FVrNTdQ/xuVf365XPg96N1TttVd7Uq2+mt09tf1aV953me0VRlMlIz9NWRak3bzpVZW4pN2y92fo72hu1+l6dW/y0VXnTanub5F7er1c+twIfsws+KGKa1ZcV88gY/Gc30toHbXQ/cq190Fq/1QO3xC1oHhnVlxXvUepShG3yH8K2rIRNhHDYjEPDvSthxmYcGtn9te9U37SM6LsGmj9sp63XiqK873gD3LxVv03Xo6jaqdW7sXrf6q99+TE+q9MxVu9bXVGU158HxufwoUhvM6abNL8exOWsvqxYJ53hH7XhH/WptenVmv6fuvepNf0/9eEf9dAtNd8i3oJ166QjfdhwUQmbCOGwtb+1U5dqf2tn99c+Kmzf6v7YtN4HwuN3oL1Rqt+s1ntlVi9XN4SKoij11vRGL3LGZ/X1/IztdVTYgvGL3QzEWKsvK9Z5d/hfLVut864/bDVZwsbMbBUJmwiTsN1anq2/W6lLtf5u+RdBxASrLyv2ZW/0pZGt9mWv+rLiPUrtTpKw4SoSNhHCYWv+2RQx950FoizWft7pHxj29SBb+wdG7ecd71F2CVsZJGwihMOGiNlqHPZ2/6Vm/u+x7f5LNQ573qMQtlJI2ESYhs1GRKmtErYySNhEcMPWv7MRUWqrt4StBHphwwQJG+J2SNhKoRs2TFZRFDdsOc8cAWAF+nf2zu24+GfRF337ii9hE5GwAWwB0oRNPxkgrlvCBrAFeGHLfZeSssPJPa2yqzNjE5CwARSHxh+N5RaUZsaW+xbILmETkbABJDB+Hm/MzlGHsGGKOmdFCkjYSkjnqIORhl8rwpatRd++4qvzOTYBCFsJcXegGNB6ssKvlUiQFEVJvT1uDGHDxSRsIuQYNvehRW5cYgwksMoOdIsRD1vEv/kwT7hnycPKGLbib2sxJWwiJIQt4e9thg8tcuMSYyABwhbJEjM2N07+P8WndISt6NtaTAmbCMlhS1gkcIsICevxLqdGa32hLQ+ELZJFw+afjaUGLDxXI2xF39ZiSthEyCRsq48RDNvSkzzwQ9giWfRQZNx7acr84ce499tKGjZvE4u/rcWUsImQHDbBuVfcauPuCq9N5FG8kYIPBHEQtkiWmLGFSZ3VEbZZ2Fzm7iv8E8hdwiZCQthWX63IgECuIhcMdC55MKRC2CJZ+lCkyC3h/hG24LYSNhEJmwhxYYv8v9GE6VTkakUGxEUrdVmqtjSELRJmbBswKWwoImETISFsqUtlMkBZ6tAiVVsFwhbJumdshM0kbKtL2ESQLmwi80VIhrBFsqYZm8JZkT6Twua+NLlvYsElbCIIhm2J/IjcGzggGSC8VALJ2wN+CFskS3/ziMisTmR6R9gIW7qETYRcwubEv0+W0LOE1RK2hSBskazjm0cSFg/fXvawoYiETYS8whY3RnCqt8TDgQdhi2QdM7aFLEvYAuS+TXJJ2ESIC1t4zEJH/DKcsYncS9gWgrBFQtg2YNG3r/gSNhFSwxaeq0XeIkh4nQvNBQlbJhC2SAjbBiz69hVfwiZCQtgSpmirhCRylpYcwiVGQgKELRLCtgGLvn3Fl7CJEA6bYCpyaQkztkwgbJEQtg1Y9O0rvoRNhNRDkbB9ELZICNsGLPr2FV8vbJggYSshhC0SwrYBi759xdcNGyZL2EpI56hjPVkYNvK12qSEDVMkbCISNoA4Gn80Nu9ymypN2PSTAeK6JWwAW4AXttx3KSk7nNzTKrs6MzYBCRvAFiDNjC33LZBdfXLyyKh/Oeie9jBSwgawBRC2suiGzXqybXuc929dcSFsAFsAYSuLXtjy/pUrNIQNYAsgbGWRsIlA2AC2AMJWFgmbCIQNYAuQJmwBct8g6Vw0bJFfuZvJyCJ/Yy9hA9gCpAnb3JXCb24BXWLGFtehcI28q94iCSsMDCBsAJAt0oTNP1cr/uYW0NUPRYoUKHkqFu5ZoarmEDaArUCasM1dKfzmFtBVwiZ48DByQhZeQ3h8cSBsAFuANGHzv7VW/M0toEu8xxZ3vDE8TGSkw4wNADaCNGEzfT0r/uYW0A28x7bQsPDVIkDYALYAwlYWlw6bE5pXLf3mGYciAWADELayGBk2c1+dTKw+9vyX3Xv9YUuYhzkCYQssGLm25I3ZDIQNYAuQJmwu3pXcN0g6NzNjC1xIXpAZGwCsA2nCNnel8JtbQFcMm8iMLXKWFjksdYV5QdgAtgCZwubtBHPfGhldLmziEy+RODFjA4ANIFPYcBWzOhQZmGCF74qbisVN4AoFYQPYAghbWeRLkEUgbABbAGEri4RNhEXDNn4el8p1vvYAmUHYyiJhE2GJsHWOOmXQfbJrfOkBsoOwlUUvbLbN7imW5cLW+KOx3bpJI2wgC4StLLphM59s6wfGunTY1vmXNH8IG8gFYSuLk7BhooQtEsIGciFN2PSTAeK6XVPY4j7YEP7gRAE/AuEQNpANL2y571JSdji5p1V2dWZsAmYStvAn+eKiRdgA1oE0M7bct0B2CZuI656xJXxEnbABZAVhK4uETcSNHYqMnNLFDc4dwgZyQdjKoj9suR9ZLqyrhy3ye8Uiv2PMif/SslX/WmcNYQO5IGxlMRC23LenmGY4Y0ttVXi6FnfEMncIG8gFYSuLhE3EzYet4HM1F8IGckHYymI4bMPbIQbM6qxIZ75bcedDSlE1h7CBbBC2shgZtrx//QpHtmEL3xj5cAlLFQTCBnJB2MoiYRNh3WHj5BGADUDYyiJhE2FNhyK92xPCFnfmZBEgbCAXhK0sEjYRMjzdP2H9cVcTbswXwgZyQdjKYlLYzrXp3ljVH6a/Gg+6Gr5x28nwrMhtgrCBXBC2shgbtgdd9dJ1rimK1nMcx+lpiqKdO47jmPvq9Mbth7BFQthALghbWRQ7FNnT3Mg96OosZtMbSwBhi4SwgVwQtrIoEjZzX1Xe6qbjOI6pv53M2JxzbXrj9kPYIiFsIBeErSymhG3yjpp/ZmbqbxVFUcpTNSfrsKV+NI2zIgHWAWEri0KHIuffY1P3TYf32BLhS5ABCghhK4u8xyYCM7ZICBvIBWEri4RNhEzCJjJdK3LGwhA2kAvCVhZjwzY7/Og4D7rqO3mEQ5GpJHzziBOasYUb5g3wClfM2hE2kAvCVhYTZmzm/vSj2P6A8QFtAZaesfkfLu7P4kDYQC4IW1nkK7VE2PyMLZA9ZmwAq0PYyiJhE2Hz77GFH72AEDaQC8JWFgmbCJmEzYl/Oy3yRpGDlvlC2EAuCFtZJGwiZBg2kValzuEKAmEDuSBsZTEybBgwlxmbU+wzRxzCBrJB2MpiOGwYdpMzNv8JI94tgQsFgbCBXBC2skjYRMwqbFsGYQO5IGxlMRA2jJSwRULYQC4IW1lkliYiYYuEsIFcELaySNhEJGyREDaQC8JWFjkUuZlDkYLnQ0bem3rOSF4nlRA2kAvCVhZ1Th4RMJMZW8L3ifjPe0xmoWHrhrCBXBC2skjYRMz8UKS/QMkfZYsbUAQIG8gFYSuL4bDl/mnoArqO99iSqyb+ibdc5mouhA3kgrCVxciw5f3rVzhWD5t/fpYapNQ5nPgta4WwgVwQtrJI2ETIZMYmUi/vLmZsAJlD2MoiYRMh87ClFituGwoFYQO5IGxlkbCJkG3YAjELz+QSEBmzsQQSNpALwlYWk8J2rk33k6r+MP8L8qCritbb+O9lXmQYNiXqnbbwsPBlZz6NqVu7AQgbyAVhK4uxYXvQVa9n55oyn7HeR0UhbPGIHIpMuBz+MzzSiZq3CT+hbCBsIBeErSyKHYrsaf5J27mmvFWZsSUQF7a4Y4nhh4uMVsLczhGez2UIYQO5IGxlUSRs5r6qvNXN6TX9rdbjUGQiS8/Ykrch0MW4MYQNIBLCVhZTwvagq/PvsZn7qrpv8h5bMnwJMkABIWxlUehQ5Ow9tp7mTt0IWyKEDaCAELayuNB7bL2PinbuOA5hS4GwARQQwlYWFwlbzzv932PSuW2HsEVC2EAuCFtZjA2b/xT/B12dnTwyvYUZWzziX4IsNYQN5IKwlcWEGZu5r3oTs2DDCFsicV+CHDizMXAhPDL5UwG5Q9hALghbWeQrtUTIcMYW6FkBcyUOYQO5IGxlkbCJsKawSV01h7CBbEgTtjBJ9xX++WxewibCWg9FygthA7mQJmyT/yjBC4HLcbcgYRMhk7AFVljw989EIGwgF1sSNmZsqUaGDQNmHjYn8T22yF/dJf8qrxPCBnIhTdhI14qGw4Zh13cospjFEoSwgVxIEzZvvxO+EEfuG10oCZuIq4fNQ0k73V8iCBvIxTaELW4PlftGF8pA2DBSwhYJYQO5kCZscRMyJeYskuI/pQ3LLE3ENYVN9rYRNpALacLm7XfCe6LUy2gSNjEzCVvgHJDImCUcQg8sXgQIG8iFNGFjxraiHOwGwiUAAAdgSURBVIrc8KHIbYKwgVxIE7bJf+I31L2L00bi1Dl5REDCFglhA7nYhrCFY0bewhI2EQlbJIQN5EKasEUeikwOWPGf1SYNhy33T0MXUMIWCWEDuZAmbLlvgexGhi3vX7/CkVXY4s7+KNpZIYIQNpALwlYWCZsI6zjdP/LG4p8J6YewgVwQtrJI2ERY06FIReBzbCJj8oKwgVwQtrJI2ERYPWyR8zDxsBWwag5hA9kgbGWRsImQ7Ywt3LPksBWzag5hA9kgbGWRsImQb9iSB+QIYQO5IGxlkbCJkEnYEnrGe2wAG4CwlUXCJkK2p/svFLbUe3OEsIFcELaySNhEWNPp/ouGrWiFI2wgF4StLBI2EdY0YwvcnroBhA1gFQhbWSRsImT7HpsTSpRIsQp4eiRhA7kgbGWRsImQyefYwit0fJ9vE9+M4kDYQC4IW1kkbCLwJciREDaQC8JWFgmbCIQtEsIGckHYyiJhE4GwRULYQC4IW1kkbCIQtkgIG8gFYSuLhE2Edf+zNcmPm9WwzCFsIBeErSwSNhHWEbaEs/9Tb19uWOYQNpALwlYWI8OGAbP6HFvg5P7IC8lEPhxhAxCBsJXFcNgw7Fq/UkvkG5BF1pO6SOYQNpALwlYWCZuIuYRNfJZG2ABEIGxlMRA2jDSTbx6JPKiY3K2E8hE2gEUhbGWRWZqI6zsrkrABbAzCVhYJm4hZnTziiB2KTDi7JDwm4fK6IWwgF4StLHIocjOHIh1fxrxDkZHdEiwWYQNYFMJWFnVOHhFwHTO2yBoF4hd4T26J/q0VwgZyQdjKorxhk/dzbOJ/D5NP949DfP0rQthALghbWZQ6bOPn8WZcPWz+OZl4jZaoFGEDiIOwlUXCFm5YgEzCtpUQNpALwlYWCZvbreRbCFskhA3kgrCVRcIWVzLClgphA7kgbGWRsCUfh/S/B0bYAhA2kAvCVhYJW8LszX/ByTRsyad4ZHguyVohbCAXhK0sErbAgcfIY5IbDlvcAMIGsAqErSwStkDAIlO3+bBFDiZsAKtA2MoiYUudw21yxhb53h5hA8gEwlYWCVvcAUn/HC6rsIUTldCqhQbnAmEDuSBsZZGwBaoW6Fm2hyIjE5V6qghhA8gEwlYWCVu4amsKW1zMArlK6BlhA1gFwlYWCVtk59bxHptIzPxXCRtAthC2skjYBFPnZPQlyCJXnZgKEjaAVSBsZZGwbSZsAUQ+oJ1cuyJA2EAuCFtZJGxFC5v4EcvcIWwgF4StLBK2DYfN/wG1yHsjryYvlReEDeSCsJVFwpbLjG07IGwgF4StLBI2wrY0hA3kgrCVRcK21rCpB87wd2Vb/yRsIBeErSxKHbaNuXTY3AZsq4QN5IKwlUV5w7ZJV5mxReo4+WdpRZmxgXQQtrIYCBtGuvqMLRV/80SGFUHCBnJB2MoiszQRM5yxOU7wz8gByReKIDM2kA7CVhYJm4hZvcfmCLQqYUx4cL4SNpALwlYWCZuIq8/YXML1Srgr4UIRZMYG0iFN2HJ/9wXLYIYztgDhYDiShI0ZG0iHF7bcdykpO5zc04plMPOzIhMq5UgSNmZsIB3SzNhy3wIsg5l/js2JT5QTdV6JR+4980vYQC4IG+LMrN5jSyAwctEcMmMDSIWwIc7c/Iyt+GFTmbGBbBA2xJmb/OaRZHKPmSczNpAOwoY4M8MZm8dyzcu9Z34JG8gFYUOcuY6zImWXGRtIB2FDnLnijG1b/yRsIBeEDXEm/9BoJIQN5IKwIc4kbJEQNpALwoY4cx1hc9cpNYQN5IKwIc5cPWyKD++WwIXAsMD4AkLYQC4IG+LMDGdsgZ6ldiuyfwWBsIFcEDbEmWsKm0irBPuXC4QN5IKwIc5c66HIZIp8NJKwgVwQNsSZmYTNP0D8jTRmbABZQdgQZ2YeNof32AA2DmFDnLm+Q5Hib7MVEMIGckHYEGeu76xIR+ZJG2EDuSBsiDPzDZtT1HfaCBvIBWFDnLnu0/0F20bYAFaBsCHOzCRsgTItUSnCBrAKhA1xZoYztm2CsIFcEDbEmYQtEsIGciFN2PSTAeK6JWyREDaQCy9sue9SUnY4uacVyyBhi4SwgVxIM2PLfQuwDGYVtrizP+K+l6TgEDaQC8KGOHMdp/sn3Bj+Jslido6wgVwQNsSZazoUGfk5tvBnsYtZNYewgWwQNsSZ2X5XpDcDS/6AdpHnai6EDeSCsCHOzHbGlvqtWuGPchczb4QN5IKwIc7cWNgSGlbAvBE2kAvChjgzq6/USr3gXeXkEYDMIWyIM7M93V8kbMkDCgJhA7kgbIgz13S6PzM2gE1C2BBnrmnGFrg9fJUZG0CGEDbEmdm+x+bEl8y7yowNIHMIG+LM1cOWMCcLdyt1SlcQCBvIBWFDnJnt6f5bA2EDuSBsiDMJWySEDeSCsCHOJGyREDaQC8KGOJOwRULYQC4IG+JMwhYJYQO5IGyIMwlbJIQN5IKwIc4kbJEQNpALwoY4k7BFQthALggb4kzCFglhA7mQJWz/H7shZtvZ95/JAAAAAElFTkSuQmCC" alt="" />

前台界面：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="StockAdd.aspx.cs" Inherits="BioErpWeb.StockSystem.StockAdd" %>

<%@ 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/CalenderStyle.css" rel="stylesheet" type="text/css" />

    <style type="text/css">

        .style1

        {

            width: 100px;

        }

    </style>

    <script src="../JS/CheckUserNames.js" type="text/javascript"></script>

    <script src="../Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

    <script type="text/javascript">

        $(document).ready(function () {

            var i = 0;

            $("#btnaddRow").click(function () {

                i++;

                var tr = '<tr id="tr' + i + '"><td><input type="text" name="UserId"  id="txtUserName"/></td><td class="style1"><input type="button" value="选择员工"  style=" width:100px;" onclick="showDialog()"/></td></tr>';

                $("#caption").before(tr);

            });

            $("#btnDeleteRow").click(function () {

                var lasttr = $("#tr" + i);

                lasttr.remove();

                i--;

            });

            //验证

            $("#btnSubmit").click(function () {

                var stockname = $("#txtStockName");

                if (stockname.val() == '') {

                    alert("请填写仓库名称");

                    return false;

                }

                var stockaddress = $("#txtAddress");

                if (stockaddress.val() == '') {

                    alert("请填写仓库地址");

                    return false;

                }

                //2011年10月26日9:54:56 完善下拉列表验证

                var selectcompany = $("#ddlCompany");

                var selectCaption = selectcompany.select();

                if (selectCaption.val() == 0) {

                    alert("请选择所属公司");

                    return false;

                }

                var userids = document.getElementsByName("UserId");

                for (var j = 0; j < userids.length; j++) {

                    if (userids[j].value == '')

                    {

                        alert("请选择第"+(j+1)+"行用户编号");

                        return false;

                    }

                }

                return true;

            });

        });

    </script>

</head>

<body>

    <form id="form1" runat="server">

    <div>

     <table class="maintable">

         <tr>

             <td class="titlebar"  colspan="2">

                 <span>仓库信息管理系统</span>

             </td>

         </tr>

         <tr>

             <td>

                 库房名称：

             </td>

             <td>

                 <asp:TextBox ID="txtStockName" Width="200px" runat="server"></asp:TextBox>

             </td>

         </tr>

         <tr>

             <td>

                 库房地址：

             </td>

             <td>

                 <asp:TextBox ID="txtAddress" Width="200px" runat="server"></asp:TextBox>

             </td>

         </tr>

         <tr>

             <td>

                 所属公司

             </td>

             <td>

                 <asp:DropDownList ID="ddlCompany" Width="200px" runat="server">

                 </asp:DropDownList>

             </td>

         </tr>

         <tr>

             <td>

                 仓库管理员

             </td>

             <td>

                 <table>

                 <tr><td><input type="text" name="UserId"  id="txtUserName"/></td><td class="style1"><input type="button" value="选择员工"  style=" width:100px;" onclick="showDialog()"/></td></tr>

                 <tr id="caption"><td colspan="2" style=" text-align:right;"><input type="button" id="btnaddRow" value="添加一行"  style=" width:100px;"/> <input type="button" value="删除一行" id="btnDeleteRow"  style=" width:100px;"/></td></tr>

                 </table>

             </td>

         </tr>

         <tr >

             <td class="bottomtd" colspan="2">

                 <asp:Button ID="btnSubmit" runat="server" Text="仓库信息登记" CssClass="submitbutton" OnClick="btnSubmit_Click" />

             </td>

         </tr>

     </table>

        <br />

    </div>

    </form>

</body>

</html>

选择员工的界面：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PersonList.aspx.cs" Inherits="BioErpWeb.PersonList.PersonList" %>

<!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>

    <script type="text/javascript">

        function search() {

            if (document.getElementById("txtSearchName").value == "") {

                alert("请输入员工姓名");

                return;

            }

            document.getElementById("PersonIframeList").src = "PersonListSelect.aspx?username=" + encodeURIComponent(document.getElementById("txtSearchName").value);

        }

        function choose() {

            window.returnValue = PersonIframeList.document.getElementById("sltUserList").value;

            window.close();

        }

    </script>

    <style type="text/css">

        .style1

        {

            width: 157px;

        }

    </style>

</head>

<body>

    <form id="form1" runat="server">

    <div>

     <table style=" width:310px; ">

         <tr>

             <td class="style1">员工姓名

             </td>

             <td>

                <input id="txtSearchName" name="txtSearchName" type="text" size="10"  maxlength="10"/> <input type="button" value="查询" onclick="search()" />

             </td>

         </tr>

         <tr>

             <td class="style1">

             <iframe width="120px" id="PersonIframeList" frameborder=0 src="PersonListSelect.aspx" height="310px" >

             </iframe>

             </td>

             <td style=" vertical-align:bottom; padding-bottom:20px;">

             <input type="button"  value="选择" onclick="choose()"/>

             </td>

         </tr>

     </table>

    </div>

    </form>

</body>

</html>

选择不同的员工显示不同的编号：

//人员选择对话框

function showDialog() {

    var re = showModalDialog("../PersonList/PersonList.aspx", "", "dialogWidth=320px;dialogHeight=350px");

    //找到点击的事件

    var obj = window.event.srcElement;

    var tr = obj.parentNode.parentNode;

    var rowIndex = tr.rowIndex;

    var txts = tr.getElementsByTagName('input');

    if (re == null || re == "")

    {

        if (txts[0].value == "" || txts[0].value == null) {

            txts[0].value = "请选择";

        }

    }

    else

     {

        txts[0].value = re;

    }

}

查询公司列表的BLL：

  public   class CompanyTableBll

    {

      /// <summary>

      /// 查询公司列表

      /// </summary>

      /// <returns>DataTable</returns>

      public DataTable GetCompanyList()

      {

        return   SqlComm.GetDataByTableNameValue("dbo.BioErpCompanyTable", "*").Tables[0];

      }

    }

添加和修改仓库管理员数据：

 public  class BioErpStockUsersBLL

    {

      /// <summary>

      /// 添加管理员数据

      /// </summary>

      /// <param name="stockuser"></param>

      /// <returns></returns>

      public int StockUserAdd(BioErpStockUsers stockuser)

      {

          SqlParameter[] parameters = {

					new SqlParameter("@StockID", SqlDbType.Int,4),

					new SqlParameter("@UserID", SqlDbType.Int,4)};

                    parameters[0].Value = stockuser.StockID;

                    parameters[1].Value = stockuser.UserID;

                    return DataBaseHelper.ExcuteSqlReturnInt("BioErpStockUsers_ADD", CommandType.StoredProcedure, parameters);

      }

      /// <summary>

      /// 根据ID修改仓库管理员信息

      /// </summary>

      /// <param name="stockuser"></param>

      /// <returns></returns>

      public int StockUserUpdeat(BioErpStockUsers stockuser)

      {

          SqlParameter[] parameters = {

                    new SqlParameter("@ID",SqlDbType.Int,4),

					new SqlParameter("@StockID", SqlDbType.Int,4),

					new SqlParameter("@UserID", SqlDbType.Int,4)};

          parameters[0].Value = stockuser.ID;

          parameters[1].Value = stockuser.StockID;

          parameters[2].Value = stockuser.UserID;

          return DataBaseHelper.ExcuteSqlReturnInt("BioErpStockUsers_Update", CommandType.StoredProcedure, parameters);

      }

    }

添加UI层后台的代码：

public partial class StockAdd : System.Web.UI.Page

    {

        CompanyTableBll companybll = new CompanyTableBll();

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                CompanyListBind();

            }

        }

        private void CompanyListBind()

        {

            this.ddlCompany.DataSource = companybll.GetCompanyList();

            this.ddlCompany.DataTextField = "CompanyName";

            this.ddlCompany.DataValueField = "ID";

            this.ddlCompany.DataBind();

            this.ddlCompany.Items.Add(new ListItem("--请选择--","0"));

            this.ddlCompany.SelectedValue = "0";

        }

        protected void btnSubmit_Click(object sender, EventArgs e)

        {

            StockTable stock = new StockTable();

            stock.StockName = this.txtStockName.Text;

            stock.StockAddress = this.txtAddress.Text;

            stock.FarhterCompany = int.Parse(this.ddlCompany.SelectedValue.ToString());

            stock.IsDel = false;

            BioErpStockTableBLL stocktablebll = new BioErpStockTableBLL();

            int stockid= stocktablebll.StockTableAdd(stock);

            BioErpStockUsers stockusers = new BioErpStockUsers();

            BioErpStockUsersBLL stockusersbll = new BioErpStockUsersBLL();

            stockusers.StockID = stockid;

           string userids= Request["UserId"].ToString();

           string[] userarrayList = userids.Split(',');

           for (int i = 0; i < userarrayList.Length; i++)

           {

               stockusers.UserID = int.Parse(userarrayList[i].ToString());

               stockusersbll.StockUserAdd(stockusers);

           }

       Server.Transfer("StockTableList.aspx");

} }

游标的介绍：

Transact_SQL 游标是由DECLARE CURSOR 语法定义、主要用在Transact_SQL 脚本、存储过程和触发器中。Transact_SQL 游标主要用在服务器上，由从客户端发送给服务器的Transact_SQL 语句或是批处理、存储过程、触发器中的Transact_SQL 进行管理。

查询实现的需求：

1.联合2个表查询，将返回结果绑定给GridView控件。

2.将员工编号对应的姓名组装成姓名字符串，显示在列表中。

游标的定义方式：

-- Description: <通过userid'2,331,332,333'等查询对应的用户名>

-- =============================================

--select dbo.[BioErpTbFN_GetUserNameListByID](',2,331,332,333,')

ALTER FUNCTION [dbo].[BioErpTbFN_GetUserNameListByID]

(@userID NVARCHAR(200))

RETURNS  NVARCHAR(1000)

AS

BEGIN

	declare cur cursor for select UserID,UserName from UserManager  where CHARINDEX(','+convert(NVARCHAR(10) ,id)+',',(','+@userID+','))>0

	open cur

	declare @id int

	declare @name NVARCHAR(50)

	declare @nn NVARCHAR(3000)

	set @nn=''

	fetch next from cur into @id, @name

	while @@fetch_status = 0

	begin

 	    set @nn=@nn+@name+';'

        if len(@nn)>50

           begin

            set @nn=SUBSTRING(@nn,0,50)

            set @nn=@nn+'……'

            break

           end

              fetch next from cur into @id, @name

   end

	close cur

	DEALLOCATE cur

 RETURN @nn

END

游标的具体使用：

-- Description:	根据仓库编号返回员工姓名字符串

-- =============================================

ALTER FUNCTION [dbo].[GetUserListByStockID]

(

    --传递的参数

	@StockID int

)

--返回的类型

RETURNS  nvarchar(200)

AS

BEGIN

	--定义游标

	declare cur cursor for

	--子查询

	SELECT userName FROM UserManager WHERE UserManager.UserId IN ( SELECT  UserID	FROM BioErpStockUsers WHERE StockID=@StockID)

	--打开游标

	open cur

	--定义姓名的参数

	DECLARE @name nvarchar(20)

	--姓名组装后的字符串的参数

	DECLARE @names nvarchar(1000)

	--给变量设置值

	SET @names=''

	--从游标中取出数据下个数据放到变量中去

	FETCH next FROM cur INTO @name

	--取到了一行数据

	WHILE @@FETCH_STATUS =0

	--取到数据之后组装字符串

	BEGIN

	     --赋值

		SET @names=@names+@name+','

		--在去下一条

		FETCH next FROM cur INTO @name

	END

	--关闭游标

	 CLOSE cur

	 --回收游标

	 DEALLOCATE cur

	 --返回变量

	 RETURN @names

END

--调用

select [dbo].[GetUserListByStockID](1)

结合实例的具体使用：

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAApMAAAECCAIAAAAtpsvRAAAdX0lEQVR4nO3dT46jut7GcZYF60FsJMoKInQWcKQeVs/I4Ep3VFItoXoQKRvoQQ3ewR36HTgQbP9sbBISDN+PoqtzUwQMSfPgP+BCAUoppbqmKIqiKNvrmwrw699f//3Pfxd6/fr3169/f/3v//7HixcvXrm/ijedpQHbr39/deduoRfJzYsXr828SG6shQ5XXrx48eIVfpHcAADkhOQGACAnJDcAADkhuQEAyAnJDQBATkhuAABykpbc15MqivurOqmuUUVzX6AujAXsV3lfsmuEBaqTsNH4dd6dhdXWharPoa2PX8OSAACsSkJyt6Udk7dMbczlzqooVOd8/HqSU7Yt5cCevc62tKNXv1NYyd0YC4zLUJPcAIC1ik5uT3bWK0tuK5KtNZDcAIDcxSa3L3eFpPSkrM8jyW27qKpQ7UX+o91aTnIDADKUktyReWym7GQKzkhu3zp9lxeurjE2SnIDAHKR2M8dE2nvS25vU/mUqDIAALACiXeFXVQ1OQD7nDZOOz65J9dJcgMANu+h+7n12HK7X5k6NwAAi3n0SSxd43QtPyO57R5rkhsAAKXUE56h5o769o8DFxN3RnL71hk/Qi2mDAAArFBscnurzonJ7Qbk48ltDQv33RUWQHIDAHKRkNxiQ/T1lHA/9wuSW5291W73GXDhMgAAsEIpye08JFy+yfu9yd2Xyqh590PTffejk9wAgFyktZbbE3U4VdiJ2UFGKTs558ew8vh13pl3r/nuIpPXPGuMGwAAr8EsnwAA5ITkBgAgJyQ3AAA5IbkBAMgJyQ0AQE5IbgAAckJyAwCQE5IbAICckNwAAOSE5AYAICckNwAAOSG5AQDICckNAEBOSG4AAHKyteS+nqrCpxlNz32uPQvVvjm8AQBYg60l91jXmGntaMuiOl2Nt851URTiZN4AAKwByX213z3XRVG1lwULBgDAbCS3k9wRHwQA4F1IbiG51bmmwxsAsE4kt5Tcl7aiwRwAsEokN8kNAMgJyU1yAwByQnKT3ACAnJDcjFADAOSE5OauMABATkhuJ7l9TeV/v9rD8Xg4Hg8f388sJgAACUju2Kef/ny2x8PxeDi2nz9PLSYAAAm2ltzLzTjy/ZsKNwDg/baW3Iv5/qDCDQBYAZI7zp8PKtwAgDUguaPoTm4q3ACAtyO5o3z/psINAFgFkhsAgJyQ3AAA5ITkBgAgJyQ3AAA5IbkBAMgJyQ0AQE5IbgAAckJyAwCQE5IbAICc7Du5fVNxL69r+rnJpBlFAQDw2WZyW3N9VqerPFf3+5JbKaVUVweTe7wXo8U6a4JSsh8AdmWDyd2WRVG2ozf6qMstubW2LKqyMvdIKZ3rzpsAgM3bXHKf66KonYju6qyT+9S6S5LcALBPW0tuX55ZreVDN7NEznK3Bd5biEtb2SsUQ9p80/jUvQxtWVSnq7tfvj1ty0Bbet/8ULbqXBs7Yv3fid3x7joAYGlbTG6hzu0RXed2WuCFd7SucbKtT76J5NaFdxoGdHLLC1sF0Ok7fvNcu9u9nqqirG47fmmrou70//ZFNZbX6xyXSu+O24ABAHiJrSW36iudUeO24pJbHt0mBa3/umG6zh2oQ+t6sLVAZGt519hXGNdTNb62sC41hs0NJZRaF6La+QEAS9hgcitlN/B6MyYmuUPLdLX5JzP2Jt3zz81XcZ3j/47t53Y6/q0PWtcl9iY8DRj0sgPAu2w0uQ26c1dK34jkDkeUEdXJ491uyd2WocZnYxOjGH5BcvsaG5R6++A+ANivPSS3Ur5K7QqSe3LMl1WP9zWe30sreCC5Q0huAHiDvSS3fLfYCpK7PvfDxGI2oe474hasLaU0XajODQB4k40lt3/k1NzkTunn9o3niiitfBu6UlLfuXifmLdP+oHkDpQKAPAuG0zuyHHgw/KTY6R9VU/3/cCQLqm5Pm1s+d2lrYqqbqKGmrfl/NZyeev3MkiH7u9XezgeD8fj4eNb+BgA4FFbTO5CvA/KH6jmn3TnrlvNtULaNxpcuJ/79pAT+clu0fdzu1sxC3BpK7PYoz7v+cl9O6TijePS1czPZ3s8HI+HY/v54/4VAPC4DSZ3fXaGVgXHYNsLe3p2IxdT6v48ssBILmGuMPcZavZ6RgGsF7b2y37YWd2NC9N01mwl9xvSRoXsH8HmhL2vJKbv31S4AWBZG0tuvNf3BxVuAFgYyY3n+fNBhRsAlkZy42l0JzcVbgBYFMmNp/n+TYUbABZHcgMAkBOSGwCAnJDcAADkhOQGACAnJDcAADkhuQEAyAnJDQBATkhuAAByQnIDAJATkvtZhmm4vPNo2S5tJU0jBgBAwMaSu7PmxXS5c10/07nOKbnNWUSr09WdMhwAsDYbS26lVCA+u5rk7ul5uMch3c/MTXIDwKrtKrlVW5LcSinVNUXRSMU81yQ3AKzcvpLbNVQ0A9XNrrn/vbtvoiiKoihbcdPXUxVonx+tUGjOF7L80laTy8SXM3TFILeWj3fH2aO+h6Jsh83dFrD+72g9+h3z4Hu/ssnvqN/xulNmF4BzdTJalXEEwt8XAKzK5pPb33GrT/HjSAvXOPvVds09ZuzK67kuirpuxqvtailClIquc+tyjtegg1xcZ0Q5r6fKvuAIakv7AsV953qqirK67c6lrYq60//bl9Zqlq9OrX1YxIMf/x2d66Ko21NlffXuUfK2N9DHDyATO05uSdc41WhztXXjhKgTP3Yw+BI6Krl9ffPhK5JQOf3RJW3es/D1VI3fv56qcS22a4xKrdVJoSu+wk4NYT9ZJPc7cjNeCRcN/ZvSYU/q6QCA99lqck+0rwY/6zl9i6kc9XFPykYk99WoRDp/Ei8ypsqZkNwT7er3P1mFsTYhJLfn8qhrIhqrxYPsP/Jyb4XUkE47OYAsbDW5Z9a5p5J7qk6Wkh8xyR1K2bl1x/jkDrerj6MuObk9BYhqyX84uYXKPRVuAPnYdXJbA68mhkq9K7lDck1uX+3W3WLsd5R05J0yJPUgAMB7bT65vdpSSr6M6txpZbiLH6H29jp3wneUmNzG8m9/JA4ApNhpcnv7j1eW3HNacac/YnRRh7y1nzvtO0pN7lGpqHADyMuOk1sKj7Z8YWt5XB+8t21ZHDgdX05Pdlqx6ks16/3k5I7ofk77jtKTu//I1Lfw96s9HI+H4/Hw8e1fCgBeZqfJrWNvfE4f9ae+LLmNW65H70iPOhEe+RJ4Dtp0Nd26j+u+TuezbuO2e1/WjH5ue7XujdpJ39GM5NYlKSf6Dn4+2+PheDwc28+fwGIA8DIbS25xxhFPe6/9YDLzCVxDqNiL+cZJmZse3zwdLIk9Bi3QARweohVbztBHfFXPYCGNHddr6Je/7W//5LJbMYxm6nAho74j88gPMTy+OTB0j/5Es8f3byrcANZlY8mNDKzozunp9onvDyrcAFaG5MarrSe5p0vy54MKN4C1IbnxamtJ7ogBAbqTmwo3gFUhufFqK0numCetfv+mwg1gdUhuvI77QLQXR7j4TLo1XEYAQDySGwCAnJDcAADkhOQGACAnJDcAADkhuQEAyAnJDQBATkhuAAByQnIDAJCTfSf3pa18M4ktbHgkyOT83A8Z5toKTmSZtiQA4K22mdzWs7qq09WaMfrmfcmtlNLTU04ltzBvaWrYW5NnP2VJAMC7bDC529KqOPbhl2Vyj5ZuiqLp5EuQIJIbALZkc8ktTwDV1dknd79weplJbgDYkq0lty97rKqqOPPE0Lgu5qLbAu8txNBnfF+hGNLmm8annDKMrkjCc2215WjLTRc4JjFLjg5Ufz107tvv3XUKO+49SOZX4DtEaUsCwB5sMbmnJl2+i66/Oi3wwjta1ziJ1efZRHLrwntawsdp7a0ZX9rKvKTQhakbZ/n4JbX+uqFr7hFut9vrRB+/o3dc2KOutoI/eIjilgSAvdhacqu+Khl1Zo9Lbl/Xshu0/uuG6Tp3qKXaKqdcbE9NVAeq0/Eft+T4T3XdOMF8/79dLbdDSNvy92jMXxIAdmODya2U3WzrPcvHJHdoma42/xRux5Y+fitb14Rux3JD3d1QIPit5oH4Je/c+rRbQk9Th7Q5X8y74pcEgL3YaHIb9NhyKX0jkjs8aMtI0OSxY7fkbsuJ4eIxOd013oSzFo5f8k6u+xpb9+6C57AYvezBeI5fEgD2YA/JrZSvUruC5J4cyeUM+5LHfwWq+9YuxC95F5PcIdOHxVvdf2BJANikvSS3nD0rSO7+Ri9vLgZGhltDzFZa54422fYwY0kA2J6NJbd/7NLc5E7p507tlB2V1h+N3iqy+ZHl+7mDI/YnF4jAfecAEGODyR05DnxYfnKUsq9C6b4fGKglNddHjC2fuG4YF37xseXhYPZeYVzaytycb0n3eMYvefP3qz0cj4fj8fDxHSwtAORri8ntxM9EoJp/0l22VmC4zbO+0eDC/dy3R5dM393kXl6EW6Htvy5/P3eQc++1kgel30acRVz0xC+p/Xy2x8PxeDi2nz8ThQWAbG0wueuzM2Aq2LJqL+xJysjFlBo9Zcw/PkuYK8x6htrZGpg2ziprGhJ7qJq148PT34TLkfCS3sFxRegesKnFdE065juKX1L7/k2FG8D2bSy5sWffH1S4AewAyY2t+PNBhRvAHpDc2AjdyU2FG8DmkdzYiO/fVLgB7ALJDQBATkhuAAByQnIDAJATkhsAgJyQ3AAA5ITkBgAgJyQ3AAA5IbkBAMgJyQ0AQE5I7ncx5/sKzDwGAMDI1pLbmWXy4XS0p+ycmOZyhvAk3AAAjG0tuceemIh6omjjrXNdjGfXfgDJDQCIR3JHEZJb6fCu2sujKye5AQDx9p7cXTNuAK/aS1dLNWk5ucVNXFqzvX462kluAEC8PSd3VxdFUbb3N/rQjU9uda6NDm/dKT7eqF5nMJhJbgBAvB0ntxW6/YeS6tzq0lb3WnVXF+Ji8jpjywkAwMiOk9sbtIKY5L6eKt+A8+upMir3aeUEAOBuz8mtlFJtaXZKe4I8JrlDmzOq5nPKCQCAtvfktrRlIVaOY5M7hOQGADwByW1rS+FTMSPUZgcwyQ0AiEdy28Q+6ai7wuQhb0uVEwCwT/tN7oRbtH0LO73XwUZ17/DyqOT++9UejsfD8Xj4+J5YFACwZbtObvdh5r7x4dFPP3XuEVfSTd4p5dR+Ptvj4Xg8HNvPn/CSAIBt21pyx884osPYHlbmDk9Ln3HEKYOzpP2ctek1f/+mwg0AUGp7yb1R3x9UuAEASimSOw9/PqhwAwA0kjsDupObCjcAQJHcWfj+TYUbAHBDcgMAkBOSGwCAnJDcAADkhOQGACAnJDcAADkhuQEAyAnJDQBATkhuAPnTcwEwWy72geQGkD+SG3uy3eRuClUUqigU/5hXa9HvaJiQrZ//bZjDTZ5DPWvOVPG789zkzuV4vq+cwyyLzkzHb/Pz2b7sWZNf/xyPv9/5WMsdJLd7mr60tz/dXvXt/bIw3n/7L/JUSYXpzMKvoJyzBb6jJ7meKmvmVmGq9dezpo4tWz2z+/yT4OQZ3J5Y9jaT7G2W+uHdFfyW7Il333KxNZ2InW/238D8v/GsmYJv8xG71yVvvsKI+tHGzrycPp+y4e9XK03usNTW/3wcD8ePPzElW8R2k3uIPd8Pq/FU9U6VcmfpfqOyUKVUpLWVc4bJ7+hhK0zutrRPB8PJZcHkVkrpUJR+8+5RWoN3flORiXiu3TN71xTFY2naloX5dfRXCXkmt/EBzy9wIHzp5zrmn0bM5A7P3frXP8fjP18TxVrMdpP7XKuiUEWlfD/rjJL71ArxtrZyzjD5HT1sbcndNYUvI9uS5DZkmtwqIiHS19nVu01upY9JcDc9Fe5lt/7Wavd2k/vWJF57F0hN7mbcRl2pSydXFu2meE8sNU5b/S3GCnvrZaFOV6FUvnKG2vy7+yaGzelfqvV/Z+xR0lEy1uz/jhIZbb9Np4LJbbbKelvk3HbL+eVLPc/aTdzCZ8W2Zd/yqcltrrxqL54zdUQ5zbX1R3toopS2HpfcZqv1VF5O7lHS8fQlt3U8Rz9LYw3jn9awp6HvYrR3aeV0NleEf8nCFyp+9eabxqf8v4EZ2Tn1wZ/P9nhov/4GVrzE1r8/Dm/r7d5uct9S6inJ3dmBOoSZ9VPW+TderV7S93M517cSNqOiWgXTya2cCHTLqbc+flO/I1TWq1sAX1pV1Lf/HUp7dtYZtUfRR8n6iPwdfX8cjseJ16hx7NJW5slIN1rWjZjcbW2mhT4PupnktFsK78RLq9rqVDOPvHcQ1vPr3J11iIbzsn2Uksqp7mnXNcUQe2LBUuvcU+fl6D1Sj9a529Iuib9sdiJeT1VCT3n0tWD8L1lo7fceKKnwwWicnZ2+Q61FNlw/fetvnH95w8mtVBkctByf3EO+GtzaZOcZbOWvd+o1N040CsntFCyytbxxKvGnyqg3N2Y1uhzvQsoexR4lU/g7iuWpC+pQcU9YUq64Z8xQzs0qc0ojalfLtaJArfepye1vszW3nljOfs1144T90skdu0d9eeYmtzuOIbRC7xriWqEf/97N9/3XDdN17pgL0/nZGdjTv19tXN336Vv/+Wzf1WC+6eQOS61zT55ETpW3iu9LWbdG6xpH6fi/I5PbDVTrg3IVv18yYY/ijtICAqcMuarhuXg3/t2GzoldPatzMT65AxUveWeXqXNPBmdyOZVUR/dYos4du8KE5I5trE5rVzDbq70pHlPOlF9y4jG/J3dgAIfxgSWS+8/HMaKTe5GtR2/66UhuR2T/sfsF+1aodLux1D0s11Od7Q7bGi//guSesUeTR2kBXeM93Yj93L5/veOFwxWIeYOn4pM7tKR4EllmhJp1z5i7y8nlVBPNntbWn5rct3VG9fU+0lquQ1e+ujIXjj0Uui9fKk9EORN+ycnj3W7JHfg3ZX+A5H4SktsRmYil0wrdmKFlv56R3MrfeD4UXtj0A8mdukdu4Wf2Cif0cwdO8Uljy1+f3FaQFOMaTMiLktviNmAkl1M9mtyBos4Y0e0dtfBYP7evfm/tUVKB5UrtCpI70MwgfIDkfpJ9J7f4JcXfbWX10QZqqD4zknv4iFvOUkrTherc8Z7Tkx2SS507uE6jyzA5hKKTWyx2/NA56+jNuf1pTcmtfL+HR5PbU87x8qkx6a3fv7/OLTQn+D6wxAi1FyS3b+sk9xucKjlR4uPKisCYGLbMSG7luU/M1yf9SHLP2CPX8ved59LPHTzBmSOAouNttObpIvnG1qV1wJu/+eRHhq0suR8ZN5Cc3NZNidINGuGRfTOSO+WXnDIUwCpt3Ne6yF1hy49Q832QEWrvIPfUSmOh3ezU3Iz3LenebaXNS25d8iZuqHn5QGu5uPV7Gcw9ij9Kz/eEseXuqcf3zzXw7//7960l33cZHn93UHjs0uT9OTL5JC58Nv4UlljOtyV34kk57nj698XbtHP7iG/9nieueK+6osoZ/0sODDmUmutfNbZ86gJl2bvC/FvnrrA3se6P0rHtfrWlNCuGXMd17mlWwQHk85Jb9T3Q7s3T4yXvfd4PJHf8HiUcpQU8dj/39VSJfXXyjbm+05O+9tcv/3lE7lsVHrLo3H/cL+Y9C7tXHk4VytlTOSrE6xvPaT2tnG9M7ug96tc2eTwD93P797Eti6r07UXfc2z+9dFypvyShfu5b0Pop++pW+R+7oinny74JJbQ1nkSyxtZDwgTvyEdZtZwrcDVpT1MzIku+6lknoWH55q5f9JrsMogzqQyrKTplDVbid7ZxhxuVnrCPrxHM47SAowBX2WrzPnBrLnCjNFV/nLag7CC//In69yaNAuCv9E1YrG0okbccaRPYfYK/Udpupz2Y7m8C0+NehsVI7ROe7WpezR1PAMzjkzdHxUKg1sWPq+cyYsNJRwJPbxv8hlqr5hxxP/00wW3ztNPAWAvZgwOwJTXN1wz4wgA7MXbZ6vbprhJR56GWT4BYC+ocC/m57N9WbX765+39XBrJDcAvEjg2QNAPJIbABYkjrkjv/EIkhsAgJyQ3AAA5ITkBgAgJyQ3AAA5IbkBAMgJyQ0AQE5IbgAAckJyAwCQE5IbAICcxCZ37ZuUsn9VJ6Uuqgr81eN6Mpa0ppPrmv5PpfDZtuz/2sTvMgAAGUupc59VUSjxWfn1OJulxdpSDld9QXBf+CzE8PWkilJVTqjrhasydFkAAMDGPCe523IiuZVSdaGsyeTlOL+oyqyj6+TuGjuhu0YVjblpAAC27jnJHbOYDtqBbiQX12b9SSe3u1p9KUByAwB2ZX5yu3VocbGBldzhxB03v9+SW6m2vG9x/CbJDQDYj1cl90VV4+UvUr/1yDjmh5Ae/kONApvkBgDsSnJyj1+xye10XU8m9zikx/9d60+NPk5yAwB2Zak6t/WyQ3pucuu6eNcIlW8AAPZg+dbys1Q7n9VaPqxtvEKSGwCwKy8ZW251ciulZo1QGz44Xj/JDQDYlVfdFea8mXxXmAfJDQDYlbfdz6107dmNZM+TWHxIbgDArrwuucU28/inn/qQ3ACAXXloxhFxxHhgopHb5CKl9KZnnbXvPjRrBLs/2gEA2BJm+QQAICckNwAAOSG5AQDICckNAEBOSG4AAHJCcgMAkBOSGwCAnJDcAADkhOQGACAnJDcAADkhuQEAyAnJrdSlrYqiaKbnUgEA4O1IbpIbAJATknuvyX1pq6KyZ3t7ia4pNGvK16VdT5XebnW6xn2iq4uRvf1CAKzVlpLbPM8a6uVPuoGtF0VRFGW7eBGUUqN8GlKqa6TUeV9yK6X04Qon9xDw3i91VvC3ZXxym4UhuQGsw5aSWyml1Ll2c7priuI1KSVtXek0fUlyt6V1idBfT2Sa3KNim4k7/XEfkhtA7naR3OplZ973Jre89a4muUdIbgC520tyS9mZ1ovptkLHb901agrulz/3xenLafXLtuVE+7/v+sBKnWArtJzlUfuu6UEDxgrFlDXfND51K8OM5DYPkRztw3rM4zDxrU0nt7DjwTUCwFx7Se62DJ15J8/LTiu08I6z9Yh6Yb9819zDQ0qs1q43n2s3ma6nKqFHP7rOHbvvYq9En2cTya0Lb34FXWNcIkwkt77uGZdKOkRqfDxHC+sUD3xZE78QvfXxAvsc9gjgJXaR3G05UakKn5d9f3XDZl5y141z0jeTW67mXtpK3tO4ZuS45I7fd/91w3SdO6Y3YUYrd9cIVxi3ermzU+HrnuAvpKvldoj5TfoAELDJ5I5tBB6EzsuhhOtq60/O1iOSO7m6Py62J9EjChCT3Cn7npis91QT89U1p3868TIusInALyQQ+S8bmQhgVzaZ3M5pVIeZ/xw6cV72f9A+189tLQ8ItPNHBIPuy5fSNyK5E/Y9ebzb7eCEezG8m4vkS+704xn4hcy97AOAmfaR3Er5mzSVWn1y+4odWaWTK7UrSO6kkVyTyW0No/MNPZt3PCeSO4TkBvBk+0numeflB5Lb2IKc4ovXuf1bWUFy12e5t356c9JfhYx8e50bABZAciv15H7ulBp/ZHJH9XP7q/hzkztl30NNGp6P96WNu5Vuoq4sruEl/dzxtwICwFPsKLkDla15Y8uF9xdK7qix5Z4nrohj4PvlJ0c+x+97YKCW1Fz/zLHlvo+LIe0bWx7+LsK/EG/ZLm3F8HIAz7aX5A7fGBZ1P7dzt/HU/dzG4o8kd3W62gUQblbue47NUk0Eqvkn3WVrlTN238X7uW+D7eUnu4Xv57aEWssvbWUWe9TnLfZz2/dzX09VuEN66hfS1c6Rj7lxAABm2FJyB+f8sM6q9hOvJoY1KXcgkn1GnppxpLB6hWM3Hf3Mr1sW2uUM1mWndiptMaXc++KEOBTmCpOeoRY6qvLDXJ3jMxSm6ZTzTDpjp+QRfAGeZ9hNLQMAj9tScm/TvOdsAwC2iuReO5IbADBGcq8dyQ0AGCO5147kBgCMkdzr5T4UjAgHAJDcAADkhOQGACAnJDcAADkhuQEAyAnJDQBATkhuAABy8v9+kMRKTpshLQAAAABJRU5ErkJggg==" alt="" />

仓库信息列表的显示列：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="StockTableList.aspx.cs" Inherits="BioErpWeb.StockSystem.StockTableList" %>

<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>

<!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" />

</head>

<body>

    <form id="form1" runat="server">

    <div>

       <table class="maintable">

         <tr>

             <td class="titlebar">

                 <span>仓库信息管理系统</span>

             </td>

         </tr>

         <tr>

             <td>

                 <asp:GridView ID="GridView1"  AutoGenerateColumns="False" Width="800px"

                     runat="server">

                     <Columns>

                         <asp:TemplateField HeaderText="编号">

                             <ItemTemplate>

                                 <asp:Label ID="Label1" runat="server" Text='<%# Eval("ID") %>'></asp:Label>

                             </ItemTemplate>

                         </asp:TemplateField>

                         <asp:TemplateField HeaderText="仓库名">

                             <ItemTemplate>

                                 <asp:Label ID="Label2" runat="server" Text='<%# Eval("StockName") %>'></asp:Label>

                             </ItemTemplate>

                         </asp:TemplateField>

                         <asp:TemplateField HeaderText="地址">

                             <ItemTemplate>

                                 <asp:Label ID="Label3" runat="server" Text='<%# Eval("StockAddress") %>'></asp:Label>

                             </ItemTemplate>

                         </asp:TemplateField>

                         <asp:TemplateField HeaderText="所属公司">

                             <ItemTemplate>

                                 <asp:Label ID="Label4" runat="server" Text='<%# Eval("FarhterCompany") %>'></asp:Label>

                             </ItemTemplate>

                         </asp:TemplateField>

                         <asp:TemplateField HeaderText="管理员">

                             <ItemTemplate>

                                 <asp:Label ID="Label5" runat="server" Text='<%# Eval("UserNames") %>'></asp:Label>

                             </ItemTemplate>

                         </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>

                            <ItemStyle HorizontalAlign="Center"  Width="120px"/>

                         </asp:TemplateField>

                     </Columns>

                 </asp:GridView>

             </td>

         </tr>

         <tr >

             <td>

                 <webdiyer:AspNetPager ID="AspNetPager1" runat="server">

                 </webdiyer:AspNetPager>

             </td>

         </tr>

     </table>

    </div>

    </form>

</body>

</html>

把查询的数据放入视图中：

create View [View_StockList]

  as

  select

    ID,

	[FarhterCompany]=[dbo].[getCompanyNameByCompanyID](FarhterCompany),

	[StockAddress],

    [IsDel],

	'UserNames'=[dbo].[GetUserListByStockID](ID)

	from

	 [dbo].[BioErpStockTable]

对应的公司名称（标量函数）：

-- Description:	根据公司编号返回公司名称

-- =============================================

ALTER FUNCTION [dbo].[getCompanyNameByCompanyID]

(

	@ID int

)

--返回的值

RETURNS nvarchar(100)

AS

BEGIN

	-- Declare the return variable here

	DECLARE @companyname nvarchar(100)

	-- Add the T-SQL statements to compute the return value here

	SELECT @companyname=CompanyName FROM BioErpCompanyTable WHERE ID=@ID

	-- 返回变量

	RETURN @companyname

END

显示的代码：

 public partial class StockTableList : System.Web.UI.Page

    {

        static string Condition = "";

        static int pageindex=0;

        static int pagesize = 8;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                getStockList();

            }

        }

        /// <summary>

        /// 获取仓库信息列表

        /// </summary>

        private void getStockList()

        {

          this.GridView1.DataSource=  SqlComm.getDataByPageIndex("View_StockList", "ID,StockName,FarhterCompany,StockAddress,IsDel,UserNames", "ID",Condition, pageindex, pagesize);

          this.GridView1.DataBind();

        }

    }

秒客网

ERP仓库管理系统（九）

相关文章