/// <summary> /// 数据表格 /// </summary> /// <param name="param"></param> /// <returns></returns> public List <sys_menu> GetMenuList(BootstrapGridDto param) { //int total = 0; var query = Sqldb.Queryable <sys_menu>().OrderBy(s => s.menu_sort).ToList(); return(query); }
/// <summary> /// 模块导航 /// </summary> /// <returns></returns> public List <sys_menu> GetTopMenuList() { var list = new List <sys_menu>(); if (UserCookie.IsSuper) { list = Sqldb.Queryable <sys_menu>() .Where(s => s.parent_id == 0) .OrderBy(s => s.menu_sort) .ToList(); } else { list = Sqldb.Queryable <sys_menu, sys_role_authorize>( (m, r) => new object[] { JoinType.Inner, m.id == r.menu_id }) .Where((m, r) => r.role_id == UserCookie.SysRoleId && m.parent_id == 0) .OrderBy((m, r) => m.menu_sort) .Select((m, r) => m) .ToList(); } return(list); }
public void UpdateMenu(sys_menu dto, string funcs) { if (!string.IsNullOrEmpty(dto.menu_url)) { dto.menu_type = 1; } if (dto.parent_id == 0) { dto.menu_level = 1; } else { dto.menu_level = Sqldb.Queryable <sys_menu>().Where(s => s.id == dto.parent_id).Select(s => s.menu_level).First() + 1; } Sqldb.Updateable(dto).IgnoreColumns(s => new { s.create_time, s.create_person }).ExecuteCommand(); Sqldb.Deleteable <sys_menu_ref_operate>().Where(s => s.menu_id == dto.id).ExecuteCommand(); if (!string.IsNullOrEmpty(funcs)) { var funcArray = funcs.Split(','); if (funcArray.Length > 0) { var list = new List <sys_menu_ref_operate>(); foreach (var func in funcArray) { var funcModel = new sys_menu_ref_operate(); funcModel.menu_id = dto.id; funcModel.operate_id = func.ToInt64(); list.Add(funcModel); } Sqldb.Insertable(list).ExecuteCommand(); } } }
public List <ZtreeDto> GetRoleMenuTree(string roleid) { var menu = _sysmenuRepository.Queryable <sys_menu>().OrderBy(s => s.menu_sort).Select(s => new ZtreeDto() { id = s.id.ToString(), name = s.menu_name, pId = s.parent_id.ToString() }).ToList(); var func = Sqldb.Queryable <sys_menu_ref_operate, sys_operate, sys_menu>((f, o, m) => f.operate_id == o.id && f.menu_id == m.id).Select((f, o, m) => new ZtreeDto() { id = f.operate_id.ToString(), pId = f.menu_id.ToString(), name = o.func_cname }).ToList(); menu.AddRange(func); var role = _sysroleauthorizeRepository.Queryable <sys_role_authorize>().Where(s => s.role_id == SqlFunc.ToInt64(roleid)).Select(s => new { s.menu_id, s.menu_pid }).ToList(); if (role.Any()) { foreach (var item in menu) { var isok = role.Where(s => s.menu_id == item.id.ToInt64() && s.menu_pid == item.pId.ToInt64()).Count(); if (isok > 0) { item.checkstate = true; } } } return(menu); }
public void UpdateProfile(sys_user dto) { dto.fax = dto.fax ?? string.Empty; dto.email = dto.email ?? string.Empty; dto.mobile_phone = dto.mobile_phone ?? string.Empty; Sqldb.Updateable(dto).UpdateColumns(s => new { s.real_name, s.pass_word, s.mobile_phone, s.email }).ExecuteCommand(); }
public void AddMenu(sys_menu dto, string funcs) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = "admin"; if (!string.IsNullOrEmpty(dto.menu_url)) { dto.menu_type = 1; } if (dto.parent_id == 0) { dto.menu_level = 1; } else { dto.menu_level = Sqldb.Queryable <sys_menu>().Where(s => s.id == dto.parent_id).Select(s => s.menu_level).First() + 1; } Sqldb.Insertable(dto).ExecuteCommand(); if (!string.IsNullOrEmpty(funcs)) { var funcArray = funcs.Split(','); if (funcArray.Length > 0) { var list = new List <sys_menu_ref_operate>(); foreach (var func in funcArray) { var funcModel = new sys_menu_ref_operate(); funcModel.menu_id = dto.id; funcModel.operate_id = func.ToInt64(); list.Add(funcModel); } Sqldb.Insertable(list).ExecuteCommand(); } } }
public void SaveRoleAuth(string roleId, string ids) { Sqldb.Deleteable <sys_role_authorize>().Where(s => s.role_id == SqlFunc.ToInt64(roleId)).ExecuteCommand(); if (!string.IsNullOrEmpty(ids)) { var list = new List <sys_role_authorize>(); var menuIds = ids.ToObject <List <ZtreeDto> >(); foreach (var mid in menuIds) { mid.pId = mid.pId ?? "0"; var model = new sys_role_authorize(); model.id = IdWorkerHelper.NewId(); model.role_id = roleId.ToInt64(); model.menu_id = mid.id.ToInt64(); model.menu_pid = mid.pId.ToInt64(); model.create_time = DateTime.Now; model.create_person = UserCookie.AccountName; list.Add(model); } if (list.Any()) { Sqldb.Insertable(list).ExecuteCommand(); } } }
public void UpdateData(sys_user dto) { dto.fax = dto.fax ?? string.Empty; dto.email = dto.email ?? string.Empty; dto.mobile_phone = dto.mobile_phone ?? string.Empty; Sqldb.Updateable(dto).IgnoreColumns(s => new { s.create_person, s.create_time, s.account_name }).ExecuteCommand(); }
public void UpdateUserPwd(long id, string pwd) { pwd = Encrypt.DesDecrypt(pwd); Sqldb.Updateable <sys_user>().UpdateColumns(s => new sys_user { pass_word = pwd }).Where(s => s.id == id).ExecuteCommand(); }
public sys_user GetUserById(string id) { var data = Sqldb.Queryable <sys_user>().Where(s => s.id == SqlFunc.ToInt64(id)).First(); data.pass_word = Encrypt.DesDecrypt(data.pass_word.Trim()); return(data); }
public bool IsExist(int areaCode, long id) { bool codeCount = false; if (id == 0) { var count = Sqldb.Queryable <sys_citys>().Where(s => s.zipcode == areaCode).Count(); if (count > 0) { codeCount = true; } } else { var count = Sqldb.Queryable <sys_citys>().Where(s => s.zipcode == areaCode && s.id != id).Count(); if (count > 0) { codeCount = true; } } return(codeCount); }
public string[] DeleteTask(string ids) { var idsArry = ids.Split(','); Sqldb.Deleteable <hangfire_jobs>().Where(s => idsArry.Contains(s.id)).ExecuteCommand(); return(idsArry); }
/// <summary> /// 迭代获取区域下拉 /// </summary> /// <returns></returns> public List <CitySelDto> GetCitySel() { var data = new List <CitySelDto>(); var list = Sqldb.Queryable <sys_citys>().OrderBy(s => s.zipcode).Select(s => new CitySelDto() { Id = s.id, Name = s.name, ParentId = s.province_code }).ToList(); var fdata = list.Where(s => s.ParentId == 0).ToList(); foreach (var item in fdata) { data.Add(item); var city = list.Where(s => s.ParentId == item.Id).ToList(); if (city.Any()) { item.Children = city; foreach (var citem in city) { InitChildList(list, citem, citem.Id); list.Add(citem); } } } return(data); }
public List <long> GetMenuRefOpt(string id) { return (Sqldb.Queryable <sys_menu_ref_operate>() .Where(s => s.menu_id == SqlFunc.ToInt64(id)) .Select(s => s.operate_id) .ToList()); }
public void DelByIds(string ids) { if (!string.IsNullOrEmpty(ids)) { var idsArray = ids.Split(','); Sqldb.Deleteable <sys_area>().In(idsArray).ExecuteCommand(); } }
public void UpdateData(demo dto) { dto.name = dto.name ?? string.Empty; dto.sex = dto.sex ?? string.Empty; dto.age = dto.age; dto.remark = dto.remark ?? string.Empty; Sqldb.Updateable(dto).IgnoreColumns(s => new { s.create_person, s.create_time }).ExecuteCommand(); }
public List <sys_dictionary> GetGridDataBypId(long pid) { //if (pid > 0) //{ return(Sqldb.Queryable <sys_dictionary>().OrderBy(s => s.sort_num).Where(s => s.parent_id == pid).ToList()); //} //return new List<sys_dictionary>(); }
public List <sys_area> GetCountys(long pid) { if (pid == 0) { pid = 52; } return(Sqldb.Queryable <sys_area>().Where(s => s.province_code == pid && s.city_level == 3).ToList()); }
/// <summary> /// 获取菜单表格 /// </summary> /// <returns></returns> public List <sys_menu> GetMenuList() { var query = Sqldb.Queryable <sys_menu>() .OrderBy(s => s.menu_sort) .ToList(); return(query); }
public void InsertRoleData(sys_role dto) { dto.role_code = dto.role_code ?? string.Empty; dto.id = IdWorkerHelper.NewId(); dto.create_person = UserCookie.AccountName; dto.create_time = DateTime.Now; Sqldb.Insertable(dto).ExecuteCommand(); }
public void DelRoleByIds(string ids) { if (!string.IsNullOrEmpty(ids)) { var idsArray = ids.Split(',').StrToLongArray(); Sqldb.Deleteable <sys_role>().In(idsArray).ExecuteCommand(); Sqldb.Deleteable <sys_role_authorize>().Where(s => idsArray.Contains(s.role_id)).ExecuteCommand(); } }
public void AddMenu(sys_menu dto) { dto.id = Guid.NewGuid().ToString("N"); dto.create_time = DateTime.Now; dto.creator = "admin"; dto.menu_icon = dto.menu_font; Sqldb.Insertable(dto).ExecuteCommand(); }
public void InsertFunc(sys_operate dto) { dto.id = IdWorkerHelper.NewId(); dto.func_icon = dto.func_icon ?? "tag"; dto.func_class = dto.func_class ?? "btn-blue"; dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; Sqldb.Insertable(dto).ExecuteCommand(); }
public BootstrapGridDto GetData(BootstrapGridDto param, string accountName) { var query = Sqldb.Queryable <sys_user, sys_role>((u, r) => new object[] { JoinType.Left, u.sys_role_id == r.id }).Where((u, r) => !u.is_super); int total = 0; var data = query.OrderBy((u, r) => u.create_time, OrderByType.Desc).Select((u, r) => new { Id = u.id, AccountName = u.account_name, RealName = u.real_name, MobilePhone = u.mobile_phone, Email = u.email, CreateTime = u.create_time, RoleName = r.role_name }).ToPageList(param.page, param.limit, ref total); param.rows = data; param.total = total; return(param); }
public void InsertData(sys_user dto) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; dto.fax = dto.fax ?? string.Empty; dto.email = dto.email ?? string.Empty; dto.mobile_phone = dto.mobile_phone ?? string.Empty; Sqldb.Insertable(dto).ExecuteCommand(); }
public List <sys_menu> GetRoleAuthMenu(string roleid) { var data = Sqldb.Queryable <sys_menu, sys_role_authorize>((m, r) => m.id == r.menu_id) .Where((m, r) => r.role_id == SqlFunc.ToInt64(roleid)) .Select((m, r) => m) .ToList(); return(data); }
public List <ZtreeDto> GetProvince() { var query = Sqldb.Queryable <sys_citys>().Where(s => s.province_code == 0) .Select(s => new ZtreeDto() { id = s.zipcode.ToString(), name = s.name, pId = "0" }).ToList(); return(query); }
public BootstrapGridDto GetData(BootstrapGridDto param) { int total = 0; var query = Sqldb.Queryable <hangfire_jobs>().OrderBy(s => s.id) .ToPageList(param.page, param.limit, ref total); param.rows = query; param.total = total; return(param); }
public void InsertAreaData(sys_area dto) { dto.id = IdWorkerHelper.NewId(); dto.zipcode = dto.zipcode; dto.name = dto.name; dto.name = dto.name ?? string.Empty; dto.province_code = dto.province_code; dto.city_code = dto.city_code; dto.city_level = dto.city_level; Sqldb.Insertable(dto).ExecuteCommand(); }
public BootstrapGridDto GetData(BootstrapGridDto param) { int total = 0; var query = Sqldb.Queryable <sys_role>() .OrderBy(s => s.sort) .ToPageList(param.page, param.limit, ref total); param.total = total; param.rows = query; return(param); }