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); } }