/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <param name="sid"></param>
public static void UpdateModel(Base_Status model, int sid)
{
using (DBContext dbContext = new DBContext())
{
Base_Status editmodel = dbContext.Base_Status.Where(u => u.id == sid).FirstOrDefault();
if (editmodel == null)
{
return;//空
}
editmodel.StatusName = model.StatusName;
editmodel.Remark = model.Remark;
//提交修改
dbContext.SaveChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="sid"></param>
/// <returns></returns>
public static string GetStatusName(int?sid)
{
string returnFlag = "";
using (DBContext dbContext = new DBContext())
{
//if (sid == null)
//{
// return "";
//}
Base_Status model = dbContext.Base_Status.Where(u => u.id == sid).FirstOrDefault();
if (model != null)
{
returnFlag = model.StatusName;
}
}
return(returnFlag);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sid"></param>
/// <returns></returns>
public static bool DeleteModel(int sid)
{
bool returnFlag = false;
using (DBContext dbContext = new DBContext())
{
Base_Status model = dbContext.Base_Status.Where(u => u.id == sid).FirstOrDefault();
if (model != null)
{
dbContext.Base_Status.Remove(model);
dbContext.SaveChanges();
returnFlag = true;
}
}
return(returnFlag);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddModel(Base_Status model)
{
bool returnFlag = false;
using (DBContext dbContext = new DBContext())
{
Base_Status NewModel = new Base_Status()
{
StatusName = model.StatusName,
Remark = model.Remark
};
//增加
dbContext.Base_Status.Add(NewModel);
dbContext.SaveChanges();
returnFlag = true;
}
return(returnFlag);
}
