/// <summary>
/// 部分替换
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="logicDbName">DatabaseSet 名称</param>
/// <param name="replacePartial">IReplacePartial 对象</param>
/// <param name="obj"></param>
/// <param name="hints"></param>
/// <returns></returns>
public Object ReplacePartially <T>(String logicDbName, IReplacePartial <T> replacePartial, T obj, IDictionary hints) where T : class, new()
{
try
{
LogManager.Logger.StartTracing();
SqlTable table = SqlTableFactory.Instance.Build(logicDbName, typeof(T));
Statement statement = SqlBuilder.GetReplacePartialSqlStatement(table, obj, logicDbName, null, replacePartial, hints, false);
SqlTable.AddSqlToExtendParams(statement, hints);
var result = table.Identity == null?DatabaseBridge.Instance.ExecuteNonQuery(statement) : DatabaseBridge.Instance.ExecuteScalar(statement);
return(result);
}
finally
{
LogManager.Logger.StopTracing();
}
}
/// <summary>
/// 批量替换对象,batchSize：100
/// <example><para>示例：</para>
/// <code>
/// <para>
/// readonly BaseDao baseDao = BaseDaoFactory.CreateBaseDao("your databaseSetName");
/// List( < UserPrizeDrawedResultsEntity > list = new List < UserPrizeDrawedResultsEntity >();
/// IDictionary statementParams = new new Hashtable();
/// statementParams.Add(DALExtStatementConstant.TIMEOUT, "1000");
/// UserPrizeDrawedResultsEntity item = null;
/// for (int i = 0; i < 100; i++)
/// {
/// item = new UserPrizeDrawedResultsEntity();
/// item.PrizeDrawTime ="test";
/// item.PrizeInfoID = "test";
/// item.PrizeActivityId = "test";
/// item.Uid = "test";
/// list.Add(item);
/// }
/// baseDao.BulkReplace(list);</para>
/// </code>
/// </example>
/// <remarks>
/// <para>备注:批量替换对象</para>
/// <para> 1.batchSize最大10000，建议100，分批插入。</para>
/// <para> 2.该批量替换推荐在mysql中使用，如果MsSQL推荐用表变量方式处理</para>
/// <para> 3.扩展属性的key，具体可以查询DALExtStatementConstant的常量列表（譬如：timeout等）</para>
/// <para> 4.可以通过指定的逻辑数据库名插入数据，也就是一个dao(数据访问对象)支持多个数据库连接</para>
/// </remarks>
/// </summary>
/// <typeparam name="T">对象类型</typeparam>
/// <param name="logicDbName">逻辑数据库名</param>
/// <param name="list">对象集合</param>
/// <param name="hints">扩展属性，譬如:timeout等 </param>
/// <returns>是否成功</returns>
/// <remarks>1.集合对象不能超过10000, 2.SQLServer参数不能超过2100, Mysql控制报文最大长度</remarks>
/// <exception cref="DalException">数据访问框架异常</exception>
public Boolean BulkReplace <T>(String logicDbName, IList <T> list, IDictionary hints) where T : class, new()
{
try
{
LogManager.Logger.StartTracing();
if (list != null && list.Count > 10000)
{
throw new DalException("最多支持插入数据超10000个，请批量插入");
}
SqlTable table = SqlTableFactory.Instance.Build(logicDbName, typeof(T));
Statement statement = SqlBuilder.GetBulkReplaceSqlStatement(table, list, logicDbName, null, hints);
SqlTable.AddSqlToExtendParams(statement, hints);
return(DatabaseBridge.Instance.ExecuteNonQuery(statement) > 0);
}
finally
{
LogManager.Logger.StopTracing();
}
}