/// <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));
}
