public string Update(Role r)
{
string msg = "编辑失败";
if (HasRoleName(r.RoleName, r.FID))
{
msg = "角色名称已存在。";
}
Role old = RoleDal.Instance.Get(r.FID);
int k = RoleDal.Instance.Update(r);
if (k > 0)
{
msg = "编辑成功";
LogBll <Role> log = new LogBll <Role>();
log.UpdateLog(old, r);
}
if (r.IsDefault == 1)
{
SetDefaultRole(r.FID);
}
return(new JsonMessage {
Success = true, Data = k.ToString(), Message = msg
}.ToString());
}
public string AddNewNav(Navigation nav)
{
string msg = "添加失败.";
if (HasNav(nav.NavTitle, nav.FID))
{
msg = "菜单名称已存在.";
}
var k = NavigationDal.Instance.Insert(nav);
//if (k > 0)
// SetNavButtons(k, "18"); //添加菜单添加默认权限
if (k != "")
{
msg = "添加成功。";
LogBll <Navigation> log = new LogBll <Navigation>();
nav.FID = k;
log.AddLog(nav);
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k != ""
}.ToString());
}
public string EditDepartment(Department dep)
{
string msg = "修改失败。";
int k = 0;
var oldDep = DepartmentDal.Instance.Get(dep.FID);
if (HasDepartmentBy(dep.DepartmentName, dep.FID))
{
msg = "部门名称已存在。";
}
else
{
k = DepartmentDal.Instance.Update(dep);
if (k > 0)
{
msg = "修改成功。";
LogBll <Department> log = new LogBll <Department>();
log.UpdateLog(oldDep, dep);
}
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k > 0
}.ToString());
}
public string Add(Role r)
{
string msg = "添加失败";
if (HasRoleName(r.RoleName))
{
msg = "角色名称已存在。";
}
string k = RoleDal.Instance.Insert(r);
if (k != "")
{
msg = "添加成功";
LogBll <Role> log = new LogBll <Role>();
r.FID = k;
log.AddLog(r);
}
if (r.IsDefault == 1)
{
SetDefaultRole(r.FID);
}
return(new JsonMessage {
Success = true, Data = k.ToString(), Message = msg
}.ToString());
}
public string EditUser(User u)
{
int k;
string msg = "用户编辑失败。";
if (HasUserName(u.UserName, u.FID))
{
k = -2;
msg = "用户名已存在。";
}
else
{
var oldUser = UserDal.Instance.Get(u.FID);
k = UserDal.Instance.Update(u);
if (k > 0)
{
msg = "用户编辑成功。";
LogBll <User> log = new LogBll <User>();
log.IgnoreFields(new[] { "FID", "password", "passsalt", "configjson" }).UpdateLog(oldUser, u);
}
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k > 0
}.ToString());
}
public string AddNewDepartment(Department dep)
{
string k = "";
string msg = "添加失败！";
if (HasDepartmentBy(dep.DepartmentName))
{
msg = "部门名称已存在！";
}
else
{
k = DepartmentDal.Instance.Insert(dep);
if (k != "")
{
msg = "添加成功。";
LogBll <Department> log = new LogBll <Department>();
dep.FID = k;
log.AddLog(dep);
}
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k != ""
}.ToString());
}
public string AddUser(User u, string roleIds)
{
string uid = "";
string msg = "用户添加失败！";
if (HasUserName(u.UserName, u.FID))
{
uid = "-2";
msg = "用户名已存在。";
}
else
{
u.ConfigJson = "{\"theme\":{\"title\":\"默认皮肤\",\"name\":\"default\"},\"showType\":\"tree\",\"gridRows\":\"20\"}";
u.Password = StringHelper.MD5string(u.Password /* + u.PassSalt*/);
uid = UserDal.Instance.Insert(u);
if (!string.IsNullOrEmpty(roleIds))
{
var roleIdArr = roleIds.Split(',');
var roleIdList = roleIdArr.Select(n => PublicMethod.GetString(n)).ToArray();
UserDal.Instance.AddUserTo(uid, roleIdList);
}
if (uid != "")
{
msg = "添加新用户成功！";
LogBll <User> log = new LogBll <User>();
u.FID = uid;
log.AddLog(u);
}
}
return(new JsonMessage {
Data = uid.ToString(), Message = msg, Success = uid != ""
}.ToString());
}
public int Delete(string dicid)
{
SysDics d = SysDicsDal.Instance.Get(dicid);
if (d != null)
{
int i = SysDicsDal.Instance.Delete(dicid);
if (i > 0)
{
LogBll <SysDics> log = new LogBll <SysDics>();
log.DeleteLog(d);
}
return(i);
}
return(0); //参数错误
}
public string Add(SysDics entity)
{
if (Exists(entity.FClassCode, entity.FClassIdent))
{
return(""); //字典编码已存在
}
string i = SysDicsDal.Instance.Insert(entity);
if (i != "")
{
LogBll <SysDics> log = new LogBll <SysDics>();
entity.FID = i;
log.AddLog(entity);
}
return(i);
}
public string Add(Dic d)
{
if (HasDicCode(d.CategoryId, d.Code))
{
return(""); //字典编码已存在
}
string i = DicDal.Instance.Insert(d);
if (i != "")
{
LogBll <Dic> log = new LogBll <Dic>();
d.FID = i;
log.AddLog(d);
}
return(i);
}
public int Update(SysDics entity)
{
if (Exists(entity.FClassCode, entity.FClassIdent, entity.FID))
{
return(0); //字典编码已存在
}
SysDics oldDic = SysDicsDal.Instance.Get(entity.FID);
int i = SysDicsDal.Instance.Update(entity);
if (i > 0)
{
LogBll <SysDics> log = new LogBll <SysDics>();
log.UpdateLog(oldDic, entity);
}
return(i);
}
public int Edit(Dic d)
{
if (HasDicCode(d.CategoryId, d.Code, d.FID))
{
return(0); //字典编码已存在
}
Dic oldDic = DicDal.Instance.Get(d.FID);
int i = DicDal.Instance.Update(d);
if (i > 0)
{
LogBll <Dic> log = new LogBll <Dic>();
log.UpdateLog(oldDic, d);
}
return(i);
}
public string Delete(string roleid)
{
string msg = "删除失败。";
var r = RoleDal.Instance.Get(roleid);
//先删除角色中分配的权限
SqlEasy.ExecuteNonQuery("delete Sys_RoleNavBtns where roleid=:roleid", new OracleParameter("roleid", roleid));
int k = RoleDal.Instance.Delete(roleid);
if (k > 0)
{
msg = "删除成功。";
LogBll <Role> log = new LogBll <Role>();
log.DeleteLog(r);
}
return(new JsonMessage {
Success = true, Data = k.ToString(), Message = msg
}.ToString());
}
public int Delete(string dicid)
{
Dic d = DicDal.Instance.Get(dicid);
if (d != null)
{
if (d.children.Any())
{
return(2); //有子节点不能删除
}
int i = DicDal.Instance.Delete(dicid);
if (i > 0)
{
LogBll <Dic> log = new LogBll <Dic>();
log.DeleteLog(d);
}
return(i);
}
return(0); //参数错误
}
public string DeleteNav(string navid)
{
var oldNavList = from n in NavigationDal.Instance.GetAll().ToList()
where navid.Split(',').Contains(n.FID.ToString())
select n;
string msg = "删除失败。";
int k = NavigationDal.Instance.Delete(navid);
if (k > 0)
{
msg = "删除成功。";
var log = new LogBll <Navigation>();
foreach (var n in oldNavList)
{
log.DeleteLog(n);
}
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k > 0
}.ToString());
}
public string EditNav(Navigation nav)
{
string msg = "编辑失败。";
Navigation oldNav = GetBy(nav.FID);
if (HasNav(nav.NavTitle, nav.FID))
{
msg = "菜单名称已存在。";
}
int k = NavigationDal.Instance.Update(nav);
if (k > 0)
{
msg = "编辑成功。";
LogBll <Navigation> log = new LogBll <Navigation>();
log.UpdateLog(oldNav, nav);
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k > 0
}.ToString());
}
public string DeleteDepartment(string depid)
{
string msg = "删除失败";
var dep = DepartmentDal.Instance.Get(depid);
if (dep.children.Any())
{
msg = "有下级部门数据，不能删除。";
}
int k = DepartmentDal.Instance.Delete(depid);
if (k > 0)
{
msg = "删除成功。";
LogBll <Department> log = new LogBll <Department>();
log.DeleteLog(dep);
}
return(new JsonMessage {
Data = k.ToString(), Message = msg, Success = k > 0
}.ToString());
}
