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);
}
}
