ackf44856-优快云博客

转载 select 中的逻辑判断 sql server

SELECT CASE field0010 WHEN '计划' THEN 1 ELSE 2 END AS s FROM formmain_5991 SELECT CASE WHEN (IFNULL(o.ENDTIME,99))=99 THEN (CASE WHEN (CURDATE()-pc.FORECASTTIME)...

2019-05-07 15:02:00 790

转载 AutoCAD中添加块和块参照

1 using System; 2 3 using Autodesk.AutoCAD.DatabaseServices; 4 using Autodesk.AutoCAD.Geometry; 5 using Autodesk.AutoCAD.Runtime; 6 7 [assembly: CommandClass(typeof(Sample.AddBlo...

2019-01-22 15:54:00 1743

转载 sql update语句

1 UPDATE table_name 2 SET column1=value1,column2=value2,... 3 WHERE some_column=some_value; 1 UPDATE Websites 2 SET alexa='5000', country='USA' 3 WHERE name='菜鸟教程'; 转载于:https:/...

2019-01-02 10:39:00 196

转载 sql server 多表查询

SELECT formmain_5991.field0001 AS 项目名称, formmain_5991.field0002 AS 项目编号, formmain_5991.field0003 AS 计划开始, ISNULL(formmain_5991.field0004, ISNULL(formmain_0478.field0...

2018-12-28 09:10:00 178

转载 cad 中字符串转OBJECTID

public static ObjectId StringToObjectId(string strId) { long intId = Convert.ToInt64(strId);//这里的strId是一个纯数字字符串，将其转换成64的long类型，32的会报错 IntPtr init = new IntPtr...

2018-12-10 18:22:00 667

转载 CAD 开发过滤器，选择集

1 PromptSelectionOptions selectionOpZDH = new PromptSelectionOptions(); 2 selectionOpZDH.MessageForAdding = "请选择展点号和高程点："; 3 4 //根据过滤器来选 5...

2018-12-10 13:40:00 825

转载 cad 创建自定义菜单

[assembly: CommandClass(typeof(clist.Main))] //[assembly:ExtensionApplication(typeof(clist.Main))] namespace clist { public class Main { public string qm; publi...

2018-12-04 17:35:00 871

转载根据EXCEL模板生成EXCEL ,指定单元格值

using Autodesk.AutoCAD.ApplicationServices; using Autodesk.AutoCAD.DatabaseServices; using Autodesk.AutoCAD.EditorInput; using System; using System.Collections.Generic; using System.Compon...

2018-12-04 17:28:00 256

转载 C# 强制类型转换

C#整数三种强制类型转换int、Convert.ToInt32（）、int.Parse()的区别Convert.ToInt32(double value) 如果 value 为浮点型，采用四舍五入; int(4.6) = 4，int转化其他数值类型为int时没有四舍五入，强制转换(截取整数部分); int.TryParse()其实是对int.Parse()做了一个异常处理，如果出现异...

2018-11-29 10:14:00 315

转载 C# 操作Excel大全(转载)

1 /引用Microsoft.Office.Interop.Excel.dll文件 2 //添加using 3 using Microsoft.Office.Interop.Excel; 4 using Excel=Microsoft.Office.Interop.Excel; 5 6 //设置程序运行语言 7 System.Glob...

2018-11-02 18:09:00 225

ackf44856的博客