- 博客(2)
- 资源 (1)
- 收藏
- 关注
RSS订阅原创 C# 获取png图片的非透明部分范围 并裁剪掉透明范围
C# 获取png图片的非透明部分范围 并裁剪掉透明部分1.获取png非透明部分范围 /// <summary> /// 根据图片得到一个图片非透明部分的矩形范围 /// </summary> /// <param name="bckImage"></param> /// <returns></returns> publ..
2021-01-20 11:58:07
1627
1
原创 table2excel.js导出的文件最后多几行代码
在使用table2excel导出excel时表格底下一直显示那几行代码不知道什么原因？有人碰到过么？
2019-10-28 16:28:31
300
2
中国省市、区、县、镇、乡5级联动sql文件
省市、区、县、镇、乡5级联动sql文件；
共74w多条记录，表结构清晰：
CREATE TABLE `position_province` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`province_id` int(11) unsigned NOT NULL COMMENT '省份id、省份编号',
`province_name` char(32) NOT NULL COMMENT '省份名称',
PRIMARY KEY (`id`),
UNIQUE KEY `provice_id` (`province_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='省份数据库';
CREATE TABLE `position_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_id` int(10) unsigned NOT NULL COMMENT '地级市id',
`city_id` bigint(20) unsigned NOT NULL COMMENT '县级市id',
`city_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `city_id` (`city_id`),
KEY `province_id` (`province_id`),
CONSTRAINT `position_city_ibfk_1` FOREIGN KEY (`province_id`) REFERENCES `position_province` (`province_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COMMENT='县级市数据库';
CREATE TABLE `position_country` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地级市主键ID',
`city_id` bigint(20) unsigned NOT NULL COMMENT '地级市id',
`country_id` bigint(20) unsigned NOT NULL COMMENT '县级id',
`country_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `county_id` (`country_id`),
KEY `city_id` (`city_id`),
CONSTRAINT `position_country_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `position_city` (`city_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2857 DEFAULT CHARSET=utf8 COMMENT='地区市数据库';
CREATE TABLE `position_town` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country_id` bigint(20) unsigned NOT NULL COMMENT '县级市id',
`town_id` bigint(20) unsigned NOT NULL COMMENT '镇id',
`town_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `town_id` (`town_id`),
KEY `country_id` (`country_id`) USING BTREE,
CONSTRAINT `position_town_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `position_country` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43855 DEFAULT CHARSET=utf8 COMMENT='镇数据库';
CREATE TABLE `position_village` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`town_id` bigint(20) unsigned NOT NULL COMMENT '镇id',
`village_id` bigint(20) unsigned NOT NULL COMMENT '村id--唯一',
`village_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `village_id` (`village_id`),
KEY `town_id` (`town_id`),
CONSTRAINT `position_village_ibfk_1` FOREIGN KEY (`town_id`) REFERENCES `position_town` (`town_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据';
2018-07-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人