Skip to content

Instantly share code, notes, and snippets.

@rqx110
rqx110 / LoadingProgress.cs
Created August 16, 2017 00:58
winform显示loading图
using System;
using System.ComponentModel;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Windows.Forms;
namespace MyControlLibrary
{
public class LoadingProgress : Control
{
@rqx110
rqx110 / untitled.cs
Last active September 13, 2017 03:12
abp增加自定义动态数据过滤
//来自群聊天,因无法贴图片,看comment内容
//具体请参考abp中的MustHaveTenantId实现
//abp代码中搜索SetFilterScopedParameterValue关键字
@rqx110
rqx110 / ISqlExecuter.cs
Created September 21, 2017 00:14
abp execute sql command/query and bulkinsert
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Abp.Domain.Entities;
namespace YnTxOA.SqlExecuterInterface
{
public interface ISqlExecuter
@rqx110
rqx110 / EfRepositoryBulkExtensions.cs
Created November 13, 2017 02:33
another abp bulk/batch operation extesion base on http://entityframework-extensions.net
public static class EfRepositoryBulkExtensions
{
public static void BulkInsert<TEntity, TPrimaryKey>(this IRepository<TEntity, TPrimaryKey> repository, IEnumerable<TEntity> entities)
where TEntity : class, IEntity<TPrimaryKey>, new()
{
var dbContext = repository.GetDbContext();
dbContext.BulkInsert(entities);
}
public static async Task BulkInsertAsync<TEntity, TPrimaryKey>(this IRepository<TEntity, TPrimaryKey> repository, IEnumerable<TEntity> entities)
@rqx110
rqx110 / showMultiTiff.cs
Created December 6, 2017 12:19 — forked from ochilab/showMultiTiff.cs
C#でマルチページ形式のTiff画像を表示する方法(Form編)
private void showMultiTiff(string tiffFileName){
FileStream tifFS = new FileStream( tiffFileName , FileMode.Open , FileAccess.Read ) ;
Image gim = Image.FromStream( tifFS ) ;
FrameDimension gfd = new FrameDimension(gim.FrameDimensionsList[0]);
int pageCount = gim.GetFrameCount( gfd ) ;//全体のページ数を得る
System.Diagnostics.Debug.WriteLine(pageCount);
Graphics g = pictureBox1.CreateGraphics();
for(int i=0;i<pageCount;i++){
gim.SelectActiveFrame(gfd, i);
g.DrawImage(gim, 0,0, pictureBox1.Width, pictureBox1.Height);//PictureBoxに表示してます
@rqx110
rqx110 / WebUtils
Created March 2, 2018 00:20
.net core web client utils
using System;
using System.Collections.Generic;
using System.IO;
using System.IO.Compression;
using System.Net;
using System.Net.Security;
using System.Security.Cryptography.X509Certificates;
using System.Text;
using System.Web;
@rqx110
rqx110 / LicenseInfo.cs
Created March 9, 2018 08:52
软件注册序列号设计
public class LicenseInfo
{
public LicenseInfo()
{
KeySn = "";
Date = DateTime.MinValue;
RegLimitDays = 0;
UseLimitDays = 0;
Offset = 0;
}
@rqx110
rqx110 / 1.txt
Created March 29, 2018 00:53
采用左右值编码来存储无限分级树形结构的数据库表设计
查看此文:https://www.cnblogs.com/yongzhi/articles/1187149.html
同时看评论的图片帮助理解。
@rqx110
rqx110 / caculate.sql
Created June 11, 2018 07:48
SQL server 中计算表占空间大小
use [table_name]
go
CREATE TABLE #tablespaceinfo
(
nameinfo VARCHAR(500) ,
rowsinfo BIGINT ,
reserved VARCHAR(20) ,
datainfo VARCHAR(20) ,
index_size VARCHAR(20) ,
unused VARCHAR(20)
@rqx110
rqx110 / WaitForm.cs
Created June 15, 2018 01:46
DevExpress show wait form
public partial class WaitForm : DevExpress.XtraWaitForm.WaitForm
{
private static WaitForm waitForm;
/// <summary>
/// 标识等待窗口是否关闭
/// </summary>
private static bool isClose = false;