<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ArcherSYM的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ArcherSYM</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ArcherSYM]]></copyright><item><title><![CDATA[winfrom中创建webapi]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/148055926</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/148055926</guid><author>ArcherSYM</author><pubDate>Mon, 19 May 2025 09:35:46 +0800</pubDate><description><![CDATA[C#.NET WebApi返回各种类型(图片/json数据/字符串)，.net图片转二进制流或byte - 冰封的心 - 博客园]]></description><category></category></item><item><title><![CDATA[C#中去除实体中null值的属性]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/140058009</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/140058009</guid><author>ArcherSYM</author><pubDate>Sat, 29 Jun 2024 08:20:43 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[dotNET China / MiniWord-调整表格插入]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/130622796</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/130622796</guid><author>ArcherSYM</author><pubDate>Thu, 11 May 2023 15:17:35 +0800</pubDate><description><![CDATA[更改哪一行，实现表格内容插入到标签行后面，保留末尾行。]]></description><category></category></item><item><title><![CDATA[Aspose操作表格]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/129812298</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/129812298</guid><author>ArcherSYM</author><pubDate>Tue, 28 Mar 2023 11:19:01 +0800</pubDate><description><![CDATA[【代码】Aspose操作表格。]]></description><category></category></item><item><title><![CDATA[.net:使用EF时，decimal类型的小数位数问题处理]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/129381904</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/129381904</guid><author>ArcherSYM</author><pubDate>Tue, 07 Mar 2023 14:27:07 +0800</pubDate><description><![CDATA[EF框架decimal保留两位问题]]></description><category></category></item><item><title><![CDATA[SQLServer，查询数据库表指定属性列]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/127295988</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/127295988</guid><author>ArcherSYM</author><pubDate>Thu, 13 Oct 2022 10:14:19 +0800</pubDate><description><![CDATA[SQLServer]]></description><category></category></item><item><title><![CDATA[java中list的查询过滤使用]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/123126381</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/123126381</guid><author>ArcherSYM</author><pubDate>Fri, 25 Feb 2022 10:00:31 +0800</pubDate><description><![CDATA[//查询code值出现的次数
Map&lt;Object, Long&gt; collect= list.stream().collect(Collectors.groupingBy(Entity::getCode,Collectors.counting()));

//过滤查出大于1的code值
List&lt;Object&gt; collect2=collect.keySet().stream().filter(key-&gt;collect.get(key)&gt;1).collect(Colle.]]></description><category></category></item><item><title><![CDATA[正则校验收藏]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/121607095</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/121607095</guid><author>ArcherSYM</author><pubDate>Mon, 29 Nov 2021 12:45:21 +0800</pubDate><description><![CDATA[校验0~100，且保留两位小数
			^((\d|[1-9]\d)(?:\.\d{1,2})?|100)$
		
			
		
			
		
]]></description><category></category></item><item><title><![CDATA[C#中List去重]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/120757841</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/120757841</guid><author>ArcherSYM</author><pubDate>Thu, 14 Oct 2021 09:49:45 +0800</pubDate><description><![CDATA[var departmentidList = List.Where((x, i) =&gt; bMS_Project_ProjectPeopleList.FindIndex(z =&gt; z.F_PeopleDepartment == x.F_PeopleDepartment) == i).Select(t =&gt; t.F_PeopleDepartment).ToList();



var departmentidList2 = List.GroupBy(d =&gt; d.F_PeopleD...]]></description><category></category></item><item><title><![CDATA[System.Linq的使用]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/112728891</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/112728891</guid><author>ArcherSYM</author><pubDate>Sun, 17 Jan 2021 10:04:23 +0800</pubDate><description><![CDATA[var sourceIds = bMS_Base_PurbillvouchsList?.Select(t =&gt; t.F_ChildOrderId)?.ToList() ?? new List&lt;string&gt;();
        var children = db.FindList&lt;BMS_Base_PurbillvouchsEntity&gt;(t =&gt; sourceIds.Contains(t.F_ChildOrderId));
       ...]]></description><category></category></item><item><title><![CDATA[人民币大写转换]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108344089</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108344089</guid><author>ArcherSYM</author><pubDate>Tue, 01 Sep 2020 15:51:15 +0800</pubDate><description><![CDATA[//人民币大写
    private static string Num2Char(string var)
    {
      string retval = "";
      bool IsPoint = false;
      double v = double.Parse(var);
      if (v &gt; 0)
      {
        char[] chars = v.ToStr...]]></description><category></category></item><item><title><![CDATA[记录一次sql中，查询三表管理，最后一张表是否存在记录]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108279897</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108279897</guid><author>ArcherSYM</author><pubDate>Fri, 28 Aug 2020 15:01:51 +0800</pubDate><description><![CDATA[SELECT
        t.F_ID,
        t.F_DocumentNo,
        t.F_GenerationDate,
        t.F_GenerationMan,
        t.F_InquiryDepartment,
        t.F_ClosingDate,
        t.F_ModeOfDelivery,
      ...]]></description><category></category></item><item><title><![CDATA[数组去重，使用HashSET]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108253521</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108253521</guid><author>ArcherSYM</author><pubDate>Thu, 27 Aug 2020 09:51:55 +0800</pubDate><description><![CDATA[HashSet&lt;string&gt; Material_listIds = new HashSet&lt;string&gt;();
          foreach (var item in Material_list)
          {
            //去重获取领料母表ID
            Material_listIds.Add(item.F_Id);
      ...]]></description><category></category></item><item><title><![CDATA[C#图片存储数据库]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108192873</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108192873</guid><author>ArcherSYM</author><pubDate>Mon, 24 Aug 2020 09:14:35 +0800</pubDate><description><![CDATA[前端js


function uploadImg1() {
        var f = document.getElementById('uploadFile1').files[0]
        var src = window.URL.createObjectURL(f);
        document.getElementById('uploadPreview1').src = src;


        learun.loading(true, '正在保存...');
        ]]></description><category></category></item><item><title><![CDATA[编程好习惯]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108126974</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108126974</guid><author>ArcherSYM</author><pubDate>Thu, 20 Aug 2020 16:39:28 +0800</pubDate><description><![CDATA[对于未实现的接口

throw new NotImplementedException("还未实现");
]]></description><category></category></item><item><title><![CDATA[SQL查询中！=的判定注意点]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108126158</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108126158</guid><author>ArcherSYM</author><pubDate>Thu, 20 Aug 2020 16:12:51 +0800</pubDate><description><![CDATA[使用！=查询条件时，如果查询记录为条件NULL，查询结果不会被查询出来

解决：

！= “” 加上 OR is NULL


]]></description><category></category></item><item><title><![CDATA[sql查询，拼接查询结果]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/108017625</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/108017625</guid><author>ArcherSYM</author><pubDate>Sat, 15 Aug 2020 08:52:50 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[sql join的用法]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/107938411</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/107938411</guid><author>ArcherSYM</author><pubDate>Tue, 11 Aug 2020 16:49:19 +0800</pubDate><description><![CDATA[第一种：Inner join

解释：产生的结果是A和B的交集（相同列里面的相同值）。内连接是最常见的一种连接，它也被称为普通连接，只连接匹配的行（仅对满足连接条件的CROSS中的列）。它又分为等值连接（连接条件运算符为"="）和不等值连接（连接条件运算符不为"="，例如between...and）。


SELECT *FROM b INNER JOIN A
on b.name=A.name

第二种：Full Outer Join

解释：产生的结果是A和B的并集（如果没有相同的值会用null作为值）。]]></description><category></category></item><item><title><![CDATA[JS数组排序]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/107830822</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/107830822</guid><author>ArcherSYM</author><pubDate>Thu, 06 Aug 2020 09:00:00 +0800</pubDate><description><![CDATA[varcompany=[{F_count:10},{F_count:12}]

var compare = function (obj1, obj2) {
            var val1 = obj1.F_count;
            var val2 = obj2.F_count;
            if (val1 &lt; val2) {
              retur...]]></description><category></category></item><item><title><![CDATA[设置两个DIV为display:inline-block出现上下错位问题]]></title><link>https://blog.youkuaiyun.com/ArcherSYM/article/details/107784467</link><guid>https://blog.youkuaiyun.com/ArcherSYM/article/details/107784467</guid><author>ArcherSYM</author><pubDate>Tue, 04 Aug 2020 13:30:31 +0800</pubDate><description><![CDATA[原因

1.同一行的行内元素对齐方式默认是底部对齐，即vertical-align：baseline

2.对于内容为空的inline-block元素而言，该元素的基线就是它的margin底边缘，否则就是元素的内部最后一行内联元素的基线

解决

1.float方式（考虑脱离流后后面元素不易控制，故不首选）

2.改变vertical-align属性
...]]></description><category></category></item></channel></rss>