/// <summary> /// 新增基础代码信息 /// </summary> /// <param name="codeBookInfo">基础代码信息</param> public void Add(CodeBookInfo codeBookInfo) { try { codeBook.Add(codeBookInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("新增基础代码信息失败!", ex); } }
/// <summary> /// 新增基础代码信息 /// </summary> /// <param name="codeBookInfo">基础代码信息对象</param> public void Add(CodeBookInfo codeBookInfo) { string commandText = "INSERT INTO CodeBook(Id,Type,Code,Name,Remark,SortOrder,Valid)" + " VALUES(@Id,@Type,@Code,@Name,@Remark,@SortOrder,@Valid)"; try { base.Execute(commandText, connectionString: CarManageConfig.Instance.ConnectionString, param: codeBookInfo); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException("新增基础代码信息失败!", ex); } }
/// <summary> /// 更新基础代码信息 /// </summary> /// <param name="codeBookInfo">基础代码信息信息对象</param> public void Update(CodeBookInfo codeBookInfo) { try { codeBook.Update(codeBookInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("更新基础代码信息失败!", ex); } }
/// <summary> /// 查询基础代码信息 /// </summary> /// <returns>基础代码信息集合</returns> public List<CodeBookInfo> Search(CodeBookInfo queryInfo) { List<CodeBookInfo> codeBookList = new List<CodeBookInfo>(); try { codeBookList = codeBook.Search(queryInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("查询基础代码信息失败!", ex); } return codeBookList; }
/// <summary> /// 更新基础代码信息 /// </summary> /// <param name="codeBookInfo">基础代码信息对象</param> public void Update(CodeBookInfo codeBookInfo) { string commandText = "UPDATE CodeBook SET " + "Type=@Type,Code=@Code,Name=@Name,Remark=@Remark,SortOrder=@SortOrder,Valid=@Valid " + "WHERE Id=@Id"; try { base.Execute(commandText, connectionString: CarManageConfig.Instance.ConnectionString, param: codeBookInfo); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException("更新基础代码信息失败!", ex); } }
/// <summary> /// 获得所有基础代码信息集合 /// </summary> /// <returns>基础代码信息集合</returns> public List<CodeBookInfo> Search(CodeBookInfo queryInfo) { IDbConnection connection = null; List<CodeBookInfo> codeList = new List<CodeBookInfo>(); try { string field = "*"; string table = "CodeBook"; string order = "ORDER BY Id"; StringBuilder filter = new StringBuilder(); #region 查询条件 #endregion string filterText = string.Empty; if (filter.Length > 0) { filterText = filter.ToString().TrimStart(' ').Remove(0, 3).Insert(0, " WHERE "); } string commandText = string.Format("SELECT COUNT(*) FROM CodeBook {0}", filterText); connection = base.CreateConnection(CarManageConfig.Instance.ConnectionString); queryInfo.TotalCount = base.ExecuteObject<int>(commandText: commandText, connection: connection, param: queryInfo); if (queryInfo.TotalCount.Equals(0)) return codeList; int pageCount = queryInfo.TotalCount / queryInfo.PageSize + 1; if (queryInfo.TotalCount % queryInfo.PageSize != 0) pageCount++; int startIndex = queryInfo.PageIndex * queryInfo.PageSize; commandText = string.Format("SELECT {0} FROM {1} WHERE {2} ORDER BY {3} LIMIT {4},{5}", field, table, filterText, order, startIndex, queryInfo.PageSize); codeList = base.Query<CodeBookInfo>(commandText, connection, param: queryInfo).ToList(); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException( "查询基础代码信息失败!", ex); } finally { CloseConnection(connection); } return codeList; }