public void AddRow()
{
if (RoomTypes.Count() > 0)
{
if (RoomTypes[RoomTypes.Count() - 1].Name == null && RoomTypes[RoomTypes.Count() - 1].Color == null)
{
new MessageWindow(thiswindow, "有空行还未填写").ShowDialog();
return;
}
else if (RoomTypes[RoomTypes.Count() - 1].Name == null)
{
new MessageWindow(thiswindow, "房间状态不能为空").ShowDialog();
return;
}
}
RoomType rt = new RoomType()
{
ID = Guid.NewGuid(),
Color = "默认(灰色)"
};
RoomTypes.Add(rt);
}
public void UpdateData()
{
if (RoomTypes[RoomTypes.Count() - 1].Name == null && RoomTypes[RoomTypes.Count() - 1].Cap <= 0)
{
new MessageWindow(thiswindow, "有空行还未填写").ShowDialog();
return;
}
else if (RoomTypes[RoomTypes.Count() - 1].Name == null)
{
new MessageWindow(thiswindow, "房间状态不能为空").ShowDialog();
return;
}
Guid[] names = new Guid[GetRoomTypes.Count()];
for (int i = 0; i < GetRoomTypes.Count(); i++)
{
names[i] = GetRoomTypes[i].ID;
}
using (RetailContext context = new RetailContext())
{
foreach (RoomType rs in RoomTypes)
{
if (names.Contains(rs.ID))
{
string sql = string.Format("update RoomTypes set Name = '{0}',Cap = {1} where UPPER(HEX([ID]))='{2}'", rs.Name, rs.Cap, rs.ID.ConvertGuid());
context.Database.ExecuteSqlCommand(sql);
}
else
{
context.RoomTypes.Add(rs);
}
}
context.SaveChanges();
}
LoadData();
}
