/// <summary>
/// 广告列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<AdDeliveryInfo> List(AdSearchSetting setting) {
FastPaging fp = new FastPaging();
fp.OverOrderBy = " CreateDateTime DESC";
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.QueryFields = "*";
fp.TableName = "AdDelivery";
fp.PrimaryKey = "Id";
fp.WithOptions = " WITH(NOLOCK)";
if(setting.AdPositionId>0){
fp.Condition = string.Format(" AdPositionId = {0}",setting.AdPositionId);
}
IList<AdDeliveryInfo> list = new List<AdDeliveryInfo>();
AdDeliveryInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = GetByRow(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));
return new PageOfList<AdDeliveryInfo>(list, setting.PageIndex, setting.PageSize, count);
}
/// <summary>
/// 广告列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<AdDeliveryInfo> List(AdSearchSetting setting)
{
return AdDeliveryManage.List(setting);
}
/// <summary>
/// 广告位列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<AdPositionInfo> List(AdSearchSetting setting) {
return AdPositionManage.List(setting);
}