 MySQL Backup
 Source Server Version: 5.0.22
 Source Database: jsh_erp
-Date: 2017-09-21 23:28:00
+Date: 2017-09-26 22:48:49
 */
 
 SET FOREIGN_KEY_CHECKS=0;

INSERT INTO `jsh_assetcategory` VALUES ('14','递延资产','1','递延资产'), ('15','无形资产','1','无形资产'), ('16','长期投资','1','长期投资'), ('17','固定资产','1','固定资产'), ('18','流动资产','1','流动资产');
INSERT INTO `jsh_assetname` VALUES ('1','联想Y450','17','1','','1'), ('2','惠普打印机','15','1','','0'), ('12','乐萌水杯','16','1','','1'), ('13','机顶盒','17','1','机顶盒','0'), ('14','TCL电视','17','1','','1'), ('15','手机','17','1','','1'), ('16','硬盘','16','1','','0'), ('17','毛笔','17','1','','0'), ('18','杯子','17','1','','0'), ('19','建造师证书','15','1','','0'), ('20','算量软件','14','1','','1'), ('21','cad软件','15','1','','0'), ('22','办公桌','17','1','','0'), ('23','笔记本','17','1','笔记本','1'), ('24','打印机','17','1','打印机','0'), ('25','电脑','17','1','电脑','0'), ('26','电动车','16','1','电动车','0'), ('27','电源线','17','1','电源线','0'), ('28','电源线666','17','1','','0'), ('29','电源线777','17','1','','0'), ('30','电源线8','17','1','','0'), ('31','电源线9','17','1','','0');
INSERT INTO `jsh_depot` VALUES ('1','上海花边店','地址222','33','22','0','2','上海33'), ('2','公司总部','地址12355','44','22.22','0','1','总部'), ('3','苏州花边店','地址666','31','4','0','3','苏州'), ('4','1268200294','',NULL,NULL,'1','1',''), ('5','1268787965',NULL,NULL,NULL,'1','3',''), ('6','1269520625',NULL,NULL,NULL,'1','2','');
INSERT INTO `jsh_depothead` VALUES ('7','入库','采购',NULL,'GHDD201708120002','GHDD201708120002','季圣华','2017-08-12 12:04:07','2017-08-12 12:03:23','1',NULL,'12','-30',NULL,'-36','现付','abcdefg','',NULL,NULL,'10','3.6','32.4','30','[\"10\",\"9\"]','[\"10\",\"20\"]','45',''), ('8','出库','销售',NULL,'XHDD201708120001','XHDD201708120001','季圣华','2017-08-12 18:10:14','2017-08-12 18:09:45','2',NULL,'11','17',NULL,'24','现付','','<7>,<6>',NULL,NULL,'22','5.28','18.72',NULL,NULL,NULL,NULL,'\0'), ('9','入库','采购',NULL,'GHDD201708120003','GHDD201708120003','季圣华','2017-08-12 21:01:09','2017-08-12 21:00:36','1',NULL,'11','-100',NULL,'-120','现付','','',NULL,NULL,'10','12','108',NULL,NULL,NULL,NULL,''), ('10','入库','采购',NULL,'GHDD201708120004','GHDD201708120004','季圣华','2017-08-12 21:10:42','2017-08-12 21:10:16','1',NULL,'4','-10',NULL,'-12','现付','','',NULL,NULL,'10','1.2','10.8',NULL,NULL,NULL,NULL,''), ('11','入库','采购',NULL,'GHDD201708120005','jshenghua001','季圣华','2017-08-12 22:07:44','2017-08-12 22:06:37','1',NULL,'12','-20',NULL,'-24','现付','','',NULL,NULL,'10','2.4','21.6',NULL,NULL,NULL,NULL,''), ('12','入库','采购',NULL,'GHDD201708120006','GHDD201708120006','季圣华','2017-08-12 22:17:11','2017-08-12 22:16:35','1',NULL,'11','-10',NULL,'-12','现付','','',NULL,NULL,'10','1.2','10.8','0','[\"undefined\"]','[\"undefined\"]',NULL,''), ('13','入库','采购',NULL,'GHDD201708120007','jishenghua3','季圣华','2017-08-12 22:17:52','2017-08-12 22:17:14','1',NULL,'4','-20',NULL,'-24','现付','','',NULL,NULL,'10','2.4','21.6',NULL,NULL,NULL,NULL,''), ('14','入库','采购',NULL,'GHDD201708120008','jishenghua004','季圣华','2017-08-12 22:19:37','2017-08-12 22:19:07','1',NULL,'11','-30',NULL,'-36','现付','','',NULL,NULL,'10','3.6','32.4','0','[\"undefined\"]','[\"undefined\"]',NULL,''), ('16','入库','采购',NULL,'GHDD201708120009','jishenghua005','季圣华','2017-08-12 22:26:23','2017-08-12 22:25:14','1',NULL,'10','-20',NULL,'-24','现付','','',NULL,NULL,'10','2.4','21.6','0','[\"undefined\"]','[\"undefined\"]',NULL,'\0'), ('17','入库','采购',NULL,'GHDD201708120010','GHDD201708120010','季圣华','2017-08-12 22:28:20','2017-08-12 22:28:02','1',NULL,'9','-30',NULL,'-36','现付','','',NULL,NULL,'10','3.6','32.4',NULL,'[\"undefined\"]','[\"undefined\"]',NULL,'\0'), ('18','入库','采购',NULL,'GHDD201708120011','GHDD201708120011','季圣华','2017-08-12 22:30:08','2017-08-12 22:29:48','1',NULL,'4','-20',NULL,'-24','现付','','',NULL,NULL,'10','2.4','21.6',NULL,NULL,NULL,NULL,'\0'), ('19','入库','采购',NULL,'GHDD201708120012','GHDD201708120012','季圣华','2017-08-12 22:30:57','2017-08-12 22:29:32','1',NULL,NULL,'-10',NULL,'-26.4','现付','','','[\"4\"]','[\"10\"]','10','2.64','23.76',NULL,NULL,NULL,NULL,'\0'), ('20','入库','采购',NULL,'GHDD201708120013','GHDD201708120013','季圣华','2017-08-12 22:46:43','2017-08-12 22:45:55','1',NULL,'10','-23',NULL,'-36','现付','','',NULL,NULL,'20','7.2','28.8',NULL,NULL,NULL,NULL,''), ('21','入库','采购',NULL,'GHDD201708120014','GHDD201708120014','季圣华','2017-08-12 22:46:52','2017-08-12 22:45:59','1',NULL,'11','-20',NULL,'-26.4','现付','','',NULL,NULL,'10','2.64','23.76','0','[\"undefined\"]','[\"undefined\"]',NULL,'\0'), ('22','入库','采购',NULL,'GHDD201708120015','GHDD201708120015','季圣华','2017-08-12 23:49:32','2017-08-12 23:48:24','1',NULL,'11','-20',NULL,'-24','现付','','',NULL,NULL,'10','2.4','21.6',NULL,NULL,NULL,NULL,'\0'), ('23','入库','采购',NULL,'GHDD201708140001','GHDD201708140001','季圣华','2017-08-14 20:41:54','2017-08-14 20:40:49','1',NULL,'4','-300',NULL,'-360','现付','','',NULL,NULL,'10','36','324',NULL,NULL,NULL,NULL,'\0'), ('24','入库','采购',NULL,'GHDD201708150001','GHDD201708150001','季圣华','2017-08-15 21:36:25','2017-08-15 21:35:38','1',NULL,'11','-675',NULL,'-750','现付','','',NULL,NULL,'10','75','675',NULL,NULL,NULL,NULL,'\0'), ('25','入库','采购',NULL,'GHDD201708150002','GHDD201708150002','季圣华','2017-08-15 22:31:46','2017-08-15 22:29:47','1',NULL,NULL,'-33',NULL,'-75','现付','ababab','','[\"9\",\"10\"]','[\"22\",\"11\"]','10','7.5','67.5','22','[\"10\",\"8\"]','[\"11\",\"11\"]',NULL,'\0'), ('26','入库','采购',NULL,'GHDD201708160001','GHDD201708160001','季圣华','2017-08-16 23:50:35','2017-08-16 23:47:42','4',NULL,'9','-162',NULL,'-150','现付','','',NULL,NULL,'10','18','162',NULL,NULL,NULL,NULL,'\0'), ('27','入库','采购',NULL,'GHDD201708180001','GHDD201708180001','季圣华','2017-08-18 00:25:58','2017-08-18 00:25:43','1',NULL,'11','-74.25',NULL,'-75','现付','','',NULL,NULL,'10','8.25','74.25',NULL,NULL,NULL,NULL,'\0'), ('28','入库','采购',NULL,'GHDD201708270001','GHDD201708270001','季圣华','2017-08-27 23:10:44','2017-08-27 23:06:05','46',NULL,'10','-64.8',NULL,'-72','现付','','',NULL,NULL,'10','7.2','64.8','10','[\"10\"]','[\"10\"]',NULL,'\0'), ('29','出库','销售',NULL,'XSCK201708280001','XSCK201708280001','季圣华','2017-08-28 23:06:40','2017-08-28 23:05:11','2',NULL,'11','117',NULL,'130','现付','','<7>',NULL,NULL,'10','13','117',NULL,NULL,NULL,NULL,'\0'), ('30','入库','销售退货',NULL,'XSTH201708280001','XSTH201708280001','季圣华','2017-08-28 23:13:08','2017-08-28 23:12:48','2',NULL,'10','-48',NULL,'-48','现付','','<5>,<6>',NULL,NULL,'0','0','48','0','[\"undefined\"]','[\"undefined\"]',NULL,'\0'), ('31','出库','采购退货',NULL,'CGTH201708280001','CGTH201708280001','季圣华','2017-08-28 23:15:45','2017-08-28 23:15:21','1',NULL,'10','28.6',NULL,'26','现付','','',NULL,NULL,'0','0','28.6','12','[\"10\"]','[\"12\"]',NULL,'\0'), ('32','入库','其它',NULL,'QTRK201708280001','QTRK201708280001','季圣华','2017-08-28 23:17:55','2017-08-28 23:17:33','1',NULL,NULL,NULL,NULL,'12','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('33','出库','其它',NULL,'QTCK201708280001','QTCK201708280001','季圣华','2017-08-28 23:21:14','2017-08-28 23:20:36','2',NULL,NULL,NULL,NULL,'65','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('37','出库','调拨',NULL,'DBCK201708280002','DBCK201708280002','季圣华','2017-08-28 23:56:34','2017-08-28 23:56:10',NULL,NULL,NULL,NULL,NULL,'1.3','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('38','出库','调拨',NULL,'DBCK201708290001','DBCK201708290001','季圣华','2017-08-29 00:20:11','2017-08-29 00:19:58',NULL,NULL,NULL,NULL,NULL,'2.6','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('41','出库','零售',NULL,'LSCK201708290002','LSCK201708290002','季圣华','2017-08-29 23:29:39','2017-08-29 23:29:06','7',NULL,'10','42',NULL,'42','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('42','出库','零售',NULL,'LSCK201708290003','LSCK201708290003','季圣华','2017-08-29 23:35:12','2017-08-29 23:33:21','7',NULL,'11','11',NULL,'11','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('43','出库','零售',NULL,'LSCK201708290004','LSCK201708290004','季圣华','2017-08-29 23:39:44','2017-08-29 23:39:28','7',NULL,'9','12.1',NULL,'12.1','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('44','入库','零售退货',NULL,'LSTH201708290001','LSTH201708290001','季圣华','2017-08-29 23:48:43','2017-08-29 23:46:35','7',NULL,'10','-2.2',NULL,'-2.2','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('45','入库','零售退货',NULL,'LSTH201708290002','LSTH201708290002','季圣华','2017-08-29 23:51:55','2017-08-29 23:51:31','7',NULL,'12','-3.3',NULL,'-3.3','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''), ('48','出库','零售',NULL,'LSCK201708310001','LSCK201708310001','季圣华','2017-08-31 00:30:31','2017-08-31 00:29:10','7',NULL,NULL,'12',NULL,'12','现付','','','[\"10\",\"11\"]','[\"15\",\"20\"]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('49','出库','零售',NULL,'LSCK201708310002','LSCK201708310002','季圣华','2017-08-31 00:57:40','2017-08-31 00:57:08','7',NULL,NULL,'12',NULL,'12','现付','','','[\"9\",\"11\"]','[\"22\",\"11\"]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('50','出库','零售',NULL,'LSCK201709030001','LSCK201709030001','季圣华','2017-09-03 12:51:50','2017-09-03 12:51:21','10',NULL,'10','22',NULL,'22','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''), ('52','出库','零售',NULL,'LSCK201709040001','LSCK201709040001','季圣华','2017-09-04 21:32:49','2017-09-04 21:31:24','7',NULL,'11','24.2',NULL,'24.2','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('53','出库','零售',NULL,'LSCK201709040002','LSCK201709040002','季圣华','2017-09-04 21:34:02','2017-09-04 21:33:30','7',NULL,'9','36.3',NULL,'36.3','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''), ('54','入库','采购',NULL,'CGRK201709040001','CGRK201709040001','季圣华','2017-09-04 22:20:12','2017-09-04 22:13:00','1',NULL,'10','-10.8',NULL,'-12','现付','','',NULL,NULL,'10','1.2','10.8','12','[\"9\"]','[\"12\"]',NULL,'\0'), ('57','入库','采购',NULL,'CGRK201709050001','CGRK201709050001','季圣华','2017-09-05 22:37:54','2017-09-05 22:37:31','1',NULL,'11','-182.52',NULL,'-182.4','现付','','',NULL,NULL,'0','0','182.52','0','[\"undefined\"]','[\"undefined\"]',NULL,'\0'), ('60','出库','礼品充值',NULL,'LPCZ201709050001','LPCZ201709050001','季圣华','2017-09-05 23:45:48','2017-09-05 23:42:17',NULL,NULL,NULL,NULL,NULL,'13','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('61','出库','礼品销售',NULL,'LPXS201709050001','LPXS201709050001','季圣华','2017-09-05 23:48:10','2017-09-05 23:46:04',NULL,NULL,NULL,NULL,NULL,'6.5','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('62','出库','礼品充值',NULL,'LPCZ201709050002','LPCZ201709050002','季圣华','2017-09-05 23:52:41','2017-09-05 23:51:26',NULL,NULL,NULL,NULL,NULL,'4','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('63','入库','采购',NULL,'CGRK201709170001','CGRK201709170001','季圣华','2017-09-17 21:45:14','2017-09-17 21:44:50','1',NULL,'10','-13.2',NULL,'-12','现付','','',NULL,NULL,'0','0','13.2',NULL,NULL,NULL,NULL,''), ('65','入库','采购',NULL,'CGRK201709170002','CGRK201709170002','季圣华','2017-09-17 21:47:07','2017-09-17 20:45:55','1',NULL,'11','-42.9',NULL,'-39','现付','','',NULL,NULL,'0','0','42.9',NULL,NULL,NULL,NULL,''), ('68','其它','组装单',NULL,'ZZD2017092000001','ZZD2017092000001','季圣华','2017-09-20 23:29:28','2017-09-20 23:29:13',NULL,NULL,NULL,NULL,NULL,'7','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('69','其它','拆卸单',NULL,'CSD2017092000001','CSD2017092000001','季圣华','2017-09-20 23:40:55','2017-09-20 23:40:41',NULL,NULL,NULL,NULL,NULL,'0','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('70','入库','采购',NULL,'CGRK201709210001','CGRK201709210001','季圣华','2017-09-21 22:37:20','2017-09-21 22:36:37','1',NULL,NULL,'-50',NULL,'-50','现付','','','[\"4\",\"9\"]','[\"10\",\"40\"]','0','0','50',NULL,NULL,NULL,NULL,'\0'), ('71','入库','销售退货',NULL,'XSTH201709210001','XSTH201709210001','季圣华','2017-09-21 22:39:00','2017-09-21 22:38:37','2',NULL,'11','-48',NULL,'-48','现付','','<6>,<7>',NULL,NULL,'0','0','48',NULL,NULL,NULL,NULL,'\0'), ('72','入库','其它',NULL,'QTRK201709210001','QTRK201709210001','季圣华','2017-09-21 22:39:26','2017-09-21 22:39:14','4',NULL,NULL,NULL,NULL,'24','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('73','出库','销售',NULL,'XSCK201709210001','XSCK201709210001','季圣华','2017-09-21 22:40:01','2017-09-21 22:39:44','2',NULL,'11','10',NULL,'10','现付','','<6>',NULL,NULL,'0','0','10',NULL,NULL,NULL,NULL,'\0'), ('74','出库','采购退货',NULL,'CGTH201709210001','CGTH201709210001','季圣华','2017-09-21 22:40:57','2017-09-21 22:40:38','4',NULL,'4','5',NULL,'5','现付','','',NULL,NULL,'0','0','5',NULL,NULL,NULL,NULL,'\0'), ('75','出库','其它',NULL,'QTCK201709210001','QTCK201709210001','季圣华','2017-09-21 22:41:15','2017-09-21 22:41:02','2',NULL,NULL,NULL,NULL,'13','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('76','出库','调拨',NULL,'DBCK201709210001','DBCK201709210001','季圣华','2017-09-21 22:41:36','2017-09-21 22:41:19',NULL,NULL,NULL,NULL,NULL,'10','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('77','出库','零售',NULL,'LSCK201709210001','LSCK201709210001','季圣华','2017-09-21 22:42:44','2017-09-21 22:42:21','7',NULL,'4','2.2',NULL,'2.2','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('78','入库','零售退货',NULL,'LSTH201709210001','LSTH201709210001','季圣华','2017-09-21 22:46:07','2017-09-21 22:45:49','7',NULL,'4','-2.2',NULL,'-2.2','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'), ('79','入库','采购',NULL,'CGRK201709210002','CGRK201709210002','季圣华','2017-09-21 23:16:37','2017-09-21 23:16:21','1',NULL,'11','-23.76',NULL,'-21.6','现付','','',NULL,NULL,'0','0','23.76',NULL,NULL,NULL,NULL,'\0'), ('80','其它','组装单',NULL,'ZZD2017092100001','ZZD2017092100001','季圣华','2017-09-21 23:17:16','2017-09-21 23:16:59',NULL,NULL,NULL,NULL,NULL,'5','现付','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'');
INSERT INTO `jsh_depotitem` VALUES ('7','7','500','码','30','30','1.2','1.32','36','remark',NULL,NULL,'3',NULL,'10','3.6','39.6','a','b','c','','',NULL), ('8','8','500','码','20','20','1.2','1.2','24','',NULL,NULL,'3',NULL,NULL,'0','24','','','','','',NULL), ('9','9','500','码','100','100','1.2','1.32','120','',NULL,NULL,'3',NULL,'10','12','132','','','','','',NULL), ('10','10','500','码','10','10','1.2','1.32','12','',NULL,NULL,'3',NULL,'10','1.2','13.2','','','','','',NULL), ('11','11','500','码','20','20','1.2','1.32','24','',NULL,NULL,'3',NULL,'10','2.4','26.4','','','','','',NULL), ('12','12','500','码','10','10','1.2','1.32','12','',NULL,NULL,'3',NULL,'10','1.2','13.2','','','','','',NULL), ('13','13','500','码','20','20','1.2','1.32','24','',NULL,NULL,'3',NULL,'10','2.4','26.4','','','','','',NULL), ('14','14','500','码','30','30','1.2','1.32','36','',NULL,NULL,'3',NULL,'10','3.6','39.6','','','','','',NULL), ('16','16','500','码','20','20','1.2','1.32','24','',NULL,NULL,'3',NULL,'10','2.4','26.4','','','','','',NULL), ('17','17','500','码','30','30','1.2','1.32','36','',NULL,NULL,'3',NULL,'10','3.6','39.6','','','','','',NULL), ('18','18','500','码','20','20','1.2','1.32','24','',NULL,NULL,'3',NULL,'10','2.4','26.4','','','','','',NULL), ('19','19','500','码','22','22','1.2','1.32','26.4','',NULL,NULL,'3',NULL,'10','2.64','29.04','','','','','',NULL), ('20','20','500','码','30','30','1.2','1.32','36','',NULL,NULL,'3',NULL,'10','3.6','39.6','','','','','',NULL), ('21','21','500','码','22','22','1.2','1.32','26.4','',NULL,NULL,'3',NULL,'10','2.64','29.04','','','','','',NULL), ('22','22','500','码','20','20','1.2','1.32','24','',NULL,NULL,'3',NULL,'10','2.4','26.4','','','','','',NULL), ('23','23','517','箱','10','120','36','36','360','',NULL,NULL,'3',NULL,'0','0','360','','','','','',NULL), ('24','24','518','包','10','250','75','75','750','',NULL,NULL,'3',NULL,'0','0','750','','','','','',NULL), ('25','25','518','包','1','25','75','75','75','',NULL,NULL,'3',NULL,'0','0','75','','','','','',NULL), ('26','26','518','包','2','50','75','90','150','',NULL,NULL,'3',NULL,'20','30','180','','','','','',NULL), ('27','27','518','包','1','25','75','82.5','75','',NULL,NULL,'3',NULL,'10','7.5','82.5','','','','','',NULL), ('28','28','517','箱','2','24','36','36','72','',NULL,NULL,'3',NULL,'0','0','72','','','','','',NULL), ('29','29','500','码','100','100','1.3','1.3','130','',NULL,NULL,'3',NULL,'0','0','130','','','','','',NULL), ('30','30','500','码','40','40','1.2','1.2','48','',NULL,NULL,'3',NULL,'0','0','48','','','','','',NULL), ('31','31','500','码','20','20','1.3','1.43','26','',NULL,NULL,'3',NULL,'10','2.6','28.6','','','','','',NULL), ('32','32','500','码','10','10','1.2','1.32','12','',NULL,NULL,'3',NULL,'10','1.2','13.2','','','','','',NULL), ('33','33','500','码','50','50','1.3','1.43','65','',NULL,NULL,'3',NULL,'10','6.5','71.5','','','','','',NULL), ('37','37','500','码','1','1','1.3','1.3','1.3','',NULL,NULL,'3','1','0','0','1.3','','','','','',NULL), ('38','38','500','码','2','2','1.3','1.3','2.6','',NULL,NULL,'3','1','0','0','2.6','','','','','',NULL), ('41','41','500','码','20','20','2.1','2.31','42','',NULL,NULL,'3',NULL,'10','4.2','46.2','','','','','',NULL), ('42','42','500','码','10','10','1.1','1.1','11','',NULL,NULL,'3',NULL,'0','0','11','','','','','',NULL), ('43','43','500','码','11','11','1.1','1.1','12.1','',NULL,NULL,'3',NULL,'0','0','12.1','','','','','',NULL), ('44','44','499','码','1','1','2.2','2.2','2.2','',NULL,NULL,'3',NULL,'0','0','2.2','','','','','',NULL), ('45','45','500','码','3','3','1.1','1.1','3.3','',NULL,NULL,'3',NULL,'0','0','3.3','','','','','',NULL), ('48','48','498','码','10','10','1.2','1.2','12','',NULL,NULL,'3',NULL,'0','0','12','','','','','',NULL), ('49','49','498','码','10','10','1.2','1.2','12','',NULL,NULL,'3',NULL,'0','0','12','','','','','',NULL), ('50','50','500','码','20','20','1.1','1.1','22','',NULL,NULL,'3',NULL,'0','0','22','','','','','',NULL), ('52','52','500','码','22','22','1.1','1.1','24.2','',NULL,NULL,'3',NULL,'0','0','24.2','','','','','',NULL), ('53','53','500','码','33','33','1.1','1.1','36.3','',NULL,NULL,'3',NULL,'0','0','36.3','','','','','',NULL), ('54','54','500','码','10','10','1.2','1.2','12','',NULL,NULL,'3',NULL,'0','0','12','','','','','',NULL), ('57','57','500','码','2','2','1.2','1.26','2.4','',NULL,NULL,'3',NULL,'0','0.12','2.52','','','','','',NULL), ('60','60','500','码','10','10','1.3','1.3','13','',NULL,NULL,'3','4','0','0','13','','','','','',NULL), ('61','61','500','码','5','5','1.3','1.3','6.5','',NULL,NULL,'4',NULL,'0','0','6.5','','','','','',NULL), ('62','62','517','瓶','1','1','4','4','4','',NULL,NULL,'1','6','0','0','4','','','','','',NULL), ('63','57','517','箱','5','60','36','36','180','',NULL,NULL,'3',NULL,'0','0','180','','','','','',NULL), ('64','63','500','码','10','10','1.2','1.32','12','',NULL,NULL,'3',NULL,'10','1.2','13.2','','','','','',NULL), ('66','65','498','码','30','30','1.3','1.43','39','',NULL,NULL,'3',NULL,'10','3.9','42.9','','','','','',NULL), ('71','68','498','码','1','1','3','3','3','',NULL,NULL,'3',NULL,'0','0','3','','','','','','组合件'), ('72','68','499','码','1','1','4','4','4','',NULL,NULL,'3',NULL,'0','0','4','','','','','','普通子件'), ('73','69','498','码','1','1','0','0','0','',NULL,NULL,'1',NULL,'0','0','0','','','','','','组合件'), ('74','69','499','码','1','1','0','0','0','',NULL,NULL,'1',NULL,'0','0','0','','','','','','普通子件'), ('75','70','487','码','50','50','1','1','50','',NULL,NULL,'3',NULL,'0','0','50','','','','','',''), ('76','71','499','码','20','20','2.4','2.4','48','',NULL,NULL,'3',NULL,'0','0','48','','','','','',''), ('77','72','499','码','10','10','2.4','2.81','24','',NULL,NULL,'3',NULL,'17','4.08','28.08','','','','','',''), ('78','73','487','码','10','10','1','1','10','',NULL,NULL,'3',NULL,'0','0','10','','','','','',''), ('79','74','487','码','5','5','1','1','5','',NULL,NULL,'3',NULL,'0','0','5','','','','','',''), ('80','75','500','码','10','10','1.3','1.3','13','',NULL,NULL,'3',NULL,'0','0','13','','','','','',''), ('81','76','487','码','10','10','1','1','10','',NULL,NULL,'3','1','0','0','10','','','','','',''), ('82','77','499','码','1','1','2.2','2.2','2.2','',NULL,NULL,'3',NULL,'0','0','2.2','','','','','',''), ('83','78','499','码','1','1','2.2','2.2','2.2','',NULL,NULL,'3',NULL,'0','0','2.2','','','','','',''), ('84','79','499','码','9','9','2.4','2.64','21.6','',NULL,NULL,'3',NULL,'10','2.16','23.76','','','','','',''), ('85','80','500','码','1','1','2','2','2','',NULL,NULL,'3',NULL,'0','0','2','','','','','','组合件'), ('86','80','498','码','1','1','3','3','3','',NULL,NULL,'3',NULL,'0','0','3','','','','','','普通子件');
INSERT INTO `jsh_functions` VALUES ('1','00','系统管理','0','','','0010','','电脑版',''), ('2','01','基础数据','0','','','0020','','电脑版',''), ('11','0001','系统管理','00','','\0','0110','','电脑版',NULL), ('12','000101','应用管理','0001','../manage/app.jsp','\0','0132','','电脑版',''), ('13','000102','角色管理','0001','../manage/role.jsp','\0','0130','','电脑版',''), ('14','000103','用户管理','0001','../manage/user.jsp','\0','0140','','电脑版',NULL), ('15','000104','日志管理','0001','../manage/log.jsp','\0','0160','','电脑版',NULL), ('16','000105','功能管理','0001','../manage/functions.jsp','\0','0135','','电脑版',NULL), ('21','0101','商品管理','01','','\0','0220','','电脑版',NULL), ('22','010101','商品类别','0101','../materials/materialcategory.jsp','\0','0230','','电脑版',NULL), ('23','010102','商品信息','0101','../materials/material.jsp','\0','0240','','电脑版',NULL), ('24','0102','基本资料','01','','\0','0250','','电脑版',NULL), ('25','01020101','供应商信息','0102','../manage/vendor.jsp','\0','0260','','电脑版','1,2'), ('26','010202','仓库信息','0102','../manage/depot.jsp','\0','0270','','电脑版',NULL), ('31','010206','经手人管理','0102','../materials/person.jsp','\0','0284','','电脑版',NULL), ('32','0502','入库管理','05','','\0','0330','','电脑版',''), ('33','050201','采购入库','0502','../materials/purchase_in_list.jsp','\0','0340','','电脑版','3,4,5'), ('38','0603','出库管理','06','','\0','0390','','电脑版',''), ('40','060306','调拨出库','0603','../materials/allocation_out_list.jsp','\0','0420','','电脑版','3,4,5'), ('41','060303','销售出库','0603','../materials/sale_out_list.jsp','\0','0410','','电脑版','3,4,5'), ('44','0704','财务管理','07','','\0','0450','','电脑版',''), ('59','030101','库存状况','0301','../reports/in_out_stock_report.jsp','\0','0600','','电脑版',NULL), ('194','010204','收支项目','0102','../manage/inOutItem.jsp','\0','0282','','电脑版',NULL), ('195','010205','结算账户','0102','../manage/account.jsp','\0','0283','','电脑版',NULL), ('196','03','报表查询','0','','','0025','','电脑版',''), ('197','070402','收入单','0704','../financial/item_in.jsp','\0','0465','','电脑版',''), ('198','0301','报表查询','03','','\0','0570','','电脑版',NULL), ('199','060304','采购退货','0603','../materials/purchase_back_list.jsp','\0','0415','','电脑版','3,4,5'), ('200','050203','销售退货','0502','../materials/sale_back_list.jsp','\0','0350','','电脑版','3,4,5'), ('201','050204','其它入库','0502','../materials/other_in_list.jsp','\0','0360','','电脑版','3,4,5'), ('202','060305','其它出库','0603','../materials/other_out_list.jsp','\0','0418','','电脑版','3,4,5'), ('203','070403','支出单','0704','../financial/item_out.jsp','\0','0470','','电脑版',''), ('204','070404','收款单','0704','../financial/money_in.jsp','\0','0475','','电脑版',''), ('205','070405','付款单','0704','../financial/money_out.jsp','\0','0480','','电脑版',''), ('206','070406','转账单','0704','../financial/giro.jsp','\0','0490','','电脑版',''), ('207','030102','结算账户','0301','../reports/account_report.jsp','\0','0610','','电脑版',NULL), ('208','030103','进货统计','0301','../reports/buy_in_report.jsp','\0','0620','','电脑版',NULL), ('209','030104','销售统计','0301','../reports/sale_out_report.jsp','\0','0630','','电脑版',NULL), ('210','040102','零售出库','0401','../materials/retail_out_list.jsp','\0','0405','','电脑版','3,4,5'), ('211','040104','零售退货','0401','../materials/retail_back_list.jsp','\0','0407','','电脑版','3,4,5'), ('212','070407','收预付款','0704','../financial/advance_in.jsp','\0','0495','','电脑版',''), ('213','010207','礼品卡管理','0102','../manage/depotGift.jsp','\0','0290','','电脑版',''), ('214','040106','礼品充值','0401','../materials/gift_recharge_list.jsp','\0','0408','','电脑版','3,4,5'), ('215','040108','礼品销售','0401','../materials/gift_out_list.jsp','\0','0409','','电脑版','3,4,5'), ('216','030105','礼品卡统计','0301','../reports/gift_manage_report.jsp','\0','0635','','电脑版',''), ('217','01020102','客户信息','0102','../manage/customer.jsp','\0','0262','','电脑版','1,2'), ('218','01020103','会员信息','0102','../manage/member.jsp','\0','0263','','电脑版','1,2'), ('219','000107','资产管理','0001','../asset/asset.jsp','\0','0170','\0','电脑版',NULL), ('220','010103','计量单位','0101','../manage/unit.jsp','\0','0245','','电脑版',NULL), ('221','04','零售管理','0','','','0028','','电脑版',''), ('222','05','入库管理','0','','','0030','','电脑版',''), ('223','06','出库管理','0','','','0035','','电脑版',''), ('224','07','财务管理','0','','','0040','','电脑版',''), ('225','0401','零售管理','04','','\0','0401','','电脑版',''), ('226','030106','入库明细','0301','../reports/in_detail.jsp','\0','0640','','电脑版',''), ('227','030107','出库明细','0301','../reports/out_detail.jsp','\0','0645','','电脑版',''), ('228','030108','入库汇总','0301','../reports/in_material_count.jsp','\0','0650','','电脑版',''), ('229','030109','出库汇总','0301','../reports/out_material_count.jsp','\0','0655','','电脑版',''), ('230','02','组装拆卸','0','','','0022','','电脑版',''), ('231','0201','组装拆卸','02','','\0','0310','','电脑版',''), ('232','020101','组装单','0201','../materials/assemble_list.jsp','\0','0315','','电脑版','3,4,5'), ('233','020102','拆卸单','0201','../materials/disassemble_list.jsp','\0','0320','','电脑版','3,4,5');
INSERT INTO `jsh_inoutitem` VALUES ('1','办公耗材','支出','办公耗材'), ('5','房租收入','收入','房租收入'), ('7','利息收入','收入','利息收入'), ('8','水电费','支出','水电费水电费'), ('9','快递费','支出','快递费'), ('10','交通报销费','支出','交通报销费'), ('11','差旅费','支出','差旅费'), ('12','全车贴膜-普通','收入',''), ('13','全车贴膜-高档','收入',''), ('14','洗车','收入',''), ('15','保养汽车','收入','');
INSERT INTO `jsh_log` VALUES ('1722','63','登录系统','192.168.1.104','2016-11-27 13:17:17','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1723','63','登录系统','192.168.1.104','2016-11-27 13:17:30','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1724','63','退出系统','192.168.1.104','2016-11-27 13:17:48','0','管理用户：jsh 退出系统','jsh 退出系统'), ('1725','65','登录系统','192.168.1.104','2016-11-27 13:17:52','0','管理用户：ls 登录系统','ls 登录系统'), ('1726','65','退出系统','192.168.1.104','2016-11-27 13:18:18','0','管理用户：ls 退出系统','ls 退出系统'), ('1727','63','登录系统','192.168.1.104','2016-11-27 13:18:22','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1728','63','更新UserBusiness','192.168.1.104','2016-11-27 13:18:44','0','更新UserBusiness的ID为  6 成功！','更新UserBusiness成功'), ('1729','63','退出系统','192.168.1.104','2016-11-27 13:18:48','0','管理用户：jsh 退出系统','jsh 退出系统'), ('1730','65','登录系统','192.168.1.104','2016-11-27 13:18:53','0','管理用户：ls 登录系统','ls 登录系统'), ('1731','63','登录系统','192.168.1.104','2016-12-04 10:38:50','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1732','63','增加物料','192.168.1.104','2016-12-04 10:40:52','0','增加物料名称为  11 成功！','增加物料成功'), ('1733','63','更新物料','192.168.1.104','2016-12-04 10:59:57','0','更新物料ID为  499 成功！','更新物料成功'), ('1734','63','更新物料','192.168.1.104','2016-12-04 11:00:13','0','更新物料ID为  499 成功！','更新物料成功'), ('1735','63','删除物料','192.168.1.104','2016-12-04 11:00:38','0','删除物料ID为  499 成功！','删除物料成功'), ('1736','63','增加物料','192.168.1.104','2016-12-04 11:02:35','0','增加物料名称为  11 成功！','增加物料成功'), ('1737','63','批量删除物料','192.168.1.104','2016-12-04 11:02:41','0','批量删除物料ID为  500 成功！','批量删除物料成功'), ('1738','63','更新功能','192.168.1.104','2016-12-04 11:04:43','0','更新功能ID为  26 成功！','更新功能成功'), ('1739','63','增加供应商','192.168.1.104','2016-12-04 11:38:13','0','增加供应商名称为  aa 成功！','增加供应商成功'), ('1740','63','增加供应商','192.168.1.104','2016-12-04 11:48:36','0','增加供应商名称为  aaaa 成功！','增加供应商成功'), ('1741','63','删除供应商','192.168.1.104','2016-12-04 11:48:53','0','删除供应商ID为  3,名称为  aa成功！','删除供应商成功'), ('1742','63','更新供应商','192.168.1.104','2016-12-04 11:48:59','0','更新供应商ID为  4 成功！','更新供应商成功'), ('1743','63','更新功能','192.168.1.104','2016-12-04 13:06:24','0','更新功能ID为  31 成功！','更新功能成功'), ('1744','63','删除功能','192.168.1.104','2016-12-04 13:06:47','0','删除功能ID为  30 成功！','删除功能成功'), ('1745','63','更新功能','192.168.1.104','2016-12-04 13:08:35','0','更新功能ID为  24 成功！','更新功能成功'), ('1746','63','更新功能','192.168.1.104','2016-12-04 13:09:52','0','更新功能ID为  24 成功！','更新功能成功'), ('1747','63','更新功能','192.168.1.104','2016-12-04 13:11:00','0','更新功能ID为  21 成功！','更新功能成功'), ('1748','63','更新功能','192.168.1.104','2016-12-04 13:11:08','0','更新功能ID为  22 成功！','更新功能成功'), ('1749','63','更新功能','192.168.1.104','2016-12-04 13:11:16','0','更新功能ID为  23 成功！','更新功能成功'), ('1750','63','更新功能','192.168.1.104','2016-12-04 13:11:31','0','更新功能ID为  23 成功！','更新功能成功'), ('1751','63','更新应用','192.168.1.104','2016-12-04 13:34:39','0','更新应用ID为  22 成功！','更新应用成功'), ('1752','63','更新应用','192.168.1.104','2016-12-04 13:35:13','0','更新应用ID为  22 成功！','更新应用成功'), ('1753','63','登录系统','192.168.1.104','2016-12-04 13:36:45','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1754','63','登录系统','192.168.1.104','2016-12-04 13:38:31','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1755','63','增加功能','192.168.1.104','2016-12-04 13:40:10','0','增加功能名称为  报表管理 成功！','增加功能成功'), ('1756','63','更新功能','192.168.1.104','2016-12-04 13:40:38','0','更新功能ID为  58 成功！','更新功能成功'), ('1757','63','更新功能','192.168.1.104','2016-12-04 13:40:54','0','更新功能ID为  59 成功！','更新功能成功'), ('1758','63','更新应用','192.168.1.104','2016-12-04 13:42:15','0','更新应用ID为  22 成功！','更新应用成功'), ('1759','63','更新功能','192.168.1.104','2016-12-04 13:43:23','0','更新功能ID为  58 成功！','更新功能成功'), ('1760','63','更新应用','192.168.1.104','2016-12-04 13:43:44','0','更新应用ID为  22 成功！','更新应用成功'), ('1761','63','更新应用','192.168.1.104','2016-12-04 13:47:17','0','更新应用ID为  22 成功！','更新应用成功'), ('1762','63','登录系统','192.168.112.102','2016-12-04 21:00:14','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1763','63','更新应用','192.168.112.102','2016-12-04 21:01:40','0','更新应用ID为  7 成功！','更新应用成功'), ('1764','63','更新应用','192.168.112.102','2016-12-04 21:02:40','0','更新应用ID为  7 成功！','更新应用成功'), ('1765','63','登录系统','192.168.112.102','2016-12-04 21:14:18','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1766','63','登录系统','192.168.112.102','2016-12-04 21:49:44','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1767','63','登录系统','192.168.4.108','2016-12-10 14:24:27','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1768','63','登录系统','192.168.4.108','2016-12-10 14:30:33','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1769','63','退出系统','192.168.4.108','2016-12-10 14:31:27','0','管理用户：jsh 退出系统','jsh 退出系统'), ('1770','63','登录系统','192.168.4.108','2016-12-10 14:31:33','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1771','63','增加经手人','192.168.4.108','2016-12-10 14:55:24','0','增加经手人名称为  赵五-财务 成功！','增加经手人成功'), ('1772','63','更新经手人','192.168.4.108','2016-12-10 14:55:33','0','更新经手人ID为  2 成功！','更新经手人成功'), ('1773','63','更新经手人','192.168.4.108','2016-12-10 14:55:45','0','更新经手人ID为  1 成功！','更新经手人成功'), ('1774','63','增加功能','192.168.4.108','2016-12-10 15:29:27','0','增加功能名称为  收入单 成功！','增加功能成功'), ('1775','63','更新UserBusiness','192.168.4.108','2016-12-10 15:30:47','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('1776','63','更新功能','192.168.4.108','2016-12-10 15:35:04','0','更新功能ID为  58 成功！','更新功能成功'), ('1777','63','更新功能','192.168.4.108','2016-12-10 15:35:59','0','更新功能ID为  58 成功！','更新功能成功'), ('1778','63','更新功能','192.168.4.108','2016-12-10 15:37:40','0','更新功能ID为  196 成功！','更新功能成功'), ('1779','63','更新功能','192.168.4.108','2016-12-10 15:39:07','0','更新功能ID为  196 成功！','更新功能成功'), ('1780','63','更新功能','192.168.4.108','2016-12-10 15:39:23','0','更新功能ID为  59 成功！','更新功能成功'), ('1781','63','删除功能','192.168.4.108','2016-12-10 15:39:45','0','删除功能ID为  58 成功！','删除功能成功'), ('1782','63','更新功能','192.168.4.108','2016-12-10 15:40:03','0','更新功能ID为  59 成功！','更新功能成功'), ('1783','63','更新UserBusiness','192.168.4.108','2016-12-10 15:41:52','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('1784','63','增加功能','192.168.4.108','2016-12-10 15:44:39','0','增加功能名称为  报表管理 成功！','增加功能成功'), ('1785','63','更新功能','192.168.4.108','2016-12-10 15:44:51','0','更新功能ID为  59 成功！','更新功能成功'), ('1786','63','更新功能','192.168.4.108','2016-12-10 15:46:30','0','更新功能ID为  198 成功！','更新功能成功'), ('1787','63','增加经手人','192.168.4.108','2016-12-10 16:48:36','0','增加经手人名称为  赵六-财务 成功！','增加经手人成功'), ('1788','63','更新经手人','192.168.4.108','2016-12-10 16:48:43','0','更新经手人ID为  3 成功！','更新经手人成功'), ('1789','63','更新经手人','192.168.4.108','2016-12-10 16:48:49','0','更新经手人ID为  3 成功！','更新经手人成功'), ('1790','63','增加仓库','192.168.4.108','2016-12-10 16:59:41','0','增加仓库名称为  总部 成功！','增加仓库成功'), ('1791','63','更新仓库','192.168.4.108','2016-12-10 16:59:52','0','更新仓库ID为  2 成功！','更新仓库成功'), ('1792','63','更新仓库','192.168.4.108','2016-12-10 17:00:03','0','更新仓库ID为  1 成功！','更新仓库成功'), ('1793','63','更新经手人','192.168.4.108','2016-12-10 17:00:15','0','更新经手人ID为  3 成功！','更新经手人成功'), ('1794','63','更新经手人','192.168.4.108','2016-12-10 17:00:23','0','更新经手人ID为  4 成功！','更新经手人成功'), ('1795','63','登录系统','192.168.4.108','2016-12-10 17:10:40','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1796','63','退出系统','192.168.4.108','2016-12-10 17:39:05','0','管理用户：jsh 退出系统','jsh 退出系统'), ('1797','63','登录系统','192.168.4.108','2016-12-10 17:39:16','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1798','63','批量删除功能','192.168.4.108','2016-12-10 17:44:39','0','批量删除功能ID为  51,193 成功！','批量删除功能成功'), ('1799','63','批量删除功能','192.168.4.108','2016-12-10 17:44:54','0','批量删除功能ID为  46,47,48,49,50 成功！','批量删除功能成功'), ('1800','63','批量删除功能','192.168.4.108','2016-12-10 17:45:26','0','批量删除功能ID为  52,53,54,55 成功！','批量删除功能成功'), ('1801','63','批量删除功能','192.168.4.108','2016-12-10 17:45:49','0','批量删除功能ID为  45 成功！','批量删除功能成功'), ('1802','63','登录系统','192.168.112.102','2016-12-10 20:19:13','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1803','63','增加财务','192.168.112.102','2016-12-10 20:20:06','0','增加财务编号为  33 成功！','增加财务成功'), ('1804','63','增加财务','192.168.112.102','2016-12-10 20:20:11','0','增加财务编号为  33 成功！','增加财务成功'), ('1805','63','增加财务','192.168.112.102','2016-12-10 20:20:12','0','增加财务编号为  33 成功！','增加财务成功'), ('1806','63','增加财务','192.168.112.102','2016-12-10 20:25:48','0','增加财务编号为  123 成功！','增加财务成功'), ('1807','63','登录系统','192.168.112.102','2016-12-10 20:50:11','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1808','63','增加财务','192.168.112.102','2016-12-10 20:51:41','0','增加财务编号为  3123 成功！','增加财务成功'), ('1809','63','增加财务','192.168.112.102','2016-12-10 20:53:58','0','增加财务编号为  3123 成功！','增加财务成功'), ('1810','63','增加财务','192.168.112.102','2016-12-10 21:08:57','0','增加财务编号为  123 成功！','增加财务成功'), ('1811','63','增加财务','192.168.112.102','2016-12-10 21:47:45','0','增加财务编号为  123 成功！','增加财务成功'), ('1812','63','保存财务明细','192.168.112.102','2016-12-10 21:47:46','0','保存财务明细对应主表编号为  8 成功！','保存财务明细成功'), ('1813','63','登录系统','192.168.112.102','2016-12-10 22:49:54','0','管理用户：jsh 登录系统','jsh 登录系统'), ('1814','63','删除财务','192.168.112.102','2016-12-10 22:52:43','0','删除财务ID为  5 成功！','删除财务成功'), ('1815','63','批量删除财务','192.168.112.102','2016-12-10 22:52:49','0','批量删除财务ID为  4 成功！','批量删除财务成功'), ('1816','63','增加财务','192.168.112.102','2016-12-10 22:53:19','0','增加财务编号为  3134 成功！','增加财务成功'), ('1817','63','保存财务明细','192.168.112.102','2016-12-10 22:53:20','0','保存财务明细对应主表编号为  9 成功！','保存财务明细成功'), ('1818','63','删除财务','192.168.112.102','2016-12-10 22:53:35','0','删除财务ID为  7 成功！','删除财务成功'), ('1819','63','增加财务','192.168.112.102','2016-12-10 22:54:05','0','增加财务编号为  N123 成功！','增加财务成功'), ('1820','63','保存财务明细','192.168.112.102','2016-12-10 22:54:06','0','保存财务明细对应主表编号为  10 成功！','保存财务明细成功'), ('1821','63','更新财务','192.168.112.102','2016-12-10 22:54:28','0','更新财务ID为  10 成功！','更新财务成功');

INSERT INTO `jsh_log` VALUES ('5022','63','更新单据','192.168.100.163','2017-08-28 23:16:12','0','更新单据ID为  30 成功！','更新单据成功'), ('5023','63','增加单据','192.168.100.163','2017-08-28 23:17:55','0','增加单据编号为  QTRK201708280001 成功！','增加单据成功'), ('5024','63','保存仓管通明细','192.168.100.163','2017-08-28 23:17:55','0','保存仓管通明细对应主表编号为  32 成功！','保存仓管通明细成功'), ('5025','63','增加单据','192.168.100.163','2017-08-28 23:21:14','0','增加单据编号为  QTCK201708280001 成功！','增加单据成功'), ('5026','63','保存仓管通明细','192.168.100.163','2017-08-28 23:21:15','0','保存仓管通明细对应主表编号为  33 成功！','保存仓管通明细成功'), ('5027','63','增加单据','192.168.100.163','2017-08-28 23:37:02','0','增加单据编号为  DBCK201708280001 成功！','增加单据成功'), ('5028','63','保存仓管通明细','192.168.100.163','2017-08-28 23:37:02','0','保存仓管通明细对应主表编号为  34 成功！','保存仓管通明细成功'), ('5029','63','删除单据','192.168.100.163','2017-08-28 23:38:46','0','删除单据ID为  34 成功！','删除单据成功'), ('5030','63','增加单据','192.168.100.163','2017-08-28 23:38:58','0','增加单据编号为  DBCK201708280001 成功！','增加单据成功'), ('5031','63','保存仓管通明细','192.168.100.163','2017-08-28 23:38:58','0','保存仓管通明细对应主表编号为  35 成功！','保存仓管通明细成功'), ('5032','63','删除单据','192.168.100.163','2017-08-28 23:39:18','0','删除单据ID为  35 成功！','删除单据成功'), ('5033','63','增加单据','192.168.100.163','2017-08-28 23:39:28','0','增加单据编号为  DBCK201708280001 成功！','增加单据成功'), ('5034','63','保存仓管通明细','192.168.100.163','2017-08-28 23:39:28','0','保存仓管通明细对应主表编号为  36 成功！','保存仓管通明细成功'), ('5035','63','增加单据','192.168.100.163','2017-08-28 23:56:34','0','增加单据编号为  DBCK201708280002 成功！','增加单据成功'), ('5036','63','保存仓管通明细','192.168.100.163','2017-08-28 23:56:35','0','保存仓管通明细对应主表编号为  37 成功！','保存仓管通明细成功'), ('5037','63','增加单据','192.168.100.163','2017-08-29 00:20:11','0','增加单据编号为  DBCK201708290001 成功！','增加单据成功'), ('5038','63','保存仓管通明细','192.168.100.163','2017-08-29 00:20:11','0','保存仓管通明细对应主表编号为  38 成功！','保存仓管通明细成功'), ('5039','63','更新单据','192.168.100.163','2017-08-29 00:20:49','0','更新单据ID为  38 成功！','更新单据成功'), ('5040','63','保存仓管通明细','192.168.100.163','2017-08-29 00:20:49','0','保存仓管通明细对应主表编号为  38 成功！','保存仓管通明细成功'), ('5041','63','更新角色按钮权限','','2017-08-29 00:27:51','0','角色按钮权限的ID为  5 成功！','更新角色按钮权限成功'), ('5042','63','批量修改单据状态','192.168.100.163','2017-08-29 00:28:19','0','批量修改状态，单据ID为  33 成功！','批量修改单据状态成功'), ('5043','63','批量修改单据状态','192.168.100.163','2017-08-29 00:28:21','0','批量修改状态，单据ID为  33 成功！','批量修改单据状态成功'), ('5044','63','登录系统','192.168.100.163','2017-08-29 20:33:52','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5045','63','更新角色按钮权限','','2017-08-29 20:38:41','0','角色按钮权限的ID为  5 成功！','更新角色按钮权限成功'), ('5046','63','批量修改单据状态','192.168.100.163','2017-08-29 20:38:57','0','批量修改状态，单据ID为  36 成功！','批量修改单据状态成功'), ('5047','63','批量修改单据状态','192.168.100.163','2017-08-29 20:39:00','0','批量修改状态，单据ID为  36 成功！','批量修改单据状态成功'), ('5048','63','更新单据','192.168.100.163','2017-08-29 20:41:12','0','更新单据ID为  31 成功！','更新单据成功'), ('5049','63','批量删除单据','192.168.100.163','2017-08-29 20:41:41','0','批量删除单据ID为  36 成功！','批量删除单据成功'), ('5050','63','更新单据','192.168.100.163','2017-08-29 20:41:56','0','更新单据ID为  38 成功！','更新单据成功'), ('5051','63','保存仓管通明细','192.168.100.163','2017-08-29 20:41:57','0','保存仓管通明细对应主表编号为  38 成功！','保存仓管通明细成功'), ('5052','63','更新单据','192.168.100.163','2017-08-29 20:51:57','0','更新单据ID为  30 成功！','更新单据成功'), ('5053','63','保存仓管通明细','192.168.100.163','2017-08-29 20:51:57','0','保存仓管通明细对应主表编号为  30 成功！','保存仓管通明细成功'), ('5054','63','更新功能','192.168.100.163','2017-08-29 20:54:04','0','更新功能ID为  210 成功！','更新功能成功'), ('5055','63','更新功能','192.168.100.163','2017-08-29 20:54:23','0','更新功能ID为  211 成功！','更新功能成功'), ('5056','63','更新功能','192.168.100.163','2017-08-29 20:54:51','0','更新功能ID为  211 成功！','更新功能成功'), ('5057','63','退出系统','192.168.100.163','2017-08-29 20:57:20','0','管理用户：jsh 退出系统','jsh 退出系统'), ('5058','63','登录系统','192.168.100.163','2017-08-29 20:57:24','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5059','63','更新UserBusiness','192.168.100.163','2017-08-29 20:57:45','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5060','63','更新功能','192.168.100.163','2017-08-29 20:58:15','0','更新功能ID为  211 成功！','更新功能成功'), ('5061','63','更新功能','192.168.100.163','2017-08-29 20:58:25','0','更新功能ID为  210 成功！','更新功能成功'), ('5062','63','更新角色按钮权限','','2017-08-29 20:58:33','0','角色按钮权限的ID为  5 成功！','更新角色按钮权限成功'), ('5063','63','更新功能','192.168.100.163','2017-08-29 20:58:55','0','更新功能ID为  214 成功！','更新功能成功'), ('5064','63','更新UserBusiness','192.168.100.163','2017-08-29 20:59:03','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5065','63','更新功能','192.168.100.163','2017-08-29 21:00:57','0','更新功能ID为  216 成功！','更新功能成功'), ('5066','63','更新功能','192.168.100.163','2017-08-29 21:01:03','0','更新功能ID为  215 成功！','更新功能成功'), ('5067','63','更新UserBusiness','192.168.100.163','2017-08-29 21:01:18','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5068','63','增加应用','192.168.100.163','2017-08-29 21:11:53','0','增加应用名称为  零售管理 成功！','增加应用成功'), ('5069','63','更新应用','192.168.100.163','2017-08-29 21:12:08','0','更新应用ID为  23 成功！','更新应用成功'), ('5070','63','增加应用','192.168.100.163','2017-08-29 21:13:16','0','增加应用名称为  入库管理 成功！','增加应用成功'), ('5071','63','增加应用','192.168.100.163','2017-08-29 21:14:22','0','增加应用名称为  出库管理 成功！','增加应用成功'), ('5072','63','增加应用','192.168.100.163','2017-08-29 21:15:19','0','增加应用名称为  财务管理 成功！','增加应用成功'), ('5073','63','增加功能','192.168.100.163','2017-08-29 21:16:55','0','增加功能名称为  零售管理 成功！','增加功能成功'), ('5074','63','增加功能','192.168.100.163','2017-08-29 21:17:23','0','增加功能名称为  入库管理 成功！','增加功能成功'), ('5075','63','更新功能','192.168.100.163','2017-08-29 21:17:38','0','更新功能ID为  3 成功！','更新功能成功'), ('5076','63','增加功能','192.168.100.163','2017-08-29 21:18:33','0','增加功能名称为  出库管理 成功！','增加功能成功'), ('5077','63','增加功能','192.168.100.163','2017-08-29 21:18:58','0','增加功能名称为  财务管理 成功！','增加功能成功'), ('5078','63','更新功能','192.168.100.163','2017-08-29 21:19:13','0','更新功能ID为  196 成功！','更新功能成功'), ('5079','63','删除功能','192.168.100.163','2017-08-29 21:19:38','0','删除功能ID为  3 成功！','删除功能成功'), ('5080','63','更新功能','192.168.100.163','2017-08-29 21:21:42','0','更新功能ID为  32 成功！','更新功能成功'), ('5081','63','更新功能','192.168.100.163','2017-08-29 21:21:59','0','更新功能ID为  33 成功！','更新功能成功'), ('5082','63','更新功能','192.168.100.163','2017-08-29 21:22:21','0','更新功能ID为  200 成功！','更新功能成功'), ('5083','63','更新功能','192.168.100.163','2017-08-29 21:22:33','0','更新功能ID为  201 成功！','更新功能成功'), ('5084','63','更新功能','192.168.100.163','2017-08-29 21:22:47','0','更新功能ID为  38 成功！','更新功能成功'), ('5085','63','更新功能','192.168.100.163','2017-08-29 21:23:13','0','更新功能ID为  41 成功！','更新功能成功'), ('5086','63','更新功能','192.168.100.163','2017-08-29 21:23:28','0','更新功能ID为  199 成功！','更新功能成功'), ('5087','63','更新功能','192.168.100.163','2017-08-29 21:23:43','0','更新功能ID为  202 成功！','更新功能成功'), ('5088','63','更新功能','192.168.100.163','2017-08-29 21:23:59','0','更新功能ID为  40 成功！','更新功能成功'), ('5089','63','增加功能','192.168.100.163','2017-08-29 21:25:04','0','增加功能名称为  零售管理 成功！','增加功能成功'), ('5090','63','更新功能','192.168.100.163','2017-08-29 21:25:21','0','更新功能ID为  210 成功！','更新功能成功'), ('5091','63','更新功能','192.168.100.163','2017-08-29 21:25:59','0','更新功能ID为  211 成功！','更新功能成功'), ('5092','63','更新功能','192.168.100.163','2017-08-29 21:26:14','0','更新功能ID为  211 成功！','更新功能成功'), ('5093','63','更新功能','192.168.100.163','2017-08-29 21:27:55','0','更新功能ID为  214 成功！','更新功能成功'), ('5094','63','更新功能','192.168.100.163','2017-08-29 21:28:20','0','更新功能ID为  215 成功！','更新功能成功'), ('5095','63','更新功能','192.168.100.163','2017-08-29 21:29:06','0','更新功能ID为  44 成功！','更新功能成功'), ('5096','63','更新功能','192.168.100.163','2017-08-29 21:29:26','0','更新功能ID为  197 成功！','更新功能成功'), ('5097','63','更新功能','192.168.100.163','2017-08-29 21:29:38','0','更新功能ID为  203 成功！','更新功能成功'), ('5098','63','更新功能','192.168.100.163','2017-08-29 21:29:53','0','更新功能ID为  204 成功！','更新功能成功'), ('5099','63','更新功能','192.168.100.163','2017-08-29 21:30:10','0','更新功能ID为  205 成功！','更新功能成功'), ('5100','63','更新功能','192.168.100.163','2017-08-29 21:30:30','0','更新功能ID为  206 成功！','更新功能成功'), ('5101','63','更新功能','192.168.100.163','2017-08-29 21:30:42','0','更新功能ID为  212 成功！','更新功能成功'), ('5102','63','更新UserBusiness','192.168.100.163','2017-08-29 21:32:15','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5103','63','更新应用','192.168.100.163','2017-08-29 21:33:32','0','更新应用ID为  8 成功！','更新应用成功'), ('5104','63','更新UserBusiness','192.168.100.163','2017-08-29 21:34:23','0','更新UserBusiness的ID为  1 成功！','更新UserBusiness成功'), ('5105','63','更新应用','192.168.100.163','2017-08-29 21:34:59','0','更新应用ID为  24 成功！','更新应用成功'), ('5106','63','更新应用','192.168.100.163','2017-08-29 21:35:07','0','更新应用ID为  23 成功！','更新应用成功'), ('5107','63','更新应用','192.168.100.163','2017-08-29 21:35:13','0','更新应用ID为  25 成功！','更新应用成功'), ('5108','63','更新应用','192.168.100.163','2017-08-29 21:36:15','0','更新应用ID为  25 成功！','更新应用成功'), ('5109','63','更新应用','192.168.100.163','2017-08-29 21:36:20','0','更新应用ID为  24 成功！','更新应用成功'), ('5110','63','更新应用','192.168.100.163','2017-08-29 21:36:24','0','更新应用ID为  23 成功！','更新应用成功'), ('5111','63','增加单据','192.168.100.163','2017-08-29 21:37:30','0','增加单据编号为  LSCK201708290001 成功！','增加单据成功'), ('5112','63','保存仓管通明细','192.168.100.163','2017-08-29 21:37:30','0','保存仓管通明细对应主表编号为  39 成功！','保存仓管通明细成功'), ('5113','63','更新供应商预付款','','2017-08-29 21:37:36','0','更新供应商ID为  7 成功！','更新供应商成功'), ('5114','63','批量删除单据','192.168.100.163','2017-08-29 21:37:36','0','批量删除单据ID为  39 成功！','批量删除单据成功'), ('5115','63','更新功能','192.168.100.163','2017-08-29 21:40:46','0','更新功能ID为  213 成功！','更新功能成功'), ('5116','63','更新UserBusiness','192.168.100.163','2017-08-29 21:41:02','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5117','63','更新仓库','192.168.100.163','2017-08-29 21:41:22','0','更新仓库ID为  4 成功！','更新仓库成功'), ('5118','63','更新仓库','192.168.100.163','2017-08-29 21:41:26','0','更新仓库ID为  4 成功！','更新仓库成功'), ('5119','63','更新应用','192.168.100.163','2017-08-29 21:51:30','0','更新应用ID为  25 成功！','更新应用成功'), ('5120','63','更新应用','192.168.100.163','2017-08-29 21:51:34','0','更新应用ID为  24 成功！','更新应用成功'), ('5121','63','更新应用','192.168.100.163','2017-08-29 21:52:57','0','更新应用ID为  23 成功！','更新应用成功');
INSERT INTO `jsh_log` VALUES ('5122','63','增加单据','192.168.100.163','2017-08-29 23:22:53','0','增加单据编号为  LSCK201708290001 成功！','增加单据成功'), ('5123','63','保存仓管通明细','192.168.100.163','2017-08-29 23:22:54','0','保存仓管通明细对应主表编号为  40 成功！','保存仓管通明细成功'), ('5124','63','增加单据','192.168.100.163','2017-08-29 23:29:39','0','增加单据编号为  LSCK201708290002 成功！','增加单据成功'), ('5125','63','保存仓管通明细','192.168.100.163','2017-08-29 23:29:40','0','保存仓管通明细对应主表编号为  41 成功！','保存仓管通明细成功'), ('5126','63','增加单据','192.168.100.163','2017-08-29 23:35:12','0','增加单据编号为  LSCK201708290003 成功！','增加单据成功'), ('5127','63','保存仓管通明细','192.168.100.163','2017-08-29 23:35:13','0','保存仓管通明细对应主表编号为  42 成功！','保存仓管通明细成功'), ('5128','63','增加单据','192.168.100.163','2017-08-29 23:39:44','0','增加单据编号为  LSCK201708290004 成功！','增加单据成功'), ('5129','63','保存仓管通明细','192.168.100.163','2017-08-29 23:39:44','0','保存仓管通明细对应主表编号为  43 成功！','保存仓管通明细成功'), ('5130','63','批量修改单据状态','192.168.100.163','2017-08-29 23:39:48','0','批量修改状态，单据ID为  43 成功！','批量修改单据状态成功'), ('5131','63','批量修改单据状态','192.168.100.163','2017-08-29 23:40:02','0','批量修改状态，单据ID为  43 成功！','批量修改单据状态成功'), ('5132','63','增加单据','192.168.100.163','2017-08-29 23:48:43','0','增加单据编号为  LSTH201708290001 成功！','增加单据成功'), ('5133','63','保存仓管通明细','192.168.100.163','2017-08-29 23:48:43','0','保存仓管通明细对应主表编号为  44 成功！','保存仓管通明细成功'), ('5134','63','增加单据','192.168.100.163','2017-08-29 23:51:55','0','增加单据编号为  LSTH201708290002 成功！','增加单据成功'), ('5135','63','保存仓管通明细','192.168.100.163','2017-08-29 23:51:56','0','保存仓管通明细对应主表编号为  45 成功！','保存仓管通明细成功'), ('5136','63','更新单据','192.168.100.163','2017-08-29 23:52:09','0','更新单据ID为  45 成功！','更新单据成功'), ('5137','63','保存仓管通明细','192.168.100.163','2017-08-29 23:52:09','0','保存仓管通明细对应主表编号为  45 成功！','保存仓管通明细成功'), ('5138','63','登录系统','192.168.100.163','2017-08-30 00:39:39','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5139','63','登录系统','192.168.100.163','2017-08-30 20:37:47','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5140','63','登录系统','192.168.100.163','2017-08-30 20:59:10','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5141','63','登录系统','192.168.100.163','2017-08-30 23:01:32','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5142','63','更新应用','192.168.100.163','2017-08-30 23:08:24','0','更新应用ID为  23 成功！','更新应用成功'), ('5143','63','更新应用','192.168.100.163','2017-08-30 23:08:34','0','更新应用ID为  24 成功！','更新应用成功'), ('5144','63','更新应用','192.168.100.163','2017-08-30 23:08:40','0','更新应用ID为  25 成功！','更新应用成功'), ('5145','63','更新应用','192.168.100.163','2017-08-30 23:09:10','0','更新应用ID为  24 成功！','更新应用成功'), ('5146','63','更新应用','192.168.100.163','2017-08-30 23:09:15','0','更新应用ID为  25 成功！','更新应用成功'), ('5147','63','更新应用','192.168.100.163','2017-08-30 23:09:40','0','更新应用ID为  24 成功！','更新应用成功'), ('5148','63','更新应用','192.168.100.163','2017-08-30 23:10:52','0','更新应用ID为  23 成功！','更新应用成功'), ('5149','63','更新应用','192.168.100.163','2017-08-30 23:10:56','0','更新应用ID为  25 成功！','更新应用成功'), ('5150','63','更新应用','192.168.100.163','2017-08-30 23:11:44','0','更新应用ID为  8 成功！','更新应用成功'), ('5151','63','增加单据','192.168.100.163','2017-08-30 23:19:46','0','增加单据编号为  LSCK201708300001 成功！','增加单据成功'), ('5152','63','保存仓管通明细','192.168.100.163','2017-08-30 23:19:46','0','保存仓管通明细对应主表编号为  46 成功！','保存仓管通明细成功'), ('5153','63','增加单据','192.168.100.163','2017-08-30 23:38:11','0','增加单据编号为  LSCK201708300002 成功！','增加单据成功'), ('5154','63','保存仓管通明细','192.168.100.163','2017-08-30 23:38:12','0','保存仓管通明细对应主表编号为  47 成功！','保存仓管通明细成功'), ('5155','63','更新供应商预付款','','2017-08-30 23:39:45','0','更新供应商ID为  7 成功！','更新供应商成功'), ('5156','63','删除单据','192.168.100.163','2017-08-30 23:39:45','0','删除单据ID为  47 成功！','删除单据成功'), ('5157','63','更新供应商预付款','','2017-08-30 23:59:30','0','更新供应商ID为  7 成功！','更新供应商成功'), ('5158','63','批量删除单据','192.168.100.163','2017-08-30 23:59:30','0','批量删除单据ID为  46 成功！','批量删除单据成功'), ('5159','63','增加单据','192.168.100.163','2017-08-31 00:30:31','0','增加单据编号为  LSCK201708310001 成功！','增加单据成功'), ('5160','63','保存仓管通明细','192.168.100.163','2017-08-31 00:30:32','0','保存仓管通明细对应主表编号为  48 成功！','保存仓管通明细成功'), ('5161','63','更新单据','192.168.100.163','2017-08-31 00:55:26','0','更新单据ID为  48 成功！','更新单据成功'), ('5162','63','增加单据','192.168.100.163','2017-08-31 00:57:40','0','增加单据编号为  LSCK201708310002 成功！','增加单据成功'), ('5163','63','保存仓管通明细','192.168.100.163','2017-08-31 00:57:41','0','保存仓管通明细对应主表编号为  49 成功！','保存仓管通明细成功'), ('5164','63','删除单据','192.168.100.163','2017-08-31 00:57:47','0','删除单据ID为  40 成功！','删除单据成功'), ('5165','63','更新供应商预付款','','2017-08-31 00:57:47','0','更新供应商ID为  7 成功！','更新供应商成功'), ('5166','63','登录系统','192.168.100.163','2017-08-31 20:27:25','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5167','63','增加功能','192.168.100.163','2017-08-31 21:25:40','0','增加功能名称为  入库明细 成功！','增加功能成功'), ('5168','63','增加功能','192.168.100.163','2017-08-31 21:28:19','0','增加功能名称为  出库明细 成功！','增加功能成功'), ('5169','63','增加功能','192.168.100.163','2017-08-31 21:29:14','0','增加功能名称为  入库汇总 成功！','增加功能成功'), ('5170','63','增加功能','192.168.100.163','2017-08-31 21:29:57','0','增加功能名称为  出库汇总 成功！','增加功能成功'), ('5171','63','更新UserBusiness','192.168.100.163','2017-08-31 21:30:25','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5172','63','登录系统','192.168.100.163','2017-08-31 21:51:39','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5173','63','登录系统','192.168.100.163','2017-08-31 22:07:02','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5174','63','登录系统','192.168.100.163','2017-09-01 23:06:53','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5175','63','登录系统','192.168.1.106','2017-09-03 12:46:05','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5176','63','增加单据','192.168.1.106','2017-09-03 12:51:50','0','增加单据编号为  LSCK201709030001 成功！','增加单据成功'), ('5177','63','保存仓管通明细','192.168.1.106','2017-09-03 12:51:50','0','保存仓管通明细对应主表编号为  50 成功！','保存仓管通明细成功'), ('5178','63','登录系统','192.168.100.163','2017-09-03 19:10:57','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5179','63','登录系统','192.168.100.163','2017-09-03 23:06:24','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5180','63','登录系统','192.168.100.163','2017-09-04 20:12:43','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5181','63','登录系统','192.168.100.163','2017-09-04 21:24:35','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5182','63','增加单据','192.168.100.163','2017-09-04 21:29:44','0','增加单据编号为  LSCK201709040001 成功！','增加单据成功'), ('5183','63','保存仓管通明细','192.168.100.163','2017-09-04 21:29:45','0','保存仓管通明细对应主表编号为  51 成功！','保存仓管通明细成功'), ('5184','63','更新供应商预付款','','2017-09-04 21:29:50','0','更新供应商ID为  7 成功！','更新供应商成功'), ('5185','63','批量删除单据','192.168.100.163','2017-09-04 21:29:50','0','批量删除单据ID为  51 成功！','批量删除单据成功'), ('5186','63','增加单据','192.168.100.163','2017-09-04 21:32:49','0','增加单据编号为  LSCK201709040001 成功！','增加单据成功'), ('5187','63','保存仓管通明细','192.168.100.163','2017-09-04 21:32:50','0','保存仓管通明细对应主表编号为  52 成功！','保存仓管通明细成功'), ('5188','63','增加单据','192.168.100.163','2017-09-04 21:34:02','0','增加单据编号为  LSCK201709040002 成功！','增加单据成功'), ('5189','63','保存仓管通明细','192.168.100.163','2017-09-04 21:34:02','0','保存仓管通明细对应主表编号为  53 成功！','保存仓管通明细成功'), ('5190','63','批量修改单据状态','192.168.100.163','2017-09-04 21:51:45','0','批量修改状态，单据ID为  50 成功！','批量修改单据状态成功'), ('5191','63','增加供应商','192.168.100.163','2017-09-04 22:12:38','0','增加供应商名称为  aaaa 成功！','增加供应商成功'), ('5192','63','删除供应商','192.168.100.163','2017-09-04 22:12:54','0','删除供应商ID为  47,名称为  aaaa成功！','删除供应商成功'), ('5193','63','增加单据','192.168.100.163','2017-09-04 22:20:12','0','增加单据编号为  CGRK201709040001 成功！','增加单据成功'), ('5194','63','保存仓管通明细','192.168.100.163','2017-09-04 22:20:12','0','保存仓管通明细对应主表编号为  54 成功！','保存仓管通明细成功'), ('5195','63','更新单据','192.168.100.163','2017-09-04 22:26:36','0','更新单据ID为  54 成功！','更新单据成功'), ('5196','63','增加单据','192.168.100.163','2017-09-05 00:10:03','0','增加单据编号为  LPCZ201709050001 成功！','增加单据成功'), ('5197','63','保存仓管通明细','192.168.100.163','2017-09-05 00:10:04','0','保存仓管通明细对应主表编号为  55 成功！','保存仓管通明细成功'), ('5198','63','登录系统','192.168.100.163','2017-09-05 20:59:16','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5199','63','登录系统','192.168.100.163','2017-09-05 21:00:57','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5200','63','增加单据','192.168.100.163','2017-09-05 22:30:17','0','增加单据编号为  LPXS201709050001 成功！','增加单据成功'), ('5201','63','保存仓管通明细','192.168.100.163','2017-09-05 22:30:17','0','保存仓管通明细对应主表编号为  56 成功！','保存仓管通明细成功'), ('5202','63','增加单据','192.168.100.163','2017-09-05 22:37:54','0','增加单据编号为  CGRK201709050001 成功！','增加单据成功'), ('5203','63','保存仓管通明细','192.168.100.163','2017-09-05 22:37:54','0','保存仓管通明细对应主表编号为  57 成功！','保存仓管通明细成功'), ('5204','63','增加单据','192.168.100.163','2017-09-05 22:45:23','0','增加单据编号为  LPXS201709050002 成功！','增加单据成功'), ('5205','63','保存仓管通明细','192.168.100.163','2017-09-05 22:45:23','0','保存仓管通明细对应主表编号为  58 成功！','保存仓管通明细成功'), ('5206','63','更新单据','192.168.100.163','2017-09-05 22:45:31','0','更新单据ID为  58 成功！','更新单据成功'), ('5207','63','保存仓管通明细','192.168.100.163','2017-09-05 22:45:31','0','保存仓管通明细对应主表编号为  58 成功！','保存仓管通明细成功'), ('5208','63','登录系统','192.168.100.163','2017-09-05 23:10:58','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5209','63','增加单据','192.168.100.163','2017-09-05 23:12:18','0','增加单据编号为  LPCZ201709050002 成功！','增加单据成功'), ('5210','63','保存仓管通明细','192.168.100.163','2017-09-05 23:12:18','0','保存仓管通明细对应主表编号为  59 成功！','保存仓管通明细成功'), ('5211','63','更新单据','192.168.100.163','2017-09-05 23:15:45','0','更新单据ID为  58 成功！','更新单据成功'), ('5212','63','保存仓管通明细','192.168.100.163','2017-09-05 23:15:45','0','保存仓管通明细对应主表编号为  58 成功！','保存仓管通明细成功'), ('5213','63','登录系统','192.168.100.163','2017-09-05 23:25:23','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5214','63','批量删除单据','192.168.100.163','2017-09-05 23:25:55','0','批量删除单据ID为  58,56 成功！','批量删除单据成功'), ('5215','63','批量删除单据','192.168.100.163','2017-09-05 23:25:59','0','批量删除单据ID为  59,55 成功！','批量删除单据成功'), ('5216','63','增加单据','192.168.100.163','2017-09-05 23:45:48','0','增加单据编号为  LPCZ201709050001 成功！','增加单据成功'), ('5217','63','保存仓管通明细','192.168.100.163','2017-09-05 23:45:48','0','保存仓管通明细对应主表编号为  60 成功！','保存仓管通明细成功'), ('5218','63','增加单据','192.168.100.163','2017-09-05 23:48:10','0','增加单据编号为  LPXS201709050001 成功！','增加单据成功'), ('5219','63','保存仓管通明细','192.168.100.163','2017-09-05 23:48:11','0','保存仓管通明细对应主表编号为  61 成功！','保存仓管通明细成功'), ('5220','63','增加单据','192.168.100.163','2017-09-05 23:52:42','0','增加单据编号为  LPCZ201709050002 成功！','增加单据成功'), ('5221','63','保存仓管通明细','192.168.100.163','2017-09-05 23:52:42','0','保存仓管通明细对应主表编号为  62 成功！','保存仓管通明细成功');
INSERT INTO `jsh_log` VALUES ('5222','63','登录系统','192.168.100.163','2017-09-06 22:21:32','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5223','63','登录系统','127.0.0.1','2017-09-16 22:14:22','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5224','63','????','127.0.0.1','2017-09-16 22:40:55','0','?????jsh ????','jsh ????'), ('5225','63','????','127.0.0.1','2017-09-16 22:41:03','0','?????jsh ????','jsh ????'), ('5226','63','退出系统','127.0.0.1','2017-09-16 22:44:59','0','管理用户：jsh 退出系统','jsh 退出系统'), ('5227','63','登录系统','127.0.0.1','2017-09-16 22:45:22','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5228','63','登录系统','127.0.0.1','2017-09-16 23:08:10','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5229','63','登录系统','127.0.0.1','2017-09-16 23:23:28','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5230','63','登录系统','127.0.0.1','2017-09-16 23:39:29','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5231','63','增加功能','127.0.0.1','2017-09-16 23:42:01','0','增加功能名称为  啊啊 成功！','增加功能成功'), ('5232','63','更新功能','127.0.0.1','2017-09-16 23:42:44','0','更新功能ID为  230 成功！','更新功能成功'), ('5233','63','增加功能','127.0.0.1','2017-09-16 23:44:51','0','增加功能名称为  溜溜 成功！','增加功能成功'), ('5234','63','更新功能','127.0.0.1','2017-09-16 23:45:09','0','更新功能ID为  231 成功！','更新功能成功'), ('5235','63','更新UserBusiness','127.0.0.1','2017-09-16 23:45:54','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5236','63','登录系统','127.0.0.1','2017-09-16 23:47:50','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5237','63','更新UserBusiness','127.0.0.1','2017-09-16 23:49:02','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5238','63','批量删除功能','127.0.0.1','2017-09-16 23:49:42','0','批量删除功能ID为  230,231 成功！','批量删除功能成功'), ('5239','63','登录系统','127.0.0.1','2017-09-17 00:03:00','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5240','63','登录系统','127.0.0.1','2017-09-17 20:16:21','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5241','63','更新单据','127.0.0.1','2017-09-17 20:17:17','0','更新单据ID为  57 成功！','更新单据成功'), ('5242','63','保存仓管通明细','127.0.0.1','2017-09-17 20:17:17','0','保存仓管通明细对应主表编号为  57 成功！','保存仓管通明细成功'), ('5243','63','登录系统','127.0.0.1','2017-09-17 21:38:44','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5244','63','增加单据','127.0.0.1','2017-09-17 21:45:14','0','增加单据编号为  CGRK201709170001 成功！','增加单据成功'), ('5245','63','保存仓管通明细','127.0.0.1','2017-09-17 21:45:14','0','保存仓管通明细对应主表编号为  63 成功！','保存仓管通明细成功'), ('5246','63','增加单据','127.0.0.1','2017-09-17 21:45:44','0','增加单据编号为  CGRK201709170002 成功！','增加单据成功'), ('5247','63','保存仓管通明细','127.0.0.1','2017-09-17 21:45:44','0','保存仓管通明细对应主表编号为  64 成功！','保存仓管通明细成功'), ('5248','63','批量删除单据','127.0.0.1','2017-09-17 21:45:53','0','批量删除单据ID为  64 成功！','批量删除单据成功'), ('5249','63','增加单据','127.0.0.1','2017-09-17 21:47:07','0','增加单据编号为  CGRK201709170002 成功！','增加单据成功'), ('5250','63','保存仓管通明细','127.0.0.1','2017-09-17 21:47:08','0','保存仓管通明细对应主表编号为  65 成功！','保存仓管通明细成功'), ('5251','63','批量修改单据状态','127.0.0.1','2017-09-17 23:09:39','0','批量修改状态，单据ID为  63 成功！','批量修改单据状态成功'), ('5252','63','登录系统','106.120.11.23','2017-09-19 20:56:34','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5253','63','批量修改单据状态','106.39.148.33','2017-09-19 20:57:32','0','批量修改状态，单据ID为  53 成功！','批量修改单据状态成功'), ('5254','63','批量修改单据状态','106.39.148.33','2017-09-19 20:58:19','0','批量修改状态，单据ID为  53 成功！','批量修改单据状态成功'), ('5255','63','批量修改单据状态','106.39.148.33','2017-09-19 20:58:43','0','批量修改状态，单据ID为  45 成功！','批量修改单据状态成功'), ('5256','63','批量修改商品状态','106.39.148.33','2017-09-19 20:59:37','0','批量修改状态，商品ID为  559 成功！','批量修改商品状态成功'), ('5257','63','登录系统','119.86.127.38','2017-09-19 21:01:40','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5258','63','删除经手人','106.120.11.23','2017-09-19 21:02:02','0','删除经手人ID为  1 成功！','删除经手人成功'), ('5259','63','删除经手人','106.120.11.23','2017-09-19 21:02:06','0','删除经手人ID为  2 成功！','删除经手人成功'), ('5260','63','批量修改单据状态','106.120.11.23','2017-09-19 21:02:30','0','批量修改状态，单据ID为  65 成功！','批量修改单据状态成功'), ('5261','63','登录系统','220.112.121.70','2017-09-19 21:05:52','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5262','63','登录系统','115.195.91.50','2017-09-19 21:07:11','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5263','63','退出系统','115.195.91.50','2017-09-19 21:08:05','0','管理用户：jsh 退出系统','jsh 退出系统'), ('5264','63','登录系统','117.64.147.64','2017-09-19 21:22:18','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5265','63','登录系统','211.148.101.34','2017-09-19 22:15:22','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5266','63','登录系统','211.148.101.34','2017-09-19 22:16:15','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5267','63','登录系统','117.175.132.159','2017-09-19 22:16:40','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5268','63','登录系统','117.75.19.137','2017-09-19 22:33:12','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5269','63','登录系统','183.198.47.127','2017-09-19 22:35:44','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5270','63','删除应用','114.62.212.4','2017-09-19 22:48:34','0','删除应用ID为  21 成功！','删除应用成功'), ('5271','63','删除应用','114.62.212.4','2017-09-19 22:48:50','0','删除应用ID为  1 成功！','删除应用成功'), ('5272','63','删除应用','114.62.212.4','2017-09-19 22:49:20','0','删除应用ID为  20 成功！','删除应用成功'), ('5273','63','更新应用','114.62.212.4','2017-09-19 22:52:57','0','更新应用ID为  8 成功！','更新应用成功'), ('5274','63','更新应用','114.62.212.4','2017-09-19 22:53:02','0','更新应用ID为  8 成功！','更新应用成功'), ('5275','63','更新应用','114.62.212.4','2017-09-19 22:59:14','0','更新应用ID为  26 成功！','更新应用成功'), ('5276','63','增加功能','114.62.212.4','2017-09-19 22:59:43','0','增加功能名称为  组装拆卸 成功！','增加功能成功'), ('5277','63','更新功能','114.62.212.4','2017-09-19 23:01:10','0','更新功能ID为  230 成功！','更新功能成功'), ('5278','63','更新功能','114.62.212.4','2017-09-19 23:01:32','0','更新功能ID为  221 成功！','更新功能成功'), ('5279','63','更新功能','114.62.212.4','2017-09-19 23:01:51','0','更新功能ID为  196 成功！','更新功能成功'), ('5280','63','增加功能','114.62.212.4','2017-09-19 23:05:09','0','增加功能名称为  组装单 成功！','增加功能成功'), ('5281','63','增加功能','114.62.212.4','2017-09-19 23:06:05','0','增加功能名称为  拆卸单 成功！','增加功能成功'), ('5282','63','更新UserBusiness','114.62.212.4','2017-09-19 23:06:52','0','更新UserBusiness的ID为  1 成功！','更新UserBusiness成功'), ('5283','63','更新UserBusiness','114.62.212.4','2017-09-19 23:07:15','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5284','63','更新功能','114.62.212.4','2017-09-19 23:08:36','0','更新功能ID为  231 成功！','更新功能成功'), ('5285','63','更新功能','114.62.212.4','2017-09-19 23:09:08','0','更新功能ID为  232 成功！','更新功能成功'), ('5286','63','更新功能','114.62.212.4','2017-09-19 23:09:20','0','更新功能ID为  232 成功！','更新功能成功'), ('5287','63','增加功能','114.62.212.4','2017-09-19 23:09:59','0','增加功能名称为  拆卸单 成功！','增加功能成功'), ('5288','63','登录系统','183.38.180.158','2017-09-19 23:26:15','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5289','63','更新功能','114.62.212.4','2017-09-19 23:26:22','0','更新功能ID为  232 成功！','更新功能成功'), ('5290','63','更新功能','114.62.212.4','2017-09-19 23:26:34','0','更新功能ID为  233 成功！','更新功能成功'), ('5291','63','更新功能','114.62.212.4','2017-09-19 23:28:10','0','更新功能ID为  233 成功！','更新功能成功'), ('5292','63','更新功能','114.62.212.4','2017-09-19 23:28:24','0','更新功能ID为  232 成功！','更新功能成功'), ('5293','63','登录系统','127.0.0.1','2017-09-19 23:32:29','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5294','63','登录系统','127.0.0.1','2017-09-20 21:32:00','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5295','63','增加单据','127.0.0.1','2017-09-20 22:59:53','0','增加单据编号为  ZZD201709200001 成功！','增加单据成功'), ('5296','63','保存仓管通明细','127.0.0.1','2017-09-20 22:59:53','0','保存仓管通明细对应主表编号为  66 成功！','保存仓管通明细成功'), ('5297','63','登录系统','127.0.0.1','2017-09-20 23:25:57','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5298','63','增加单据','127.0.0.1','2017-09-20 23:26:34','0','增加单据编号为  ZZD201709200002 成功！','增加单据成功'), ('5299','63','保存仓管通明细','127.0.0.1','2017-09-20 23:26:35','0','保存仓管通明细对应主表编号为  67 成功！','保存仓管通明细成功'), ('5300','63','批量删除单据','127.0.0.1','2017-09-20 23:28:45','0','批量删除单据ID为  66 成功！','批量删除单据成功'), ('5301','63','批量删除单据','127.0.0.1','2017-09-20 23:28:48','0','批量删除单据ID为  67 成功！','批量删除单据成功'), ('5302','63','增加单据','127.0.0.1','2017-09-20 23:29:28','0','增加单据编号为  ZZD201709200001 成功！','增加单据成功'), ('5303','63','保存仓管通明细','127.0.0.1','2017-09-20 23:29:28','0','保存仓管通明细对应主表编号为  68 成功！','保存仓管通明细成功'), ('5304','63','更新功能','127.0.0.1','2017-09-20 23:30:44','0','更新功能ID为  233 成功！','更新功能成功'), ('5305','63','更新功能','127.0.0.1','2017-09-20 23:30:52','0','更新功能ID为  232 成功！','更新功能成功'), ('5306','63','更新功能','127.0.0.1','2017-09-20 23:30:55','0','更新功能ID为  232 成功！','更新功能成功'), ('5307','63','更新功能','127.0.0.1','2017-09-20 23:32:57','0','更新功能ID为  232 成功！','更新功能成功'), ('5308','63','更新角色按钮权限','','2017-09-20 23:33:53','0','角色按钮权限的ID为  5 成功！','更新角色按钮权限成功'), ('5309','63','增加单据','127.0.0.1','2017-09-20 23:40:55','0','增加单据编号为  CSD201709200001 成功！','增加单据成功'), ('5310','63','保存仓管通明细','127.0.0.1','2017-09-20 23:40:56','0','保存仓管通明细对应主表编号为  69 成功！','保存仓管通明细成功'), ('5311','63','增加单据','127.0.0.1','2017-09-20 23:42:49','0','增加单据编号为  CGRK201709200001 成功！','增加单据成功'), ('5312','63','保存仓管通明细','127.0.0.1','2017-09-20 23:42:50','0','保存仓管通明细对应主表编号为  70 成功！','保存仓管通明细成功'), ('5313','63','删除单据','127.0.0.1','2017-09-20 23:43:08','0','删除单据ID为  70 成功！','删除单据成功'), ('5314','63','登录系统','127.0.0.1','2017-09-21 22:32:58','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5315','63','增加单据','127.0.0.1','2017-09-21 22:37:20','0','增加单据编号为  CGRK201709210001 成功！','增加单据成功'), ('5316','63','保存仓管通明细','127.0.0.1','2017-09-21 22:37:21','0','保存仓管通明细对应主表编号为  70 成功！','保存仓管通明细成功'), ('5317','63','增加单据','127.0.0.1','2017-09-21 22:39:00','0','增加单据编号为  XSTH201709210001 成功！','增加单据成功'), ('5318','63','保存仓管通明细','127.0.0.1','2017-09-21 22:39:01','0','保存仓管通明细对应主表编号为  71 成功！','保存仓管通明细成功'), ('5319','63','增加单据','127.0.0.1','2017-09-21 22:39:26','0','增加单据编号为  QTRK201709210001 成功！','增加单据成功'), ('5320','63','保存仓管通明细','127.0.0.1','2017-09-21 22:39:26','0','保存仓管通明细对应主表编号为  72 成功！','保存仓管通明细成功'), ('5321','63','增加单据','127.0.0.1','2017-09-21 22:40:01','0','增加单据编号为  XSCK201709210001 成功！','增加单据成功');
INSERT INTO `jsh_log` VALUES ('5322','63','保存仓管通明细','127.0.0.1','2017-09-21 22:40:01','0','保存仓管通明细对应主表编号为  73 成功！','保存仓管通明细成功'), ('5323','63','增加单据','127.0.0.1','2017-09-21 22:40:57','0','增加单据编号为  CGTH201709210001 成功！','增加单据成功'), ('5324','63','保存仓管通明细','127.0.0.1','2017-09-21 22:40:57','0','保存仓管通明细对应主表编号为  74 成功！','保存仓管通明细成功'), ('5325','63','增加单据','127.0.0.1','2017-09-21 22:41:15','0','增加单据编号为  QTCK201709210001 成功！','增加单据成功'), ('5326','63','保存仓管通明细','127.0.0.1','2017-09-21 22:41:15','0','保存仓管通明细对应主表编号为  75 成功！','保存仓管通明细成功'), ('5327','63','增加单据','127.0.0.1','2017-09-21 22:41:36','0','增加单据编号为  DBCK201709210001 成功！','增加单据成功'), ('5328','63','保存仓管通明细','127.0.0.1','2017-09-21 22:41:36','0','保存仓管通明细对应主表编号为  76 成功！','保存仓管通明细成功'), ('5329','63','增加单据','127.0.0.1','2017-09-21 22:42:44','0','增加单据编号为  LSCK201709210001 成功！','增加单据成功'), ('5330','63','保存仓管通明细','127.0.0.1','2017-09-21 22:42:44','0','保存仓管通明细对应主表编号为  77 成功！','保存仓管通明细成功'), ('5331','63','增加单据','127.0.0.1','2017-09-21 22:46:07','0','增加单据编号为  LSTH201709210001 成功！','增加单据成功'), ('5332','63','保存仓管通明细','127.0.0.1','2017-09-21 22:46:07','0','保存仓管通明细对应主表编号为  78 成功！','保存仓管通明细成功'), ('5333','63','更新功能','127.0.0.1','2017-09-21 22:50:07','0','更新功能ID为  214 成功！','更新功能成功'), ('5334','63','更新功能','127.0.0.1','2017-09-21 22:50:28','0','更新功能ID为  215 成功！','更新功能成功'), ('5335','63','更新角色按钮权限','','2017-09-21 22:50:50','0','角色按钮权限的ID为  5 成功！','更新角色按钮权限成功'), ('5336','63','批量修改单据状态','127.0.0.1','2017-09-21 22:51:05','0','批量修改状态，单据ID为  62 成功！','批量修改单据状态成功'), ('5337','63','批量修改单据状态','127.0.0.1','2017-09-21 22:51:08','0','批量修改状态，单据ID为  62 成功！','批量修改单据状态成功'), ('5338','63','更新功能','127.0.0.1','2017-09-21 22:54:01','0','更新功能ID为  232 成功！','更新功能成功'), ('5339','63','更新功能','127.0.0.1','2017-09-21 22:54:26','0','更新功能ID为  233 成功！','更新功能成功'), ('5340','63','更新功能','127.0.0.1','2017-09-21 22:54:32','0','更新功能ID为  233 成功！','更新功能成功'), ('5341','63','更新UserBusiness','127.0.0.1','2017-09-21 23:04:48','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5342','63','更新UserBusiness','127.0.0.1','2017-09-21 23:05:30','0','更新UserBusiness的ID为  5 成功！','更新UserBusiness成功'), ('5343','63','更新角色按钮权限','','2017-09-21 23:05:53','0','角色按钮权限的ID为  5 成功！','更新角色按钮权限成功'), ('5344','63','批量修改单据状态','127.0.0.1','2017-09-21 23:08:01','0','批量修改状态，单据ID为  69 成功！','批量修改单据状态成功'), ('5345','63','批量修改单据状态','127.0.0.1','2017-09-21 23:08:03','0','批量修改状态，单据ID为  69 成功！','批量修改单据状态成功'), ('5346','63','批量修改单据状态','127.0.0.1','2017-09-21 23:08:07','0','批量修改状态，单据ID为  68 成功！','批量修改单据状态成功'), ('5347','63','批量修改单据状态','127.0.0.1','2017-09-21 23:08:09','0','批量修改状态，单据ID为  68 成功！','批量修改单据状态成功'), ('5348','63','增加单据','127.0.0.1','2017-09-21 23:16:37','0','增加单据编号为  CGRK201709210002 成功！','增加单据成功'), ('5349','63','保存仓管通明细','127.0.0.1','2017-09-21 23:16:37','0','保存仓管通明细对应主表编号为  79 成功！','保存仓管通明细成功'), ('5350','63','增加单据','127.0.0.1','2017-09-21 23:17:16','0','增加单据编号为  ZZD201709210001 成功！','增加单据成功'), ('5351','63','保存仓管通明细','127.0.0.1','2017-09-21 23:17:16','0','保存仓管通明细对应主表编号为  80 成功！','保存仓管通明细成功'), ('5352','63','更新单据','127.0.0.1','2017-09-21 23:18:48','0','更新单据ID为  69 成功！','更新单据成功'), ('5353','63','更新单据','127.0.0.1','2017-09-21 23:23:39','0','更新单据ID为  80 成功！','更新单据成功'), ('5354','63','保存仓管通明细','127.0.0.1','2017-09-21 23:23:40','0','保存仓管通明细对应主表编号为  80 成功！','保存仓管通明细成功'), ('5355','63','更新单据','127.0.0.1','2017-09-21 23:24:11','0','更新单据ID为  68 成功！','更新单据成功'), ('5356','63','保存仓管通明细','127.0.0.1','2017-09-21 23:24:11','0','保存仓管通明细对应主表编号为  68 成功！','保存仓管通明细成功'), ('5357','63','批量修改单据状态','127.0.0.1','2017-09-21 23:24:17','0','批量修改状态，单据ID为  80 成功！','批量修改单据状态成功'), ('5358','63','登录系统','127.0.0.1','2017-09-22 21:45:27','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5359','63','登录系统','127.0.0.1','2017-09-22 22:30:07','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5360','63','批量修改单据状态','127.0.0.1','2017-09-22 22:37:57','0','批量修改状态，单据ID为  65 成功！','批量修改单据状态成功'), ('5361','63','更新单据','127.0.0.1','2017-09-22 22:38:19','0','更新单据ID为  65 成功！','更新单据成功'), ('5362','63','增加单据','127.0.0.1','2017-09-22 22:43:28','0','增加单据编号为  CGRK201709220001 成功！','增加单据成功'), ('5363','63','保存仓管通明细','127.0.0.1','2017-09-22 22:43:28','0','保存仓管通明细对应主表编号为  81 成功！','保存仓管通明细成功'), ('5364','63','更新单据','127.0.0.1','2017-09-22 22:46:52','0','更新单据ID为  65 成功！','更新单据成功'), ('5365','63','更新单据','127.0.0.1','2017-09-22 22:51:06','0','更新单据ID为  65 成功！','更新单据成功'), ('5366','63','更新单据','127.0.0.1','2017-09-22 22:51:30','0','更新单据ID为  65 成功！','更新单据成功'), ('5367','63','登录系统','127.0.0.1','2017-09-22 22:57:39','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5368','63','更新单据','127.0.0.1','2017-09-22 22:59:16','0','更新单据ID为  65 成功！','更新单据成功'), ('5369','63','更新单据','127.0.0.1','2017-09-22 23:02:38','0','更新单据ID为  81 成功！','更新单据成功'), ('5370','63','更新单据','127.0.0.1','2017-09-22 23:02:49','0','更新单据ID为  81 成功！','更新单据成功'), ('5371','63','更新单据','127.0.0.1','2017-09-22 23:03:10','0','更新单据ID为  65 成功！','更新单据成功'), ('5372','63','更新单据','127.0.0.1','2017-09-22 23:03:39','0','更新单据ID为  81 成功！','更新单据成功'), ('5373','63','更新单据','127.0.0.1','2017-09-22 23:04:39','0','更新单据ID为  81 成功！','更新单据成功'), ('5374','63','更新单据','127.0.0.1','2017-09-22 23:05:17','0','更新单据ID为  65 成功！','更新单据成功'), ('5375','63','删除单据','127.0.0.1','2017-09-22 23:05:37','0','删除单据ID为  81 成功！','删除单据成功'), ('5376','63','增加单据','127.0.0.1','2017-09-22 23:06:01','0','增加单据编号为  CGRK201709220001 成功！','增加单据成功'), ('5377','63','保存仓管通明细','127.0.0.1','2017-09-22 23:06:02','0','保存仓管通明细对应主表编号为  82 成功！','保存仓管通明细成功'), ('5378','63','更新单据','127.0.0.1','2017-09-22 23:07:13','0','更新单据ID为  82 成功！','更新单据成功'), ('5379','63','保存仓管通明细','127.0.0.1','2017-09-22 23:07:14','0','保存仓管通明细对应主表编号为  82 成功！','保存仓管通明细成功'), ('5380','63','增加单据','127.0.0.1','2017-09-22 23:15:38','0','增加单据编号为  LSCK201709220001 成功！','增加单据成功'), ('5381','63','保存仓管通明细','127.0.0.1','2017-09-22 23:15:38','0','保存仓管通明细对应主表编号为  83 成功！','保存仓管通明细成功'), ('5382','63','更新供应商预付款','','2017-09-22 23:15:42','0','更新供应商ID为  7 成功！','更新供应商成功'), ('5383','63','批量删除单据','127.0.0.1','2017-09-22 23:15:42','0','批量删除单据ID为  83 成功！','批量删除单据成功'), ('5384','63','增加单据','127.0.0.1','2017-09-22 23:22:02','0','增加单据编号为  CGRK201709220002 成功！','增加单据成功'), ('5385','63','保存仓管通明细','127.0.0.1','2017-09-22 23:22:03','0','保存仓管通明细对应主表编号为  84 成功！','保存仓管通明细成功'), ('5386','63','更新单据','127.0.0.1','2017-09-22 23:22:54','0','更新单据ID为  54 成功！','更新单据成功'), ('5387','63','保存仓管通明细','127.0.0.1','2017-09-22 23:22:55','0','保存仓管通明细对应主表编号为  54 成功！','保存仓管通明细成功'), ('5388','63','更新单据','127.0.0.1','2017-09-22 23:23:50','0','更新单据ID为  70 成功！','更新单据成功'), ('5389','63','保存仓管通明细','127.0.0.1','2017-09-22 23:23:50','0','保存仓管通明细对应主表编号为  70 成功！','保存仓管通明细成功'), ('5390','63','更新单据','127.0.0.1','2017-09-22 23:25:18','0','更新单据ID为  73 成功！','更新单据成功'), ('5391','63','保存仓管通明细','127.0.0.1','2017-09-22 23:25:18','0','保存仓管通明细对应主表编号为  73 成功！','保存仓管通明细成功'), ('5392','63','登录系统','127.0.0.1','2017-09-24 22:26:31','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5393','63','登录系统','127.0.0.1','2017-09-24 22:31:09','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5394','63','增加单据','127.0.0.1','2017-09-24 22:46:00','0','增加单据编号为  CGRK201709240001 成功！','增加单据成功'), ('5395','63','保存仓管通明细','127.0.0.1','2017-09-24 22:46:00','0','保存仓管通明细对应主表编号为  85 成功！','保存仓管通明细成功'), ('5396','63','登录系统','127.0.0.1','2017-09-25 20:37:31','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5397','63','增加单据','127.0.0.1','2017-09-25 22:19:30','0','增加单据编号为  XSCK201709250001 成功！','增加单据成功'), ('5398','63','保存仓管通明细','127.0.0.1','2017-09-25 22:19:30','0','保存仓管通明细对应主表编号为  86 成功！','保存仓管通明细成功'), ('5399','63','批量删除单据','127.0.0.1','2017-09-25 22:21:04','0','批量删除单据ID为  86 成功！','批量删除单据成功'), ('5400','63','增加单据','127.0.0.1','2017-09-25 22:24:09','0','增加单据编号为  XSCK201709250001 成功！','增加单据成功'), ('5401','63','保存仓管通明细','127.0.0.1','2017-09-25 22:24:09','0','保存仓管通明细对应主表编号为  87 成功！','保存仓管通明细成功'), ('5402','63','增加单据','127.0.0.1','2017-09-25 22:36:51','0','增加单据编号为  XSCK201709250002 成功！','增加单据成功'), ('5403','63','保存仓管通明细','127.0.0.1','2017-09-25 22:36:51','0','保存仓管通明细对应主表编号为  88 成功！','保存仓管通明细成功'), ('5404','63','更新商品','127.0.0.1','2017-09-26 00:19:20','0','更新商品ID为  517 成功！','更新商品成功'), ('5405','63','增加单据','127.0.0.1','2017-09-26 00:26:52','0','增加单据编号为  LSTH201709260001 成功！','增加单据成功'), ('5406','63','保存仓管通明细','127.0.0.1','2017-09-26 00:26:53','0','保存仓管通明细对应主表编号为  89 成功！','保存仓管通明细成功'), ('5407','63','登录系统','127.0.0.1','2017-09-26 22:27:15','0','管理用户：jsh 登录系统','jsh 登录系统'), ('5408','63','批量删除商品','127.0.0.1','2017-09-26 22:29:04','0','批量删除商品ID为  501 成功！','批量删除商品成功'), ('5409','63','增加单据','127.0.0.1','2017-09-26 22:31:24','0','增加单据编号为  LSCK201709260001 成功！','增加单据成功'), ('5410','63','保存仓管通明细','127.0.0.1','2017-09-26 22:31:24','0','保存仓管通明细对应主表编号为  90 成功！','保存仓管通明细成功'), ('5411','63','更新单据','127.0.0.1','2017-09-26 22:36:34','0','更新单据ID为  90 成功！','更新单据成功'), ('5412','63','保存仓管通明细','127.0.0.1','2017-09-26 22:36:34','0','保存仓管通明细对应主表编号为  90 成功！','保存仓管通明细成功');
INSERT INTO `jsh_material` VALUES ('485','6','棉线','制造商a','25','100','A21-4321','5g','','码','','1','1','1','1',NULL,' ',' ',' ',''), ('487','1','网布','制造商b',NULL,'100','12343','10g','','码','','1','1','1','1',NULL,'','','[{\"basic\":{\"Unit\":\"kg\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}},{\"other\":{\"Unit\":\"包\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}}]',''), ('498','1','蕾丝','制造商c',NULL,NULL,'B123a','6g','','码','','1.2','1','1.3','1.4',NULL,'','','[{\"basic\":{\"Unit\":\"kg\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}},{\"other\":{\"Unit\":\"包\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}}]',''), ('499','1','棉线','制造商d',NULL,NULL,'A21-1234','7g','','码','','2.2','2','2.4','2.6',NULL,'','','[{\"basic\":{\"Unit\":\"kg\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}},{\"other\":{\"Unit\":\"包\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}}]',''), ('500','1','纯棉线','制造商e',NULL,NULL,'AAA666','11g','','码','','1.1','1','1.2','1.3',NULL,'','','[{\"basic\":{\"Unit\":\"kg\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}},{\"other\":{\"Unit\":\"包\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}}]',''), ('517','1','奶酪','制造商',NULL,NULL,'AAAA','12ml','','','',NULL,NULL,NULL,NULL,'8','瓶','箱','[{\"basic\":{\"Unit\":\"瓶\",\"RetailPrice\":\"1.5\",\"LowPrice\":\"2\",\"PresetPriceOne\":\"3\",\"PresetPriceTwo\":\"4\"}},{\"other\":{\"Unit\":\"箱\",\"RetailPrice\":\"18\",\"LowPrice\":\"24\",\"PresetPriceOne\":\"36\",\"PresetPriceTwo\":\"48\"}}]',''), ('518','2','安慕希','伊利',NULL,NULL,'abcd','350ml','','','',NULL,NULL,NULL,NULL,'2','kg','包','[{\"basic\":{\"Unit\":\"kg\",\"RetailPrice\":\"2\",\"LowPrice\":\"1\",\"PresetPriceOne\":\"3\",\"PresetPriceTwo\":\"4\"}},{\"other\":{\"Unit\":\"包\",\"RetailPrice\":\"50\",\"LowPrice\":\"25\",\"PresetPriceOne\":\"75\",\"PresetPriceTwo\":\"100\"}}]',''), ('559','1','test','bbb',NULL,NULL,'aaa','','','ccc','','22','11','33','44',NULL,'','','[{\"basic\":{\"Unit\":\"\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}},{\"other\":{\"Unit\":\"\",\"RetailPrice\":\"\",\"LowPrice\":\"\",\"PresetPriceOne\":\"\",\"PresetPriceTwo\":\"\"}}]','\0');
INSERT INTO `jsh_materialcategory` VALUES ('1','根目录','1','1'), ('2','花边一级A','1','1'), ('3','其他','1','1'), ('4','其他','2','3'), ('5','其他','3','4'), ('6','花边二级A','2','2'), ('7','花边三级A','3','6'), ('8','花边二级B','2','2'), ('9','花边一级B','1','1'), ('10','花边三级B','3','6');
INSERT INTO `jsh_person` VALUES ('3','财务员','王五-财务'), ('4','财务员','赵六-财务'), ('5','业务员','小李'), ('6','业务员','小军'), ('7','业务员','小曹');
INSERT INTO `jsh_role` VALUES ('4','管理员'), ('5','仓管员'), ('6','aaaa');
INSERT INTO `jsh_supplier` VALUES ('1','上海某某花边工厂','乔治','','','','1','供应商','','0',NULL,'20',NULL,NULL,'','','','','','','10'), ('2','客户AAAA','佩琪','','','','1','客户','','24',NULL,'30',NULL,NULL,'','','','','','',NULL), ('4','苏州新源布料厂','龙哥','13000000000','312341@qq.com','55','1','供应商','','0','44',NULL,NULL,NULL,'','','','','','','17'), ('5','客户BBBB','彪哥','13000000000','666@qq.com','','1','客户','','36','20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), ('6','南通宝贝家纺','姗姗','1231','31243@qq.com','备注备注备注','1','客户','','0','20',NULL,NULL,NULL,'2134','15678903','地址地址地址','纳税人识别号','开户行','31234124312','0.17'), ('7','非会员','宋江','13000000000','123456@qq.com','','1','会员','','76.6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), ('8','hy00001','宋江','13000000000','','','1','会员','','956',NULL,NULL,NULL,NULL,'','','','','','',NULL), ('9','hy00002','吴用','13000000000','','','1','会员','','344',NULL,NULL,NULL,NULL,'','','','','','',NULL), ('10','1268787965','李逵','82567384','423@qq.com','','1','会员','','2122',NULL,NULL,NULL,NULL,'','13000000001','','','','',NULL), ('45','666666666','武松','82567384','423@qq.com','','1','会员','','2100','0','0','0','0','','13000000001','','','','','0'), ('46','南通居梦莱家纺','曹操','','','','1','供应商','','0',NULL,NULL,'0','0','','13000000000','','','','',NULL);
INSERT INTO `jsh_unit` VALUES ('2','kg,包(1:25)'), ('8','瓶,箱(1:12)'), ('11','qwe,sed(1:33)');
INSERT INTO `jsh_user` VALUES ('63','季圣华','jsh','e10adc3949ba59abbe56e057f20f883e','','','','','0','1','-1','',NULL), ('64','张三','zs','e10adc3949ba59abbe56e057f20f883e','','销售','','','0','1',NULL,'',NULL), ('65','李四','ls','e10adc3949ba59abbe56e057f20f883e','','销售','','','0','1',NULL,'',NULL);
INSERT INTO `jsh_userbusiness` VALUES ('1','RoleAPP','4','[23][24][25][8][26][22][7][3][6]',NULL), ('2','RoleAPP','5','[8][7][6]',NULL), ('3','RoleAPP','6','[21][1][8]',NULL), ('4','RoleAPP','7','[21][1][8][11]',NULL), ('5','RoleFunctions','4','[13][12][16][14][15][22][23][220][25][217][218][26][194][195][31][213][232][233][59][207][208][209][216][226][227][228][229][210][211][214][215][33][200][201][41][199][202][40][197][203][204][205][206][212]','[{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"218\",\"btnStr\":\"1\"},{\"funId\":\"232\",\"btnStr\":\"3\"},{\"funId\":\"233\",\"btnStr\":\"3\"},{\"funId\":\"33\",\"btnStr\":\"3\"},{\"funId\":\"200\",\"btnStr\":\"3\"},{\"funId\":\"201\",\"btnStr\":\"3\"},{\"funId\":\"210\",\"btnStr\":\"3\"},{\"funId\":\"211\",\"btnStr\":\"3\"},{\"funId\":\"214\",\"btnStr\":\"3\"},{\"funId\":\"215\",\"btnStr\":\"3\"},{\"funId\":\"41\",\"btnStr\":\"3\"},{\"funId\":\"199\",\"btnStr\":\"3\"},{\"funId\":\"202\",\"btnStr\":\"3\"},{\"funId\":\"40\",\"btnStr\":\"3\"}]'), ('6','RoleFunctions','5','[22][23][25][26][194][195][31][33][200][201][41][199][202]',NULL), ('7','RoleFunctions','6','[13][12][16][33]','[{\"funId\":\"33\",\"btnStr\":\"4\"}]'), ('8','RoleAPP','8','[21][1][8][11][10]',NULL), ('9','RoleFunctions','7','[168][13][12][16][14][15][189][18][19][132]',NULL), ('10','RoleFunctions','8','[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187]',NULL), ('11','RoleFunctions','9','[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187][188]',NULL), ('12','UserRole','1','[5]',NULL), ('13','UserRole','2','[6][7]',NULL), ('14','UserDepot','2','[1][2][6][7]',NULL), ('15','UserDepot','1','[1][2][5][6][7][10][12][14][15][17]',NULL), ('16','UserRole','63','[4]',NULL), ('17','RoleFunctions','13','[46][47][48][49]',NULL), ('18','UserDepot','63','[1][3]',NULL), ('19','UserDepot','5','[6][45][46][50]',NULL), ('20','UserRole','5','[5]',NULL), ('21','UserRole','64','[5]',NULL), ('22','UserDepot','64','[1]',NULL), ('23','UserRole','65','[5]',NULL), ('24','UserDepot','65','[1]',NULL), ('25','UserCustomer','64','[5][2]',NULL), ('26','UserCustomer','65','[6]',NULL), ('27','UserCustomer','63','[6][5][2]',NULL);
