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