Пример #1
0
        private void button7_Click(object sender, EventArgs e)
        {
            DBConn    db       = new DBConn();
            string    sql      = "select * from cydj where aac044 = '" + s.aac044 + "' and id = " + str_id;
            DataTable dt       = db.GetDataSet(sql).Tables[0];
            string    ykc      = "select ykc700 from fhjzdj where aac044 = '" + s.aac044 + "' and id = " + str_id;
            DataTable dt1      = db.GetDataSet(ykc).Tables[0];
            string    ykc700   = dt1.Rows[0]["ykc700"].ToString();
            string    otransid = dt.Rows[0]["transid"].ToString();
            string    aae011   = dt.Rows[0]["aae011"].ToString();

            DialogResult dr = MessageBox.Show("该病号已做出院登记,是否回退?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            if (dr == DialogResult.OK)
            {
                WebReference.STYDJY bbb = new WebReference.STYDJY();
                string resultxml        = bbb.STYDJKService("0216", "<?xml version=\"1.0\" encoding=\"GBK\"?>"
                                                            + "<input>"
                                                            + "<otransid>" + otransid + "</otransid>"
                                                            + "<aab299>" + PublicCommon.aab299 + "</aab299>"
                                                            + "<yab600>" + PublicCommon.yab600 + "</yab600>"
                                                            + "<akb026>" + PublicCommon.akb026 + "</akb026>"
                                                            + "<akb021>" + PublicCommon.akb021 + "</akb021>"
                                                            + "<ykc700>" + ykc700 + "</ykc700>"
                                                            + "<aab301>" + s.aab301 + "</aab301>"
                                                            + "<yab060>" + s.yab060 + "</yab060>"
                                                            + "<aac002>" + s.aac002 + "</aac002>"
                                                            + "<aac043>" + s.aac043 + "</aac043>"
                                                            + "<aac044>" + s.aac044 + "</aac044>"
                                                            + "<aae011>" + aae011 + "</aae011>"
                                                            + "<aae036>" + DateTime.Now.ToString("yyyyMMdd") + "</aae036>"
                                                            + "</input>");

                if (resultxml == "")
                {
                    return;
                }
                XmlDocument xd = new XmlDocument();
                xd.LoadXml(resultxml);
                XmlNode res   = xd.SelectSingleNode("//result");
                int     error = int.Parse(res.SelectSingleNode("errorcode").InnerText);
                if (error < 0)
                {
                    MessageBox.Show(res.SelectSingleNode("errormsg").InnerText);
                }
                else
                {
                    string sql1 = "delete cydj where aac044 = '" + s.aac044 + "' and id = " + str_id;
                    db.GetSqlCmd(sql1);
                    MessageBox.Show("身份证为:" + s.aac044 + " 的病人出院登记回退成功");
                }
            }
        }
Пример #2
0
        private void button5_Click(object sender, EventArgs e)
        {
            DBConn    db  = new DBConn();
            string    sql = "select * from gxjzdj where aac044 = '" + s.aac044 + "' and id = " + str_id;
            DataTable dt  = db.GetDataSet(sql).Tables[0];

            if (dt.Rows.Count < 1)
            {
                MessageBox.Show("该病人尚未就诊登记"); return;
            }
            gxjzdj gx   = new gxjzdj();
            var    pros = gx.GetType().GetProperties();

            foreach (var p in pros)
            {
                p.SetValue(gx, dt.Rows[0][p.Name].ToString(), null);
            }

            DialogResult dr = MessageBox.Show("确认对该病人进行就诊登记回退吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            if (dr == DialogResult.OK)
            {
                string otran            = "select transid from fhjzdj where aac044 = '" + s.aac044 + "' and id=" + str_id;
                string otranid          = db.GetDataSet(otran).Tables[0].Rows[0]["transid"].ToString();
                WebReference.STYDJY bbb = new WebReference.STYDJY();
                string resultxml        = bbb.STYDJKService("0214", "<?xml version=\"1.0\" encoding=\"GBK\"?>"
                                                            + "<input>"
                                                            + "<otransid>" + otranid + "</otransid>"
                                                            + "<aab299>" + PublicCommon.aab299 + "</aab299>"
                                                            + "<yab600>" + PublicCommon.yab600 + "</yab600>"
                                                            + "<akb026>" + PublicCommon.akb026 + "</akb026>"
                                                            + "<akb021>" + PublicCommon.akb021 + "</akb021>"
                                                            + "<ykc700>" + gx.ykc700 + "</ykc700>"
                                                            + "<aab301>" + gx.aab301 + "</aab301>"
                                                            + "<yab060>" + gx.yab060 + "</yab060>"
                                                            + "<aac002>" + gx.aac002 + "</aac002>"
                                                            + "<aac043>" + gx.aac043 + "</aac043>"
                                                            + "<aac044>" + gx.aac044 + "</aac044>"
                                                            + "<aae011>" + gx.aae011 + "</aae011>"
                                                            + "<aae036>" + gx.aae036 + "</aae036>"
                                                            + "</input>");

                if (resultxml == "")
                {
                    return;
                }
                XmlDocument xd = new XmlDocument();
                xd.LoadXml(resultxml);
                XmlNode res   = xd.SelectSingleNode("//result");
                int     error = int.Parse(res.SelectSingleNode("errorcode").InnerText);
                if (error < 0)
                {
                    MessageBox.Show(res.SelectSingleNode("errormsg").InnerText);
                }
                else
                {
                    MessageBox.Show("身份证为:" + gx.aac044 + " 的病人出院登记回退成功");
                    string sql1 = "delete fhjzdj where aac044 = '" + gx.aac044 + "' and id = " + str_id;
                    string sql2 = "delete gxjzdj where aac044 = '" + gx.aac044 + "' and id = " + str_id;
                    db.GetSqlCmd(sql1);
                    db.GetSqlCmd(sql2);
                    frm3.sfsbcx();
                }
            }
        }