public IEnumerable <MainMenuModel> GetUserMenu(int userId) { DataTable data = SqlHelper.ExecuteDataTable( @" SELECT a.* FROM SJMainMenu a join SJPageOwner b on a.ID=b.MainMenuId where UserId=@UserId union SELECT a.* FROM SJMainMenu a join SJPageOwner b on a.ID = b.MainMenuId join SJUserRole c on b.RoleId = c.RoleId where c.UserId = @UserId order by ShowOrder ;", new SqlParameter[] { new SqlParameter("@UserId", userId) }); return(SqlHelper.DataTableToModelList <MainMenuModel>(data)); }
public IEnumerable <CustomerModel> GetSongRunCustomers() { DataTable data = SqlHelper.ExecuteDataTableSR(@" select * from SRCustomerView ", null); return(SqlHelper.DataTableToModelList <CustomerModel>(data)); }
public IEnumerable <OrganizationModel> GetOrganization(int orgId) { DataTable data = SqlHelper.ExecuteDataTable(@" select * from SJOrganization where id=@Id ", new SqlParameter[] { new SqlParameter("@Id", orgId) }); return(SqlHelper.DataTableToModelList <OrganizationModel>(data)); }
public IEnumerable <OrganizationModel> GetOrganization() { DataTable data = SqlHelper.ExecuteDataTable(@" select * from SJOrganization ", null); return(SqlHelper.DataTableToModelList <OrganizationModel>(data)); }
public IEnumerable <EnumModel> GetEnumModels() { DataTable data = SqlHelper.ExecuteDataTable(@" SELECT * FROM SJEnumTable", null); return(SqlHelper.DataTableToModelList <EnumModel>(data)); }
public IEnumerable <MainMenuModel> GetAllMenu() { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJMainMenu order by ShowOrder ;", null); return(SqlHelper.DataTableToModelList <MainMenuModel>(data)); }
public IEnumerable <UserModel> GetAllUsers() { DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJUser ;", null); return(SqlHelper.DataTableToModelList <UserModel>(data)); }