heartdevil

"SELECT * 
FROM `articleTag` AS aT
INNER JOIN `article` AS a ON(aT.articleID = a.id)
INNER JOIN `tags` AS t ON(aT.tagID = t.id)
WHERE AND t.alias = 'find me'"

public interface PagedListInterface
{
//..
PageIndex
PageSize
TotalCount
TotalPages
//..
}

class PagedList implements PagedListInterface
{
//тут вся логика листалки
}

public interface NewsInterface
{
//Различные методы
//И среди прочих
PagedListInterface GetNewsList()
}

class News implements NewsInterface
{
public PagedListInterface GetNewsList()
}

BarService(IFooRepository fooRepository, IUnitOfWork uow)

public void dropStatus_OnSelectedIndexChanged(object sender, EventArgs e)
       {
       }

public void dropStatus_OnSelectedIndexChanged(object sender, EventArgs e)
       {
          DropDownList ddl = (DropDownList)sender;
          //Индекс доступен через ddl.SelectedIndex
       }

SELECT fcl.site, year(fcl.date) as year, month(fcl.date) as month, day(fcl.date) as day, hour(fcl.date) as hour, COUNT(fo.id) AS orders, SUM(fcl.w_init) as w_init, SUM(fcl.w_unique) as w_unique, SUM(fcl.w_close) as w_close 
FROM `f_click_log` AS fcl
INNER JOIN `f_orders` AS fo ON fcl.site = fo.client  
WHERE fcl.site='".$_val['name']."' AND fcl.date>='".$date_start." 00:00:00' AND fcl.date<='".$date_end." 23:59:59' 
GROUP BY fcl.year, fcl.month, fcl.site