//新增身份识别
public void xzsfsb(string xml)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
XmlNode list = doc.SelectSingleNode("//result");
XmlNode ot = list.SelectSingleNode("output");
Sfyz s = new Sfyz();
var propers = s.GetType().GetProperties();
foreach (var p in propers)
{
if (p.Name != "sign" && p.Name != "transid" && p.Name != "errorcode" && p.Name != "errormsg")
{
string n = ot.SelectSingleNode(p.Name).InnerText;
if (n.Trim() == "")
{
n = null;
}
p.SetValue(s, n, null);
}
else
{
p.SetValue(s, list.SelectSingleNode(p.Name).InnerText, null);
}
}
//status 0验证 1就诊登记 2费用明细上传 3出院登记 4费用结算 5病案上传
DBConn db = new DBConn();
string sql = "INSERT INTO [ydjs_zyy].[dbo].[sfsb]([sign],[transid],[errorcode],[errormsg],[aab301],[yab060],[aac002],"
+ "[aac043],[aac044],[aac003],[aac004],[aac005],[aac006],[ykc021],[ykc300],[akc026],[akc023],[aae379],[akc252]"
+ ",[aab001],[aab003],[aab004],[yka116],[yka119],[yka121],[yka123],[ake092],[yka437],[akc200],[ykc667],[yzz014],[ake132]"
+ ",[ykc669],[ykc678],[ykc670],[aka130],[ykc682],[ake014],[ykc672],[ykc673],[ykc674],[status]) "
+ "VALUES('" + s.sign + "','" + s.transid + "','" + s.errorcode + "','" + s.errormsg + "','" + s.aab301 + "','" + s.yab060 + "','" + s.aac002 + "',"
+ "'" + s.aac043 + "','" + s.aac044 + "','" + s.aac003 + "','" + s.aac004 + "','" + s.aac005 + "','" + s.aac006 + "','" + s.ykc021 + "','" + s.ykc300 + "','" + s.akc026 + "',"
+ "'" + s.akc023 + "','" + s.aae379 + "','" + s.akc252 + "','" + s.aab001 + "','" + s.aab003 + "','" + s.aab004 + "','" + s.yka116 + "','" + s.yka119 + "','" + s.yka121 + "','"
+ s.yka123 + "','" + s.ake092 + "','" + s.yka437 + "','" + s.akc200 + "','" + s.ykc667 + "','" + s.yzz014 + "','" + s.ake132 + "','" + s.ykc669 + "','" + s.ykc678 + "','"
+ s.ykc670 + "','" + s.aka130 + "','" + s.ykc682 + "','" + s.ake014 + "'," + "'" + s.ykc672 + "','" + s.ykc673 + "','" + s.ykc674 + "','0')select @@identity ";
string issql = "select * from sfsb where aac044 = '" + s.aac044 + "' and status!='5'";
DataTable dt = db.GetDataSet(issql).Tables[0];
if (dt.Rows.Count < 1)
{
str_id = db.GetDataScalar(sql).ToString();
if (int.Parse(str_id) > 0)//转换测试数据
{
MessageBox.Show("身份验证信息已添加");
}
}
else
{
MessageBox.Show("身份验证已存在");
}
}
