using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;
using System.Xml.Serialization;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
}
//把数据库里的数据导成xml格式的文件
private static void XMLGetOut()
{
DataTable dt = DBHelper.GetTable("select * from FamilyUser");
XElement xmlbookstore = new XElement("xmlbookstore");
for (int i = 0; i < dt.Rows.Count; i++)
{
XElement FamilyUser = new XElement("FamilyUser");
XElement userName = new XElement("userName", dt.Rows[i]["userName"].ToString());
XElement password = new XElement("password", dt.Rows[i]["password"].ToString());
XElement notes = new XElement("notes", dt.Rows[i]["notes"].ToString());
FamilyUser.Add(userName);
FamilyUser.Add(password);
FamilyUser.Add(notes);
xmlbookstore.Add(FamilyUser);
}
FileStream stream = File.OpenWrite("~/bin/a.xml");
StreamWriter writer = new StreamWriter(stream);
writer.Write(xmlbookstore.ToString());
writer.Flush();
writer.Dispose();
}
//XML导入数据库
private static void XMLGetIn()
{
Stream stream = File.OpenRead("a.xml");
XDocument document = XDocument.Load(stream);
stream.Dispose();
foreach (XElement element in document.Root.Descendants("FamilyUser"))
{
string userName = element.Element("userName").Value;
string password = element.Element("password").Value;
string notes = element.Element("notes").Value;
int a = DBHelper.NonQuery("insert into FamilyUser ([userName],[password],[notes])values('" + userName + "','" + password + "','" + notes + "')");
}
}
private static void NewMethod()
{
FamilyUser familyuser = new FamilyUser();
SqlDataReader sqldr = DBHelper.Reader("select top 1 * from FamilyUser");
using (sqldr)
{
if (sqldr.Read())
{
familyuser.userName = sqldr["userName"].ToString();
familyuser.password = sqldr["password"].ToString();
familyuser.notes = sqldr["notes"].ToString();
}
}
XmlSerializer xmlser = new XmlSerializer(typeof(FamilyUser));
var c = familyuser;
xmlser.Serialize(Console.Out, c);
}
}
[XmlRoot("FamilyUser")]
public class FamilyUser
{
//[XmlAttribute("UserName")]
[XmlElement("UserName")]
public string userName { get; set; }
//[XmlIgnore]
[XmlElement("PassWord")]
public string password { get; set; }
[XmlElement("Uotes")]
public string notes { get; set; }
}
}