public ResponseResult <string> addRoom([FromQuery] string token, string name, int area, int status)
{
claim = (JwtClaim)_accessor.HttpContext.Items["user"];
try
{
if (string.IsNullOrEmpty(name))
{
return(ResponseResult <string> .Error("参数异常"));
}
SYS_ROOMINFO room = new SYS_ROOMINFO {
NAME = name, AREA = area, STATUS = status
};
var b = SystemService.addRoom(room, connstr);
if (b)
{
return(ResponseResult <string> .Success("操作成功", "操作成功"));
}
else
{
return(ResponseResult <string> .Success("操作失败", "操作失败"));
}
}
catch (Exception ex)
{
return(ResponseResult <string> .Error("系统异常"));
}
}
public bool addRoom(SYS_ROOMINFO room, string connectionString)
{
bool _user = false;
string sql = $@"INSERT INTO `bcr`.`sys_roominfo` ( `name`, `area`, `status`) VALUES
(
'{room.NAME}',{room.AREA},{room.STATUS});" ;
using (IDbConnection conn = DataBaseConfig.GetSqlConnection(DBType.mysql, connectionString))
{
var obj = conn.Execute(sql);
if (obj >= 1)
{
_user = true;
}
}
return(_user);
}
public bool UpdateEntity(SYS_ROOMINFO entity, string connectionString = null)
{
throw new NotImplementedException();
}
