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