摘要：
1、通过DataSetConvertToByStr实现XML转成DataSet
2、通过 关键字做逐条数据比对
原文链接：
http://www.lookdaima.com/page/docItemDetail.html?id=de9330c8-0bc9-46a4-b29e-681bd45d9ab7
界面效果：
相关代码：
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"
Inherits="WebForms_WebPages_Blanks_WebTools_Dbs_DataCompares_Default"
ValidateRequest="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script language="javascript" type="text/javascript" src="<%=strPhyPath %>/JS/jquery-1.8.3.min.js"></script>
<script language="javascript" type="text/javascript" src="<%=strPhyPath %>/JS/CreateCode.js"></script>
<script language="javascript" type="text/javascript" src="<%=strPhyPath %>/JS/DateOper.js"></script>
<style type="text/css">
.slxdemo-oneline
{
-moz-border-bottom-colors: none;
-moz-border-left-colors: none;
-moz-border-right-colors: none;
-moz-border-top-colors: none;
border-collapse: collapse;
border-color: #ccc;
border-image: none;
border-style: solid;
border-width: 1px 0 0 1px;
margin-top: 0px;
}
.slxdemo-oneline th, .slxdemo-oneline td
{
-moz-border-bottom-colors: none;
-moz-border-left-colors: none;
-moz-border-right-colors: none;
-moz-border-top-colors: none;
border-color: #ccc;
border-image: none;
border-style: solid;
border-width: 0 1px 1px 0;
padding: 6px;
size: 14px;
}
a.DefaultHref
{
color: #0000FF;
text-decoration: none;
}
a.DefaultHref:link
{
color: #0000FF;
text-decoration: none;
}
a.DefaultHref:hover
{
color: #0000FF;
text-decoration: underline;
}
a.DefaultHref:visited
{
color: #0000FF;
text-decoration: none;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table border="0" cellpadding="0" cellspacing="5" width="100%">
<tr>
<td colspan="1">
</td>
<td colspan="1">
<b>通过数据表的DataSet输出XML做数据比对</b> | <a href="Default.aspx" class="DefaultHref">刷新</a>
</td>
</tr>
<tr>
<td align="right" valign="top">
执行结果：
</td>
<td colspan="3">
<asp:Label ID="lbl_ResultTip" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td align="right" style="width: 100px;">
源数据：
</td>
<td colspan="1">
<asp:TextBox ID="txt_Source" runat="server" Width="99%" Height="130px" TextMode="MultiLine"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right" style="width: 100px;">
目标数据：
</td>
<td colspan="1">
<asp:TextBox ID="txt_Target" runat="server" Width="99%" Height="130px" TextMode="MultiLine"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right" style="width: 100px;">
关键字：
</td>
<td colspan="1">
<asp:TextBox ID="txt_PkName" runat="server" Width="99%"></asp:TextBox>
<br />
(组合关键字用|做分隔)
</td>
</tr>
<tr>
<td align="right" style="width: 100px;">
比较字段：
</td>
<td colspan="1">
<asp:TextBox ID="txt_DcName" runat="server" Width="99%" Height="100px" TextMode="MultiLine"></asp:TextBox>
<br />
(组合关键字用|做分隔)
</td>
</tr>
<tr>
<td align="right" style="width: 100px; height: 35px;">
</td>
<td colspan="1">
<asp:Button ID="btn_SourceDcName" runat="server" Text="源字段清单" OnClick="btn_SourceDcName_Click" />
<asp:Button ID="btn_SourceData" runat="server" Text="源数据" OnClick="btn_SourceData_Click" />
<asp:Button ID="btn_SourceRowCount" runat="server" Text="源记录数" OnClick="btn_SourceRowCount_Click" />
<asp:Button ID="btn_TargetDcName" runat="server" Text="目标字段清单" OnClick="btn_TargetDcName_Click" />
<asp:Button ID="btn_TargetData" runat="server" Text="目标数据" OnClick="btn_TargetData_Click" />
<asp:Button ID="btn_TargetRowCount" runat="server" Text="目标记录数" OnClick="btn_TargetRowCount_Click" />
<asp:Button ID="btn_Example" runat="server" Text="样例" OnClick="btn_Example_Click" />
| <a href="Default.aspx" class="DefaultHref">刷新</a>
</td>
</tr>
<tr>
<td align="right" style="width: 100px; height: 35px;">
</td>
<td colspan="1">
<asp:Button ID="btn_SourceMore" runat="server" Text="源多的数据" OnClick="btn_SourceMore_Click" />
<asp:Button ID="btn_TargetMore" runat="server" Text="目标多的数据" OnClick="btn_TargetMore_Click" />
<asp:Button ID="btn_EqualData" runat="server" Text="相同的数据" OnClick="btn_EqualData_Click" />
<asp:Button ID="btn_NoEqualData" runat="server" Text="不相同的数据" OnClick="btn_NoEqualData_Click" />
<asp:Button ID="btn_DcCompare" runat="server" Text="字段是否相同" OnClick="btn_DcCompare_Click" />
</td>
</tr>
<tr>
<td align="right" valign="top">
输出：
</td>
<td colspan="3">
<asp:Literal ID="lt_Result" runat="server"></asp:Literal>
<asp:TextBox ID="txt_Result" Visible="false" runat="server" Width="99%" Height="130px"
TextMode="MultiLine"></asp:TextBox>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.IO;
public partial class WebForms_WebPages_Blanks_WebTools_Dbs_DataCompares_Default
:
PageBase
{
#region 样例数据
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Example_Click(object sender, EventArgs e)
{
txt_PkName.Text = "Guid";
txt_Source.Text = @"
<NewDataSet>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>60cafcf3deb7458e90247bfc18aa846b</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T15:03:46.3125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T15:03:46.3125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T15:03:46+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>数量测试2</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>47a734fb88a14abd8ca0d82896d7d2f1</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T15:16:22.703125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T15:16:22.703125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T15:16:22+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>下次下发任务，是否情况此处内容？</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>1c109716f32140b88bec1e2e4622bcad</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T15:44:56.015625+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T15:44:56.015625+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T15:44:56+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>121212</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>9a6e271b22f94953bfc0cb55997ec477</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T15:03:31.921875+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T15:03:31.921875+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T15:03:31+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>数量测试1</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>a5b5763c85704fa2ab824c2a39649c6f</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T11:30:37.02593+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T11:30:37.02593+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T11:30:37+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>啊啊啊啊啊</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>e4899af22ac44fe8bec6085223fe218d</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T09:34:56.500608+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T09:34:56.500608+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T09:34:56+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>qqqqqqqqqq</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>f964b564b37b4e6f9cf70fa65802a0bc</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T09:37:35.601659+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T09:37:35.601659+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T09:37:35+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>zzzzzzzzzzzzz</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>5a2563ee706945168ae7837a931321f6</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-01T16:36:43.569723+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-01T16:36:43.569723+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-01T16:36:43+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>202020</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>e0dc6581344447e4b36e4d9d11f0134c</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T14:57:01.6875+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T14:57:01.6875+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T14:57:01+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSSJ</JOB_GROUP>
<JOB>LSSJ</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>撤销看APP情况</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>5913ee4a0f404e09bd39054233a906a4</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T14:19:04.453125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T14:19:04.453125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T14:19:04+08:00</ARCHIVE_DATE>
<JOB_GROUP>TBDRW</JOB_GROUP>
<JOB>TBDRW</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>1111111111</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>d8621396e58c4c9fbf3d1db5db0708a9</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T09:34:09.736506+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T09:34:09.736506+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T09:34:09+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>eeeeeee</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>0dd8b3e4521a41b19477f5af64dd0033</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T09:49:41.596452+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T09:49:41.596452+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T09:49:41+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>6666</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>73d9bc57540241a783028463de591e64</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T10:01:01.899396+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T10:01:01.899396+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T10:01:01+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>0010313</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>44ebd4cda4ae45e7ba0f945578c0fa4c</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-01T15:02:32.507773+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-01T15:02:32.507773+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-01T15:02:32+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>001</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>d8e40354480e42f3bb3c3a1bdd557d62</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T09:33:05.902947+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T09:33:05.902947+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T09:33:05+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>qqqqqqqqqqqqqq</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>f1ef5340e8254aeaaf0d236680ea8fd6</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-01T16:18:24.286178+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-01T16:18:24.286178+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-01T16:18:24+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>16161616</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
</NewDataSet>
";
txt_Target.Text = @"
<NewDataSet>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>07af40d4960a4b7baf93bd6f9443f883</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T14:57:30.125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T14:57:30.125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T14:57:30+08:00</ARCHIVE_DATE>
<JOB_GROUP>TBDRW</JOB_GROUP>
<JOB>TBDRW</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>随便来点</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>60cafcf3deb7458e90247bfc18aa846b</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T15:03:46.3125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T15:03:46.3125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T15:03:46+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>数量测试2</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>47a734fb88a14abd8ca0d82896d7d2f1</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T15:16:22.703125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T15:16:22.703125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T15:16:22+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>下次下发任务，是否情况此处内容？</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>1c109716f32140b88bec1e2e4622bcad</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T15:44:56.015625+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T15:44:56.015625+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T15:44:56+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>121212</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>9a6e271b22f94953bfc0cb55997ec477</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T15:03:31.921875+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T15:03:31.921875+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T15:03:31+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>数量测试1</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>a5b5763c85704fa2ab824c2a39649c6f</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T11:30:37.02593+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T11:30:37.02593+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T11:30:37+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>啊啊啊啊啊</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>e4899af22ac44fe8bec6085223fe218d</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T09:34:56.500608+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T09:34:56.500608+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T09:34:56+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>qqqqqqqqqq</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>f964b564b37b4e6f9cf70fa65802a0bc</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T09:37:35.601659+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T09:37:35.601659+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T09:37:35+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>zzzzzzzzzzzzz</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>5a2563ee706945168ae7837a931321f6</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-01T16:36:43.569723+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-01T16:36:43.569723+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-01T16:36:43+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>202020</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>e0dc6581344447e4b36e4d9d11f0134c</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T14:57:01.6875+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T14:57:01.6875+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T14:57:01+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSSJ</JOB_GROUP>
<JOB>LSSJ</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>撤销看APP情况</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>5913ee4a0f404e09bd39054233a906a4</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T14:19:04.453125+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T14:19:04.453125+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T14:19:04+08:00</ARCHIVE_DATE>
<JOB_GROUP>TBDRW</JOB_GROUP>
<JOB>TBDRW</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>1111111111</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>d8621396e58c4c9fbf3d1db5db0708a9</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T09:34:09.736506+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T09:34:09.736506+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T09:34:09+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>eeeeeee</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>0dd8b3e4521a41b19477f5af64dd0033</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-04T09:49:41.596452+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-04T09:49:41.596452+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-04T09:49:41+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>6666</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>3e67f689e14e4539bdb3a46dde12814c</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-06T14:18:01.21875+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-06T14:18:01.21875+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-06T14:18:01+08:00</ARCHIVE_DATE>
<JOB_GROUP>TBDRW</JOB_GROUP>
<JOB>TBDRW</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>1417</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>73d9bc57540241a783028463de591e64</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T10:01:01.899396+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T10:01:01.899396+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T10:01:01+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LLLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>0010313</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>45ebd4cda4ae45e7ba0f945578c0fa4c</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-01T15:02:32.507773+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-01T15:02:32.507773+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-01T15:02:32+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>001</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
<BS_NOFLIGHTJOB_ALLOCATION>
<GUID>d8e40354480e42f3bb3c3a1bdd557d62</GUID>
<INSERT_OPERATOR>A070388</INSERT_OPERATOR>
<INSERT_TIME>2019-03-05T09:33:05.902947+08:00</INSERT_TIME>
<UPDATE_TIME>2019-03-05T09:33:05.902947+08:00</UPDATE_TIME>
<VALIDITY>1</VALIDITY>
<ARCHIVE_DATE>2019-03-05T09:33:05+08:00</ARCHIVE_DATE>
<JOB_GROUP>LSLJC</JOB_GROUP>
<JOB>LSLJC</JOB>
<STATUS>Allocation</STATUS>
<INITIATIVE>0</INITIATIVE>
<REQUIREMENT>qqqqqqqqqqqqqq</REQUIREMENT>
<OVERDUE>0</OVERDUE>
<ACCEPT_THRESHOLD>10</ACCEPT_THRESHOLD>
</BS_NOFLIGHTJOB_ALLOCATION>
</NewDataSet>
";
}
#endregion 样例数据
#region DataSetConvertToByStr|通过XML(字符串形式)转成DataSet
/// <summary>
/// 通过XML(字符串形式)转成DataSet
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
private DataSet DataSetConvertToByStr(string str)
{
DataSet ds = new DataSet();
using (StringReader xmlSR = new StringReader(str))
{
ds.ReadXml(xmlSR, XmlReadMode.InferTypedSchema); //忽视任何内联架构，从数据推断出强类型架构并加载数据。如果无法推断，则解释成字符串数据
if (ds.Tables.Count > 0)
return ds;
else
return null;
}
}
#endregion DataSetConvertToByStr|通过XML(字符串形式)转成DataSet
/// <summary>
///
/// </summary>
/// <param name="strMsg"></param>
/// <param name="succFlag"></param>
protected void SetResultTip(string strMsg, bool succFlag)
{
if (succFlag)
{
lbl_ResultTip.ForeColor = System.Drawing.Color.Blue;
}
else
{
lbl_ResultTip.ForeColor = System.Drawing.Color.Red;
}
lbl_ResultTip.Text = strMsg + " " + DateTime.Now.ToString("HH:mm:ss");
}
#region 保存
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Ok_Click(object sender, EventArgs e)
{
try
{
// btnOkClick();
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
#endregion 保存
/// <summary>
///
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
protected bool ListDcName(string str)
{
if (str == null || str.Length == 0 || str.Trim().Length == 0)
{
SetResultTip("请输入数据", false);
return false;
}
DataSet ds = DataSetConvertToByStr(str.Trim());
if (ds == null || ds.Tables.Count ==0)
{
SetResultTip("数据不正确", false);
return false;
}
DataTable dt = ds.Tables[0];
StringBuilder theResult = new StringBuilder();
foreach (DataColumn dc in dt.Columns)
{
theResult.AppendLine(dc.ColumnName);
}
txt_Result.Visible = true;
txt_Result.Text = theResult.ToString();
SetResultTip("成功", true);
return true;
}
/// <summary>
///
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
protected bool DataRowCount(string str)
{
if (str == null || str.Length == 0 || str.Trim().Length == 0)
{
SetResultTip("请输入数据", false);
return false;
}
DataSet ds = DataSetConvertToByStr(str.Trim());
if (ds == null || ds.Tables.Count == 0)
{
SetResultTip("数据不正确", false);
return false;
}
DataTable dt = ds.Tables[0];
lt_Result.Text = dt.Rows.Count.ToString();
SetResultTip("成功", true);
return true;
}
#region 源字段清单
/// <summary>
/// 源字段清单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_SourceDcName_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
string str = txt_Source.Text.Trim();
if (str.Length == 0)
{
SetResultTip("请输入源数据", false);
return;
}
ListDcName(str);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
#endregion 源字段清单
#region 目标字段清单
/// <summary>
/// 目标字段清单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_TargetDcName_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
string str = txt_Target.Text.Trim();
if (str.Length == 0)
{
SetResultTip("请输入目标数据", false);
return;
}
ListDcName(str);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
#endregion 目标字段清单
#region 源记录数
/// <summary>
/// 源记录数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_SourceRowCount_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
string str = txt_Source.Text.Trim();
if (str.Length == 0)
{
SetResultTip("请输入源数据", false);
return;
}
DataRowCount(str);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
#endregion 源记录数
#region 目标记录数
/// <summary>
/// 目标记录数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_TargetRowCount_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
string str = txt_Target.Text.Trim();
if (str.Length == 0)
{
SetResultTip("请输入目标数据", false);
return;
}
DataRowCount(str);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
#endregion 目标记录数
#region DataSetToHtmlTable:DataSet转成HTML的Table输出
private const string P__SQLROWNUMBERVALUE = "P__SQLROWNUMBERVALUE";
/// <summary>
/// DataSet转成HTML的Table输出 - DataSetToHtmlTable +
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public string DataSetToHtmlTable(System.Data.DataSet ds)
{
return DataSetToHtmlTable(ds, -98, true, null);
}
/// <summary>
/// DataSet转成HTML的Table输出 - DataSetToHtmlTable +
/// </summary>
/// <param name="ds"></param>
/// <param name="showDcNameList">显示的字段列表</param>
/// <returns></returns>
public string DataSetToHtmlTable(System.Data.DataSet ds, List<string> showDcNameList)
{
return DataSetToHtmlTable(ds, -98, true, showDcNameList);
}
/// <summary>
/// DataSet转成HTML的Table输出 - DataSetToHtmlTable +
/// </summary>
/// <param name="ds"></param>
/// <param name="needConvertHtml">是否需要转移Html内容</param>
/// <returns></returns>
public string DataSetToHtmlTable(System.Data.DataSet ds, bool needConvertHtml)
{
return DataSetToHtmlTable(ds, -98, needConvertHtml, null);
}
/// <summary>
/// DataSet转成HTML的Table输出 - DataSetToHtmlTable +
/// </summary>
/// <param name="ds"></param>
/// <param name="widthValue">表格宽度|如:-98=98%;120=120px</param>
/// <param name="needConvertHtml">是否需要转移Html内容</param>
/// <param name="showDcNameList">显示的字段列表</param>
/// <returns></returns>
public string DataSetToHtmlTable(System.Data.DataSet ds, int widthValue, bool needConvertHtml,List<string> showDcNameList)
{
if (ds == null || ds.Tables.Count == 0)
{
throw new Exception
(
"方法："
+ System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.FullName
+ " "
+ System.Reflection.MethodBase.GetCurrentMethod().ToString()
+ " 发生异常："
+ "传入参数：DataSet ds为null。"
);
}
string widthStyle = "";
if (widthValue > 0)
{
widthStyle = " width:" + widthValue.ToString() + "px;";
}
else if (widthValue < 0)
{
widthStyle = " width:" + (-widthValue).ToString() + "%;";
}
System.Data.DataTable dt = ds.Tables[0];
StringBuilder theResult = new StringBuilder();
theResult.Append(@"<table style=""background-color: #CDCDCD; font-family: 仿宋;" + widthStyle + @""" align=""center"" border=""0"" cellpadding=""1"" cellspacing=""1"">");
int rowIndex = 0;
bool noAllDcFlag = false;
if (showDcNameList != null && showDcNameList.Count > 0)
{
noAllDcFlag = true;
}
string strTmp = null;
string columnName = null;
object oValue = null;
DateTime dtValue = DateTime.MinValue;
if (needConvertHtml)
{
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 18px; font-weight: bold; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; text-align: center;"" align=""center"" height=""30px"">");
theResult.Append("序号");
theResult.Append("</td>");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
strTmp = columnName;
strTmp = strTmp.Replace("<", "<").Replace(">", ">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 18px; font-weight: bold; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; text-align: center;"" align=""center"" height=""30px"">");
theResult.Append(strTmp);
theResult.Append("</td>");
}
theResult.Append("</tr>");
foreach (System.Data.DataRow dr in dt.Rows)
{
++rowIndex;
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(rowIndex.ToString());
theResult.Append("</td>");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
oValue = dr[dc.ColumnName];
if (oValue == null || oValue == DBNull.Value)
{
strTmp = "";
}
else
{
if (oValue is DateTime)
{
dtValue = (DateTime)oValue;
if (dtValue.Date == dtValue)
{
strTmp = dtValue.ToString("yyyy-MM-dd");
}
else
{
strTmp = dtValue.ToString("yyyy-MM-dd HH:mm:ss");
}
}
else
{
strTmp = oValue.ToString();
}
}
strTmp = strTmp.Replace("<", "<").Replace(">", ">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(strTmp);
theResult.Append("</td>");
}
theResult.Append("</tr>");
}
}
else
{
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 18px; font-weight: bold; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; text-align: center;"" align=""center"" height=""30px"">");
theResult.Append("序号");
theResult.Append("</td>");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 18px; font-weight: bold; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; text-align: center;"" align=""center"" height=""30px"">");
theResult.Append(dc.ColumnName);
theResult.Append("</td>");
}
theResult.Append("</tr>");
foreach (System.Data.DataRow dr in dt.Rows)
{
++rowIndex;
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(rowIndex.ToString());
theResult.Append("</td>");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
oValue = dr[dc.ColumnName];
if (oValue == null || oValue == DBNull.Value)
{
strTmp = "";
}
else
{
if (oValue is DateTime)
{
dtValue = (DateTime)oValue;
if (dtValue.Date == dtValue)
{
strTmp = dtValue.ToString("yyyy-MM-dd");
}
else
{
strTmp = dtValue.ToString("yyyy-MM-dd HH:mm:ss");
}
}
else
{
strTmp = oValue.ToString();
}
}
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(strTmp);
theResult.Append("</td>");
}
theResult.Append("</tr>");
}
}
theResult.Append("</table>");
return theResult.ToString();
}
#endregion DataSetToHtmlTable:DataSet转成HTML的Table输出
#region StrToListStr:多行字符串转成List-string的值输出
/// <summary>
/// 多行字符串转成List-string的值输出
/// </summary>
/// <param name="str">字符串</param>
/// <param name="toLowerFlag">是否转小写</param>
/// <returns></returns>
public List<string> StrToListStr(string str,bool toLowerFlag)
{
List<string> theResult = new List<string>();
if (str == null)
return theResult;
str = str.Trim();
if (str.Length == 0)
return theResult;
string[] sA = str.Split('\n');
string strTmp = null;
foreach (string s in sA)
{
if (s == null)
continue;
strTmp = s.Trim();
if (strTmp.Length == 0)
continue;
if (toLowerFlag)
strTmp = strTmp.ToLower();
if (theResult.Contains(strTmp))
continue;
theResult.Add(strTmp);
}
return theResult;
}
#endregion StrToListStr:多行字符串转成List-string的值输出
/// <summary>
/// DataSet转成HTML的Table输出 - DataSetToHtmlTable +
/// </summary>
/// <param name="ds"></param>
/// <param name="widthValue">表格宽度|如:-98=98%;120=120px</param>
/// <param name="needConvertHtml">是否需要转移Html内容</param>
/// <param name="showDcNameList">显示的字段列表</param>
/// <returns></returns>
public string DataSetToHtmlTableForNoEqual
(
System.Data.DataSet ds,
int widthValue,
List<string> showDcNameList
)
{
if (ds == null || ds.Tables.Count == 0)
{
throw new Exception
(
"方法："
+ System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.FullName
+ " "
+ System.Reflection.MethodBase.GetCurrentMethod().ToString()
+ " 发生异常："
+ "传入参数：DataSet ds为null。"
);
}
string widthStyle = "";
if (widthValue > 0)
{
widthStyle = " width:" + widthValue.ToString() + "px;";
}
else if (widthValue < 0)
{
widthStyle = " width:" + (-widthValue).ToString() + "%;";
}
System.Data.DataTable dt = ds.Tables[0];
int rowCount = dt.Rows.Count;
if (rowCount % 2 == 1)
{
return "数据错误，数据应该是2的倍数";
}
StringBuilder theResult = new StringBuilder();
theResult.Append(@"<table style=""background-color: #CDCDCD; font-family: 仿宋;" + widthStyle + @""" align=""center"" border=""0"" cellpadding=""1"" cellspacing=""1"">");
int rowIndex = 0;
bool noAllDcFlag = false;
if (showDcNameList != null && showDcNameList.Count > 0)
{
noAllDcFlag = true;
}
string strTmp = null;
string columnName = null;
object oValue = null;
DateTime dtValue = DateTime.MinValue;
DataRow drOne = null;
DataRow drTwo = null;
bool compareFlag = false;
int rowSpan = 1;
bool needConvertHtml = true;
if (needConvertHtml)
{
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 18px; font-weight: bold; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; text-align: center;"" align=""center"" height=""30px"">");
theResult.Append("序号");
theResult.Append("</td>");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
strTmp = columnName;
strTmp = strTmp.Replace("<", "<").Replace(">", ">");
theResult.Append(@"<td style=""background-color: #FFFFFF; font-size: 18px; font-weight: bold; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; text-align: center;"" align=""center"" height=""30px"">");
theResult.Append(strTmp);
theResult.Append("</td>");
}
theResult.Append("</tr>");
for(int i = 0; i <rowCount;i=i+2)
{
drOne = dt.Rows[i];
drTwo = dt.Rows[i + 1];
++rowIndex;
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
theResult.Append(@"<td rowspan=""2"" style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(rowIndex.ToString());
theResult.Append("</td>");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
compareFlag = ObjCompare(drOne[columnName], drTwo[columnName]);
if (compareFlag)
{
rowSpan = 2;
}
else
{
rowSpan = 1;
}
oValue = drOne[columnName];
if (oValue == null || oValue == DBNull.Value)
{
strTmp = "";
}
else
{
if (oValue is DateTime)
{
dtValue = (DateTime)oValue;
if (dtValue.Date == dtValue)
{
strTmp = dtValue.ToString("yyyy-MM-dd");
}
else
{
strTmp = dtValue.ToString("yyyy-MM-dd HH:mm:ss");
}
}
else
{
strTmp = oValue.ToString();
}
}
strTmp = strTmp.Replace("<", "<").Replace(">", ">");
theResult.Append(@"<td rowspan=""" + rowSpan.ToString() + @""" style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(strTmp);
theResult.Append("</td>");
}
theResult.Append("</tr>");
theResult.Append(@"<tr style=""background-color: #FFFFFF;"">");
foreach (System.Data.DataColumn dc in dt.Columns)
{
columnName = dc.ColumnName;
if (columnName.Trim().ToUpper() == P__SQLROWNUMBERVALUE)
{
continue;
}
if (noAllDcFlag)
{
if (!showDcNameList.Contains(columnName.ToLower()))
continue;
}
compareFlag = ObjCompare(drOne[columnName], drTwo[columnName]);
if (compareFlag)
{
continue;
}
rowSpan = 1;
oValue = drTwo[columnName];
if (oValue == null || oValue == DBNull.Value)
{
strTmp = "";
}
else
{
if (oValue is DateTime)
{
dtValue = (DateTime)oValue;
if (dtValue.Date == dtValue)
{
strTmp = dtValue.ToString("yyyy-MM-dd");
}
else
{
strTmp = dtValue.ToString("yyyy-MM-dd HH:mm:ss");
}
}
else
{
strTmp = oValue.ToString();
}
}
strTmp = strTmp.Replace("<", "<").Replace(">", ">");
theResult.Append(@"<td rowspan=""" + rowSpan.ToString() + @""" style=""background-color: #FFFFFF; font-size: 14px; font-family: 宋体; line-height: 20pt; vertical-align: middle; line-height: 20pt; padding-left: 5px;"" align=""center"" height=""30px"">");
theResult.Append(strTmp);
theResult.Append("</td>");
}
theResult.Append("</tr>");
}
}
theResult.Append("</table>");
return theResult.ToString();
}
/// <summary>
///
/// </summary>
/// <param name="str"></param>
/// <returns></returns>
protected bool ShowHtmlData(string str)
{
if (str == null || str.Length == 0 || str.Trim().Length == 0)
{
SetResultTip("请输入数据", false);
return false;
}
DataSet ds = DataSetConvertToByStr(str.Trim());
if (ds == null || ds.Tables.Count == 0)
{
SetResultTip("数据不正确", false);
return false;
}
string dcName = txt_DcName.Text.Trim();
List<string> showDcNameList = null;
if (dcName.Length > 0)
{
showDcNameList = StrToListStr(dcName, true);
}
string strHtml = DataSetToHtmlTable(ds, showDcNameList);
lt_Result.Text = strHtml;
SetResultTip("成功", true);
return true;
}
protected void btn_TargetData_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
string str = txt_Target.Text.Trim();
if (str.Length == 0)
{
SetResultTip("请输入目标数据", false);
return;
}
ShowHtmlData(str);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_SourceData_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
string str = txt_Source.Text.Trim();
if (str.Length == 0)
{
SetResultTip("请输入源数据", false);
return;
}
ShowHtmlData(str);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
public enum EmOper
{
/// <summary>
/// 源多的数据
/// </summary>
源多的数据 = 1,
/// <summary>
/// 目标多的数据
/// </summary>
目标多的数据,
/// <summary>
/// 相同的数据
/// </summary>
相同的数据,
/// <summary>
/// 不相同的数据
/// </summary>
不相同的数据,
/// <summary>
/// 字段比较
/// </summary>
字段比较
}
/// <summary>
///
/// </summary>
/// <param name="sourceFlag"></param>
/// <param name="dt"></param>
/// <param name="sA"></param>
/// <returns></returns>
public bool DataTableContainColumns(bool sourceFlag,DataTable dt,List<string> sA)
{
if (sA == null)
return true;
string strTmp = null;
foreach (string s in sA)
{
if (s == null || s.Length == 0)
continue;
strTmp = s.Trim();
if(strTmp.Length ==0)
continue;
if (!dt.Columns.Contains(strTmp))
{
if (sourceFlag)
{
SetResultTip("源不包含" + strTmp + "字段", false);
}
else
{
SetResultTip("目标不包含" + strTmp + "字段", false);
}
return false;
}
}
return true;
}
/// <summary>
///
/// </summary>
/// <param name="sA"></param>
/// <returns></returns>
public List<string> StrArrayToStrList(string[] sA)
{
List<string> theResult = new List<string>();
if (sA == null || sA.Length == 0)
return theResult;
string strTmp = null;
foreach (string s in sA)
{
if (s == null)
continue;
strTmp = s.Trim();
if (theResult.Contains(strTmp))
continue;
theResult.Add(strTmp);
}
return theResult;
}
/// <summary>
/// 不考虑多对一的情况
/// </summary>
/// <param name="drData"></param>
/// <param name="dt"></param>
/// <param name="pkList"></param>
/// <returns></returns>
protected DataRow DataRowFind(DataRow drData, DataTable dt, List<string> pkList)
{
bool findFlag = false;
bool compareFlag = false;
foreach (DataRow dr in dt.Rows)
{
findFlag = true;
foreach (string pk in pkList)
{
compareFlag = ObjCompare(dr[pk], drData[pk]);
if(!compareFlag)
{
findFlag = false;
break;
}
}
if (findFlag)
{
return dr;
}
}
return null;
}
/// <summary>
///
/// </summary>
/// <param name="objOne"></param>
/// <param name="objTwo"></param>
/// <returns></returns>
protected bool ObjCompare(object objOne, object objTwo)
{
bool oneIsEmpty = false;
bool twoIsEmpty = false;
if (objOne == null || objOne == DBNull.Value || objOne.ToString().Length == 0)
{
oneIsEmpty = true;
}
if (objTwo == null || objTwo == DBNull.Value || objTwo.ToString().Length == 0)
{
twoIsEmpty = true;
}
if (oneIsEmpty)
{
if (twoIsEmpty)
return true;
else
return false;
}
if (twoIsEmpty)
{
if (oneIsEmpty)
return true;
else
return false;
}
string strOne = objOne.ToString();
string strTwo = objTwo.ToString();
if (strOne == strTwo)
return true;
return false;
}
/// <summary>
///
/// </summary>
/// <param name="drOne"></param>
/// <param name="drTwo"></param>
/// <param name="dcList"></param>
/// <returns></returns>
protected bool DataRowCompare(DataRow drOne, DataRow drTwo, List<string> dcList)
{
bool noAllDcList = false;
if (dcList != null && dcList.Count > 0)
{
noAllDcList = true;
}
bool compareFlag = false;
string dcName = null;
DataTable dtOne = drOne.Table;
DataTable dtTwo = drTwo.Table;
if (noAllDcList)
{
foreach (string s in dcList)
{
dcName = s;
if (dcName == null || dcName.Length == 0)
continue;
dcName = dcName.Trim();
if (dcName.Length == 0)
continue;
if (!dtOne.Columns.Contains(dcName))
return false;
if (!dtTwo.Columns.Contains(dcName))
return false;
compareFlag = ObjCompare(drOne[dcName], drTwo[dcName]);
if (!compareFlag)
return false;
}
}
else
{
foreach (DataColumn dc in dtOne.Columns)
{
dcName = dc.ColumnName;
if (!dtTwo.Columns.Contains(dcName))
return false;
compareFlag = ObjCompare(drOne[dcName], drTwo[dcName]);
if (!compareFlag)
return false;
}
}
return true;
}
/// <summary>
///
/// </summary>
/// <param name="em"></param>
/// <returns></returns>
public bool DataCompareOper(EmOper em)
{
string strSource = txt_Source.Text.Trim();
if (strSource.Length == 0)
{
SetResultTip("请输入源数据", false);
return false;
}
string strTarget = txt_Target.Text.Trim();
if (strTarget.Length == 0)
{
SetResultTip("请输入目标数据", false);
return false;
}
string pkName = txt_PkName.Text.Trim();
if (pkName.Length == 0)
{
SetResultTip("请输入比较关键字", false);
return false;
}
string[] pkA = pkName.Split('|');
List<string> pkList = StrArrayToStrList(pkA);
string dcName = txt_DcName.Text.Trim();
List<string> dcList = null;
if (dcName.Length > 0)
{
dcList = StrToListStr(dcName, false);
}
DataSet dsSource = DataSetConvertToByStr(strSource);
DataSet dsTarget = DataSetConvertToByStr(strTarget);
if (dsSource == null || dsSource.Tables.Count == 0 || dsSource.Tables[0].Rows.Count == 0)
{
SetResultTip("源数据为空", false);
return false;
}
if (dsTarget == null || dsTarget.Tables.Count == 0 || dsTarget.Tables[0].Rows.Count == 0)
{
SetResultTip("目标数据为空", false);
return false;
}
DataTable dtSource = dsSource.Tables[0];
DataTable dtTarget = dsTarget.Tables[0];
bool resultFlag = DataTableContainColumns(true, dtSource, pkList);
if (!resultFlag)
return false;
resultFlag = DataTableContainColumns(false, dtTarget, pkList);
if (!resultFlag)
return false;
resultFlag = DataTableContainColumns(true, dtSource, dcList);
if (!resultFlag)
return false;
resultFlag = DataTableContainColumns(false, dtTarget, dcList);
if (!resultFlag)
return false;
DataSet dsResult = new DataSet();
DataTable dtResult = null;
DataRow drFind = null;
bool compareFlag = false;
switch (em)
{
case EmOper.源多的数据:
dtResult = dtSource.Clone();
foreach (DataRow drS in dtSource.Rows)
{
drFind = DataRowFind(drS, dtTarget, pkList);
if (drFind == null)
{
dtResult.ImportRow(drS);
}
}
if (dtResult.Rows.Count == 0)
{
lt_Result.Text = "没有记录";
return true;
}
dsResult.Tables.Add(dtResult);
lt_Result.Text = DataSetToHtmlTable(dsResult, dcList);
SetResultTip(em.ToString() + "操作成功", true);
return true;
case EmOper.目标多的数据:
dtResult = dtTarget.Clone();
foreach (DataRow drS in dtTarget.Rows)
{
drFind = DataRowFind(drS, dtSource, pkList);
if (drFind == null)
{
dtResult.ImportRow(drS);
}
}
if (dtResult.Rows.Count == 0)
{
lt_Result.Text = "没有记录";
return true;
}
dsResult.Tables.Add(dtResult);
lt_Result.Text = DataSetToHtmlTable(dsResult, dcList);
SetResultTip(em.ToString() + "操作成功", true);
return true;
case EmOper.相同的数据:
dtResult = dtSource.Clone();
foreach (DataRow drS in dtSource.Rows)
{
drFind = DataRowFind(drS, dtTarget, pkList);
if (drFind == null)
{
continue;
}
compareFlag = DataRowCompare(drFind, drS, dcList);
if (compareFlag)
{
dtResult.ImportRow(drS);
}
}
if (dtResult.Rows.Count == 0)
{
lt_Result.Text = "没有记录";
return true;
}
dsResult.Tables.Add(dtResult);
lt_Result.Text = DataSetToHtmlTable(dsResult, dcList);
SetResultTip(em.ToString() + "操作成功", true);
return true;
case EmOper.不相同的数据:
dtResult = dtSource.Clone();
foreach (DataRow drS in dtSource.Rows)
{
drFind = DataRowFind(drS, dtTarget, pkList);
if (drFind == null)
{
continue;
}
compareFlag = DataRowCompare(drFind, drS, dcList);
if (!compareFlag)
{
dtResult.ImportRow(drS);
dtResult.ImportRow(drFind);
}
}
if (dtResult.Rows.Count == 0)
{
lt_Result.Text = "没有记录";
return true;
}
dsResult.Tables.Add(dtResult);
lt_Result.Text =
DataSetToHtmlTableForNoEqual(dsResult, -99, dcList);
SetResultTip(em.ToString() + "操作成功", true);
return true;
case EmOper.字段比较:
StringBuilder sourceMoreSb = new StringBuilder();
StringBuilder targetMoreSb = new StringBuilder();
foreach (DataColumn dc in dtSource.Columns)
{
if (!dtTarget.Columns.Contains(dc.ColumnName))
{
sourceMoreSb.AppendLine(dc.ColumnName);
}
}
foreach (DataColumn dc in dtTarget.Columns)
{
if (!dtSource.Columns.Contains(dc.ColumnName))
{
targetMoreSb.AppendLine(dc.ColumnName);
}
}
StringBuilder compareResultSb = new StringBuilder();
string strCompareTmp = sourceMoreSb.ToString();
if (strCompareTmp.Length > 0)
{
compareResultSb.AppendLine("源多的字段：");
compareResultSb.AppendLine(strCompareTmp);
}
strCompareTmp = targetMoreSb.ToString();
if (strCompareTmp.Length > 0)
{
compareResultSb.AppendLine("目标多的字段：");
compareResultSb.AppendLine(strCompareTmp);
}
strCompareTmp = compareResultSb.ToString();
if (strCompareTmp.Length > 0)
{
txt_Result.Visible = true;
txt_Result.Text = strCompareTmp;
}
else
{
lt_Result.Text = em.ToString()+"相同";
}
SetResultTip(em.ToString() + "操作成功", true);
return true;
default:
SetResultTip(em.ToString() + "未实现", false);
return false;
}
}
/// <summary>
/// 不相同的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_NoEqualData_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
DataCompareOper(EmOper.不相同的数据);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
/// <summary>
/// 源多的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_SourceMore_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
DataCompareOper(EmOper.源多的数据);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
/// <summary>
/// 相同的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_EqualData_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
DataCompareOper(EmOper.相同的数据);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
/// <summary>
/// 目标多的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_TargetMore_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
DataCompareOper(EmOper.目标多的数据);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
/// <summary>
/// 字段是否相同
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_DcCompare_Click(object sender, EventArgs e)
{
try
{
lt_Result.Text = "";
txt_Result.Visible = false;
DataCompareOper(EmOper.字段比较);
}
catch (Exception err)
{
SetResultTip(err.Message, false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
}
}
扫一扫
851
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
