/// <summary>
/// add building info
/// </summary>
/// <param name="userKey"></param>
/// <param name="paramDicts"></param>
/// <returns></returns>
public ArrayList AddBuilding(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
try
{
Models.Data.base_community_buildinginfo model = paramDicts[0]["building"].ToString().JsonToModel <Models.Data.base_community_buildinginfo>();
model.building_id = Guid.NewGuid();
model.status = 1;
using (var context = new Data.CbooEntities())
{
context.base_community_buildinginfo.AddObject(model);
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 UpdateCommunity(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
try
{
Models.Data.base_community_baseinfo community = paramDicts[0]["community"].ToString().JsonToModel <Models.Data.base_community_baseinfo>();
using (var context = new Data.CbooEntities())
{
context.base_community_baseinfo.Attach(community);
context.ObjectStateManager.ChangeObjectState(community, System.Data.EntityState.Modified);
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);
}
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);
}
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 GetChildren(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
try
{
var item_id = new Guid(paramDicts[0]["item_id"].ToString());
using (var context = new Data.CbooEntities())
{
var models = from model in context.base_datadic_tree
where model.parent_id == item_id
orderby model.item_key
select model;
data = models.ToList();
}
}
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 GetRoot(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
try
{
using (var context = new Data.CbooEntities())
{
var models = from model in context.base_datadic_tree
where model.item_id == new Guid("0cf3f9d0-67ac-492f-91f7-d0b6f31e8165")
select model;
data = models.First();
}
}
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 static int AddModel <TEntity>(TEntity model) where TEntity : class
{
using (var context = new Data.CbooEntities())
{
context.CreateObjectSet <TEntity>().AddObject(model);
return(context.SaveChanges());
}
}
public static int UpdateModel <TEntity>(TEntity model) where TEntity : class
{
using (var context = new Data.CbooEntities())
{
context.CreateObjectSet <TEntity>().Attach(model);
context.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
return(context.SaveChanges());
}
}
/// <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());
}
}
public base_datadic_tree GetRoot()
{
using (var context = new Data.CbooEntities())
{
var models = from model in context.base_datadic_tree
where model.item_id == new Guid("0cf3f9d0-67ac-492f-91f7-d0b6f31e8165")
select model;
return(models.First());
}
}
public List <base_datadic_tree> GetList(Guid id)
{
using (var context = new Data.CbooEntities())
{
var models = from model in context.base_datadic_tree
where model.item_id == id
select model;
return(models.ToList());
}
}
public List <base_datadic_tree> GetChildren(Guid parent_id)
{
using (var context = new Data.CbooEntities())
{
var models = from model in context.base_datadic_tree
where model.parent_id == parent_id
orderby model.item_key
select model;
return(models.ToList());
}
}
private static string GetKey(string tableName)
{
if (!EntityKey.ContainsKey(tableName))
{
using (var context = new Data.CbooEntities())
{
var table = context.ExecuteStoreQuery <table_info>("desc " + tableName);
EntityKey[tableName] = table.Where(t => t.key == "PRI").First().field;
}
}
return(EntityKey[tableName]);
}
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);
}
/// <summary>
/// get building info as List<base_community_buildinginfo>
/// </summary>
/// <param name="userKey"></param>
/// <param name="paramDicts"></param>
/// <returns></returns>
public ArrayList GetBuildingList(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
Models.Pager <base_community_buildinginfo> pager = null;
if (paramDicts[0].ContainsKey("Pager`1"))
{
pager = paramDicts[0].As <Models.Pager <base_community_buildinginfo> >();
}
try
{
var community_id = new Guid(paramDicts[0]["community_id"].ToString());
using (var context = new Data.CbooEntities())
{
var models = from building in context.base_community_buildinginfo
where building.community_id == community_id && building.status != -1
orderby building.building_name
select building;
if (pager == null)
{
data = models.ToList();
}
else
{
data = models.Page(pager);
}
}
}
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 static object GetModelList <TEntity, TKey>(Func <TEntity, bool> where, Func <TEntity, TKey> orderby, Models.Pager <TEntity> pager) where TEntity : class
{
using (var context = new Data.CbooEntities())
{
IEnumerable <TEntity> models = (from model in context.CreateObjectSet <TEntity>()
select model);
if (where != null)
{
models = models.Where(where);
}
if (orderby != null)
{
models = models.OrderBy(orderby);
}
if (pager != null)
{
return(models.Page(pager));
}
return(models.ToList());
}
}
public ArrayList GetCommunityList(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
try
{
using (var context = new Data.CbooEntities())
{
var communities = from community in context.base_community_baseinfo
//where community.city_name == "北京"
select community;
data = communities.ToList <Models.Data.base_community_baseinfo>();
}
}
catch (Exception ex)
{
erro = ex;
message = ex.Message;
}
ArrayList revList = new ArrayList();
{
//check user
}
revList.Add(new Models.ServerResult()
{
succeed = erro == null, data = data, message = message
});
return(revList);
}
public ArrayList Register(string userKey, Dictionary <string, object>[] paramDicts)
{
//Models.User model = paramDicts[0]["user"].ToString().JsonToModel<Models.User>();
{
Models.Data.sys_user_baseinfo user = new Models.Data.sys_user_baseinfo();
user.user_id = Guid.NewGuid();
user.city_name = "北京";
using (var context = new Data.CbooEntities())
{
context.sys_user_baseinfo.AddObject(user);
context.SaveChanges();
}
}
ArrayList revList = new ArrayList();
{
//check user
}
revList.Add(new Models.ServerResult()
{
succeed = true, data = null, message = "message f!!!!!!"
});
return(revList);
}
