/// <summary>
///
/// </summary>
/// <param name="pointId"></param>
/// <param name="pointTable"></param>
/// <returns></returns>
public MessageEntity UpdatePointTableByPointId(PointAreaInfo pointTable)
{
using (var conn = ConnectionFactory.GetDBConn(ConnectionFactory.DBConnNames.PipeInspectionBase_Gis_OutSide))
{
var rows = 0;
string sql = $@"select count(0) as count from PointAreaInfo p where p.PlanAreaId = {pointTable.PlanAreaId} and p.PointName='{ pointTable.PointName}'";
List <dynamic> pointcc = conn.Query <dynamic>(sql).ToList();
if (pointcc[0].count > 0)
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, "同一区域内不能添加相同关键点"));
}
var updateSql = DapperExtentions.MakeUpdateSql(pointTable);
if (string.IsNullOrEmpty(updateSql))
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, "请检查实体类"));
}
try
{
rows = conn.Execute(updateSql, pointTable);
return(MessageEntityTool.GetMessage(rows));
}
catch (Exception e)
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, e.Message));
}
}
}
/// <summary>
/// 删除区域下点位
/// </summary>
/// <param name="PointId">点位PointId</param>
/// <returns></returns>
public MessageEntity Delete(int PointId)
{
PointAreaInfo value = new PointAreaInfo();
value.PointId = PointId;
var messageEntity = _pointAreaInfoDAL.DeletePointArea(value);
return(messageEntity);
}
/// <summary>
/// 根据pointId修改pointAreaInfo
/// </summary>
/// <param name="pointId">PointId</param>
/// <param name="pointAreaInfo">实体PointX/PointY/PointName不可为空</param>
/// <returns></returns>
// PUT api/<controller>/5
public MessageEntity Put(int pointId, [FromBody] PointAreaInfo pointAreaInfo)
{
if (string.IsNullOrEmpty(pointAreaInfo.PointX) || string.IsNullOrEmpty(pointAreaInfo.PointY) || string.IsNullOrEmpty(pointAreaInfo.PointName))
{
return(MessageEntityTool.GetMessage(ErrorType.FieldError));
}
pointAreaInfo.PointId = pointId;
var messageEntity = _pointAreaInfoDAL.UpdatePointTableByPointId(pointAreaInfo);
return(messageEntity);
}
/// <summary>
/// 添加区域下点位
/// </summary>
/// <param name="value">实体PointX/PointY/PointName/PlanAreaId不可为空</param>
/// <returns></returns>
public MessageEntity Post([FromBody] PointAreaInfo value)
{
if (string.IsNullOrEmpty(value.PointX) || string.IsNullOrEmpty(value.PointY) || string.IsNullOrEmpty(value.PointName) || value.PlanAreaId == null)
{
return(MessageEntityTool.GetMessage(ErrorType.FieldError));
}
value.AddTime = DateTime.Now;
var messageEntity = _pointAreaInfoDAL.AddPointArea(value);
return(messageEntity);
}
public MessageEntity DeletePointArea(PointAreaInfo pointTable)
{
using (var conn = ConnectionFactory.GetDBConn(ConnectionFactory.DBConnNames.PipeInspectionBase_Gis_OutSide))
{
var rows = 0;
var updateSql = DapperExtentions.MakeDeleteSql(pointTable);
if (string.IsNullOrEmpty(updateSql))
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, "请检查实体类"));
}
try
{
rows = conn.Execute(updateSql, pointTable);
return(MessageEntityTool.GetMessage(rows));
}
catch (Exception e)
{
return(MessageEntityTool.GetMessage(ErrorType.SqlError, e.Message));
}
}
}
