private List <BannerDetailsModel> GetBannerList()
{
List <BannerDetailsModel> results = new List <BannerDetailsModel>();
List <BANNER> data = new List <BANNER>();
try
{
data = DB.BANNER
.Where(o => o.DISABLE == false)
.OrderByDescending(o => o.BUD_DT).ThenByDescending(g => g.SQ)
.ToList();
FileModule fileModule = new FileModule();
using (var bannerModule = new BannerModule())
{
foreach (var d in data)
{
PublicMethodRepository.HtmlDecode(d);
BannerDetailsModel temp = bannerModule.DoGetDetailsByID(d.ID);
temp.Files = fileModule.GetFiles((int)d.ID, "Banner", "F");
results.Add(temp);
}
}
fileModule.Dispose();
}
catch (Exception ex)
{
throw ex;
}
return(results);
}
public ActionResult BannerEdit(int?ID)
{
if (!ID.HasValue)
{
return(RedirectToAction("BannerList"));
}
BannerDetailsModel model = new BannerDetailsModel();
using (BannerModule module = new BannerModule())
{
model = module.DoGetDetailsByID((int)ID);
}
FileModule fileModule = new FileModule();
model.Files = fileModule.GetFiles((int)model.ID, "Banner", "F");
return(View(model));
}
public ActionResult BannerSave(BannerDataModel model)
{
int id = 0;
using (BannerModule module = new BannerModule())
{
if (model.OldFilesId.Count == 0 && model.Files.Count == 0)
{
TempData["UndefinedFile"] = "請上傳檔案";
return(RedirectToAction("BannerEdit", new { ID = (int?)null }));
}
id = module.DoSaveData(model);
}
var redirectUrl = new UrlHelper(Request.RequestContext).Action("BannerEdit", "_SysAdm", new { ID = id });
return(Json(new { Url = redirectUrl }));
}
// 首頁banner
public ActionResult BannerList(int?page, string qry, string sort, string disable, string pDate)
{
BannerListViewModel model = new BannerListViewModel();
model.Filter.CurrentPage = page ?? 1;
model.Filter.QueryString = qry ?? string.Empty;
model.Filter.SortColumn = sort ?? string.Empty;
model.Filter.Disable = disable ?? string.Empty;
model.Filter.PublishDate = pDate;
using (BannerModule module = new BannerModule())
{
model.Result = module.DoGetList(model.Filter);
}
return(View(model));
}
public JsonResult BannerDelete(int?ID)
{
bool success = true;
string messages = string.Empty;
try
{
using (BannerModule module = new BannerModule())
{
module.DoDeleteByID((int)ID);
}
messages = "刪除成功";
}
catch (Exception ex)
{
success = false;
messages = ex.Message;
}
var resultJson = Json(new { success = success, messages = messages });
return(resultJson);
}
