public ViewResult Copy(int id)
{
SE_GiftManageConfigModel model = new SE_GiftManageConfigModel();
var U_ChannelPayList = SE_GiftManageConfigBLL.GetU_ChannelPayList();
if (id > 0)
{
model = SE_GiftManageConfigBLL.GetEntity(id);
if (!string.IsNullOrWhiteSpace(model.Channel))
{
U_ChannelPayList?.ToList().ForEach(_ =>
{
var channels = model.Channel.Split(',');
foreach (var item in channels)
{
if (_.ChannelKey.Contains(item))
{
_.IsChecked = true;
}
}
});
}
_CreateLogs = model;
}
ViewBag.U_ChannelPayList = U_ChannelPayList;
ViewBag.B_Categorys = SE_MDBeautyPartConfigController.InteriorCategorysTreeJson(model.B_Categorys);
return(View(model));
}
public static bool Update(SE_GiftManageConfigModel model)
{
try
{
var giftFlag = true;
var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(model.Id);
giftFlag = giftFlag && reGiftP >= 0;
var giftProductModels = JsonConvert.DeserializeObject <List <GiftStockModel2> >(model.GiftProducts);
foreach (var g in giftProductModels)
{
g.RuleId = model.Id;
giftFlag = giftFlag && SE_GiftManageConfigDAL.MergeIntoGiftProductStock(g.Pid, g.Stock, model.Id) > 0;
giftFlag = giftFlag && SE_GiftManageConfigDAL.InsertGiftProductConfig(g) > 0;
}
var result = SE_GiftManageConfigDAL.Update(ProcessConnection.OpenConfiguration, model) && giftFlag;
// 按PID配置赠品后刷新牛皮癣缓存
RefreshGiftPicture(model);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Save(SE_GiftManageConfigModel model)
{
model.ActivityType = 2;
var dataSource = model;
if (model.Id <= 0)
{
dataSource.Creater = User.Identity.Name;
dataSource.CreateTime = DateTime.Now;
DiscountManageConfigManage.Insert(dataSource, new SE_DictionaryConfigModel
{
ParentId = dataSource.Id,
Key = "SE_GiftManageConfig",
Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "",
Extend2 = dataSource != null ? JsonConvert.SerializeObject(dataSource) : "",
Extend3 = dataSource.Mender,
Extend4 = "新增",
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now
});
//Logs(dataSource, "新增");
}
else
{
dataSource.Mender = User.Identity.Name;
dataSource.UpdateTime = DateTime.Now;
if (DiscountManageConfigManage.Update(dataSource))
{
Logs(dataSource, "更新");
}
}
return(RedirectToAction("Index"));
}
public static bool Insert(SE_GiftManageConfigModel model, SE_DictionaryConfigModel log)
{
try
{
var result = SE_GiftManageConfigDAL.Insert(ProcessConnection.OpenConfiguration, model);
var giftFlag = true;
log.ParentId = result;
//var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(result);
var giftProductModels = JsonConvert.DeserializeObject <List <GiftStockModel2> >(model.GiftProducts);
foreach (var g in giftProductModels)
{
g.RuleId = result;
g.IsGiveAway = model.GiveAway;
giftFlag = giftFlag && SE_GiftManageConfigDAL.MergeIntoGiftProductStock(g.Pid, g.Stock, result) > 0;
giftFlag = giftFlag && SE_GiftManageConfigDAL.InsertGiftProductConfig(g) > 0;
}
// 按PID配置赠品后刷新牛皮癣缓存
RefreshGiftPicture(model);
return(result > 0 && SE_GiftManageConfigDAL.InsertLog(ProcessConnection.OpenConfiguration, log) && giftFlag);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(SE_GiftManageConfigModel model)
{
try
{
return(DiscountManageConfigDal.Update(ProcessConnection.OpenConfiguration, model));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Insert(SE_GiftManageConfigModel model, SE_DictionaryConfigModel log)
{
try
{
var result = DiscountManageConfigDal.Insert(ProcessConnection.OpenConfiguration, model);
log.ParentId = result;
//var reGiftP = SE_GiftManageConfigDAL.DeleteGiftProductConfig(result);
return(SE_GiftManageConfigDAL.InsertLog(ProcessConnection.OpenConfiguration, log));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Save(SE_GiftManageConfigModel model)
{
model.ActivityType = 2;
var dataSource = model;
if (model.Id <= 0)
{
dataSource.Creater = User.Identity.Name;
dataSource.CreateTime = DateTime.Now;
DiscountManageConfigManage.Insert(dataSource, new SE_DictionaryConfigModel
{
ParentId = dataSource.Id,
Key = "SE_GiftManageConfig",
Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "",
Extend2 = dataSource != null ? JsonConvert.SerializeObject(dataSource) : "",
Extend3 = dataSource.Mender,
Extend4 = "新增",
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now
});
//Logs(dataSource, "新增");
}
else
{
dataSource.Mender = User.Identity.Name;
dataSource.UpdateTime = DateTime.Now;
if (DiscountManageConfigManage.Update(dataSource))
{
Logs(dataSource, "更新");
}
}
RefreshCache();
if (dataSource.P_PID != null)
{
var pidModel = JsonConvert.DeserializeObject <List <PidModel> >(dataSource.P_PID);
var pids = pidModel.Select(r => r.Pid).ToList();
if (pids.Any())
{
Thread.Sleep(50);
TuhuNotification.SendNotification("notification.productModify.ProductCommonTag", new
{
type = "RebuildCache",
pids,
tag = ProductCommonTag.Discount
});
}
}
return(RedirectToAction("Index"));
}
public static bool Update(SqlConnection connection, SE_GiftManageConfigModel model)
{
using (IDbConnection conn = connection)
{
string sql = @" UPDATE Configuration.dbo.SE_GiftManageConfig
SET Name = @Name,
State = @State,
Limit = @Limit,
DonateWay = @DonateWay,
Describe = @Describe,
Visible = @Visible,
OrdersWay = @OrdersWay,
ValidTimeBegin = @ValidTimeBegin,
ValidTimeEnd = @ValidTimeEnd,
Channel = @Channel,
Type = @Type,
ConditionSize = @ConditionSize,
TireType = @TireType,
Size = @Size,
B_Categorys = @B_Categorys,
B_Brands = @B_Brands,
B_PID = @B_PID,
B_PID_Type = @B_PID_Type,
P_PID = @P_PID,
GiftCondition = @GiftCondition,
GiftNum = @GiftNum,
GiftMoney = @GiftMoney,
GiftUnit = @GiftUnit,
GiftType = @GiftType,
GiftProducts = @GiftProducts,
GiftDescribe = @GiftDescribe,
Creater = @Creater,
Mender = @Mender,
CreateTime = @CreateTime,
UpdateTime = @UpdateTime,
TireSizeCondition= @TireSizeCondition,
TireSize= @TireSize,
Category=@Category,
IsPackage=@IsPackage,
ActivityType=@ActivityType,
TagDisplay=@TagDisplay
WHERE Id = @Id " ;
return(conn.Execute(sql, model) > 0);
}
}
private void Logs(SE_GiftManageConfigModel source, string type)
{
if (source != null)
{
var result = SE_DictionaryConfigBLL.Insert(new SE_DictionaryConfigModel
{
ParentId = source.Id,
Key = "SE_GiftManageConfig",
Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "",
Extend2 = source != null ? JsonConvert.SerializeObject(source) : "",
Extend3 = source.Mender,
Extend4 = type,
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now
});
//_CreateLogs = null;
}
}
public static bool Update(SqlConnection connection, SE_GiftManageConfigModel model)
{
using (IDbConnection conn = connection)
{
string sql = @" UPDATE Configuration.dbo.SE_GiftManageConfig
SET Name = @Name,
ValidTimeBegin = @ValidTimeBegin,
ValidTimeEnd = @ValidTimeEnd,
Channel = @Channel,
GiftProducts = @GiftProducts,
Creater = @Creater,
Mender = @Mender,
CreateTime = @CreateTime,
UpdateTime = @UpdateTime,
TagDisplay=@TagDisplay
WHERE Id = @Id " ;
return(conn.Execute(sql, model) > 0);
}
}
/// <summary>
/// 刷新赠品牛皮癣
/// </summary>
/// <param name="model"></param>
private static void RefreshGiftPicture(SE_GiftManageConfigModel model)
{
var pids = model.P_PID != null?JsonConvert.DeserializeObject <List <PidModel> >(
model.P_PID).Select(p => p.Pid).ToList() : new List <string>();
if (!pids.Any())
{
return;
}
var productCacheService = new ProductCacheService();
Task.Delay(3000).ContinueWith((task) =>
{
if (task.IsCompleted)
{
productCacheService.RefreshGiftCache();
productCacheService.SetProductCommonTagDetailsCache(ProductCommonTag.GiftProduct, pids);
}
});
}
public ActionResult Save(SE_GiftManageConfigModel model)
{
model.ActivityType = 1;
model.PictureUrl = model.PictureUrl?.Trim();
model.PictureUrl4Detail = model.PictureUrl4Detail?.Trim();
var dataSource = model;
if (model.Type == 4)
{
var flag = false;
var pPids = JsonConvert.DeserializeObject <List <PidModel> >(model.P_PID);
var result = SE_GiftManageConfigBLL.GetProductsModel(pPids.Select(r => r.Pid).ToList());
foreach (var value in result.Values)
{
if (value.Contains("BaoYang"))
{
flag = true;
break;
}
}
if (flag)
{
model.Category = "BaoYang";
}
}
if (model.Type == 3)
{
var pNodes = new List <string>();
var list = SE_GiftManageConfigBLL.GetByAllNodes();
foreach (var item in list)
{
pNodes.AddRange(item.Split('.').ToList());
}
var distinctNodes = pNodes.Distinct().ToList();
var categorys = model.B_Categorys?.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries) ??
new string[0];
var bBrands = model.B_Brands == null
? new List <BrandModel>()
: JsonConvert.DeserializeObject <List <BrandModel> >(model.B_Brands);
var isBrand = false;
//var isCategory = categorys.Contains("28656");
var isCategory = distinctNodes.Any() && distinctNodes.Any(category => categorys.Contains(category));
foreach (var brand in bBrands)
{
isBrand = distinctNodes.Any() && distinctNodes.Contains(brand.Category);
if (isBrand)
{
break;
}
}
var isbPid = false;
if (model.B_PID_Type)
{
var pPids = model.B_PID == null
? new List <PidModel>()
: JsonConvert.DeserializeObject <List <PidModel> >(model.B_PID);
var result = SE_GiftManageConfigBLL.GetProductsModel(pPids.Select(r => r.Pid).ToList());
foreach (var value in result.Values)
{
if (value.Contains("BaoYang"))
{
isbPid = true;
break;
}
}
}
if (isBrand || isCategory || isbPid)
{
model.Category = "BaoYang";
}
}
//var giftProductModels = JsonConvert.DeserializeObject<List<GiftProductModel>>(dataSource.GiftProducts);
//giftProductModels.ForEach(g =>
//{
// //if (g.Stock.HasValue)
// //{
// var stock = SE_GiftManageConfigBLL.GetGiftProductStock(g.Pid);
// if (!stock.HasValue)
// {
// if (g.Stock.HasValue)
// SE_GiftManageConfigBLL.InsertGiftProductStock(g.Pid, g.Stock.Value);
// }
// else
// {
// if (g.Stock.HasValue)
// SE_GiftManageConfigBLL.UpdateGiftProductStock(g.Pid, g.Stock.Value);
// else
// SE_GiftManageConfigBLL.DeleteGiftProductStock(g.Pid);
// }
// // }
//});
if (model.Id <= 0)
{
dataSource.Creater = User.Identity.Name;
dataSource.CreateTime = DateTime.Now;
SE_GiftManageConfigBLL.Insert(dataSource, new SE_DictionaryConfigModel
{
ParentId = dataSource.Id,
Key = "SE_GiftManageConfig",
Extend1 = _CreateLogs != null ? JsonConvert.SerializeObject(_CreateLogs) : "",
Extend2 = dataSource != null ? JsonConvert.SerializeObject(dataSource) : "",
Extend3 = dataSource.Mender,
Extend4 = "新增",
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now
});
//Logs(dataSource, "新增");
}
else
{
dataSource.Mender = User.Identity.Name;
dataSource.UpdateTime = DateTime.Now;
if (SE_GiftManageConfigBLL.Update(dataSource))
{
Logs(dataSource, "更新");
}
}
return(RedirectToAction("Index"));
}
public ActionResult CopySave(SE_GiftManageConfigModel model)
{
model.Id = 0;
return(Save(model));
}
public static int Insert(SqlConnection connection, SE_GiftManageConfigModel model)
{
using (IDbConnection conn = connection)
{
string sql = @"
INSERT INTO Configuration.dbo.SE_GiftManageConfig
(
Name,
State,
Limit,
DonateWay,
Describe,
Visible,
OrdersWay,
ValidTimeBegin,
ValidTimeEnd,
Channel,
Type,
ConditionSize,
TireType,
Size,
B_Categorys,
B_Brands,
B_PID,
B_PID_Type,
P_PID,
GiftCondition,
GiftNum,
GiftMoney,
GiftUnit,
GiftType,
GiftProducts,
GiftDescribe,
Creater,
Mender,
CreateTime,
UpdateTime,
TireSizeCondition,
TireSize,
CateGory,
IsPackage,
ActivityType,
TagDisplay,
GiveAway,
PictureUrl,
PictureUrl4Detail
)
VALUES
(
@Name,
@State,
@Limit,
@DonateWay,
@Describe,
@Visible,
@OrdersWay,
@ValidTimeBegin,
@ValidTimeEnd,
@Channel,
@Type,
@ConditionSize,
@TireType,
@Size,
@B_Categorys,
@B_Brands,
@B_PID,
@B_PID_Type,
@P_PID,
@GiftCondition,
@GiftNum,
@GiftMoney,
@GiftUnit,
@GiftType,
@GiftProducts,
@GiftDescribe,
@Creater,
@Mender,
@CreateTime,
@UpdateTime,
@TireSizeCondition,
@TireSize,
@Category,
@IsPackage,
@ActivityType,
@TagDisplay,
@GiveAway,
@PictureUrl,
@PictureUrl4Detail
)SELECT @@IDENTITY" ;
return(conn.ExecuteScalar <int>(sql, model));
}
}
