/// <summary>
/// 修改功能(sql语句修改)
/// </summary>
/// <param name="sqlStr"></param>
/// <returns></returns>
public int Update(string sqlStr)
{
try
{
return(dapperHelps.ExecuteSqlInt(sqlStr));
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
return(0);
}
}
/// <summary>
/// 批量更新实体,返回更新状态
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="List"></param>
/// <returns></returns>
public bool UpdateList <T>(List <T> List) where T : class
{
try
{
if (List.Count <= 0)
{
return(false);
}
return(dapperHelps.ExecuteUpdateList <T>(List));
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
return(false);
}
}
/// <summary>
/// 修改单个实体
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateModel <T>(T model) where T : class
{
try
{
if (model == null)
{
return(false);
}
return(dapperHelps.UpdateModel <T>(model));
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
return(false);
}
}
/// <summary>
/// 添加集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="modelList"></param>
/// <returns></returns>
public bool InsertList <T>(List <T> modelList) where T : class
{
try
{
if (modelList.Count <= 0)
{
return(false);
}
dapperHelps.ExecuteInsertList <T>(modelList);
return(true);
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
return(false);
}
}
/// <summary>
/// 新增操作(主键为Guid)
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <returns></returns>
public string InsertModelGuid <T>(T model) where T : class
{
try
{
if (model == null)
{
return(String.Empty);
}
var id = dapperHelps.ExecuteInsertGuid <T>(model);
return(id);
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
return(String.Empty);
}
}
/// <summary>
/// 新增操(主键为Int类型)
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <returns></returns>
public long InsertModelInt <T>(T model) where T : class
{
try
{
if (model == null)
{
return(0);
}
var id = dapperHelps.ExecuteInsert <T>(model);
return(id);
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
return(0);
}
}
/// <summary>
/// 批量修改返回成功和失败的条数
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="List"></param>
/// <param name="ErrorCount"></param>
/// <returns></returns>
public int UpdateList <T>(List <T> List, out int ErrorCount) where T : class
{
try
{
if (List.Count <= 0)
{
ErrorCount = 0;
return(0);
}
return(dapperHelps.ExecuteUpdateList <T>(List, out ErrorCount));
}
catch (Exception ex)
{
WriteLogMethod.WriteLogs(ex);
ErrorCount = 0;
return(0);
}
}
