public static BloodOxygen XmlToBloodOxygen(string sxml) { string sql = @"insert into BloodOxygen values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}', '{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}', '{31}','{32}','{33}','{34}','{35}',{36})"; Data[] temp = new Data[2]; BloodOxygen bloodoxygen = new BloodOxygen(); try { XmlDocument DOC = new XmlDocument(); DOC.LoadXml(sxml); XmlElement root = DOC.DocumentElement; for (int i = 4; i < 6; ++i) { Data item = new Data(); string cname = "/CSBoard" + "/" + ((DataName)i).ToString() + "/CNAME"; string ename = "/CSBoard" + "/" + ((DataName)i).ToString() + "/ENAME"; string lrange = "/CSBoard" + "/" + ((DataName)i).ToString() + "/LRANGE"; string srange = "/CSBoard" + "/" + ((DataName)i).ToString() + "/SRANGE"; string unit = "/CSBoard" + "/" + ((DataName)i).ToString() + "/UNIT"; string value = "/CSBoard" + "/" + ((DataName)i).ToString() + "/VALUE"; //item.CNAME = no.SelectSingleNode(cname).InnerText; item.CNAME = root.SelectSingleNode(cname).InnerText; item.ENAME = root.SelectSingleNode(ename).InnerText; item.LRANGE = IntTryParse(root.SelectSingleNode(lrange).InnerText); item.SRANGE = IntTryParse(root.SelectSingleNode(srange).InnerText); item.UNIT = root.SelectSingleNode(unit).InnerText; item.VALUE = IntTryParse(root.SelectSingleNode(value).InnerText); bloodoxygen.data.Add(item); temp[i - 4] = item; } string s = String.Format(sql, bi.checkdate, bi.examNO, bi.checkID, bi.name, bi.sex, bi.age, bi.doctor, bi.deviceID, bi.version, bi.reserve, bi.check_flag, bi.hosname, bi.auditdoctor, bi.auditdate, bi.status, bi.str1, bi.str2, bi.str3, bi.str4, bi.str5, bi.str6, bi.str7, bi.str8, bi.str9, bi.str10, temp[0].ENAME, temp[0].CNAME, temp[0].UNIT, temp[0].SRANGE, temp[0].LRANGE, temp[0].VALUE, temp[1].ENAME, temp[1].CNAME, temp[1].UNIT, temp[1].SRANGE, temp[1].LRANGE, temp[1].VALUE); int flag = DBHelper.ExecuteNonQuerySql(s, DBHelper.ConnectionString); if (flag > 0) { bloodoxygen.HasData = true; } return(bloodoxygen); } catch { return(bloodoxygen); } }
public bool SendBloodOxygen(string sxml) { BasicInfo basic = new BasicInfo(); BloodOxygen blo = new BloodOxygen(); basic = XMLHelper.XmlToBasicInfo(XMLHelper.SelectXml(sxml, "/insert/baseInfo")); blo = XMLHelper.XmlToBloodOxygen(XMLHelper.SelectXml(sxml, "/insert/CSBoard")); if (basic.HasData && blo.HasData) { return(true); } else { return(false); } }