public Flexigride GetJson(JObject json) { SearchMod <SYS_Button> searchModel = new SearchMod <SYS_Button>(); searchModel.page = Convert.ToInt32(json["page"].ToString()); //当前页 searchModel.rp = Convert.ToInt32(json["rp"].ToString()); //页面大小 searchModel.sortorder = json["sortorder"].ToString(); //排序字段 searchModel.sortname = json["sortname"].ToString(); //排序方式 SYS_Button model = JsonToObject <SYS_Button>(json); IQueryable <SYS_Button> query = DPBase.db.SYS_Button; query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder); if (!string.IsNullOrEmpty(model.BTN_Name)) { query = query.Where(c => c.BTN_Name.Contains(model.BTN_Name)); } if (!string.IsNullOrEmpty(model.BTN_Name_En)) { query = query.Where(c => c.BTN_Name_En.Contains(model.BTN_Name_En)); } searchModel.query = query; Flexigride grid = new Flexigride(); grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel); grid.page = searchModel.page; grid.total = searchModel.total; return(grid); }
public SYS_Button Get(JObject json) { var model = JsonToObject <SYS_Button>(json); SYS_Button _model = DPBase.Get <SYS_Button>(model.BTN_Id); return(_model); }
public JsonResult UpdateButton(SYS_Button button) { JsonResult result = new JsonResult(); string msg = ""; try { button.ModifiedTime = DateTime.Now; button.Modifier = (Session["user"] as SYS_User)?.UserName; bool isSuccess = buttonService.UpdateButton(button); if (isSuccess) { msg = "修改成功"; } else { msg = "修改失败"; } log.Info(msg); } catch (DbEntityValidationException e) { log.Error(e.Message); } catch (Exception e) { log.Error(e.Message); } finally { result = Json(new { msg = msg }, JsonRequestBehavior.AllowGet); } return(result); }
/// <summary> /// 按钮内容HTML /// </summary> /// <param name="btn">按钮对象</param> /// <returns></returns> public string ButtonInnerHtml(SYS_Button btn) { string icon = "<i class='layui-icon " + btn.BtnIcon + "'></i>"; string text = btn.BtnName; string innerHtml = "按钮"; var showType = (BtnShowType)btn.ShowType; switch (showType) { case BtnShowType.图标加文字: innerHtml = icon + text; break; case BtnShowType.纯图标: innerHtml = icon; break; case BtnShowType.纯文字: innerHtml = text; break; default: break; } return(innerHtml); }
public int Add(JObject json) { SYS_Button model = JsonToObject <SYS_Button>(json); model.BTN_IsSuspended = false; //默认为false model.BTN_Mark = model.BTN_Name_En; model.BTN_CreatedBy = UserSession.username; //当前用户 model.BTN_CreatedOn = DateTime.Now; return(DPBase.Add(model)); }
public string ValBtnAttribute(JObject json) { if (string.IsNullOrEmpty(json["BTN_OrderIndex"].ToString())) { json["BTN_OrderIndex"] = 0; } SYS_Button model = JsonToObject <SYS_Button>(json); return(DPButton.DPValBtnAttribute(model)); }
/// <summary> /// 删除按钮 /// </summary> /// <param name="id">按钮ID</param> /// <returns></returns> public bool DeleteButton(Guid id) { using (var db = base.GDDSVSPDb) { int isdel = Convert.ToInt32(IsDel.未删除); SYS_Button Button = db.SYS_Button.SingleOrDefault(p => p.ButtonID == id && p.IsDel == isdel); Button.IsDel = Convert.ToInt32(IsDel.已删除); return(db.SaveChanges() > 0); } }
/// <summary> /// 验证按钮属性 /// </summary> /// <returns></returns> public static string DPValBtnAttribute(SYS_Button Btn) { try { using (NERPEntities context = new NERPEntities()) { string flag = string.Empty; IQueryable <SYS_Button> _valbBtn = context.SYS_Button; if (Btn.BTN_Id != 0) { _valbBtn = _valbBtn.Where(c => c.BTN_Id != Btn.BTN_Id); } var _valName = _valbBtn.Where(c => c.BTN_Name == Btn.BTN_Name); if (_valName.Count() != 0) { flag = "0"; } else { var _valName_En = _valbBtn.Where(c => c.BTN_Name_En == Btn.BTN_Name_En); if (_valName_En.Count() != 0) { flag = "1"; } else { var _valMark = _valbBtn.Where(c => c.BTN_Mark == Btn.BTN_Mark); if (_valMark.Count() != 0) { flag = "3"; } //} } } return(flag); } } catch (Exception ex) { throw new Exception(ex.Message + "转换的过程中发生了错误!"); } }
/// <summary> /// 添加按钮 /// </summary> /// <param name="Button">按钮对象</param> /// <returns></returns> public bool InsertButton(SYS_Button Button) { try { using (var transaction = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted })) { using (var db = base.GDDSVSPDb) { db.SYS_Button.Add(Button); db.SaveChanges(); List <SYS_Menu> menuList = db.SYS_Menu.ToList(); List <SYS_REL_MenuButton> mblist = new List <SYS_REL_MenuButton>(); int isdel = Convert.ToInt32(IsDel.已删除); foreach (var menu in menuList) { SYS_REL_MenuButton mb = new SYS_REL_MenuButton() { ID = Guid.NewGuid(), BtnCode = Button.BtnCode, MenuCode = menu.MenuCode, State = isdel }; mblist.Add(mb); } db.SYS_REL_MenuButton.BulkInsert(mblist); db.BulkSaveChanges(); } transaction.Complete(); } } catch (DbEntityValidationException ex) { throw ex; } return(true); }
/// <summary> /// 修改按钮 /// </summary> /// <param name="obj">按钮对象</param> /// <returns></returns> public bool UpdateButton(SYS_Button obj) { try { using (var db = base.GDDSVSPDb) { int isdel = Convert.ToInt32(IsDel.未删除); SYS_Button Button = db.SYS_Button.SingleOrDefault(p => p.ButtonID == obj.ButtonID && p.IsDel == isdel); Button.BtnCode = obj.BtnCode; Button.BtnName = obj.BtnName; Button.BtnOrder = obj.BtnOrder; Button.BtnDescribe = obj.BtnDescribe; Button.BtnIcon = obj.BtnIcon; Button.BtnType = obj.BtnType; Button.ShowType = obj.ShowType; return(db.SaveChanges() > 0); } } catch (DbEntityValidationException ex) { throw ex; } }
public JsonResult InsertEmployee(SYS_Button btn) { JsonResult result = new JsonResult(); try { btn.ButtonID = Guid.NewGuid(); btn.IsDel = 0; btn.CreateTime = DateTime.Now; btn.Creator = (Session["user"] as SYS_User)?.UserName; bool isSuccess = buttonService.InsertButton(btn); log.Info("添加成功"); } catch (Exception e) { log.Error(e.Message); } finally { result = Json(new { msg = "添加成功" }, JsonRequestBehavior.AllowGet); } return(result); }
public string Edit(JObject json) { SYS_Button model = JsonToObject <SYS_Button>(json); return(DPBase.Update(model) ? "新增成功!" : "新增失败"); }