public ActionResult Count(SalesCodeModel.SalesCodeModelShow item) { SalesCodeModel data = new SalesCodeModel(); int Num = data.Check_Code_Front(item); //促銷碼已經兌換過 if (Num == -1) { return RedirectToAction("Count", new { Code_Error = -1, Code = item.Code }); } //促銷碼輸入錯誤 else if (Num == -2) { return RedirectToAction("Count", new { Code_Error = -2, Code = item.Code }); } //兌換成功 else { s26webDataContext db = new s26webDataContext(); int Point = db.SalesCode.FirstOrDefault(w => w.Code == item.Code).SalesPromotionPoint; return RedirectToAction("Premiums_complete", new { Point = Point }); } }
public static List<Export> Get_Export(SalesCodeModel data) { /*-------------------匯出宣告-------------------*/ s26webDataContext db = new s26webDataContext(); Export export = new Export(); List<Export> exp = new List<Export>(); List<string> bir = new List<string> { "", "", "" }; var newdata = data.Get().OrderByDescending(o => o.Id); /*-------------------匯出宣告End-------------------*/ foreach (var d in newdata) { export.Id = d.Id.ToString(); export.SalesPromotionName = Get_SalesPromotionName(d.SalesPromotionId); export.Code = d.Code; export.SalesPromotionDeadline = d.SalesPromotionDeadline.ToString("yyyy/MM/dd"); export.SalesPromotionPoint = d.SalesPromotionPoint.ToString(); if (d.ExchangeStatus == true) { export.ExchangeStatus = "已兌換"; } else { export.ExchangeStatus = "未兌換"; } if (d.ExchangeTime != null) { export.ExchangeTime = d.ExchangeTime.Value.ToString("yyyy/MM/dd HH:mm:ss"); } if (d.VolunteersId != 0) { export.VolunteersId = d.VolunteersId.Value.ToString(""); } exp.Add(export); export = new Export(); } db.Connection.Close(); return exp; }
public ActionResult Create(SalesCodeModel.SalesCodeModelShow item) { try { if (data.Insert(item) <= 0) { TempData["err"] = "SalesCode_0"; return RedirectToAction("Index"); } } catch { TempData["err"] = "SalesCode_1"; } return RedirectToAction("Index"); }
public ActionResult Import(string savedFileName, int SalesPromotionId = 0) { var jo = new JObject(); string result; try { var fileName = string.Concat(Server.MapPath(fileSavedPath), "/", savedFileName); var importSalesCodes = new List<SalesCodeModel.ImportClass>(); var helper = new SalesCodeModel(); var checkResult = helper.CheckImportData(fileName, importSalesCodes); jo.Add("Result", checkResult.Success); jo.Add("Msg", checkResult.Success ? string.Empty : checkResult.ErrorMessage); jo.Add("RowCount", checkResult.RowCount); if (checkResult.Success) { //儲存匯入的資料 helper.SaveImportData(importSalesCodes, SalesPromotionId, fileName); } result = JsonConvert.SerializeObject(jo); } catch (Exception ex) { throw; } return Content(result, "application/json"); }
public ActionResult Edit(SalesCodeModel.SalesCodeModelShow item, int p = 1) { if (data.Update(item) <= 0) { TempData["err"] = "SalesCode_5"; return RedirectToAction("Index"); } return RedirectToAction("Index", new { p = p }); }