全局搜索结果(4)

  • 技术文摘c# 实现文件下载功能,带下载进度条,可用到软件的自动更新中
  • 2021/1/19 18:44:59
  • ...rc="https://img-blog.csdnimg.cn/20190516112307397.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3h1a2FpNTE1Nzg2,size_16,color_FFFFFF,t_70" src="https://img-blog.csdnimg.cn/20190516112307397.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3h1a2FpNTE1Nzg2,size_16,color_FFFFFF,t_70" width="478" class="has cke_widget_element" data-cke-widget-data="{"hasCaption":false,"src":"https://img-blog.csdnimg.cn/20190516112307397.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3h1a2FpNTE1Nzg2,size_16,color_FFFFFF,t_70","alt":"","width":"478","height":"238","lock":true,"align":"none","classes":{"has":1}}" data-cke-widget-upcasted="1" data-cke-widget-keep-attr="0" data-widget="image">​1、实例一个委托: private delegate void setText();2、定义一个线程内方法:public void Threadp() { try { setText d = new setText(downFile); //实例化一个委托 this.Invoke(d); //在拥用此控件的基础窗体句柄的线程上执行指定的委托 } catch (Exception ex) { MessageBox.Show(ex.Message); } }3、下载文件的方法: public void downFile() { string updateFileUrl = textBox1.Text.Trim(); long fileLength = 0; try { int readCountOnce = 5;//每次下载的字节数,该值越大,下载越快 WebRequest webReq = WebRequest.Create(updateFileUrl); WebResponse webRes = webReq.GetResponse(); fileLength = webRes.ContentLength; pbDownFile.Value = 0; pbDownFile.Maximum = (int)fileLength; try { Stream srm = webRes.GetResponseStream(); StreamReader srmReader = new StreamReader(srm); byte[] bufferbyte = new byte[fileLength]; int allByte = (int)bufferbyte.Length; int startByte = 0; while (fileLength > 0) { Application.DoEvents(); int downByte = srm.Read(bufferbyte, startByte, allByte > readCountOnce ? readCountOnce : allByte); if (downByte == 0) { break; }; startByte += downByte; allByte -= downByte; pbDownFile.Value += downByte; float part = (float)startByte / readCountOnce; float total = (float)bufferbyte.Length / readCountOnce; int percent = Convert.ToInt32((part / total) * 100); this.label_precess.Text = percent.ToString() + "%"; } string tempPath = Application.StartupPath + "//files//"; if (!Directory.Exists(tempPath)) { Directory.CreateDirectory(tempPath); } tempPath += DateTime.Now.ToString("yyyyMMddHHmmss"); FileStream fs = new FileStream(tempPath, FileMode.OpenOrCreate, FileAccess.Write); fs.Write(bufferbyte, 0, bufferbyte.Length); srm.Close(); srmReader.Close(); fs.Close(); } catch (WebException ex) { MessageBox.Show("更新文件下载失败!" + ex.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (WebException ex1) { MessageBox.Show("更新文件下载失败!" + ex1.Message.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }4、万事具备, 只欠东风了,来一个选择文件路径的按钮(文件路径可以是网络路径)private void button2_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == DialogResult.OK) { this.textBox1.Text = ofd.FileName; } }5、开始下载按钮事件:try { //string UpdateFile = textBox1.Text.Trim(); Thread threadDown = new Thread(new ThreadStart(Threadp)); threadDown.IsBackground = true; threadDown.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message); }
  • 评论:0 / 阅读:1135
  • 技术文摘c# 如何打印条形码
  • 2021/1/20 20:30:37
  • ...t;, \&quot;16\&quot;, \&quot;123122\&quot;);\n m_Code128.Rows.Add(\&quot;17\&quot;, \&quot;1\&quot;, \&quot;1\&quot;, \&quot;17\&quot;, \&quot;123221\&quot;);\n m_Code128.Rows.Add(\&quot;18\&quot;, \&quot;2\&quot;, \&quot;2\&quot;, \&quot;18\&quot;, \&quot;223211\&quot;);\n m_Code128.Rows.Add(\&quot;19\&quot;, \&quot;3\&quot;, \&quot;3\&quot;, \&quot;19\&quot;, \&quot;221132\&quot;);\n m_Code128.Rows.Add(\&quot;20\&quot;, \&quot;4\&quot;, \&quot;4\&quot;, \&quot;20\&quot;, \&quot;221231\&quot;);\n m_Code128.Rows.Add(\&quot;21\&quot;, \&quot;5\&quot;, \&quot;5\&quot;, \&quot;21\&quot;, \&quot;213212\&quot;);\n m_Code128.Rows.Add(\&quot;22\&quot;, \&quot;6\&quot;, \&quot;6\&quot;, \&quot;22\&quot;, \&quot;223112\&quot;);\n m_Code128.Rows.Add(\&quot;23\&quot;, \&quot;7\&quot;, \&quot;7\&quot;, \&quot;23\&quot;, \&quot;312131\&quot;);\n m_Code128.Rows.Add(\&quot;24\&quot;, \&quot;8\&quot;, \&quot;8\&quot;, \&quot;24\&quot;, \&quot;311222\&quot;);\n m_Code128.Rows.Add(\&quot;25\&quot;, \&quot;9\&quot;, \&quot;9\&quot;, \&quot;25\&quot;, \&quot;321122\&quot;);\n m_Code128.Rows.Add(\&quot;26\&quot;, \&quot;:\&quot;, \&quot;:\&quot;, \&quot;26\&quot;, \&quot;321221\&quot;);\n m_Code128.Rows.Add(\&quot;27\&quot;, \&quot;;\&quot;, \&quot;;\&quot;, \&quot;27\&quot;, \&quot;312212\&quot;);\n m_Code128.Rows.Add(\&quot;28\&quot;, \&quot;&lt;\&quot;, \&quot;&lt;\&quot;, \&quot;28\&quot;, \&quot;322112\&quot;);\n m_Code128.Rows.Add(\&quot;29\&quot;, \&quot;=\&quot;, \&quot;=\&quot;, \&quot;29\&quot;, \&quot;322211\&quot;);\n m_Code128.Rows.Add(\&quot;30\&quot;, \&quot;&gt;\&quot;, \&quot;&gt;\&quot;, \&quot;30\&quot;, \&quot;212123\&quot;);\n m_Code128.Rows.Add(\&quot;31\&quot;, \&quot;?\&quot;, \&quot;?\&quot;, \&quot;31\&quot;, \&quot;212321\&quot;);\n m_Code128.Rows.Add(\&quot;32\&quot;, \&quot;@\&quot;, \&quot;@\&quot;, \&quot;32\&quot;, \&quot;232121\&quot;);\n m_Code128.Rows.Add(\&quot;33\&quot;, \&quot;A\&quot;, \&quot;A\&quot;, \&quot;33\&quot;, \&quot;111323\&quot;);\n m_Code128.Rows.Add(\&quot;34\&quot;, \&quot;B\&quot;, \&quot;B\&quot;, \&quot;34\&quot;, \&quot;131123\&quot;);\n m_Code128.Rows.Add(\&quot;35\&quot;, \&quot;C\&quot;, \&quot;C\&quot;, \&quot;35\&quot;, \&quot;131321\&quot;);\n m_Code128.Rows.Add(\&quot;36\&quot;, \&quot;D\&quot;, \&quot;D\&quot;, \&quot;36\&quot;, \&quot;112313\&quot;);\n m_Code128.Rows.Add(\&quot;37\&quot;, \&quot;E\&quot;, \&quot;E\&quot;, \&quot;37\&quot;, \&quot;132113\&quot;);\n m_Code128.Rows.Add(\&quot;38\&quot;, \&quot;F\&quot;, \&quot;F\&quot;, \&quot;38\&quot;, \&quot;132311\&quot;);\n m_Code128.Rows.Add(\&quot;39\&quot;, \&quot;G\&quot;, \&quot;G\&quot;, \&quot;39\&quot;, \&quot;211313\&quot;);\n m_Code128.Rows.Add(\&quot;40\&quot;, \&quot;H\&quot;, \&quot;H\&quot;, \&quot;40\&quot;, \&quot;231113\&quot;);\n m_Code128.Rows.Add(\&quot;41\&quot;, \&quot;I\&quot;, \&quot;I\&quot;, \&quot;41\&quot;, \&quot;231311\&quot;);\n m_Code128.Rows.Add(\&quot;42\&quot;, \&quot;J\&quot;, \&quot;J\&quot;, \&quot;42\&quot;, \&quot;112133\&quot;);\n m_Code128.Rows.Add(\&quot;43\&quot;, \&quot;K\&quot;, \&quot;K\&quot;, \&quot;43\&quot;, \&quot;112331\&quot;);\n m_Code128.Rows.Add(\&quot;44\&quot;, \&quot;L\&quot;, \&quot;L\&quot;, \&quot;44\&quot;, \&quot;132131\&quot;);\n m_Code128.Rows.Add(\&quot;45\&quot;, \&quot;M\&quot;, \&quot;M\&quot;, \&quot;45\&quot;, \&quot;113123\&quot;);\n m_Code128.Rows.Add(\&quot;46\&quot;, \&quot;N\&quot;, \&quot;N\&quot;, \&quot;46\&quot;, \&quot;113321\&quot;);\n m_Code128.Rows.Add(\&quot;47\&quot;, \&quot;O\&quot;, \&quot;O\&quot;, \&quot;47\&quot;, \&quot;133121\&quot;);\n m_Code128.Rows.Add(\&quot;48\&quot;, \&quot;P\&quot;, \&quot;P\&quot;, \&quot;48\&quot;, \&quot;313121\&quot;);\n m_Code128.Rows.Add(\&quot;49\&quot;, \&quot;Q\&quot;, \&quot;Q\&quot;, \&quot;49\&quot;, \&quot;211331\&quot;);\n m_Code128.Rows.Add(\&quot;50\&quot;, \&quot;R\&quot;, \&quot;R\&quot;, \&quot;50\&quot;, \&quot;231131\&quot;);\n m_Code128.Rows.Add(\&quot;51\&quot;, \&quot;S\&quot;, \&quot;S\&quot;, \&quot;51\&quot;, \&quot;213113\&quot;);\n m_Code128.Rows.Add(\&quot;52\&quot;, \&quot;T\&quot;, \&quot;T\&quot;, \&quot;52\&quot;, \&quot;213311\&quot;);\n m_Code128.Rows.Add(\&quot;53\&quot;, \&quot;U\&quot;, \&quot;U\&quot;, \&quot;53\&quot;, \&quot;213131\&quot;);\n m_Code128.Rows.Add(\&quot;54\&quot;, \&quot;V\&quot;, \&quot;V\&quot;, \&quot;54\&quot;, \&quot;311123\&quot;);\n m_Code128.Rows.Add(\&quot;55\&quot;, \&quot;W\&quot;, \&quot;W\&quot;, \&quot;55\&quot;, \&quot;311321\&quot;);\n m_Code128.Rows.Add(\&quot;56\&quot;, \&quot;X\&quot;, \&quot;X\&quot;, \&quot;56\&quot;, \&quot;331121\&quot;);\n m_Code128.Rows.Add(\&quot;57\&quot;, \&quot;Y\&quot;, \&quot;Y\&quot;, \&quot;57\&quot;, \&quot;312113\&quot;);\n m_Code128.Rows.Add(\&quot;58\&quot;, \&quot;Z\&quot;, \&quot;Z\&quot;, \&quot;58\&quot;, \&quot;312311\&quot;);\n m_Code128.Rows.Add(\&quot;59\&quot;, \&quot;[\&quot;, \&quot;[\&quot;, \&quot;59\&quot;, \&quot;332111\&quot;);\n m_Code128.Rows.Add(\&quot;60\&quot;, \&quot;\\\\\&quot;, \&quot;\\\\\&quot;, \&quot;60\&quot;, \&quot;314111\&quot;);\n m_Code128.Rows.Add(\&quot;61\&quot;, \&quot;]\&quot;, \&quot;]\&quot;, \&quot;61\&quot;, \&quot;221411\&quot;);\n m_Code128.Rows.Add(\&quot;62\&quot;, \&quot;^\&quot;, \&quot;^\&quot;, \&quot;62\&quot;, \&quot;431111\&quot;);\n m_Code128.Rows.Add(\&quot;63\&quot;, \&quot;_\&quot;, \&quot;_\&quot;, \&quot;63\&quot;, \&quot;111224\&quot;);\n m_Code128.Rows.Add(\&quot;64\&quot;, \&quot;NUL\&quot;, \&quot;`\&quot;, \&quot;64\&quot;, \&quot;111422\&quot;);\n m_Code128.Rows.Add(\&quot;65\&quot;, \&quot;SOH\&quot;, \&quot;a\&quot;, \&quot;65\&quot;, \&quot;121124\&quot;);\n m_Code128.Rows.Add(\&quot;66\&quot;, \&quot;STX\&quot;, \&quot;b\&quot;, \&quot;66\&quot;, \&quot;121421\&quot;);\n m_Code128.Rows.Add(\&quot;67\&quot;, \&quot;ETX\&quot;, \&quot;c\&quot;, \&quot;67\&quot;, \&quot;141122\&quot;);\n m_Code128.Rows.Add(\&quot;68\&quot;, \&quot;EOT\&quot;, \&quot;d\&quot;, \&quot;68\&quot;, \&quot;141221\&quot;);\n m_Code128.Rows.Add(\&quot;69\&quot;, \&quot;ENQ\&quot;, \&quot;e\&quot;, \&quot;69\&quot;, \&quot;112214\&quot;);\n m_Code128.Rows.Add(\&quot;70\&quot;, \&quot;ACK\&quot;, \&quot;f\&quot;, \&quot;70\&quot;, \&quot;112412\&quot;);\n m_Code128.Rows.Add(\&quot;71\&quot;, \&quot;BEL\&quot;, \&quot;g\&quot;, \&quot;71\&quot;, \&quot;122114\&quot;);\n m_Code128.Rows.Add(\&quot;72\&quot;, \&quot;BS\&quot;, \&quot;h\&quot;, \&quot;72\&quot;, \&quot;122411\&quot;);\n m_Code128.Rows.Add(\&quot;73\&quot;, \&quot;HT\&quot;, \&quot;i\&quot;, \&quot;73\&quot;, \&quot;142112\&quot;);\n m_Code128.Rows.Add(\&quot;74\&quot;, \&quot;LF\&quot;, \&quot;j\&quot;, \&quot;74\&quot;, \&quot;142211\&quot;);\n m_Code128.Rows.Add(\&quot;75\&quot;, \&quot;VT\&quot;, \&quot;k\&quot;, \&quot;75\&quot;, \&quot;241211\&quot;);\n m_Code128.Rows.Add(\&quot;76\&quot;, \&quot;FF\&quot;, \&quot;I\&quot;, \&quot;76\&quot;, \&quot;221114\&quot;);\n m_Code128.Rows.Add(\&quot;77\&quot;, \&quot;CR\&quot;, \&quot;m\&quot;, \&quot;77\&quot;, \&quot;413111\&quot;);\n m_Code128.Rows.Add(\&quot;78\&quot;, \&quot;SO\&quot;, \&quot;n\&quot;, \&quot;78\&quot;, \&quot;241112\&quot;);\n m_Code128.Rows.Add(\&quot;79\&quot;, \&quot;SI\&quot;, \&quot;o\&quot;, \&quot;79\&quot;, \&quot;134111\&quot;);\n m_Code128.Rows.Add(\&quot;80\&quot;, \&quot;DLE\&quot;, \&quot;p\&quot;, \&quot;80\&quot;, \&quot;111242\&quot;);\n m_Code128.Rows.Add(\&quot;81\&quot;, \&quot;DC1\&quot;, \&quot;q\&quot;, \&quot;81\&quot;, \&quot;121142\&quot;);\n m_Code128.Rows.Add(\&quot;82\&quot;, \&quot;DC2\&quot;, \&quot;r\&quot;, \&quot;82\&quot;, \&quot;121241\&quot;);\n m_Code128.Rows.Add(\&quot;83\&quot;, \&quot;DC3\&quot;, \&quot;s\&quot;, \&quot;83\&quot;, \&quot;114212\&quot;);\n m_Code128.Rows.Add(\&quot;84\&quot;, \&quot;DC4\&quot;, \&quot;t\&quot;, \&quot;84\&quot;, \&quot;124112\&quot;);\n m_Code128.Rows.Add(\&quot;85\&quot;, \&quot;NAK\&quot;, \&quot;u\&quot;, \&quot;85\&quot;, \&quot;124211\&quot;);\n m_Code128.Rows.Add(\&quot;86\&quot;, \&quot;SYN\&quot;, \&quot;v\&quot;, \&quot;86\&quot;, \&quot;411212\&quot;);\n m_Code128.Rows.Add(\&quot;87\&quot;, \&quot;ETB\&quot;, \&quot;w\&quot;, \&quot;87\&quot;, \&quot;421112\&quot;);\n m_Code128.Rows.Add(\&quot;88\&quot;, \&quot;CAN\&quot;, \&quot;x\&quot;, \&quot;88\&quot;, \&quot;421211\&quot;);\n m_Code128.Rows.Add(\&quot;89\&quot;, \&quot;EM\&quot;, \&quot;y\&quot;, \&quot;89\&quot;, \&quot;212141\&quot;);\n m_Code128.Rows.Add(\&quot;90\&quot;, \&quot;SUB\&quot;, \&quot;z\&quot;, \&quot;90\&quot;, \&quot;214121\&quot;);\n m_Code128.Rows.Add(\&quot;91\&quot;, \&quot;ESC\&quot;, \&quot;{\&quot;, \&quot;91\&quot;, \&quot;412121\&quot;);\n m_Code128.Rows.Add(\&quot;92\&quot;, \&quot;FS\&quot;, \&quot;|\&quot;, \&quot;92\&quot;, \&quot;111143\&quot;);\n m_Code128.Rows.Add(\&quot;93\&quot;, \&quot;GS\&quot;, \&quot;}\&quot;, \&quot;93\&quot;, \&quot;111341\&quot;);\n m_Code128.Rows.Add(\&quot;94\&quot;, \&quot;RS\&quot;, \&quot;~\&quot;, \&quot;94\&quot;, \&quot;131141\&quot;);\n m_Code128.Rows.Add(\&quot;95\&quot;, \&quot;US\&quot;, \&quot;DEL\&quot;, \&quot;95\&quot;, \&quot;114113\&quot;);\n m_Code128.Rows.Add(\&quot;96\&quot;, \&quot;FNC3\&quot;, \&quot;FNC3\&quot;, \&quot;96\&quot;, \&quot;114311\&quot;);\n m_Code128.Rows.Add(\&quot;97\&quot;, \&quot;FNC2\&quot;, \&quot;FNC2\&quot;, \&quot;97\&quot;, \&quot;411113\&quot;);\n m_Code128.Rows.Add(\&quot;98\&quot;, \&quot;SHIFT\&quot;, \&quot;SHIFT\&quot;, \&quot;98\&quot;, \&quot;411311\&quot;);\n m_Code128.Rows.Add(\&quot;99\&quot;, \&quot;CODEC\&quot;, \&quot;CODEC\&quot;, \&quot;99\&quot;, \&quot;113141\&quot;);\n m_Code128.Rows.Add(\&quot;100\&quot;, \&quot;CODEB\&quot;, \&quot;FNC4\&quot;, \&quot;CODEB\&quot;, \&quot;114131\&quot;);\n m_Code128.Rows.Add(\&quot;101\&quot;, \&quot;FNC4\&quot;, \&quot;CODEA\&quot;, \&quot;CODEA\&quot;, \&quot;311141\&quot;);\n m_Code128.Rows.Add(\&quot;102\&quot;, \&quot;FNC1\&quot;, \&quot;FNC1\&quot;, \&quot;FNC1\&quot;, \&quot;411131\&quot;);\n m_Code128.Rows.Add(\&quot;103\&quot;, \&quot;StartA\&quot;, \&quot;StartA\&quot;, \&quot;StartA\&quot;, \&quot;211412\&quot;);\n m_Code128.Rows.Add(\&quot;104\&quot;, \&quot;StartB\&quot;, \&quot;StartB\&quot;, \&quot;StartB\&quot;, \&quot;211214\&quot;);\n m_Code128.Rows.Add(\&quot;105\&quot;, \&quot;StartC\&quot;, \&quot;StartC\&quot;, \&quot;StartC\&quot;, \&quot;211232\&quot;);\n m_Code128.Rows.Add(\&quot;106\&quot;, \&quot;Stop\&quot;, \&quot;Stop\&quot;, \&quot;Stop\&quot;, \&quot;2331112\&quot;);\n #endregion\n }\n /// &lt;summary&gt;\n /// 获取128图形\n /// &lt;/summary&gt;\n /// &lt;param name=\&quot;p_Text\&quot;&gt;文字&lt;/param&gt;\n /// &lt;param name=\&quot;p_Code\&quot;&gt;编码&lt;/param&gt; \n /// &lt;returns&gt;图形&lt;/returns&gt;\n public Bitmap GetCodeImage(string p_Text, Encode p_Code,Graphics g=null)\n {\n string _ViewText = p_Text;\n string _Text = \&quot;\&quot;;\n IList&lt;int&gt; _TextNumb = new List&lt;int&gt;();\n int _Examine = 0; //首位\n switch (p_Code)\n {\n case Encode.Code128C:\n _Examine = 105;\n if (!((p_Text.Length &amp; 1) == 0)) throw new Exception(\&quot;128C长度必须是偶数\&quot;);\n while (p_Text.Length != 0)\n {\n int _Temp = 0;\n try\n {\n int _CodeNumb128 = Int32.Parse(p_Text.Substring(0, 2));\n }\n catch\n {\n throw new Exception(\&quot;128C必须是数字!\&quot;);\n }\n _Text += GetValue(p_Code, p_Text.Substring(0, 2), ref _Temp);\n _TextNumb.Add(_Temp);\n p_Text = p_Text.Remove(0, 2);\n }\n break;\n case Encode.EAN128:\n _Examine = 105;\n if (!((p_Text.Length &amp; 1) == 0)) throw new Exception(\&quot;EAN128长度必须是偶数\&quot;);\n _TextNumb.Add(102);\n _Text += \&quot;411131\&quot;;\n while (p_Text.Length != 0)\n {\n int _Temp = 0;\n try\n {\n int _CodeNumb128 = Int32.Parse(p_Text.Substring(0, 2));\n }\n catch\n {\n throw new Exception(\&quot;128C必须是数字!\&quot;);\n }\n _Text += GetValue(Encode.Code128C, p_Text.Substring(0, 2), ref _Temp);\n _TextNumb.Add(_Temp);\n p_Text = p_Text.Remove(0, 2);\n }\n break;\n default:\n if (p_Code == Encode.Code128A)\n {\n _Examine = 103;\n }\n else\n {\n _Examine = 104;\n }\n\n while (p_Text.Length != 0)\n {\n int _Temp = 0;\n string _ValueCode = GetValue(p_Code, p_Text.Substring(0, 1), ref _Temp);\n if (_ValueCode.Length == 0) throw new Exception(\&quot;无效的字符集!\&quot; + p_Text.Substring(0, 1).ToString());\n _Text += _ValueCode;\n _TextNumb.Add(_Temp);\n p_Text = p_Text.Remove(0, 1);\n }\n break;\n }\n if (_TextNumb.Count == 0) throw new Exception(\&quot;错误的编码,无数据\&quot;);\n _Text = _Text.Insert(0, GetValue(_Examine)); //获取开始位\n\n for (int i = 0; i != _TextNumb.Count; i++)\n {\n _Examine += _TextNumb[i] * (i + 1);\n }\n _Examine = _Examine % 103; //获得严效位\n _Text += GetValue(_Examine); //获取严效位\n _Text += \&quot;2331112\&quot;; //结束位\n Bitmap _CodeImage = GetImage(_Text, _ViewText,g);\n //GetViewText(_CodeImage, _ViewText);\n return _CodeImage;\n }\n /// &lt;summary&gt;\n /// 获取目标对应的数据\n /// &lt;/summary&gt;\n /// &lt;param name=\&quot;p_Code\&quot;&gt;编码&lt;/param&gt;\n /// &lt;param name=\&quot;p_Value\&quot;&gt;数值 A b 30&lt;/param&gt;\n /// &lt;param name=\&quot;p_SetID\&quot;&gt;返回编号&lt;/param&gt;\n /// &lt;returns&gt;编码&lt;/returns&gt;\n private string GetValue(Encode p_Code, string p_Value, ref int p_SetID)\n {\n if (m_Code128 == null) return \&quot;\&quot;;\n DataRow[] _Row = m_Code128.Select(p_Code.ToString() + \&quot;='\&quot; + p_Value + \&quot;'\&quot;);\n if (_Row.Length != 1) throw new Exception(\&quot;错误的编码\&quot; + p_Value.ToString());\n p_SetID = Int32.Parse(_Row[0][\&quot;ID\&quot;].ToString());\n return _Row[0][\&quot;BandCode\&quot;].ToString();\n }\n /// &lt;summary&gt;\n /// 根据编号获得条纹\n /// &lt;/summary&gt;\n /// &lt;param name=\&quot;p_CodeId\&quot;&gt;&lt;/param&gt;\n /// &lt;returns&gt;&lt;/returns&gt;\n private string GetValue(int p_CodeId)\n {\n DataRow[] _Row = m_Code128.Select(\&quot;ID='\&quot; + p_CodeId.ToString() + \&quot;'\&quot;);\n if (_Row.Length != 1) throw new Exception(\&quot;验效位的编码错误\&quot; + p_CodeId.ToString());\n return _Row[0][\&quot;BandCode\&quot;].ToString();\n }\n /// &lt;summary&gt;\n /// 获得条码图形\n /// &lt;/summary&gt;\n /// &lt;param name=\&quot;p_Text\&quot;&gt;文字&lt;/param&gt;\n /// &lt;returns&gt;图形&lt;/returns&gt;\n private Bitmap GetImage(string p_Text, string sourceText,Graphics g=null)\n {\n char[] _Value = p_Text.ToCharArray();\n int _Width = 0;\n for (int i = 0; i != _Value.Length; i++)\n {\n _Width += Int32.Parse(_Value[i].ToString()) * (m_Magnify + 1);\n }\n Bitmap _CodeImage = new Bitmap(_Width+4 , (int)m_Height + 12);\n Graphics _Garphics = g;\n //Pen _Pen;\n int _LenEx = 6;\n int _TopEx = 4;\n if (g == null)\n {\n Graphics.FromImage(_CodeImage);\n _LenEx = 2;\n _TopEx = 0;\n }\n\n for (int i = 0; i != _Value.Length; i++)\n {\n int _ValueNumb = Int32.Parse(_Value[i].ToString()) * (m_Magnify + 1); //获取宽和放大系数\n if (!((i &amp; 1) == 0))\n {\n //_Pen = new Pen(Brushes.White, _ValueNumb);\n _Garphics.FillRectangle(Brushes.White, new Rectangle(_LenEx, _TopEx, _ValueNumb, (int)m_Height));\n }\n else\n {\n //_Pen = new Pen(Brushes.Black, _ValueNumb);\n _Garphics.FillRectangle(Brushes.Black, new Rectangle(_LenEx, _TopEx, _ValueNumb, (int)m_Height));\n }\n //_Garphics.(_Pen, new Point(_LenEx, 0), new Point(_LenEx, m_Height));\n _LenEx += _ValueNumb;\n }\n _Garphics.DrawString(sourceText, new Font(\&quot;宋体\&quot;, 10f), new SolidBrush(Color.Black), new PointF(2, m_Height+_TopEx));\n if (_Garphics != g)\n {\n _Garphics.Dispose();\n }\n return _CodeImage;\n }\n /// &lt;summary&gt;\n /// 显示可见条码文字 如果小于40 不显示文字\n /// &lt;/summary&gt;\n /// &lt;param name=\&quot;p_Bitmap\&quot;&gt;图形&lt;/param&gt; \n private void GetViewText(Bitmap p_Bitmap, string p_ViewText)\n {\n if (m_ValueFont == null) return;\n\n Graphics _Graphics = Graphics.FromImage(p_Bitmap);\n SizeF _DrawSize = _Graphics.MeasureString(p_ViewText, m_ValueFont);\n if (_DrawSize.Height &gt; p_Bitmap.Height - 10 || _DrawSize.Width &gt; p_Bitmap.Width)\n {\n _Graphics.Dispose();\n return;\n }\n\n int _StarY = p_Bitmap.Height - (int)_DrawSize.Height;\n _Graphics.FillRectangle(Brushes.White, new Rectangle(0, _StarY, p_Bitmap.Width, (int)_DrawSize.Height));\n _Graphics.DrawString(p_ViewText, m_ValueFont, Brushes.Black, 0, _StarY);\n }\n\n //12345678\n //(105 + (1 * 12 + 2 * 34 + 3 * 56 + 4 *78)) % 103 = 47\n //结果为starc +12 +34 +56 +78 +47 +end\n\n\n}\n\n&quot;,&quot;classes&quot;:{&quot;has&quot;:1}}" data-cke-widget-upcasted="1" data-cke-widget-keep-attr="0" data-widget="codeSnippet">using System; using System.Collections.Generic; using System.Data; using System.Drawing; public class Code128 { private DataTable m_Code128 = new DataTable(); private uint m_Height = 40; /// <summary> /// 高度 /// </summary> public uint Height { get { return m_Height; } set { m_Height = value; } } private Font m_ValueFont = null; /// <summary> /// 是否显示可见号码 如果为NULL不显示号码 /// </summary> public Font ValueFont { get { return m_ValueFont; } set { m_ValueFont = value; } } private byte m_Magnify = 0; /// <summary> /// 放大倍数 /// </summary> public byte Magnify { get { return m_Magnify; } set { m_Magnify = value; } } /// <summary> /// 条码类别 /// </summary> public enum Encode { Code128A, Code128B, Code128C, EAN128 } public Code128() { m_Code128.Columns.Add("ID"); m_Code128.Columns.Add("Code128A"); m_Code128.Columns.Add("Code128B"); m_Code128.Columns.Add("Code128C"); m_Code128.Columns.Add("BandCode"); m_Code128.CaseSensitive = true; #region 数据表 m_Code128.Rows.Add("0", " ", " ", "00", "212222"); m_Code128.Rows.Add("1", "!", "!", "01", "222122"); m_Code128.Rows.Add("2", "\"", "\"", "02", "222221"); m_Code128.Rows.Add("3", "#", "#", "03", "121223"); m_Code128.Rows.Add("4", "$", "$", "04", "121322"); m_Code128.Rows.Add("5", "%", "%", "05", "131222"); m_Code128.Rows.Add("6", "&", "&", "06", "122213"); m_Code128.Rows.Add("7", "'", "'", "07", "122312"); m_Code128.Rows.Add("8", "(", "(", "08", "132212"); m_Code128.Rows.Add("9", ")", ")", "09", "221213"); m_Code128.Rows.Add("10", "*", "*", "10", "221312"); m_Code128.Rows.Add("11", "+", "+", "11", "231212"); m_Code128.Rows.Add("12", ",", ",", "12", "112232"); m_Code128.Rows.Add("13", "-", "-", "13", "122132"); m_Code128.Rows.Add("14", ".", ".", "14", "122231"); m_Code128.Rows.Add("15", "/", "/", "15", "113222"); m_Code128.Rows.Add("16", "0", "0", "16", "123122"); m_Code128.Rows.Add("17", "1", "1", "17", "123221"); m_Code128.Rows.Add("18", "2", "2", "18", "223211"); m_Code128.Rows.Add("19", "3", "3", "19", "221132"); m_Code128.Rows.Add("20", "4", "4", "20", "221231"); m_Code128.Rows.Add("21", "5", "5", "21", "213212"); m_Code128.Rows.Add("22", "6", "6", "22", "223112"); m_Code128.Rows.Add("23", "7", "7", "23", "312131"); m_Code128.Rows.Add("24", "8", "8", "24", "311222"); m_Code128.Rows.Add("25", "9", "9", "25", "321122"); m_Code128.Rows.Add("26", ":", ":", "26", "321221"); m_Code128.Rows.Add("27", ";", ";", "27", "312212"); m_Code128.Rows.Add("28", "<", "<", "28", "322112"); m_Code128.Rows.Add("29", "=", "=", "29", "322211"); m_Code128.Rows.Add("30", ">", ">", "30", "212123"); m_Code128.Rows.Add("31", "?", "?", "31", "212321"); m_Code128.Rows.Add("32", "@", "@", "32", "232121"); m_Code128.Rows.Add("33", "A", "A", "33", "111323"); m_Code128.Rows.Add("34", "B", "B", "34", "131123"); m_Code128.Rows.Add("35", "C", "C", "35", "131321"); m_Code128.Rows.Add("36", "D", "D", "36", "112313"); m_Code128.Rows.Add("37", "E", "E", "37", "132113"); m_Code128.Rows.Add("38", "F", "F", "38", "132311"); m_Code128.Rows.Add("39", "G", "G", "39", "211313"); m_Code128.Rows.Add("40", "H", "H", "40", "231113"); m_Code128.Rows.Add("41", "I", "I", "41", "231311"); m_Code128.Rows.Add("42", "J", "J", "42", "112133"); m_Code128.Rows.Add("43", "K", "K", "43", "112331"); m_Code128.Rows.Add("44", "L", "L", "44", "132131"); m_Code128.Rows.Add("45", "M", "M", "45", "113123"); m_Code128.Rows.Add("46", "N", "N", "46", "113321"); m_Code128.Rows.Add("47", "O", "O", "47", "133121"); m_Code128.Rows.Add("48", "P", "P", "48", "313121"); m_Code128.Rows.Add("49", "Q", "Q", "49", "211331"); m_Code128.Rows.Add("50", "R", "R", "50", "231131"); m_Code128.Rows.Add("51", "S", "S", "51", "213113"); m_Code128.Rows.Add("52", "T", "T", "52", "213311"); m_Code128.Rows.Add("53", "U", "U", "53", "213131"); m_Code128.Rows.Add("54", "V", "V", "54", "311123"); m_Code128.Rows.Add("55", "W", "W", "55", "311321"); m_Code128.Rows.Add("56", "X", "X", "56", "331121"); m_Code128.Rows.Add("57", "Y", "Y", "57", "312113"); m_Code128.Rows.Add("58", "Z", "Z", "58", "312311"); m_Code128.Rows.Add("59", "[", "[", "59", "332111"); m_Code128.Rows.Add("60", "\\", "\\", "60", "314111"); m_Code128.Rows.Add("61", "]", "]", "61", "221411"); m_Code128.Rows.Add("62", "^", "^", "62", "431111"); m_Code128.Rows.Add("63", "_", "_", "63", "111224"); m_Code128.Rows.Add("64", "NUL", "`", "64", "111422"); m_Code128.Rows.Add("65", "SOH", "a", "65", "121124"); m_Code128.Rows.Add("66", "STX", "b", "66", "121421"); m_Code128.Rows.Add("67", "ETX", "c", "67", "141122"); m_Code128.Rows.Add("68", "EOT", "d", "68", "141221"); m_Code128.Rows.Add("69", "ENQ", "e", "69", "112214"); m_Code128.Rows.Add("70", "ACK", "f", "70", "112412"); m_Code128.Rows.Add("71", "BEL", "g", "71", "122114"); m_Code128.Rows.Add("72", "BS", "h", "72", "122411"); m_Code128.Rows.Add("73", "HT", "i", "73", "142112"); m_Code128.Rows.Add("74", "LF", "j", "74", "142211"); m_Code128.Rows.Add("75", "VT", "k", "75", "241211"); m_Code128.Rows.Add("76", "FF", "I", "76", "221114"); m_Code128.Rows.Add("77", "CR", "m", "77", "413111"); m_Code128.Rows.Add("78", "SO", "n", "78", "241112"); m_Code128.Rows.Add("79", "SI", "o", "79", "134111"); m_Code128.Rows.Add("80", "DLE", "p", "80", "111242"); m_Code128.Rows.Add("81", "DC1", "q", "81", "121142"); m_Code128.Rows.Add("82", "DC2", "r", "82", "121241"); m_Code128.Rows.Add("83", "DC3", "s", "83", "114212"); m_Code128.Rows.Add("84", "DC4", "t", "84", "124112"); m_Code128.Rows.Add("85", "NAK", "u", "85", "124211"); m_Code128.Rows.Add("86", "SYN", "v", "86", "411212"); m_Code128.Rows.Add("87", "ETB", "w", "87", "421112"); m_Code128.Rows.Add("88", "CAN", "x", "88", "421211"); m_Code128.Rows.Add("89", "EM", "y", "89", "212141"); m_Code128.Rows.Add("90", "SUB", "z", "90", "214121"); m_Code128.Rows.Add("91", "ESC", "{", "91", "412121"); m_Code128.Rows.Add("92", "FS", "|", "92", "111143"); m_Code128.Rows.Add("93", "GS", "}", "93", "111341"); m_Code128.Rows.Add("94", "RS", "~", "94", "131141"); m_Code128.Rows.Add("95", "US", "DEL", "95", "114113"); m_Code128.Rows.Add("96", "FNC3", "FNC3", "96", "114311"); m_Code128.Rows.Add("97", "FNC2", "FNC2", "97", "411113"); m_Code128.Rows.Add("98", "SHIFT", "SHIFT", "98", "411311"); m_Code128.Rows.Add("99", "CODEC", "CODEC", "99", "113141"); m_Code128.Rows.Add("100", "CODEB", "FNC4", "CODEB", "114131"); m_Code128.Rows.Add("101", "FNC4", "CODEA", "CODEA", "311141"); m_Code128.Rows.Add("102", "FNC1", "FNC1", "FNC1", "411131"); m_Code128.Rows.Add("103", "StartA", "StartA", "StartA", "211412"); m_Code128.Rows.Add("104", "StartB", "StartB", "StartB", "211214"); m_Code128.Rows.Add("105", "StartC", "StartC", "StartC", "211232"); m_Code128.Rows.Add("106", "Stop", "Stop", "Stop", "2331112"); #endregion } /// <summary> /// 获取128图形 /// </summary> /// <param name="p_Text">文字</param> /// <param name="p_Code">编码</param> /// <returns>图形</returns> public Bitmap GetCodeImage(string p_Text, Encode p_Code,Graphics g=null) { string _ViewText = p_Text; string _Text = ""; IList<int> _TextNumb = new List<int>(); int _Examine = 0; //首位 switch (p_Code) { case Encode.Code128C: _Examine = 105; if (!((p_Text.Length & 1) == 0)) throw new Exception("128C长度必须是偶数"); while (p_Text.Length != 0) { int _Temp = 0; try { int _CodeNumb128 = Int32.Parse(p_Text.Substring(0, 2)); } catch { throw new Exception("128C必须是数字!"); } _Text += GetValue(p_Code, p_Text.Substring(0, 2), ref _Temp); _TextNumb.Add(_Temp); p_Text = p_Text.Remove(0, 2); } break; case Encode.EAN128: _Examine = 105; if (!((p_Text.Length & 1) == 0)) throw new Exception("EAN128长度必须是偶数"); _TextNumb.Add(102); _Text += "411131"; while (p_Text.Length != 0) { int _Temp = 0; try { int _CodeNumb128 = Int32.Parse(p_Text.Substring(0, 2)); } catch { throw new Exception("128C必须是数字!"); } _Text += GetValue(Encode.Code128C, p_Text.Substring(0, 2), ref _Temp); _TextNumb.Add(_Temp); p_Text = p_Text.Remove(0, 2); } break; default: if (p_Code == Encode.Code128A) { _Examine = 103; } else { _Examine = 104; } while (p_Text.Length != 0) { int _Temp = 0; string _ValueCode = GetValue(p_Code, p_Text.Substring(0, 1), ref _Temp); if (_ValueCode.Length == 0) throw new Exception("无效的字符集!" + p_Text.Substring(0, 1).ToString()); _Text += _ValueCode; _TextNumb.Add(_Temp); p_Text = p_Text.Remove(0, 1); } break; } if (_TextNumb.Count == 0) throw new Exception("错误的编码,无数据"); _Text = _Text.Insert(0, GetValue(_Examine)); //获取开始位 for (int i = 0; i != _TextNumb.Count; i++) { _Examine += _TextNumb[i] * (i + 1); } _Examine = _Examine % 103; //获得严效位 _Text += GetValue(_Examine); //获取严效位 _Text += "2331112"; //结束位 Bitmap _CodeImage = GetImage(_Text, _ViewText,g); //GetViewText(_CodeImage, _ViewText); return _CodeImage; } /// <summary> /// 获取目标对应的数据 /// </summary> /// <param name="p_Code">编码</param> /// <param name="p_Value">数值 A b 30</param> /// <param name="p_SetID">返回编号</param> /// <returns>编码</returns> private string GetValue(Encode p_Code, string p_Value, ref int p_SetID) { if (m_Code128 == null) return ""; DataRow[] _Row = m_Code128.Select(p_Code.ToString() + "='" + p_Value + "'"); if (_Row.Length != 1) throw new Exception("错误的编码" + p_Value.ToString()); p_SetID = Int32.Parse(_Row[0]["ID"].ToString()); return _Row[0]["BandCode"].ToString(); } /// <summary> /// 根据编号获得条纹 /// </summary> /// <param name="p_CodeId"></param> /// <returns></returns> private string GetValue(int p_CodeId) { DataRow[] _Row = m_Code128.Select("ID='" + p_CodeId.ToString() + "'"); if (_Row.Length != 1) throw new Exception("验效位的编码错误" + p_CodeId.ToString()); return _Row[0]["BandCode"].ToString(); } /// <summary> /// 获得条码图形 /// </summary> /// <param name="p_Text">文字</param> /// <returns>图形</returns> private Bitmap GetImage(string p_Text, string sourceText,Graphics g=null) { char[] _Value = p_Text.ToCharArray(); int _Width = 0; for (int i = 0; i != _Value.Length; i++) { _Width += Int32.Parse(_Value[i].ToString()) * (m_Magnify + 1); } Bitmap _CodeImage = new Bitmap(_Width+4 , (int)m_Height + 12); Graphics _Garphics = g; //Pen _Pen; int _LenEx = 6; int _TopEx = 4; if (g == null) { Graphics.FromImage(_CodeImage); _LenEx = 2; _TopEx = 0; } for (int i = 0; i != _Value.Length; i++) { int _ValueNumb = Int32.Parse(_Value[i].ToString()) * (m_Magnify + 1); //获取宽和放大系数 if (!((i & 1) == 0)) { //_Pen = new Pen(Brushes.White, _ValueNumb); _Garphics.FillRectangle(Brushes.White, new Rectangle(_LenEx, _TopEx, _ValueNumb, (int)m_Height)); } else { //_Pen = new Pen(Brushes.Black, _ValueNumb); _Garphics.FillRectangle(Brushes.Black, new Rectangle(_LenEx, _TopEx, _ValueNumb, (int)m_Height)); } //_Garphics.(_Pen, new Point(_LenEx, 0), new Point(_LenEx, m_Height)); _LenEx += _ValueNumb; } _Garphics.DrawString(sourceText, new Font("宋体", 10f), new SolidBrush(Color.Black), new PointF(2, m_Height+_TopEx)); if (_Garphics != g) { _Garphics.Dispose(); } return _CodeImage; } /// <summary> /// 显示可见条码文字 如果小于40 不显示文字 /// </summary> /// <param name="p_Bitmap">图形</param> private void GetViewText(Bitmap p_Bitmap, string p_ViewText) { if (m_ValueFont == null) return; Graphics _Graphics = Graphics.FromImage(p_Bitmap); SizeF _DrawSize = _Graphics.MeasureString(p_ViewText, m_ValueFont); if (_DrawSize.Height > p_Bitmap.Height - 10 || _DrawSize.Width > p_Bitmap.Width) { _Graphics.Dispose(); return; } int _StarY = p_Bitmap.Height - (int)_DrawSize.Height; _Graphics.FillRectangle(Brushes.White, new Rectangle(0, _StarY, p_Bitmap.Width, (int)_DrawSize.Height)); _Graphics.DrawString(p_ViewText, m_ValueFont, Brushes.Black, 0, _StarY); } //12345678 //(105 + (1 * 12 + 2 * 34 + 3 * 56 + 4 *78)) % 103 = 47 //结果为starc +12 +34 +56 +78 +47 +end }
  • 评论:0 / 阅读:702
  • 技术文摘不用写一句sql的ORM框架,支持多种数据库
  • 2021/4/12 11:59:22
  • ...27.0.0.1;database=ormcms;uid=root;pwd=abc123123;oldsyntax=true;charset=utf8;Allow Zero Datetime=True;port=3306;" />    2、定义一个类文件(这个文件可以自己用代码生成器生成,后面会开放下载)//------------------------------------------------------------------------------ // // 此代码由工具生成: // 生成时间:2021/3/17 // 创建人:XuKai // using System; using Xk.ORM; namespace CMS.Models { /// /// *实体类:ktcfriendlink /// [Table("ktcfriendlink")] [Serializable] public partial class Ktcfriendlink : Entity { #region Model private int _Id; /// /// 主键id /// [Field("id")] public int Id { get { return _Id; } set { this.OnPropertyValueChange("id"); this._Id = value; } } private string _Title; /// /// 友链标题 /// [Field("title")] public string Title { get { return _Title; } set { this.OnPropertyValueChange("title"); this._Title = value; } } private string _Desc; /// /// 描述 /// [Field("desc")] public string Desc { get { return _Desc; } set { this.OnPropertyValueChange("desc"); this._Desc = value; } } private string _Url; /// /// 友链地址 /// [Field("url")] public string Url { get { return _Url; } set { this.OnPropertyValueChange("url"); this._Url = value; } } private int _Status; /// /// 1 通过,2 不通过,0 未审核 /// [Field("status")] public int Status { get { return _Status; } set { this.OnPropertyValueChange("status"); this._Status = value; } } private DateTime _Createtime; /// /// 创建时间 /// [Field("createtime")] public DateTime Createtime { get { return _Createtime; } set { this.OnPropertyValueChange("createtime"); this._Createtime = value; } } private DateTime _Authtime; /// /// 审核时间 /// [Field("authtime")] public DateTime Authtime { get { return _Authtime; } set { this.OnPropertyValueChange("authtime"); this._Authtime = value; } } private string _Askdesc; /// /// 申请描述 /// [Field("askdesc")] public string Askdesc { get { return _Askdesc; } set { this.OnPropertyValueChange("askdesc"); this._Askdesc = value; } } private string _Imgurl; /// /// 友链图片封面 /// [Field("imgurl")] public string Imgurl { get { return _Imgurl; } set { this.OnPropertyValueChange("imgurl"); this._Imgurl = value; } } private int _Index; /// /// 排序 /// [Field("index")] public int Index { get { return _Index; } set { this.OnPropertyValueChange("index"); this._Index = value; } } private int _Isimg; /// /// 是否为图片链接,1 是,0 否(文本) /// [Field("isimg")] public int Isimg { get { return _Isimg; } set { this.OnPropertyValueChange("isimg"); this._Isimg = value; } } private string _Email; /// /// 对方的站点url /// [Field("email")] public string Email { get { return _Email; } set { this.OnPropertyValueChange("email"); this._Email = value; } } #endregion #region Method /// /// 获取实体中的主键列 /// public override Field[] GetPrimaryKeyFields() { return new Field[] { _.Id, }; } /// /// 获取列信息 /// public override Field[] GetFields() { return new Field[] { _.Id, _.Title, _.Desc, _.Url, _.Status, _.Createtime, _.Authtime, _.Askdesc, _.Imgurl, _.Index, _.Isimg, _.Email }; } /// /// 获取值信息 /// public override object[] GetValues() { return new object[] { this._Id, this._Title, this._Desc, this._Url, this._Status, this._Createtime, this._Authtime, this._Askdesc, this._Imgurl, this._Index, this._Isimg, this._Email }; } #endregion #region _Field /// /// 字段信息 /// public class _ { /// /// * /// public readonly static Field All = new Field("*", "ktcfriendlink"); /// /// 主键id /// public readonly static Field Id = new Field("id", "ktcfriendlink"); /// /// 友链标题 /// public readonly static Field Title = new Field("title", "ktcfriendlink"); /// /// 描述 /// public readonly static Field Desc = new Field("desc", "ktcfriendlink"); /// /// 友链地址 /// public readonly static Field Url = new Field("url", "ktcfriendlink"); /// /// 1 通过,2 不通过,0 未审核 /// public readonly static Field Status = new Field("status", "ktcfriendlink"); /// /// 创建时间 /// public readonly static Field Createtime = new Field("createtime", "ktcfriendlink"); /// /// 审核时间 /// public readonly static Field Authtime = new Field("authtime", "ktcfriendlink"); /// /// 申请描述 /// public readonly static Field Askdesc = new Field("askdesc", "ktcfriendlink"); /// /// 友链图片封面 /// public readonly static Field Imgurl = new Field("imgurl", "ktcfriendlink"); /// /// 排序 /// public readonly static Field Index = new Field("index", "ktcfriendlink"); /// /// 是否为图片链接,1 是,0 否(文本) /// public readonly static Field Isimg = new Field("isimg", "ktcfriendlink"); /// /// 对方的联系邮箱 /// public readonly static Field Email = new Field("email", "ktcfriendlink"); } #endregion } }     3、cuid操作int i = 0; DbHelper.From<Ktcfriendlink>();//查询表所有数据 DbHelper.From<Ktcfriendlink>().Where(t => t.Id == 1);//条件id为1的数据,参数遵循linq语法。 DbHelper.From<Ktcfriendlink>().Where(new WhereClip("id = 1"));//条件id为1的数据,WhereClip参数也有很多种写法。 Ktcfriendlink model = new Ktcfriendlink(); model.Title = "baidu"; model.Url = "www.baidu.com"; i = DbHelper.Insert(model);//插入一条数据 i = DbHelper.Delete(a => a.Id == 1);//删除id为1的数据 model.Title = "taobao"; i = DbHelper.Update(model); DbHelper.FromProc("procname");//可以执行存储过程 DbTrans trans = DbHelper.BeginTransaction();//执行事务 try { trans.Update(Ktcfriendlink._.Title, "google", a => a.Id == 1); trans.Update(Ktcfriendlink._.Title, "yahoo", a => a.Id == 2); trans.Commit();//提交事务 } catch { trans.Rollback();//回滚事务 } finally { trans.Close(); } Ktcfriendlink model = new Ktcfriendlink(); model.Title = "baidu"; model.Url = "www.baidu.com"; i = DbHelper.Insert(model);//插入一条数据 i = DbHelper.Delete(a => a.Id == 1);//删除id为1的数据 model.Title = "taobao"; i = DbHelper.Update(model); DbHelper.FromProc("procname");//可以执行存储过程 DbTrans trans = DbHelper.BeginTransaction();//执行事务 try { trans.Update(Ktcfriendlink._.Title, "google", a => a.Id == 1); trans.Update(Ktcfriendlink._.Title, "yahoo", a => a.Id == 2); trans.Commit();//提交事务 } catch { trans.Rollback();//回滚事务 } finally { trans.Close(); } DbHelper.From().Where(new WhereClip("id = 1"));//条件id为1的数据,WhereClip参数也有很多种写法。 Ktcfriendlink model = new Ktcfriendlink(); model.Title = "baidu"; model.Url = "www.baidu.com"; i = DbHelper.Insert(model);//插入一条数据 i = DbHelper.Delete(a => a.Id == 1);//删除id为1的数据 model.Title = "taobao"; i = DbHelper.Update(model); DbHelper.FromProc("procname");//可以执行存储过程 DbTrans trans = DbHelper.BeginTransaction();//执行事务 try { trans.Update(Ktcfriendlink._.Title, "google", a => a.Id == 1); trans.Update(Ktcfriendlink._.Title, "yahoo", a => a.Id == 2); trans.Commit();//提交事务 } catch { trans.Rollback();//回滚事务 } finally { trans.Close(); } DbHelper.From().Where(t => t.Id == 1);//条件id为1的数据,参数遵循linq语法。 DbHelper.From().Where(new WhereClip("id = 1"));//条件id为1的数据,WhereClip参数也有很多种写法。 Ktcfriendlink model = new Ktcfriendlink(); model.Title = "baidu"; model.Url = "www.baidu.com"; i = DbHelper.Insert(model);//插入一条数据 i = DbHelper.Delete(a => a.Id == 1);//删除id为1的数据 model.Title = "taobao"; i = DbHelper.Update(model); DbHelper.FromProc("procname");//可以执行存储过程 DbTrans trans = DbHelper.BeginTransaction();//执行事务 try { trans.Update(Ktcfriendlink._.Title, "google", a => a.Id == 1); trans.Update(Ktcfriendlink._.Title, "yahoo", a => a.Id == 2); trans.Commit();//提交事务 } catch { trans.Rollback();//回滚事务 } finally { trans.Close(); }框架后期整理好后开放下载,欢迎广大.net ORM爱好者使用
  • 评论:1 / 阅读:1353
  • 技术文摘123
  • 2021/5/24 16:10:46
  • 评论:0 / 阅读:469
1