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 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();
}
}