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