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