Web网站开发项目案例

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Text;

public partial class UserSynchro : System.Web.UI.Page
{

    public string Action;
    public string SysType_Source DbType_Source AcFile_Source SqlServer_Source SqlDbName_Source SqlUser_Source SqlPass_Source;
    public string SysType_Remote DbType_Remote AcFile_Remote SqlServer_Remote SqlDbName_Remote SqlUser_Remote SqlPass_Remote;
    public bool NeedOverwrite NeedBatch;
    public int TotalRecord SkipRecord OverwriteRecord SuccessRecord FailedRecord BatchNum;
    public string ConnStr;
    public string ServerMsg SQL_Source;
    public IDbConnection  Conn_SourceConn_Remote;
    public IDbDataAdapter DataAdapter_Source DataAdapter_Remote;
    public string source_table remote_table PE_table remote_c source_c;

    /// 

    /// 程序入口
    /// 

    /// 
    /// 
    protected void Page_Load（object sender EventArgs e）
    {

        Action = base.Request[“action“];
        switch （Action）
        {
            case “TestConn“:  //测试链接
                TestConn（）;
                break;
            case “start“:   //开始
                Main（）;
                break;
        }

       
    }


    /// 

    /// 测试链接
    /// 

    public void TestConn（）
    {
        string TestType;
        TestType = Request.Form[“testtype“];
        if （TestType == “source“）
        {
            GetSourceInfo（）;
            TestSource（）;
            CleanConns（）;
            ServerMsg = “{0}源数据库连接测试成功。“;
            WriteMsg（）;
        }
        else
        {
            GetRemoteInfo（）;
            TestRemote（）;
            CleanConns（）;
            ServerMsg = “{0}目标数据库连接测试成功。“;
            WriteMsg（）;
        }

    }

    /// 

    /// 同步主函数
    /// 

    public void Main（）
    {
        GetSourceInfo（）;
        GetRemoteInfo（）;
        GetOptionInfo（）;
        InitHTML（）;
        CheckParam（）;
        TestSource（）;
        IDbCommand cmd = Conn_Source.CreateCommand（）;
        cmd.CommandText = GetSqlString（）;
        DataSet ds = new DataSet（）;
        DataAdapter_Source.SelectCommand = cmd;
        DataAdapter_Source.Fill（ds）;
        if （ds.Tables[0].Rows.Count>0）
        {
            TotalRecord = ds.Tables[0].Rows.Count-1;
        }
        else
        {
            ServerMsg = “源数据库中没有记录，不需要同步！“;
            WriteMsg（）;
        }
        SuccessRecord = Convert.ToInt32（Request.Form[“SucNum“]）;
        SkipRecord = Convert.ToInt32（Request.Form[“SkipNum“]）;
        OverwriteRecord = Convert.ToIn

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        132  2012-02-22 10:02  BizIdea.Standard_4.6.0.0_201202221-环境配置指南.url

     文件        132  2012-02-22 10:02  BizIdea.Standard_4.6.0.0_201202222-详细安装说明.url

     文件        132  2012-02-22 10:02  BizIdea.Standard_4.6.0.0_201202223-安装疑难解答.url

     文件        132  2012-02-22 10:02  BizIdea.Standard_4.6.0.0_201202224-用户帮助手册.url

     文件        127  2012-02-22 10:02  BizIdea.Standard_4.6.0.0_201202225-视频录像教程.url

    .......      8271  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesAuthor.aspx

    .......      3275  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesAuthorGuide.aspx

    .......       596  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesAuthorList.aspx

    .......      4868  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesAuthorManage.aspx

    .......      5623  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesBank.aspx

    .......       768  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesBankGuide.aspx

    .......      4911  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesBankManage.aspx

    .......      3378  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesCacheManage.aspx

    .......      1076  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesCacheManageGuide.aspx

    .......      1365  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesCacheShow.aspx

    .......      9221  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesCompareFilesOnline.aspx

    .......       874  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesCompareFilesOnlineGuide.aspx

    .......      2178  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownloadErrorGuide.aspx

    .......      4250  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownloadErrorManage.aspx

    .......      3703  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownServer.aspx

    .......      1364  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownServerGuide.aspx

    .......      6236  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownServerList.aspx

    .......      4778  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownServerManage.aspx

    .......      2239  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesDownServerOrder.aspx

    .......     18281  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesFileManage.aspx

    .......       172  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesFileServerAttestationServer.ashx

    .......       684  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesFilesGuide.aspx

    .......      3531  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesFileUpload.aspx

    .......       164  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesFileUploadRecordService.ashx

    .......      3300  2012-02-22 10:01  BizIdea.Standard_4.6.0.0_20120222WebSiteAdminAccessoriesFloatingFileUpload.aspx

............此处省略3810个文件信息