asp.net core sqlsugar 复制插入并返回新id
var result = await _db.Ado.GetScalarAsync("insert into qy_gw(gwmc,qyid,shzt,cdt,zplx,gwlb,gzcs,zprs,xcfw,xqzy,yyyq,gwms,jssj,lxr,phone,refreshtime,jsjyq) select gwmc,qyid,'审核中','" + DateTime.Now + "',zplx,gwlb,gzcs,zprs,xcfw,xqzy,yyyq,gwms,'" + DateTime.Now.AddMonths(3) + "',lxr,phone,'" + DateTime.Now + "',jsjyq from qy_gw where id=" + id + " returning id;"); _regid = await _db.Insertable(reginfo).AS("qy").ExecuteReturnIdentityAsync();