public ResultObj Add(OilStation obj)
{
// 获取当前登录用户名
string _currentUserName = CommonService.GetCurrentUser(HttpContext).UserName;
ResultObj resultObj = new ResultObj();
if (IsExistSame(obj))
{
resultObj.IsSuccess = false;
resultObj.ErrMsg = "该站名已存在。";
return(resultObj);
}
obj.CreateUser = _currentUserName;
obj.CreateTime = DateTime.Now;
obj.LastUpdateUser = _currentUserName;
obj.LastUpdateTime = DateTime.Now;
_context.OilStation.Add(obj);
_context.SaveChanges();
resultObj.IsSuccess = true;
return(resultObj);
}
// 判断是否存在相同站名
public bool IsExistSame(OilStation obj)
{
var where = _context.OilStation.Where(p => p.Name == obj.Name);
if (obj.PK != null)
{
where = where.Where(p => p.PK != obj.PK);
}
List <OilStation> list = where.ToList();
if (list.Count > 0)
{
return(true);
}
return(false);
}
public ResultObj Update(OilStation newObj)
{
// 获取当前登录用户名
string _currentUserName = CommonService.GetCurrentUser(HttpContext).UserName;
ResultObj resultObj = new ResultObj();
var obj = _context.OilStation.Find(newObj.PK);
if (obj == null)
{
resultObj.IsSuccess = false;
resultObj.ErrMsg = "修改对象不存在。";
return(resultObj);
}
if (IsExistSame(newObj))
{
resultObj.IsSuccess = false;
resultObj.ErrMsg = "该站名已存在。";
return(resultObj);
}
obj.Branch = newObj.Branch;
obj.Name = newObj.Name;
obj.District = newObj.District;
obj.PLCIP = newObj.PLCIP;
obj.HMIIP = newObj.HMIIP;
obj.VolumnPer1cm = newObj.VolumnPer1cm;
obj.LevelCalcFactor = newObj.LevelCalcFactor;
obj.LevelCalcOffset = newObj.LevelCalcOffset;
obj.PumpRatedFlow = newObj.PumpRatedFlow;
obj.PumpCalcFactor = newObj.PumpCalcFactor;
obj.PumpCalcOffset = newObj.PumpCalcOffset;
obj.Latitude = newObj.Latitude;
obj.Longitude = newObj.Longitude;
obj.Remark = newObj.Remark;
obj.LastUpdateTime = DateTime.Now;
obj.LastUpdateUser = _currentUserName;
_context.OilStation.Update(obj);
_context.SaveChanges();
resultObj.IsSuccess = true;
return(resultObj);
}
