private void btnTicket_Click(object sender, EventArgs e)
{
using (var context = new BusinessContext())
{
var businessWithoutOrder = new BusinessWithoutOrder
{
Name = "孙二狗",
IDCard = IdCard,
CreateTime = DateTime.Now,
businessType = context.businessType.FirstOrDefault(a => a.Id == 1),
};
var model = context.businessWithoutOrder.Add(businessWithoutOrder);
var result = context.SaveChanges();
if (result > 0)
{
MessageBox.Show("出号成功,您的号码为A" + model.Id);
}
else
{
throw new Exception("出号失败");
}
}
}
private void btnTicket_Click(object sender, EventArgs e)
{
using (var context = new BusinessContext())
{
var business = context.business.OrderBy(a => a.OrderTime).ThenBy(a => a.ComingTime).FirstOrDefault(a => a.IDCard.Equals(IdCard));
if (business != null) MessageBox.Show(@"您的号码为B：" + business.Id);
}
}
private static string CallingOrder()
{
using (var context = new BusinessContext())
{
var user = context.business.OrderBy(a => a.OrderTime).ThenBy(a => a.ComingTime).FirstOrDefault();
if (user == null)
{
throw new Exception("队列为空");
}
return user.Name;
}
}
private static string CallingWithoutOrder()
{
using (var context = new BusinessContext())
{
var user = context.businessWithoutOrder.OrderBy(a => a.CreateTime).FirstOrDefault();
if (user == null)
{
MessageBox.Show(@"没有人排队");
return "";
}
return user.Name;
}
}
private static dynamic GetWithoutOrder(out int count)
{
using (var context = new BusinessContext())
{
var withoutList = context.businessWithoutOrder.Select(a => new
{
a.Name,
a.CreateTime,
a.IDCard,
a.Id,
typeName = a.businessType.Name
}).ToList();
count = withoutList.Count;
return withoutList;
}
}
private static dynamic GetOrders(out int count)
{
using (var context = new BusinessContext())
{
var orderList = context.business.Select(a => new
{
a.IDCard,
a.Name,
a.OrderTime,
a.Id,
typeName = a.businessType.Name
}).ToList();
count = orderList.Count;
return orderList;
}
}
private void GetNameByIdCardNum()
{
using (var context = new BusinessContext())
{
var business = context.business.FirstOrDefault(a => a.IDCard.Equals(IdCard));
if (business == null)
{
throw new Exception("没有这个人");
}
else
{
lblName.Text = business.Name;
}
}
}
private Business GetBusiness(string idCard)
{
using (var context = new BusinessContext())
{
return context.business.FirstOrDefault(a => a.IDCard.Equals(idCard));
}
}
private bool IsOrder(string idCard)
{
using (var context = new BusinessContext())
{
return context.business.Count(a => a.IDCard.Equals(idCard)) > 0;
}
}
private void Init()
{
using (var context = new BusinessContext())
{
var bt1 = new BusinessType
{
Name = "机动车业务"
};
var bt2 = new BusinessType
{
Name = "驾驶证业务"
};
context.businessType.AddRange(new[] { bt1, bt2 });
context.business.Add(new Business
{
IDCard = "232321029293817283",
CreateTime = DateTime.Now,
OrderTime = DateTime.Parse("2015-7-1"),
ComingTime = DateTime.Parse("2015-7-1"),
businessType = bt2,
Name = "李一花"
});
context.business.Add(new Business
{
IDCard = "232323798193817283",
CreateTime = DateTime.Now,
OrderTime = DateTime.Parse("2015-7-1"),
ComingTime = DateTime.Parse("2015-7-1"),
businessType = bt2,
Name = "李二花"
});
context.business.Add(new Business
{
IDCard = "232323218210417283",
CreateTime = DateTime.Now,
OrderTime = DateTime.Parse("2015-7-1"),
ComingTime = DateTime.Parse("2015-7-1"),
businessType = bt2,
Name = "李三花"
});
context.businessWithoutOrder.Add(new BusinessWithoutOrder
{
Name = "张三三",
IDCard = "111111111111111111",
businessType = bt1,
CreateTime = DateTime.Now
});
context.businessWithoutOrder.Add(new BusinessWithoutOrder
{
Name = "张三疯",
IDCard = "111111117283911111",
businessType = bt2,
CreateTime = DateTime.Now
});
context.SaveChanges();
}
}
private static void RemoveOrder(string name)
{
using (var context = new BusinessContext())
{
var b = context.business.OrderBy(a => a.CreateTime).FirstOrDefault(a => a.Name.Equals(name));
if (b == null)
{
throw new Exception("队列出现错误");
}
context.business.Remove(b);
context.SaveChanges();
}
}