开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
frmExport.cs
资源名称：DataExport(GenSqlScript).zip　[点击查看]
上传用户：lyg_rssy
上传日期：2022-04-14
资源大小：104k
文件大小：28k
源码类别：

数据库系统

开发平台：

C#

frmExport.cs：源码内容
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using System.Data.SqlClient;
  10. using System.IO;
  11. using System.Threading;
  13. namespace HKBU_DataExport
  14. {
  15.     public partial class frmExportData : Form
  16.     {
  17.         public frmExportData()
  18.         {
  19.             InitializeComponent();
  20.         }
  22.         private static List<Thread> backendThread = new List<Thread>();
  23.         private static List<string> backendThreadName = new List<string>();
  24.         private const string TempFilePath = "";
  25.         private static string GoodlistFileName = "\" + Properties.Settings.Default.Table1 + ".ecp";
  26.         private static string VisitorFileName = "\" + Properties.Settings.Default.Table2  + ".ecp";
  27.         private const string TempFileName = "\Temp.ecp";
  28.         private const string LogFileName = "\Log.txt";
  29.         private const string Key = "P@ssw0rd";
  30.         private StreamWriter UpdateLog = null;
  31.         private bool isTable1Updated = false;
  32.         private bool isTable2Updated = false;
  33.         private string NullValue = "NULL";
  34.         private object updateLock = new object();
  35.         private const string FILE_UPDATE_TABLE = "UpdateTable_log";
  36.         private const string LOG_SEPERATOR = "-----------------------------------------------";
  37.         private const char FileSeperator = 't';
  39.         private delegate void InvokeDelegate(string msg);
  40.         private delegate void setupGVDelegate(DataGridView gvData, string file);
  42.         private void frmExportData_Load(object sender, EventArgs e)
  43.         {            
  44.             try
  45.             {
  46.                 if (!File.Exists(Properties.Settings.Default.Output_Path))
  47.                 {
  48.                     Directory.CreateDirectory(Properties.Settings.Default.Output_Path);
  49.                 }
  50.                 UpdateLog = new StreamWriter(Properties.Settings.Default.Output_Path + LogFileName, true);
  51.                 UpdateLog.AutoFlush = true;
  52.                 UpdateLog.WriteLine("------------------------------------------------------------------------------------------------------");
  53.                 UpdateLog.WriteLine("Application Launched At: " + DateTime.Today.ToString("yyyy/MM/dd HH:mm:ss"));
  54.                 UpdateLog.WriteLine ("------------------------------------------------------------------------------------------------------");
  55.                 writeLog("System Loading ...");
  56.                 txtOutputPath.Text = Properties.Settings.Default.Output_Path;
  57.                 txtUpdateHour.Text = Properties.Settings.Default.update_hour.ToString();
  58.                 txtUpdateMinute.Text = Properties.Settings.Default.update_minute.ToString();
  59.                 txtConnectionString.Text = Properties.Settings.Default.ConnectionString;
  60.                 txtTable1.Text = Properties.Settings.Default.Table1;
  61.                 txtTable2.Text = Properties.Settings.Default.Table2;
  62.                 btnTable1.Text = Properties.Settings.Default.Table1;
  63.                 btnTable2.Text = Properties.Settings.Default.Table2;
  64.                 writeLog("Initialize Completed");
  65.             }
  66.             catch (Exception ex)
  67.             {
  68.                 MessageBox.Show("Initialize System Failed, Error Message: " + ex.ToString());
  69.             }
  70.         }
  72.         private void setupGridView(DataGridView gvData,string table)
  73.         {
  74.             if (this.InvokeRequired)
  75.             {
  76.                 this.Invoke(new setupGVDelegate(setupGridView),gvData,table);
  77.             }
  78.             else
  79.             {
  80.                 try
  81.                 {
  82.                     using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString))
  83.                     {
  84.                         string command = "Select * from " + table;
  85.                         using (SqlDataAdapter sda = new SqlDataAdapter(command, conn))
  86.                         {
  87.                             DataSet ds = new DataSet();
  88.                             sda.Fill(ds);
  89.                             gvData.DataSource = ds.Tables[0];
  90.                         }
  91.                     }
  92.                 }
  93.                 catch (Exception ex)
  94.                 {
  95.                     MessageBox.Show("Open Data Table Failed, Error Message: " + ex.ToString(), "Error", MessageBoxButtons.OK);
  96.                     writeLog("Open Data Table Failed, Error Message: " + ex.ToString());
  97.                 }
  98.             }
  99.         }
  101.         private void btnSave_Click(object sender, EventArgs e)
  102.         {
  103.             writeLog("------------------------------------------------");
  104.             try
  105.             {                
  106.                 this.Cursor = Cursors.WaitCursor;
  107.                 SaveFileDialog saveFileDialog = new SaveFileDialog();
  108.                 saveFileDialog.Filter = "Encrypted files (*.ecp)|*.ecp|Excel files (*.xls)|*.xls|Comma Separated Value File(*.csv)|*.csv|Microsoft SQL Server Query File(*.sql)|*.sql";
  109.                 saveFileDialog.FilterIndex = 0;
  110.                 saveFileDialog.RestoreDirectory = true;
  111.                 saveFileDialog.CreatePrompt = true;
  112.                 saveFileDialog.Title = "Export File To";
  113.                 string filePath = "";
  114.                 string msg;
  115.                 if (saveFileDialog.ShowDialog() == DialogResult.OK)
  116.                 {
  117.                     filePath = saveFileDialog.FileName;                    
  118.                     writeLog("Saving file as: " + filePath);
  119.                     string tempPath = Properties.Settings.Default.Output_Path + TempFileName;                        
  120.                     string extension = filePath.Split('.').Last().ToLower();        
  121.                     switch(extension)
  122.                     {
  123.                         case "sql":
  124.                             SaveAs(gvDataView, tempPath, FileSeperator);
  125.                             generateSqlFile(filePath,tempPath,btnTable1.Enabled?btnTable2.Text.Trim():btnTable1.Text.Trim());
  126.                             break;
  127.                         case "ecp":
  128.                             SaveAs(gvDataView, tempPath, FileSeperator);
  129.                             if (EncryptFunction.EncryptFile(tempPath, filePath, Key, out msg))
  130.                             try
  131.                             {
  132.                                 File.Delete(tempPath);
  133.                             }
  134.                             catch { }
  135.                             break;
  136.                         case "csv":
  137.                             SaveAs(gvDataView, filePath, ',');
  138.                             break;
  139.                         case "xls":
  140.                             SaveAs(gvDataView, filePath,FileSeperator);
  141.                             break;
  142.                     }                
  143.                     System.Windows.Forms.MessageBox.Show("File Saved", "Message", MessageBoxButtons.OK);
  144.                     writeLog("File Saved");                    
  145.                 }
  146.                 this.Cursor = Cursors.Default;
  147.             }
  148.             catch (Exception ex)
  149.             {
  150.                 System.Windows.Forms.MessageBox.Show("Error occured, Error Message: n" + ex.ToString(), "Message", MessageBoxButtons.OK);
  151.                 writeLog("Error occured, Error Message: n" + ex.ToString());
  152.                 this.Cursor = Cursors.Default;
  153.             }
  154.         }
  156.         /// <summary>
  157.         /// 另存新档按钮
  158.         /// </summary>
  159.         private void SaveAs(DataGridView gvData,string fileName,char seperator) //另存新档按钮   导出成CSV
  160.         {
  161.             Stream myStream;
  162.             myStream = File.Open(fileName, FileMode.Create);            
  163.             StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.UTF8);
  164.             string str = "";
  165.             try
  166.             {
  167.                 //写标题
  168.                 for (int i = 0; i < gvData.ColumnCount; i++)
  169.                 {
  170.                     if (i > 0)
  171.                     {
  172.                         str += seperator;
  173.                     }
  174.                     str += gvData.Columns[i].HeaderText;
  175.                 }
  176.                 sw.WriteLine(str);
  177.                 for (int j = 0; j < gvData.Rows.Count; j++)
  178.                 {
  179.                     string tempStr = "";
  180.                     for (int k = 0; k < gvData.Columns.Count; k++)
  181.                     {
  182.                         if (k > 0)
  183.                         {
  184.                             tempStr += seperator;
  185.                         }
  186.                         if (gvData.Rows[j].Cells[k].Value == gvData.DefaultCellStyle.NullValue || gvData.Rows[j].Cells[k].Value == DBNull.Value)
  187.                         {
  188.                             tempStr += NullValue;
  189.                         }
  190.                         else if (gvData.Rows[j].Cells[k].ValueType.Name.ToLower().CompareTo("datetime") == 0)
  191.                         {
  192.                             tempStr += Convert.ToDateTime(gvData.Rows[j].Cells[k].Value).ToString("yyyy-MM-dd HH:mm:ss");                            
  193.                         }
  194.                         else
  195.                         {
  196.                             tempStr += gvData.Rows[j].Cells[k].Value.ToString();
  197.                         }
  198.                     }
  199.                     sw.WriteLine(tempStr);   
  200.                 }
  201.                 sw.Close();
  202.                 myStream.Close();
  203.             }
  204.             catch (Exception e)
  205.             {
  206.                 MessageBox.Show(e.ToString());
  207.                 writeLog("Export File Error, Error Message: " + e.ToString());
  208.             }
  209.             finally
  210.             {
  211.                 sw.Close();
  212.                 myStream.Close();
  213.             }   
  214.       }
  216.         private void btnOutputPath_Click(object sender, EventArgs e)
  217.         {
  218.             FolderBrowserDialog fbdOutputPath = new FolderBrowserDialog();
  219.             fbdOutputPath.RootFolder = Environment.SpecialFolder.Desktop;
  220.             if (fbdOutputPath.ShowDialog() == DialogResult.OK)
  221.             {
  222.                 txtOutputPath.Text = fbdOutputPath.SelectedPath;
  223.             }
  224.         }
  226.         private void changeOutputPath(string origin_path, string new_path)
  227.         {
  228.             string msg = "";
  230.             writeLog("Changing OutputPath...");
  231.             writeLog("Moving Log File to New Output Floder...");
  232.             UpdateLog.Close();
  233.             if (EncryptFunction.EncryptFile(origin_path + LogFileName, origin_path + TempFileName, Key, out msg))
  234.             {
  235.                 if (EncryptFunction.DecryptFile(origin_path + TempFileName, new_path + LogFileName, Key, out msg))
  236.                 {
  237.                     Properties.Settings.Default.Output_Path = new_path;
  238.                     UpdateLog = new StreamWriter(Properties.Settings.Default.Output_Path + LogFileName, true);
  239.                     UpdateLog.AutoFlush = true;
  240.                     try
  241.                     {
  242.                         File.Delete(origin_path + LogFileName);
  243.                     }
  244.                     catch { }
  245.                     writeLog("Output Path Changed");
  246.                 }
  247.                 else
  248.                 {
  249.                     Properties.Settings.Default.Output_Path = origin_path;
  250.                     UpdateLog = new StreamWriter(Properties.Settings.Default.Output_Path + LogFileName, true);
  251.                     UpdateLog.AutoFlush = true;
  252.                     writeLog("Change Output Path Failed, Error Message: " + msg);
  253.                     return;
  254.                 }
  255.             }
  256.             else
  257.             {
  258.                 Properties.Settings.Default.Output_Path = origin_path;
  259.                 UpdateLog = new StreamWriter(Properties.Settings.Default.Output_Path + LogFileName, true);
  260.                 UpdateLog.AutoFlush = true;
  261.                 writeLog("Change Output Path Failed, Error Message: " + msg);
  262.             }
  263.             try
  264.             {                
  265.                 File.Delete(origin_path + TempFileName);                
  266.             }
  267.             catch(Exception ex)
  268.             { }
  269.         }
  271.         private void btnSaveSetting_Click(object sender, EventArgs e)
  272.         {
  273.             try
  274.             {
  275.                 writeLog("------------------------------------------------");
  276.                 writeLog("Modifying System Setting");
  277.                 writeLog("Original Output Path: " + Properties.Settings.Default.Output_Path);
  278.                 writeLog("Original Update Time: " + Properties.Settings.Default.update_hour + " : " + Properties.Settings.Default.update_minute);
  279.                 writeLog("Original Connection String: " + Properties.Settings.Default.ConnectionString);
  280.                 writeLog("Original Table 1: " + Properties.Settings.Default.Table1);
  281.                 writeLog("Original Table 2: " + Properties.Settings.Default.Table2);
  282.                 changeOutputPath(Properties.Settings.Default.Output_Path, txtOutputPath.Text);
  283.                 Properties.Settings.Default.update_hour = Int32.Parse(txtUpdateHour.Text);
  284.                 Properties.Settings.Default.update_minute = Int32.Parse(txtUpdateMinute.Text);
  285.                 Properties.Settings.Default.ConnectionString = txtConnectionString.Text;
  286.                 Properties.Settings.Default.Table1 = txtTable1.Text;
  287.                 Properties.Settings.Default.Table2 = txtTable2.Text;
  288.                 btnTable1.Text = txtTable1.Text;
  289.                 btnTable2.Text = txtTable2.Text;
  290.                 System.Windows.Forms.MessageBox.Show("System Setting Saved", "Message", MessageBoxButtons.OK);
  291.                 writeLog("System Setting Modified");
  292.                 writeLog("Current Output Path: " + txtOutputPath.Text);
  293.                 writeLog("Current Update Time: " + txtUpdateHour.Text + " : " + txtUpdateMinute.Text);
  294.                 writeLog("Current Connection String: " + txtConnectionString.Text);
  295.                 writeLog("Current Table 1: " + txtTable1.Text);
  296.                 writeLog("Current Table 2: " + txtTable2.Text);
  297.             }
  298.             catch (Exception ex)
  299.             {
  300.                 System.Windows.Forms.MessageBox.Show("Error occured, Error Message: n" + ex.ToString(), "Message", MessageBoxButtons.OK);
  301.                 writeLog("Error occured, Error Message: n" + ex.ToString());
  302.                 writeLog("Original Output Path: " + Properties.Settings.Default.Output_Path);
  303.                 writeLog("Original Update Time: " + Properties.Settings.Default.update_hour + " : " + Properties.Settings.Default.update_minute);
  304.                 writeLog("Original Connection String: " + Properties.Settings.Default.ConnectionString);
  305.                 writeLog("Original Table 1: " + Properties.Settings.Default.Table1);
  306.                 writeLog("Original Table 2: " + Properties.Settings.Default.Table2);
  307.             }
  308.             finally
  309.             {
  310.                 resetManualPanel();
  311.             }
  312.         }
  314.         private void exportGoodlist()
  315.         {
  316.             try
  317.             {
  318.                 this.Cursor = Cursors.WaitCursor;
  319.                 if (!isTable1Updated)
  320.                 {
  321.                     writeLog("------------------------------------------------");
  322.                     writeLog("Exproting Data Table: [" + Properties.Settings.Default.Table1 + "]");
  323.                     string inputfilePath = Properties.Settings.Default.Output_Path + TempFilePath;
  324.                     if (!File.Exists(inputfilePath)) Directory.CreateDirectory(inputfilePath);
  325.                     string outputfilePath = Properties.Settings.Default.Output_Path;
  326.                     if (!File.Exists(outputfilePath)) Directory.CreateDirectory(outputfilePath);
  327.                     inputfilePath += TempFileName;
  328.                     outputfilePath += GoodlistFileName;
  329.                     string msg = "";
  330.                     setupGridView(gvGoodlist, Properties.Settings.Default.Table1);
  331.                     SaveAs(gvGoodlist, inputfilePath, FileSeperator);
  332.                     this.Cursor = Cursors.WaitCursor;
  333.                     if (EncryptFunction.EncryptFile(inputfilePath, outputfilePath, Key, out msg))
  334.                     {
  335.                         writeLog("Data Table: [" + Properties.Settings.Default.Table1 + "] Exported");
  336.                         isTable1Updated = true;
  337.                     }
  338.                     else
  339.                     {
  340.                         writeLog("Error occured, Error Message: " + msg);
  341.                     }
  342.                     try
  343.                     {
  344.                         File.Delete(inputfilePath);
  345.                     }
  346.                     catch { }
  347.                 }
  348.             }
  349.             catch
  350.             {
  351.                 isTable1Updated = false;
  352.             }
  353.             this.Cursor = Cursors.Default;
  354.         }
  356.         private void exportVisitor()
  357.         {
  358.             try
  359.             {
  360.                 this.Cursor = Cursors.WaitCursor;
  361.                 if (!isTable2Updated)
  362.                 {
  363.                     writeLog("------------------------------------------------");
  364.                     writeLog("Exproting Data Table: [" + Properties.Settings.Default.Table2 + "]");
  365.                     string inputfilePath = Properties.Settings.Default.Output_Path + TempFilePath;
  366.                     if (!File.Exists(inputfilePath)) Directory.CreateDirectory(inputfilePath);
  367.                     string outputfilePath = Properties.Settings.Default.Output_Path;
  368.                     if (!File.Exists(outputfilePath)) Directory.CreateDirectory(outputfilePath);
  369.                     inputfilePath += TempFileName;
  370.                     outputfilePath += VisitorFileName;
  371.                     string msg = "";
  372.                     setupGridView(gvVisitor, Properties.Settings.Default.Table2);
  373.                     SaveAs(gvVisitor, inputfilePath, FileSeperator);
  374.                     this.Cursor = Cursors.WaitCursor;
  375.                     if (EncryptFunction.EncryptFile(inputfilePath, outputfilePath, Key, out msg))
  376.                     {
  377.                         writeLog("Data Table: [" + Properties.Settings.Default.Table2 + "] Exported");
  378.                         isTable2Updated = true;
  379.                     }
  380.                     else
  381.                     {
  382.                         writeLog("Error occured, Error Message: " + msg);
  383.                     }
  384.                     try
  385.                     {
  386.                         File.Delete(inputfilePath);
  387.                     }
  388.                     catch { }
  389.                 }
  390.             }
  391.             catch
  392.             {
  393.                 isTable2Updated = false;
  394.             }
  395.             this.Cursor = Cursors.Default;
  396.         }       
  398.         private void btnStart_Click(object sender, EventArgs e)
  399.         {
  400.             writeLog("------------------------------------------------");
  401.             writeLog("Launching Update Threads...");
  402.             Thread tdExportTable = new Thread(ExportTableInSchedule);
  403.             tdExportTable.Start();
  404.             writeLog("Update Thread Started");
  405.             backendThread.Insert(0,tdExportTable);
  406.             backendThreadName.Insert(0,"ExportTable");
  407.             btnStart.Enabled = false;
  408.             btnStop.Enabled = true;
  409.             writeLog("Update Threads Launched");
  410.         }
  412.         private void btnStop_Click(object sender, EventArgs e)
  413.         {
  414.             writeLog("------------------------------------------------");
  415.             writeLog("Aborting Update Threads...");
  416.             foreach (Thread td in backendThread)
  417.             {
  418.                 td.Abort();             
  419.             }
  420.             backendThread.Clear();
  421.             backendThreadName.Clear();
  422.             btnStart.Enabled = true;
  423.             btnStop.Enabled = false;
  424.             writeLog("All Thread Aborted");
  425.         }
  427.         private void btnTable2_Click(object sender, EventArgs e)
  428.         {
  429.             writeLog("------------------------------------------------");
  430.             writeLog("Opening Data Table [" + Properties.Settings.Default.Table2 + "] ...");
  431.             this.Cursor = Cursors.WaitCursor;
  432.             btnTable1.Enabled = true;
  433.             btnTable2.Enabled = false;
  434.             btnSave.Enabled = true;
  435.             setupGridView(gvDataView, Properties.Settings.Default.Table2);
  436.             writeLog("Data Table [" + Properties.Settings.Default.Table2 + "] Opened");
  437.         }
  439.         private void btnTable1_Click(object sender, EventArgs e)
  440.         {
  441.             writeLog("------------------------------------------------");
  442.             writeLog("Opening Data Table [" + Properties.Settings.Default.Table1 + "] ...");
  443.             this.Cursor = Cursors.WaitCursor;
  444.             btnTable1.Enabled = false;
  445.             btnTable2.Enabled = true;
  446.             btnSave.Enabled = true;
  447.             setupGridView(gvDataView,Properties.Settings.Default.Table1);
  448.             writeLog("Data Table [" + Properties.Settings.Default.Table1 + "] Opened");
  449.         }
  451.         private void writeLog(string msg)
  452.         {            
  453.             if (this.InvokeRequired)
  454.             {
  455.                 this.Invoke(new InvokeDelegate(writeLog), msg);
  456.             }
  457.             else
  458.             {
  459.                 txtMessage.AppendText("[ " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "]:t" + msg + "n");
  460.                 txtMessage.ScrollToCaret();
  461.                 UpdateLog.WriteLine("[ " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "]:t" + msg );
  462.             }
  463.         }
  465.         private void btnKey_Click(object sender, EventArgs e)
  466.         {
  467.             writeLog("------------------------------------------------");
  468.             if (btnKey.Text.Trim().CompareTo("Confirm") == 0)
  469.             {
  470.                 if (txtKey.Text.Trim().CompareTo(Key) == 0)
  471.                 {
  472.                     plManual.Enabled = true;
  473.                     plSetting.Enabled = true;
  474.                     btnKey.Text = "Lock";
  475.                     txtKey.Enabled = false;
  476.                     System.Windows.Forms.MessageBox.Show("Administrator Control Unlocked", "Message", MessageBoxButtons.OK);
  477.                     writeLog("Access Administrator Control Mode");                 
  478.                 }
  479.                 else
  480.                 {
  481.                     System.Windows.Forms.MessageBox.Show("Access Administrator Control Mode Failed, Please Check Key.", "Message", MessageBoxButtons.OK);
  482.                     writeLog("Access Administrator Control Mode Faile");
  483.                 }
  484.             }
  485.             else
  486.             {
  487.                 resetManualPanel();
  488.                 plManual.Enabled = false;
  489.                 plSetting.Enabled = false;
  490.                 txtKey.Enabled = true;
  491.                 txtKey.Text = "";
  492.                 btnKey.Text = "Confirm";
  493.                 System.Windows.Forms.MessageBox.Show("Administrator Control Locked", "Message", MessageBoxButtons.OK);
  494.                 writeLog("Lock Administrator Control Mode");
  495.             }
  496.         }
  498.         private void resetManualPanel()
  499.         {
  500.             gvDataView.DataSource = null;
  501.             btnTable1.Enabled = true;
  502.             btnTable2.Enabled = true;
  503.             btnSave.Enabled = false;
  504.         }
  506.         private void DataView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
  507.         {            
  508.             this.Cursor = Cursors.Default;
  509.         }
  511.         private void frmExportData_FormClosing(object sender, FormClosingEventArgs e)
  512.         {
  513.             if (MessageBox.Show("Are you sure to Exit?", "Message", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
  514.             {
  515.                 e.Cancel = true;
  516.             }
  517.             else
  518.             {
  519.                 try
  520.                 {
  521.                     File.Delete(Properties.Settings.Default.Output_Path + TempFileName);
  522.                 }
  523.                 catch { }
  524.                 UpdateLog.WriteLine("------------------------------------------------------------------------------------------------------");
  525.                 UpdateLog.WriteLine("Application Aborted At: " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
  526.                 UpdateLog.WriteLine("------------------------------------------------------------------------------------------------------");
  527.                 UpdateLog.Close();
  528.             }
  529.         }
  531.         private void ExportTableInSchedule()
  532.         {
  533.             while (true)
  534.             {
  535.                 if (DateTime.Now.Hour == Properties.Settings.Default.update_hour && DateTime.Now.Minute == Properties.Settings.Default.update_minute)
  536.                 {
  537.                     exportGoodlist();
  538.                     exportVisitor();
  539.                 }
  540.                 else
  541.                 {
  542.                     isTable1Updated = false;
  543.                     isTable2Updated = false;
  544.                     Thread.Sleep(Properties.Settings.Default.update_frequency * 1000);
  545.                 }
  546.             }
  547.         }
  549.         private void btnExportAtOnce_Click(object sender, EventArgs e)
  550.         {
  551.             btnExportAtOnce.Enabled = false;
  552.             exportGoodlist();
  553.             exportVisitor();
  554.             isTable1Updated = false;
  555.             isTable2Updated = false;
  556.             MessageBox.Show("Operation Completed", "Message", MessageBoxButtons.OK);
  557.             btnExportAtOnce.Enabled = true;
  558.         }
  560.         public bool generateSqlFile(string outFilePath, string inFilePath, string tableName)
  561.         {
  562.             int successRecord = 0;
  563.             int failRecord = 0;
  564.             string inputPath = inFilePath;
  565.             StreamReader inputFile = new StreamReader(inputPath, System.Text.Encoding.UTF8);
  566.             StreamWriter updatelog = new StreamWriter(outFilePath,false,System.Text.Encoding.Unicode);
  567.             try
  568.             {
  569.                 string tempLine = inputFile.ReadLine(); // skip header(first line)
  570.                 string[] values;
  571.                 string tempCmd = "";
  572.                 int i = 0;
  573.                 values = Properties.Settings.Default.ConnectionString.Split(';');
  574.                 values = values[1].Split('=');
  575.                 tempCmd = "USE [" + values[1].Trim() + "]";
  576.                 WriteLine(updatelog, tempCmd);
  577.                 WriteLine(updatelog, "GO");
  578.                 while (!inputFile.EndOfStream)
  579.                 {
  580.                     tempLine = inputFile.ReadLine();
  581.                     values = tempLine.Split(FileSeperator);
  582.                     tempCmd = "Insert into [" + tableName + "] Values (";
  583.                     for (i = 0; i < values.Count() - 1; i++)
  584.                     {
  585.                         if (values[i].CompareTo(NullValue) == 0)
  586.                         {
  587.                             tempCmd += "NULL,";
  588.                         }
  589.                         else
  590.                         {
  591.                             tempCmd += "'" + values[i].Replace("'", "''") + "', ";
  592.                         }
  593.                     }
  594.                     if (values[i].CompareTo(NullValue) == 0)
  595.                     {
  596.                         tempCmd += "NULL)";
  597.                     }
  598.                     else
  599.                     {
  600.                         tempCmd += "'" + values[i].Replace("'", "''") + "')";
  601.                     }
  602.                     WriteLine(updatelog, tempCmd);
  603.                 }
  604.                 WriteLine(updatelog, "--" + LOG_SEPERATOR);
  605.                 WriteLine(updatelog, "--Finish Updating  At: " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  606.                 WriteLine(updatelog, "--Total Updated Records: " + (successRecord + failRecord).ToString());
  607.                 WriteLine(updatelog, "--Successed Records: " + (successRecord).ToString());
  608.                 WriteLine(updatelog, "--Failed Records: " + (failRecord).ToString());
  609.                 inputFile.Close();
  610.                 File.Delete(inputPath);
  611.                 updatelog.Flush();
  612.                 updatelog.Close();
  613.                 return true;
  614.             }
  615.             catch (Exception ex)
  616.             {
  617.                 WriteLine(updatelog, "--" + LOG_SEPERATOR);
  618.                 WriteLine(updatelog, "--Error Occured, Error Message: " + ex.ToString());
  619.                 inputFile.Close();
  620.                 File.Delete(inputPath);
  621.                 return false;
  622.             }
  623.         }
  625.         private void WriteLine(StreamWriter updatelog,string msg)
  626.         {
  627.             updatelog.WriteLine(msg);
  628.         }
  629.     }
  630. }