/// <summary> /// 新增对象 /// </summary> /// <param name="entity">实体</param> /// <returns>true=成功;false=失败</returns> public bool Insert(PatrolSpotParts entity) { SQLEntities context = new SQLEntities(); bool success = false; using (TransactionScope trans = new TransactionScope()) { try { context.PatrolSpotParts.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(PatrolSpotParts current, Hashtable updateKeys) { foreach (DictionaryEntry item in updateKeys) { switch (item.Key.ToString().ToLower()) { case "id": current.ID = item.Value.ToString(); break; case "name": current.Name = item.Value.ToString(); break; case "parentid": current.ParentID = item.Value.ToString(); break; case "sortcd": current.SortCD = Convert.ToInt32(item.Value); break; default: break; } } }
/// <summary> /// 根据用户名称查询唯一用户 /// </summary> /// <param name="searchInfo">带有ID的查询对象</param> /// <returns>指定UserCD值的个人信息</returns> public static PatrolSpotParts Select(PatrolSpotParts searchInfo) { if (searchInfo == null || searchInfo.ID == String.Empty) { return(null); } return(controller.Select(searchInfo)); }
/// <summary> /// 删除记录 /// </summary> /// <param name="entity">删除对象 主键必须设置</param> /// <returns></returns> public static bool Delete(PatrolSpotParts 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(PatrolSpotParts 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(PatrolSpotParts entity) { if (entity != null) { return(controller.Insert(entity)); } return(false); }
/// <summary> /// 复制对象 /// </summary> /// <param name="source">源对象</param> /// <returns></returns> public PatrolSpotParts Copy(PatrolSpotParts source) { PatrolSpotParts target = new PatrolSpotParts(); target.ID = source.ID; target.Name = source.Name; target.ParentID = source.ParentID; target.SortCD = source.SortCD; return(target); }
/// <summary> /// 根据查询条件查询单条记录 /// </summary> /// <param name="searchInfo">查询条件,主键查询</param> /// <returns></returns> public PatrolSpotParts Select(PatrolSpotParts searchInfo) { PatrolSpotParts instance = null; try { SQLEntities context = new SQLEntities(); instance = context.PatrolSpotParts.Where("it.ID=@ID", new ObjectParameter("ID", searchInfo.ID)).First(); context.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(instance); }
/// <summary> /// 根据主键删除实例 /// </summary> /// <param name="oldEntity">设置了主键Id的对象</param> /// <returns></returns> public bool Delete(PatrolSpotParts entity) { SQLEntities context = new SQLEntities(); bool success = false; using (TransactionScope trans = new TransactionScope()) { try { PatrolSpotParts instance = context.PatrolSpotParts.Where("it.ID=@ID", new ObjectParameter("ID", entity.ID)).First(); //标记删除 context.PatrolSpotParts.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); }