public ActionResult Save(SE_MDBeautyPartConfigModel model)
{
if (model != null)
{
var cates = model.ExternalCategorys?.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var pids = cates.Where(w => w.Contains('-'));
if (pids != null && pids.Any())
{
var categoryIds = cates?.Where(w => !w.Contains('-'));
var cate_pids = Business.SE_MDBeautyCategoryConfigBLL.GetPidsFromMDBeautyCategoryProductConfigByCategoryIds(categoryIds);
if (cate_pids != null && cate_pids.Any())
{
var excludePids = cate_pids.Where(w => !pids.Contains(w));
if (excludePids != null && excludePids.Any())
{
model.ExcludePids = string.Join(",", excludePids);
}
}
model.ExternalCategorys = string.Join(",", categoryIds);
}
if (model.Id > 0)
{
SE_MDBeautyPartConfigBLL.Update(model);
}
else
{
SE_MDBeautyPartConfigBLL.Insert(model);
}
RefreshBeautyConfigCache("ios");
}
return(RedirectToAction("Index"));
}
public static bool Insert(SqlConnection connection, SE_MDBeautyPartConfigModel model)
{
using (IDbConnection conn = connection)
{
string sql = @"
INSERT INTO SE_MDBeautyPartConfig
(
Name,
InteriorCategorys,
ExternalCategorys,
H5URL,
Soft,
IsShow,
ExcludePids
)
VALUES
(
@Name,
@InteriorCategorys,
@ExternalCategorys,
@H5URL,
@Soft,
@IsShow,
@ExcludePids
)" ;
return(conn.Execute(sql, model) > 0);
}
}
public static bool Update(SE_MDBeautyPartConfigModel model)
{
try
{
return(SE_MDBeautyPartConfigDAL.Update(ProcessConnection.OpenTuhu_Groupon, model));
}
catch (Exception ex)
{
throw ex;
}
}
//
// GET: /SE_MDBeautyPartConfig/Edit/5
public ActionResult Edit(int id = 0)
{
SE_MDBeautyPartConfigModel model = new SE_MDBeautyPartConfigModel();
model.Soft = 1;
if (id > 0)
{
model = SE_MDBeautyPartConfigBLL.Select(id);
}
ViewBag.InteriorCategorys = InteriorCategorysTreeJson(model.InteriorCategorys);
ViewBag.ExternalCategorys = SE_MDBeautyCategoryConfigController.SE_MDBeautyCategoryTreeJsonForPart(model.ExternalCategorys, model.ExcludePids, true);
return(View(model));
}
public static bool Update(SqlConnection connection, SE_MDBeautyPartConfigModel model)
{
using (IDbConnection conn = connection)
{
string sql = @" UPDATE SE_MDBeautyPartConfig
SET Name = @Name,
InteriorCategorys = @InteriorCategorys,
ExternalCategorys = @ExternalCategorys,
H5URL = @H5URL,
Soft = @Soft,
IsShow = @IsShow,
ExcludePids=@ExcludePids
WHERE Id = @Id " ;
return(conn.Execute(sql, model) > 0);
}
}
