using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Xml; using System.Xml.Serialization; using System.Text; using System.IO;
public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Response.Clear(); Response.ContentType = "text/xml"; Response.Charset = "UTF-8"; string db = "Data Source=LENOVO-85DD1539;Initial Catalog=Emne;User ID=sa;Password=ehs123456"; string sql = "select * from Emne"; SqlConnection conn = new SqlConnection(db); conn.Open(); SqlCommand comm = new SqlCommand(sql, conn); SqlDataReader sdr = comm.ExecuteReader(); Class1 c = new Class1(); while (sdr.Read()) { c.Id = Convert.ToInt32(sdr["Id"]); c.Temperature = Convert.ToInt32(sdr["Temperature"]); c.Humidity = Convert.ToInt32(sdr["Humidity"]); c.Airquality = Convert.ToInt32(sdr["Airquality"]); c.Fan = Convert.ToInt32(sdr["Fan"]); c.Button1 = Convert.ToInt32(sdr["Button1"]); c.Button2 = Convert.ToInt32(sdr["Button2"]); c.Button3 = Convert.ToInt32(sdr["Button3"]); c.Button4 = Convert.ToInt32(sdr["Button4"]); c.Button5 = Convert.ToInt32(sdr["Button5"]); c.Button6 = Convert.ToInt32(sdr["Button6"]); } XmlWriter writer = null; try { XmlSerializer serializer = new XmlSerializer(c.GetType()); //string l = AppDomain.CurrentDomain.BaseDirectory; //StreamWriter myWriter = new StreamWriter(l + "/myFileName.xml"); //mySerializer.Serialize(myWriter, c); writer = new XmlTextWriter(Response.OutputStream, Encoding.UTF8); serializer.Serialize(writer, c); } finally { if (writer != null) { writer.Close(); } } if (Request.QueryString["bu"] != null) { try { string id = Request.QueryString["bu"].ToString();
if (id.Equals("Button1")) { if (c.Button1 == 0) { sql = "update Emne set Button1=1 where Id=" + c.Id; } else { sql = "update Emne set Button1=0 where Id=" + c.Id; } conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button2")) { if (c.Button1 == 0) { sql = "update Emne set Button2=1 where Id=" + c.Id; } else { sql = "update Emne set Button2=0 where Id=" + c.Id; } conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button3")) { if (c.Button1 == 0) { sql = "update Emne set Button3=1 where Id=" + c.Id; } else { sql = "update Emne set Button3=0 where Id=" + c.Id; } conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button4")) { if (c.Button1 == 0) { sql = "update Emne set Button4=1 where Id=" + c.Id; } else { sql = "update Emne set Button4=0 where Id=" + c.Id; } conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button5")) { if (c.Button1 == 0) { sql = "update Emne set Button5=1 where Id=" + c.Id; } else { sql = "update Emne set Button5=0 where Id=" + c.Id; } conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } if (id.Equals("Button6")) { if (c.Button1 == 0) { sql = "update Emne set Button6=1 where Id=" + c.Id; } else { sql = "update Emne set Button6=0 where Id=" + c.Id; } conn.Close(); conn.Open(); comm = new SqlCommand(sql, conn); comm.ExecuteReader(); conn.Close(); } } finally { }
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn