public JsonHelp FenXiang(DbMallEntities db, Member_Info member) { JsonHelp json = new JsonHelp() { IsSuccess = true, Msg = "" }; var Recommend = db.Member_Info.Where(p => p.MemberId == member.RecommendId).FirstOrDefault(); for (int i = 1; i <= 2; i++) { if (Recommend == null) { return(json); } decimal?amount = 0; if (i == 1) { amount = System.DB.XmlConfig.XmlSite.FenXiang1; } else if (i == 2) { amount = System.DB.XmlConfig.XmlSite.FenXiang1; } if (amount > 0) { InsertFin(db, Recommend, member, amount.Value, "分享消费奖", "分享消费奖"); FuDaoJ(db, Recommend, amount.Value); } Recommend = db.Member_Info.Where(p => p.MemberId == Recommend.RecommendId).FirstOrDefault(); } return(json); }
public List <Sys_BasicData> getBasicDataByType(string type) { using (var db = new DbMallEntities()) { var list = from a in db.Sys_BasicData join b in db.Sys_BasicType.Where(a => a.TypeName == type) on a.TypeId equals b.Id orderby a.SortValue select a; return(list.ToList()); } }
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)); }
public JsonHelp FuDaoJ(DbMallEntities db, Member_Info member, decimal Money) { JsonHelp json = new JsonHelp() { IsSuccess = true, Msg = "" }; var Recommend = DB.Member_Info.FindEntity(member.RecommendId); if (Recommend != null) { var count = DB.Member_Info.Count(p => p.RecommendId == Recommend.MemberId && p.IsActive == "已激活"); if (count >= 3) { decimal?amount = Money * System.DB.XmlConfig.XmlSite.FuDao / 100m; if (amount > 0) { InsertFin(db, Recommend, member, amount.Value, "辅导奖", "辅导奖"); } } } return(json); }
/// <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="member">要增加奖金的会员,</param> /// <param name="refMember">相关的会员,</param> /// <param name="amount">金额</param> /// <param name="db">数据库连接实例</param> /// <param name="typeName">奖金类型名称</param> /// <param name="Comment">奖金描述</param> /// <returns></returns> public JsonHelp InsertFin(DbMallEntities db, Member_Info member, Member_Info refMember, decimal amount, string typeName, string Comment) { JsonHelp json = new JsonHelp(true); if (amount < 0) { json.Msg = "奖金不能小于0"; return(json); } else if (amount == 0) { //奖金为0,直接返回,不向数据库增加数据 json.Msg = "奖金为0"; return(json); } //检查是否锁定此会员不得奖 if (member.IsLockCommission == true) { json.Msg = "此会员已锁定得奖,奖金不能分配"; return(json); } var Poundage = System.DB.XmlConfig.XmlSite.Poundage; var ChongXiao = System.DB.XmlConfig.XmlSite.ChongXiao; //插入费用明细 var mFin = new Fin_Info(); mFin.MemberId = member.MemberId; mFin.MemberCode = member.Code; mFin.NickName = member.NickName; mFin.Amount = amount; if (typeName == "挂卖奖励收益") { mFin.Poundage = 0; mFin.CongXiao = 0; if (typeName == "挂卖奖励收益") { mFin.RealAmount = 2100; } } else { mFin.Poundage = 0; mFin.CongXiao = 0; mFin.RealAmount = mFin.Amount; } mFin.TypeName = typeName; mFin.Comment = string.IsNullOrEmpty(Comment) ? typeName : Comment; mFin.RefMemberId = refMember.MemberId; mFin.RefMemberCode = refMember.Code; mFin.RefNickName = refMember.NickName; mFin.CreateTime = DateTime.Now; mFin.IsSettlement = true; mFin.SettlementTime = mFin.CreateTime; db.Fin_Info.Add(mFin); if (typeName == "挂卖奖励收益") { if (typeName == "挂卖奖励收益") { member.Commission += Convert.ToDecimal(mFin.RealAmount); member.CommissionSum += Convert.ToDecimal(mFin.RealAmount); Fin_LiuShui _liushui = new Fin_LiuShui(); //收益 _liushui.MemberId = member.MemberId; _liushui.Code = member.Code; _liushui.NickName = member.NickName; _liushui.Type = "流水账单"; _liushui.Comment = "收益(+)"; _liushui.Amount = mFin.RealAmount; _liushui.CreateTime = DateTime.Now; DB.Fin_LiuShui.Insert(_liushui); //累计收益 _liushui.MemberId = member.MemberId; _liushui.Code = member.Code; _liushui.NickName = member.NickName; _liushui.Type = "流水账单"; _liushui.Comment = "累计收益(+)"; _liushui.Amount = mFin.RealAmount; _liushui.CreateTime = DateTime.Now; } } else { member.Commission += mFin.RealAmount; member.CommissionSum += mFin.RealAmount; //收益 Fin_LiuShui _liushui = new Fin_LiuShui(); _liushui.MemberId = member.MemberId; _liushui.Code = member.Code; _liushui.NickName = member.NickName; _liushui.Type = "流水账单"; _liushui.Comment = "收益(+)"; _liushui.Amount = mFin.RealAmount; _liushui.CreateTime = DateTime.Now; //累计收益 _liushui.MemberId = member.MemberId; _liushui.Code = member.Code; _liushui.NickName = member.NickName; _liushui.Type = "流水账单"; _liushui.Comment = "累计收益(+)"; _liushui.Amount = mFin.RealAmount; _liushui.CreateTime = DateTime.Now; } json.Msg = "插入奖金成功"; return(json); }
/// <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); }
/// <summary> /// 增加佣金 /// </summary> /// <param name="db">数据库实体</param> /// <param name="member">要增加佣金的会员,</param> /// <param name="refMember">相关的会员,</param> /// <param name="amount">金额</param> /// <param name="db">数据库连接实例</param> /// <param name="typeName">佣金类型名称</param> /// <param name="Comment">佣金描述</param> /// <returns></returns>DbMallEntities public JsonHelp InsertFin(DbMallEntities db, Member_Info member, Member_Info refMember, decimal amount, string typeName, string Comment = "") { JsonHelp json = new JsonHelp(true); if (amount < 0) { json.Msg = "佣金不能小于0"; return(json); } else if (amount == 0) { //佣金为0,直接返回,不向数据库增加数据 json.Msg = "佣金为0"; return(json); } //检查是否锁定此会员不得奖 if (member.IsLockCommission == true) { json.Msg = "此会员已锁定得奖,佣金不能分配"; return(json); } var Poundage = DB.XmlConfig.XmlSite.Poundage; var ChongXiao = DB.XmlConfig.XmlSite.ChongXiao; //插入费用明细 var mFin = new Fin_Info(); mFin.MemberId = member.MemberId; mFin.MemberCode = member.Code; mFin.NickName = member.NickName; mFin.Amount = amount; mFin.Poundage = amount * Poundage / 100m; mFin.CongXiao = amount * ChongXiao / 100m; mFin.RealAmount = mFin.Amount - mFin.Poundage; mFin.TypeName = typeName; mFin.Comment = string.IsNullOrEmpty(Comment) ? typeName : Comment; mFin.RefMemberId = refMember.MemberId; mFin.RefMemberCode = refMember.Code; mFin.RefNickName = refMember.NickName; mFin.CreateTime = DateTime.Now; if (DB.XmlConfig.XmlSite.IsMiaoJie == true) { mFin.IsSettlement = true; mFin.SettlementTime = mFin.CreateTime; } else { mFin.IsSettlement = false; } db.Fin_Info.Add(mFin); if (DB.XmlConfig.XmlSite.IsMiaoJie == true) { var Comminssion = mFin.RealAmount * 50 / 100m; var Coins = mFin.RealAmount * 50 / 100m; member.Commission += Comminssion; member.CommissionSum += Comminssion; member.Coins += Coins; member.ShopCoins += Convert.ToDecimal(mFin.CongXiao); } json.Msg = "插入佣金成功"; return(json); }
// GET: SysManage/Home public ActionResult Index() { var start_day = DateTime.Now.Date; var end_day = start_day.AddDays(1); var start_week = getMonday(); var end_week = getSunday(); var start_month = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var end_month = start_month.AddMonths(1); var start_year = new DateTime(DateTime.Now.Year, 1, 1); var end_year = start_year.AddYears(1); #region 减少数据库查询次数 using (var db = new DbMallEntities()) { var r = db.Sys_Level.Where(a => true).Select(x => new { addMember_dd = db.Member_Info.Count(a => a.CreateTime >= start_day && a.CreateTime < end_day), addMember_week = db.Member_Info.Count(a => a.CreateTime >= start_week && a.CreateTime < end_week), addMember_mm = db.Member_Info.Count(a => a.CreateTime >= start_month && a.CreateTime < end_month), addMember_yy = db.Member_Info.Count(a => a.CreateTime >= start_year && a.CreateTime < end_year), income_dd = db.ShopOrders.Where(a => a.PayTime >= start_day && a.OrderType != "积分优惠价" && a.PayTime < end_day).Sum(a => (decimal?)a.RealAmount) ?? 0, income_week = db.ShopOrders.Where(a => a.PayTime >= start_week && a.OrderType != "积分优惠价" && a.PayTime < end_day).Sum(a => (decimal?)a.RealAmount) ?? 0, income_mm = db.ShopOrders.Where(a => a.PayTime >= start_month && a.OrderType != "积分优惠价" && a.PayTime < end_month).Sum(a => (decimal?)a.RealAmount) ?? 0, income_yy = db.ShopOrders.Where(a => a.PayTime >= start_year && a.OrderType != "积分优惠价" && a.PayTime < end_year).Sum(a => (decimal?)a.RealAmount) ?? 0, income_dds = db.ShopOrders.Where(a => a.PayTime >= start_day && a.OrderType == "积分优惠价" && a.PayTime < end_day).Sum(a => (decimal?)a.RealAmount) ?? 0, income_weeks = db.ShopOrders.Where(a => a.PayTime >= start_week && a.OrderType == "积分优惠价" && a.PayTime < end_day).Sum(a => (decimal?)a.RealAmount) ?? 0, income_mms = db.ShopOrders.Where(a => a.PayTime >= start_month && a.OrderType == "积分优惠价" && a.PayTime < end_month).Sum(a => (decimal?)a.RealAmount) ?? 0, income_yys = db.ShopOrders.Where(a => a.PayTime >= start_year && a.OrderType == "积分优惠价" && a.PayTime < end_year).Sum(a => (decimal?)a.RealAmount) ?? 0, //income_dd = db.ShopOrders.Where(a => a.PayTime >= start_day && a.PayTime < end_day).Sum(a => a.RealAmount), //income_week = db.ShopOrders.Where(a => a.PayTime >= start_week && a.PayTime < end_day).Sum(a => a.RealAmount), //income_mm = db.ShopOrders.Where(a => a.PayTime >= start_month && a.PayTime < end_month).Sum(a => a.RealAmount), //income_yy = db.ShopOrders.Where(a => a.PayTime >= start_year && a.PayTime < end_year).Sum(a => a.RealAmount), expend_dd = db.Fin_Info.Where(a => a.CreateTime >= start_day && a.CreateTime < end_day).Sum(a => a.RealAmount), expend_week = db.Fin_Info.Where(a => a.CreateTime >= start_week && a.CreateTime < end_week).Sum(a => a.RealAmount), expend_mm = db.Fin_Info.Where(a => a.CreateTime >= start_month && a.CreateTime < end_month).Sum(a => a.RealAmount), expend_yy = db.Fin_Info.Where(a => a.CreateTime >= start_year && a.CreateTime < end_year).Sum(a => a.RealAmount), Active_y = db.Sys_Msg.Count(p => p.State == 0), Active_n = db.ShopOrders.Count(p => p.State == 2), Drawcount = db.Fin_Draw.Count(p => p.DrawState == "未发放"), Remitcount = db.Fin_Remit.Count(p => p.RemitState == "申请中") }).FirstOrDefault(); ViewBag.addMember_dd = r.addMember_dd; ViewBag.addMember_week = r.addMember_week; ViewBag.addMember_mm = r.addMember_mm; ViewBag.addMember_yy = r.addMember_yy; ViewBag.income_dd = r.income_dd; ViewBag.income_week = r.income_week; ViewBag.income_mm = r.income_mm; ViewBag.income_yy = r.income_yy; ViewBag.income_dds = r.income_dds; ViewBag.income_weeks = r.income_weeks; ViewBag.income_mms = r.income_mms; ViewBag.income_yys = r.income_yys; ViewBag.expend_dd = r.expend_dd ?? 0; ViewBag.expend_week = r.expend_week ?? 0; ViewBag.expend_mm = r.expend_mm ?? 0; ViewBag.expend_yy = r.expend_yy ?? 0; ViewBag.Active_y = r.Active_y; ViewBag.Active_n = r.Active_n; ViewBag.Drawcount = r.Drawcount; ViewBag.Remitcount = r.Remitcount; ViewBag.OutIn_dd = getOutIn(Convert.ToDecimal(ViewBag.income_dd), Convert.ToDecimal(ViewBag.expend_dd)); ViewBag.OutIn_week = getOutIn(Convert.ToDecimal(ViewBag.income_week), Convert.ToDecimal(ViewBag.expend_week)); ViewBag.OutIn_mm = getOutIn(Convert.ToDecimal(ViewBag.income_mm), Convert.ToDecimal(ViewBag.expend_mm)); ViewBag.OutIn_yy = getOutIn(Convert.ToDecimal(ViewBag.income_yy), Convert.ToDecimal(ViewBag.expend_yy)); } #endregion DB.XmlConfig.AutoSetUrl(Request); ViewBag.LingShouQuZongJin = DB.ShopOrder.Where(p => p.PayTime >= start_day && p.PayTime < end_day && p.OrderType == "零售区").Sum(p => (decimal?)p.RealAmount) ?? 0; ViewBag.LingShouQuCount = DB.ShopOrder.Where(p => p.PayTime >= start_day && p.PayTime < end_day && p.OrderType == "零售区").Sum(p => (decimal?)p.Count) ?? 0; ViewBag.QiangGou = DB.ShopOrder.Where(p => p.PayTime >= start_day && p.PayTime < end_day && p.Type == "挂卖中" && p.OrderType == "批发区").Count();; return(View()); }
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)); }