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