public void SaveMeasure(DangerMeasureEntity model)
{
using (var ctx = new DataContext())
{
if (ctx.DangerMeasures.Count(x => x.MeasureId != model.MeasureId && x.CategoryId == model.CategoryId && x.DangerReason == model.DangerReason) > 0)
{
throw new Exception("该风险因素已存在！");
}
var entity = ctx.DangerMeasures.Find(model.MeasureId);
if (entity == null)
{
entity = new DangerMeasure()
{
MeasureId = Guid.NewGuid().ToString(), MeasureContent = model.MeasureContent, CategoryId = model.CategoryId, DangerReason = model.DangerReason, OperateTime = model.OperateTime, OperateUser = model.OperateUser, OperateUserId = model.OperateUserId
};
ctx.DangerMeasures.Add(entity);
}
else
{
entity.MeasureContent = model.MeasureContent;
entity.DangerReason = model.DangerReason;
entity.CategoryId = model.CategoryId;
entity.OperateTime = model.OperateTime;
entity.OperateUser = model.OperateUser;
entity.OperateUserId = model.OperateUserId;
ctx.Entry(entity).State = EntityState.Modified;
}
int a = ctx.SaveChanges();
}
}
public JsonResult Edit2(string id, DangerMeasureEntity model)
{
var bll = new DangerMeasureBLL();
var user = OperatorProvider.Provider.Current();
var success = true;
var message = "保存成功";
try
{
model.OperateUserId = user.UserId;
model.OperateUser = user.UserName;
model.OperateTime = DateTime.Now;
bll.SaveMeasure(model);
}
catch (Exception ex)
{
success = false;
message = ex.Message;
}
return(Json(new AjaxResult {
type = success ? ResultType.success : ResultType.error, message = HttpUtility.JavaScriptStringEncode(message)
}));
}
/// <summary>
/// 风险预控措施
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ViewResult Edit2(string id)
{
DangerMeasureEntity model = null;
if (!string.IsNullOrEmpty(id))
{
var bll = new DangerMeasureBLL();
model = bll.GetMeasureDetail(id);
}
else
{
model = new DangerMeasureEntity();
}
return(View(model));
}
public DangerMeasureEntity GetMeasureDetail(string measureid)
{
var result = default(DangerMeasureEntity);
using (var ctx = new DataContext())
{
var entity = ctx.DangerMeasures.Include("Category").FirstOrDefault(x => x.MeasureId == measureid);
if (entity != null)
{
result = new DangerMeasureEntity()
{
MeasureId = entity.MeasureId, MeasureContent = entity.MeasureContent, CategoryId = entity.Category.CategoryId, Category = entity.Category.CategoryName, DangerReason = entity.DangerReason, OperateTime = entity.OperateTime, OperateUser = entity.OperateUser
};
}
}
return(result);
}
private List <DangerMeasureEntity> GetMeasureData(Worksheet sheet, int titleIndex)
{
var result = new List <DangerMeasureEntity>();
var bll = new DangerMeasureBLL();
var categories = bll.GetCategories(null);
for (int i = titleIndex + 1; i <= sheet.Cells.MaxDataRow; i++)
{
var measure = new DangerMeasureEntity()
{
MeasureId = Guid.NewGuid().ToString(),
Category = sheet.Cells[i, 0].StringValue,
DangerReason = sheet.Cells[i, 1].StringValue,
MeasureContent = sheet.Cells[i, 2].StringValue
};
if (string.IsNullOrEmpty(measure.DangerReason))
{
throw new Exception(string.Format("行 {0} 风险因素为空！", i + 1));
}
var category = categories.FirstOrDefault(x => x.CategoryName == measure.Category);
if (category == null)
{
throw new Exception(string.Format("行 {0} 风险类别不存在！", i + 1));
}
else
{
measure.CategoryId = category.CategoryId;
}
if (bll.ExistDangerReason(measure.CategoryId, measure.DangerReason))
{
throw new Exception(string.Format("行 {0} 风险因素已存在！", i + 1));
}
if (result.Count(x => x.CategoryId == measure.CategoryId && x.DangerReason == measure.DangerReason) > 0)
{
throw new Exception(string.Format("行 {0} 风险因素重复！", i + 1));
}
result.Add(measure);
}
return(result);
}
public void SaveMeasure(DangerMeasureEntity model)
{
IDangerMeasureService service = new DangerMeasureService();
service.SaveMeasure(model);
}
