//数据库所在服务器IP
string servername = "192.168.2.137";
//数据库名字
string sqlname = "myTest";
//数据库账号
string usname= "myTest";
//数据库密码
string pwd = "123456";
//表名
string tablename="user";
//连接数据库语句
string strSql = "Server=" + servername + ";database=" + dbname + ";uid=" + usname + ";pwd=" + pwd + ";";
//建表方法
private static void creatTable(){
    using (SqlConnection conn = new SqlConnection(mConnString)){
    try{
        if(conn.State== ConnectionState.Closed){
         conn.Open();
        }
        StringBuilder sqlBuider = new StringBuilder("CREATE TABLE "+tablename+"(")
        .Append("[id] [int] IDENTITY(1,1) NOT NULL,")
        .Append("[UserName] [nvarchar](50) NULL,")
        .Append("[UserPwd] [nvarchar](200) NULL")
        SqlCommand cmd = new SqlCommand(sqlBuider.ToString(),conn);
        cmd.ExecuteNonQuery();
    }catch (Exception ex){
        conn.Close();
    }
  }
}
// 执行 修改、删除、添加的sql语句
private static Boolean update(string sql){
    using(SqlConnection conn = new SqlConnection(mConnString)){
    try{
        if(conn.State== ConnectionState.Closed){
         conn.Open();
        }
        SqlCommand com = new SqlCommand(sql,conn);
        int result = com.ExecuteNonQuery();
        conn.Close();
        if (result > 0) return true;
       }
     catch(Exception ex){
        conn.Close();
     }
     return false;
    }
}

// 事务执行 修改、删除、添加的sql语句
private static Boolean updateTran(List<string> sqlList,IsolationLevel leave){
    if (sqlList.Count == 0) return false;
    using(SqlConnection conn = new SqlConnection(mConnString)){
    SqlTransaction tran = null;
    try{
     
        if(conn.State== ConnectionState.Closed){
         conn.Open();
        }
        tran = conn.BeginTransaction(leave);
        for (int index = 0; index < sqlList.Count; index++){
             SqlCommand com = new SqlCommand(sqlList[index],conn);
             com.Transaction = tran;
             int result = com.ExecuteNonQuery();
             conn.Close();
             if (result > 0) {
               tran.Rollback();
               return true;
             }    
        }
       tran.Commit();
       return true; 
       }
     catch(Exception ex){
      if (tran != null){
        tran.Rollback();
         }
        conn.Close();
     }
     return false;
    }
}
 //获取查询的记录集
public static  DataTable getTable(string sql){
  using (SqlConnection conn = new SqlConnection(mConnString)){
    try{
        if(conn.State== ConnectionState.Closed){
           conn.Open();
        }
       SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
       DataTable dt = new DataTable();
       adapter.Fill(dt);
       conn.Close();
       return dt;
    }catch (Exception ex){
        conn.Close();
    }
  }

//添加日志文件
public static bool NoteLog(string line){
try{
   string Fpath = System.Web.HttpContext.Current.Server.MapPath("~/bin/log");
       if (!Directory.Exists(Fpath))
      {
       Directory.CreateDirectory(Fpath);
       }
       StreamWriter Note = new StreamWriter(Fpath + "/" + DateTime.Now.ToString("yyyyMMdd") + ".log", true, Encoding.Default);
       Note.WriteLine(DateTime.Now.ToString() + "##" + line + "\r\n");
       Note.Close();  
    }
 catch (Exception ex){
       
    }
    return true;
}

}