public IEnumerable <OrganizationModel> GetOrganization()
{
DataTable data = SqlHelper.ExecuteDataTable(@" select * from SJOrganization ", null);
return(SqlHelper.DataTableToModelList <OrganizationModel>(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 <MainMenuModel> GetAllMenu()
{
DataTable data = SqlHelper.ExecuteDataTable(" SELECT * FROM SJMainMenu order by ShowOrder ;", null);
return(SqlHelper.DataTableToModelList <MainMenuModel>(data));
}