public ArrayList UpdateDict(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.base_datadic_tree.Attach(model);
context.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
data = 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);
}
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 AddDict(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>();
model.item_id = Guid.NewGuid();
model.leaf = true;
using (var context = new Data.CbooEntities())
{
string max = (from dict in context.base_datadic_tree
where dict.parent_id == model.parent_id
select dict.item_key).Max();
if (max == null)
{
model.item_key = (from dict in context.base_datadic_tree
where dict.item_id == model.parent_id
select dict.item_key).First() + "01";
}
else
{
model.item_key = (long.Parse(max, System.Globalization.NumberStyles.HexNumber) + 1).ToString("X");
}
context.base_datadic_tree.AddObject(model);
(from parent in context.base_datadic_tree
where parent.item_id == model.parent_id
select parent).First().leaf = false;
data = 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);
}
