/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_Sys_Role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Role set ");
strSql.Append(" RoleName = @RoleName ");
strSql.Append(" where RoleID=@RoleID ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@RoleStatus", SqlDbType.VarChar, 10),
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleID;
parameters[2].Value = model.RoleStatus;
int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public string Delete(int roleid)
{
string msg = "删除失败。";
//判断是否有用户在使用该角色
if (HasUsers(roleid))
{
msg = "该角色使用中，不能删除！";
return(new JsonMessage {
Success = true, Data = "0", Message = msg
}.ToString());
}
var r = RoleDal.Instance.Get(roleid);
//先删除角色中分配的权限
SqlEasy.ExecuteNonQuery("delete Sys_RoleNavBtns where roleid=@roleid", new SqlParameter("@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());
}
/// <summary>
/// 角色授权
/// </summary>
/// <param name="navJsonData">导航菜单、按钮数据</param>
/// <returns></returns>
public int RoleAuthorize(string navJsonData)
{
JObject jobj = JObject.Parse(navJsonData);
var buttons = ButtonDal.Instance.GetAll().ToList();
var roleid = jobj["roleId"];
var menus = jobj["menus"];
var navs = menus.Select(menu => new{
navid = menu["navid"],
btns = buttons.Where(n =>
menu["buttons"].Select(m => (string)m).Contains <string>(n.ButtonTag)
).Select(k => k)
});
const string sql = "insert into Sys_RoleNavBtns(roleid,navid,btnid) values ('{0}','{1}','{2}')";
List <string> sb = new List <string>();
foreach (var nav in navs)
{
foreach (var btn in nav.btns)
{
sb.Add(string.Format(sql, roleid, nav.navid, btn.FID));
}
}
SqlEasy.ExecuteNonQuery("delete sys_roleNavBtns where roleid=:roleid",
new OracleParameter("roleid", (string)roleid));
foreach (string s in sb)
{
SqlEasy.ExecuteNonQuery(s);
}
return(1);
// return !string.IsNullOrEmpty(sb.ToString()) ? SqlEasy.ExecuteNonQuery( sb.ToString()) : 0;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Mod_Sys_Role model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Role(");
strSql.Append("RoleName");
strSql.Append(") values (");
strSql.Append("@RoleName");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleStatus", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleStatus;
object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 设置菜单按钮
/// </summary>
/// <param name="navid">菜单ID</param>
/// <param name="permissions">按钮</param>
/// <returns></returns>
public int SetNavButtons(string navid, string permissions)
{
const string sql = "insert into Sys_NavButtons (navid,buttonid,sortnum) values('{0}','{1}',{2})";
if (permissions != "" && navid != "")
{
var sb = new List <string>();
var arr = permissions.Split(',');
int k = 0;
foreach (var s in arr)
{
sb.Add(string.Format(sql, navid, s, k));
// sb.AppendLine();
k++;
}
if (sb.Count == 0)
{
throw new Exception("按钮数量为0或菜单ID未找到。");
}
const string deleteSql = "delete Sys_NavButtons where navid=:Navid";
DbUtils.ExecuteNonQuery(deleteSql, new { Navid = navid });
foreach (string s in sb)
{
SqlEasy.ExecuteNonQuery(s);
}
return(1);
}
return(0);
}
/// <summary>
/// 用户授权
/// </summary>
/// <param name="navJsonData">菜单、按钮JSON数据</param>
/// <returns></returns>
public int UserAuthorize(string navJsonData)
{
JObject jobj = JObject.Parse(navJsonData);
var buttons = ButtonDal.Instance.GetAll().ToList();
var userId = jobj["userId"];
var menus = jobj["menus"];
var navs = menus.Select(menu => new
{
navid = menu["navid"],
btns = buttons.Where(n =>
menu["buttons"].Select(m => (string)m).Contains <string>(n.ButtonTag)
).Select(k => k)
});
const string sql = "insert into Sys_UserNavBtns(userid,navid,btnid) values ({0},{1},{2})";
var sb = new StringBuilder();
foreach (var nav in navs)
{
foreach (var btn in nav.btns)
{
sb.AppendFormat(sql, userId, nav.navid, btn.FID);
sb.AppendLine();
}
}
SqlEasy.ExecuteNonQuery("delete Sys_UserNavBtns where userid=:userid",
new OracleParameter("userid", (int)userId));
return(!string.IsNullOrEmpty(sb.ToString()) ? SqlEasy.ExecuteNonQuery(sb.ToString()) : 0);
}
/// <summary>
/// 设置菜单按钮
/// </summary>
/// <param name="navid">菜单ID</param>
/// <param name="permissions">按钮</param>
/// <returns></returns>
public int SetNavButtons(int navid, string permissions)
{
const string sql = "insert into Sys_NavButtons (navid,buttonid,sortnum) values({0},{1},{2})";
if (permissions != "" && navid > 0)
{
var sb = new StringBuilder();
var arr = permissions.Split(',');
int k = 0;
foreach (var s in arr)
{
sb.AppendFormat(sql, navid, s, k);
sb.AppendLine();
k++;
}
if (string.IsNullOrEmpty(sb.ToString()))
{
throw new Exception("按钮数量为0或菜单ID未找到。");
}
const string deleteSql = "delete Sys_NavButtons where navid=@Navid";
DbUtils.ExecuteNonQuery(deleteSql, new { Navid = navid });
return(SqlEasy.ExecuteNonQuery(sb.ToString()));
}
return(0);
}
/// <summary>
/// 批量删除一批数据
/// </summary>
public bool DeleteList(string MenuIdlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Sys_Menu ");
strSql.Append(" where ID in (" + MenuIdlist + ") ");
int rows = SqlEasy.ExecuteNonQuery(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 为指定的用户分配角色
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="roleIds">角色ID</param>
/// <returns></returns>
public int AddUserTo(int userId, params int[] roleIds)
{
string sql = "insert into Sys_UserRoles (userid,roleid) values({0},{1})";
StringBuilder sb = new StringBuilder();
foreach (var rid in roleIds)
{
sb.AppendFormat(sql, userId, rid);
sb.AppendLine();
}
if (!string.IsNullOrEmpty(sb.ToString()))
{
return(SqlEasy.ExecuteNonQuery(sb.ToString()));
}
return(0);
}
/// <summary>
/// 为指定的用户分配角色
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="roleIds">角色ID</param>
/// <returns></returns>
public int AddUserTo(string userId, params string[] roleIds)
{
string sql = "insert into Sys_UserRoles (FID,userid,roleid) values('{0}','{1}','{2}')";
StringBuilder sb = new StringBuilder();
foreach (var rid in roleIds)
{
sb.AppendFormat(sql, Guid.NewGuid().ToString(), userId, rid);
sb.AppendLine();
}
if (!string.IsNullOrEmpty(sb.ToString()))
{
return(SqlEasy.ExecuteNonQuery(sb.ToString()));
}
return(0);
}
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 SetDepartments(int roleid, string deps)
{
if (string.IsNullOrEmpty(deps))
{
return(0);
}
string[] arrDep = deps.Split(',');
string sql = "insert into Sys_Roles_Departments (roleid,depid) values({0},{1}) ";
StringBuilder sb = new StringBuilder();
foreach (string depid in arrDep)
{
sb.AppendFormat(sql, roleid, depid);
sb.AppendLine();
}
return(sb.Length > 0 ? SqlEasy.ExecuteNonQuery(sb.ToString()) : 0);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_Sys_Menu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Menu set ");
strSql.Append(" Pid = @Pid , ");
strSql.Append(" MenuName = @MenuName , ");
strSql.Append(" Menu_Url = @Menu_Url , ");
strSql.Append(" Icon = @Icon , ");
strSql.Append(" Sort = @Sort ");
strSql.Append(" where MenuId=@MenuId ");
SqlParameter[] parameters =
{
new SqlParameter("@MenuId", SqlDbType.Int, 4),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@MenuName", SqlDbType.NVarChar, 100),
new SqlParameter("@Menu_Url", SqlDbType.NVarChar, 500),
new SqlParameter("@Icon", SqlDbType.VarChar, 50),
new SqlParameter("@Sort", SqlDbType.Int, 4)
};
parameters[0].Value = model.MenuId;
parameters[1].Value = model.Pid;
parameters[2].Value = model.MenuName;
parameters[3].Value = model.Menu_Url;
parameters[4].Value = model.Icon;
parameters[5].Value = model.Sort;
int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Sys_Role ");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Mod_Sys_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" Update Sys_User SET ");
strSql.Append(" UserName=@UserName, ");
strSql.Append(" PassWord=@PassWord, ");
strSql.Append(" RoleId=@RoleId, ");
strSql.Append(" PassSalt=@PassSalt, ");
strSql.Append(" IsDisabled=@IsDisabled ");
strSql.Append(" where 1=1 and UserId=" + model.UserId);
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 100),
new SqlParameter("@RoleId", SqlDbType.Int, 8),
new SqlParameter("@PassSalt", SqlDbType.VarChar, 50),
new SqlParameter("@IsDisabled", SqlDbType.Bit, 2)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.RoleId;
parameters[3].Value = model.PassSalt;
parameters[4].Value = model.IsDisabled;
object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int MenuId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Sys_Menu ");
strSql.Append(" where MenuId=@MenuId");
SqlParameter[] parameters =
{
new SqlParameter("@MenuId", SqlDbType.Int, 4)
};
parameters[0].Value = MenuId;
int rows = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Mod_Sys_Menu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Menu(");
strSql.Append("Pid,MenuName,Menu_Url,Icon,Sort");
strSql.Append(") values (");
strSql.Append("@Pid,@MenuName, @Menu_Url, @Icon, @Sort");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@MenuName", SqlDbType.NVarChar, 100),
new SqlParameter("@Menu_Url", SqlDbType.NVarChar, 500),
new SqlParameter("@Icon", SqlDbType.VarChar, 50),
new SqlParameter("@Sort", SqlDbType.Int, 4)
};
parameters[0].Value = model.Pid;
parameters[1].Value = model.MenuName;
parameters[2].Value = model.Menu_Url;
parameters[3].Value = model.Icon;
parameters[4].Value = model.Sort;
object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Mod_Sys_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_User(");
strSql.Append("UserName,PassWord,RoleId,PassSalt,IsDisabled");
strSql.Append(") values (");
strSql.Append("@UserName,@PassWord, @RoleId, @PassSalt, @IsDisabled");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 100),
new SqlParameter("@RoleId", SqlDbType.Int, 8),
new SqlParameter("@PassSalt", SqlDbType.VarChar, 50),
new SqlParameter("@IsDisabled", SqlDbType.Bit, 2)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.RoleId;
parameters[3].Value = model.PassSalt;
parameters[4].Value = model.IsDisabled;
object obj = SqlEasy.ExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
