public ActionResult BannerCreate(bannerModel model)
{
ViewBag.RootImage = ImagePath;
ViewData["BannerPlaceCodeModel1"] = null;
ViewBag.ImagePath = ImagePath;//图片前半段地址
var opera = string.Empty;
if (ModelState.IsValid)
{
ResultModel resultModel = new ResultModel();
if (model.ProductId > 0)
{
ProductModel modelp = GetBannerProductByProductId(model.ProductId);
if (modelp == null)
{
resultModel.Messages = new List <string>()
{
"Invalid product ID"
};
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
}
if (model.bannerId != 0)
{
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
resultModel = this._bannerService.UpdateBanner(model);
resultModel.Messages = new List <string>()
{
resultModel.Data > 0 ? "Modify success" : "Modify failed"
};
opera = string.Format("修改首页轮播banner:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "广告管理--首页轮播banner-修改");
}
else
{
model.bannerId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
model.CreateBy = UserInfo.CurrentUserName;
model.CreateDT = DateTime.Now;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
model.Sorts = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
resultModel = this._bannerService.AddBanner(model);
resultModel.Messages = new List <string>()
{
resultModel.Data != 0 ? "Add success" : "Add failed"
};
opera = string.Format("添加首页轮播banner:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "广告管理--首页轮播banner-添加");
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
ViewBag.Ts = "有未填项";
return(PartialView(model));
}
/// <summary>
/// Banner加载数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult BannerCreate(long?id)
{
bannerModel model = null;
var identityStatus = 5;
ViewBag.ImagePath = ImagePath;//图片前半段地址
ViewBag.RootImage = ImagePath;
if (id.HasValue)
{
ResultModel result = this._bannerService.GetBannerById(id.Value);
if (result.Data != null)
{
model = result.Data;
}
}
else
{
model = new bannerModel();
model.IdentityStatus = identityStatus;//添加控制位置是否显示出来
}
ViewData["BannerPlaceCodeModel1"] = null;
if (identityStatus == 2)
{
ViewData["BannerPlaceCodeModel1"] = con.GetBannerProducPlaceCodeNameList(ACultureHelper.GetLanguageID, 0, identityStatus);
}
//ViewData["IdentityModelBannerCreate"] = con.GetIdentityNameList(new int[] { 1 });
return(PartialView(model));
}
public ActionResult bannerFotoEkle(bannerModel model)
{
Banner yeni = new Banner();
yeni.baslik = model.baslik;
yeni.aciklama = model.aciklama;
if (model.foto != null && model.foto.ContentLength > 0)
{
string dosya = Guid.NewGuid().ToString();
string uzanti = Path.GetExtension(model.foto.FileName).ToLower();
if (uzanti != ".jpg" && uzanti != ".png" && uzanti != ".jpeg")
{
ModelState.AddModelError("foto", "Dosya Uzantısı JPEG,JPG veya PNG olmalı!");
return(View(model));
}
string dosyaAdi = dosya + uzanti;
model.foto.SaveAs(Server.MapPath("~/Content/Banner/" + dosyaAdi));
yeni.resimYol = dosyaAdi;
}
db.Banner.Add(yeni);
db.SaveChanges();
ModelState.Clear();
ViewBag.sonuc = "Fotoğraf Eklendi";
return(View());
}
public JsonResult DeleteBanner(long?bannerId)
{
bannerModel model = new bannerModel();
var resultModel = new ResultModel();
if (bannerId.HasValue)
{
model.bannerId = bannerId.Value;
var result = this._bannerService.DeleteBanner(model).IsValid;
if (result)
{
resultModel.IsValid = true;
resultModel.Messages = new List <string> {
"Delete success"
};
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Delete failed"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Parameter ID error"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 添加banner图片
/// </summary>
/// <param name="model">用banner图片模型</param>
/// <returns>是否成功</returns>
public ResultModel AddBanner(bannerModel model)
{
var result = new ResultModel()
{
Data = base._database.Db.banner.Insert(model)
};
return(result);
}
public ActionResult BannerCreate(bannerModel model)
{
ViewData["BannerPlaceCodeModel1"] = null;
ViewBag.ImagePath = ImagePath;
var opera = string.Empty;
if (model.IdentityStatus == (int)EIdentityStatus.AppFloor)
{
ViewData["BannerPlaceCodeModel1"] = con.GetBannerProducPlaceCodeNameList(ACultureHelper.GetLanguageID, 0, model.IdentityStatus);
}
if (ModelState.IsValid)
{
ResultModel resultModel = new ResultModel();
if (model.ProductId > 0)
{
ProductModel modelp = GetBannerProductByProductId(model.ProductId);
if (modelp == null)
{
resultModel.Messages = new List <string>()
{
"Invalid product ID"
};
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
}
if (model.bannerId != 0)
{
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
resultModel.Messages = new List <string>()
{
this._bannerService.UpdateBanner(model).Data > 0 ? "Modify success" : "Modify failed"
};
opera = string.Format("修改APP首页楼层banner:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "广告管理--APP 首页楼层banner-修改");
}
else
{
model.bannerId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
model.CreateBy = UserInfo.CurrentUserName;
model.CreateDT = DateTime.Now;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
model.Sorts = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
resultModel.Messages = new List <string>()
{
this._bannerService.AddBanner(model).Data != 0 ? "Add success" : "Add failed"
};
opera = string.Format("添加APP 首页楼层banner:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "APP--APP首页楼层banner-添加");
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
return(PartialView(model));
}
//public Result AddCategory(AddCategoryModel model)
//{
// var result = new Result();
// using (var tx = _database.Db.BeginTransaction())
// {
// try
// {
// var category = tx.Category.Insert(model);
// foreach (var lang in model.CategoryLanguageModels)
// {
// lang.CategoryId = category.CategoryId;
// }
// tx.Category_Lang.Insert(model.CategoryLanguageModels);
// tx.Commit();
// }
// catch (Exception ex)
// {
// tx.Rollback();
// result.IsValid = false;
// result.Messages.Add(ex.Message);
// }
// }
// return result;
//}
/// <summary>
/// 删除banner图片
/// </summary>
/// <param name="model">banner图片模型</param>
/// <returns>是否删除成功</returns>
public ResultModel DeleteBanner(bannerModel model)
{
var result = new ResultModel()
{
Data = base._database.Db.banner.Delete(bannerId: model.bannerId)
};
result.IsValid = result.Data > 0 ? true : false;
return(result);
}
/// <summary>
/// 更新banner图片
/// </summary>
/// <param name="model">后banner图片模型</param>
/// <returns>是否修改成功</returns>
public ResultModel UpdateThreeBanner(bannerModel model)
{
var result = new ResultModel()
{
Data = base._database.Db.banner.UpdateBybannerId(bannerId: model.bannerId, bannerName: model.bannerName, bannerPic: model.bannerPic, bannerUrl: model.bannerUrl, ProductId: model.ProductId, UpdateBy: model.UpdateBy, UpdateDT: model.UpdateDT, IdentityStatus: model.IdentityStatus)
};
result.IsValid = result.Data > 0 ? true : false;
return(result);
}
public ActionResult BannerCreate(bannerModel model)
{
ViewData["BannerPlaceCodeModel1"] = null;
ViewBag.ImagePath = ImagePath;
var opera = string.Empty;
if (model.IdentityStatus == 3)
{
ViewData["BannerPlaceCodeModel1"] = con.GetBannerProducPlaceCodeNameList(ACultureHelper.GetLanguageID, 0, model.IdentityStatus);
}
if (ModelState.IsValid)
{
ResultModel resultModel = new ResultModel();
if (model.bannerId != 0)
{
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
resultModel.Messages = new List <string>()
{
this._bannerService.UpdateBanner(model).Data > 0 ? "Modify success" : "Modify failed"
};
opera = " bannerId:" + model.bannerId + ",bannerName:" + model.bannerName + ",bannerUrl:" + model.bannerUrl + ",bannerPic=" + model.bannerPic + ",结果:" + resultModel.Messages;
LogPackage.InserAC_OperateLog(opera, "广告管理--分类频道轮播banner-修改");
}
else
{
model.bannerId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
model.CreateBy = UserInfo.CurrentUserName;
model.CreateDT = DateTime.Now;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
model.Sorts = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
resultModel.Messages = new List <string>()
{
this._bannerService.AddBanner(model).Data != 0 ? "Add success" : "Add failed"
};
opera = " bannerId:" + model.bannerId + ",bannerName:" + model.bannerName + ",bannerUrl:" + model.bannerUrl + ",bannerPic=" + model.bannerPic + ",结果:" + resultModel.Messages;
LogPackage.InserAC_OperateLog(opera, "广告管理--分类频道轮播banner-添加");
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
return(PartialView(model));
}
/// <summary>
/// 获取
/// </summary>
/// <param name="topCount"></param>
/// <returns></returns>
public ResultModel GetTopBannerForApp(int topCount, int identityStatus, int placeCode)
{
dynamic pc;
var tb = base._database.Db.banner;
var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
where = new SimpleExpression(where, tb.IdentityStatus == identityStatus, SimpleExpressionType.And);
where = new SimpleExpression(where, tb.PlaceCode == placeCode, SimpleExpressionType.And);
var result = new ResultModel();
var query = _database.Db.banner
.Query()
.LeftJoin(_database.Db.Product, out pc)
.On(pc.ProductId == tb.ProductId)
.Select(tb.bannerId, tb.ProductId, tb.bannerName, tb.bannerUrl, tb.bannerPic, tb.PlaceCode, tb.IdentityStatus
, tb.Sorts, tb.CreateBy, tb.CreateDT, tb.UpdateBy, tb.UpdateDT, pc.Status)
.Where(where).
OrderBySorts().
ToList <bannerMidModel>();
List <bannerModel> list = new List <bannerModel> ();
foreach (bannerMidModel a in query)
{
if (a.ProductId == 0 || (a.ProductId != 0 && a.Status == 4))
{
bannerModel b = new bannerModel();
b.bannerId = a.bannerId;
b.bannerName = a.bannerName;
b.bannerPic = a.bannerPic;
b.bannerUrl = a.bannerUrl;
b.CreateBy = a.CreateBy;
b.CreateDT = a.CreateDT;
b.IdentityStatus = a.IdentityStatus;
b.PlaceCode = a.PlaceCode;
b.ProductId = a.ProductId;
b.UpdateBy = a.UpdateBy;
b.UpdateDT = a.UpdateDT;
list.Add(b);
}
}
result.Data = list.Take(topCount).ToList <bannerModel>();
return(result);
}
public JsonResult DeleteBanner(long?bannerId)
{
bannerModel model = new bannerModel();
var resultModel = new ResultModel();
if (bannerId.HasValue)
{
model.bannerId = bannerId.Value;
var result = this._bannerService.DeleteBanner(model).IsValid;
if (result)
{
resultModel.IsValid = true;
resultModel.Messages = new List <string> {
"Delete success"
};
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Delete failed"
};
}
var opera = string.Empty;
opera = " bannerId:" + model.bannerId + ",结果:" + resultModel.Messages;
LogPackage.InserAC_OperateLog(opera, "广告管理--首页轮播banner-删除");
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Parameter ID error"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新banner的Sorts
/// </summary>
/// <param name="model">需要上下移动的model</param>
/// <param name="model">需要上下移动的model对应的上下行model</param>
/// <returns>是否修改成功</returns>
public ResultModel UpdateSorts(bannerModel model, bannerModel model1)
{
var result = new ResultModel();
using (var tx = _database.Db.BeginTransaction())
{
try
{
tx.banner.UpdateBybannerId(bannerId: model.bannerId, Sorts: model.Sorts, UpdateBy: model.UpdateBy, UpdateDT: model.UpdateDT);
tx.banner.UpdateBybannerId(bannerId: model1.bannerId, Sorts: model1.Sorts, UpdateBy: model1.UpdateBy, UpdateDT: model1.UpdateDT);
tx.Commit();
}
catch (Exception ex)
{
tx.Rollback();
result.IsValid = false;
result.Messages.Add(ex.Message);
}
}
return(result);
}
/// <summary>
/// Banner加载数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Create(long?id)
{
bannerModel model = null;
var identityStatus = 7;
ViewBag.ImagePath = ImagePath;//图片前半段地址
if (id.HasValue)
{
ResultModel result = this._bannerService.GetBannerById(id.Value);
if (result.Data != null)
{
model = result.Data;
}
}
else
{
model = new bannerModel();
model.IdentityStatus = identityStatus;//添加控制位置是否显示出来
}
return(PartialView(model));
}
//public JsonResult UpdateSorts(long? bannerId, int sx, int Sorts, int IdentityStatus, int BannerPlaceCode)
public JsonResult UpdateSorts(SortsModel modelst)
{
bannerModel model = new bannerModel();
bannerModel modelsx = new bannerModel();
var resultModel = new ResultModel();
resultModel.Messages = new List <string> {
"Parameter ID error"
};
resultModel.IsValid = false;
if (modelst.bannerId > 0)
{
//UserInfoModel asuser = UserInfo.GetLoginUserInfo();
List <bannerModel> ds = null;
//查询
ResultModel result1 = this._bannerService.GetBannerById(modelst.bannerId);
if (result1.Data != null)
{
bannerModel models = new bannerModel();
models = result1.Data;
modelst.bannerId = models.bannerId;
modelst.BannerPlaceCode = models.PlaceCode;
modelst.Sorts = models.Sorts;
modelst.IdentityStatus = models.IdentityStatus;
}
if (modelst.sx == 1)
{
//获取触发行的下一行数据
var resultlist = this._bannerService.GetBanner(modelst.Sorts, 1, modelst.IdentityStatus, modelst.bannerId, modelst.BannerPlaceCode);
ds = resultlist.Data;
if (ds != null && ds.Count > 0)
{
modelsx = ds[0];
modelsx.UpdateBy = UserInfo.CurrentUserName;
modelsx.UpdateDT = DateTime.Now;
var models = modelsx.Sorts;
modelsx.Sorts = modelst.Sorts; //
//this._bannerService.UpdateBanner(smodel);
model.Sorts = models; //触发行修改的排序
}
else
{
resultModel.Messages = new List <string> {
"This is last line!！"
};
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
}
else
{
//获取触发行的上一行数据
var resultlist = this._bannerService.GetBanner(modelst.Sorts, 2, modelst.IdentityStatus, modelst.bannerId, modelst.BannerPlaceCode);
ds = resultlist.Data;
if (ds != null && ds.Count > 0)
{
modelsx = ds[ds.Count - 1];//获取最后一行
modelsx.UpdateBy = UserInfo.CurrentUserName;
modelsx.UpdateDT = DateTime.Now;
var models = modelsx.Sorts;
modelsx.Sorts = modelst.Sorts; //
//this._bannerService.UpdateBanner(smodel1);
model.Sorts = models; //触发行修改的排序
}
else
{
resultModel.Messages = new List <string> {
"This is top line！"
};
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
}
model.bannerId = modelst.bannerId;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
var result = this._bannerService.UpdateSorts(model, modelsx).IsValid;
if (result)
{
resultModel.Messages = new List <string> {
"Move success！"
};
}
else
{
resultModel.Messages = new List <string> {
"Move failed！"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
public static banner ToEntity(this bannerModel model)
{
return(Mapper.Map <banner>(model));
}
public void BannerService_GetBannerById_Test()
{
bannerModel resultModel = this._bannerService.GetBannerById(973840239).Data;
Assert.IsTrue(true);
}
