private void button_ensure_click(object sender, RoutedEventArgs e)
{
if (name.Text == "" || password.Text == "")
{
MessageBox.Show("输入信息不能为空！");
return;
}
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
User u = new User()
{
uName = name.Text,
uPassword = password.Text,
addTime = DateTime.Now,
balance = 0
};
try
{
c.User.Add(u);
c.SaveChanges();
MessageBox.Show("添加用户成功！");
}
catch (Exception ex)
{
MessageBox.Show("添加失败：" + ex.Message);
}
}
}
private void button_ensure_click(object sender, RoutedEventArgs e)
{
if (userid.Text == "" || money.Text == "")
{
MessageBox.Show("输入信息不能为空！");
return;
}
int x;
double d;
if (!int.TryParse(userid.Text, out x) || !double.TryParse(money.Text, out d))
{
MessageBox.Show("输入信息有误" + "12");
return;
}
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
var q = from t in c.User
where t.uID == x
select t;
if (q != null && q.Count() >= 1)
{
foreach (var v in q)
{
v.balance += d;
MessageBox.Show("您已成功为" + v.uName + "充值现金" + d + "元\r\n当前余额" + v.balance + "元");
}
c.SaveChanges();
}
else
{
MessageBox.Show("输入信息有误");
}
}
}
private void button_ensure_click(object sender, RoutedEventArgs e)
{
if (name.Text == "" || password.Text == "" || typebox.Text == "")
{
MessageBox.Show("输入信息不能为空！");
return;
}
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
string s = typebox.Text;
Admin u = new Admin()
{
aName = name.Text,
aPassword = password.Text,
Type = s
};
try
{
c.Admin.Add(u);
c.SaveChanges();
MessageBox.Show("添加用户成功！");
}
catch (Exception ex)
{
MessageBox.Show("添加失败：" + ex.Message);
}
}
}
public 除管理员()
{
InitializeComponent();
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
var q = from t in c.Admin
select t;
if (q != null && q.Count() >= 1)
{
this.datagrid.ItemsSource = q.ToList();
}
}
}
private void button_getTicket_Click(object sender, RoutedEventArgs e)
{
if ((balancelabel2.Content).ToString() != "")
{
if (blance >= allprice)
{
using (var context = new SubwayDatabaseEntities6())
{
var q = from t in context.User
where t.uID == ID
select t;
foreach (var v in q)
{
v.balance -= allprice;
balancelabel2.Content = v.balance;
blance = v.balance;
}
context.SaveChanges();
Ticket ticket = new Ticket()
{
UserName = name,
UserID = ID,
Type = type,
BeginStation = startstation,
EndStation = endstation,
Price = price,
num = Ticketnum
};
try
{
context.Ticket.Add(ticket);
context.SaveChanges();
MessageBox.Show("恭喜您，购票成功！");
}
catch (Exception ex)
{
MessageBox.Show("添加失败：" + ex.Message);
}
}
}
else
{
MessageBox.Show("金额不足,请联系管理员充值!");
}
}
}
private void button_search_Click(object sender, RoutedEventArgs e)
{
if (userID.Text != "" || password.Password != "")
{
int x;
if (int.TryParse(userID.Text, out x))
{
using (var context = new SubwayDatabaseEntities6())
{
int i = 0;
var q = from t in context.User
where t.uID == x
select t;
foreach (var v in q)
{
if (v.uPassword.ToString() == password.Password.ToString())
{
ID = v.uID;
blance = v.balance;
name = v.uName;
balancelabel.Content = "Balance : ";
balancelabel2.Content = v.balance.ToString();
}
else
{
MessageBox.Show("输入信息有误");
}
i++;
}
if (i == 0)
{
MessageBox.Show("输入信息有误");
}
}
}
else
{
MessageBox.Show("输入信息有误！");
}
}
else
{
MessageBox.Show("请输入用户信息！");
}
}
private void state_login_Click(object sender, RoutedEventArgs e)
{
if (UserID.Text == "" || password.Password == "")
{
MessageBox.Show("请您先填好信息再登录！");
return;
}
int x;
if (!int.TryParse(UserID.Text, out x))
{
MessageBox.Show("您输入的信息有误");
return;
}
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
var q = from t in c.User
where t.uID == x && t.uPassword == password.Password.ToString()
select t;
if (q != null && q.Count() >= 1)
{
var p = from t in c.Ticket
where t.UserID == x
select t;
if (p != null && p.Count() >= 1)
{
State st = new State();
st.datagrid.ItemsSource = p.ToList();
st.Show();
this.Close();
}
else
{
MessageBox.Show("您当前还未购买票，请前往购票！");
}
}
else
{
MessageBox.Show("您输入的信息有误");
}
}
}
private void button_delete_click(object sender, RoutedEventArgs e)
{
if (userID.Text == "")
{
MessageBox.Show("输入信息不能为空！");
}
int x;
if (!int.TryParse(userID.Text, out x))
{
MessageBox.Show("输入信息有误！");
}
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
var q = from t in c.Admin
where t.aId == x
select t;
if (q != null && q.Count() >= 1)
{
foreach (var v in q)
{
c.Admin.Remove(v);
MessageBox.Show("ID: " + v.aId + "Name: " + v.aName + "\r\n删除成功");
var p = from t in c.Admin
select t;
if (p != null && p.Count() >= 1)
{
this.datagrid.ItemsSource = p.ToList();
}
}
c.SaveChanges();
}
else
{
MessageBox.Show("输入信息有误");
}
}
}
private void ensure_click(object sender, RoutedEventArgs e)
{
if (ticketId.Text == "")
{
MessageBox.Show("请您先填好信息！");
return;
}
int x;
if (!int.TryParse(ticketId.Text, out x))
{
MessageBox.Show("您输入的信息有误");
return;
}
using (SubwayDatabaseEntities6 c = new SubwayDatabaseEntities6())
{
var q = from t in c.Ticket
where t.Id == x
select t;
if (q != null && q.Count() >= 1)
{
TicketState ts = new TicketState();
foreach (var v in q)
{
ts.StartState.Content = v.BeginStation;
ts.EndState.Content = v.EndStation;
ts.TicketType.Content = v.Type;
}
;
ts.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("您输入的信息有误");
}
}
}
