public JsonResult Edit2(string id, CategoryItemModel model)
{
var bll = new EvaluateBLL();
var success = true;
var message = "保存成功";
try
{
if (string.IsNullOrEmpty(id))
{
bll.AddItem(new EvaluateCategoryItemEntity()
{
CategoryId = model.Category.CategoryId, ItemContent = model.ItemContent, ItemStandard = model.ItemStandard, Score = model.Score, EvaluateDept = model.EvaluateDept, UseDept = model.UseDept, UseDeptId = model.UseDeptId
});
}
else
{
bll.EditItem(new EvaluateCategoryItemEntity()
{
ItemId = model.ItemId, CategoryId = model.Category.CategoryId, ItemContent = model.ItemContent, ItemStandard = model.ItemStandard, Score = model.Score, EvaluateDept = model.EvaluateDept, UseDept = model.UseDept, UseDeptId = model.UseDeptId
});
}
}
catch (Exception ex)
{
success = false;
message = ex.Message;
}
return(Json(new AjaxResult {
type = success ? ResultType.success : ResultType.error, message = HttpUtility.JavaScriptStringEncode(message)
}));
}
public JsonResult Import(string id)
{
DepartmentBLL dpbll = new DepartmentBLL();
var book = new Workbook(this.Request.Files[0].InputStream);
var sheet = book.Worksheets[0];
var sss = sheet.Cells[0, 0].StringValue;
var bll = new EvaluateBLL();
var categories = bll.GetAllCategories().ToList();
var success = true;
var message = "保存成功";
var user = OperatorProvider.Provider.Current();
var date = DateTime.Now;
try
{
var categoryname = string.Empty;
var categoryitems = new List <EvaluateCategoryItemEntity>();
for (int i = 1; i <= sheet.Cells.MaxRow; i++)
{
var currentcategory = sheet.Cells[i, 0].StringValue;
if (!string.IsNullOrWhiteSpace(currentcategory))
{
categoryname = currentcategory;
}
var category = categories.Find(x => x.Category == categoryname);
if (category == null)
{
throw new Exception(string.Format("不存在考评要素，行 {0}", i + 1));
}
var score = 0;
if (sheet.Cells[i, 3].Type == CellValueType.IsNumeric)
{
score = sheet.Cells[i, 3].IntValue;
}
var itemcontent = sheet.Cells[i, 1].StringValue;
if (string.IsNullOrEmpty(itemcontent))
{
throw new Exception(string.Format("考评内容不能为空，行 {0}", i + 1));
}
var khbz = sheet.Cells[i, 2].StringValue;
if (string.IsNullOrEmpty(khbz))
{
throw new Exception(string.Format("考评标准不能为空，行 {0}", i + 1));
}
var deptname = sheet.Cells[i, 5].StringValue;
var deptid = "";
if (!string.IsNullOrEmpty(deptname))
{
if (deptname.Contains(','))
{
string[] names = deptname.Split(',');
foreach (string name in names)
{
var dept = dpbll.GetList().Where(x => x.FullName == name && x.Nature == "班组").FirstOrDefault();
if (dept == null)
{
throw new Exception(string.Format("班组{1}不存在，行 {0}", i + 1, deptname));
}
else
{
deptid += dept.DepartmentId + ",";
}
}
if (deptid.EndsWith(","))
{
deptid = deptid.Substring(0, deptid.Length - 1);
}
}
else
{
var dept = dpbll.GetList().Where(x => x.FullName == deptname && x.Nature == "班组").FirstOrDefault();
if (dept == null)
{
throw new Exception(string.Format("班组{1}不存在，行 {0}", i + 1, deptname));
}
else
{
deptid = dept.DepartmentId;
}
}
}
var categoryitem = new EvaluateCategoryItemEntity()
{
ItemId = Guid.NewGuid().ToString(), CategoryId = category.CategoryId, ItemContent = sheet.Cells[i, 1].StringValue, ItemStandard = sheet.Cells[i, 2].StringValue, EvaluateDept = sheet.Cells[i, 4].StringValue, UseDept = deptname, UseDeptId = deptid, CreateUserId = user.UserId, CreateTime = date.AddSeconds(i), Score = score
};
categoryitems.Add(categoryitem);
}
bll.AddItem(categoryitems);
}
catch (Exception ex)
{
success = false;
message = ex.Message;
}
return(Json(new AjaxResult {
type = success ? ResultType.success : ResultType.error, message = HttpUtility.JavaScriptStringEncode(message)
}));
}