public ActionResult Delete(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<TrainNotice>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以删除的培训通知。");
return Close();
}
var notices = string.Join(", ", models.Select(m => m.Title));
if (models.Any(model => !session.Delete(model)))
{
session.Rollback();
FlashError("删除培训通知{0}失败！", notices);
return View(models);
}
session.Commit();
FlashSuccess("删除培训通知{0}成功！", notices);
return Close();
}
}
public ActionResult Delete(long[] ids, long id = 0)
{
if (ids.Length == 0)
{
FlashInfo("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<PunishmentDossierFiles>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以删除的记录。");
return Close();
}
if (models.Any(m => !m.CreatedBy.Equals(CurrentAccountNo)))
{
FlashInfo("你不是创建人，不能删除{0}", string.Join(",", models.Where(m => !m.CreatedBy.Equals(CurrentAccountNo)).Select(m => m.FileName)));
return Close();
}
var contract = session.Load<PunishmentDossier>(id);
if (contract == null)
{
FlashWarn("材料未找到，请联系管理员！");
return Close();
}
if (!IsEditAble(contract))
{
FlashInfo("材料已经提交，相关文件不能删除！");
return Close();
}
return View(models);
}
}
public ActionResult Delete(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<TrainManagement>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以删除的记录。");
return Close();
}
var displays = string.Join(", ", models.Select(m => string.Concat(m.Id)));
if (session.Delete<TrainManagement>(m => m.Id.In(ids)))
{
session.Commit();
FlashSuccess("删除记录{0}成功！", displays);
return Close();
}
session.Rollback();
FlashError("删除记录{0}失败！", displays);
return View(models);
}
}
public ActionResult Active(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要激活的用户。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<User>(m => m.Id.In(ids) && !m.IsActive);
if (models.Count == 0)
{
FlashInfo("你没有选择任何需要激活的用户。");
return Close();
}
foreach (User model in models)
{
if (!model.Active(session, CurrentAccountNo))
{
session.Rollback();
FlashError("账户激活失败！");
return Close();
}
}
session.Commit();
FlashSuccess("账户激活成功");
return Close();
}
}
public ActionResult AnalysisByYear(FormCollection collection)
{
using (var session = new SessionFactory().OpenSession())
{
var contractList = session.Find<Contract>();
var dossierList = session.Find<Dossier>();
var punishmentDossierList = session.Find<PunishmentDossier>();
var recordList = session.Find<Record>();
var startYear = contractList.Min(m => m.Time).Year;
var endYear = contractList.Max(m => m.Time).Year;
var list = new List<Analysis>();
return View(list);
}
}
public ActionResult Edit(long[] ids)
{
using (var session = new SessionFactory().OpenSession())
{
var model = session.Load<TrainManagementItem>(ids[0]);
if (model.ExamStatus != null && !model.ExamStatus.Equals(ExamStatusConst.未考试))
{
FlashWarn("您已经完成该考试！");
return Close();
}
var q = new Criteria<Exam>(session)
.AndIn<TrainManagementItem>(m => m.TrainManId, n => n.TrainManId, n => n.Id == ids[0]);
var exam = q.Load();
if (exam == null)
{
FlashWarn("考试不存在！请联系管理员！");
return Close();
}
var models = session.Find<Question>(m => m.ExamId == exam.Id);
if (models == null || !models.Any())
{
FlashWarn("考试题目未设置！");
return Close();
}
Response.Write(string.Format("<script>window.open('Exam?ids={0}','_blank')</script>", ids[0]));
return Close();
}
}
public static SelectList BrandList()
{
Session ds = new SessionFactory().OpenSession();
IList<SupplierBrand> d = ds.Find<SupplierBrand>();
var item = new SupplierBrand {Id = 0, Brand = "无"};
d.Add(item);
return new SelectList(d, "Id", "Brand");
}
public static SelectList SupplierList()
{
Session ds = new SessionFactory().OpenSession();
IList<Supplier> d = ds.Find<Supplier>();
var item = new Supplier {Id = 0, Name = "无"};
d.Add(item);
return new SelectList(d, "Id", "Name");
}
public static SelectList RoleList()
{
var ds = new SessionFactory().OpenSession();
var d = ds.Find<Role>();
var item = new Role() { Id = 0, Name = "无" };
d.Add(item);
return new SelectList(d, "Id", "Name");
}
public static SelectList OrganizationList()
{
Session ds = new SessionFactory().OpenSession();
IList<Organization> d = ds.Find<Organization>();
var item = new Organization {Id = 0, Name = "无"};
d.Add(item);
return new SelectList(d, "Id", "Name");
}
public ActionResult AnalysisByMonth(FormCollection collection)
{
using (var session = new SessionFactory().OpenSession())
{
var year = (collection["year"] + string.Empty).Trim().TryToInt();
if (!year.HasValue)
{
FlashWarn("年份有误,请选择年份!");
return Close();
}
var contractList = session.Find<Contract>();
var dossierList = session.Find<Dossier>();
var punishmentDossierList = session.Find<PunishmentDossier>();
var recordList = session.Find<Record>();
var list = new List<Analysis>();
for (int i = 1; i < 13; i++)
{
var item = new Analysis
{
Month = i + "月",
ContractNo = contractList.Count(m => m.Time.Year == year && m.Time.Month == i),
DossierNo = dossierList.Count(m => m.Time.Year == year && m.Time.Month == i),
PunishmentDossier = punishmentDossierList.Count(m => m.Time.Year == year && m.Time.Month == i),
RecordNo = recordList.Count(m => m.Time.Year == year && m.Time.Month == i)
};
list.Add(item);
}
var total =
new Analysis
{
Month = "合计",
ContractNo = contractList.Count(m => m.Time.Year == year),
DossierNo = dossierList.Count(m => m.Time.Year == year),
PunishmentDossier = punishmentDossierList.Count(m => m.Time.Year == year),
RecordNo = recordList.Count(m => m.Time.Year == year)
};
list.Add(total);
return View(list);
}
}
public ActionResult Exam(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("考试不存在！请联系管理员！");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<ExamAnswer>(m => m.TrainManagementItemId == ids[0]);
if (models == null || !models.Any())
{
FlashWarn("用户答题记录不在在！请联系管理员！");
return Close();
}
var trainManagementItem = session.Load<TrainManagementItem>(ids[0]);
if (trainManagementItem == null)
{
FlashWarn("用户答题记录不在在！请联系管理员！");
return Close();
}
trainManagementItem.ExamScore = 0;
foreach (var question in models)
{
var score = GetDbQueryPara(question.Id + "");
try
{
question.Score = score==null||score.Equals("")?0:Decimal.Parse(score);
trainManagementItem.ExamScore += question.Score;
}
catch (Exception)
{
FlashError("评分输入错误！");
return Close();
}
}
trainManagementItem.ExamStatus = ExamStatusConst.已评阅;
trainManagementItem.UpdatedAt = DateTime.Now;
trainManagementItem.UpdatedBy = "SYSTEM";
if (session.Update(trainManagementItem) && session.Update(models))
{
session.Commit();
Response.Write("<script>window.close()</script>");
return Close();
}
session.Rollback();
FlashError("提交试卷不成功，请联系管理员！");
return View(models);
}
}
public ActionResult AnalysisByMonth(FormCollection collection)
{
using (var session = new SessionFactory().OpenSession())
{
var year = (collection["year"] + string.Empty).Trim().TryToInt();
if (!year.HasValue)
{
FlashWarn("年份有误,请选择年份!");
return Close();
}
var contractList = session.Find<Contract>();
var dossierList = session.Find<Dossier>();
var punishmentDossierList = session.Find<PunishmentDossier>();
var recordList = session.Find<Record>();
var list = new List<Analysis>();
return View(list);
}
}
public ActionResult Delete(long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
ViewData.Model = session.Find<SchoolDepartment>(m => m.Id.In(ids));
return View();
}
}
public ActionResult AnalysisByYear(FormCollection collection)
{
using (var session = new SessionFactory().OpenSession())
{
var contractList = session.Find<Contract>();
var dossierList = session.Find<Dossier>();
var punishmentDossierList = session.Find<PunishmentDossier>();
var recordList = session.Find<Record>();
var startYear = contractList.Min(m => m.Time).Year;
var endYear = contractList.Max(m => m.Time).Year;
var list = new List<Analysis>();
for (int i = startYear; i <= endYear; i++)
{
var item = new Analysis
{
Year = i + "年",
ContractNo = contractList.Count(m => m.Time.Year == i),
DossierNo = dossierList.Count(m => m.Time.Year == i),
PunishmentDossier = punishmentDossierList.Count(m => m.Time.Year == i),
RecordNo = recordList.Count(m => m.Time.Year == i)
};
list.Add(item);
}
var total =
new Analysis
{
Year = "合计",
ContractNo = contractList.Count(),
DossierNo = dossierList.Count(),
PunishmentDossier = punishmentDossierList.Count(),
RecordNo = recordList.Count()
};
list.Add(total);
return View(list);
}
}
public ActionResult Create(FormCollection collection)
{
var model = new TrainNeed();
TryUpdateModel(model, collection.ToValueProvider());
if (!ModelState.IsValid)
{
return View(model);
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var dept = new Criteria<Department>(session)
.AndIn<User>(m => m.Id, n => n.DepartmentId, m => m.Code.Equals(CurrentAccountNo)).Load();
var models = session.Find<TrainNeed>(m => !m.IsCollected && m.Status.Equals(TrainNeedStatus.已提交部门负责人) && m.DeptId == dept.Id && m.Type.Equals(TrainNeedType.员工));
if (models == null || !models.Any())
{
FlashWarn("没有未汇总的需求!");
return Close();
}
foreach (var trainNeed in models)
{
trainNeed.IsCollected = true;
}
model.DeptId = dept != null ? dept.Id : 0;
model.Dept = dept != null ? dept.Name : null;
model.IsCollected = false;
model.CreatedAt = DateTime.Now;
model.CreatedBy = CurrentAccountNo;
model.Type = TrainNeedType.部门;
ViewData.Model = model;
ViewData["StaffNeeds"] = models;
var exist = session.Load<TrainNeed>(m => m.Type.Equals(TrainNeedType.部门) && m.DeptId.Equals(model.DeptId) && m.Year.Equals(model.Year));
if (exist != null)
{
ModelState.AddModelError("Year", "本部门该年度部门培训需求已经存在！");
return View(model);
}
if (session.Create(model) && session.Update(models))
{
session.Commit();
FlashSuccess("创建记录成功！");
return Close();
}
session.Rollback();
FlashFailure("创建记录失败！");
return View();
}
}
public ActionResult Create()
{
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<TrainNeed>(m =>
!m.IsCollected && m.Status.Equals(TrainNeedStatus.已提交培训部门) && m.Type.Equals(TrainNeedType.部门));
if (models == null || !models.Any())
{
FlashWarn("没有未汇总的需求!");
return Close();
}
ViewData["StaffNeeds"] = models;
return View();
}
}
public ActionResult Create(FormCollection collection)
{
var model = new TrainNeed();
TryUpdateModel(model, collection.ToValueProvider());
if (!ModelState.IsValid)
{
return View(model);
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<TrainNeed>(m =>
!m.IsCollected && m.Status.Equals(TrainNeedStatus.已提交培训部门) && m.Type.Equals(TrainNeedType.部门));
if (models == null || !models.Any())
{
FlashWarn("没有未汇总的需求!");
return Close();
}
foreach (var trainNeed in models)
{
trainNeed.IsCollected = true;
}
model.IsCollected = false;
model.CreatedAt = DateTime.Now;
model.CreatedBy = CurrentAccountNo;
model.Type = TrainNeedType.公司;
ViewData["StaffNeeds"] = models;
ViewData.Model = model;
var exist = session.Load<TrainNeed>(m => m.Type.Equals(TrainNeedType.公司) && m.Year.Equals(model.Year));
if (exist != null)
{
ModelState.AddModelError("Year", "该年度公司培训需求已经存在！");
return View(model);
}
if (session.Create(model) && session.Update(models))
{
session.Commit();
FlashSuccess("创建记录成功！");
return Close();
}
session.Rollback();
FlashFailure("创建记录失败！");
return View();
}
}
public ActionResult Edit(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要修改的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var model = session.Find<TrainStudyFiles>(m => m.ParentId == ids[0]);
if (model == null || model.Count == 0)
{
FlashInfo("没有任何学习课件！");
return Close();
}
return View(model);
}
}
public ActionResult Details(long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要操作的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<StandardFile>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashWarn("没有可以查看的记录。");
return Close();
}
return ShowWord(models[0].HtmlFilePath);
}
}
public ActionResult Delete(long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var model = session.Find<Role>(m => m.Id.In(ids) && !m.CreatedBy.Equals("SYSTEM"));
if (model == null || model.Count == 0)
{
FlashFailure("你要删除的角色不存在或者已被删除！");
return Close();
}
return View(model);
}
}
public ActionResult Details(long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要操作的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<School>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashWarn("没有可以查看的记录。");
return Close();
}
return View(models);
}
}
public ActionResult Delete(long[] ids)
{
if (ids.Length == 0)
{
FlashInfo("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<TrainManagement>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以删除的记录。");
return Close();
}
return View(models);
}
}
public ActionResult Approve(FormCollection collection, long[] ids)
{
if (ids == null || ids.Length == 0)
{
FlashWarn("请选择要审核的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<Contract>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以审核的记录。");
session.Rollback();
return Close();
}
if (models.Any(m => !CanApprove(m)))
{
FlashWarn("无法审核,请检查所选记录状态!");
session.Rollback();
return Close();
}
foreach (var model in models)
{
model.State = ContractStateConst.承办部门审核;
model.ApproveState = ApproveStateConst.已审核;
model.ApprovePerson1 = CurrentAccountNo.GetName();
model.UpdatedAt = DateTime.Now;
model.UpdatedBy = CurrentAccountNo;
}
if (session.Update(models))
{
FlashSuccess("记录审核成功");
session.Commit();
return Close();
}
FlashFailure("审核失败,请联系管理员!");
session.Rollback();
return Close();
}
}
public ActionResult Approve(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要审核的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<StandardFile>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以审核的记录。");
return Close();
}
if (!models.All(CanApprove))
{
FlashInfo("所选文件状态有误，请检查！");
return Close();
}
var displays = string.Join(", ", models.Select(m => m.FileName));
foreach (var model in models)
{
model.ApproveState = ApproveStateConst.已审核;
model.UpdatedAt = DateTime.Now;
model.UpdatedBy = CurrentAccountNo;
}
if (!session.Update(models))
{
session.Rollback();
FlashError("审核记录{0}失败！", displays);
return View(models);
}
session.Commit();
FlashSuccess("审核记录{0}成功！", displays);
return Close();
}
}
public ActionResult Approve(FormCollection collection, long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要审核的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
session.BeginTransaction();
var models = session.Find<TrainExperience>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以审核的记录。");
return Close();
}
if (!models.All(CanApprove))
{
FlashWarn("所选记录不能审核，请检查记录状态！");
return Close();
}
foreach (var item in models)
{
item.ApproveStatus = ApproveStateConst.已审核;
item.UpdatedAt = DateTime.Now;
item.UpdatedBy = CurrentAccountNo;
}
if (session.Update(models))
{
session.Commit();
FlashSuccess("审核成功");
return Close();
}
session.Rollback();
FlashError("审核失败，请联系管理员！");
return Close();
}
}
/* [Priviledge(Name = "查看培训试卷评改", IsEntry = true, Position = 15)]
public ActionResult Details(long[] ids)
{
if (ids.Length == 0)
{
FlashWarn("请选择要操作的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<ExamAnswer>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashWarn("没有可以查看的记录。");
return Close();
}
return View(models);
}
}*/
public ActionResult Exam(long[] ids)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<Exam>(session)
.AndIn<TrainManagementItem>(m => m.TrainManId, n => n.TrainManId, n => n.Id == ids[0]);
var exam = q.Load();
if (exam == null)
{
FlashWarn("考试不存在！请联系管理员！");
return Close();
}
ViewData["ExamContent"] = exam.AnswerHtmlContent;
var models = session.Find<ExamAnswer>(m => m.TrainManagementItemId == ids[0]);
if (models == null || !models.Any())
{
FlashWarn("用户答题记录不在在！请联系管理员！");
return Close();
}
return View(models);
}
}
public ActionResult Create()
{
using (var session = new SessionFactory().OpenSession())
{
var dept = new Criteria<Department>(session)
.AndIn<User>(m => m.Id, n => n.DepartmentId, m => m.Code.Equals(CurrentAccountNo)).Load();
if (dept == null)
{
FlashWarn("您不属于任何部门,请联系管理员!");
return Close();
}
var models = session.Find<TrainNeed>(m => !m.IsCollected && m.Status.Equals(TrainNeedStatus.已提交部门负责人) && m.DeptId == dept.Id && m.Type.Equals(TrainNeedType.员工));
if (models == null || !models.Any())
{
FlashWarn("没有未汇总的需求!");
return Close();
}
ViewData["StaffNeeds"] = models;
return View();
}
}
public ActionResult Delete(long[] ids)
{
if (ids.Length == 0)
{
FlashInfo("请选择要删除的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<TrainExperienceView>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以删除的记录。");
return Close();
}
if (!models.All(CanSubmit))
{
FlashWarn("所选记录中包括已提交记录！");
return Close();
}
return View(models);
}
}
public ActionResult Approve(long[] ids)
{
if (ids.Length == 0)
{
FlashInfo("请选择要审核的记录。");
return Close();
}
using (var session = new SessionFactory().OpenSession())
{
var models = session.Find<StandardFile>(m => m.Id.In(ids));
if (models.Count == 0)
{
FlashInfo("你没有选择任何可以审核的记录。");
return Close();
}
if (!models.All(CanApprove))
{
FlashInfo("所选文件状态有误，请检查！");
return Close();
}
return View(models);
}
}