/// <summary>
/// EF 执行 Sql
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public bool ExecuteNonQuery(string sql, params object[] parameters)
{
try
{
return(_context.Database.ExecuteSqlCommand(sql, parameters) > 0);
}
catch (Exception ex)
{
MessageLog.AddErrorLogDalSpecial("ExecuteSqlCommand(EF 执行 Sql)", ex.Message);
return(false);
}
}
public bool AddImportService_2(List <td_Service_2> list)
{
try
{
if (list == null)
{
return(false);
}
_context.td_Service_2.RemoveRange(_context.td_Service_2.ToList());
_context.td_Service_2.AddRange(list);
_context.SaveChanges();
return(true);
}
catch (Exception ex)
{
MessageLog.AddErrorLogDalSpecial("td_Service_2(虚拟服务器导入)", ex.Message);
return(false);
}
}
/// <summary>
/// 机房
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool AddImportRoom(List <td_ComputerRoom_1> list)
{
try
{
if (list == null)
{
return(false);
}
_context.td_ComputerRoom_1.RemoveRange(_context.td_ComputerRoom_1.ToList());
_context.td_ComputerRoom_1.AddRange(list);
_context.SaveChanges();
return(true);
}
catch (Exception ex)
{
MessageLog.AddErrorLogDalSpecial("AddImportRoom(机房情况导入)", ex.Message);
return(false);
}
}
public bool AddImportSecurity_sl(List <td_Security_xxsl_1> list)
{
try
{
if (list == null)
{
return(false);
}
_context.td_Security_xxsl_1.RemoveRange(_context.td_Security_xxsl_1.ToList());
_context.td_Security_xxsl_1.AddRange(list);
_context.SaveChanges();
return(true);
}
catch (Exception ex)
{
MessageLog.AddErrorLogDalSpecial("AddImportSecurity_sl(安全情况数量导入)", ex.Message);
return(false);
}
}
/// <summary>
/// 软件
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool AddImportSoft(List <td_GenuineSoftware_1> list)
{
try
{
if (list == null)
{
return(false);
}
_context.td_GenuineSoftware_1.RemoveRange(_context.td_GenuineSoftware_1.ToList());
_context.td_GenuineSoftware_1.AddRange(list);
_context.SaveChanges();
return(true);
}
catch (Exception ex)
{
MessageLog.AddErrorLogDalSpecial("AddImportSoft(软件情况导入)", ex.Message);
return(false);
}
}
