<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[loveheronly的专栏]]></title><description><![CDATA[一个字节一个字节地敲打代码]]></description><link>https://blog.youkuaiyun.com/loveheronly</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; loveheronly]]></copyright><item><title><![CDATA[StiReport报表总结]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/117511796</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/117511796</guid><author>loveheronly</author><pubDate>Thu, 03 Jun 2021 10:11:37 +0800</pubDate><description><![CDATA[1、d


]]></description><category></category></item><item><title><![CDATA[导入Excel数据过慢]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/117082172</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/117082172</guid><author>loveheronly</author><pubDate>Thu, 20 May 2021 16:45:36 +0800</pubDate><description><![CDATA[一、现象：

最近项目遇到导入Excel数据，返回的相应很慢。再服务器上十几条的Excel数据，导入预览返回需要1分钟。这现象不正常吧？

二、分析

将后台读取的Excel数据并且在校验数据加上打印日志。通过分析发现，读取Excel的数据很快的，但是在校验的时候查询某一字段的时候，发现竟然要1-2秒。这不符合常规吧。通过查询该表的数据，发现数据量也不是特别多，该表的数据也才3、5w条。

三、解决

1、最后给该表加上索引，在涉及到校验查询的表都加上了索引。类似 ALTER TABLE `sku` AD.]]></description><category></category></item><item><title><![CDATA[jquery动态添加、删除行]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/116520821</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/116520821</guid><author>loveheronly</author><pubDate>Sat, 08 May 2021 11:09:08 +0800</pubDate><description><![CDATA[1、html的table如下


  &lt;table id="skuTable"&gt;
                                            &lt;thead&gt;
                                                &lt;tr&gt;
                                                    &lt;th width="65%"&gt;  Sku &lt;/th&gt;
]]></description><category></category></item><item><title><![CDATA[iis的Excel的0x80070005解决方案]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/116082242</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/116082242</guid><author>loveheronly</author><pubDate>Sat, 24 Apr 2021 09:58:41 +0800</pubDate><description><![CDATA[导出Excel时遇到hresult: 0x80070005错误，可以通过以下两种方式解决。（前提是服务器已经安装了Excel的应用）

一、第一种方法：可以配置IIS的应用池的





默认是内置账户，内置账户权限不够。有时候程序访问Excel有问题。所以我们需要选择自定义账户或者有权限的administrator账号。



二、第二种方法

1:在"开始"-&gt;"运行"中输入dcomcnfg.exe启动"组件服务" 【如果找不到Microsoft Excel应用程序，可以通过comexp.msc.]]></description><category></category></item><item><title><![CDATA[sql的entity的复杂类型使用]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/103429608</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/103429608</guid><author>loveheronly</author><pubDate>Fri, 06 Dec 2019 21:03:37 +0800</pubDate><description><![CDATA[1、好多个对象有相同的属性，比如物体有长宽高，可以定义一个复杂的属性



2、增加Measurements属性



3、根据Measurements属性映射实际的表字段




]]></description><category></category></item><item><title><![CDATA[mvc 列表编辑传参]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/84472426</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/84472426</guid><author>loveheronly</author><pubDate>Sun, 25 Nov 2018 09:10:07 +0800</pubDate><description><![CDATA[一、列表最后一列有一个编辑的按钮


&amp;lt;button type=&quot;button&quot; class=&quot;btn btn-xs btn-default&quot; data-dialog=&quot;/Role/Edit/{{:id}}?actionType=edit&quot; data-title=&quot;&quot; data-width=&quot;1000&quot; data-id=&quot;edit-role-data-dialog&quot; data]]></description><category></category></item><item><title><![CDATA[ajax 提交list]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/83964127</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/83964127</guid><author>loveheronly</author><pubDate>Sun, 11 Nov 2018 23:27:41 +0800</pubDate><description><![CDATA[一、简单的ajax提交


$(function () {

    $('form').validate({
        rules: {
            cnName: {
                required: true,
                maxlength: 80
            }
        },
        messages: ...]]></description><category></category></item><item><title><![CDATA[mvc 引用js]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/83833471</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/83833471</guid><author>loveheronly</author><pubDate>Wed, 07 Nov 2018 22:45:53 +0800</pubDate><description><![CDATA[在页面最下面使用如下语句引入

@section scripts{
    @Scripts.Render(&quot;~/Content/javascripts/test.js&quot;)
}

或者

@section Scripts{
    &amp;lt;script&amp;gt;
        function test() {
        }
    &amp;lt;/script&amp;gt;
}...]]></description><category></category></item><item><title><![CDATA[mvc框架的control]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/83795031</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/83795031</guid><author>loveheronly</author><pubDate>Tue, 06 Nov 2018 21:55:47 +0800</pubDate><description><![CDATA[1.view视图的代码如下

&amp;lt;button class=&quot;btn blue-madison&quot; data-dialog=&quot;/Test/EditRole/?actionType=add&quot;  data-width=&quot;1000&quot; data-id=&quot;edit-person-role-data-dialog&quot;&amp;gt;
&amp;lt;/button&amp;gt;

2.我们应该找control的类名为TestCon]]></description><category></category></item><item><title><![CDATA[word排版]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/82015647</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/82015647</guid><author>loveheronly</author><pubDate>Fri, 24 Aug 2018 11:56:05 +0800</pubDate><description><![CDATA[1.选择格式后



2.设置标号值位1



3.标号格式改为4.1

]]></description><category></category></item><item><title><![CDATA[窗体之间方法调用_发消息方式(三)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/80427615</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/80427615</guid><author>loveheronly</author><pubDate>Wed, 23 May 2018 22:45:29 +0800</pubDate><description><![CDATA[一、封装一个类发消息 public struct My_lParam
    {
        public int i;
        public string s;

    }
    public class Note
    {

        [DllImport(&quot;User32.dll&quot;, EntryPoint = &quot;SendMessage&quot;)]

        priva...]]></description><category></category></item><item><title><![CDATA[窗体之间方法调用_事件方式(二)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/80427532</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/80427532</guid><author>loveheronly</author><pubDate>Wed, 23 May 2018 22:39:04 +0800</pubDate><description><![CDATA[一、主窗口设计事件  public partial class FormMain : Form
    {
        public string strA;
        public void FunA(string strTest)
        {
            strA = strTest;
        }

        internal void FormMa...]]></description><category></category></item><item><title><![CDATA[窗体之间方法调用(一)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/80427287</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/80427287</guid><author>loveheronly</author><pubDate>Wed, 23 May 2018 22:22:14 +0800</pubDate><description><![CDATA[一、将主窗体放到全局变量里面using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Test
{
    class Global
    {
        public FormMain CurMa...]]></description><category></category></item><item><title><![CDATA[wcf学习 (一)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/80246560</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/80246560</guid><author>loveheronly</author><pubDate>Tue, 08 May 2018 22:08:53 +0800</pubDate><description><![CDATA[1.新建一个WCF服务库，并将项目名称改为“MyWcfService2.重新命名文件名3.发布wcf服务4.将文件MyWcfService.MyService.svc修改为MyWcfService.svc5.部署到iis上即可6.打开URLhttp://localhost:7890/MyWcfService.svc?wsdl...]]></description><category></category></item><item><title><![CDATA[.net mvc 外键表数据读取]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/79491170</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/79491170</guid><author>loveheronly</author><pubDate>Thu, 08 Mar 2018 22:45:57 +0800</pubDate><description><![CDATA[一、需求，在界面上显示a表的数据，某字段需要显示的是b表的数据二、表结构如下a表如下CREATE TABLE `T_Sku` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `SkuId` varchar(64) DEFAULT '',     
  `Code` varchar(64) DEFAULT '',
  `MeasurementsContract...]]></description><category></category></item><item><title><![CDATA[.net 获取实体类的属性]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/72639026</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/72639026</guid><author>loveheronly</author><pubDate>Tue, 23 May 2017 13:48:32 +0800</pubDate><description><![CDATA[protected string Test(T_MODEL model)
        {
            
            //取得m的Type实例
            Type t = model.GetType();

            string strResult = "";

            string strColumn ="ID";

   ]]></description><category></category></item><item><title><![CDATA[.net mvc5 (三)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/71617392</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/71617392</guid><author>loveheronly</author><pubDate>Thu, 11 May 2017 13:05:20 +0800</pubDate><description><![CDATA[现在开始View和Controllers的制作
1.在View文件夹下新建shared文件夹，然后新建 MVC 4布局页


2.新加以下内容




    
    @ViewBag.Title
    
    
    
    
    


    
        
            
                 
                     
 ]]></description><category></category></item><item><title><![CDATA[.net mvc5(二)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/71602605</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/71602605</guid><author>loveheronly</author><pubDate>Thu, 11 May 2017 11:23:32 +0800</pubDate><description><![CDATA[上次创建了基本的框架，现在开始进行Model层的编写
一、新建User类
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;

n]]></description><category></category></item><item><title><![CDATA[.net mvc5 (一)]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/71601600</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/71601600</guid><author>loveheronly</author><pubDate>Thu, 11 May 2017 11:01:40 +0800</pubDate><description><![CDATA[网上看了百度传课的视频(https://chuanke.baidu.com/v2448265-208716-1281505.html),现在将该视频的学习步骤记一下。
一、新建项目，选择web下的Visual Studio 2012 ，之后选择Asp.net MVC 4 Web应用程序


然后点击下一步就完成了


可以看到mvc的框架，有包含Models层、View层、Contr]]></description><category></category></item><item><title><![CDATA[.net 自定义控件事件]]></title><link>https://blog.youkuaiyun.com/loveheronly/article/details/71249339</link><guid>https://blog.youkuaiyun.com/loveheronly/article/details/71249339</guid><author>loveheronly</author><pubDate>Sat, 06 May 2017 11:05:12 +0800</pubDate><description><![CDATA[.net的自定义控件，并且可以定义事件]]></description><category></category></item></channel></rss>