public IndexModel(IndexManageEntity item, string parentId = "0", bool showCheckBox = false) : this()
{
this.id = item.Id;
this.text = item.Title;
this.value = item.Id;
this.parentnodes = parentId;
this.showcheck = showCheckBox;
}
public ActionResult SaveTitle(string keyValue, IndexManageEntity entity)
{
try
{
//找当前登录人所在的组织的ID 厂级或厂级以下找 厂级ID 省级找省级ID 集团级找集团ID
Operator user = OperatorProvider.Provider.Current();
DepartmentEntity orgDept = new DepartmentBLL().GetCompany(user.DeptId);
entity.DeptId = orgDept.DepartmentId;
entity.DeptCode = orgDept.EnCode;
entity.DeptName = orgDept.FullName;
manageBLL.SaveForm(keyValue, entity);
return(Success("操作成功"));
}
catch (Exception ex)
{
return(Error(ex.Message));
}
}
/// <summary>
/// 读取指标分类信息
/// </summary>
/// <returns></returns>
private List <IndexManageEntity> ReadIndex()
{
List <IndexManageEntity> data = new List <IndexManageEntity>();
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Content/指标/指标分类.xlsx");
if (!System.IO.File.Exists(path))
{
WriteMsg?.Invoke("未找到“指标分类.xlsx文件”，请检查文件在不在程序根目录下");
WriteMsg?.Invoke("==用navicat执行下面sql语句导出Excel文件放到根目录下的Content/指标 里面==");
WriteMsg?.Invoke(@"select b.NATURE,a.* from base_indexmanage a
left join base_department b
on a.deptid= b.DEPARTMENTID" );
WriteMsg?.Invoke("=============附件名称：指标分类.xlsx================");
throw new ArgumentNullException("未找到附件");
}
var book = new Workbook(path);
var sheet = book.Worksheets[0];
for (int i = 1; i <= sheet.Cells.MaxDataRow; i++)
{
IndexManageEntity indexEntity = new IndexManageEntity()
{
Nature = sheet.Cells[i, 0].StringValue.Trim(),
Id = sheet.Cells[i, 1].StringValue.Trim(),
DeptId = sheet.Cells[i, 2].StringValue.Trim(),
Title = sheet.Cells[i, 3].StringValue.Trim(),
DeptCode = sheet.Cells[i, 4].StringValue.Trim(),
DeptName = sheet.Cells[i, 5].StringValue.Trim(),
Sort = sheet.Cells[i, 6].IntValue,
IsShow = sheet.Cells[i, 7].IntValue,
CreateUserId = sheet.Cells[i, 8].StringValue.Trim(),
CreateDate = DateTime.Parse(sheet.Cells[i, 9].StringValue),
CreateUserName = sheet.Cells[i, 10].StringValue.Trim(),
ModifyUserId = sheet.Cells[i, 11].StringValue.Trim(),
ModifyDate = DateTime.Parse(sheet.Cells[i, 12].StringValue),
ModifyUserName = sheet.Cells[i, 13].StringValue.Trim(),
IndexType = sheet.Cells[i, 14].IntValue,
Templet = sheet.Cells[i, 15].IntValue,
};
data.Add(indexEntity);
}
return(data);
}
public ActionResult GetTitleFormJson(string keyValue)
{
IndexManageEntity indexManage = manageBLL.GetForm(keyValue);
return(Json(indexManage, JsonRequestBehavior.AllowGet));
}
public void SaveForm(string keyValue, IndexManageEntity entity)
{
service.SaveForm(keyValue, entity);
}
