/// <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. }