public DataTable GetNavBtnsBy(params int[] roleid) { var roleids = roleid.Aggregate("", (current, i) => current + (i.ToString() + ",")).TrimEnd(','); string sql = "select a.*,b.ButtonTag from sys_roleNavBtns a join sys_buttons b on a.btnid=b.keyid where a.roleid in (" + roleids + ")"; return(SqlEasy.ExecuteDataTable(sql)); }
/// <summary> /// 根据主键Id,获取一行数据 /// </summary> /// <param name="tableName">表名</param> /// <param name="keyName">主键名称</param> /// <param name="value">值</param> /// <param name="msg">返回信息</param> /// <returns></returns> public static DataRow GetADataRow(string tableName, string keyName, string value, out string msg) { try { string s = "select * from @table where @keyname=@value"; SqlParameter[] sp = { new SqlParameter("@table", tableName), new SqlParameter("@keyname", keyName), new SqlParameter("@value", value) }; DataTable dt = SqlEasy.ExecuteDataTable(s, sp); if (dt.Rows.Count > 0) { msg = "OK"; return(dt.Rows[0]); } else { msg = ""; return(null); } } catch (Exception ex) { msg = ex.Message; return(null); } }
/// <summary> /// 获取指定用户的菜单及按钮 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public DataTable GetNavBtnsBy(int userId) { string sql = "select a.*,b.ButtonTag from Sys_UserNavBtns a join sys_buttons b on a.btnid=b.keyid where a.userid=@userid"; return(SqlEasy.ExecuteDataTable(sql, new SqlParameter("@userid", userId))); }
public Mod_Sys_User testGetUser(string UserName) { try { DataTable dt = SqlEasy.ExecuteDataTable(string.Format("SELECT * FROM Sys_User WHERE UserName='******'", UserName)); Mod_Sys_User Sys_User = null; if (dt.Rows.Count == 1) { Sys_User = new Mod_Sys_User(); Sys_User.UserId = Convert.ToInt32(dt.Rows[0]["UserId"]); Sys_User.PassWord = dt.Rows[0]["PassWord"].ToString(); Sys_User.UserName = dt.Rows[0]["UserName"].ToString(); Sys_User.RoleId = Convert.ToInt32(dt.Rows[0]["RoleId"]); Sys_User.PassSalt = dt.Rows[0]["PassSalt"].ToString(); if (dt.Rows[0]["IsDisabled"] == DBNull.Value) { Sys_User.IsDisabled = false; } else { Sys_User.IsDisabled = Convert.ToBoolean(dt.Rows[0]["IsDisabled"]); } } return(Sys_User); } catch (Exception ex) { throw; } }
/// <summary> /// 获取指定用户的菜单及按钮 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public DataTable GetNavBtnsBy(string userId) { string sql = "select a.*,b.ButtonTag from Sys_UserNavBtns a join sys_buttons b on a.btnid=b.FID where a.userid=:userid"; return(SqlEasy.ExecuteDataTable(sql, new OracleParameter("userid", userId))); }
public IEnumerable <Role> GetRolesBy(int userId) { string s = "select roleid from Sys_UserRoles where userid=@userid"; DataTable dt = SqlEasy.ExecuteDataTable(s, new SqlParameter("@userid", userId)); var list = from n in RoleDal.Instance.GetAll() where dt.AsEnumerable().Select(r => PublicMethod.GetInt(r[0])).ToArray <int>().Contains(n.KeyId) select n; return(list); }
public IEnumerable <Role> GetRolesBy(string userId) { string s = "select roleid from Sys_UserRoles where userid=:userid"; DataTable dt = SqlEasy.ExecuteDataTable(s, new OracleParameter("userid", userId)); var list = from n in RoleDal.Instance.GetAll() where dt.AsEnumerable().Select(r => PublicMethod.GetString(r[0])).ToArray <string>().Contains(n.FID) select n; return(list); }
public IEnumerable <User> GetUserBy(string FID) { string s = "select userid from Sys_UserRoles where ROLEID =:FID"; DataTable dt = SqlEasy.ExecuteDataTable(s, new OracleParameter("FID", FID)); var list = from n in UserDal.Instance.GetAll() where dt.AsEnumerable().Select(r => PublicMethod.GetString(r[0])).ToArray <string>().Contains(n.FID) select n; return(list); }
public DataTable GetNavBtnsBy(params string[] roleid) { var roleids = roleid.Aggregate("", (current, i) => current + (i.ToString() + ",")).TrimEnd(','); string[] array = roleids.Split(','); List <string> ids = new List <string>(); foreach (string id in array) { ids.Add("'" + id + "'"); } string sql = "select a.*,b.ButtonTag from sys_roleNavBtns a join sys_buttons b on a.btnid=b.FID where a.roleid in (" + string.Join(",", ids.ToArray()) + ")"; return(SqlEasy.ExecuteDataTable(sql)); }