摘要:
//是否合并单元格 bool isMerge = sheet.Range["A1"].MergeCells; //合并单元格的区域 sheet.Range["A1"].MergeArea //合并开始的行列信息 sheet.Range["A1"].MergeArea.Row sheet.Range[ 阅读全文
摘要:
声明中添加属性 TextOptions.TextFormattingMode="Display" TextOptions.TextRenderingMode="ClearType" TextOptions.TextHintingMode="Fixed" UseLayoutRounding="True 阅读全文
摘要:
可以获取一下权限列表,如果成功就表示文件存在 var fi = new FileInfo(FilePath); var fe = fi.GetAccessControl(); 阅读全文
摘要:
转载:https://blog.csdn.net/yihanzhi/article/details/89965589 方式1:监听事件visibilitychange具体实现方式如下: var hiddenProperty = 'hidden' in document ? 'hidden' : 'w 阅读全文
摘要:
C:\Users\{用户名}\AppData\Local\Apps\2.0\xxx 阅读全文
摘要:
select top PageSize * from( select row_number() over(order by id) as rows,* ) as t where rows > (PageSize*(PageIndex-1)) select * from( select row_number() over(order by id) as rows,* ) as ... 阅读全文
摘要:
var db = new DBEntities(); var query = from m in db.tables select new{ m.id,m.name }.ToList().Select(m=>new tables{m.id,m.name}).ToList(); 将赋值操作分为两步 参 阅读全文
摘要:
//参数直接写参数名 string Sql = "select * from [table] where field like @field"; //参数值里面加上通配符,varchar类型查询也不加单引号 var Param = new {field = "%{ParamValue}%"}; // 阅读全文
摘要:
1.添加系统DLL引用 [DllImport("user32.dll")] public static extern void SwitchToThisWindow(IntPtr hWnd, bool fAltTab); 2.得到窗口句柄 应用程序运行时 Process instance = nul 阅读全文
摘要:
DynamicParameters Params = new DynamicParameters();Params.Add("Key",Value); 阅读全文