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