<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lovemuchcode的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lovemuchcode</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lovemuchcode]]></copyright><item><title><![CDATA[sql查询]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/75214231</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/75214231</guid><author>lovemuchcode</author><pubDate>Mon, 17 Jul 2017 09:26:23 +0800</pubDate><description><![CDATA[select seri, max(case when insunit='℃' then hvalue end) as tvalue,max(case when insunit='%' then hvalue end) as hvalue from (SELECT substring(insname,1,(CHARINDEX('#',insname)-1)) as seri,insunit,hval]]></description><category></category></item><item><title><![CDATA[SQL查询两列合并一列]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/75214113</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/75214113</guid><author>lovemuchcode</author><pubDate>Mon, 17 Jul 2017 09:10:56 +0800</pubDate><description><![CDATA[使用中为了结果使用的方便，常常需要查询结果两列合并成一列，查询语句如下
select b+c as a from Table where d is not null
说明：a、b、c、d均为列名，Table为表名称，查询条件是列值不能为空]]></description><category></category></item><item><title><![CDATA[SQL 查询的列中截取一部分字符串作为新列]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/75214008</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/75214008</guid><author>lovemuchcode</author><pubDate>Mon, 17 Jul 2017 08:59:35 +0800</pubDate><description><![CDATA[数据库表中原来的列值如下：

SQL语句如下：SELECT substring(Name,1,(CHARINDEX('#',Name)-1)) as Name  from Boat 
结果如下：]]></description><category></category></item><item><title><![CDATA[windows 服务安装程序]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/53169406</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/53169406</guid><author>lovemuchcode</author><pubDate>Tue, 15 Nov 2016 11:17:07 +0800</pubDate><description><![CDATA[新建项目---控制台应用程序 等同于命令：sc create service+ 服务路径+名称 
class Program
    {
        static void Main(string[] args)
        {
            Application.EnableVisualStyles();


            Application.S]]></description><category></category></item><item><title><![CDATA[百度云推送消息到手机]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/53169279</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/53169279</guid><author>lovemuchcode</author><pubDate>Tue, 15 Nov 2016 11:10:30 +0800</pubDate><description><![CDATA[百度云推送消息，参考百度云推送官网，以下是核心代码：private void SendNotificationToAndroid(string message)
        {

            BaiduPush Bpush = new BaiduPush("POST", SecretKey);
          
            String messages = "";]]></description><category></category></item><item><title><![CDATA[sql 多表联合查询并计数]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/53168954</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/53168954</guid><author>lovemuchcode</author><pubDate>Tue, 15 Nov 2016 10:37:45 +0800</pubDate><description><![CDATA[SELECT Organ.OrganName, SOSAlarm.TermName,COUNT(*)as counts
from Organ,Users,SOSAlarm
WHERE Users.UserName=SOSAlarm.TermName and Users.UserOrgan_ID=Organ.ID group by SOSAlarm.TermName,Organ.OrganNam]]></description><category></category></item><item><title><![CDATA[SQL 每隔几条数据取一条]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/53168888</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/53168888</guid><author>lovemuchcode</author><pubDate>Tue, 15 Nov 2016 10:35:11 +0800</pubDate><description><![CDATA[有时候再做SQL查询的时候，如果数据量太大，会取其中的一部分作为代表，以下SQL语句中每隔10条数据取一条，即ID 除以10余1的记录
select s.Lon,s.Lat from (select * from(select row_number() over (order by GPSTime) as rn,* from GPSPositions) t)s 
where rn%10=1 a]]></description><category></category></item><item><title><![CDATA[SQL 查询表格中某字段不同值的最新一条记录]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/53168769</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/53168769</guid><author>lovemuchcode</author><pubDate>Tue, 15 Nov 2016 10:29:29 +0800</pubDate><description><![CDATA[SELECT TermName,Phone,Lon,Lat,GPSTime
  FROM SOSAlarm
  WHERE exists(
  select * from(
  select  SOSAlarm.TermName,MAX(ID) as ID from SOSAlarm group by SOSAlarm.TermName) x
  WHERE SOSAlarm.TermN]]></description><category></category></item><item><title><![CDATA[Android 设置Activity全屏显示，没有TitleBar;自定义TitleBar]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/45480925</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/45480925</guid><author>lovemuchcode</author><pubDate>Mon, 04 May 2015 14:41:43 +0800</pubDate><description><![CDATA[在setContentView(R.layout.main);前加入如下两行代码：
getWindow().setFlags(WindowManager.LayoutParam.FLAG_FULLSCREEN,WindowManager.LayoutParams.FLAG_FULLSCREEN);
requestWindowFeature(Window.FEATURE_NO_TITLE);]]></description><category></category></item><item><title><![CDATA[AE接口使用理解Geodatabase篇（一）]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/8751698</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/8751698</guid><author>lovemuchcode</author><pubDate>Wed, 03 Apr 2013 09:45:36 +0800</pubDate><description><![CDATA[Geodatabase类型：
1.personal：ACCESS数据库，2G数据
2.file：作用于1相同，不需要一栏ACCESS
3.ArcSDE:基于大型关系数据库，如：SQL SERVER,Oracle，DB2，是基于关系型数据库基础上的地理数据库服务器。


1）. Dataset:
       A: 用于简单数据集，如table，feature class，geomet]]></description><category></category></item><item><title><![CDATA[AE加标注]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/8736949</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/8736949</guid><author>lovemuchcode</author><pubDate>Fri, 29 Mar 2013 15:40:47 +0800</pubDate><description><![CDATA[//获得系统已安装的字体
public void GetInstalledFont()
{
            InstalledFontCollection MyFont = new InstalledFontCollection();
            FontFamily[] MyFontFamilies = MyFont.Families;
            in]]></description><category></category></item><item><title><![CDATA[AE导出图片并插入到word文档中某一固定位置]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/8736254</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/8736254</guid><author>lovemuchcode</author><pubDate>Fri, 29 Mar 2013 15:00:26 +0800</pubDate><description><![CDATA[按矢量图层中各要素范围批量裁剪图片，并将图像粘贴到word中，将已经存在的图像批量粘贴到已存的word文档中。
void ClipPicToWord()
{
      ILayer pLayer=GetCurrentLayer(); 
      IFeatureLayer=pLayer as IFeatureLayer;
      IFeatureClass pFtClass=pF]]></description><category></category></item><item><title><![CDATA[AE查询 IQueryFilter ISpatialFilter]]></title><link>https://blog.youkuaiyun.com/lovemuchcode/article/details/8726666</link><guid>https://blog.youkuaiyun.com/lovemuchcode/article/details/8726666</guid><author>lovemuchcode</author><pubDate>Wed, 27 Mar 2013 15:38:35 +0800</pubDate><description><![CDATA[IQueryFilter接口主要用于属性查询，WhereClause限定查询条件，后者通过设定空间过滤器的范围（Geometry）和空间关系类型（SpatialRel）限定。


空间关系类型描述：A待查询图形B过滤条件图形SpatialRel属性：例如：esriSpatialRelEnum.esriSpatialRelContains;




 
 


esriSpa]]></description><category></category></item></channel></rss>