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);
}
/// <summary>
/// 获取路面设备
/// </summary>
/// <returns></returns>
public static List <dynamic> GetAllFrontendDevice()
{
string sql = "select DEVICEID,DEVICENAME from frontenddevice where functiontype like '09%' or functiontype='0200'";
List <FrontendDevice> list = null;
using (CommonDbContext db = new CommonDbContext())
{
list = db.SqlQuery(sql).Read <FrontendDevice>().ToList();
}
List <dynamic> listR = new List <dynamic>();
foreach (var item in list)
{
listR.Add(new
{
Value = item.DeviceId,
Text = item.DeviceName
});
}
return(listR);
}