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