- 博客(72)
- 资源 (5)
- 收藏
- 关注
原创 [Angular] Import TranslateModule in Angular 16
Angular 更新至V16版后,支援 standalone,故移除了 NgModule,而TranslateModule 又要在AppModule中 import,那该如何做呢?
2023-07-24 22:10:42 1416
原创 [Angular] 主从表结构,从表记录在主表固定栏位上呈现
主从表结构,有时为了方便数据呈现,在UI上不显示从表资料,那么需要动态把从表的资料加载到主表的固定栏位上。例如:主表是人员信息,从表是银行卡信息,一个人在同一家银行可能有多张银行卡,且一个人可能在多家银行开户。
2023-07-24 20:57:53 216
原创 [Angular] Export excel from table or json
【代码】[Angular] Export excel from table or json。
2023-07-24 19:30:24 1349
原创 [Angular] Custom a DatePipe to support special time zone conversion from user
【代码】[Angular] Custom a DatePipe to support special time zone conversion from user。
2023-07-24 13:06:18 874
原创 How to start a gitlab-runner in wsl?
Becasue I've installed the Ubuntu 18.04 LTS in my wsl, I click the icon to start.1.Start wls2 and docker 2.Download the gitlab-runner docker image3.Show docker images 4.Start the docker container (Docker run)5.Go to the gitlab-runner container
2022-06-14 09:29:32 290 1
原创 How to start the dotnetsdk docker image for test?
Following the last articleHow to run a Docker on Windows 10 with WSL?https://blog.csdn.net/wish366/article/details/125011890 1. Start wsl2 and docker 2.Download the dotnetsdk docker image 2.1 If it's showing the error: x509: certificate signed by
2022-06-08 21:01:44 188
原创 How to upload a UT coverage report of angular to SonarQube?
1. Preconditions: you've deployed a SonarQube service.2. In order to test the processes, I'll install the sonar-scanner in your local computer, it's located on the left of the image above. Becasue I use a Windows system, I get the package from the webs
2022-05-31 19:46:46 121
原创 nz-modal of ng-zorro supports browser height
If you know the setting, maybe it will very easy.Please see the code, we only set some css to support it.<nz-modal [nzStyle]="{height:'100vh', top:0}"> … </nz-modal>vh,是指CSS中相对长度单位,表示相对视口高度(Viewport Height),1vh = 1% * 视口高度。...
2022-05-31 18:55:08 384
原创 How to run a Docker on Windows 10 with WSL?
1.Install Linux on Windows with WSLPlease refer to the URL:Install WSL | Microsoft DocsWSL: windows subsystem for linuxYou must be running Windows 10 version 2004 and higher (Build 19041 and higher) or Windows 11.If not, please upgrade your Windo..
2022-05-27 23:54:52 195
原创 How to use a rancher CLI to run kubectl command?
How to use a rancher CLI to run kubectl command?
2022-05-20 14:25:22 194
原创 DB migration automatically with DB first (using PostgreSQL) in .NET 5
Please see the content first:DB first (using PostgreSQL) in .NET 5We knowed that our program's release path is from DEV to QAS to PRD.1. Create new objects in your DB of DEV, and export all sql scripts into a file.for exapmle: I have exported a file.
2022-05-12 13:39:59 141
原创 A CSP(Content Security Policy) issue on Web UI
A Content Security Policy issue
2022-03-26 16:00:02 1172
原创 DataTable 列转行
接上篇JSON to DataTable_Free Labor 的专栏-CSDN博客1. Json fileappsettings.json "UploadData": [ { "item_a": "", "item_b": "", "item_c": "", "d1": "Jan-22", "d2": "Jan-22", "d3": "Jan-22", "d4": "Jan-22", "d5": "Jan-22", "d6": "Feb-22", https://blog.csdn.net/wish3
2022-03-01 12:10:21 798
原创 JSON to DataTable
1. Json fileappsettings.json "UploadData": [ { "item_a": "", "item_b": "", "item_c": "", "d1": "Jan-22", "d2": "Jan-22", "d3": "Jan-22", "d4": "Jan-22", "d5": "Jan-22", "d6": "Feb-22",
2022-03-01 11:52:43 495
原创 [NgZorroAntdMobileModule] 使用ImagePicker组件上传图片并压缩
直接上代码:app.module.tsimport { NgxImageCompressService } from 'ngx-image-compress';import { NgModule } from '@angular/core';import { BrowserModule } from '@angular/platform-browser';import { BrowserAnimationsModule } from '@angular/platform-browser
2022-01-06 19:11:07 781
原创 DB first (using PostgreSQL) in .NET 5
1.Create a projectunder your solution, there is DbFirst.API2. Install EntityFrameworkCore, Microsoft.EntityFrameworkCore.Design,Microsoft.EntityFrameworkCore.Tools, Npgsql.EntityFrameworkCore.PostgreSQL by NuGet4. Installdotnet-efdotnet tool in...
2021-09-17 14:05:05 172
原创 Using NiFi to sync data between table to table
1.Add aExecuteSQL processor1.1 Add Controller Service (DBCPConnectionPool)1.2Input SQL select query2. Add aConvertAvroToJSONProcessor3. Add aConvertJSONToSQLProcessor4. Add aPutSQLProcessorAttach Ni...
2021-09-16 16:13:48 162
原创 NiFi 从PostgreSQL同步资料报: table does not exist.
1.问题:如下图,左边能成功,右边不成功。两者的差异:左边SQL有schema name。2.原因:经过分析,发现PgAdmin工具在做ROLE与SCHEMA绑定,它在存储时自动转成小写,造成当前用户登录后,找不到默认的SCHEMA NAME。查看当前默认SCHEMA NAME:show search_path;3.解决方案3.1 指定用户对应的SCHEMAALTER ROLE "USER_NAME" IN DATABASE "DATABASE" SET search_path.
2021-09-16 14:24:42 571
原创 Code first (using PostgreSQL) in .NET 5
1. Open your VS and create two projects, there are CodeFirst.API and CodeFirstModel.1.1 CodeFirst.API project1.2 CodeFirst.Model2. Add a user class in CodeFirst.Model project.using System;using System.Collections.Generic;using Sys...
2021-09-16 08:30:45 133
原创 PostgreSQL Trigger
1. Create two tables, there are a1 and a2.table: a1table a2:2. Create a function:record_a1CREATE OR REPLACE FUNCTION record_a1() returns trigger as $$declarenCnt int;begin select count(0) into nCnt from a2 where column1=new.column1; if ...
2021-08-20 16:37:46 606
原创 How to get a access token from IdentityServer4?
1.Get token with client_credentials grant typePost url: https://xxx.com/auth/connect/tokenPost data: client_id: xx client_secret: secret grant_type: client_credentials scope: api1Content-Type: application/x-www-form-urlencoded2.
2021-06-24 13:01:24 888
原创 How to grant table in PostgreSQL?
常常漏掉这一句:grant usage on schema...-- Permissionsgrant usage on schema "A" to "B";grant usage on schema "A" to "C";ALTER TABLE "A".tablename OWNER TO "A" ;GRANT ALL ON TABLE "A".tablename TO "A" ;GRANT SELECT ON TABLE "A".tablename TO "B" ;GRANT ..
2021-05-18 16:15:15 153
原创 多线程实现方法 (threadpool and async method) in .Net Core.
.NET CORE 中实现多线程的两种方法(个人经验总结),两种方法使用的场景不同1.使用ThreadPoolusing System;using System.Collections.Generic;using System.Text;using System.Threading;using System.Threading.Tasks;namespace ConsoleApp1{ public class MyThreadPool { public
2021-05-13 16:16:23 279
原创 WeChat小程序如何获得用户的unionId?
前提条件,必要申请了微信开发平台帐号,并绑定此小程序,如下图:安装cryptojs.jsnpm install cryptojs新增一个js文件(DataCrypt.js),并引用cryptojs.js文件,使用 getUnionId 方法将返回unionid。DataCrypt.jsvar Crypto = require('cryptojs/cryptojs.js').Crypto;var APPID = 'wx....';var APPsecret = '....';
2021-04-23 09:50:10 814
原创 WeChat小程序如何获取用户的个人信息(头像、昵称、性别与地区)?
由于WeChat小程序发布了新的规范,获取用户的个人信息将使用新的方法。“2021年4月13日后发布的新版本小程序,开发者通过组件调用wx.getUserInfo将不再弹出弹窗,直接返回匿名的用户个人信息,获取加密后的openID、unionID数据的能力不做调整;若开发者需要获取用户的个人信息(头像、昵称、性别与地区),可以通过wx.getUserProfile接口进行获取。具体参考公告:https://developers.weixin.qq.com/community/develop/doc/00
2021-04-23 08:19:58 3735
转载 Loading on page
本文包含两部分内容:即loading.css和loading.html,以下是范例。loading.css body { margin: 0; padding: 0; background-color: rgba(0, 0, 0, 0.7); } .load-container { display: inline-block; position: absolute; top: 50
2021-04-23 08:06:28 104
原创 Table固定表头
Table固定表头使用CSS position:sticky<!DOCTYPE html><html><head><style>table { border-collapse: collapse; width: 100%;}th, td { text-align: left; padding: 28px;}tr:nth-child(even) {background-color: #f2f2f2;}tr:hov.
2021-03-25 13:54:45 352
原创 IDM trust Keycloak
IDM trust Keycloak提示:这里可以添加系列文章的所有文章的目录,目录需要自己手动添加例如:第一章 Python 机器学习入门之pandas的使用提示:写完文章后,目录可以自动生成,如何生成可参考右边的帮助文档文章目录系列文章目录 前言 一、pandas是什么? 二、使用步骤 1.引入库 2.读入数据 总结前言由于项目原因,需要启用Keycloak做SSO,但是项目中又使用IDM管制访问权限,我使用的方法如下。一、实...
2021-03-23 13:07:50 452
原创 How to call a WebAPI in Excel?
前置條件:電腦需安裝Excel1. 選擇資料來源:從Web2. 輸入WebAPI URL地址,并點確認按鈕data2.json[["2018-03-27","",""],["1980-12-12",28.75,"abc"],["2018-03-27","b",""]]3. 在Power Query編輯器上點擊’到表格’4. 分隔符號選擇“無”,然後點‘確定’5. 在標題欄的圖示點擊鼠標左鍵,然後選擇’擷取值’6.分隔符號選擇‘Tab鍵’,然後點‘確定’.
2021-03-10 10:02:53 155
原创 解決ASP.NET CrystalReports 用戶限制的處理方法
由於ASP.NET CrystalReports不支援多用戶同時在線,此時可以用以下的方法來處理:把WEB前端列印傳遞到WINDOWS後端來處理,這樣只有一個USER在使用CrystalReports. 一.WindowsService1.使用VS2008新建項目:WindowsService2.在Service1.cs上添加時間控件,一定是System.Timers.Time
2010-04-17 09:30:00 592
原创 數據庫訪問類(Query,Insert,Update,Delete)
數據庫訪問類:SQLHelp(原創,轉載請注明出處) 1.接口類:IDAL.csusing System;using System.Collections.Generic;using System.Text;using System.Data;namespace DB.SQLHelp.DAL{ public interface IDAL { bool i
2009-11-06 10:21:00 667
转载 打工还是创业,思路决定出路
打工还是创业,思路决定出路http://blog.sina.com.cn/s/blog_5ec7577b0100dgm0.html~type=v5_one&label=rela_prevarticle
2009-05-06 16:47:00 580
原创 ASP.NET GridView中鏈結打開模式窗口,當模式窗口關閉時,刷新父頁.
ASP.NET打開模式窗口,當模式窗口關閉時,刷新父頁.1.使用Javascript: showModelessDialog打開模式窗口JS代碼:function showDialog(url, width, height){ showModelessDialog(url, window, dialogWidth: + width + px;dialogHeight: +
2009-03-27 16:44:00 1719
原创 ASP.NET GridView 使用Oracle Procedure 分頁
ASP.NET GridView 使用Oracle Procedure 分頁1.創建Procedure(P_QUERYSPLIT) CREATE OR REPLACE PROCEDURE ZSHR.P_QUERYSPLIT( SQLSCRIPT IN VARCHAR2,PAGESIZE IN NUMBER,PAGEINDEX IN NUMBER, TOTALCOUNT OUT NUMBER
2009-03-27 16:19:00 1115
原创 VS2005 Publish添加文件
VS2005 Publish添加文件(Mage命令)1. 打開項目屬性面版,設置好Publish屬性. 2. 把網頁Publish到IIS.此時項目bin/Debug目錄會增加AutoUpdate.publish文件夾. 3. 啟動Visual Studio 2005 Command Prompt,輸入MAGEUI命令啟動.4. Open打開AutoUpdate.publish/AutoUpdat
2009-01-14 16:12:00 1090
原创 ASP.NET頁面傳值,並返回子頁值至父頁
ASP.NET頁面傳值,並返回子頁值至父頁1.父頁:"text/javascript"> //1、open子窗口:用window.opener代表父窗口的window对象 (window.opener) //2、模态子窗口:间接通过传window对象到子窗口,然后子窗口可获得父窗口的window对象 (window.dialogArgumen
2008-11-03 16:10:00 3157
转载 如何在網頁中添加多媒體插放器?
如何在網頁中添加多媒體插放器?1.添加多媒體播放類:PlayClass.csusing System;namespace ConfigTools{ /// /// PlayClass 的摘要说明。 /// ConfigTools.PlayClass pc=new ConfigTools.PlayClass();
2008-10-28 17:12:00 988
ThreadSample.7z
2021-05-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人