熊仔的部落格

//轉換成功直接輸出，轉換失敗為0
double doubleA=0;   //預先設一個double = 0

//創建一個 DataTable 來存放資料庫
DataTable (datatable1)→變數名稱 = new DataTable();

//last_run_min 程式開始執行 起始時間
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Reset();
sw.Start();
//last_run_min 程式結束 結束時間
sw.Stop();
// 將時間儲存到Timing字串
string Timing = sw.Elapsed.TotalMinutes.ToString("0.00");
//輸出到TextBox1.text 顯示
textBox1.Text = Timing;

堃 
鳯鳳

ㄧ 開始進入畫面
Form1.cs 原本程式碼

//把DataGridView1 轉 DataTable
DataTable dt = (DataTable)DataGridView1.DataSource;

Process Process1 = new Process();
string RarFileName = @"C:\Users\jwwu\Desktop\安裝檔"; //要壓縮成什麼檔案名稱
string CompressSource = @"C:\Users\jwwu\Desktop\安裝檔"; //壓縮來源
Process1.StartInfo.FileName = "WinRAR.exe";
Process1.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;

Process1.StartInfo.Arguments = string.Format("a -ep1 {0} {1}", RarFileName, CompressSource);
Process1.Start();

 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

//加入下列物件
using System.Net;
using mshtml;

namespace WebBrowser_Download
{
public partial class Form1 : Form
{
WebBrowser webUrl = new WebBrowser();
public Form1()
{
InitializeComponent();
this.btnAuto.Click += new EventHandler(btn_Click);
this.btnManual.Click += new EventHandler(btn_Click);
DownloadLink.Text = "www.yahoo.com.tw";
this.listBox1.MouseDoubleClick += new MouseEventHandler(listBox1_MouseDoubleClick);
webUrl.ScriptErrorsSuppressed = true;
}

public void loading()
{
while (!(webUrl.ReadyState == WebBrowserReadyState.Complete))
{
//在網頁讀取的時候可以繼續其他事件
Application.DoEvents();
}
}

public void listBox1_MouseDoubleClick(object sender, MouseEventArgs e)
{
//點選ListBox選項下載檔案
webUrl.Navigate(listBox1.SelectedItem.ToString());
}

public void btn_Click(object sender, EventArgs e)
{
//連結到網站
webUrl.Navigate(DownloadLink.Text);
//等待網頁下載完成
loading();
//使用HTMLDocument語法
HTMLDocument doc = webUrl.Document.Body.Document.DomDocument as HTMLDocument;
//計算檔案次數
int CountA = 0;
WebClient wc = new WebClient();
//暫存Url
string strUrl = "";
//儲存路徑
string receivePath = @"C:\Users\jwwu\Desktop\WebBrowser_Download\DownLoad\";
progressBar1.Minimum = 0;

//自動下載btn
if (sender.Equals(btnAuto))
{
//逐筆抓出有".doc"的網址
foreach (IHTMLElement doclink in doc.links)
{
strUrl = doclink.toString();
//Url文字包含".doc"
if (strUrl.Contains(".doc"))
{
CountA++;
progressBar1.Maximum=CountA;
progressBar1.Value += 1;
wc.DownloadFile(strUrl, receivePath + System.IO.Path.GetFileName(strUrl));
}
}
if (CountA == 0)
{
MessageBox.Show("沒有word檔案可供下載", "下載檔案", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("總共" + CountA + "筆", "下載檔案", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (sender.Equals(btnManual))//手動下載
{
foreach (IHTMLElement doclink in doc.links)
{
strUrl = doclink.toString();

if (strUrl.Contains(".doc"))
{
CountA++;
listBox1.Items.Add(strUrl);
}
}
if (CountA == 0)
{
MessageBox.Show("沒有word檔案可供下載", "下載檔案", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}

// Stream DownLoad 直接下載檔案
using System.Net;
using mshtml;
using System.IO;
using System.Web;

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Threading; //自行宣告

namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
//宣告資料夾對話方塊類別
FolderBrowserDialog Fbd = new FolderBrowserDialog();
public Form1()
{
InitializeComponent();
textPath.Text = @"C:\Users\jwwu\Desktop\委任狀\";
this.btnS.Click += new EventHandler(Btn_Click);
this.btnBr.Click += new EventHandler(Btn_Click);
this.btnE.Click += new EventHandler(Btn_Click);
this.label4.Text = "";
}

public void Btn_Click(object sender, EventArgs e)
{
if (sender.Equals(btnE))
{
this.Close();
}
else if (sender.Equals(btnBr))
{
//初始位置設定
Fbd.RootFolder = Environment.SpecialFolder.Desktop;
//開啟方塊
Fbd.ShowDialog();
//取得選取資料夾路徑
textPath.Text = Fbd.SelectedPath;
}
else if (sender.Equals(btnS))
{
if (!Directory.Exists(textPath.Text))
{
MessageBox.Show("請輸入正確路徑", "瀏覽路徑");
return;
}

//找出目錄底下所有檔案，以及子目錄底下所有檔案
string[] filepath = System.IO.Directory.GetFiles(textPath.Text, "*",
System.IO.SearchOption.AllDirectories);
//設定初始值
this.label4.Text = "";
//設定初始值=0
this.progressBar1.Value = 0;
//數值最小=0
this.progressBar1.Minimum = 0;
//數值最大=總共檔案數目
this.progressBar1.Maximum = filepath.Length;
this.progressBar1.Step = 1;
foreach (var filename in filepath)
{
//從路徑抓出檔案名稱
string strname = filename.Substring(filename.LastIndexOf("\\") + 1);
//從路徑抓出目錄路徑
string strname1 = filename.Substring(0, filename.LastIndexOf("\\"));

string strSpace = "";
//判斷字串中是否有空白部分
if (strname.Contains(" "))
{
//使用Replace轉換字串
strSpace = strname.Replace(" ", "_");
}
else
{
//沒有空白則為原來檔案名稱
strSpace = strname;
}

//拆解檔案名稱，分出 檔名 及 副檔名
string strMa = "";
string strSe = "";
//檔名在副檔名"."之前
strMa = strSpace.Substring(0, strSpace.LastIndexOf(".")).ToString();
//副檔名在"."之後包括"."
strSe = strSpace.Substring(strSpace.LastIndexOf(".")).ToString();

string strDel = "";

//當檔案名稱裡面有"."的時候
while (strMa.Contains("."))
{
//index從零開始，總長度-1= index
if ((strMa.LastIndexOf(".")) == (strMa.Length - 1))
{
//檔案索引與"."相同，減去一個字串
strDel = strMa.Substring(0, strMa.Length - 1).ToString();
strMa = strDel;
}
else
{
break;
}
}

//foreach一個檔案就+1
progressBar1.Value += 1;

//使用File.Move移動檔案，也可以更新檔案名稱
File.Move(filename, strname1 + "\\" + strMa + strSe);
//計算百分比
int intValue = progressBar1.Value;
label4.Text = "Records Read = " + progressBar1.Value.ToString() +"個 " +
((intValue / progressBar1.Maximum) * 100 + "%").ToString();
}
//MessageBox.Show("檔案名稱修改完成", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}