计件工资管理系统表

1、维护[人员信息]和[工序设置]表。2、[录入]表双击选择日期，工序，操作人信息，其他手录，点击保存，数据自动存储到数据库，清除录入界面的数据。3、[工资查询]和[工序查询]表，点击查询按钮，选择截止日期和项目，进行统计分析。4、[工资汇总]，点击查询按钮，选择截止日期，自动生成报表。5、插件下载地址:https://pan.baidu.com/s/1dF7VJKP。必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,,2018-5-1- 2018-5-28工资汇总表,编号姓名工种入厂时间保底薪资考勤/天请假款式19900款款式3款式4款式5款式6款式7款式8款式9款式10款式11款式12款式13款式14款式15款式16款式17款式18款式19款式20款式21款式22款式23款式24款式25款式26款式27款式28款式29款式30计件薪资应发其他扣款实发备注,1.0林淑霞A1000.0,2.0邓丽平B1000.0,3.0邓晓菊,4.0吴言波,5.0卢玲,6.0郑素琴,7.0郑丽琼,8.0郑春连,9.0曾强,10.0符勇,11.0符金金,12.0郭书琴,13.0孙怀宗,14.0,15.0,16.0曹伟,17.0尚德会,18.0吴秋仙,19.0,20.0,21.0高占英,22.0林玉叶,23.0彭剑武,24.0张晓帆,25.0吴燕英,26.0张美容,27.0曾吓花,28.0黄丽英,29.0翁翠媚,30.0黄美香,31.0陈建国,33.0董银香,34.0周雪花,35.0谢双,36.0许国柱,37.0左三霞,38.0普显梅,39.0林美华,40.0陈秀芳,41.0李云慈,42.0龙运全,43.0刘亚,44.0刘嘉菲,45.0周玉,46.0周波,47.0关晓丹,48.0徐仕梅,49.0金美兰,50.0张勇,51.0颜历冰,52.0蒋杰,53.0陈雪梅,54.0杨惠,55.0徐海兰,56.0李细花,57.0张亮亮,58.0李腾飞,59.0倪红兵,60.0杨玉梅,61.0张美兰,62.0蔺忠,63.0田维,64.0高秀青,65.0谢敏,66.0池秀连,67.0李忠琼,68.0陈淑琴,69.0姚元桂,70.0贺红梅,71.0陈秀清,72.0吴友情,73.0梁剑兰,74.0方万兴,75.0郑丽梅,76.0方亚妹,77.0郑冬英,78.0,79.0刘美容 临时,80.0林碧露 临时,81.0翁春兰,82.0余金玉 临时,83.0余德钦 临时,84.0,85.0,86.0,87.0,小计:,日期款式工序编号工序编号操作人数量工序单价合计,43249.0,编号姓名工种入厂时间保底薪资,1.0林淑霞A1000.0,2.0邓丽平B1000.0,3.0邓晓菊,4.0吴言波,5.0卢玲,6.0郑素琴,7.0郑丽琼,8.0郑春连,9.0曾强,10.0符勇,11.0符金金,12.0郭书琴,13.0孙怀宗,14.0,15.0,16.0曹伟,17.0尚德会,18.0吴秋仙,19.0,20.0,21.0高占英,22.0林玉叶,23.0彭剑武,24.0张晓帆,25.0吴燕英,26.0张美容,27.0曾吓花,28.0黄丽英,29.0翁翠媚,30.0黄美香,31.0陈建国,32.0董银香,33.0周雪花,34.0谢双,35.0许国柱,36.0左三霞,37.0普显梅,38.0林美华,39.0陈秀芳,40.0李云慈,41.0龙运全,42.0刘亚,43.0刘嘉菲,44.0周玉,45.0周波,46.0关晓丹,47.0徐仕梅,48.0金美兰,49.0张勇,50.0颜历冰,51.0蒋杰,52.0陈雪梅,53.0杨惠,54.0徐海兰,55.0李细花,56.0张亮亮,57.0李腾飞,58.0倪红兵,59.0杨玉梅,60.0张美兰,61.0蔺忠,62.0田维,63.0高秀青,64.0谢敏,65.0池秀连,66.0李忠琼,67.0陈淑琴,68.0姚元桂,69.0贺红梅,70.0陈秀清,71.0吴友情,72.0梁剑兰,73.0方万兴,74.0郑丽梅,75.0方亚妹,76.0郑冬英,77.0,78.0刘美容 临时,79.0林碧露 临时,80.0翁春兰,81.0余金玉 临时,82.0余德钦 临时,行号日期款式工序编号工序编号操作人数量工序单价合计,1.043221.09900款12.09900款12 反口里压线1.0林淑霞2.00.180.36,2.043226.09900款5.09900款5 车后上片4.0吴言波5.00.482.4,款式工序编号工序价格,1.09900款1 鞋头后补强万能0.32,2.09900款2 车鞋口片0.4,3.09900款3 车眼片前内外0.38,4.09900款4 车眼片后内外0.35,5.09900款5 车后上片0.48,6.09900款6 前片接片内外结合,7.09900款7 车鞋头双针0.95,8.09900款8 鞋头后车接片单针0.46,9.09900款9 车腰花0.5,10.09900款10 车鞋身标0.6,11.09900款11 车鞋身双针0.92,12.09900款12 反口里压线,13.09900款13 车反口里0.38,14.09900款14 车港宝0.19,15.09900款15 整戈鞋面压边线0.3,16.09900款16 车舌面织带,17.09900款17 舌上舌下结合,18.09900款18 车舌面织标0.34,19.09900款19 舌面里车合0.22,20.09900款20 舌面车双针,21.09900款21 结舌单针叠针0.4,22.09900款22 缩头,23.09900款23 鞋口修边,24.09900款24 鞋身内前内后结合,25.09900款25 鞋头面内里贴合0.24,26.09900款26 贴后眼片下饰片内外,27.09900款27 贴鞋口片补强,28.09900款28 后领口鞋身过胶贴合,29.09900款29 接片擦胶捶平,30.09900款30 接片内外贴补强,31.09900款31 鞋头里前抚平贴合0.06,32.09900款32 鞋身内外腰结合,33.09900款33 鞋身擦胶捶平,34.09900款34 贴鞋身内外标0.26,35.09900款35 贴鞋身外腰补强0.12,36.09900款36 贴鞋身内腰前补强,37.09900款37 贴鞋身内腰后补强,38.09900款38 包泡棉0.45,39.09900款39 冲孔0.42,40.09900款40 裁舌面织带0.02,41.09900款41 贴舌泡0.07,42.09900款42 翻鞋舌,43.09900款43 定型0.33,44.09900款44 穿鞋带0.47,林淑霞 -工资明细表,日期：43221.0至43248.0,日期款式工序编号工序编号操作人数量工序单价合计,43221.09900款12.09900款12 反口里压线1.0林淑霞2.00.180.36,合计2.00.36,9900款12 反口里压线 -工序明细表工序,>=2018-5-1<=2018-5-242017 大面后跟万能,日期：43221.043248.0至43244.0,款式工序编号工序编号操作人数量工序单价合计,43221.09900款12.09900款12 反口里压线1.0林淑霞2.00.180.36,合计2.00.36