/// <summary> /// 添加广告 /// </summary> /// <param name="userinfo"></param> /// <returns></returns> public static int AddBanner(banner bann) { sqltext = "insert into [dbo].[banner]([Banner_bg],[Banner_text],[Banner_text1]) values ('" + bann.Banner_bg + "','" + bann.Banner_text + "','" + bann.Banner_text1 + "')"; int i = (int)SQLHelper.ExecuteNonQuery(sqltext); return(i); }
private void Bindbannerforhome() { using (banner obj = new banner()) { StringBuilder strbanner = new StringBuilder(); DataSet ds = new DataSet(); ds = obj.Banner_Select_Bind(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (i == 0) { strbanner.AppendFormat("<div class=\"active\"><img src=\"Admin/upload/banner/" + ds.Tables[0].Rows[i]["image"].ToString() + "\" alt=\"\" height=\"279\" width=\"960\"/><p class=\"arrow\"><a href=\"#\"></a></p></div>"); } else { strbanner.AppendFormat("<div><img src=\"Admin/upload/banner/" + ds.Tables[0].Rows[i]["image"].ToString() + "\" alt=\"\" height=\"279\" width=\"960\"/><p class=\"arrow\"><a href=\"#\"></a></p></div>"); } } bindbanner = strbanner.ToString(); } }
public ActionResult Create([Bind(Include = "Id,name,meta,img")] banner banner, HttpPostedFileBase img) { var path = ""; var filename = ""; if (ModelState.IsValid) { if (img != null) { filename = img.FileName; path = Path.Combine(Server.MapPath("~/Content/images"), filename); img.SaveAs(path); banner.img = filename; } else { banner.img = "logo.png"; } banner.meta = Functions.ConvertToUnSign(banner.name); db.banners.Add(banner); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(banner)); }
public ActionResult SalvarBanner(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } banner Banner = db.banner.Find(id); if (Banner == null) { return(HttpNotFound()); } HttpPostedFileBase file = Request.Files["arquivoFoto"]; if (file.ContentLength > 0) { string _FileName = (DateTime.Now + Path.GetExtension(file.FileName)).ToString(); _FileName = _FileName.Replace("/", "").Replace(":", "").Replace(" ", ""); file.SaveAs(Path.Combine(Server.MapPath("~/img/Home/banners/"), _FileName)); Banner.diretorio = "../../img/Home/banners/" + _FileName; db.Entry(Banner).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Banner")); }
private void FillBannerData() { using (banner badd = new banner()) { DataSet ds = new DataSet(); badd._id = Convert.ToInt64(Request.QueryString["id"]); ds = badd.Banner_Select_byid(); if (ds.Tables[0].Rows.Count > 0) { txttitle.Text = ds.Tables[0].Rows[0]["title"].ToString(); txtrank.Text = ds.Tables[0].Rows[0]["rank"].ToString(); ViewState["image"] = ds.Tables[0].Rows[0]["image"].ToString(); imageup.ImageUrl += ds.Tables[0].Rows[0]["image"].ToString(); imageup.Visible = true; fuimage.Visible = false; Boolean b = Convert.ToBoolean(ds.Tables[0].Rows[0]["active"].ToString()); if (b == true) { ckbactive.Checked = true; } else { ckbactive.Checked = false; } //ViewState["funame"] = ds.Tables[0].Rows[0]["image"].ToString(); title.Text = "Upadate Banner"; btnsubmit.Text = "Update"; } } }
public ActionResult DeleteConfirmed(int id) { banner banner = db.banners.Find(id); db.banners.Remove(banner); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult bannerSil(int id) { try { banner bnr = _banner.getOne(id); bool resultDeleteBanner; if (bnr != null) { if (bnr.bannerBoxInfo.Any()) { List <bannerBoxInfo> boxes = _bannerBoxInfo.getAllByBannerId(bnr.id); foreach (var item in boxes) { _bannerBoxInfo.delete(item); if (System.IO.File.Exists(Server.MapPath(item.boxIconPath))) { System.IO.File.Delete(Server.MapPath(item.boxIconPath)); } } banner bnr1 = _banner.getOne(id);//ilişkili veriler silindikten sonra veri uyuşmazlığı olduğu için hata veriyor. O yüzden veri yeniledim. resultDeleteBanner = _banner.delete(bnr1); if (System.IO.File.Exists(Server.MapPath(bnr1.bannerPath))) { System.IO.File.Delete(Server.MapPath(bnr1.bannerPath)); } } else { resultDeleteBanner = _banner.delete(bnr); if (System.IO.File.Exists(Server.MapPath(bnr.bannerPath))) { System.IO.File.Delete(Server.MapPath(bnr.bannerPath)); } } if (resultDeleteBanner) { return(Json(new { id = 1, message = "Resim Başarıyla Silindi." })); } else { return(Json(new { id = 0, message = "Bu Resim Silinemedi, Başka Bir Yerde Kullanılıyor Olabilir !" })); } } else { return(Json(new { id = 0, message = "Silmek İstediğiniz Resim Bulunamadı!" })); } } catch (Exception e) { return(Json(new { id = 0, message = e.Message })); } }
public ActionResult Edit([Bind(Include = "Id,name,meta,img")] banner banner) { if (ModelState.IsValid) { db.Entry(banner).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(banner)); }
public ActionResult bannerDuzenle(banner bnr, HttpPostedFileBase file, HttpPostedFileBase flash) { if (ModelState.IsValid) { banner changeBanner = _banner.getOne(bnr.id); if (changeBanner != null) { if (flash != null) { if (System.IO.File.Exists(Server.MapPath(changeBanner.onBannerFlashPath))) { System.IO.File.Delete(Server.MapPath(changeBanner.onBannerFlashPath)); } int iconWidth = settings.bannerFlash.Width; int iconHeight = settings.bannerFlash.Height; string iconnewName = ""; if (flash.FileName.Length > 10) { iconnewName = Path.GetFileNameWithoutExtension(flash.FileName.Substring(0, 9)) + Guid.NewGuid() + Path.GetExtension(flash.FileName); } else { iconnewName = Path.GetFileNameWithoutExtension(flash.FileName) + "-" + Guid.NewGuid() + Path.GetExtension(flash.FileName); } var combine = Path.Combine(Server.MapPath("/images/bannerPictures/flash"), iconnewName); if (Directory.Exists(Server.MapPath("/images/bannerPictures/flash"))) { flash.SaveAs(combine); } changeBanner.onBannerFlashPath = "/images/bannerPictures/flash/" + iconnewName; } if (file != null) { if (System.IO.File.Exists(Server.MapPath(changeBanner.bannerPath))) { System.IO.File.Delete(Server.MapPath(changeBanner.bannerPath)); } changeBanner.bannerPath = resimEkle(file, HttpContext, "/images/bannerPictures"); } changeBanner.onBannerText = bnr.onBannerText; changeBanner.onBannerCaption = bnr.onBannerCaption; _banner.update(changeBanner); Session["bannerDuzenle"] = "Banner Başarıyla Düzenlendi"; return(RedirectToAction("bannerDuzenle", "Banner", new { area = "AdminPanel", id = changeBanner.id })); } return(View("bannerDuzenle")); } return(View("bannerDuzenle")); }
private void FillRepeater() { using (banner badd = new banner()) { DataSet dsR = new DataSet(); if (txtserch.Text == "") { dsR = badd.Banner_Select_Alldata(); } else { badd._serch = txtserch.Text.Trim(); dsR = badd.Banner_Select_Searchdata(); } int cnt = dsR.Tables[0].Rows.Count; PagedDataSource page = new PagedDataSource(); page.DataSource = dsR.Tables[0].DefaultView; page.AllowPaging = true; page.PageSize = 5; page.CurrentPageIndex = Pgnm; vcnt = cnt / page.PageSize; if (Pgnm < 1) { linkprev.Visible = false; } else if (Pgnm > 0) { linkprev.Visible = true; } if (Pgnm == vcnt) { linknext.Visible = false; } if (Pgnm < vcnt) { linknext.Visible = true; } if (dsR.Tables[0].Rows.Count > 0) { rptbanner.DataSource = page; rptbanner.DataBind(); if (txtserch.Text != "") { lblMessage.Text = " Record Found :" + dsR.Tables[0].Rows.Count; messagegreen.Visible = true; } } else { rptbanner.Visible = false; } } }
public ActionResult Create([Bind(Include = "Id,name,meta,img")] banner banner) { if (ModelState.IsValid) { db.banners.Add(banner); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(banner)); }
protected void btnsubmit_Click(object sender, EventArgs e) { using (banner badd = new banner()) { badd._title = txttitle.Text.Trim(); badd._rank = Convert.ToInt64(txtrank.Text.Trim()); if (fuimage.Visible == true) { if (fuimage.HasFile) { //string strss = System.DateTime.Today.ToString(); //string[] strs = new string[10]; //strs = strss.Split(' '); string imagename = fuimage.FileName; fuimage.SaveAs(Server.MapPath("upload\\banner\\") + imagename); badd._imagename = imagename.Trim(); } else { } } else { badd._imagename = ViewState["image"].ToString(); } if (ckbactive.Checked == true) { badd._active = true; } else { badd._active = false; } if (btnsubmit.Text == "Update") { //if (!fuimage.HasFile) //{ // badd._imagename = ViewState["funame"].ToString(); //} badd._id = Convert.ToInt64(Request.QueryString["id"].ToString()); badd.img_update(); Response.Redirect("Bannerrepeter.aspx?flag=edit"); } else { badd.img_insert(); Response.Redirect("Bannerrepeter.aspx?flag=add"); } } }
public banner find_banner_By_AppId(string Appid) { try { banner = db.banners.SingleOrDefault(a => a.app_id == Appid); return(banner); } catch (Exception) { return(null); } }
public banner find_banner_By_ID(int id) { try { banner = db.banners.SingleOrDefault(a => a.id == id); return(banner); } catch (Exception) { return(null); } }
public banner delete_banner() { try { banner prev_banner = db.banners.SingleOrDefault(a => a.id == banner.id); db.banners.DeleteOnSubmit(prev_banner); return(banner); } catch (Exception) { return(null); } }
// GET: Admin/banners/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } banner banner = db.banners.Find(id); if (banner == null) { return(HttpNotFound()); } return(View(banner)); }
public ActionResult DeleteConfirmed(int id) { if (Session["User"] == null) { return(RedirectToAction("Logout", "Account")); } banner banner = db.banners.Find(id); //db.banners.Remove(banner); banner.ngaycapnhat = DateTime.Now; banner.daxoa = true; db.Entry(banner).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult _Create([Bind(Include = "id,c_time,c_id,u_time,u_id,banner_switch,sort,banner_top,banner,center,under,img,url,action,remark")] banner banner, HttpPostedFileBase file) { if (ModelState.IsValid && file != null) { if (file.ContentLength > 0) { string path = Path.Combine(Server.MapPath("~/image/banner/"), file.FileName); file.SaveAs(path); } banner.img = file.FileName; db.banner.Add(banner); db.SaveChanges(); return(RedirectToAction("Index")); } return(PartialView(banner)); }
protected void rptbanner_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "EditData") { Response.Redirect("banneradd.aspx?id=" + e.CommandArgument.ToString()); } if (e.CommandName == "DeleteData") { using (banner badd = new banner()) { badd._id = Convert.ToInt64(e.CommandArgument.ToString()); badd.img_delete(); FillRepeater(); } } }
public ActionResult Mod([Bind(Include = "id,c_time,c_id,u_time,u_id,switch,sort,top_,banner1,center,under,img,url,action,remark")] banner banner, HttpPostedFileBase file) { if (ModelState.IsValid && file != null) { if (file.ContentLength > 0) { string path = Path.Combine(Server.MapPath("~/image/banner/"), file.FileName); file.SaveAs(path); } banner.img = file.FileName; db.Entry(banner).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(banner)); }
public ActionResult Edit([Bind(Include = "id,tenbanner,urlbanner,motabanner,ghichu,ngaytao,ngaycapnhat,nguoitao,hienthi,thutuhien,daxoa,loaibanner")] banner banner) { if (Session["User"] == null) { return(RedirectToAction("Logout", "Account")); } if (ModelState.IsValid) { banner.ngaycapnhat = DateTime.Now; db.Entry(banner).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.nguoitao = new SelectList(db.admin_account, "id", "username", banner.nguoitao); ViewBag.loaibanner = new SelectList(db.loaibanners, "id", "tenloaibanner", banner.loaibanner); return(View(banner)); }
public ActionResult Edit(banner obanner, HttpPostedFileBase file) { if (file != null) { obanner.bannerImgURL = UploadFile(file, "/bannersImg"); } else { TempData["result"] = "Please upload banner image"; return(View(obanner)); } if (_IsettingServices.uploadBanner(obanner) == 1) { TempData["result"] = "Banner updated. "; } return(View(obanner)); }
// GET: Admin/banners/Details/5 public ActionResult Details(int?id) { if (Session["User"] == null) { return(RedirectToAction("Logout", "Account")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } banner banner = db.banners.Find(id); if (banner == null) { return(HttpNotFound()); } return(View(banner)); }
protected void btnSubmit_Click(object sender, EventArgs e) { //首先获取上传控件中文件的地址 string fullfilenam = FileUpload1.PostedFile.FileName; //其次从上传的路径中获取文件名,采用字符串分割的方法 string filename = fullfilenam.Substring(fullfilenam.LastIndexOf("\\") + 1); //分割上传文件的后缀,用来限制上传文件格式 string type = fullfilenam.Substring(fullfilenam.LastIndexOf(".") + 1); //判断文件上传的后缀名类型 ,当前格式可以自定义,写出自己需要的格式即可 if (type == "xls" || type == "doc" || type == "jpg" || type == "png") { //将文件保存在当前服务器路径中自己新建的文件(file)中 //将当前文件保存的路径做一个完整拼接。用于待会存放数据库 string savefilename = Server.MapPath("~/images") + "\\" + filename; if (savefilename == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript'>alert('当前文件路径不存在')</script>"); return; } //将文件进行保存操作 FileUpload1.PostedFile.SaveAs(savefilename); //将当前文件信息全部保存到数据库中,用于下载的时候进行读取 banner bann = new banner(); bann.Banner_bg = filename; bann.Banner_text = txttitle.Text; bann.Banner_text1 = TextBox1.Text; //执行添加操作 if (BLL.AdminManager.AddBanner(bann) > 0) { //弹出对话框表示文件保存成功 Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript'>alert('文件上传成功')</script>"); txttitle.Text = ""; TextBox1.Text = ""; } } else { //给出文件上传失败的提示 Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript'>alert('文件上传失败')</script>"); } }
public ActionResult uploadbanner(banner obanner, HttpPostedFileBase file) { if (file != null) { obanner.bannerImgURL = UploadFile(file, "/bannersImg"); } else { TempData["result"] = "Please upload banner image"; return(View()); } if (_IsettingServices.uploadBanner(obanner) == 1) { TempData["result"] = "Banner uploaded. "; return(RedirectToAction("availablebanners")); } return(View()); }
public int uploadBanner(banner obanner) { obanner.modifiedBy = Convert.ToInt64(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()).ToString()); obanner.modifiedDate = BaseUtil.GetCurrentDateTime(); obanner.userId = Convert.ToInt64(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()).ToString()); if (obanner.bannerId == 0) { obanner.createdBy = Convert.ToInt64(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString()).ToString()); obanner.createdDate = BaseUtil.GetCurrentDateTime(); obanner.isDelete = false; uow.banner_.Add(obanner); return(1); } else { uow.banner_.Update(obanner); return(1); } }
// GET: Admin/banners/Edit/5 public ActionResult Edit(int?id) { if (Session["User"] == null) { return(RedirectToAction("Logout", "Account")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } banner banner = db.banners.Find(id); if (banner == null) { return(HttpNotFound()); } ViewBag.nguoitao = new SelectList(db.admin_account, "id", "username", banner.nguoitao); ViewBag.loaibanner = new SelectList(db.loaibanners, "id", "tenloaibanner", banner.loaibanner); return(View(banner)); }
public banner alter_banner() { try { banner prev_banner = db.banners.SingleOrDefault(a => a.id == banner.id); prev_banner.position = banner.position; prev_banner.url = banner.url; prev_banner.alt = banner.alt; prev_banner.source = banner.source; db.SubmitChanges(); return(banner); } catch (Exception) { return(null); } }
public ActionResult AddBanner(banner banner) { var data = Request["data"]; var bannerData = SerializeHelper.SerializeToObject <dynamic>(data); banner.img_url = bannerData.img_url; banner.link_address = bannerData.link_address; banner.remark = bannerData.remark; banner.sort = bannerData.sort; banner.add_time = DateTime.Now; banner.add_admin = nowManager.name; //banner.thumbnail_url = bannerData.thumbnail_url; banner.state = bannerData.state ?? 1; var res = BannerService.AddEntity(banner); if (res.id > 0) { SaveSyslog($"添加广告图(id={res.id})成功", SysLogType.后台日志, nowManager.name); return(Json(SysEnum.成功, "添加成功")); } return(Json(SysEnum.失败, "添加失败")); }
public ActionResult Edit([Bind(Include = "Id,name,meta,img")] banner banner, HttpPostedFileBase img) { var path = ""; var filename = ""; banner temp = getById(banner.Id); if (ModelState.IsValid) { if (img != null) { filename = DateTime.Now.ToString("dd-MM-yy-hh-mm-ss") + img.FileName; path = Path.Combine(Server.MapPath("~/Content/images"), filename); img.SaveAs(path); temp.img = filename; } temp.name = banner.name; temp.meta = Functions.ConvertToUnSign(banner.meta); db.Entry(temp).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(banner)); }