using CY_PUBLIC_LIBRARY
.Extension;
using DoMain
.hp_dto;
using Model
.sys_model;
using System
.Transactions;
namespace CY_API
.Controllers
.hController
{
[Route("api/[controller]")]
[Authorize]
[ApiExplorerSettings(GroupName = "base_data")]
public class HospitalController : BaseApiController
{
public HospitalController(IFreeSql fsql) : base(fsql) { }
/// <summary>
/// 新增
/// </summary>
/// <param name="hospitalDto">医院和科室信息</param>
/// <returns></returns>
[HttpPost]
public IActionResult AddHospitalWithDepartments([FromBody] hospitalDepartmentDto hospitalDto)
{
try
{
// 使用事务确保数据一致性
_fsql
.Transaction(() =>
{
// 1
. 创建医院
var hospital = new sys_hospital
{
name = hospitalDto
.name,
address = hospitalDto
.address,
image = hospitalDto
.image,
hospital_label = hospitalDto
.hospital_label,
is_hot = hospitalDto
.is_hot,
};
// 插入医院并获取自增ID
var hospitalId = _fsql
.Insert(hospital)
.ExecuteIdentity();
// 2
. 创建科室
var departments = hospitalDto
.hospitalDepartmentL
istDtos
.Select(d=> new sys_hospitaldepartment
{
name = d
.name,
hospital_id =(int)hospitalId,
content = d
.content,
//hd_id=d
.hd_id
})
.ToL
ist();
// 批量插入科室
_fsql
.Insert(departments)
.ExecuteAffrows();
});
return th
is.ReturnOk();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 显示医院列表
/// </summary>
/// <returns></returns>
[HttpGet]
public ActionResult<retEnumerable<retHospital>> GetHospital(string name, bool?
is_hot, int page=1, int size=5)
{
try
{
var query = _fsql
.Select<sys_hospital>();
if (!string
.IsNullOrEmpty(name))
{
query = query
.Where(x => x
.name
.Contains(name));
}
if (
is_hot
.HasValue)
{
query = query
.Where(x => x
.is_hot ==
is_hot
.Value);
}
var hospitals =query
.OrderByDescending(x => x
.hospital_id)
.Page(page, size)
.ToL
ist();
// 获取每个医院的科室信息
var result = hospitals
.Select(hospital => new retHospital
{
hospital_id = hospital
.hospital_id,
name = hospital
.name,
address = hospital
.address,
image = hospital
.image,
hospital_label = hospital
.hospital_label,
is_hot = hospital
.is_hot,
// 获取该医院的科室列表
departments = _fsql
.Select<sys_hospitaldepartment>()
.Where(d => d
.hospital_id == hospital
.hospital_id)
.Page(page,size)
.ToL
ist(d => new retHospitalDepartment
{
hd_id = d
.hd_id,
name = d
.name,
content = d
.content,
hospital_id = d
.hospital_id
})
})
.ToL
ist();
return Ok(result
.GetRetEnumerable());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[HttpDelete("{id}")]
public IActionResult DeleteHp(int id)
{
_fsql
.Transaction(() =>
{
_fsql
.Update<sys_hospital>(id)
.Set(e => e
.is_del, true)
.ExecuteAffrows();
});
return th
is.ReturnOk();
}
/// <summary>
.
/// 修改医院和科室
/// </summary>
/// <param name="upd">医院和科室信息</param>
/// <returns></returns>
[HttpPut]
public IActionResult UpdateHospitalWithDepartments([FromBody] updatehospitalDepartment upd)
{
try
{
// 使用事务确保数据一致性
_fsql
.Transaction(() =>
{
// 1
. 更新医院信息
var hospital = new sys_hospital
{
hospital_id = upd
.hospital_id,
name = upd
.name,
address = upd
.address,
image = upd
.image,
hospital_label = upd
.hospital_label,
is_hot =upd
.is_hot
};
_fsql
.Update<sys_hospital>()
.SetSource(hospital)
.ExecuteAffrows();
// 2
. 更新科室信息
var departments = upd
.updhospitalDepartmentL
istDtos
.Select(d => new sys_hospitaldepartment
{
hd_id = d
.hd_id,
name = d
.name,
content = d
.content,
hospital_id = upd
.hospital_id,
})
.ToL
ist();
// 修改关联科室
_fsql
.Update<sys_hospitaldepartment>()
.Where(d => d
.hospital_id == hospital
.hospital_id)
.SetSource(departments)
.ExecuteAffrows();
});
// 返回更新后的医院详情（包含科室）
return Ok(upd
.hospital_id);
}
catch (Exception ex)
{
throw ex;
}
}
}
}
为啥我后台测试的时候都是对的，但前端调用接口会
报错，修改不成功，而且有时候前端也添加少张表添加进去
本文解决了一个在Windows7操作系统中遇到的COM+服务权限问题，该问题导致了应用程序在执行事务操作时出现错误。通过调整权限设置，成功解决了这一难题。
扫一扫
1336
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
