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