background image

 5         /// <param name="statementName">statement 的 id</param>
 6         /// <param name="paramObject">sql 语句的参数</param>
 7         /// <returns>DataTable</returns>
 8         protected virtual DataSet QueryForDataSet(ISqlMapper sqlMapper, string statementName, 
object paramObject)
 9         {
10             DataSet ds = new DataSet();
11             IMappedStatement statement = sqlMapper.GetMappedStatement(statementName);
12             if (!sqlMapper.IsSessionStarted)
13             {
14                 sqlMapper.OpenConnection();
15             }
16                         RequestScope  scope  =  statement.Statement.Sql.GetRequestScope(statement, 
paramObject, sqlMapper.LocalSession);
17 
18                         statement.PreparedCommand.Create(scope,  sqlMapper.LocalSession, 
statement.Statement, paramObject);
19 
20                         IDbCommand  cmd  =  GetDbCommand(sqlMapper,  statementName, 
paramObject);//SQL text command
21             sqlMapper.LocalSession.CreateDataAdapter(cmd).Fill(ds);
22             return ds;
23         }

 好了  下面我们来看一下批量插入数据:

1,首先我们要给实体做好描述

 1 namespace Model
 2 {
 3     [Serializable]
 4     public class Calsses : Entity
 5     {
 6         private int calsses_id;
 7         /// <summary>
 8         /// 班级编号
 9         /// </summary>
10         [TableColumnAttribute(Description = "该属性是真实表所对应的列名")]
11         public int Calsses_id
12         {
13             get { return calsses_id; }
14             set { calsses_id = value; }