/// <summary> /// 批量插入数据 /// </summary> /// <param name="modelList"></param> /// <returns></returns> public override int InsertList(List <IModel> ml) { lock (m_lock) { int result = 0; OpenConnection(); //cmd.Transaction = conn.BeginTransaction(); foreach (IModel model in ml) { string sql = ""; SqlParameter[] dp = (SqlParameter[])SqlStringHelper.MakeInsertSql(model, ref sql); cmd.Parameters.Clear(); foreach (SqlParameter item in dp) { cmd.Parameters.Add(item); } cmd.CommandText = sql; try { result += cmd.ExecuteNonQuery(); } catch (SqlException e) { //cmd.Transaction.Rollback(); //CloseConnection(); //return 0; } } //cmd.Transaction.Commit(); CloseConnection(); return(result); } }
/// <summary> /// 插入数据, 返回插入的行数 /// </summary> /// <param name="model"></param> /// <returns></returns> public override int Insert(IModel model) { lock (m_lock) { int result = 0; string sql = ""; SqlParameter[] dp = (SqlParameter[])SqlStringHelper.MakeInsertSql(model, ref sql); cmd.Parameters.Clear(); foreach (SqlParameter item in dp) { cmd.Parameters.Add(item); } cmd.CommandText = sql; try { OpenConnection(); result = cmd.ExecuteNonQuery(); } catch (SqlException e) { throw e; } finally { CloseConnection(); } return(result); } }