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; }