<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DataExchange.aspx.cs" Inherits="Rjkbb_Other_DataExchange" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>数据交换工具</title>
<style>
span { width:80px;color:red;display:inline-block;margin:5px 0;
}
input[type=text] {
width:600px; border:none; border-bottom:1px solid blue;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblSource" runat="server" Text="Source"></asp:Label><asp:TextBox ID="txtSource" runat="server"></asp:TextBox>
<br />
<asp:Label ID="lblDest" runat="server" Text="Dest"></asp:Label><asp:TextBox ID="txtDest" runat="server"></asp:TextBox>
<br />
<asp:Label ID="lblTable" runat="server" Text="Table"></asp:Label><asp:TextBox ID="txtTable" runat="server"></asp:TextBox>
<br />
<asp:Button ID="Button1" runat="server" Text="GetFromDb" OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="source --> dest" />
<br />
<br />
<br />
<asp:TextBox ID="txtMsg" TextMode="MultiLine" runat="server" Height="203px" Width="675px"></asp:TextBox>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CpmBigDataImportService;
public partial class Rjkbb_Other_DataExchange : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
txtSource.Text = new SqlConnectConfig().ConfigByDbString(RJKBB.DB.Main.ConnectionString).ConnectString;
}
protected void Button2_Click(object sender, EventArgs e)
{
if (txtSource.Text.Length == 0 || txtDest.Text.Length == 0 || txtTable.Text.Length == 0)
{
txtMsg.Text = "参数错误";
return;
}
try
{
SqlConnectConfig sourceSqc = new SqlConnectConfig(); sourceSqc.ConnectString = txtSource.Text;
SqlConnectConfig destSqc = new SqlConnectConfig(); destSqc.ConnectString = txtDest.Text;
string tableName = txtTable.Text.ToUpper();
destSqc.TableName = tableName;
BigDataToSqlServer b2s = new BigDataToSqlServer(destSqc,
MyCommon.GetDt(string.Format("select * from {0}", tableName), sourceSqc.ConnectString)
, true);
txtMsg.Text = string.Format("导入 {0} 条记录。", b2s.ImportedCount);
}
catch (Exception ex)
{
txtMsg.Text = ex.Message + "<br/>" + ex.StackTrace;
}
}
}