rqx110’s gists

rqx110 / EnumExtensions.cs

Created September 6, 2018 01:40

获取Enum描述属性值

	using System;
	using System.Collections.Generic;
	using System.ComponentModel;
	using System.Reflection;
	using Abp.Application.Services.Dto;

	namespace Abp.Extensions
	{
	public static class EnumExtensions
	{

rqx110 / ObjectExtensions.cs

Created September 6, 2018 01:37

对象deep copy, 注意对象必须添加[Serializable]

	using System;
	using System.IO;
	using System.Runtime.Serialization;
	using System.Runtime.Serialization.Formatters.Binary;

	namespace Abp.Extensions
	{
	public static class ObjectExtensions
	{
	public static T Dereference<T>(this object obj)

rqx110 / AppDbContext.cs

Created August 15, 2018 01:33

EF core 2.0 批量注册entityTypeConfiguration

	string typeName = typeof(IEntityTypeConfiguration<>).Name;
	var assembly = Assembly.GetExecutingAssembly();

	assembly.GetTypes()
	.Where(w => w.GetTypeInfo().ImplementedInterfaces.Any(a => a.Name == typeName))
	.ToList()
	.ForEach(item =>
	{
	dynamic instance = item.FullName;
	builder.ApplyConfiguration(assembly.CreateInstance(instance));

rqx110 / NewMongodbObjectId.cs

Last active August 2, 2018 06:52

生成类似Mongodb的ObjectId有序、不重复Guid

	private static DateTime dt1970 = new DateTime(1970, 1, 1);
	private static Random rnd = new Random();
	private static readonly int __staticMachine = ((0x00ffffff & Environment.MachineName.GetHashCode()) +
	#if NETSTANDARD1_5 \|\| NETSTANDARD1_6
	1
	#else
	AppDomain.CurrentDomain.Id
	#endif
	) & 0x00ffffff;
	private static readonly int __staticPid = Process.GetCurrentProcess().Id;

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;

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 / 1.txt

Created March 29, 2018 00:53

采用左右值编码来存储无限分级树形结构的数据库表设计

	查看此文：https://www.cnblogs.com/yongzhi/articles/1187149.html
	同时看评论的图片帮助理解。

rqx110 / LicenseInfo.cs

Created March 9, 2018 08:52

软件注册序列号设计

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 / 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に表示してます

Qingxiao Ren rqx110