yonghuairuogu-CSDN博客

原创 Sqlite数据更新update

（1）单表内字段更新update PipeLine set state='0' where Address='33'（2）两个表间单字段关联更新 sql = "update Videos set ID =(select ID from TMPLINETotal where Videos.Lno=TMPLINETotal.Lno ) ";（3）多字段更新 sql = "update ResultRecord ...

2021-02-01 15:16:46 5177

转载 FreeSql （十五）查询数据

FreeSql （十五）查询数据 FreeSql在查询数据下足了功能，链式查询语法、多表查询、表达式函数支持得非常到位。static IFreeSql fsql = new FreeSql.FreeSqlBuilder() .UseConnectionString(FreeSql.DataType.MySql, "Data Source=127.0...

2020-06-19 16:09:25 2661 1

原创 C# cad 加载自定义的cuix

void AddCuix() { try { object oldCmdEcho = Application.GetSystemVariable("CMDECHO"); object oldFileDia = Application.GetSystemVariable("FILEDIA"); string cuifile = System....

2020-06-18 17:12:47 1770

原创 c# cad 批量将dwg转换为dxf

private void btn_dwg2dxf_Click(object sender, EventArgs e) { Autodesk.AutoCAD.Interop.AcadApplication acadApp = (Autodesk.AutoCAD.Interop.AcadApplication)Autodesk.AutoCAD.ApplicationServices.Application.AcadAppl...

2020-06-11 14:20:08 2147

原创 C# net autocad批量打印（图纸设置，打印比例设置）

private void btn_outpdf_Click(object sender, EventArgs e) { AcadDocument doc = null; string destPath = string.Empty; foreach (var file in fileslist) { doc = _app.Documents.Open(file,...

2020-06-11 14:15:33 5082 1

原创 access 数据更新update

（1）单表内字段更新update PipeLine set state='0' where Address='33'（2）两个表间关联更新在Access数据库中，UPDATE指令不能够含有From语句。因此在多表关联批量更新数据时操作不是那么方便。update table1 as t1,table2 as t2 set t1.name=t2.namewhere t1.id=t...

2020-01-16 13:52:46 9387