public ApiResult <FrontendDevice> Get(string id)
{
ApiResult <FrontendDevice> result = new ApiResult <FrontendDevice>();
using (CommonDbContext db = new CommonDbContext())
{
result.Result = db.Set <FrontendDevice>().FindById(id);
//测试SqlQuery方法
var list = db.SqlQuery("SELECT * FROM PASSPORT_APPLICATIONFORM WHERE APPLICATIONID =:Id", new { Id = "0EXFQJESIFD491UF530X" }).Read <ApplicationForm>();
result.Message = JsonConvert.SerializeObject(list);
//测试非查询SQL执行
int rowCount = db.ExecuteSqlCommand(@"UPDATE PASSPORT_APPLICATIONFORM " +
" SET MODIFIEDTIME=:Time WHERE APPLICATIONID =:Id", new { Time = DateTime.Now, Id = "0EXFQJESIFD491UF530X" });
result.TotalCount = rowCount;
}
return(result);
}