public Flexigride GetButtonGroup(JObject json) { SearchMod <SYS_ButtonGroup> searchModel = new SearchMod <SYS_ButtonGroup>(); searchModel.page = Convert.ToInt32(json["page"].ToString()); searchModel.rp = Convert.ToInt32(json["rp"].ToString()); SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup))); IQueryable <SYS_ButtonGroup> query = DPBase.db.SYS_ButtonGroup; query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortname) : query.OrderBy(c => searchModel.sortname); if (!string.IsNullOrEmpty(bGroup.BG_Name)) { query = query.Where(c => c.BG_Name.Contains(bGroup.BG_Name)); } if (!string.IsNullOrEmpty(bGroup.BG_Name_En)) { query = query.Where(c => c.BG_Name_En.Contains(bGroup.BG_Name_En)); } //aa.query = query.Select(c => new { BG_Name = c.BG_Name, BG_Name_En = c.BG_Name_En, BG_OrderIndex = c.BG_OrderIndex, BG_Desc = c.BG_Desc,BG_Id = c.BG_Id }); searchModel.query = query.OrderBy(c => c.BG_CreatedOn); Flexigride grid = new Flexigride(); grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel); grid.page = searchModel.page; grid.total = searchModel.total; return(grid); }
/// <summary> /// 通用查询 /// </summary> /// <param name="BtnG"></param> /// <param name="rp"></param> /// <param name="pageIndex"></param> /// <param name="allRows"></param> /// <param name="allPages"></param> /// <returns></returns> public static List <dynamic> DPGetQueryLst(SearchMod <T> aa, dynamic expression) { using (NERPEntities contex = new NERPEntities()) { int skipCount = ((aa.page - 1) * aa.rp); var bb = aa.ret; //匿名对象,用于显示输出 //List<dynamic> list = contex.Set<T>().Select(c => aa).ToList<dynamic>(); IQueryable <dynamic> query = aa.query; var custom = new SYS_ButtonGroup { BG_Name = "BG_Name", BG_Name_En = "BG_Name_En" }; //aa.where.Compile()(custom); //query.Where(aa.where); //query = aa.query; // var custom = expression.Compile()(expression); // var ww = expression.Compile()(custom); //表中有无法转换的字段,所以用动态类型进行转换 List <dynamic> list = query.ToList <dynamic>(); aa.total = list.Count(); aa.total = aa.total / aa.rp + aa.total % aa.rp == 0 ? 0 : 1; List <dynamic> ret = aa.page == 0 ? list : list.Skip(skipCount).Take(aa.rp).ToList(); return(ret); } }
public string EditButtonGroup(JObject json) { SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup))); DPBase.Update(bGroup); return("保存成功!"); }
public string AddNewButtonGroup(JObject json) { json["BG_OrderIndex"] = 0; SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup))); bGroup.BG_CreatedOn = DateTime.Now; bGroup.BG_IsSuspended = false; DPBase.Add(bGroup); return("保存成功!"); }
public string ValBtnAttribute(JObject json) { if (string.IsNullOrEmpty(json["BG_OrderIndex"].ToString())) { json["BG_OrderIndex"] = 0; } SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup))); return(DPButton.DPValBtnGroupAttribute(bGroup)); }
public JObject GetBtnInformation(JObject json) { //SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup))); int BG_Id = Convert.ToInt32(json["BG_Id"].ToString()); SYS_ButtonGroup _btnGroup = DPBase.Get <SYS_ButtonGroup>(BG_Id); JObject ret = new JObject(); ret.Add("group", JObject.FromObject(_btnGroup)); return(ret); }
/// <summary> /// 验证按钮组属性 /// </summary> /// <returns></returns> public static string DPValBtnGroupAttribute(SYS_ButtonGroup bGroup) { try { using (NERPEntities context = new NERPEntities()) { string flag = string.Empty; IQueryable <SYS_ButtonGroup> _valbGroup = context.SYS_ButtonGroup; if (bGroup.BG_Id != 0) { _valbGroup = _valbGroup.Where(c => c.BG_Id != bGroup.BG_Id); } IQueryable <SYS_ButtonGroup> _valName = _valbGroup.Where(c => c.BG_Name == bGroup.BG_Name); if (_valName.Count() != 0) { flag = "0"; } else { IQueryable <SYS_ButtonGroup> _valName_En = _valbGroup.Where(c => c.BG_Name_En == bGroup.BG_Name_En); if (_valName_En.Count() != 0) { flag = "1"; } else { //_valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_OrderIndex == bGroup.BG_OrderIndex); //if (_valbGroup.Count() != 0) //{ // flag = "2"; //} //else //{ IQueryable <SYS_ButtonGroup> _valMark = _valbGroup.Where(c => c.BG_Mark == bGroup.BG_Mark); if (_valMark.Count() != 0) { flag = "3"; } //} } } return(flag); } } catch (Exception ex) { throw new Exception(ex.Message + "转换的过程中发生了错误!"); } }
/// <summary> /// 获取按钮组 /// </summary> /// <returns></returns> public static SYS_ButtonGroup DPGetBtnInformation(SYS_ButtonGroup bGroup) { try { using (NERPEntities context = new NERPEntities()) { SYS_ButtonGroup btnGroup = context.SYS_ButtonGroup.Where(c => c.BG_Name_En == bGroup.BG_Name_En).FirstOrDefault(); return(btnGroup); } } catch (Exception ex) { throw new Exception(ex.Message + "转换的过程中发生了错误!"); } }
/// <summary> /// 保存按钮组 /// </summary> /// <returns></returns> public static void DPSaveButtonModel(SYS_ButtonGroup bGroup) { try { using (NERPEntities context = new NERPEntities()) { bGroup.BG_IsSuspended = false; bGroup.BG_CreatedOn = DateTime.Now; bGroup.BG_CreatedBy = "SYS"; context.SYS_ButtonGroup.Add(bGroup); context.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message + "转换的过程中发生了错误!"); } }
/// <summary> /// 获取按钮组列表,列表必须在末尾加Lst /// </summary> /// <returns></returns> public static List <dynamic> DPGetButtonGroupLst(SYS_ButtonGroup BtnG, int rp, int page, out int allRows, out int allPages) { using (NERPEntities contex = new NERPEntities()) { int skipCount = ((page - 1) * rp); IQueryable <SYS_ButtonGroup> query = contex.SYS_ButtonGroup; if (!string.IsNullOrEmpty(BtnG.BG_Name)) { query = query.Where(c => c.BG_Name == BtnG.BG_Name); } if (!string.IsNullOrEmpty(BtnG.BG_Name_En)) { query = query.Where(c => c.BG_Name_En == BtnG.BG_Name_En); } //表中有无法转换的字段,所以用动态类型进行转换 List <dynamic> list = query.Select(c => c.BG_Name).ToList <dynamic>(); allRows = list.Count(); allPages = allRows / rp + allRows % rp == 0 ? 0 : 1; return(page == 0 ? list : list.Skip(skipCount).Take(rp).ToList()); } }
/// <summary> /// 验证按钮属性 /// </summary> /// <returns></returns> public static string DPValBtnAttribute(SYS_ButtonGroup bGroup) { try { using (NERPEntities context = new NERPEntities()) { string flag = string.Empty; IQueryable <SYS_ButtonGroup> _valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_Name == bGroup.BG_Name); if (_valbGroup.Count() != 0) { flag = "按钮组名称重复请从新输入!"; } else { _valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_Name_En == bGroup.BG_Name_En); if (_valbGroup.Count() != 0) { flag = "按钮组编号重复请从新输入!"; } else { _valbGroup = context.SYS_ButtonGroup.Where(c => c.BG_OrderIndex == bGroup.BG_OrderIndex); if (_valbGroup.Count() != 0) { flag = "按钮组序号重复请从新输入!"; } } } return(flag); } } catch (Exception ex) { throw new Exception(ex.Message + "转换的过程中发生了错误!"); } }