/// <summary>
/// 批量修改
/// </summary>
/// <param name="list"></param>
/// <param name="strCols"></param>
/// <returns></returns>
public bool UpdateList(List <T> list, string strCols)
{
if (list == null || list.Count == 0)
{
return(false);
}
List <CommandInfo> comList = new List <CommandInfo>();
foreach (T t in list)
{
SqlModel update = CreateSql.GetUpdateSqlAndParas <T>(t, strCols, "");
CommandInfo com = new CommandInfo(update.Sql, false, update.SqlParaArray);
comList.Add(com);
}
return(SqlHelper.ExecuteTrans(comList));
}
/// <summary>
/// 修改信息实体
/// </summary>
/// <param name="t"></param>
/// <param name="strCols">要修改的列</param>
/// <param name="strWhere">条件 </param>
/// <returns></returns>
public bool Update(T t, string strCols, string strWhere, params SqlParameter[] paras)
{
if (t == null)
{
return(false);
}
//获取生成的sql和参数列表
SqlModel update = CreateSql.GetUpdateSqlAndParas <T>(t, strCols, strWhere);
List <SqlParameter> listParas = update.SqlParaArray.ToList();
if (paras != null && paras.Length > 0)
{
listParas.AddRange(paras);
}
//执行sql命令
return(SqlHelper.ExecuteNonQuery(update.Sql, 1, listParas.ToArray()) > 0);
}
