/// <summary> /// 删除奖项 /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult DeletePrize(int id) { var error = string.Empty; using (var _db = new LuckyDrawEntities()) { var prize = _db.Prizes.Find(id); if (prize != null) { prize.State = false; var result = _db.SaveChanges(); if (result > 0) { return(Json(new { success = true })); } error = "删除失败"; } else { error = "找不到该奖项"; } } return(Json(new { success = false, msg = error })); }
public string GetSmallSetList() { using (LuckyDrawEntities entitys = new LuckyDrawEntities()) { var list = (from a in entitys.SmallSets select a).Where(a => a.num != 0).ToList(); return(JsonHelper.GetJson(list)); } }
public string GetPhotoSetList() { using (LuckyDrawEntities entitys = new LuckyDrawEntities()) { var list = (from a in entitys.PhotoSets select a).ToList(); return(JsonHelper.GetJson(list)); } }
// // GET: /DashBroad/ #region PrizeList #region View /// <summary> /// 奖项列表 /// </summary> /// <returns></returns> public ActionResult PrizeList() { using (var _db = new LuckyDrawEntities()) { var pList = _db.Prizes.Where(x => x.State); return(View("PrizeList", pList.ToArray())); } }
public FileResult Export(RewardViewModel viewmodel) { viewmodel.RewardPageModel = viewmodel.RewardPageModel ?? new RewardPagerModel() { Page = new PageModel() { PageNum = 1 } }; viewmodel.Filter = viewmodel.Filter ?? new RewardFilter(); using (var _db = new LuckyDrawEntities()) { var mpList = Filter(viewmodel.Filter, _db); var stream = WriteFile(mpList.ToArray()); return(File(stream, "text/comma-separated-values", "韩熙获奖列表.csv")); } }
public string InsertSmallSet(string name, int num, string color) { using (LuckyDrawEntities entitys = new LuckyDrawEntities()) { try { SmallSet ss = new SmallSet(); ss.name = name; ss.num = num; ss.color = color; entitys.SmallSets.Add(ss); entitys.SaveChanges(); } catch (Exception) { return(JsonHelper.GetJson("false")); } return(JsonHelper.GetJson("true")); } }
public string SubtractSmall(int id) { using (LuckyDrawEntities entitys = new LuckyDrawEntities()) { try { List <Models.SmallSet> list = entitys.SmallSets.Where(a => a.id == id).ToList(); if (list.Count > 0) { SmallSet ss = list[0]; ss.num = ss.num - 1; entitys.SaveChanges(); } } catch (Exception) { return(JsonHelper.GetJson("false")); } return(JsonHelper.GetJson("true")); } }
/// <summary> /// Deletes the Photo set. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> /// 创建人:李允智 /// 创建时间:2016/1/14 /// 描述:删除照片 public string DelPhotoSet(int id) { using (LuckyDrawEntities entitys = new LuckyDrawEntities()) { try { List <Models.PhotoSet> list = entitys.PhotoSets.Where(a => a.id == id).ToList(); if (list.Count > 0) { PhotoSet ss = list[0]; entitys.PhotoSets.Remove(ss); entitys.SaveChanges(); } } catch (Exception) { return(JsonHelper.GetJson("false")); } return(JsonHelper.GetJson("true")); } }
protected IQueryable <DrawResultModel> Filter(RewardFilter filter, LuckyDrawEntities _db) { var fResult = (from mp in _db.Member_Prize join member in _db.Members on mp.MemberID equals member.Id into Members from m in Members.DefaultIfEmpty() join prize in _db.Prizes on mp.PrizeID equals prize.Id into Prizes from p in Prizes.DefaultIfEmpty() where mp.HasReceived && (!string.IsNullOrEmpty(filter.MemberMobile) ? m.Mobile.Contains(filter.MemberMobile) : true) && (!string.IsNullOrEmpty(filter.MemberName) ? m.Name.Contains(filter.MemberName) : true) && (!string.IsNullOrEmpty(filter.PrizeName) ? p.Name.Contains(filter.PrizeName) : true) select new DrawResultModel() { Member = m, Prize = p, Id = mp.Id, AddTime = mp.AddTime }); return(fResult); }
/// <summary> /// 添加或者编辑奖项 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult EditPrize(Prize model) { using (var _db = new LuckyDrawEntities()) { if (model.Id > 0) { var prize = _db.Prizes.Find(model.Id); if (prize == null) { return(Json(new { success = false, msg = "找不到该奖项" })); } prize.Name = model.Name; prize.Detail = model.Detail; prize.Count = model.Count; prize.Percent = model.Percent; prize.Angle = model.Angle; } else { var prize = new Prize() { Name = model.Name, Angle = model.Angle, Percent = model.Percent, Count = model.Count, Detail = model.Detail, State = true }; _db.Prizes.Add(prize); } var result = _db.SaveChanges(); if (result > 0) { return(Json(new { success = true, item = model })); } } return(Json(new { success = false, msg = "提交失败" })); }
/// <summary> /// 生成轮盘 /// </summary> /// <returns>返回轮盘</returns> public static List <Prize> BuildRoulette() { //生成的轮盘 var roulette = new List <Prize>(); using (LuckyDrawEntities _db = new LuckyDrawEntities()) { var prizeList = _db.Prizes.Where(x => x.State && x.Count > 0); if (!prizeList.Any()) { throw new Exception("没有奖品"); } //抽奖基数 int total = 10000; //奖品列表 var pList = new List <Prize>(); foreach (var p in prizeList) { var pCount = total * p.Percent / 100; for (int i = 0; i < pCount; i++) { pList.Add(p); } } //把奖品随机的放到轮盘中 while (pList.Count > 0) { var pos = rand.Next(pList.Count); roulette.Add(pList[pos]); pList.RemoveAt(pos); } } return(roulette); }
public ActionResult RewardList(RewardViewModel viewmodel) { viewmodel.RewardPageModel = viewmodel.RewardPageModel ?? new RewardPagerModel() { Page = new PageModel() { PageNum = 1 } }; viewmodel.Filter = viewmodel.Filter ?? new RewardFilter(); using (var _db = new LuckyDrawEntities()) { var mpList = Filter(viewmodel.Filter, _db); viewmodel.RewardPageModel.Page.PageCount = (int)Math.Ceiling((decimal)mpList.Count() / (decimal)30); mpList = mpList.OrderBy(x => x.Id).Skip((viewmodel.RewardPageModel.Page.PageNum - 1) * 30).Take(30); viewmodel.RewardPageModel.ResultModel = mpList.ToList(); } return(View(viewmodel)); }
public string InsertPhotoSet(string name, string path, int x, int y, int x2, int y2) { Bitmap bm = new Bitmap(System.Web.HttpContext.Current.Server.MapPath(path)); Bitmap bmpOut = new Bitmap((x2 - x), (y2 - y), PixelFormat.Format24bppRgb); Graphics g = Graphics.FromImage(bmpOut); g.DrawImage(bm, new Rectangle(0, 0, (x2 - x), (y2 - y)), new Rectangle(x, y, (x2 - x), (y2 - y)), GraphicsUnit.Pixel); Random rnd = new Random(); int num = rnd.Next(5000, 1000000); string newpath = "/Data/" + num.ToString() + ".jpg"; bmpOut.Save(System.Web.HttpContext.Current.Server.MapPath(newpath)); g.Dispose(); using (LuckyDrawEntities entitys = new LuckyDrawEntities()) { try { PhotoSet ss = new PhotoSet(); ss.name = name; ss.url = newpath; entitys.PhotoSets.Add(ss); entitys.SaveChanges(); } catch (Exception) { return(JsonHelper.GetJson("false")); } return(JsonHelper.GetJson("true")); } //HttpFileCollection files = System.Web.HttpContext.Current.Request.Files; //if (files.Count > 0) //{ // Random rnd = new Random(); // string path = ""; // HttpPostedFile file = files[0]; // if (file.ContentLength > 0) // { // string fileName = file.FileName; // string extension = Path.GetExtension(fileName); // int num = rnd.Next(5000, 1000000); // path = "/Data/" + num.ToString() + extension; // file.SaveAs(System.Web.HttpContext.Current.Server.MapPath(path)); // } // using (LuckyDrawEntities entitys = new LuckyDrawEntities()) // { // try // { // PhotoSet ss = new PhotoSet(); // ss.name = name; // ss.url = path; // entitys.PhotoSets.Add(ss); // entitys.SaveChanges(); // } // catch (Exception) // { // return JsonHelper.GetJson("false"); // } // return JsonHelper.GetJson("true"); // } //} //else //{ // return JsonHelper.GetJson("false"); //} }