增值业务的同步程序

using System;
using System.Data.SqlClient;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Timers;

namespace _09_03
{
 class Class_09_03
 {
  public static void Main(String[] args)
  {
   System.Timers.Timer aTimer = new System.Timers.Timer();
   aTimer.Elapsed+=new ElapsedEventHandler(OnTimedEvent);
   // Set the Interval to 5 seconds.
   aTimer.Interval=5000;
   aTimer.Enabled=true;
 
   Console.WriteLine("Press /'q/' to quit the programme.");
   while(Console.Read()!='q');
  }
  private static void OnTimedEvent(object source, ElapsedEventArgs e)
  {
   string strConn = "Initial Catalog=movie;Data Source=(local);User ID=sa;Password=aaa";

   // SqlConnection 对象
   SqlConnection conn = new SqlConnection(strConn);
   SqlConnection conn1 = new SqlConnection(strConn);
   System.Net.WebClient Client=new System.Net.WebClient();
   

   try
   {
    // 打开数据库连接
    conn.Open();
    conn1.Open();

    
    // SqlCommand 对象, 使用conn作为数据连接
    SqlCommand cmd = new SqlCommand();
    SqlCommand cmd1 = new SqlCommand();
    cmd.Connection = conn;
    cmd1.Connection = conn1;

    cmd.CommandText = "SELECT * FROM t_sendtolmthree_hx";
    // 获取 SqlDataReader 实例
    SqlDataReader reader = cmd.ExecuteReader();

    // 输出结果
    //Console.WriteLine("{0}/t{1}/t/t{2}/t{3}", "id", "mobile", "deal", "mobiletype");
    //Console.WriteLine();
    while(reader.Read())
    {
     if(reader.IsDBNull(1)==false)
     {
      //Console.WriteLine("{0}/t{1}/t/t{2}/t{3}", reader.GetInt32(0), reader.GetString(1), reader.GetInt32(3), reader.GetInt32(4));
      String Urlstr=" http://192.168.75.122/gethttp.asp?i=";
                        Urlstr=Urlstr+reader.GetString(1);
      Console.WriteLine("{0}", Urlstr);
      Stream strm=Client.OpenRead(Urlstr);
      if(reader.IsDBNull(2)==false)
      {
       String Selectstr1="select count(*) from t_user_stat where mobile=";
       Selectstr1=Selectstr1+reader.GetString(1);
       cmd1.CommandText = (Selectstr1);
       int stat=(int)cmd1.ExecuteScalar();
       if(stat==0)
       {

        String Insertstr1="insert into t_user_stat(mobile,mobile_type,creater,spcode) values('";
        String Insertstr2="','";
        String Insertstr3="',3,1)";
        Insertstr1=Insertstr1+reader.GetString(1)+Insertstr2+reader.GetInt32(4)+Insertstr3;
        cmd1.CommandText = (Insertstr1);
        Console.WriteLine("向t_user_stat表写入{0}行！", cmd1.ExecuteNonQuery());
       }
       else
       {
        Console.WriteLine("向t_user_stat表写入0行！");
       }
      }
      else
      {
       Console.WriteLine("向t_user_stat表写入0行！");
      }
      String Deletestr = "delete from t_sendtolmthree_hx where mobile=";
      Deletestr=Deletestr+reader.GetString(1);
      cmd1.CommandText = (Deletestr);
      Console.WriteLine("删除{0}行！", cmd1.ExecuteNonQuery());
      DateTime dt1 = DateTime.Now;
      Console.WriteLine("执行时间：{0}", dt1);
     }
    }

    conn.Close();
    conn1.Close();
   }
   catch(Exception e2)
   {
    Console.WriteLine("报告异常：");
    Console.WriteLine(e2.Message);
   }
  }
 }
}