public String getLastInfo(String patid) { String res = "null"; String query = "SELECT * from patient" + patid + " ORDER BY value_date DESC"; LastInfo lst = new LastInfo(); con = new OleDbConnection(con_string); com = new OleDbCommand(); con.Open(); com.Connection = con; com.CommandText = query; dr = com.ExecuteReader(); if (dr.Read()) { lst.spo2 = dr["spo2"].ToString(); lst.pulse = dr["pulse"].ToString(); lst.datetime = dr["value_date"].ToString(); res = JsonConvert.SerializeObject(lst); } else { res = "false"; con.Close(); } con.Close(); return(res); }
private static void Step4(LastInfo companyUserLastInfo) { var lastPage = PageFactory.Get <LastPage>(); lastPage.WaitForReady(); lastPage.Iachfield.SetText(companyUserLastInfo.Iachfield); lastPage.SignDocument.SetText(companyUserLastInfo.SignDocument); lastPage.SignDocument2.SetText(companyUserLastInfo.SignDocument2); lastPage.combobox.Select(companyUserLastInfo.combobox); lastPage.iachfield2.SetText(companyUserLastInfo.iachfield2); }