TextFile1.txt 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141
  1. From main.cs
  2. #region Test
  3. /**********************************************TEST ......................
  4. /// <summary>
  5. /// Test lecture xml imbriqué
  6. /// </summary>
  7. private void tt()
  8. {
  9. //XElement xEle = new XElement("tb_prestas", "content");//XElement.Load(Program.folder + @"\employees.xml");
  10. //IEnumerable<XElement> employees = xelement.Elements();
  11. //// Read the entire XML
  12. //foreach (var employee in employees)
  13. //{
  14. // Console.WriteLine("***********");
  15. // Console.WriteLine(employee);
  16. //}
  17. //XElement xEle = XElement.Load("..\\..\\Employees.xml");
  18. XElement sxEle = new XElement("Employee",
  19. new XElement("EmpId", 6),
  20. new XElement("Name", "George"),
  21. new XElement("Sex", "Male"),
  22. new XElement("Phone", "423-555-4224", new XAttribute("Type", "Home")),
  23. new XElement("Phone", "424-555-0545", new XAttribute("Type", "Work")),
  24. new XElement("Address",
  25. new XElement("Street", "Fred Park, East Bay"),
  26. new XElement("City", "Acampo"),
  27. new XElement("State", "CA"),
  28. new XElement("Zip", "95220"),
  29. new XElement("Country", "USA")));
  30. XElement xEle = new XElement("tb_prestas", sxEle);
  31. xEle.Save(Program.folder + @"\employees2.xml");
  32. Console.WriteLine(xEle);
  33. }
  34. **********************************************************/
  35. #endregion Test
  36. /*
  37. *
  38. List<string> linesGlob = lines.FindAll(
  39. delegate(string sr)
  40. {
  41. return sr.ToUpper().Contains(".GLOBAL.");
  42. }
  43. );
  44. List<string> linesUnik = lines.FindAll(
  45. delegate(string sr)
  46. {
  47. return !sr.ToUpper().Contains(".GLOBAL.");
  48. }
  49. );
  50. foreach (string line in linesGlob)
  51. readHttp_Glob(line);
  52. foreach (string line in linesUnik)
  53. readHttp_Unik(line);
  54. *
  55. private void readHttp_Glob(string url_txt)
  56. {
  57. Uri url = new Uri(url_txt);
  58. HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
  59. request.MaximumAutomaticRedirections = 4;
  60. request.MaximumResponseHeadersLength = 4;
  61. request.Credentials = CredentialCache.DefaultCredentials;
  62. HttpWebResponse response = (HttpWebResponse)request.GetResponse();
  63. Stream receiveStream = response.GetResponseStream();
  64. StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
  65. streamtolist_glob(readStream);
  66. readStream.Close();
  67. response.Close();
  68. }
  69. private void readHttp_Unik(string url_txt)
  70. {
  71. Uri url = new Uri(url_txt);
  72. HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
  73. request.MaximumAutomaticRedirections = 4;
  74. request.MaximumResponseHeadersLength = 4;
  75. request.Credentials = CredentialCache.DefaultCredentials;
  76. HttpWebResponse response = (HttpWebResponse)request.GetResponse();
  77. Stream receiveStream = response.GetResponseStream();
  78. StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
  79. streamtolist_uniq(readStream);
  80. response.Close();
  81. readStream.Close();
  82. }
  83. //Make Images
  84. private void makePnpFromDB()
  85. {
  86. //the index number to write bytes to
  87. long CurrentIndex = 0;
  88. //the number of bytes to store in the array
  89. int BufferSize = 4096;
  90. //The Number of bytes returned from GetBytes() method
  91. long BytesReturned;
  92. //A byte array to hold the buffer
  93. byte[] Blob = new byte[BufferSize];
  94. string strCnx="server=localhost;user id=Patrick;password=xvtu92+2;persist security info=True;database=carbu";
  95. MySql.Data.MySqlClient.MySqlConnection myCnx = new MySql.Data.MySqlClient.MySqlConnection(strCnx);
  96. myCnx.Open();
  97. string strCmd = "select * from pays";
  98. MySql.Data.MySqlClient.MySqlCommand myCmd = new MySqlCommand(strCmd,myCnx);
  99. MySqlDataReader myReader = myCmd.ExecuteReader();
  100. while ( myReader.Read())
  101. {
  102. listBox1.Items.Add(myReader.GetString(0));
  103. FileStream fs = new FileStream("D:\\temp\\" + myReader.GetString(0)+"_"+ myReader.GetString(1)+"_"+ myReader.GetString(2).Replace(" ","")+".png", FileMode.OpenOrCreate, FileAccess.Write);
  104. BinaryWriter writer = new BinaryWriter(fs);
  105. CurrentIndex = 0;
  106. BytesReturned = myReader.GetBytes(3, CurrentIndex, Blob, 0, BufferSize);
  107. while (BytesReturned == BufferSize)
  108. {
  109. writer.Write(Blob);
  110. writer.Flush();
  111. CurrentIndex += BufferSize;
  112. BytesReturned = myReader.GetBytes(3, CurrentIndex, Blob, 0, BufferSize);
  113. }
  114. writer.Write(Blob, 0, (int)BytesReturned);
  115. writer.Flush();
  116. writer.Close();
  117. fs.Close();
  118. }
  119. myReader.Close();
  120. myCnx.Close();
  121. }
  122. */