/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(BannerList entity)
{
Func <BannerList, ResultStatus> validate = (_entity) =>
{
return(new ResultStatus());
};
Func <BannerList, ResultStatus> op = (_entity) =>
{
int ret = new BannerListDal().Add(entity);
if (ret > 0)
{
return(new ResultStatus());
}
else
{
return new ResultStatus()
{
Success = false,
Code = StatusCollection.AddFailed.Code,
Description = StatusCollection.AddFailed.Description
}
};
};
return(HandleBusiness(entity, op, validate));
}
public BannerList getBanner(string posCode)
{
BannerList bannerList = new BannerList();
List <Banner> list = new List <Banner>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_BANNER_BY_POSCODE, posCode, "BANNER");
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
Banner banner = new Banner
{
sort = dr["sort"].ToString(),
advname = dr["advname"].ToString(),
advtime = dr["advtime"].ToString(),
advurl = dr["advurl"].ToString(),
imgurl = dr["imgurl"].ToString(),
remark = dr["remark"].ToString()
};
list.Add(banner);
}
}
bannerList.lb = list;
return(bannerList);
}
/// <summary>
/// 绑定列表
/// </summary>
/// <param name="num">显示数量</param>
/// <param name="adid">推荐位id</param>
public void BindBannerList()
{
var adEntity = adbll.GetAll("*", " id in(32,33,34,35)", "", " orderid desc").Entity;
BannerList.DataSource = adEntity;
BannerList.DataBind();
}
private List <BannerList> getNewBannersPath()
{
BannerList objBannerList;
List <BannerList> lstBannerList = new List <BannerList>();
var localPaths = Directory.GetFiles(System.Web.Hosting.HostingEnvironment.MapPath("~/BannerUploads")).Select(f => Path.GetFileName(f)).ToList();
if (localPaths.Count > 0)
{
for (int i = 0; i < localPaths.Count; i++)
{
objBannerList = new BannerList();
FileInfo fi = new FileInfo(localPaths[i]);
//filePaths[i] = @Url.Content("~/BannerUploads/" + localPaths[i]);
// string modifiedDate=localPaths[i].
objBannerList.Banner = @Url.Content("~/BannerUploads/" + localPaths[i]);
objBannerList.BannerModifiedDate = fi.LastWriteTime;
lstBannerList.Add(objBannerList);
}
//= Directory.GetFiles(@Url.Content("~/BannerUploads"));
return(lstBannerList);
}
else
{
return(new List <BannerList>());
}
}
/// <summary>
/// 加载的时候获取数据
/// </summary>
private async void InitData()
{
var netWorkDataResult = await this._netWorkServices.GetAsync <PersonalityRecommend>("FindMusic", "PersonalityRecommend", new { limit = 10 });
if (!netWorkDataResult.Successed)
{
//todo 网络提示信息
return;
}
var temp = netWorkDataResult.Data;
if (temp?.RecommendList != null)
{
// RecommendList.Clear();
//RecommendList.AddRange(temp.RecommendList.Select(x => new PlayListModel(x)));
await RecommendList.AddRangeAsync(temp.RecommendList);
}
if (temp?.AnchorRadioList != null)
{
//AnchorRadioList.Clear();
//AnchorRadioList.AddRange(temp.AnchorRadioList.Select(x => new RadioModel(x)));
await AnchorRadioList.AddRangeAsync(temp.AnchorRadioList);
}
if (temp?.RecommendMvList != null)
{
await RecommendMvList.AddRangeAsync(temp.RecommendMvList);
}
if (temp?.NewMusicList != null)
{
//NewMusicList.Clear();
//NewMusicList.AddRange(temp.NewMusicList);
await NewMusicList.AddRangeAsync(temp.NewMusicList);
}
if (temp?.PrivateContentList != null)
{
await ExclusiveDeliveryList.AddRangeAsync(temp.PrivateContentList);
}
if (temp?.BannerList != null)
{
//BannerList.Clear();
//BannerList.AddRange(temp.BannerList.Select(x => new BannerModel { Image = x.Pic }));
await BannerList.AddRangeAsync(temp.BannerList);
}
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(BannerList entity, IDbTransaction tran)
{
string sql = @"insert into [BannerList]
([bannerimg], [linkurl], [orderid], [adid],[recommendedinfo])
values
(@bannerimg, @linkurl, @orderid, @adid,@recommendedinfo)";
object param = new
{
bannerimg = entity.Bannerimg,
linkurl = entity.Linkurl,
orderid = entity.Orderid,
adid = entity.Adid,
recommendedinfo = entity.Recommendedinfo
};
int count = tran.Connection.Execute(sql, param, tran);
return(count);
}
public int Update(BannerList entity)
{
//GetUpdateSql2
string sql = @"update [BannerList] set bannerimg=@bannerimg, linkurl=@linkurl, orderid=@orderid, adid=@adid,recommendedinfo=@recommendedinfo where id=@id ";
object param = new
{
id = entity.Id,
bannerimg = entity.Bannerimg,
linkurl = entity.Linkurl,
orderid = entity.Orderid,
adid = entity.Adid,
recommendedinfo = entity.Recommendedinfo
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return(count);
}
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(BannerList entity)
{
string sql = @"insert into [BannerList]
([bannerimg], [linkurl], [orderid], [adid],[recommendedinfo])
values
(@bannerimg, @linkurl, @orderid, @adid,@recommendedinfo)";
object param = new
{
bannerimg = entity.Bannerimg,
linkurl = entity.Linkurl,
orderid = entity.Orderid,
adid = entity.Adid,
recommendedinfo = entity.Recommendedinfo
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return(count);
}
}
void subStart()
{
//m_bmBannerList = new ButtonManager ();
//m_bmBannerShop = new ButtonManager ();
foreach (CsvVoiceData data in DataManagerAlarm.Instance.master_voice_list)
{
if (TimeManager.Instance.GetDiffNow(data.release_date).TotalSeconds < 0)
{
if (data.type == 1)
{
GameObject obj = PrefabManager.Instance.MakeObject("prefab/BannerList", m_gridList.gameObject);
BannerList script = obj.GetComponent <BannerList> ();
m_bmBannerList.AddButtonBaseList(obj);
script.Initialize(data);
m_bmBannerListSelect.AddButtonBaseList(script.m_goSelect);
m_bannerList.Add(script);
}
else if (data.type == 2)
{
GameObject obj = PrefabManager.Instance.MakeObject("prefab/BannerShop", m_gridStore.gameObject);
BannerShop script = obj.GetComponent <BannerShop> ();
m_bmBannerShop.AddButtonBaseList(obj);
script.Initialize(data);
m_bmBannerShopSelect.AddButtonBaseList(script.m_goSelect);
m_bannerShop.Add(script);
}
else
{
}
}
}
m_bmBannerList.SetButtonbaseFromList();
m_bmBannerListSelect.SetButtonbaseFromList();
m_bmBannerShop.SetButtonbaseFromList();
m_bmBannerShopSelect.SetButtonbaseFromList();
m_gridList.enabled = true;
m_gridStore.enabled = true;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//return;
IQueryable <vRandBanners> BannerList;
HttpContext context = HttpContext.Current;
if (context.Cache["Banners" + _positionCode] == null)
{
BOLBanners bolBanners = new BOLBanners();
BannerList = bolBanners.GetRandBannersByPositionCode(_positionCode);
context.Cache.Insert("Banners" + _positionCode, BannerList, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero);
}
BannerList = (IQueryable <vRandBanners>)context.Cache["Banners" + _positionCode];
//int BannerCount = BannerList.Count();
if (BannerList.Any())
{
//int RandVal = GetRandRow(BannerCount);
string FileName;
vRandBanners CurBanner = BannerList.First(); //(BannerList.Skip(RandVal).Take(1)).Single();
FileName = CurBanner.BanFile;
if (CurBanner.HCTypeCode == 1)
{
if (CurBanner.TargetUrl != "")
{
hlBanner.NavigateUrl = "http://" + CurBanner.TargetUrl;
}
imgBanner.ImageUrl = "https://static.Khabardaan.ir/Files/Banners/" + FileName;// ResolveUrl("~/") + string.Format("Imager.aspx?ImgFilePath={0}&StaticWidth={1}&StaticHeight={2}", Server.UrlEncode(Tools.Encode("Files/Banners/" + FileName)), CurBanner.Width, CurBanner.Height);
imgBanner.AlternateText = CurBanner.Text;
//hlBanner.Width = (int)CurBanner.Width;
//hlBanner.Height = (int)CurBanner.Height;
}
else if (CurBanner.HCTypeCode == 2)
{
ltrFlash.Visible = true;
ltrFlash.Text = @"<OBJECT classid=""clsid:D27CDB6E-AE6D-11cf-96B8-444553540000""
codebase=""http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,0,0""
ID=awards WIDTH=" + CurBanner.Width + " HEIGHT=" + CurBanner.Height + @">
<PARAM NAME=movie VALUE=""" + ResolveClientUrl("~/Files/Banners/") + CurBanner.BanFile + @""">
<PARAM NAME=quality VALUE=high> <PARAM NAME=bgcolor VALUE=#>
<EMBED src=""" + ResolveUrl("~/Files/Banners/") + CurBanner.BanFile + @""" quality=high bgcolor=# WIDTH=" + CurBanner.Width + " HEIGHT=" + CurBanner.Height + @" TYPE=""application/x-shockwave-flash"" PLUGINSPAGE=""http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash""></EMBED>
</OBJECT>";
hlBanner.Visible = false;
}
else if (CurBanner.HCTypeCode == 3)
{
ltrFlash.Visible = false;
hlBanner.Visible = false;
ltrText.Visible = true;
if (CurBanner.Width != null && CurBanner.Height != null)
{
ltrText.Text = "<div style=\"width:" + CurBanner.Width + "px;height:" + CurBanner.Height + ";\">" + CurBanner.Text + "</div>";
}
else
{
ltrText.Text = CurBanner.Text;
}
}
}
else
{
hlBanner.Visible = false;
}
}
catch (Exception rr)
{
}
//Random rnd = new Random();
//rnd.
}
