employeedaoservice.cs

利用iBatis架构开发Web应用程序的初学实例。

using System;
using System.Text;
using System.Collections;

namespace DaoProvider
{
    public class EmployeeDaoService : AbstractDaoService
    {
        public Employee QueryWithParameterClassForObject(Employee p_dataObject)
        {
            return (Employee)GetMapper().QueryForObject("Employees_SelectWithParameterClass", p_dataObject);
        }
        public IList QueryWithParameterClass(Employee p_dataObject)
        {
            return GetMapper().QueryForList("Employees_SelectWithParameterClass", p_dataObject);
        }
        public IList QueryWithParameterMap1(Employee p_dataObject)
        {
            return GetMapper().QueryForList("Employees_SelectWithParameterMap1", p_dataObject);
        }
        /// <summary>
        /// 在Select使用?访问ParameterMap
        /// </summary>
        /// <param name="p_dataObject">The p_data object.</param>
        /// <returns></returns>
        public IList QueryWithParameterMap2(Employee p_dataObject)
        {
            return GetMapper().QueryForList("Employees_SelectWithParameterMap2", p_dataObject);
        }

        public int InsertWithParameterClass(Employee p_dataObject)
        {
            GetMapper().Insert("Employee_InsertWithParameterClass", p_dataObject);
            return p_dataObject.EmployeeID;
        }
        public int InsertWithParameterMap1(Employee p_dataObject)
        {
            GetMapper().Insert("Employee_InsertWithParameterMap1", p_dataObject);
            return p_dataObject.EmployeeID;
        }
        /// <summary>
        /// 使用?的形式使用ParameterMap
        /// </summary>
        /// <param name="p_dataObject">The p_data object.</param>
        /// <returns></returns>
        public int InsertWithParameterMap2(Employee p_dataObject)
        {
            GetMapper().Insert("Employee_InsertWithParameterMap2", p_dataObject);
            return p_dataObject.EmployeeID;
        }
        /// <summary>
        /// 与InsertWithParameterMap2的不同的是将ParameterMap的映射成员顺序调换一下。
        /// </summary>
        /// <param name="p_dataObject">The p_data object.</param>
        /// <returns></returns>
        public int InsertWithParameterMap3(Employee p_dataObject)
        {
            GetMapper().Insert("Employee_InsertWithParameterMap3", p_dataObject);
            return p_dataObject.EmployeeID;
        }
        /// <summary>
        /// 使用存储过程，将LastName和FirstName调换
        /// </summary>
        /// <param name="p_dataObject">The p_data object.</param>
        /// <returns></returns>
        public int InsertWithProcdure(Employee p_dataObject)
        {
            return (int)GetMapper().Insert("Employee_InsertWithProcedure", p_dataObject);            
        }
    }
}