public void AddItem(EvaluateCategoryItemEntity model)
{
model.ItemId = Guid.NewGuid().ToString();
model.CreateUserId = OperatorProvider.Provider.Current().UserId;
model.CreateTime = DateTime.Now;
service.AddItem(model);
}
/// <summary>
/// 根据前后打分记录，添加修正记录
/// </summary>
/// <param name="oldMarks">修正前</param>
/// <param name="newMarks">修正后</param>
public void Insert(EvaluateMarksRecordsEntity oldMarks, EvaluateMarksRecordsEntity newMarks)
{
var db = new RepositoryFactory().BaseRepository();
//Operator user = OperatorProvider.Provider.Current();
EvaluateItemEntity evaluateItemEntity = null;
evaluateItemEntity = db.FindEntity <EvaluateItemEntity>(oldMarks.EvaluateItemId);
EvaluateCategoryItemEntity categoryItemEntity = null;
categoryItemEntity = db.FindEntity <EvaluateCategoryItemEntity>(evaluateItemEntity.EvaluateContentId);
EvaluateCategoryEntity categoryEntity = null;
categoryEntity = db.FindEntity <EvaluateCategoryEntity>(categoryItemEntity.CategoryId);
EvaluateGroupEntity evaluateGroup = null;
evaluateGroup = db.FindEntity <EvaluateGroupEntity>(evaluateItemEntity.EvaluateGroupId);
EvaluateEntity evaluate = null;
evaluate = db.FindEntity <EvaluateEntity>(evaluateGroup.EvaluateId);
EvaluateReviseEntity reviseEntity = new EvaluateReviseEntity()
{
Id = Guid.NewGuid().ToString(),
Category = categoryEntity?.Category,
CategoryId = categoryEntity?.CategoryId,
CreateDate = DateTime.Now,
CreateUser = newMarks.CreateUserName,
CreateUserId = newMarks.CreateUserId,
DepartmentId = evaluateGroup?.DeptId,
DepartmentName = evaluateGroup?.DeptName,
DeptCause = oldMarks.Cause,
DeptEvaluateUserId = oldMarks.CreateUserId,
DeptEvaluteUser = oldMarks.CreateUserName,
DeptScore = oldMarks.Score,
EvaluteContent = evaluateItemEntity?.EvaluateContent,
EvaluteContentId = evaluateItemEntity?.EvaluateContentId,
GroupId = evaluateGroup?.GroupId,
GroupName = evaluateGroup?.GroupName,
ReviseCause = newMarks.Cause,
ReviseScore = newMarks.Score,
ReviseUser = newMarks.CreateUserName,
ReviseUserId = newMarks.CreateUserId,
StandardScore = evaluateItemEntity.Score,
EvaluateId = evaluate.EvaluateId,
EvaluateSeason = evaluate.EvaluateSeason
};
this.BaseRepository().Insert(reviseEntity);
}
/// <summary>
/// 如果是公司级删除的部门级的数据，则会新增一条，否则的话就不会新增
/// </summary>
/// <param name="entity">所删除的部门级的数据</param>
public void Insert(string deptid, EvaluateMarksRecordsEntity entity)
{
var db = new RepositoryFactory().BaseRepository();
//Operator user = OperatorProvider.Provider.Current();
DepartmentEntity userDept = db.FindEntity <DepartmentEntity>(deptid);
if (entity.IsOrg == 0 && userDept.IsSpecial)//如果数据时部门级的，但是删除的用户的是部门级的，则添加一条记录
{
EvaluateItemEntity evaluateItemEntity = null;
evaluateItemEntity = db.FindEntity <EvaluateItemEntity>(entity.EvaluateItemId);
EvaluateCategoryItemEntity categoryItemEntity = null;
categoryItemEntity = db.FindEntity <EvaluateCategoryItemEntity>(evaluateItemEntity.EvaluateContentId);
EvaluateCategoryEntity categoryEntity = null;
categoryEntity = db.FindEntity <EvaluateCategoryEntity>(categoryItemEntity.CategoryId);
EvaluateGroupEntity evaluateGroup = null;
evaluateGroup = db.FindEntity <EvaluateGroupEntity>(evaluateItemEntity.EvaluateGroupId);
EvaluateEntity evaluate = null;
evaluate = db.FindEntity <EvaluateEntity>(evaluateGroup.EvaluateId);
EvaluateReviseEntity reviseEntity = new EvaluateReviseEntity()
{
Id = Guid.NewGuid().ToString(),
Category = categoryEntity?.Category,
CategoryId = categoryEntity?.CategoryId,
CreateDate = DateTime.Now,
CreateUser = entity.CreateUserName,
CreateUserId = entity.CreateUserId,
DepartmentId = evaluateGroup?.DeptId,
DepartmentName = evaluateGroup?.DeptName,
DeptCause = entity.Cause,
DeptEvaluateUserId = entity.CreateUserId,
DeptEvaluteUser = entity.CreateUserName,
DeptScore = entity.Score,
EvaluteContent = evaluateItemEntity?.EvaluateContent,
EvaluteContentId = evaluateItemEntity?.EvaluateContentId,
GroupId = evaluateGroup?.GroupId,
GroupName = evaluateGroup?.GroupName,
ReviseCause = "该打分项在 " + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + " 被 " + entity.CreateUserName + " 删除",
ReviseUser = entity.CreateUserName,
ReviseUserId = entity.CreateUserId,
StandardScore = evaluateItemEntity.Score,
IsDeleteType = 1,//删除数据
EvaluateId = evaluate.EvaluateId,
EvaluateSeason = evaluate.EvaluateSeason
};
this.BaseRepository().Insert(reviseEntity);
}
}
public void EditItem(EvaluateCategoryItemEntity model)
{
service.EditItem(model);
}
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)
}));
}
