public MessageEntity DeleteEventType(M_EventType eventType)
{
using (var conn = ConnectionFactory.GetDBConn(ConnectionFactory.DBConnNames.PipeInspectionBase_Gis_OutSide))
{
var rows = 0;
var excSql = DapperExtentions.MakeDeleteSql(eventType);
if (string.IsNullOrEmpty(excSql))
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, "请检查实体类"));
}
try
{
rows = conn.Execute(excSql, eventType);
return(MessageEntityTool.GetMessage(rows));
}
catch (Exception e)
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, e.Message));
}
}
}
public int DeleteEntity(object entity, ConnectionFactory.DBConnNames dBConnName, out MessageEntity messageEntity)
{
using (var conn = ConnectionFactory.GetDBConn(dBConnName))
{
var rows = 0;
var result = DapperExtentions.MakeDeleteSql(entity);
if (string.IsNullOrEmpty(result))
{
messageEntity = MessageEntityTool.GetMessage(ErrorType.SqlError, "请检查实体类");
return(0);
}
try
{
rows = conn.Execute(result, entity);
messageEntity = MessageEntityTool.GetMessage(rows);
}
catch (Exception e)
{
messageEntity = MessageEntityTool.GetMessage(ErrorType.SqlError, e.Message);
}
return(rows);
}
}