public JsonResult GetDangerReasons(string categoryid)
{
var bll = new DangerMeasureBLL();
var data = bll.GetDangerReasons(categoryid);
return(Json(data, JsonRequestBehavior.AllowGet));
}
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)
}));
}
public JsonResult GetCategories(string categoryid)
{
var bll = new DangerMeasureBLL();
var data = bll.GetCategories(categoryid).OrderBy(x => x.Sort).ToList();
return(Json(data.Where(x => x.ParentCategoryId == null).Select(x => new TreeModel {
id = x.CategoryId.ToString(), value = x.CategoryId.ToString(), text = x.CategoryName, isexpand = data.Count(y => y.ParentCategoryId == x.CategoryId) > 0, hasChildren = data.Count(y => y.ParentCategoryId == x.CategoryId) > 0, ChildNodes = GetChildren(data, x.CategoryId)
}).ToList(), JsonRequestBehavior.AllowGet));
}
public ViewResult Edit(string id)
{
var model = default(DangerCategoryEntity);
if (string.IsNullOrEmpty(id))
{
model = new DangerCategoryEntity();
}
else
{
var guid = Guid.Parse(id);
var bll = new DangerMeasureBLL();
model = bll.GetCategory(guid);
}
return(View(model));
}
public JsonResult GetData(FormCollection fc)
{
var categoryid = fc.Get("categoryid");
var key = fc.Get("key");
var page = int.Parse(fc.Get("page") ?? "1");
var rows = int.Parse(fc.Get("rows") ?? "20");
var sortfield = fc.Get("sidx");
var direction = fc.Get("sord");
var bll = new DangerMeasureBLL();
var user = OperatorProvider.Provider.Current();
var total = 0;
var data = bll.GetData(categoryid, key, rows, page, out total, sortfield, direction);
return(Json(new { rows = data, records = total, total = Math.Ceiling((double)total / rows), page }));
}
/// <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));
}
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 JsonResult Remove(string id)
{
var bll = new DangerMeasureBLL();
var success = true;
var message = "删除成功";
try
{
bll.DeleteMeasure(id);
}
catch (Exception ex)
{
success = false;
message = ex.Message;
}
return(Json(new AjaxResult {
type = success ? ResultType.success : ResultType.error, message = HttpUtility.JavaScriptStringEncode(message)
}));
}
public JsonResult DoImport()
{
var success = true;
var message = "保存成功！";
var user = OperatorProvider.Provider.Current();
if (this.Request.Files.Count > 0)
{
var book = new Workbook(this.Request.Files[0].InputStream);
var sheet = book.Worksheets[0];
var bll = new DangerMeasureBLL();
try
{
var titleIndex = this.GetTitleRow(sheet);
var measuredata = this.GetMeasureData(sheet, titleIndex);
foreach (var item in measuredata)
{
item.OperateTime = DateTime.Now;
item.OperateUser = user.UserName;
item.OperateUserId = user.UserId;
}
bll.AddMeasures(measuredata);
}
catch (Exception e)
{
success = false;
message = e.Message;
}
}
return(Json(new AjaxResult()
{
type = success ? ResultType.success : ResultType.error, message = message
}));
}
public JsonResult Edit(string id, DangerCategoryEntity model)
{
var bll = new DangerMeasureBLL();
var success = true;
var message = "保存成功";
try
{
bll.Save(new DangerCategoryEntity()
{
CategoryName = model.CategoryName, CategoryId = id, Sort = model.Sort
});
}
catch (Exception ex)
{
success = false;
message = ex.Message;
}
return(Json(new AjaxResult {
type = success ? ResultType.success : ResultType.error, message = HttpUtility.JavaScriptStringEncode(message)
}));
}
