关于我们

质量为本、客户为根、勇于拼搏、务实创新

< 返回新闻公共列表

任意cms系统导入数据到NetWingCMS系统的方法

发布时间:2019-11-19 16:18:40

任意cms系统导入数据到NetWingCMS系统代码如下:

<%@ WebHandler Language="C#" Class="DTcms.Web.dev.intobase" %>

using System;

using System.Collections.Generic;

using System.Web;

using System.Text;

using System.Web.UI;

using System.Web.UI.WebControls;

using DTcms.Common;

using DTcms.DBUtility;

using NetWing.Common.Data.SQLServer;

using NetWing.Common.Request;

using DTcms.API.Payment.Alipay;

using System.Diagnostics;

namespace DTcms.Web.dev

{

    /// <summary> 

    /// 用户绑定类

    /// </summary> 

    //alipay1 这个类可以自定义 必须和上面保持一致

    public class intobase : IHttpHandler

    {

        public void ProcessRequest(HttpContext context)

        {

            string cateid = "110";//netwing cms栏目id

            string oldcateid = "1,2";//数据源栏目id

            DateTime stime = DateTime.Now;

            //业务逻辑放在这里

            //得到最大id

            int maxid = (int)SqlEasy.ExecuteScalar("select top 1 article_id from dt_article_attribute_value order by article_id desc  ");

            //插入数据库

            StringBuilder sb = new StringBuilder();

            sb.Append("INSERT INTO dt_article ");

            sb.Append(" (channel_id,category_id,title,content,click,add_time,update_time,img_url,zhaiyao,user_name,seo_title,seo_keywords) ");

            sb.Append(" select 3, " + cateid + ", proname, procontent, 300, proinputdate,proinputdate,(select top 1 filename from Ynpb_attachments where tid=proid) ,ProDescribe,'admin',proname,proname from Ynpb_Product ");

            sb.Append(" where ProCategoryID = '" + oldcateid + "'");

            SqlEasy.ExecuteNonQuery(sb.ToString());

            context.Response.Write(sb.ToString());

            //在dt_article_attribute_value 里写入值

            SqlEasy.ExecuteNonQuery("insert into dt_article_attribute_value(article_id) select id from dt_article where id >" + maxid + "");

            //记录日志            

            Stopwatch sw = new Stopwatch();

            sw.Start();

            DateTime etime = DateTime.Now;

            sw.Stop();

            //修正封面图路径

            //SqlEasy.ExecuteNonQuery("update dt_article set img_url='/upload/'+replace(img_url,'\','/')");

            //SqlEasy.ExecuteNonQuery("update dt_article set img_url=replace(img_url,'\','/')");

            //一共导入多少条

            //int max = 0;

            int max = (int)SqlEasy.ExecuteScalar("select count(*) from Ynpb_Product where ProCategoryID = '" + oldcateid + "'");

            context.Response.Write("开始时间:" + stime + "结束时间:" + etime + "耗时:" + sw.Elapsed + " 共导入" + max + "条\r\n");

            //业务逻辑放在这里

        }

        public bool IsReusable

        {

            get

            {

                return false;

            }

        }

    }

}



/template/Home/Zkeys/PC/Static