public static bool Update(SE_MDBeautyBrandConfigModel model) { try { return(SE_MDBeautyBrandConfigDAL.Update(ProcessConnection.OpenTuhu_Groupon, model)); } catch (Exception ex) { throw ex; } }
public ActionResult BatchEdit(int parentId = 0) { SE_MDBeautyBrandConfigModel model = new SE_MDBeautyBrandConfigModel() { Id = 0, ParentId = parentId, CreateTime = DateTime.Now, IsDisable = false }; return(View(model)); }
public ActionResult BatchSave(SE_MDBeautyBrandConfigModel model) { bool result = false; if (model != null) { if (model.ParentId > 0) { result = SE_MDBeautyBrandConfigBLL.BatchInsert(model); } } return(RedirectToAction("Index")); }
public ActionResult Edit(int id = 0, int parentId = 0) { SE_MDBeautyBrandConfigModel model = new SE_MDBeautyBrandConfigModel() { ParentId = parentId }; if (id > 0) { model = SE_MDBeautyBrandConfigBLL.Select(id) ?? new SE_MDBeautyBrandConfigModel(); } ViewBag.ZTreeJsonEdit = SE_MDBeautyCategoryConfigController.SE_MDBeautyCategoryTreeJson(model.CategoryIds, true); return(View(model)); }
public static bool BatchInsert(SqlConnection connection, SE_MDBeautyBrandConfigModel model) { int executeNum = 0; var _brandNameList = model?.BrandName.Split(','); string sql = @" INSERT INTO [SE_MDBeautyBrandConfig] ([ParentId] ,[CategoryIds] ,[BrandName] ,[IsDisable] ,[CreateTime]) VALUES (@ParentId ,@CategoryIds ,@BrandName ,@IsDisable ,@CreateTime)"; using (IDbConnection conn = connection) { IDbTransaction transaction = conn.BeginTransaction(); try { for (int i = 0; i < _brandNameList.Length; i++) { model.BrandName = _brandNameList[i] ?? ""; if (!string.IsNullOrWhiteSpace(model.BrandName)) { executeNum += conn.Execute(sql, model, transaction); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } finally { if (executeNum != _brandNameList.Length) { transaction.Rollback(); } } } return(executeNum == _brandNameList.Length); }
public ActionResult Save(SE_MDBeautyBrandConfigModel model) { bool result = false; if (model != null) { if (model.Id > 0) { result = SE_MDBeautyBrandConfigBLL.Update(model); } else { result = SE_MDBeautyBrandConfigBLL.Insert(model); } } return(RedirectToAction("Index")); }
public static bool Update(SqlConnection connection, SE_MDBeautyBrandConfigModel model) { //修改状态时,若有子级则修改子级状态 using (IDbConnection conn = connection) { //string sql = @" UPDATE [SE_MDBeautyBrandConfig] // SET [ParentId] = @ParentId // ,[CategoryIds] = @CategoryIds // ,[BrandName] = @BrandName // ,[IsDisable] = @IsDisable // ,[CreateTime] = @CreateTime // WHERE Id = @Id "; //return conn.Execute(sql, model) > 0; string sql = @" BEGIN DECLARE @childCount INT with cte_child as ( select *,0 as lvl from SE_MDBeautyBrandConfig WITH(NOLOCK) where Id = @Id union all select b.*,lvl + 1 from cte_child AS c INNER join SE_MDBeautyBrandConfig AS b WITH(NOLOCK) on c.Id = b.ParentId ) SELECT * INTO #ChildTable from cte_child; SELECT @childCount = COUNT(1) from #ChildTable UPDATE [SE_MDBeautyBrandConfig] SET [ParentId] = @ParentId ,[CategoryIds] = @CategoryIds ,[BrandName] = @BrandName ,[IsDisable] = @IsDisable ,[CreateTime] = @CreateTime WHERE Id = @Id IF(@childCount > 1) BEGIN UPDATE [SE_MDBeautyBrandConfig] SET [IsDisable] = @IsDisable WHERE Id IN(select id from #ChildTable) END DROP TABLE #ChildTable END "; return(conn.Execute(sql, model) > 0); } }
public static bool Insert(SqlConnection connection, SE_MDBeautyBrandConfigModel model) { using (IDbConnection conn = connection) { string sql = @" INSERT INTO [SE_MDBeautyBrandConfig] ([ParentId] ,[CategoryIds] ,[BrandName] ,[IsDisable] ,[CreateTime]) VALUES (@ParentId ,@CategoryIds ,@BrandName ,@IsDisable ,@CreateTime)"; return(conn.Execute(sql, model) > 0); } }