/// <summary> /// 查询日志 /// </summary> /// <param name="objectId"></param> /// <param name="type"></param> /// <returns></returns> public List <RegionMarketingLog> SelectOperationLog(Guid objectId, string type) { List <RegionMarketingLog> result = new List <RegionMarketingLog>(); try { result = DALRegionMarketing.SelectOperationLog(objectId, type); } catch (Exception ex) { logger.Log(Level.Error, ex, "ConfigLog"); } return(result); }
public List <RegionMarketingModel> GetRegionMarketingConfig(Guid?activityId, string activityName, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize) { List <RegionMarketingModel> result = new List <RegionMarketingModel>(); try { result = dbScopeReadManager.Execute(conn => DALRegionMarketing.SelectRegionMarketingConfig(conn, activityId, activityName, startTime, endTime, pageIndex, pageSize)); } catch (Exception ex) { logger.Log(Level.Error, ex, "GetRegionMarketingConfig"); } return(result); }
public bool DeleteRegionMarketingConfig(Guid activityId, string user) { var result = false; try { result = dbScopeManager.Execute(conn => DALRegionMarketing.DeleteRegionMarketingConfig(conn, activityId)) > 0; } catch (Exception ex) { logger.Log(Level.Error, ex, ""); } if (result) { InsertLog("DeleteRegionMarketingConfig", activityId, "", "删除活动", user, LogType); CallCRMService.NewDeleteActivityBySourceId(activityId.ToString(), CRMSourceType.TiresActivityOne, user); } return(result); }
public RegionMarketingModel GetRegionActivityConfigByActivityId(Guid activityId) { RegionMarketingModel result = null; FlashSaleModel flashSaleInfo = null; List <DataAccess.Entity.RegionMarketing.SimpleTireProductInfo> tireInfo = new List <DataAccess.Entity.RegionMarketing.SimpleTireProductInfo>(); try { if (activityId != Guid.Empty) { dbScopeReadManager.Execute(conn => { result = DALRegionMarketing.SelectRegionConfigByActivityId(conn, activityId); if (result != null) { result.ImgList = DALRegionMarketing.SelectActivityImgById(conn, result.ActivityId); result.ProductList = DALRegionMarketing.SelectRegionProductsByActivityId(conn, result.ActivityId); flashSaleInfo = SelectFlashSaleDataByActivityID(activityId); if (flashSaleInfo != null && flashSaleInfo.Products != null && flashSaleInfo.Products.Any()) { var products = flashSaleInfo.Products; var pidStr = string.Join(",", products.Select(x => x.PID)); tireInfo = DALRegionMarketing.SelectProductInfoByPID(conn, pidStr); } } }); if (result != null) { if (flashSaleInfo != null && flashSaleInfo.Products != null && flashSaleInfo.Products.Any()) { result.ProductList = (from fs in flashSaleInfo.Products join pl in result.ProductList on fs.PID equals pl.ProductId into temp from t in temp.DefaultIfEmpty() join tp in tireInfo on fs.PID equals tp.PID into infoData from o in infoData.DefaultIfEmpty() select new RegionMarketingProductConfig() { ActivityId = fs.ActivityID, ProductId = fs.PID, ProductName = fs.ProductName, Price = fs.Price, Size = o != null ? o.CP_Tire_Rim : string.Empty, Specification = o != null && !string.IsNullOrEmpty(o.CP_Tire_Width) ? (o.CP_Tire_Width + "/" + (!string.IsNullOrEmpty(o.CP_Tire_AspectRatio) ? o.CP_Tire_AspectRatio : string.Empty)) : string.Empty, MaxQuantity = fs.MaxQuantity, TotalQuantity = fs.TotalQuantity, AdvertiseTitle = t != null && !string.IsNullOrEmpty(t.AdvertiseTitle) ? t.AdvertiseTitle : fs.AdvertiseTitle, IsShow = t != null && !string.IsNullOrEmpty(t.AdvertiseTitle), SpecialCondition = t != null ? t.SpecialCondition : 0 }).ToList(); } } } } catch (Exception ex) { logger.Log(Level.Error, ex, "GetRegionMarketingConfig"); } return(result); }
public bool SaveRegionarketingConfig(RegionMarketingModel data, string user) { var result = false; var flag = false; string msg = string.Empty; var isAdd = false; var startTime = data.StartTime.GetValueOrDefault(); var endTime = data.EndTime.GetValueOrDefault(); try { if (data != null) { data.StartTime = data.EndTime = null; dbScopeManager.CreateTransaction(conn => { var info = DALRegionMarketing.SelectRegionMarketingConfig(conn, data.ActivityId, string.Empty, null, null, 1, 10); if (info == null || info.Count == 0) { isAdd = true; msg = "添加活动配置"; flag = DALRegionMarketing.InsertRegionMarketingConfig(conn, data) > 0; } else { msg = "修改活动配置"; flag = DALRegionMarketing.UpdateRegionMarketingConfig(conn, data) > 0; } if (flag) { foreach (var item in data.ImgList) { var imgInfo = DALRegionMarketing.SelectActivityImgByIdAndType(conn, item.ActivityId, item.Type); if (imgInfo != null) { result = DALRegionMarketing.UpdateActivityImgByIdAnType(conn, item.ActivityId, item.ImgUrl, item.Type, item.Position) > 0; } else { result = DALRegionMarketing.InsertActivityImg(conn, item.ActivityId, item.ImgUrl, item.Type, item.Position) > 0; } } foreach (var item in data.ProductList) { var proInfo = DALRegionMarketing.SelectRegionProductsByPID(conn, item.ActivityId, item.ProductId); if (proInfo != null) { result = DALRegionMarketing.UpdateRegionProductInfo(conn, item.ActivityId, item.ProductId, item.AdvertiseTitle, item.SpecialCondition) > 0; } else { result = DALRegionMarketing.InsertRegionProductInfo(conn, item.ActivityId, item.ProductId, item.AdvertiseTitle, item.SpecialCondition) > 0; } } } }); } } catch (Exception ex) { result = false; logger.Log(Level.Error, ex, "SaveRegionarketingConfig"); } if (result) { data.ProductList = new List <RegionMarketingProductConfig>(); data.ImgList = new List <DataAccess.Entity.RegionMarketing.ActivityImageConfig>(); InsertLog("RegionMarketingLog", data.ActivityId, JsonConvert.SerializeObject(data), msg, user, LogType); if (isAdd) { CallCRMService.NewAddActivity(data.ActivityName, startTime, endTime, "", data.ActivityRules, data.ActivityId.ToString(), CRMSourceType.TiresActivityOne, user); } else { CallCRMService.NewUpdateActivity(data.ActivityName, startTime, endTime, "", data.ActivityRules, data.ActivityId.ToString(), CRMSourceType.TiresActivityOne, user); } } return(result); }