admin_usersynchron.aspx

具有的功能适合于网站的运营和管理

<%@ page language="C#" masterpagefile="AdminIndexMaster.master" autoeventwireup="true" inherits="Admin_UserSynchron, HoWaveIMSV5.0" title="用户数据同步" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:ScriptManager ID="ScriptManager1" runat="server" ></asp:ScriptManager>
<script type="text/javascript">
function SelectDBType(ctlname)
{
 var obj1=document.getElementById(ctlname+"_0");
 var obj2=document.getElementById(ctlname+"_1");
 var obj3=document.getElementById(ctlname+"_2");
 if(obj1.checked||obj3.checked)
 {
   document.getElementById("AccessDB").style.display="none";
   document.getElementById("SqlDB").style.display="";
 }
 else if(obj2.checked)
 {
   document.getElementById("AccessDB").style.display="";
   document.getElementById("SqlDB").style.display="none";
 } 
}
</script>
<script type="text/javascript" src="Js/Function.js"></script>   
<table class="adminheading">
       <tr>
          <th valign="middle" class="cpane" >
              用户数据同步</th>                 
     </tr>
  </table> 
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"  SelectMethod="GetInterfaceNameID" TypeName="InterfaceBLL"/>
   
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
  <fieldset class="FieldSetStlye">
    <asp:Wizard ID="UserSynchroSet" runat="server" ActiveStepIndex="0" Width="100%" StepStyle-VerticalAlign="Top"  SideBarStyle-Width="15%" FinishCompleteButtonText="">
        <WizardSteps>
            <asp:WizardStep runat="server" Title="阅读转换说明" ID="step1">
               <table cellSpacing="1" cellPadding="3"  class="UserSynchronTable" width="100%">
                  <tr bgColor="#185195">
                     <td colSpan="2" height="2"></td></tr>
                     <tr bgColor="#e9effc">
                     <td width="80%"><div align="center">恒浪整合V5.0用户表转移程序</div></td>
                     <td width="20%"><div align="center"><a href="http://bbs.howave.net" target="_blank">官方论坛</a></div></td></tr>
                     <tr align="middle" bgColor="#ffffff">
                     <td colspan="2" align="left">
                     <ol start="1">
                     <li><strong>阅读转移说明</strong></li><li>选择源系统及目的系统 此转换程序为一对多的程序，在转换过程中一定要保证所有系统都有用户数据才能同步！ </li>
                     <li>设置源数据库地址和目的数据库地址</li><li>设置源数据库转移字段和目的数据库转移字段</li><li>执行转换</li><li>成功（错误）提示</li></ol>
                     </td>
                  </tr>
                  <tr align="center" bgColor="#ffffff">
                     <td colspan="2" align="left">
                       <li><strong>　　转移说明</strong></li><OL start="1">
                       <li>此程序主要实现了恒浪数据库用户表与其它系统用户表互相转移的功能</li><li>使用此程序之前必须确认，您所用的恒浪数据库用户表为官方原版,并看清楚转换操作说明</li><li>转换之前请备份好目的数据库，如果转换失败请查看出错提示进行下一步的工作</li><li>此程序并不保证转换100%成功，对于使用此程序后出现的问题，官方不承担一切责任</li></OL>
                     </td>
                  </tr>         
              </table>
              <div style="height:20px;"></div>
              <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource2" AllowPaging="True" width="100%">
                  <Columns>
                      <asp:BoundField DataField="TransferID" HeaderText="ID" HeaderStyle-Height="25px"/>
                      <asp:TemplateField HeaderText="转换名称" HeaderStyle-Height="25px">
                         <ItemTemplate>
                            恒浪V5.0<asp:Label ID="TransferType" runat="server" Text='<%# ((Eval("TransferType").ToString())=="1")?"--->":"<---" %>' /><asp:Label ID="TransferName" runat="server" Text='<%#Eval("InterfaceName") %>' />
                         </ItemTemplate>
                      </asp:TemplateField>
                      <asp:TemplateField HeaderText="操作" HeaderStyle-Height="25px">
                         <ItemTemplate>
                            <asp:Button ID="Modify" runat="server" Text="修改转换设置"  CommandName='<%# Eval("TransferID")+"|Modify" %>' OnCommand="TransferAction"/>
                            <asp:Button ID="Button1" runat="server" Text="修改转换参数"  CommandName='<%# Eval("TransferID")+"|ModifyParam" %>' OnCommand="TransferAction"/>
                            <asp:Button ID="Delete" runat="server" Text="删除" CommandName='<%# Eval("TransferID")+"|Delete" %>' OnCommand="TransferAction" OnClientClick ="return confirm('将删除转换设置和转换字段，确定要删除?');"/>
                            <asp:Button ID="Transfer" runat="server" Text="转换" CommandName='<%# Eval("TransferID")+"|Transfer" %>' OnCommand="TransferAction"/>
                         </ItemTemplate>
                      </asp:TemplateField>
                  </Columns>
              </asp:GridView>
            </asp:WizardStep>
            <asp:WizardStep runat="server" Title="设置数据库" ID="step2">
                      <table cellSpacing="1" cellPadding="3"  class="UserSynchronTable" width="100%">                         
                         <tr>
                            <td>
                               <table border="0" width="100%" bgcolor="white">
                                   <tr bgColor="#e9effc">
                                      <td  align="left" width="50%">选择转换形式</td>
                                      <td>
                                          <asp:RadioButtonList ID="TransferType" runat="server"  RepeatDirection="Horizontal">
                                             <asp:ListItem Text="从恒浪导入该系统" Value="1" Selected="True"/>
                                             <asp:ListItem Text="从该系统导入恒浪" Value="2" />
                                          </asp:RadioButtonList>
                                      </td>
                                   </tr>
                               </table>
                            </td>
                         </tr>                        
                         <tr>
                            <td>
                               <table border="0" width="100%" bgcolor="white">
                                   <tr bgColor="#e9effc">
                                      <td colspan="4" align="center">选择转换系统</td>
                                   </tr>
                                   <tr>
                                      <td align="left" width="20%">转换系统:</td>
                                      <td align="left" width="30%">
                                          <asp:DropDownList ID="InterfaceID" runat="server" DataSourceID="ObjectDataSource1" 
                                            DataTextField="InterfaceName" DataValueField="InterfaceID"  AppendDataBoundItems="True" />                                            
                                      </td>
                                      <td align="left" colspan="2"></td>
                                  </tr>
                               </table>
                            </td>
                         </tr>
                         <tr>                           
                            <td>
                               <table border="0" width="100%" bgcolor="white" >
                                   <tr bgColor="#e9effc">
                                     <td colspan="6" align="center">转换用户数据表设置</td>
                                   </tr> 
                                   <tr>
                                      <td width="50%" align="left">
                                         <table border="0" width="100%">
                                            <tr>
                                               <td width="40%" align="left">转换数据库表名</td>
                                               <td align="left"><asp:TextBox ID="TransferTableName" runat="server" Text="PE_User"/></td>
                                            </tr>
                                         </table>
                                      </td>
                                      <td align="left"><a href="#"  onmouseover="showHelp('help1');" onmouseout="hidenHelp('help1');" ><img src="../IMS_Img/smallIcon/tooltip.png" border="0" /></a></td>
                                   </tr>
                                   <tr>
                                       <td width="50%" align="left">
                                          <table border="0" width="100%">
                                             <tr>
                                                <td width="40%" align="left">表ID字段名</td>
                                                <td align="left"><asp:TextBox ID="Other_UserID" runat="server" Text="userid"/></td>
                                             </tr>
                                          </table>
                                       </td>
                                       <td align="left"><a href="#"  onmouseover="showHelp('help3');" onmouseout="hidenHelp('help3');" ><img src="../IMS_Img/smallIcon/tooltip.png" border="0" /></a> </td>
                                   </tr>
                                   <tr>
                                       <td width="50%" align="left">
                                          <table border="0" width="100%">
                                             <tr>
                                                <td width="40%" align="left">表用户UserName字段名</td>
                                                <td align="left"><asp:TextBox ID="Other_UserName" runat="server" Text="UserName"/></td>
                                             </tr>
                                          </table>
                                       </td>
                                       <td align="left"><a href="#"  onmouseover="showHelp('help2');" onmouseout="hidenHelp('help2');" ><img src="../IMS_Img/smallIcon/tooltip.png" border="0" /></a></td>
                                   </tr>                                        
                               </table>
                            </td>                           
                         </tr>
                         <tr>
                            <td >
                               <table border="0" width="100%" bgcolor="white" >
                                  <tr bgColor="#e9effc">
                                     <td colspan="2" align="center">数据库类型及路径设置</td>
                                   </tr> 
                                   <tr>
                                       <td width="50%" valign="top">
                                           <table border="0" width="100%" >
                                              <tr>
                                                 <td align="left" width="40%">转换系统的数据库类型</td>
                                                 <td align="left">
                                                     <asp:RadioButtonList ID="DBType" runat="server" RepeatDirection="Horizontal">                                                         
                                                          <asp:ListItem Text="MS SQL" Value="SQL"  />
                                                          <asp:ListItem Text="Access" Value="Access"  Selected="True"/>
                                                          <asp:ListItem Text="My Sql" Value="MySql" />
                                                     </asp:RadioButtonList>
                                              </tr>      
                                              <tr id="AccessDB" >
                                                 <td align="left" width="40%">Access数据库相对路径</td>
                                                 <td align="left"><asp:TextBox ID="AccessPath" runat="server" Text="data/data.mdb" Width="90%"/><a href="#"  onmouseover="showHelp('help4');" onmouseout="hidenHelp('help4');" ><img src="../IMS_Img/smallIcon/tooltip.png" border="0" /></a></td>                                     
                                              </tr>
                                              <tr id="SqlDB" style="display:none;">
                                                 <td colspan="2" style="height: 159px">
                                                    <table border="0" width="100%">
                                                       <tr>
                                                          <td align="left" width="40%">数据库服务器</td>
                                                          <td align="left"><asp:TextBox ID="Sql_Source" runat="server" Text="localhost"/><a href="#"  onmouseover="showHelp('help5');" onmouseout="hidenHelp('help5');" ><img src="../IMS_Img/smallIcon/tooltip.png" border="0" /></a></td>
                                                       </tr>
                                                       <tr>
                                                          <td align="left">数据库名</td>
                                                          <td align="left"><asp:TextBox ID="Sql_Name" runat="server" Text="Howave"/></td>