IBatisNet系列-执行存储过程

映射xml文件书写如下

<? xml version="1.0" encoding="utf-8"  ?>

< sqlMap  namespace ="Member"  xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance"  xsi:noNamespaceSchemaLocation ="SqlMap.xsd" >
     < resultMaps >
         < resultMap  id ="SelectResult"  class ="PlatAdmin.Model.Member" >
             < result  property ="Id"  column ="id"   />
             < result  property ="Identityno"  column ="identityno"   />
             < result  property ="Telephone"  column ="telephone"   />
             < result  property ="Email"  column ="email"   />
             < result  property ="Linktel"  column ="linktel"   />
             < result  property ="Address"  column ="address"   />
             < result  property ="Content"  column ="content"   />
             < result  property ="Username"  column ="username"   />
             < result  property ="Password"  column ="password"   />
             < result  property ="Truename"  column ="truename"   />
             < result  property ="Enable"  column ="enable"   />
             < result  property ="Regdate"  column ="regdate"   />
         </ resultMap >
     </ resultMaps >
        
     < parameterMaps >
         < parameterMap  id ="swapParas"  class ="PlatAdmin.Model.Member" >
             < parameter  property ="querystr"  column =""   />
             < parameter  property ="keyfield"  column =""   />
             < parameter  property ="pagesize"  column =""   />
             < parameter  property ="pagenumber"  column =""   />
         </ parameterMap >
     </ parameterMaps >
    
     < statements >
         < procedure  id ="GetMemberList"  parameterMap ="swapParas"  resultMap ="SelectResult" >
            usp_GetRecordset
         </ procedure >

        
     </ statements >
</ sqlMap >

 程序代码如下:

public  IList GetMemberList( string  querystr, int  pageNo)
         {
            Hashtable ht = new Hashtable();
            ht.Add("querystr",querystr);
            ht.Add("keyfield","id");
            ht.Add("pagesize",2);
            ht.Add("pagenumber",pageNo);

            SqlMapper sqlMap = IBatisNet.DataMapper.Mapper.Instance();

            try
            {
                return sqlMap.QueryForList("GetMemberList",ht);
            }
            catch(Exception e)
            {
                throw new IBatisNetException(e.Message,e);
            }
        }

转载于:https://www.cnblogs.com/maplye/archive/2006/03/25/358598.html