public JsonResult AddTable(ScadaTableModel model) { model.CreateTime = DateTime.Now; model.CreateUserId = Operator.UserId; model.UpdateTime = DateTime.Now; model.UpdateUserId = Operator.UserId; model.ColNum = 26; List <int> colWidths = new List <int>(); List <string> colTitles = new List <string>(); for (int i = 0; i < model.ColNum; i++) { colTitles.Add(ExcelConvert.ToName(i)); colWidths.Add(120); } model.ColimnWidths = string.Join(",", colWidths.ToArray()); model.ColumnTitles = string.Join(",", colTitles.ToArray()); model.RowNum = 100; model.FilterRule = ""; int id = 0; bool isres = TableService.Insert(model, out id); if (isres) { TableUserRoleService.DeleteByWhere(" where TableId=" + id); if (model.RoleUserID != null) { string[] users = model.RoleUserID.Split(','); for (int i = 0; i < users.Length; i++) { ScadaTableUserRoleModel role = new ScadaTableUserRoleModel(); role.CreateTime = DateTime.Now; role.CreateTime = DateTime.Now; role.CreateUserId = Operator.UserId; role.UpdateTime = DateTime.Now; role.UpdateUserId = Operator.UserId; role.SortCode = i + 1; role.TableId = id; role.UserId = int.Parse(users[i]); TableUserRoleService.Insert(role); } } } var result = isres ? SuccessTip("添加成功") : ErrorTip("添加失败"); return(Json(result)); }
public JsonResult EditTable(ScadaTableModel model) { var sourmodel = TableService.GetById(model.Id); model.CreateTime = DateTime.Now; model.CreateUserId = Operator.UserId; model.UpdateTime = DateTime.Now; model.UpdateUserId = Operator.UserId; model.RowNum = 100; model.ColNum = 26; if (sourmodel != null) { model.ColimnWidths = sourmodel.ColimnWidths; model.ColumnTitles = sourmodel.ColumnTitles; } bool isres = TableService.UpdateById(model); if (isres) { TableUserRoleService.DeleteByWhere(" where TableId=" + model.Id); if (model.RoleUserID != null) { string[] users = model.RoleUserID.Split(','); for (int i = 0; i < users.Length; i++) { ScadaTableUserRoleModel role = new ScadaTableUserRoleModel(); role.CreateTime = DateTime.Now; role.CreateTime = DateTime.Now; role.CreateUserId = Operator.UserId; role.UpdateTime = DateTime.Now; role.UpdateUserId = Operator.UserId; role.SortCode = i + 1; role.TableId = model.Id; role.UserId = int.Parse(users[i]); TableUserRoleService.Insert(role); } } } var result = isres ? SuccessTip("保存成功") : ErrorTip("保存失败"); return(Json(result)); }