public void linkSql()
{
try
{
// 连接数据库引擎
using (contsDataContext aDataContext = new contsDataContext(ConnectionString))
{
if (!aDataContext.DatabaseExists())
{
aDataContext.CreateDatabase();
// Console.WriteLine("数据库已经创建！");
}
else
{
// Console.WriteLine("数据库已经存在！");
}
// 读取数据表内容
var aUsers = from r in aDataContext.User select r;
foreach (User aUser in aUsers)
{
Console.WriteLine($"{aUser.id} : {aUser.password}");
}
Console.WriteLine("插入新记录……");
//User aNewUser = new User { id = "131", password = "******" };
//aDataContext.User.InsertOnSubmit(aNewUser);
//Conts aNewConts = new Conts
//{
// id = "131",
// name = "joey",
// mobile = "1522328132",
// birth = "1991-01-01",
// sex = "Male",
// memo = "didnuas"
//};
//aDataContext.Conts.InsertOnSubmit(aNewConts);
// Console.WriteLine("提交数据……");
aDataContext.SubmitChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
}
public void Insert()
{
LoginModel aLogin = new LoginModel();
contsDataContext aDataContext = new contsDataContext(ConnectionString);
Conts aNewConts = new Conts
{
id = "131",
name = Name,
mobile = Mobile,
birth = Birth,
sex = Sex,
memo = Memo
};
aDataContext.Conts.InsertOnSubmit(aNewConts);
aDataContext.SubmitChanges();
}
//显示数据
public void MainMode()
{
contsDataContext aDataContext = new contsDataContext(ConnectionString);
var aConts = from r in aDataContext.Conts where r.id == LoginModel.id select r;
foreach (Conts aCont in aConts)
{
memberData.Add(new MainModel()
{
Name = aCont.name,
Mobile = aCont.mobile,
Memo = aCont.memo,
Sex = aCont.sex,
Birth = aCont.birth
});
}
}
public void TurntoMain()
{
contsDataContext aDataContext = new contsDataContext(ConnectionString);
User aUser = (from r in aDataContext.User where r.id == _user select r).FirstOrDefault();
if (aUser == null)
{
MessageBox.Show("查无此用户");
}
else if (aUser.password == _password)
{
id = aUser.id;
MainWindow mainWindow = new MainWindow();
App.Current.MainWindow = mainWindow;
mainWindow.Show();
}
else if (aUser.password != _password)
{
MessageBox.Show("密码错误！");
}
}