public JsonHelp Delete(string idList) { JsonHelp json = new JsonHelp() { Status = "n", Msg = "删除数据失败" }; try { //是否为空 if (string.IsNullOrEmpty(idList)) { json.Msg = "未找到要删除的数据"; return(json); } var id = idList.TrimEnd(',').Split(',').Select(a => Convert.ToInt32(a)).ToList(); try { using (var db = new DbMallEntities()) { //删除订单的同时,奖下单时产生的电子币加回去 var list = db.Bill_Info.Where(a => id.Contains(a.BillId)); if (list.Any(a => a.State == "已发货")) { json.Msg = "选择订单中包含已发货订单,请重新选择;"; return(json); } foreach (var item in list) { var member = db.Member_Info.Find(item.MemberId); member.Coins += item.TotalPrice; db.Bill_Info.Remove(item); } //删除这些对象 var r = db.SaveChanges(); if (r > 0) { json.Status = "y"; json.Msg = "删除数据成功"; //添加操作日志 DB.SysLogs.setAdminLog(Enums.EventType.Delete, "删除 ID为【" + idList + "】的订单信息"); } } } catch { throw; } return(json); } catch (Exception e) { throw e.InnerException; } }
public ActionResult ResetRPosition(string q) { if (q == "zhijukejixsy888") { using (var db = new DbMallEntities()) { var list = db.Member_Info.ToList(); var admin = list.FirstOrDefault(a => a.Code == "admin"); admin.RPosition = "0|"; updatechild_rposition(admin, list); db.SaveChanges(); } return(Content(DateTime.Now + "_succss")); } return(View()); }
/// <summary> /// 收益结算 /// </summary> /// <param name="date"></param> /// <param name="db"></param> /// <param name="curPrice"></param> /// <param name="isBefore">是否结算date以前的</param> public void ToSettlement(DateTime date, DbMallEntities db, bool isBefore) { Stopwatch sw = new Stopwatch(); sw.Start(); int count = 0; var start = date.Date; var end = start.AddDays(1); var query = db.Fin_Info.Where(a => true && a.CreateTime < end); if (isBefore == false) { query = query.Where(a => a.CreateTime >= start); } var list = query.ToList(); var memberids = list.GroupBy(a => a.MemberId).Select(a => a.Key).ToList(); var members = db.Member_Info.Where(a => memberids.Contains(a.MemberId)).ToList(); foreach (var item in members) { #region 更新收益 var comList = list.Where(a => a.MemberId == item.MemberId).ToList(); if (comList.Count > 0) { foreach (var citem in comList) { citem.IsSettlement = true; citem.SettlementTime = DateTime.Now; } //更新会员收益 var realAmount = comList.Sum(a => a.RealAmount) ?? 0; item.Commission += realAmount; item.CommissionSum += realAmount; count++; } #endregion } db.SaveChanges(); sw.Stop(); LogHelper.Info(string.Format("收益结算 日期:{2},会员[{0}]个,分配奖[{3}]个,用时:[{1}]]", list.Count, sw.Elapsed, date.ToString("yyyy-MM-dd"), count)); }
/// <summary> /// 定时任务执行的内容 /// </summary> /// <param name="sender"></param> /// <param name="ex"></param> public void TimerHanlder() { #region 这里写你的定时任务要执行的程序代码(数据库操作,不要使用 Business.DB,请重新自定义个上下文) using (var DB = new DbMallEntities()) { var list = DB.ShopOrders.Where(p => p.Type == "未挂卖").ToList(); foreach (var item in list) { if ((int)Math.Floor((DateTime.Now - item.SubmitTime).TotalHours) >= 48) { item.State = ShopEnum.OrderState.Cancel.GetHashCode(); item.Type = "已超时"; var member = DB.Member_Info.Where(p => p.MemberId == item.MemberID).FirstOrDefault(); member.Commission = member.Commission + item.RealScore; member.CommissionSum = member.CommissionSum + item.RealScore; member.Scores = member.Scores + item.RealCongXiao; } } var listMember = DB.ShopOrders.Where(p => p.Type == "挂卖中" && p.State == 40).ToList(); foreach (var item in listMember) { if ((int)Math.Floor((DateTime.Now - item.SubmitTime).TotalHours) >= 168) { item.State = ShopEnum.OrderState.Finish.GetHashCode(); item.Type = "挂卖成功"; item.FinishTime = DateTime.Now; var member = DB.Member_Info.Where(p => p.MemberId == item.MemberID).FirstOrDefault(); //DB.Jiang.InsertFin(member, member, 800, "挂卖奖励积分", "挂卖奖励积分");//积分 InsertFin(DB, member, member, 2100, "委托奖励收益", "委托奖励收益");//收益 //分享消费奖 FenXiang(DB, member); //辅导奖 } } DB.SaveChanges(); } #endregion }
/// <summary> /// 保存 /// </summary> /// <param name="role">角色对象</param> /// <param name="rolenav">权限集合</param> /// <param name="id">权限ID</param> /// <returns></returns> public JsonHelp Save(int id, string name, byte roletype, string rolenav) { JsonHelp json = new JsonHelp() { Status = "n", Msg = "保存失败" }; List <Sys_Role_Nav> role_nav = new List <Sys_Role_Nav>(); using (var db = new DbMallEntities()) { try { if (!Any(p => p.id == id)) { Sys_Role entity = new Sys_Role(); entity.role_name = name; entity.role_type = roletype; db.Sys_Role.Add(entity); db.SaveChanges(); var str = rolenav.Trim(',').Split(','); for (int i = 0; i < str.Length; i++) { var role_name = str[i].Split('&')[0]; var role_type = str[i].Split('&')[1]; Sys_Role_Nav role = new Sys_Role_Nav(); role.role_id = entity.id; role.nav_name = role_name.ToString(); role.action_type = role_type.ToString(); role_nav.Add(role); db.Sys_Role_Nav.Add(role); } db.SaveChanges(); json.Status = "y"; json.Msg = "保存成功"; DB.CacheRoleId++; //添加操作日志 DB.SysLogs.setAdminLog("Add", "新建名称为[" + entity.role_name + "]的角色"); } else { var model = db.Sys_Role.Find(id); model.id = id; model.role_name = name; model.role_type = roletype; var str = rolenav.Trim(',').Split(','); for (int i = 0; i < str.Length; i++) { var role_name = str[i].Split('&')[0]; var role_type = str[i].Split('&')[1]; Sys_Role_Nav role = new Sys_Role_Nav(); role.role_id = id; role.nav_name = role_name.ToString(); role.action_type = role_type.ToString(); role_nav.Add(role); } var oldNav = db.Sys_Role_Nav.Where(p => p.role_id == id); //先删除原来多余的 foreach (var item in oldNav) { var exsit = role_nav.Any(a => a.nav_name == item.nav_name && a.action_type == item.action_type); if (exsit == false) { db.Sys_Role_Nav.Remove(item); } } //再添加原来没有的 foreach (var item in role_nav) { var exsit = oldNav.FirstOrDefault(a => a.nav_name == item.nav_name && a.action_type == item.action_type); if (exsit == null) { db.Sys_Role_Nav.Add(item); } } db.SaveChanges(); json.Status = "y"; json.Msg = "保存成功"; DB.CacheRoleId++; //添加操作日志 DB.SysLogs.setAdminLog("Edit", "更新名称为[" + name + "]的角色"); } } catch (Exception e) { json.IsSuccess = false; LogHelper.Error("角色保存失败:" + e.Message); } } return(json); }
/// <summary> /// 保存 /// </summary> /// <param name="entity"></param> /// <returns></returns> public JsonHelp Save(Allocation_Info entity) { var json = new JsonHelp(true, "分红成功"); using (var db = new DbMallEntities()) { try { if (entity.StartTime != null) { entity.StartTime = entity.StartTime.Value.AddDays(1); } #region 给每个会员分红 var list = db.Member_Info.Where(a => a.IsActive == "已激活" && a.Code != "admin" && a.IsNullActive != true && a.IsLockFen != true); decimal?sum = 0M; var nullMember = new Member_Info(); var comment1 = "分红奖"; var comment2 = "分红奖累计已达到投资额,后面将不再产生分红奖"; foreach (var item in list) { //var ReCount = db.Member_Info.Count(p => p.RecommendId == item.MemberId && p.IsActive == "已激活"); //decimal? FengD = 0; //if (ReCount >= 2) //{ // FengD = item.ActiveAmount * 2; //} //else if (ReCount >= 1) //{ // FengD = item.ActiveAmount * 1.5m; //} //else if (ReCount < 1) //{ // FengD = item.ActiveAmount; //} decimal?FengD = 0; if (item.MemberLevelId == 1) { FengD = item.ActiveAmount * 1; } else if (item.MemberLevelId == 2) { FengD = item.ActiveAmount * 1.5m; } else if (item.MemberLevelId == 3) { FengD = item.ActiveAmount * 2; } //判断分红金额累计 是否 会超过 投资额(这里的条件是以投资额作为封顶) var realAmount = entity.PerAmount; if (item.MemberLevelId == 1) { realAmount = entity.PerAmount; } else if (item.MemberLevelId == 2) { realAmount = entity.PerAmount2; } else if (item.MemberLevelId == 3) { realAmount = entity.PerAmount3; } string comment = comment1; if (FengD <= realAmount + item.FHSum) { comment = comment2; realAmount = FengD - item.FHSum; if (realAmount < 0) { realAmount = 0; } } sum += realAmount; //求总的实发金额 item.FHSum = item.FHSum + realAmount; //插入收益 json = DB.Jiang.InsertFin(db, item, nullMember, realAmount.Value, "分红", comment); } #endregion #region 更新实际金额(总) entity.RealAmount = sum; db.Allocation_Info.Add(entity); #endregion db.SaveChanges(); } catch (Exception e) { json.IsSuccess = false; LogHelper.Error("分红失败:" + WebTools.getFinalException(e)); } } return(json); }
public ActionResult Save(ShopProduct entity) { var json = new JsonHelp(); //var shangpin = DB.ShopProductCategory.FindEntity(p => p.ID == entity.CategoryID1); var shop = DB.Shop.FindEntity(p => p.ID == 1); entity.UpdateTime = DateTime.Now; var imgs1 = Request["imgpath1"]; var imgs2 = Request["imgpath2"]; try { using (var db = new DbMallEntities()) { if (entity.ID == 0) { // entity.PriceCongXiao = 0; //if (entity.CategoryID1 == ShopEnum.ShopType.订单商品.GetHashCode()) //{ // entity.PriceScore = 0; // entity.PriceVip = 0; //} if (shop == null) { json.IsSuccess = false; json.Msg = "添加失败,您暂无商家权限"; return(Json(json)); } else if (shop.IsCheck != true) { json.IsSuccess = false; json.Msg = "添加失败,您暂无商家权限"; return(Json(json)); } //if (shangpin.Name == "优选区") //{ // if (entity.PriceShopping < 1) // { // json.IsSuccess = false; // json.Msg = "添加失败,现金价不准为0"; // return Json(json); // } // if (entity.PV < 1) // { // json.IsSuccess = false; // json.Msg = "添加失败,积分价不准为0"; // return Json(json); // } //} //else if (shangpin.Name == "消费区") //{ // if (entity.PriceShopping < 1) // { // json.IsSuccess = false; // json.Msg = "添加失败,现金价不准为0"; // return Json(json); // } // if (entity.PV > 1) // { // json.IsSuccess = false; // json.Msg = "添加失败,积分不需要填写"; // return Json(json); // } //} db.ShopProducts.Add(entity); db.SaveChanges(); #region 添加商品相册图片 if (!string.IsNullOrEmpty(imgs1) && imgs1.EndsWith("&")) { var list1 = imgs1.Substring(0, imgs1.Length - 1).Split('&'); var list2 = imgs2.Substring(0, imgs2.Length - 1).Split('&'); if (list1.Length == list2.Length) { var xlist = new List <ShopProductImage>(); for (int i = 0; i < list1.Length; i++) { var img = new ShopProductImage() { CreateTime = DateTime.Now, ProductID = entity.ID, Sort = i + 1, URL = list1[i], ThumURL = list2[i] }; db.ShopProductImages.Add(img); } var first = db.ShopProducts.FirstOrDefault(a => a.ID == entity.ID); first.Image = list1[0]; } else { json.IsSuccess = false; json.Msg = "添加失败,请重试商品图片"; return(Json(json)); } } #endregion json.Msg = "添加"; } else { var first = db.ShopProducts.FirstOrDefault(a => a.ID == entity.ID); WebTools.CopyToObject(entity, first); //json.IsSuccess = DB.ShopProduct.Update(first); #region 修改商品相册图片 //if (json.IsSuccess) { if (!string.IsNullOrEmpty(imgs1) && imgs1.EndsWith("&")) { var list1 = imgs1.Substring(0, imgs1.Length - 1).Split('&'); var list2 = imgs2.Substring(0, imgs2.Length - 1).Split('&'); if (list1.Length == list2.Length) { var olds = db.ShopProductImages.Where(a => a.ProductID == entity.ID); #region 先删除多余的图片 foreach (var item in olds) { var exsit = list1.Any(a => a == item.URL); if (exsit == false) { db.ShopProductImages.Remove(item); } } #endregion #region 再添加原来没有的 for (int i = 0; i < list1.Length; i++) { var cururl = list1[i]; var exsit = olds.FirstOrDefault(a => a.URL == cururl); if (exsit == null) { var img = new ShopProductImage() { CreateTime = DateTime.Now, ProductID = entity.ID, Sort = i + 1, URL = list1[i], ThumURL = list2[i] }; db.ShopProductImages.Add(img); } } #endregion if (list1.Length > 0) { first.Image = list1[0]; } } else { json.IsSuccess = false; } } } #endregion json.Msg = "修改"; } db.SaveChanges(); json.IsSuccess = true; } } catch (Exception e) { json.IsSuccess = false; LogHelper.Error("商品添加失败:" + WebTools.getFinalException(e)); } if (json.IsSuccess) { json.ReUrl = ControllerPath + "/Index"; //注册成功就跳转到 激活页 json.Msg += "成功"; } else { json.Msg += "失败"; } return(Json(json)); }