public List <UserView> GetList() { return(DataAccessProxy.GetList <UserInfo, GroupInfo, UserView>((st, sc) => new object[] { SqlSugar.JoinType.Left, st.GroupID == sc.Id }, st => st.Id == 1, (st, sc) => st.Id, (st, sc) => new UserView { Id = st.Id, CnName = st.CnName, GroupName = sc.GroupName })); }
public List <UserView> GetList2() { return(DataAccessProxy.GetList <UserInfo, GroupInfo, DeptInfo, UserView>((st, sc, sd) => new object[] { SqlSugar.JoinType.Left, st.GroupID == sc.Id, SqlSugar.JoinType.Left, st.DeptID == sd.Id }, (st => st.Id == 1), null, (st, sc, sd) => new UserView { Id = st.Id, CnName = st.CnName, GroupName = sc.GroupName, DeptName = sd.DeptName })); }
public List <GroupInfo> GetList(string where, object parameters, string orderBy) { return(DataAccessProxy.GetList <GroupInfo>(where, parameters, orderBy)); }