public ActionResult CheckEmployeeManage(long id)
{
if (Session["CheckFeed"] == null || !(bool) Session["CheckSystemManage"])
{
Response.Write("<script>history.go(0);</script>");
return View("Error");
}
var employeeService = new EmployeeService();
var roleService = new RoleService();
var listService = new ListService();
List<role> roles = roleService.FindByEmployeeId(id);
employee employee = employeeService.Find(id);
var employeeModel = new EmployeeModel
{
EmployeeId = employee.Id,
EmployeeNumber = employee.Number,
EmployeeName = employee.Name,
Rfid = employee.RFID,
Sex = employee.Sex,
ConfirmPassWd = employee.Password,
PassWd = employee.Password,
Logon = employee.LogOn,
Birthday = Convert.ToDateTime(employee.Birthday),
Memo = employee.Memo
};
List<long> roleType = roles.Select(role => role.role_type.Id).ToList();
employeeModel.RoleTypeId = roleType;
ViewData["Role"] = listService.GetRoleTypeList();
ViewData["Sex"] = listService.GetSexTypeList();
ViewBag.Title = "查看人员信息";
return View("AddNewEmployeeManage", employeeModel);
}
public EmployeeModel FindEmployeeById(long id)
{
var employeeService = new EmployeeService();
var roleService = new RoleService();
try
{
List<role> roles = roleService.FindByEmployeeId(id);
employee employee = employeeService.Find(id);
var employeeModel = new EmployeeModel
{
EmployeeId = employee.Id,
EmployeeNumber = employee.Number,
EmployeeName = employee.Name,
Rfid = employee.RFID,
Sex = employee.Sex,
ConfirmPassWd = employee.Password,
PassWd = employee.Password,
Logon = employee.LogOn,
state=employee.State,
Birthday = Convert.ToDateTime(employee.Birthday),
Memo = employee.Memo
};
List<long> roleType = roles.Select(role => role.role_type.Id).ToList();
employeeModel.RoleTypeId = roleType;
return employeeModel;
}
catch (Exception)
{
return null;
}
}
public bool SaveModifyEmployee(EmployeeModel model)
{
var employeeService = new EmployeeService();
var roleService = new RoleService();
string result = "";
try
{
//SHA512加密
if (model.ConfirmPassWd != null)
{
SHA512 sha512 = new SHA512Managed();
byte[] s = sha512.ComputeHash(Encoding.UTF8.GetBytes(model.ConfirmPassWd));
for (int i = 0; i < s.Length; i++)
{
result += s[i].ToString("X2");
}
sha512.Clear();
}
//修改人员信息
employee newemployee = employeeService.Find(model.EmployeeId);
newemployee.Name = model.EmployeeName;
newemployee.Number = model.EmployeeNumber;
newemployee.RFID = model.Rfid;
newemployee.LogOn = model.Logon;
newemployee.Sex = model.Sex;
newemployee.State = model.state;
newemployee.Birthday = Convert.ToDateTime(model.Birthday);
newemployee.Memo = model.Memo;
if (model.ConfirmPassWd != null)
{
newemployee.Password = result.ToLower();
}
employeeService.Update(newemployee);
//修改角色信息
//如果增加的角色类型数据库中没有，则插入该角色
foreach (long t in model.RoleTypeId)
{
List<role> roles = roleService.FindByEmployeeId(model.EmployeeId);
int flag = 1;
foreach (role role in roles)
{
if (t == role.RoleId)
{
flag = 0;
}
}
if (flag == 1)
{
var role = new role
{
EmployeeId = model.EmployeeId,
RoleId = t
};
roleService.Insert(role);
}
}
// 如果删除了一个角色类型，则在数据库删除对应的角色类型
List<role> anotherroles = roleService.FindByEmployeeId(model.EmployeeId);
foreach (role anotherrole in anotherroles)
{
int flag = 1;
long delete = anotherrole.RoleId;
for (int j = 0; j < model.RoleTypeId.Count; j++)
{
if (anotherrole.RoleId == model.RoleTypeId[j])
{
flag = 0;
}
}
if (flag == 1)
{
roleService = new RoleService();
roleService.Delete(
roleService.Find(roleService.FindByEmployeeIdAndRoleId(model.EmployeeId, delete).Id));
}
}
}
catch (Exception)
{
return false;
}
return true;
}
public ActionResult DelEmployeeManage(long id)
{
if (Session["CheckFeed"] == null || !(bool) Session["DelSystemManage"] ||
!(bool) Session["CheckSystemManage"])
{
Response.Write("<script>history.go(0);</script>");
return View("Error");
}
var employeeService = new EmployeeService();
var roleService = new RoleService();
employee employee = employeeService.Find(id);
List<role> roles = roleService.FindByEmployeeId(id);
//如果该员工有生产信息与之关联，则无法删除
if (employee.cure_pig.Count != 0 || employee.feed.Count != 0 || employee.fodder_take.Count != 0 ||
employee.inspection.Count != 0 || employee.prevention.Count != 0 || employee.sale.Count != 0 ||
employee.task.Count != 0 || employee.task_employee.Count != 0)
{
Response.Write("<script language='JavaScript'>alert('该员工有生产信息与之关联，无法删除.');history.go(-1);</script>");
return Content("nothing");
}
foreach (role role in roles)
{
roleService.Delete(role);
}
employeeService.Delete(employee);
return RedirectToAction("EmployeeManage");
}
public bool DelEmp(long id)
{
var employeeService = new EmployeeService();
var roleService = new RoleService();
employee employee = employeeService.Find(id);
List<role> roles = roleService.FindByEmployeeId(id);
//如果该员工有生产信息与之关联，则无法删除
if (employee.cure_pig.Count != 0 || employee.feed.Count != 0 || employee.fodder_take.Count != 0 ||
employee.inspection.Count != 0 || employee.prevention.Count != 0 || employee.sale.Count != 0 ||
employee.task.Count != 0 || employee.task_employee.Count != 0)
{
return false;
}
foreach (role role in roles)
{
roleService.Delete(role);
}
employeeService.Delete(employee);
return true;
}
/// <summary>
/// 修改喂食信息
/// </summary>
/// <param name="feedInfo">已修改的喂食信息页面类</param>
/// <param name="time">原时间</param>
/// <param name="employeeName">原喂食人员名字</param>
/// <returns></returns>
public bool UpdateFeedInfo(FeedInfo feedInfo, DateTime time, string employeeName)
{
var feedService = new FeedService();
var fodderTakeService = new FodderTakeService();
var employeeService = new EmployeeService();
var taskService = new TaskService();
int i = 0, j = 0;
employee firstOrDefault = employeeService.FindByName(employeeName).FirstOrDefault();
//var firstOrDefault = taskService.FindByTaskNumber(feedInfo.TaskNumber);
if (firstOrDefault != null)
{
foreach (fodder_take fodderTake in fodderTakeService.FindByEmployeeId(firstOrDefault.Id))
{
string num = fodderTake.task.TaskNumber;
if (!time.Date.Equals(fodderTake.Time.Date) && num != feedInfo.TaskNumber) continue;
if (i < feedInfo.TakeDetail.Count)
{
fodderTake.EmployeeId = long.Parse(feedInfo.EmployeeName);
fodderTake.FodderTypeId = long.Parse(feedInfo.TakeDetail[i].FodderType);
fodderTake.Quantity = feedInfo.TakeDetail[i].Quantity;
fodderTake.UnitId = long.Parse(feedInfo.TakeDetail[i].Unit);
fodderTake.Time = feedInfo.TakeDetail[i].TakeTime;
fodderTakeService.Update(fodderTake);
i++;
}
else
{
fodderTakeService = new FodderTakeService();
fodderTakeService.Delete(fodderTakeService.Find(fodderTake.Id));
}
}
for (; i < feedInfo.TakeDetail.Count; i++)
{
string num = feedInfo.TaskNumber ?? null;
long id = taskService.FindByTaskNumber(num).Id;
fodderTakeService.Insert(new fodder_take
{
TaskId = id,
EmployeeId = long.Parse(feedInfo.EmployeeName),
FodderTypeId = long.Parse(feedInfo.TakeDetail[i].FodderType),
Quantity = feedInfo.TakeDetail[i].Quantity,
UnitId = long.Parse(feedInfo.TakeDetail[i].Unit),
Time = feedInfo.TakeDetail[i].TakeTime
});
}
employee orDefault = employeeService.Find(long.Parse(feedInfo.EmployeeName));
if (orDefault != null)
foreach (feed feedItem in feedService.FindByEmployeeId(orDefault.Id))
{
string num = feedItem.task.TaskNumber;
if (!time.Date.Equals(feedItem.Time.Date) && num != feedInfo.TaskNumber) continue;
if (j < feedInfo.FeedPig.Count)
{
feedItem.EmployeeId = long.Parse(feedInfo.EmployeeName);
//feedItem.FodderTypeId = long.Parse(feedInfo.FeedPig[j].FodderType);
//feedItem.Quality = feedInfo.FeedPig[j].Quantity;
//feedItem.UnitId = long.Parse(feedInfo.FeedPig[j].Unit);
feedItem.PigstyId = long.Parse(feedInfo.FeedPig[j].Pigsty);
feedItem.Time = feedInfo.FeedPig[j].DetailTime;
feedItem.Memo = feedInfo.Meno;
feedService.Update(feedItem);
j++;
}
else
{
feedService = new FeedService();
feedService.Delete(feedService.Find(feedItem.Id));
}
}
for (; j < feedInfo.FeedPig.Count; j++)
{
string num = feedInfo.TaskNumber ?? null;
long id = taskService.FindByTaskNumber(num).Id;
feedService.Insert(new feed
{
TaskId = id,
EmployeeId = long.Parse(feedInfo.EmployeeName),
PigstyId = long.Parse(feedInfo.FeedPig[j].Pigsty),
//FodderTypeId = long.Parse(feedInfo.FeedPig[j].FodderType),
//Quality = feedInfo.FeedPig[j].Quantity,
//UnitId = long.Parse(feedInfo.FeedPig[j].Unit),
Time = feedInfo.FeedPig[j].DetailTime,
Memo = feedInfo.Meno
});
}
}
else
{
return false;
}
return true;
}
/// <summary>
/// 喂食信息管理列表
/// </summary>
/// <returns></returns>
public IEnumerable<Info> GetFeedInfoList()
{
var feedService = new FeedService();
var taskService = new TaskService();
var employeeService = new EmployeeService();
string taskNumber = "";
task task = null;
var feedInfoList = new List<Info>();
var employeeIds = new HashSet<long>();
foreach (feed employeeId in feedService.FindAll())
{
employeeIds.Add(employeeId.EmployeeId);
}
foreach (long employeeId in employeeIds)
{
feed item = feedService.FindByEmployeeId(employeeId).OrderByDescending(m => m.Time).FirstOrDefault();
if (item != null) task = taskService.Find(item.TaskId);
taskNumber = task != null ? task.TaskNumber : "";
if (item != null)
{
feedInfoList.Add(new Info
{
TaskNumber = taskNumber,
EmployeeName =
employeeService.Find(
item.
EmployeeId).Name,
Time = item.Time,
Meno = item.Memo
});
foreach (
feed feedInfoitem in feedService.FindByEmployeeId(employeeId).OrderByDescending(m => m.Time))
{
task = taskService.Find(feedInfoitem.TaskId);
taskNumber = task != null ? task.TaskNumber : "";
if (item.Time.Date.Equals(feedInfoitem.Time.Date) && item.TaskId == feedInfoitem.TaskId)
continue;
feedInfoList.Add(new Info
{
TaskNumber = taskNumber,
EmployeeName =
employeeService.Find(
feedInfoitem.
EmployeeId).Name,
Time = feedInfoitem.Time,
Meno = feedInfoitem.Memo
});
item = feedInfoitem;
}
}
}
return feedInfoList.OrderByDescending(m => m.Time);
}
/// <summary>
/// 新建喂食信息
/// </summary>
/// <param name="newFeedInfo"></param>
/// y
/// <returns></returns>
public bool CreateFeedInfo(FeedInfo newFeedInfo)
{
var employeeService = new EmployeeService();
var feedService = new FeedService();
var fodderTakeService = new FodderTakeService();
var taskService = new TaskService();
var fodderTypeService = new FodderTypeService();
var unitService = new UnitService();
var taskStatusTypeService = new TaskStatusTypeService();
long taskId = long.Parse(TaskNumber);
foreach (FodderTakeDetail takedetail in newFeedInfo.TakeDetail)
{
employee firstOrDefault = employeeService.Find(long.Parse(newFeedInfo.EmployeeName));
if (firstOrDefault != null)
{
var take = new fodder_take
{
TaskId = taskId,
EmployeeId = firstOrDefault.Id,
//FodderTypeId = fodderTypeService.Find(long.Parse(takedetail.FodderType)).Id,
//Quantity = takedetail.Quantity,
//UnitId = unitService.Find(long.Parse(takedetail.Unit)).Id,
Time = takedetail.TakeTime
};
fodderTakeService.Insert(take);
}
}
foreach (FeedInfoDetail feedPigDetail in FeedPig)
{
var feedinfo = new feed {TaskId = taskId};
employee firstOrDefault = employeeService.Find(long.Parse(newFeedInfo.EmployeeName));
if (firstOrDefault != null)
feedinfo.EmployeeId = firstOrDefault.Id;
feedinfo.PigstyId = long.Parse(feedPigDetail.Pigsty);
//feedinfo.FodderTypeId = long.Parse(feedPigDetail.FodderType);
//feedinfo.Quality = feedPigDetail.Quantity;
//feedinfo.UnitId = long.Parse(feedPigDetail.Unit);
feedinfo.Memo = newFeedInfo.Meno;
feedinfo.Time = feedPigDetail.DetailTime;
feedService.Insert(feedinfo);
}
task_status_type taskStatusType = taskStatusTypeService.FindByName("正在进行");
task task = taskService.Find(long.Parse(newFeedInfo.TaskNumber));
if (taskStatusType != null && task != null)
{
task.TaskStatusId = taskStatusType.Id;
taskService.Update(task);
}
return true;
}
