/// <summary> /// 新增对象 /// </summary> /// <param name="entity">实体</param> /// <returns>true=成功;false=失败</returns> public bool Insert(PatrolServerList entity) { SQLEntities context = new SQLEntities(); bool success = false; using (TransactionScope trans = new TransactionScope()) { try { context.PatrolServerList.AddObject(entity); trans.Complete(); success = true; } catch (Exception ex) { Console.WriteLine(ex.Message); } } try { if (success) { //提交保存 context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } context.Dispose(); return(success); }
/// <summary> /// 记录需要更新的字段 /// </summary> /// <param name="update"></param> private static void SetUpdateValue(PatrolServerList current, Hashtable updateKeys) { foreach (DictionaryEntry item in updateKeys) { switch (item.Key.ToString().ToLower()) { case "address": current.Address = item.Value.ToString(); break; case "name": current.Name = item.Value.ToString(); break; case "ismainserver": current.IsMainServer = item.Value.ToString(); break; case "sortcd": current.SortCD = Convert.ToInt32(item.Value); break; default: break; } } }
/// <summary> /// 根据用户名称查询唯一用户 /// </summary> /// <param name="searchInfo">带有UserCD值的查询对象</param> /// <returns>指定UserCD值的个人信息</returns> public static PatrolServerList Select(PatrolServerList searchInfo) { if (searchInfo == null || searchInfo.Address == String.Empty) { return(null); } return(controller.Select(searchInfo)); }
/// <summary> /// 删除记录 /// </summary> /// <param name="entity">删除对象 主键必须设置</param> /// <returns></returns> public static bool Delete(PatrolServerList entity) { if (entity != null) { return(controller.Delete(entity)); } return(false); }
/// <summary> /// 更新记录 /// </summary> /// <param name="entity">要更新对象</param> /// <param name="updateKeys">更新列表</param> /// <returns>true=成功,false=失败</returns> public static bool Update(PatrolServerList entity, Hashtable updateKeys) { if (entity != null && updateKeys != null && updateKeys.Count > 0) { return(controller.Update(entity, updateKeys)); } return(false); }
/// <summary> /// 新增记录 /// </summary> /// <param name="entity">新增对象</param> /// <returns>true=成功,false=失败</returns> public static bool Insert(PatrolServerList entity) { if (entity != null) { return(controller.Insert(entity)); } return(false); }
/// <summary> /// 复制对象 /// </summary> /// <param name="source">源对象</param> /// <returns></returns> public PatrolServerList Copy(PatrolServerList source) { PatrolServerList target = new PatrolServerList(); target.Address = source.Address; target.Name = source.Name; target.IsMainServer = source.IsMainServer; target.SortCD = source.SortCD; return(target); }
/// <summary> /// 根据查询条件查询单条记录 /// </summary> /// <param name="searchInfo">查询条件,主键查询</param> /// <returns></returns> public PatrolServerList Select(PatrolServerList searchInfo) { PatrolServerList instance = null; try { SQLEntities context = new SQLEntities(); instance = context.PatrolServerList.Where("it.Address=@Address", new ObjectParameter("Address", searchInfo.Address)).First(); context.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(instance); }
/// <summary> /// 根据主键删除实例 /// </summary> /// <param name="oldEntity">设置了主键Id的对象</param> /// <returns></returns> public bool Delete(PatrolServerList entity) { SQLEntities context = new SQLEntities(); bool success = false; using (TransactionScope trans = new TransactionScope()) { try { PatrolServerList instance = context.PatrolServerList.Where("it.Address=@Address", new ObjectParameter("Address", entity.Address)).First(); //标记删除 context.PatrolServerList.DeleteObject(instance); trans.Complete(); success = true; } catch (Exception ex) { Console.WriteLine(ex.Message); } } try { if (success) { //提交保存 context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } context.Dispose(); return(success); }