//0修改失败，-1修改重复
public int editByBearing(Bearing bearing)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
var type = entities.Bearing.SingleOrDefault(bt => bt.Code == bearing.Code && bt.Deleted == 0 && bt.BearingId != bearing.BearingId);
if (type == null)
{
//实体绑定model
DbEntityEntry<Bearing> entry = entities.Entry<Bearing>(bearing);
//设置操作类型
entry.State = System.Data.Entity.EntityState.Unchanged;
//设置修改状态为ture 否则数据库不会更新
entry.Property("Code").IsModified = true;
entry.Property("Name").IsModified = true;
entry.Property("Status").IsModified = true;
entry.Property("UpdateBy").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
//关闭实体验证，不关闭验证需要整个对象全部传值
entities.Configuration.ValidateOnSaveEnabled = false;
flag = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
else
{
flag = -1;
}
}
return flag;
}
public int delByBearing(Bearing bearing)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//直接修改的方式
DbEntityEntry<Bearing> entry = entities.Entry<Bearing>(bearing);
entry.State = System.Data.Entity.EntityState.Unchanged;
//设置修改状态为ture 否则数据库不会更新
entry.Property("UpdateBy").IsModified = true;
entry.Property("Deleted").IsModified = true;
entry.Property("UpdateDatetime").IsModified = true;
try
{
//关闭实体验证，不关闭验证需要整个对象全部传值
entities.Configuration.ValidateOnSaveEnabled = false;
flag = entities.SaveChanges();
entities.Configuration.ValidateOnSaveEnabled = true;
}
catch (Exception ex)
{
ex.ToString();
}
}
return flag;
}
//0添加失败，-1添加重复
public int addBearing(Bearing bearing)
{
int flag = 0;
using (ChooseDishesEntities entities = new ChooseDishesEntities())
{
//查询编码是否存在
var type = entities.Bearing.SingleOrDefault(bt => bt.Code == bearing.Code && bt.Deleted == 0);
if (type == null)
{
//实体绑定MODEL
entities.Bearing.Add(bearing);
try
{
//操作数据库
flag = entities.SaveChanges();
}
catch (Exception ex)
{
ex.ToString();
}
}
else
{
flag = -1;
}
}
return flag;
}
