/// <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)); } } }