public ArrayList DeleteDict(string userKey, Dictionary <string, object>[] paramDicts) { Exception erro = null; object data = null; string message = null; try { Models.Data.base_datadic_tree model = paramDicts[0]["dict"].ToString().JsonToModel <Models.Data.base_datadic_tree>(); using (var context = new Data.CbooEntities()) { context.ExecuteStoreCommand(string.Format(_deleteDict, model.item_key)); int count = (from dict in context.base_datadic_tree where dict.parent_id == model.parent_id select dict).Count(); if (count == 0) { context.ExecuteStoreCommand(string.Format(_setLeaf, model.parent_id)); } } } catch (Exception ex) { erro = ex; message = ex.Message; } ArrayList revList = new ArrayList(); revList.Add(new Models.ServerResult() { succeed = erro == null, data = data, message = message }); return(revList); }
public ArrayList DeleteCommunityList(string userKey, Dictionary <string, object>[] paramDicts) { Exception erro = null; object data = null; string message = null; try { List <string> communityList = paramDicts[0]["communityList"].ToString().JsonToModel <List <string> >(); using (var context = new Data.CbooEntities()) { context.ExecuteStoreCommand(string.Format(_deleteCommunityList, communityList.GetSelectIn())); int a = context.SaveChanges(); } } catch (Exception ex) { erro = ex; message = ex.Message; } ArrayList revList = new ArrayList(); revList.Add(new Models.ServerResult() { succeed = erro == null, data = data, message = message }); return(revList); }
/// <summary> /// update TEntity set dr=1 where Primarykey = id /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="id">Primary key</param> /// <returns></returns> public static int DeleteModel <TEntity>(string id) where TEntity : class { string tableName = typeof(TEntity).Name; using (var context = new Data.CbooEntities()) { context.ExecuteStoreCommand(string.Format(_deleteModel, tableName, GetKey(tableName), id)); return(context.SaveChanges()); } }