public ResponseResult <string> addArea([FromQuery] string token, string name, string abb)
{
claim = (JwtClaim)_accessor.HttpContext.Items["user"];
try
{
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(abb))
{
return(ResponseResult <string> .Error("参数异常"));
}
SYS_AREA area = new SYS_AREA {
NAME = name, ABBREVIATION = abb
};
var b = SystemService.addArea(area, connstr);
if (b)
{
return(ResponseResult <string> .Success("操作成功", "操作成功"));
}
else
{
return(ResponseResult <string> .Success("操作失败", "操作失败"));
}
}
catch (Exception ex)
{
return(ResponseResult <string> .Error("系统异常"));
}
}
public bool addArea(SYS_AREA area, string connectionString)
{
bool _user = false;
string sql = $@"INSERT INTO `sys_area` ( `name`, `abbreviation`)
VALUES
(
'{area.NAME}',
'{area.ABBREVIATION}'
);" ;
using (IDbConnection conn = DataBaseConfig.GetSqlConnection(DBType.mysql, connectionString))
{
var obj = conn.Execute(sql);
if (obj >= 1)
{
_user = true;
}
}
return(_user);
}
