最新文章

Winfrom为dataGridView添加序号

WinFrom

//为第一列生成序号 foreach (DataGridViewRow row in rowMergeView1.Rows) { row.Cells[0].Value = row.Index + 1; }

MYSQL给select加序号

SQL SERVER

Select (@i:=@i+1) as RowNum, A.* FROM TH_WorkLog A,(Select @i:=0) B order by CreateDate desc,WorkingDay limit 0, 10

个人日志改造前方法

WinFrom

[crayon-5d5974b419f98718726150/]  

WinFrom判断数据库是否连接成功优化

WinFrom

原方法 [crayon-5d5974b41b831997559499/] 新方法 [crayon-5d5974b41b843660546705/]  

风险功能项递归导入

PRP

WITH DGCX AS ( SELECT * FROM SYS_Function WHERE FuncID = 'e11eddd9-5132-4d12-8095-256d48fbfce4' UNION ALL SELECT SYS_Function.* FROM DGCX,SYS_Function…

新增功能项后执行，调整功能项层级（重置ilevel）

PRP

[crayon-5d5974b41bcee358793438/]