public SearchMeta GetSearchMeta(string searchID)
{
string pp = searchID.ToUpper();
string strsql = string.Format(" select * from EAP_Search where upper(searchId)='{0}' and FlagDelete=0", pp);
SearchMeta result = DataProvider.GetEntity <SearchMeta>(strsql);
if (result != null)
{
strsql = string.Format(" select * from EAP_SearchField where upper(searchId)='{0}' and FlagDelete=0", pp);
result.Add(DataProvider.LoadData <SearchField>(strsql));
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="sUserName"></param>
/// <param name="nametype">0:用户名登录 1：caid登录</param>
/// <returns></returns>
public EAP_User GetUserByUserName(string sUserName, int nametype = 0)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UserName", sUserName),
new SqlParameter("@nametype", nametype)
};
EAP_User user = DataProvider.GetEntity <EAP_User>("usp_GetUserByUserName2", parameters);
if (user != null)
{
string sSql = string.Format("SELECT * FROM uv_UserRole WHERE UserID='{0}'", user.ID);
List <EAP_Role> _List = DataProvider.LoadData <EAP_Role>(sSql);
user.Roles.Clear();
user.Roles.AddRange(_List);
}
return(user);
}
