动态 版块 发帖 消息 我的
xwylt
书山有路勤为径,学海无涯苦作舟
子版块
lytcreate
95
颜色码对照表颜色英文代码形象描述十六进制RGB LightPink浅粉红#FFB6C1255,182,193 Pink粉红#FFC0CB255,192,203 Crimson猩红#DC143C220,20,60 LavenderBlush脸红的淡紫色#FFF0F5255,240,245 PaleVioletRed苍白的紫罗兰红色#DB7093219,112,147 HotPink热情的粉红#FF69B4255,105,180 DeepPink深粉色#FF1493255,20,147 MediumVioletRed适中的紫罗兰红色#C71585199,21,133 Orchid兰花的紫色#DA70D6218,112,214 Thistle蓟#D8BFD8216,191,216 plum李子#DDA0DD221,160,221 Violet紫罗兰#EE82EE238,130,238 Magenta洋红#FF00FF255,0,255 Fuchsia灯笼海棠(紫红色)#FF00FF255,0,255 DarkMagenta深洋红色#8B008B139,0,139 Purple紫色#800080128,0,128 MediumOrchid适中的兰花紫#BA55D3186,85,211 DarkVoilet深紫罗兰色#9400D3148,0,211 DarkOrchid深兰花紫#9932CC153,50,204 Indigo靛青#4B008275,0,130 BlueViolet深紫罗兰的蓝色#8A2BE2138,43,226 MediumPurple适中的紫色#9370DB147,112,219 MediumSlateBlue适中的板岩暗蓝灰色#7B68EE123,104,238 SlateBlue板岩暗蓝灰色#6A5ACD106,90,205 DarkSlateBlue深岩暗蓝灰色#483D8B72,61,139 Lavender熏衣草花的淡紫色#E6E6FA230,230,250 GhostWhite幽灵的白色#F8F8FF248,248,255 Blue纯蓝#0000FF0,0,255 MediumBlue适中的蓝色#0000CD0,0,205 MidnightBlue午夜的蓝色#19197025,25,112 DarkBlue深蓝色#00008B0,0,139 Navy海军蓝#0000800,0,128 RoyalBlue皇家蓝#4169E165,105,225 CornflowerBlue矢车菊的蓝色#6495ED100,149,237 LightSteelBlue淡钢蓝#B0C4DE176,196,222 LightSlateGray浅石板灰#778899119,136,153 SlateGray石板灰#708090112,128,144 DoderBlue道奇蓝#1E90FF30,144,255 AliceBlue爱丽丝蓝#F0F8FF240,248,255 SteelBlue钢蓝#4682B470,130,180 LightSkyBlue淡蓝色#87CEFA135,206,250 SkyBlue天蓝色#87CEEB135,206,235 DeepSkyBlue深天蓝#00BFFF0,191,255 LightBLue淡蓝#ADD8E6173,216,230 PowDerBlue火药蓝#B0E0E6176,224,230 CadetBlue军校蓝#5F9EA095,158,160 Azure蔚蓝色#F0FFFF240,255,255 LightCyan淡青色#E1FFFF225,255,255 PaleTurquoise苍白的绿宝石#AFEEEE175,238,238 Cyan青色#00FFFF0,255,255 Aqua水绿色#D4F2E7212,242,231 DarkTurquoise深绿宝石#00CED10,206,209 DarkSlateGray深石板灰#2F4F4F47,79,79 DarkCyan深青色#008B8B0,139,139 Teal水鸭色#0080800,128,128 MediumTurquoise适中的绿宝石#48D1CC72,209,204 LightSeaGreen浅海洋绿#20B2AA32,178,170 Turquoise绿宝石#40E0D064,224,208 Auqamarin绿玉\碧绿色#7FFFAA127,255,170 MediumAquamarine适中的碧绿色#00FA9A0,250,154 MediumSpringGreen适中的春天的绿色#00FF7F0,255,127 MintCream薄荷奶油#F5FFFA245,255,250 SpringGreen春天的绿色#3CB37160,179,113 SeaGreen海洋绿#2E8B5746,139,87 Honeydew蜂蜜#F0FFF0240,255,240 LightGreen淡绿色#90EE90144,238,144 PaleGreen苍白的绿色#98FB98152,251,152 DarkSeaGreen深海洋绿#8FBC8F143,188,143 LimeGreen酸橙绿#32CD3250,205,50 Lime酸橙色#00FF000,255,0 ForestGreen森林绿#228B2234,139,34 Green纯绿#0080000,128,0 DarkGreen深绿色#0064000,100,0 Chartreuse查特酒绿#7FFF00127,255,0 LawnGreen草坪绿#7CFC00124,252,0 GreenYellow绿黄色#ADFF2F173,255,47 OliveDrab橄榄土褐色#556B2F85,107,47 Beige米色(浅褐色)#F5F5DC245,245,220 LightGoldenrodYellow浅秋麒麟黄#FAFAD2250,250,210 Ivory象牙#FFFFF0255,255,240 LightYellow浅黄色#FFFFE0255,255,224 Yellow纯黄#FFFF00255,255,0 Olive橄榄#808000128,128,0 DarkKhaki深卡其布#BDB76B189,183,107 LemonChiffon柠檬薄纱#FFFACD255,250,205 PaleGodenrod灰秋麒麟#EEE8AA238,232,170 Khaki卡其布#F0E68C240,230,140 Gold金#FFD700255,215,0 Cornislk玉米色#FFF8DC255,248,220 GoldEnrod秋麒麟#DAA520218,165,32 FloralWhite花的白色#FFFAF0255,250,240 OldLace老饰带#FDF5E6253,245,230 Wheat小麦色#F5DEB3245,222,179 Moccasin鹿皮鞋#FFE4B5255,228,181 Orange橙色#FFA500255,165,0 PapayaWhip番木瓜#FFEFD5255,239,213 BlanchedAlmond漂白的杏仁#FFEBCD255,235,205 NavajoWhite纳瓦霍白#FFDEAD255,222,173 AntiqueWhite古代的白色#FAEBD7250,235,215 Tan晒黑#D2B48C210,180,140 BrulyWood结实的树#DEB887222,184,135 Bisque(浓汤)乳脂,番茄等#FFE4C4255,228,196 DarkOrange深橙色#FF8C00255,140,0 Linen亚麻布#FAF0E6250,240,230 Peru秘鲁#CD853F205,133,63 PeachPuff桃色#FFDAB9255,218,185 SandyBrown沙棕色#F4A460244,164,96 Chocolate巧克力#D2691E210,105,30 SaddleBrown马鞍棕色#8B4513139,69,19 SeaShell海贝壳#FFF5EE255,245,238 Sienna黄土赭色#A0522D160,82,45 LightSalmon浅鲜肉(鲑鱼)色#FFA07A255,160,122 Coral珊瑚#FF7F50255,127,80 OrangeRed橙红色#FF4500255,69,0 DarkSalmon深鲜肉(鲑鱼)色#E9967A233,150,122 Tomato番茄#FF6347255,99,71 MistyRose薄雾玫瑰#FFE4E1255,228,225 Salmon鲜肉(鲑鱼)色#FA8072250,128,114 Snow雪#FFFAFA255,250,250 LightCoral淡珊瑚色#F08080240,128,128 RosyBrown玫瑰棕色#BC8F8F188,143,143 IndianRed印度红#CD5C5C205,92,92 Red纯红#FF0000255,0,0 Brown棕色#A52A2A165,42,42 FireBrick耐火砖#B22222178,34,34 DarkRed深红色#8B0000139,0,0 Maroon栗色#800000128,0,0 White纯白#FFFFFF255,255,255 WhiteSmoke白烟#F5F5F5245,245,245 Gainsboro亮灰色#DCDCDC220,220,220 LightGrey浅灰色#D3D3D3211,211,211 Silver银白色#C0C0C0192,192,192 DarkGray深灰色#A9A9A9169,169,169 Gray灰色#808080128,128,128 DimGray暗淡的灰色#696969105,105,105 Black纯黑#0000000,0,0
 0   2  14天前
lytcreate
13
设计----页面边框----无---应用于整片文档。
 0   0  23小时前
lytcreate
9
#设置主键和自增 alter table user add primary key (id); 设置主键 alter table 表名 change id id int AUTO_INCREMENT; 设置自增
 0   0  1天前
lytcreate
23
点击下载:coreldrawX4安装版
 0   0  4天前
lytcreate
29
地址:前端拖动生成代码
 0   0  4天前
lytcreate
34
1、mysql导出,cmd下输入:mysqldump -u用户名 -p 数据库名 > F:\数据库名.sql之后可去F盘下找到名为数据库名.sql的文件,这个就是该数据库的全部文件了。2、mysql导入新的数据库方法:1、mysql 命令导入使用 mysql 命令导入语法格式为:mysql -u用户名 -p密码 < 要导入的数据库数据(runoob.sql)实例:# mysql -uroot -p123456 < runoob.sql以上命令将将备份的整个数据库 runoob.sql 导入。2、source 命令导入source 命令导入数据库需要先登录到数库终端:mysql> create database abc; # 创建数据库 mysql> use abc; # 使用已创建的数据库 mysql> set names utf8; # 设置编码 mysql> source /home/abc/abc.sql # 导入备份数据库
 0   0  7天前
lytcreate
27
方式一:去系统环境变量里面查看方法二:cmd中输入python,然后:>>> import sys >>> sys.path ['', 'C:\\Python27\\Lib\\idlelib', 'C:\\Python27\\lib\\site-packages\\robotframework_selenium2library-1.5.0-py2.7.egg', 'C:\\Python27\\lib\\site-packages\\docutils-0.14-py2.7.egg', 'C:\\Python27\\lib\\site-packages\\decorator-4.2.1-py2.7.egg', 'C:\\Windows\\system32\\python27.zip', 'C:\\Python27\\DLLs', 'C:\\Python27\\lib', 'C:\\Python27\\lib\\plat-win', 'C:\\Python27\\lib\\lib-tk', 'C:\\Python27', 'C:\\Python27\\lib\\site-packages', 'C:\\Python27\\lib\\site-packages\\win32', 'C:\\Python27\\lib\\site-packages\\win32\\lib', 'C:\\Python27\\lib\\site-packages\\Pythonwin', 'C:\\Python27\\lib\\site-packages\\wx-2.8-msw-unicode']
 0   0  7天前
lytcreate
45
用管理员打开cmd输入 netstat 可查看端口号和对应的pid之后去任务管理器中关闭占用端口的服务
 0   0  7天前
lytcreate
48
解决echarts饼图显示百分比,和显示内容字体及大小// 基于准备好的dom,初始化echarts实例        var pieEchart = echarts.init(document.getElementById('pieEchart'));         // 指定图表的配置项和数据         var pieoption = {              title : {                  text: '公里总里程',                   x:'left',                textStyle:{                    color:'#FFFFFF',                    fontSize:25                }            },              tooltip : {                  trigger: 'item',                  formatter: "{a} <br/>{b} : {c} KM"              },              legend: {                  orient : 'vertical',                  x : 'left',                  top:40,                itemWidth:70,                itemHeight:30,                formatter: '{name}',                textStyle:{                    color: '#FFFFFF'                },                data:[{name:'高速50KM',icon:'rect'},{name:'一级150KM',icon:'rect'},{name:'二级150KM',icon:'rect'},{name:'三级100KM',icon:'rect'},{name:'四级50KM',icon:'rect'}]  }            ,               calculable : true,              series : [                  {                      name:'公里总里程',                      type:'pie',                      radius : '70%',//饼图的半径大小                      center: ['60%', '60%'],//饼图的位置                     label:{            //饼图图形上的文本标签                            normal:{                                show:true,                                position:'inner', //标签的位置                                textStyle : {                                    fontWeight : 300 ,                                    fontSize : 16    //文字的字体大小                                },                                formatter:'{d}%'                                                            }                        },                    data:[                          {value:50,name:'高速50KM',itemStyle:{normal:{color:'#FE0000'}}},                          {value:150,name:'一级150KM',itemStyle:{normal:{color:'#F29700'}}},                          {value:150,name:'二级150KM',itemStyle:{normal:{color:'#02B0ED'}}},                         {value:100,name:'三级100KM',itemStyle:{normal:{color:'#55E87D'}}},                        {value:50,name:'四级50KM',itemStyle:{normal:{color:'#FFE200'}}},                    ]                }              ]          };            // 使用刚指定的配置项和数据显示图表。            pieEchart.setOption(pieoption);
 0   0  7天前
lytcreate
52
报错:Exception at /sotdc/Attempt to overwrite cell: sheetname='SOT问题统计表' rowx=1 colx=9解决:检查表格数字,有重复单元格
 0   0  8天前
lytcreate
48
ws = Workbook(encoding='utf-8') # 设置Excel为UTF-8的编码格式w = ws.add_sheet("危险源辨识、风险评价与控制措施表") # 设置sheet名称style = xlwt.XFStyle()al = xlwt.Alignment()al.horz = 0x02 # 设置水平居中al.vert = 0x01 # 设置垂直居中style.alignment = al# 合并第1行的第0列到第17列,然后居中w.write_merge(0, 0, 0, 16, 'SGMW重庆分公司('+department+')危险源辨识、风险评价与控制措施表', style)下面是一个导出的实例:@login_required()def wxydc(request): if request.method == 'POST': department = request.POST.get('department') timestart = request.POST.get('timestart') timeend = request.POST.get('timeend') conn = pymysql.connect(host=host, port=port, user=user, password=password, database=database, charset='utf8') cursor = conn.cursor(cursor=pymysql.cursors.DictCursor) cursor.execute("select workplace,workcontent,dsdescription,dstype,maybetrouble,probability,exposuretime,resoluts,dzhi,risklevel,unaccept,adopted,controldocumet,ifimportantds,ifaccept,changes,dsdepartment from aqk_dangersource where intime between %s and %s and dsdepartment=%s ",[timestart,timeend,department,]) wxydc_list = cursor.fetchall() cursor.close() conn.close() ws = Workbook(encoding='utf-8') # 设置Excel为UTF-8的编码格式 w = ws.add_sheet("危险源辨识、风险评价与控制措施表") # 设置sheet名称 style = xlwt.XFStyle() al = xlwt.Alignment() al.horz = 0x02 # 设置水平居中 al.vert = 0x01 # 设置垂直居中 style.alignment = al # 合并第1行到第2行的第0列到第3列 w.write_merge(0, 0, 0, 16, 'SGMW重庆分公司('+department+')危险源辨识、风险评价与控制措施表', style) w.write_merge(1,1,0,4,'区域:'+department,style) w.write_merge(1, 1, 5, 12, '评估人员:各区域工段长、班组长、员工、安全工程师', style) w.write_merge(1, 1, 13, 16, '日期:', style) w.write_merge(2, 3, 0, 0, '序号', style) w.write_merge(2, 3, 1, 1, '作业活动场所', style) w.write_merge(2, 3, 2, 2, '作业活动内容', style) w.write_merge(2, 3, 3, 3, '危险源描述', style) w.write_merge(2, 3, 4, 4, '危险源类型', style) w.write_merge(2, 3, 5, 5, '可能导致的事故', style) w.write_merge(2, 2, 6, 9, '风险评价(LEC法)', style) w.write(3, 6, '可能性L', style) w.write(3, 7, '暴露时间E', style) w.write(3, 8, '事故后果C', style) w.write(3, 9, 'D值', style) w.write_merge(2, 3, 10, 10, '风险等级', style) w.write_merge(2, 3, 11,11, '不可接受风险直接判定', style) w.write_merge(2, 3, 12, 12, '已采取的控制措施', style) w.write_merge(2, 3, 13, 13, '相应的控制文件', style) w.write_merge(2, 3, 14, 14, '是否重要危险源', style) w.write_merge(2, 3, 15, 15, '是否可接受风险', style) w.write_merge(2, 3, 16, 16, '变更情况', style) # 把需要导出的数据写到文件中 excel_row = 4 dcb_row = 1 for dcb in wxydc_list: w.write(excel_row, 0, dcb_row) w.write(excel_row, 1, dcb['workplace']) w.write(excel_row, 2, dcb['workcontent']) w.write(excel_row, 3, dcb['dsdescription']) w.write(excel_row, 4, dcb['dstype']) w.write(excel_row, 5, dcb['maybetrouble']) w.write(excel_row, 6, dcb['probability']) w.write(excel_row, 7, dcb['exposuretime']) w.write(excel_row, 8, dcb['resoluts']) w.write(excel_row, 9, dcb['dzhi']) w.write(excel_row, 10, dcb['risklevel']) w.write(excel_row, 11, dcb['unaccept']) w.write(excel_row, 12, dcb['adopted']) w.write(excel_row, 13, dcb['controldocumet']) w.write(excel_row, 14, dcb['ifimportantds']) w.write(excel_row, 15, dcb['ifaccept']) w.write(excel_row, 16, dcb['changes']) excel_row += 1 dcb_row += 1 sio = BytesIO() # 写出到IO ws.save(sio) sio.seek(0) # 重新定位到开始 response = HttpResponse(sio.getvalue(), content_type='application/vnd.ms-excel') # 设置文件格式为Excel response['Content-Disposition'] = 'attachment; filename="危险源导出表.xls"' response.write(sio.getvalue()) return response else: return render(request,'wxydc.html')
 0   0  9天前
我的小伙伴
Powered by Xwylt.com
© 2020-2020 lytcreate
您的IP:3.234.143.26,2020-10-01 15:35:16,Processed in 0.02326 second(s).
Powered by HadSky
书山有路勤为径,学海无涯苦作舟