/// <summary>
/// 新增数据
/// </summary>
///<param name="request">一条数据</param>
[HttpPost]
public MessageModel<string> Post([FromBody] Dtable request)
{
var lastdata = DbCon.Queryable<Dtable >().MaxAsync(it => it.ID).Result;
request.ID = Convert.ToInt32(lastdata) + 1; //id获取最大加1
request.CREATETIME = DateTime.Now; //当前时间
var data = new MessageModel<string>();
var id = DbCon.Insertable(request).ExecuteCommand(); //插入
//查询是否添加成功
var success1 = DbCon.Queryable<Dtable >().Where(it => it.ID == request.ID)
.ToList();
data.success = success1.Count > 0;
if (data.success)
{
data.response = id.ToString();
data.msg = "添加成功";
}
return data;
}
2、DbCon为对应数据库类,Dtable 为对应数据表实体类
public class Dtable
{
/// <summary>
/// 字典主键
/// </summary>
[SugarColumn(IsPrimaryKey = true)]
public int ID { get; set; }
/// <summary>
/// 字典名称
/// </summary>
public string NAME { get; set; }
/// <summary>
/// 字典类型
/// </summary>
public string TYPE { get; set; }
/// <summary>
/// 字典状态
/// </summary>
public int STATE { get; set; }
/// <summary>
/// 备注
/// </summary>
public string REMARK { get; set; }
/// <summary>
/// 创建时间
/// </summary>
public DateTime? CREATETIME { get; set; }
/// <summary>
/// 更新时间
/// </summary>
public DateTime? UPDATETIME { get; set; }
}