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); }