/// <summary>
/// 我的招聘
/// </summary>
/// <returns></returns>
public IActionResult MyRecruit()
{
MultiJqGridViewModel multi = new MultiJqGridViewModel();
//简历评价
var resumeAssess = GetJqGridModel("RcrtResumeReview", qs =>
{
qs.GlobalWhere = "EmpUid=@EmpUid";
qs.AddParameter("EmpUid", _applicationContext.EmpUid);
qs.ReadOnlyCols = "EmpUid";
});
//面试
var interviewAssess = GetJqGridModel("RcrtInterview", qs =>
{
qs.GlobalWhere = "EmpUid=@EmpUid";
qs.AddParameter("EmpUid", _applicationContext.EmpUid);
});
var cols = _dbContext.Columns("RcrtDemand").Where(c => !c.ColProperty.EqualsWithIgnoreCase("3"))?.Select(c => c.ColName);
//内推
var innerRecommend = GetJqGridModel("RcrtDemand", qs =>
{
qs.QueryCols = string.Join(',', cols);
qs.GlobalWhere = "InternalAble=1";
});
multi.JqGridViewModels.Add("resume", resumeAssess);
multi.JqGridViewModels.Add("interview", interviewAssess);
multi.JqGridViewModels.Add("recommend", innerRecommend);
return(View(multi));
}
/// <summary>
/// 组织机构
/// </summary>
/// <returns></returns>
public IActionResult OrgMgt()
{
MultiJqGridViewModel multiModel = new MultiJqGridViewModel();
JqGridViewModel orgModel = this.GetJqGridModel("FapOrg");
multiModel.JqGridViewModels.Add("FapOrg", orgModel);
JqGridViewModel groupModel = this.GetJqGridModel("FapGroup");
multiModel.JqGridViewModels.Add("FapGroup", groupModel);
return(View(multiModel));
}
public IActionResult BizRole()
{
MultiJqGridViewModel model = new MultiJqGridViewModel();
JqGridViewModel bizRole = this.GetJqGridModel("FapBizRoleEmployee");
JqGridViewModel dynRole = this.GetJqGridModel("FapBizDynRole");
model.JqGridViewModels.Add("FapBizRole", bizRole);
model.JqGridViewModels.Add("FapBizDynRole", dynRole);
return(View(model));
}
/// <summary>
/// 实时同步设置
/// </summary>
/// <returns></returns>
public IActionResult RealtimeSetting()
{
JqGridViewModel modelSetting = this.GetJqGridModel("CfgRTSynchSetting");
JqGridViewModel modelLog = this.GetJqGridModel("FapRealtimeSynLog", (qs) => {
qs.InitWhere = "SynState=0";
});
MultiJqGridViewModel model = new MultiJqGridViewModel();
model.JqGridViewModels.Add("setting", modelSetting);
model.JqGridViewModels.Add("log", modelLog);
return(View(model));
}
/// <summary>
/// 类别设置
/// </summary>
/// <returns></returns>
public ActionResult TimeType()
{
MultiJqGridViewModel mmodel = new MultiJqGridViewModel();
JqGridViewModel lm = GetJqGridModel("TmLeaveType");
mmodel.JqGridViewModels.Add("leave", lm);
JqGridViewModel tm = GetJqGridModel("TmTravelType");
mmodel.JqGridViewModels.Add("travel", tm);
JqGridViewModel om = GetJqGridModel("TmOvertimeType");
mmodel.JqGridViewModels.Add("overtime", om);
return(View(mmodel));
}
public IActionResult MultiDataGrid(List <GridViewModel> gridViews)
{
MultiJqGridViewModel multiModels = new MultiJqGridViewModel();
foreach (var gridView in gridViews)
{
var model = GetJqGridModel(gridView.TableName, qs =>
{
qs.GlobalWhere = gridView.Condition;
qs.DefaultValues = gridView.DefaultValues;
});
model.Title = gridView.TableLabel;
multiModels.JqGridViewModels.Add(gridView.TableName, model);
}
return(View(multiModels));
}
public IActionResult BizRole()
{
MultiJqGridViewModel model = new MultiJqGridViewModel();
JqGridViewModel bizRole = this.GetJqGridModel("Employee", (qs) =>
{
qs.InitWhere = "1=2";
qs.GlobalWhere = "IsMainJob=1";
qs.QueryCols = "Id,Fid,EmpCategory,EmpCode,EmpName,Gender,DeptUid,EmpPosition";
});
JqGridViewModel dynRole = this.GetJqGridModel("FapBizDynRole");
model.JqGridViewModels.Add("FapBizRole", bizRole);
model.JqGridViewModels.Add("FapBizDynRole", dynRole);
return(View(model));
}
/// <summary>
/// 业务角色，用于处理业务中使用的角色，不用于权限分配
/// </summary>
/// <returns></returns>
public IActionResult BusinessRole()
{
MultiJqGridViewModel model = new MultiJqGridViewModel();
JqGridViewModel bizRole = this.GetJqGridModel("Employee", (qs) =>
{
qs.InitWhere = "1=2";
qs.GlobalWhere = "DeptUid in(" + FapPlatformConstants.DepartmentAuthority + ") and IsMainJob=1";
qs.QueryCols = "Id,Fid,EmpCategory,EmpCode,EmpName,Gender,DeptUid,EmpPosition";
});
JqGridViewModel dynRole = this.GetJqGridModel("FapBizDynRole");
model.JqGridViewModels.Add("FapBizRole", bizRole);
model.JqGridViewModels.Add("FapBizDynRole", dynRole);
return(View(model));
}
//基础设置
public IActionResult BasicSettings()
{
JqGridViewModel modelWebsite = this.GetJqGridModel("RcrtWebsite");
var modelMail = GetJqGridModel("RcrtMail");
var modelTemplate = GetJqGridModel("CfgEmailTemplate", qs =>
{
qs.QueryCols = "Id,Fid,Name,ModuleUid,TableName,TemplateContent,Enabled";
qs.GlobalWhere = "ModuleUid='RecruitMailTmpl'";
qs.AddDefaultValue("ModuleUid", "RecruitMailTmpl");
qs.AddDefaultValue("TableName", "RcrtResume");
qs.AddDefaultValue("TableNameMC", "招聘简历");
});
MultiJqGridViewModel multiModel = new MultiJqGridViewModel();
multiModel.JqGridViewModels.Add("website", modelWebsite);
multiModel.JqGridViewModels.Add("mail", modelMail);
multiModel.JqGridViewModels.Add("template", modelTemplate);
return(View(multiModel));
}
/// <summary>
/// 我的考核
/// </summary>
/// <returns></returns>
public IActionResult MyAssess()
{
JqGridViewModel scoreModel = this.GetJqGridModel("PerfExaminer", (qs) =>
{
qs.GlobalWhere = "EmpUid=@EmpUid and ProgramUid in(select fid from perfprogram where PrmStatus='Starting')";
qs.AddParameter("EmpUid", _applicationContext.EmpUid);
qs.QueryCols = "Id,Fid,ObjectUid,ProgramUid,AssessModel,Score";
});
JqGridViewModel resultModel = this.GetJqGridModel("PerfObject", (q) =>
{
q.GlobalWhere = "ObjUid=@ObjUid";
q.ReadOnlyCols = "ProgramUid";
q.AddParameter("ObjUid", _applicationContext.EmpUid);
});
MultiJqGridViewModel multi = new MultiJqGridViewModel();
multi.JqGridViewModels.Add("score", scoreModel);
multi.JqGridViewModels.Add("result", resultModel);
return(View(multi));
}
public ActionResult MyPartner()
{
MultiJqGridViewModel multi = new MultiJqGridViewModel();
var partner = GetJqGridModel(nameof(EssPartner), qs =>
{
qs.GlobalWhere = "EmpUid=@EmpUid";
qs.AddParameter("EmpUid", _applicationContext.EmpUid);
qs.AddDefaultValue("EmpUid", _applicationContext.EmpUid);
qs.AddDefaultValue("EmpUidMC", _applicationContext.EmpName);
});
multi.JqGridViewModels.Add("partner", partner);
var partnerRequest = GetJqGridModel(nameof(EssPartner), qs =>
{
qs.GlobalWhere = $"{nameof(EssPartner.PartnerUid)}=@EmpUid and {nameof(EssPartner.RequestResult)}='None'";
qs.AddParameter("EmpUid", _applicationContext.EmpUid);
});
multi.JqGridViewModels.Add("request", partnerRequest);
return(View(multi));
}
/// <summary>
/// 单据设置
/// </summary>
/// <returns></returns>
public IActionResult BillSet()
{
MultiJqGridViewModel model = new MultiJqGridViewModel();
JqGridViewModel billcode = this.GetJqGridModel("CfgBillCodeRule");
JqGridViewModel billbw = this.GetJqGridModel("CfgBillWriteBackRule");
JqGridViewModel mailTemplate = this.GetJqGridModel("CfgEmailTemplate", (qs) =>
{
qs.GlobalWhere = "ModuleUid='BillMailTmpl'";
qs.AddDefaultValue("ModuleUid", "BillMailTmpl");
//qs.QueryCols = "Id,Fid,Code,Name,ModuleUid,TableName,Enabled";
});
JqGridViewModel ffmodel = GetJqGridModel("CfgFreeForm", (qs) =>
{
//qs.QueryCols = "Id, Fid, FFCode, FFName, BillTable, Enabled";
}, true);
model.JqGridViewModels.Add("WfFreeForm", ffmodel);
model.JqGridViewModels.Add("CfgBillCodeRule", billcode);
model.JqGridViewModels.Add("CfgBillWriteBackRule", billbw);
model.JqGridViewModels.Add("CfgEmailTemplate", mailTemplate);
return(View(model));
}
/// <summary>
/// 审批人选择
/// </summary>
/// <returns></returns>
public IActionResult Approver(string billTable)
{
var empModel = this.GetJqGridModel("Employee", (qs) =>
{
qs.QueryCols = "Id,Fid,EmpCode,EmpName,DeptUid";
qs.GlobalWhere = "IsMainJob=1";//主职
});
var roleModel = this.GetJqGridModel("FapBizRole", (qs) =>
{
qs.QueryCols = "Id,Fid,BizRoleName";
});
var dynRoleModel = this.GetJqGridModel("FapBizDynRole", (qs) =>
{
qs.QueryCols = "Id,Fid,RoleName,CustomSql,BindType";
qs.GlobalWhere = "State=1";//有效
});
MultiJqGridViewModel model = new MultiJqGridViewModel();
model.JqGridViewModels.Add("employee", empModel);
model.JqGridViewModels.Add("role", roleModel);
model.JqGridViewModels.Add("dynrole", dynRoleModel);
ViewBag.BillTable = billTable;
return(View(model));
}
