public ActionResult GetFormJson(string keyValue)
{
var data = dutyApp.GetForm(keyValue);
if (data.F_LastModifyUserId != null)
{
var data1 = userApp.GetForm(data.F_LastModifyUserId);
if (data1 != null)
{
data.F_LastModifyUserId = data1.F_RealName;
}
}
if (data.F_CreatorUserId != null)
{
var data2 = userApp.GetForm(data.F_CreatorUserId);
if (data2 != null)
{
data.F_CreatorUserId = data2.F_RealName;
}
}
return(Content(data.ToJson()));
}
// [HandlerAjaxOnly]
public ActionResult GetFormJson(string keyValue)
{
var data = dutyApp.GetForm(keyValue);
return(Content(data.ToJson()));
}
public ActionResult DownLoadPersonalAssessmentTemplete(string check_object_list, string templete_id, string assessment_name)
{
//根据模板id查找该模板的所有细项指标
List <DimensionDetailEntity> dimensionDetailList = dimensionDetailApp.GetTempleteDimensionDetail(templete_id);
List <string> indicatorsDefineList = new List <string>();
for (int i = 0; i < dimensionDetailList.Count; i++)
{
DimensionDetailEntity entity = dimensionDetailList[i];
string formule = entity.formule;
List <string> collection = AnalysisFormule(ref formule, null);
collection.ForEach(item =>
{
indicatorsDefineList.Add(item);
});
if (formule.Contains("[") && formule.Contains("]"))//如果有考核办法需要外部附加数据的
{
formule = formule.Replace('[', '|').Replace(']', '|');
}
string[] arr = formule.Replace('(', '|').Replace(')', '|').Replace('+', '|').Replace('-', '|').Replace('*', '|').Replace('/', '|').Replace('Σ', '|').Split('|');
for (int j = 0; j < arr.Length; j++)
{
if (!string.IsNullOrEmpty(arr[j]) && !indicatorsDefineList.Contains(arr[j]))
{
indicatorsDefineList.Add(arr[j]);
}
}
}
//指定excel格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = Server.UrlDecode(assessment_name);
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 15;
excelconfig.FileName = Server.UrlDecode(assessment_name) + "考核数据录入模板.xls";
excelconfig.IsAllSizeColumn = true;
excelconfig.ColumnEntity = new List <ColumnEntity>();
//写入Excel表头
//个人信息
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "F_RealName", ExcelColumn = "员工姓名", Alignment = "center"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "F_MobilePhone", ExcelColumn = "手机号", Alignment = "center"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "F_Duty", ExcelColumn = "职位", Alignment = "center"
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "F_DepartmentId", ExcelColumn = "所属组织", Alignment = "center"
});
//行数据
DataTable rowData = new DataTable();
rowData.Columns.Add("F_RealName");
rowData.Columns.Add("F_MobilePhone");
rowData.Columns.Add("F_Duty");
rowData.Columns.Add("F_DepartmentId");
//各个细项指标
for (int i = 0; i < indicatorsDefineList.Count; i++)
{
string indicatorName = indicatorsDefineList[i];
string columnName = "indicator_" + i;
string excelColumnName = indicatorName;
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = columnName, ExcelColumn = excelColumnName, Alignment = "center"
});
rowData.Columns.Add(columnName);
}
//转化所有考核对象列表
List <string> checkObjectIdList = KPI.Code.Json.ToObject <List <string> >(check_object_list);
DataRow dr = rowData.NewRow();
for (int i = 0; i < checkObjectIdList.Count; i++)
{
UserEntity userEntity = userApp.GetForm(checkObjectIdList[i]);
dr = rowData.NewRow();
dr["F_RealName"] = userEntity.F_RealName;
dr["F_MobilePhone"] = userEntity.F_MobilePhone;
dr["F_Duty"] = dutyApp.GetForm(userEntity.F_DutyId).F_FullName;
dr["F_DepartmentId"] = organizeApp.GetForm(userEntity.F_DepartmentId).F_FullName;
rowData.Rows.Add(dr);
}
ExcelHelper.ExcelDownload(rowData, excelconfig);
return(Success("操作成功。", null));
}
public async Task <IActionResult> GetFormJson(string keyValue)
{
var data = await dutyApp.GetForm(keyValue);
return(Content(data.ToJson()));
}
public ActionResult Info()
{
var user = OperatorProvider.Provider.GetCurrent();
var entity = userApp.GetForm(user.UserId);
string OrganizeName = string.Empty;
ViewBag.OrganizeName = organizeApp.GetForm(entity.F_OrganizeId)?.F_FullName;
ViewBag.DepartmentName = organizeApp.GetForm(entity.F_DepartmentId)?.F_FullName;
ViewBag.RoleName = string.IsNullOrWhiteSpace(entity.F_RoleId) == true ? "" : roleApp.GetForm(entity.F_RoleId)?.F_FullName;
ViewBag.Duty = string.IsNullOrWhiteSpace(entity.F_DutyId) == true ? "" : dutyApp.GetForm(entity.F_DutyId)?.F_FullName;
return(View(entity));
}
