Пример #1
0
 /// <summary>
 /// 新增基础代码信息
 /// </summary>
 /// <param name="codeBookInfo">基础代码信息</param>
 public void Add(CodeBookInfo codeBookInfo)
 {
     try
     {
         codeBook.Add(codeBookInfo);
     }
     catch (Exception ex)
     {
         BusinessExceptionHandler.HandlerException("新增基础代码信息失败!", ex);
     }
 }
Пример #2
0
        /// <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);
            }
        }
Пример #3
0
 /// <summary>
 /// 更新基础代码信息
 /// </summary>
 /// <param name="codeBookInfo">基础代码信息信息对象</param>
 public void Update(CodeBookInfo codeBookInfo)
 {
     try
     {
         codeBook.Update(codeBookInfo);
     }
     catch (Exception ex)
     {
         BusinessExceptionHandler.HandlerException("更新基础代码信息失败!", ex);
     }
 }
Пример #4
0
        /// <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;
        }
Пример #5
0
        /// <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);
            }
        }
Пример #6
0
        /// <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;
        }