任意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;
}
}
}
}
Copyright © 2004-2024 Ynicp.com 版权所有 法律顾问:建纬(昆明)律师事务所 昆明市网翼通科技有限公司 滇ICP备08002592号-4