/// <summary>
/// 获取指定位置的广告信息集合
/// </summary>
/// <param name="relationId">城市或单位类型(MQ)编号</param>
/// <param name="position">广告位置</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdvStructure.AdvInfo> GetNotFillAdvs(int relationId, EyouSoft.Model.AdvStructure.AdvPosition position)
{
string cachename = string.Format(EyouSoft.CacheTag.Adv.SystemAdv, position.ToString(), relationId);
EyouSoft.Cache.Facade.EyouSoftCacheTime <List <EyouSoft.Model.AdvStructure.AdvInfo> > list = (EyouSoft.Cache.Facade.EyouSoftCacheTime <List <EyouSoft.Model.AdvStructure.AdvInfo> >)
EyouSoft.Cache.Facade.EyouSoftCache.GetCache(cachename);
object UpdateTime = EyouSoft.Cache.Facade.EyouSoftCache.GetCache(string.Format(EyouSoft.CacheTag.Adv.SystemAdvUpdateKey, position.ToString()));
if (UpdateTime == null)
{
EyouSoft.Cache.Facade.EyouSoftCache.Add(string.Format(EyouSoft.CacheTag.Adv.SystemAdvUpdateKey, position.ToString()), DateTime.Now);
}
if (list != null && UpdateTime != null && list.UpdateTime > (DateTime)UpdateTime)
{
return(list.Data);
}
else
{
list = new EyouSoft.Cache.Facade.EyouSoftCacheTime <List <EyouSoft.Model.AdvStructure.AdvInfo> >();
EyouSoft.Model.AdvStructure.AdvPositionInfo positionInfo = this.GetPositionInfo(position);
IList <EyouSoft.Model.AdvStructure.AdvInfo> advs = dal.GetAdvs(positionInfo.AdvType, relationId, position, DateTime.Today, positionInfo.AdvCount, false);
int appendItems = positionInfo.AdvCount;
#region 补平台广告
if (advs != null && advs.Count > 0)
{
appendItems = positionInfo.AdvCount - advs.Count;
}
else
{
advs = new List <EyouSoft.Model.AdvStructure.AdvInfo>();
}
if (appendItems > 0)
{
IList <EyouSoft.Model.AdvStructure.AdvInfo> platformAdvs = dal.GetAdvs(positionInfo.AdvType, relationId, position, DateTime.Today, appendItems, true);
if (platformAdvs != null && platformAdvs.Count > 0)
{
//advs = advs.Union(platformAdvs).ToList();
foreach (EyouSoft.Model.AdvStructure.AdvInfo advInfo in platformAdvs)
{
advs.Add(advInfo);
}
}
}
#endregion
list.Data = advs.ToList();
list.UpdateTime = DateTime.Now;
EyouSoft.Cache.Facade.EyouSoftCache.Add(cachename, list, DateTime.Today.AddDays(1).AddMinutes(10));
}
return(list.Data);
}
protected string GetAdvCatalog(object position)
{
string catelog = "";
EyouSoft.Model.AdvStructure.AdvPositionInfo posiinfo = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetPositionInfo((EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position.ToString()));
if (posiinfo != null)
{
catelog = posiinfo.Catalog.ToString();
posiinfo = null;
}
return(catelog);
}
/// <summary>
/// 获取广告位置信息
/// </summary>
/// <param name="position"></param>
/// <returns></returns>
public virtual EyouSoft.Model.AdvStructure.AdvPositionInfo GetPositionInfo(EyouSoft.Model.AdvStructure.AdvPosition position)
{
EyouSoft.Model.AdvStructure.AdvPositionInfo info = null;
DbCommand cmd = base.SystemStore.GetSqlStringCommand(SQL_SELECT_GetPositionInfo);
base.SystemStore.AddInParameter(cmd, "PositionId", DbType.Int32, position);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SystemStore))
{
if (rdr.Read())
{
info = new EyouSoft.Model.AdvStructure.AdvPositionInfo();
info.AdvCount = rdr.GetInt32(rdr.GetOrdinal("AdvCount"));
info.Catalog = (EyouSoft.Model.AdvStructure.AdvCatalog)rdr.GetInt32(rdr.GetOrdinal("CatalogId"));
info.DisplayType = (EyouSoft.Model.AdvStructure.AdvDisplayType)rdr.GetByte(rdr.GetOrdinal("DisplayType"));
info.Position = position;
}
}
return(info);
}
/// <summary>
/// 获取广告位置信息集合
/// </summary>
/// <param name="catalog">广告栏目</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.AdvStructure.AdvPositionInfo> GetPositions(EyouSoft.Model.AdvStructure.AdvCatalog catalog)
{
IList <EyouSoft.Model.AdvStructure.AdvPositionInfo> positions = new List <EyouSoft.Model.AdvStructure.AdvPositionInfo>();
DbCommand cmd = base.SystemStore.GetSqlStringCommand(SQL_SELECT_GetPositions);
base.SystemStore.AddInParameter(cmd, "Catalog", DbType.Int32, catalog);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SystemStore))
{
while (rdr.Read())
{
EyouSoft.Model.AdvStructure.AdvPositionInfo tmp = new EyouSoft.Model.AdvStructure.AdvPositionInfo();
tmp.AdvCount = rdr.GetInt32(rdr.GetOrdinal("AdvCount"));
tmp.Catalog = (EyouSoft.Model.AdvStructure.AdvCatalog)rdr.GetInt32(rdr.GetOrdinal("CatalogId"));
tmp.DisplayType = (EyouSoft.Model.AdvStructure.AdvDisplayType)rdr.GetByte(rdr.GetOrdinal("DisplayType"));
tmp.Position = (EyouSoft.Model.AdvStructure.AdvPosition)rdr.GetInt32(rdr.GetOrdinal("AreaId"));
positions.Add(tmp);
}
}
return(positions);
}
private void InitData()
{
string position = Request.QueryString["position"];
DispType = Utils.GetInt(Request.QueryString["dispType"]);
if (!string.IsNullOrEmpty(position))
{
startPosition.Value = position;
EyouSoft.Model.AdvStructure.AdvPositionInfo poinfo = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetPositionInfo((EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position));
if (poinfo != null)
{
switch (poinfo.DisplayType)
{
case EyouSoft.Model.AdvStructure.AdvDisplayType.单位图片广告:
case EyouSoft.Model.AdvStructure.AdvDisplayType.单位图文广告:
case EyouSoft.Model.AdvStructure.AdvDisplayType.单位文字广告:
PagePath = "AddUnitAd.aspx?";
break;
case EyouSoft.Model.AdvStructure.AdvDisplayType.图片广告:
PagePath = "AddPhotoAd.aspx?";
break;
case EyouSoft.Model.AdvStructure.AdvDisplayType.图文广告:
case EyouSoft.Model.AdvStructure.AdvDisplayType.供求图文广告:
PagePath = "AddPhotoWritingAd.aspx?dispType=" + DispType.ToString() + "&";
break;
case EyouSoft.Model.AdvStructure.AdvDisplayType.文字广告:
PagePath = "AddWritingAd.aspx?";
break;
}
;
poinfo = null;
}
}
else
{
MessageBox.ResponseScript(this.Page, "window.location.href='/Default.aspx'");
return;
}
string eecodename = Server.UrlDecode(Request.QueryString["unit"]);
string unitname = eecodename != "" ? eecodename : null;
DateTime?start = null;
if (!string.IsNullOrEmpty(Request.QueryString["start"]))
{
start = Utils.GetDateTime(Request.QueryString["start"]);
}
DateTime?end = null;
if (!string.IsNullOrEmpty(Request.QueryString["end"]))
{
end = Utils.GetDateTime(Request.QueryString["end"]);
}
int province = Utils.GetInt(Utils.GetQueryStringValue("province"), 1);
int city = Utils.GetInt(Utils.GetQueryStringValue("city"), 1);
if (!MasterUserInfo.AreaId.Contains(city))
{
city = int.MaxValue;
}
int relationId = city;
txtUnitName.Value = unitname;
DatePicker1.Value = start == null ? "" : start.Value.ToString("yyyy-MM-dd");
DatePicker2.Value = end == null ? "" : end.Value.ToString("yyyy-MM-dd");
ProvinceAndCityList1.SetCityId = city;
ProvinceAndCityList1.SetProvinceId = province;
ltr_Menu.Text = ((EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position)).ToString() + "广告管理";
//购买单位
int intRecordCount = 0; //总记录数
currentPage = Utils.GetInt(Utils.InputText(Request.QueryString["Page"]), 1);
IList <EyouSoft.Model.AdvStructure.AdvInfo> list = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetAdvs(pageSize, currentPage, ref intRecordCount, (EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position), relationId, unitname, null, start, end, null);
if (list != null && list.Count > 0)
{
crptPhotoList.DataSource = list;
crptPhotoList.DataBind();
this.ExportPageInfo1.intPageSize = pageSize;
this.ExportPageInfo1.CurrencyPage = currentPage;
this.ExportPageInfo1.intRecordCount = intRecordCount;
this.ExportPageInfo1.CurrencyPageCssClass = "RedFnt";
this.ExportPageInfo1.UrlParams = Request.QueryString;
this.ExportPageInfo1.PageLinkURL = "PhotoWritingAdList.aspx?";
this.ExportPageInfo1.LinkType = 3;
list = null;
}
else
{
crptPhotoList.EmptyText = "<tr><td colspan=\"7\"><div style=\"text-align:center; margin-top:75px; margin-bottom:75px;\">暂无广告信息！</span></div></td></tr>";
this.ExportPageInfo1.Visible = true;
}
}
private void InitData()
{
string position = Request.QueryString["position"];
if (!string.IsNullOrEmpty(position))
{
startPosition.Value = position;
EyouSoft.Model.AdvStructure.AdvPositionInfo poinfo = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetPositionInfo((EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position));
if (poinfo != null)
{
switch (poinfo.DisplayType)
{
case EyouSoft.Model.AdvStructure.AdvDisplayType.单位图片广告:
case EyouSoft.Model.AdvStructure.AdvDisplayType.单位图文广告:
case EyouSoft.Model.AdvStructure.AdvDisplayType.单位文字广告:
PagePath = "AddUnitAd.aspx";
break;
case EyouSoft.Model.AdvStructure.AdvDisplayType.图片广告:
PagePath = "AddPhotoAd.aspx";
break;
case EyouSoft.Model.AdvStructure.AdvDisplayType.图文广告:
PagePath = "AddPhotoWritingAd.aspx";
break;
case EyouSoft.Model.AdvStructure.AdvDisplayType.文字广告:
PagePath = "AddWritingAd.aspx";
break;
}
;
poinfo = null;
}
}
else
{
MessageBox.ResponseScript(this.Page, "window.location.href='/Default.aspx'");
return;
}
DateTime?end = null;
DateTime?start = null;
string unitname = Server.UrlDecode(Request.QueryString["unit"]) != ""?Server.UrlDecode(Request.QueryString["unit"]):null;
string category = Utils.GetString(Request.QueryString["category"], "");
string title = Utils.GetString(Server.UrlDecode(Request.QueryString["title"]), "");
int province = Utils.GetInt(Utils.GetQueryStringValue("province"), 1);
int city = Utils.GetInt(Utils.GetQueryStringValue("city"), 0);
if (!string.IsNullOrEmpty(Request.QueryString["start"]))
{
start = Utils.GetDateTime(Request.QueryString["start"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["end"]))
{
end = Utils.GetDateTime(Request.QueryString["end"]);
}
bool IsContain = false;
foreach (var item in MasterUserInfo.AreaId)
{
if (item == city)
{
IsContain = true;
break;
}
}
if (!IsContain)
{
city = int.MaxValue;
}
int relationId = city;
//广告位置
txtTitle.Value = title;
txtUnitName.Value = unitname;
DatePicker1.Value = start == null ? "" : start.Value.ToString("yyyy-MM-dd");
DatePicker2.Value = end == null ? "" : end.Value.ToString("yyyy-MM-dd");
ProvinceAndCityList1.SetCityId = city;
ProvinceAndCityList1.SetProvinceId = province;
ddlCategory.SelectedValue = category;
ltr_Menu.Text = ((EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position)).ToString() + "广告管理";
//购买单位
int intRecordCount = 0; //总记录数
currentPage = Utils.GetInt(Utils.InputText(Request.QueryString["Page"]), 1);
IList <EyouSoft.Model.AdvStructure.AdvInfo> list = null;
if (category != "")
{
list = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetAdvs(pageSize, currentPage, ref intRecordCount, (EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position), relationId, unitname, (EyouSoft.Model.AdvStructure.AdvCategory)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvCategory), category), start, end, title);
}
else
{
list = EyouSoft.BLL.AdvStructure.Adv.CreateInstance().GetAdvs(pageSize, currentPage, ref intRecordCount, (EyouSoft.Model.AdvStructure.AdvPosition)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvPosition), position), relationId, unitname, null, start, end, title);
}
if (list != null && list.Count > 0)
{
crptPhotoList.DataSource = list;
crptPhotoList.DataBind();
this.ExportPageInfo1.intPageSize = pageSize;
this.ExportPageInfo1.CurrencyPage = currentPage;
this.ExportPageInfo1.intRecordCount = intRecordCount;
this.ExportPageInfo1.CurrencyPageCssClass = "RedFnt";
this.ExportPageInfo1.UrlParams = Request.QueryString;
this.ExportPageInfo1.PageLinkURL = "WritingAdList.aspx?";
this.ExportPageInfo1.LinkType = 3;
list = null;
}
else
{
crptPhotoList.EmptyText = "<tr><td colspan=\"7\"><div style=\"text-align:center; margin-top:75px; margin-bottom:75px;\">暂无广告信息！</span></div></td></tr>";
this.ExportPageInfo1.Visible = false;
}
this.ddlCategory.Items.Add(new ListItem("-请选择-", ""));
string[] typeList = Enum.GetNames(typeof(EyouSoft.Model.AdvStructure.AdvCategory));
if (typeList != null && typeList.Length > 0)
{
foreach (string str in typeList)
{
this.ddlCategory.Items.Add(new ListItem(str, ((int)(EyouSoft.Model.AdvStructure.AdvCategory)Enum.Parse(typeof(EyouSoft.Model.AdvStructure.AdvCategory), str)).ToString()));
}
}
ddlCategory.SelectedValue = category;
}
