NetMQ 发布/订阅 源码(C# socket连接)

示例使用方法在word文档内查看。要是看明白了，会发现这类东西编写其实很简单。示例及文档说明了WebSocket的基本使用方法，介绍了传输文字、图像、文件传输的基本方法。示例仿照微信的显示样式传递图文。可以适用于Socket、WebService等连接方式，只要包括发送用户数据功能、判断用户离线功能就可以。只是将Socket_Packet类进行传递。关于WebSocket使用的其他说明可参见：https://github.com/sta/websocket-sharp。示例界面只是简单贴了几张图，没做设计，所以界面部分无需参考。文章对照源代码进行理解，学习时间不长，难免有错，自行纠正，交流：QQ: 3532927017

[实例简介] 连接sql数据库 类 [核心代码]using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data.SqlClient;using System.Data; namespace Itcast.Cn{ public static class SqlHelper { private static readonly string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; //执行增删改的 public static int ExecuteNonQuery(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteNonQuery(); } } } //封装一个执行返回单个值的方法 public static object ExecuteScalar(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteScalar(); } } } //返回SqlDataReader对象的方法 public static SqlDataReader ExecuteReader(string sql, CommandType cmdType, params SqlParameter[] pms) { SqlConnection con = new SqlConnection(conStr); using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } try { con.Open(); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception) { con.Close(); con.Dispose(); throw; } } } //封装一个返回DataTable的方法 public static DataTable ExecuteDataTable(string sql, CommandType cmdType, params SqlParameter[] pms) { DataTable dt = new DataTable(); using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conStr)) { adapter.SelectCommand.CommandType = cmdType; if (pms != null) { adapter.SelectCommand.Parameters.AddRange(pms); } adapter.Fill(dt); } return dt; } //封装一个带事务的执行Sql语句的方法 public static void ExecuteNonQueryTran(List list) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = con.CreateCommand()) { con.Open(); using (SqlTransaction trans = con.BeginTransaction()) { cmd.Transaction = trans; try { foreach (var SqlObject in list) { cmd.CommandText = SqlObject.Sql; if (SqlObject.Parameters != null) { cmd.Parameters.AddRange(SqlObject.Parameters); } cmd.CommandType = SqlObject.CmdType; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } trans.Commit(); } catch (Exception) { trans.Rollback(); } } } } } } public class SqlAndParameter { public string Sql { get; set; } public SqlParameter[] Parameters { get; set; } public CommandType CmdType { get; set; } }}

.Net版本的 Ucenter整合方案

可直接拿来测试哦

在征询建议的基础上进行了补全修改，正式写为DLL，可以完成基本的报表定制、打印功能。在程序设计中，很多时候报表不需要那么庞杂的功能，一些小程序的数据库报表只需要简单处理，就没必要安装FastReport、Crystal Reports、DevExpress等庞大组件了。由于为前面征询意见的补全，所以不需分数。此程序代码可优化、功能可添加，自行完善修改。1、调用方式：将EzReport_Build.dll添加到引用中，将fontawesome-webfont.ttf字库文件放置在一起private void button1_Click(object sender, EventArgs e){    Form_Desing.Initialize_Design();}即可，也可将Preview.cs、Form_Desing.cs中的private PanelEx修改为public PanelEx，在你的Form中直接嵌入调用，比如打印、预览比例等函数有些已设置为public，也可将需要的函数和组件设为public直接调用。数据库定义在：Define_DataLink.cs绘制定义在：Draw_Function.cs报表组件、界面颜色等定义在：Define_Global.cs界面等其他附属在ui文件夹2、 打印模式设置dpi为96，SetResolution(96, 96);相对应dpi打印纸张类型：public static string[] page_types = new string[24] {            "A0","A1","A2","A3","A4","A5","A6","A7",            "B0","B1","B2","B3","B4","B5","B6","B7",            "C0","C1","C2","C3","C4","C5","C6","C7"        };以及自定义纸张（单位设置为毫米）换算公式为：(int)Math.Floor(int.Parse(input_def[0].textBox.Text) * 3.779527559055118)相对应纸张大小（毫米）public static string[] page_size = new string[24] {"841×1189","594×841","420×594","297×420","210×297","148×210","105×148","74×105","1000×1414","707×1000","500×707","353×500","250×353","176×250","125×176","88×125","917×1297","648×917","458×648","324×458","229×324","162×229","114×162","81×114"        };对应像素为：public static string[] page_pixel = new string[24] {"3178×4493","2245×3178","1587×2245","1122×1587","793×1122","559×793","396×559","279×396","3779×5344","2672×3779","1889×2672","1334×1889","944×1334","665×944","472×665","332×472","3465×4902","2449×3465","1731×2449","1235×1731","865×1224","612×865","430×612","306×430"        }; 按照ISO标准纸型、尺寸设置。打印支持选项：  3、快捷键Ctrl 上、下、左、右可移动组件Shift 上、下、左、右调整组件大小Alt V 粘贴、Alt C复制、等，在报表组件上点击右键，菜单中可看见或在报表栏目空白处点击右键。4、 其余可参见代码中public函数，其他说明可参见草稿：https://www.haolizi.net/example/view_16592.html征求意见稿：https://www.haolizi.net/example/view_16896.html如有疏漏自行修正。  实在抱歉，源码有一点误差：Report_Function.cs 的print_File ()函数内修改为：if (_pgselect != -1)         {             pSize = new PaperSize(page_types[_pgselect] " page", (int)(PreViewPage_Area.Width / 25.4f * 100f), (int)(PreViewPage_Area.Height / 25.4f * 100f)); ..........................    }         else         {             ..............................             pSize = new PaperSize("Custom page", (int)(PreViewPage_Area.Width / 25.4f * 100f), (int)(PreViewPage_Area.Height / 25.4f * 100f));         }换算比例搞成旧的了，横向打印输出打印机打不全了。自己修改下

该实例用多种方式实现了根据用户输入自动完成的功能，是开发时较为常用的智能提示方法

C#常用类库(DotNetUtilities)

C# RichTextBox 常用操作(可插入图片/更改字体/获取Rtf Codes)

线程操作数据查询，防止窗口卡死

NetMQ