private void button5_Click(object sender, EventArgs e) { DBConn db = new DBConn(); 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(); string resultxml = qj.cscf("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>" + gj.ykc700 + "</ykc700>" + "<aab301>" + gj.aab301 + "</aab301>" + "<yab060>" + gj.yab060 + "</yab060>" + "<aac002>" + gj.aac002 + "</aac002>" + "<aac043>" + gj.aac043 + "</aac043>" + "<aac044>" + gj.aac044 + "</aac044>" + "<aae011>" + gj.aae011 + "</aae011>" + "<aae036>" + gj.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("身份证为:" + gj.aac044 + " 的病人出院登记回退成功"); qj.gxStatus(0, s.aac044, str_id); string sql1 = "delete fhjzdj where aac044 = '" + gj.aac044 + "' and id =" + str_id; string sql2 = "delete gxjzdj where aac044 = '" + gj.aac044 + "' and id =" + str_id; db.GetSqlCmd(sql1); db.GetSqlCmd(sql2); qj.dHuitui("fymxjl", gj.aac044, str_id); gxinit(); } } }
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 + " 的病人出院登记回退成功"); } } }
private void button1_Click(object sender, EventArgs e) { DBConn conn = new DBConn(); string ssql = "select * from zidian where csdm = '" + textBox1.Text.Trim() + "'"; string sql = "INSERT INTO [ydjs_zyy].[dbo].[zidian]([csdm],[csmc]) VALUES('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "')"; int i = conn.GetDataSet(ssql).Tables[0].Rows.Count; if (i < 1) { conn.GetSqlCmd(sql); } label3.Text = textBox1.Text; textBox1.Text = ""; textBox2.Text = ""; }
private void button2_Click(object sender, EventArgs e) { string yzz062 = ""; String Str_xml = ""; strSql = "select yzz062 from ydsb where yzz060='" + dateTimePicker1.Value.ToString("yyyy") + "' and yzz061='" + dateTimePicker1.Value.ToString("MM") + "' and aae140 = '" + aae140 + "'"; // sqlDataReader = new SqlDataReader(); sqlDataReader = db.GetDataReader(strSql); if (sqlDataReader.Read()) { yzz062 = getStringFormat("P440800", dateTimePicker1.Value.ToString("yy") + dateTimePicker1.Value.ToString("MM"), sqlDataReader.GetValue(0).ToString()); } else { yzz062 = "P440800" + dateTimePicker1.Value.ToString("yy") + dateTimePicker1.Value.ToString("MM") + "0000001"; } if (button2.Text == "提交") { Str_xml = "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<aab299>" + PublicCommon.aab299 + "</aab299>" + "<akb026>" + PublicCommon.akb026 + "</akb026>" + "<akb021>" + PublicCommon.akb021 + "</akb021>" + "<yzz060>" + dateTimePicker1.Value.ToString("yyyy") + "</yzz060>" + "<yzz061>" + dateTimePicker1.Value.ToString("MM") + "</yzz061>" + "<yzz062>" + yzz062 + "</yzz062>" /* + "<aae011>" + "LH" + "</aae011>" + "<aae036>" + DateTime.Now.ToString("yyyy-MM-dd") + "</aae036>" */ + "<yzz063>" + label3.Text + "</yzz063>" + "<yzz064>" + label6.Text + "</yzz064>" + "<yzz134>" + textBox1.Text.Trim() + "</yzz134>" + "<yzz135>" + textBox1.Text.Trim() + "</yzz135>" + "<yzz136>" + textBox1.Text.Trim() + "</yzz136>" + "<yzz137>" + DateTime.Now.ToString("yyyyMMdd") + "</yzz137>" + "<yzz138>" + textBox2.Text.Trim() + "</yzz138>" + "<yzz041>" + dateTimePicker1.Value.AddDays(1 - dateTimePicker1.Value.Day).ToString("yyyyMMdd") + "</yzz041>" + "<yzz042>" + dateTimePicker1.Value.AddDays(1 - dateTimePicker1.Value.Day).Date.AddMonths(1).AddSeconds(-1).ToString("yyyyMMdd") + "</yzz042>" + "<aae140>" + aae140 + "</aae140><detail>"; for (int i = 0; i < dataGridView1.Rows.Count; i++) { Str_xml = Str_xml + " <row>" + "<aac002>" + dataGridView1.Rows[i].Cells[0].Value.ToString() + "</aac002>" + "<aac043>" + dataGridView1.Rows[i].Cells[1].Value.ToString() + "</aac043>" + "<aac044>" + dataGridView1.Rows[i].Cells[2].Value.ToString() + "</aac044>" + "<aac003>" + dataGridView1.Rows[i].Cells[3].Value.ToString() + "</aac003>" + "<aab301>" + dataGridView1.Rows[i].Cells[4].Value.ToString() + "</aab301>" + "<ykc700>" + dataGridView1.Rows[i].Cells[5].Value.ToString() + "</ykc700>" + "<ykc618>" + dataGridView1.Rows[i].Cells[6].Value.ToString() + "</ykc618>" + "<ykc701>" + dataGridView1.Rows[i].Cells[7].Value.ToString() + "</ykc701>" + "<ykc702>" + dataGridView1.Rows[i].Cells[8].Value.ToString() + "</ykc702>" + "<akb063>" + dataGridView1.Rows[i].Cells[9].Value.ToString() + "</akb063>" + "<akc194>" + DateTime.Parse(dataGridView1.Rows[i].Cells[10].Value.ToString()).ToString("yyyyMMdd") + "</akc194>" + "<akc050>" + dataGridView1.Rows[i].Cells[11].Value.ToString() + "</akc050>" + "<akc185>" + dataGridView1.Rows[i].Cells[12].Value.ToString() + "</akc185>" + "<akc264>" + dataGridView1.Rows[i].Cells[13].Value.ToString() + "</akc264>" + "<akb068>" + dataGridView1.Rows[i].Cells[14].Value.ToString() + "</akb068>" + "<ykc630>" + dataGridView1.Rows[i].Cells[15].Value.ToString() + "</ykc630>" + "<aka130>" + dataGridView1.Rows[i].Cells[16].Value.ToString() + "</aka130>" + "<aae140>" + dataGridView1.Rows[i].Cells[17].Value.ToString() + "</aae140>" + "<akc190>" + dataGridView1.Rows[i].Cells[18].Value.ToString() + "</akc190>" + "<yzz139>" + dataGridView1.Rows[i].Cells[19].Value.ToString() + "</yzz139>" + "<aae013>" + dataGridView1.Rows[i].Cells[20].Value.ToString() + "</aae013>" + "</row>"; } Str_xml = Str_xml + "</detail></input>"; string resultxml = qj.cscf("0521", Str_xml); // MessageBox.Show(resultxml); if (resultxml == "") { return; } XmlDocument doc = new XmlDocument(); doc.LoadXml(resultxml); XmlNode list = doc.SelectSingleNode("//result"); int error = int.Parse(list.SelectSingleNode("errorcode").InnerText); if (error < 0) { string errormsg = list.SelectSingleNode("errormsg").InnerText; MessageBox.Show("错误信息为:" + errormsg); } else { string sign = list.SelectSingleNode("sign").InnerText; string transid = list.SelectSingleNode("transid").InnerText; string errorcode = list.SelectSingleNode("errorcode").InnerText; string errormsg = list.SelectSingleNode("errormsg").InnerText; string yzz060 = dateTimePicker1.Value.ToString("yyyy"); string yzz061 = dateTimePicker1.Value.ToString("MM"); // string yzz062 = dateTimePicker1.Value.Year.ToString(); string flag = "1"; string strSql = "insert into ydsb values('" + sign + "'" + ",'" + transid + "','" + errorcode + "','" + errormsg + "','" + yzz060 + "','" + yzz061 + "','" + yzz062 + "','" + flag + "','" + aae140 + "')"; ; if (db.GetSqlCmd(strSql) != 0) { MessageBox.Show("申报成功!"); } } } else if (button2.Text == "回退") { Str_xml = "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<otransid>" + dataGridView1.Rows[0].Cells[0].Value.ToString() + "</otransid>" + "<aab299>" + PublicCommon.aab299 + "</aab299>" + "<akb026>" + PublicCommon.akb026 + "</akb026>" + "<akb021>" + PublicCommon.akb021 + "</akb021>" + "<yzz060>" + dataGridView1.Rows[0].Cells[1].Value.ToString() + "</yzz060>" + "<yzz061>" + dataGridView1.Rows[0].Cells[2].Value.ToString() + "</yzz061>" + "<yzz062>" + dataGridView1.Rows[0].Cells[3].Value.ToString() + "</yzz062>" + "<aae140>" + dataGridView1.Rows[0].Cells[4].Value.ToString() + "</aae140>" + "</input>"; string resultxml = qj.cscf("0522", Str_xml); if (resultxml == "") { return; } // MessageBox.Show(resultxml); XmlDocument doc = new XmlDocument(); doc.LoadXml(resultxml); XmlNode list = doc.SelectSingleNode("//result"); int error = int.Parse(list.SelectSingleNode("errorcode").InnerText); if (error < 0) { string errormsg = list.SelectSingleNode("errormsg").InnerText; MessageBox.Show("错误信息为:" + errormsg); } else { strSql = "update ydsb set flag=0 where transid='" + dataGridView1.Rows[0].Cells[0].Value.ToString() + "'"; if (db.GetSqlCmd(strSql) != 0) { MessageBox.Show("回退成功!"); } } } }
public void SCXml(List <fymx> fx) { string xml = "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<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>" + "<detail>"; foreach (var f in fx) { xml += "<row>"; var pros = f.GetType().GetProperties(); foreach (var p in pros) { xml += "<" + p.Name + ">" + p.GetValue(f, null) + "</" + p.Name + ">"; } xml += "</row>"; } xml += "</detail></input>"; string resultxml = qj.cscf("0301", xml); 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 errormsg = res.SelectSingleNode("errormsg").InnerText; string sign = res.SelectSingleNode("sign").InnerText; string transid = res.SelectSingleNode("transid").InnerText; string insql = "INSERT INTO [ydjs_zyy].[dbo].[fymxjl] ([sign],[transid],[errorcode],[errormsg],[aac044],[aae011],[id])" + "VALUES ('" + sign + "','" + transid + "','" + error + "','" + errormsg + "','" + gx.aac044 + "','" + aae011 + "'," + str_id + ")"; DBConn db = new DBConn(); int i = db.GetSqlCmd(insql); if (i > 0) { MessageBox.Show("费用明细录入成功"); qj.gxStatus(2, gx.aac044, str_id); button1.Text = "费用明细回退"; } } }
private void button1_Click(object sender, EventArgs e) { try { if (button1.Text == "费用明细回退") { DBConn db = new DBConn(); string sql = "select * from fymxjl where aac044 = '" + gx.aac044 + "' and id='" + str_id + "'"; DataTable dt = db.GetDataSet(sql).Tables[0]; string otransid = dt.Rows[0]["transid"].ToString(); DialogResult dr = MessageBox.Show("是否回退费用明细?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { string resultxml = qj.cscf("0302", "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<otransid>0</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>" + "<ykc610></ykc610>" + "<aae011>" + gx.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 fymxjl where aac044 = '" + gx.aac044 + "' and id = " + str_id; db.GetSqlCmd(sql1); MessageBox.Show("身份证为:" + gx.aac044 + " 的病人是费用明细回退成功"); qj.gxStatus(1, gx.aac044, str_id); button1.Text = "费用明细上传"; } } return; } List <fymx> fx = fl.fyls; if (fx.Count > 500) { int j = 500; for (int i = 0; i < fx.Count / 500 + 1; i++) { List <fymx> cList = new List <fymx>(); cList = fx.Take(j).Skip(i * 500).ToList(); j += 500; SCXml(cList); } } else { SCXml(fx); } } catch (Exception ex) { if (ex.Message == "操作超时") { DialogResult dr1 = MessageBox.Show(ex.Message + "。是否超时重发?", "提示", MessageBoxButtons.YesNo); if (dr1 == DialogResult.Yes) { button1_Click(sender, e); } } else { MessageBox.Show(ex.Message); } } }
//就诊登记 public void djjzdj() { string ryks = ""; var lryks = (from r in qj.akf001 where r.Value == txtakf001.Text.Trim() select r.Key).ToList <string>(); if (lryks.Count > 0) { ryks = lryks[0]; } string ryyy = (from r in qj.ykc679 where r.Value == comykc679.SelectedItem.ToString() select r.Key).ToList <string>()[0]; string bzlx = (from r in qj.ykc680 where r.Value == comykc680.SelectedItem.ToString() select r.Key).ToList <string>()[0]; string resultxml = qj.cscf("0212", "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<aab299>" + PublicCommon.aab299 + "</aab299>" + "<yab600>" + PublicCommon.yab600 + "</yab600>" + "<akb026>" + PublicCommon.akb026 + "</akb026>" + "<akb021>" + PublicCommon.akb021 + "</akb021>" + "<aab301>" + s.aab301 + "</aab301>" + "<yab060>" + s.yab060 + "</yab060>" + "<aac002>" + s.aac002 + "</aac002>" + "<aac043>" + s.aac043 + "</aac043>" + "<aac044>" + s.aac044 + "</aac044>" + "<aka130>" + s.aka130 + "</aka130>" + "<ykc009>" + txtykc009.Text.Trim() + "</ykc009>" + "<akc190>" + txtakc190.Text.Trim() + "</akc190>" + "<akf001>" + ryks + "</akf001>" + "<yzz018>" + txtyzz018.Text.Trim() + "</yzz018>" + "<yzz019>" + txtyzz019.Text.Trim() + "</yzz019>" + "<ykc012>" + txtykc012.Text.Trim() + "</ykc012>" + "<akc050>" + txtakc050.Text.Trim() + "</akc050>" + "<ykc679>" + ryyy + "</ykc679>" + "<ykc680>" + bzlx + "</ykc680>" + "<akc193>" + txtakc193.Text.Trim() + "</akc193>" + "<ykc601>" + txtykc601.Text.Trim() + "</ykc601>" + "<ykc602>" + txtykc602.Text.Trim() + "</ykc602>" + "<akc056>" + txtakc056.Text.Trim() + "</akc056>" + "<ake022>" + txtake022.Text.Trim() + "</ake022>" + "<ykc701>" + dtpykc701.Text.Trim() + "</ykc701>" + "<aae011>" + txtaae011.Text.Trim() + "</aae011>" + "<aae036>" + txtaae036.Text.Trim() + "</aae036>" + "<aae004>" + txtaae004.Text.Trim() + "</aae004>" + "<aae005>" + txtaae005.Text.Trim() + "</aae005>" + "<aae013>" + txtaae013.Text.Trim() + "</aae013>" + "</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 ykc700 = res.SelectSingleNode("output").SelectSingleNode("ykc700").InnerText; string transid = res.SelectSingleNode("transid").InnerText; //FileStream fs = new FileStream("D://ak.txt", FileMode.Create); //StreamWriter sw = new StreamWriter(fs); ////开始写入 //sw.Write(ykc700); ////清空缓冲区 //sw.Flush(); ////关闭流 //sw.Close(); //fs.Close(); string gxsql = "INSERT INTO [ydjs_zyy].[dbo].[gxjzdj]([sign],[transid],[aab299],[yab600],[akb026],[akb021],[aab301],[ykc700],[yab060],[aac002]," + "[aac043],[aac044],[aka130],[ykc009],[akc190],[akf001],[yzz018],[yzz019],[ykc012],[akc050],[ykc679],[ykc680]," + "[akc193],[ykc601],[ykc602],[akc056],[ake022],[ykc701],[aae011],[aae036],[aae004],[aae005],[aae013],[id])" + "VALUES('" + s.sign + "','" + transid + "','" + PublicCommon.aab299 + "','" + PublicCommon.yab600 + "','" + PublicCommon.akb026 + "','" + PublicCommon.akb021 + "','" + s.aab301 + "','" + ykc700 + "'," + "'" + s.yab060 + "','" + s.aac002 + "','" + s.aac043 + "','" + s.aac044 + "','" + s.aka130 + "','" + txtykc009.Text.Trim() + "'," + "'" + txtakc190.Text.Trim() + "','" + ryks + "','" + txtyzz018.Text.Trim() + "','" + txtyzz019.Text.Trim() + "'," + "'" + txtykc012.Text.Trim() + "','" + txtakc050.Text.Trim() + "','" + ryyy + "','" + bzlx + "'," + "'" + txtakc193.Text.Trim() + "','" + txtykc601.Text.Trim() + "','" + txtykc602.Text.Trim() + "','" + txtakc056.Text.Trim() + "'," + "'" + txtake022.Text.Trim() + "','" + dtpykc701.Text.Trim() + "','" + txtaae011.Text.Trim() + "','" + txtaae036.Text.Trim() + "'," + "'" + txtaae004.Text.Trim() + "','" + txtaae005.Text.Trim() + "','" + txtaae013.Text.Trim() + "'," + str_id + ")"; DBConn db = new DBConn(); int re = db.GetSqlCmd(gxsql); string result = ""; if (re > 0) { result += "就诊登记已经记录"; } fhjzdj fj = new fhjzdj(); var pors = fj.GetType().GetProperties(); XmlNode op = res.SelectSingleNode("output"); for (int i = 0; i < pors.Length; i++) { if (pors[i].Name == "sign" || pors[i].Name == "transid" || pors[i].Name == "errorcode" || pors[i].Name == "errormsg") { pors[i].SetValue(fj, res.SelectSingleNode(pors[i].Name).InnerText, null); } else { pors[i].SetValue(fj, op.SelectSingleNode(pors[i].Name).InnerText, null); } } string sql = qj.getSql(fj, fj.GetType().Name, str_id, null); int f = db.GetSqlCmd(sql); if (f > 0) { result = "操作成功!"; qj.gxStatus(1, s.aac044, str_id); } MessageBox.Show(result); gxinit(); } }
//更新就诊登记 public void gxjzdj() { string ryks = ""; var lryks = (from r in qj.akf001 where r.Value == txtakf001.Text.Trim() select r.Key).ToList <string>(); if (lryks.Count > 0) { ryks = lryks[0]; } string ryyy = (from r in qj.ykc679 where r.Value == comykc679.SelectedItem.ToString() select r.Key).ToList <string>()[0]; string bzlx = (from r in qj.ykc680 where r.Value == comykc680.SelectedItem.ToString() select r.Key).ToList <string>()[0]; string resultxml = qj.cscf("0213", "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<aab299>" + PublicCommon.aab299 + "</aab299>" + "<yab600>" + PublicCommon.yab600 + "</yab600>" + "<akb026>" + PublicCommon.akb026 + "</akb026>" + "<akb021>" + PublicCommon.akb021 + "</akb021>" + "<aab301>" + s.aab301 + "</aab301>" + "<ykc700>" + txtykc700.Text.Trim() + "</ykc700>" + "<yab060>" + s.yab060 + "</yab060>" + "<aac002>" + s.aac002 + "</aac002>" + "<aac043>" + s.aac043 + "</aac043>" + "<aac044>" + s.aac044 + "</aac044>" + "<aka130>" + s.aka130 + "</aka130>" + "<akc190>" + txtakc190.Text.Trim() + "</akc190>" + "<akf001>" + ryks + "</akf001>" + "<yzz018>" + txtyzz018.Text.Trim() + "</yzz018>" + "<yzz019>" + txtyzz019.Text.Trim() + "</yzz019>" + "<ykc012>" + txtykc012.Text.Trim() + "</ykc012>" + "<akc050>" + txtakc050.Text.Trim() + "</akc050>" + "<ykc679>" + ryyy + "</ykc679>" + "<ykc680>" + bzlx + "</ykc680>" + "<akc193>" + txtakc193.Text.Trim() + "</akc193>" + "<ykc601>" + txtykc601.Text.Trim() + "</ykc601>" + "<ykc602>" + txtykc602.Text.Trim() + "</ykc602>" + "<akc056>" + txtakc056.Text.Trim() + "</akc056>" + "<ake022>" + txtake022.Text.Trim() + "</ake022>" + "<ykc701>" + dtpykc701.Text.Trim() + "</ykc701>" + "<aae011>" + txtaae011.Text.Trim() + "</aae011>" + "<aae036>" + txtaae036.Text.Trim() + "</aae036>" + "<aae004>" + txtaae004.Text.Trim() + "</aae004>" + "<aae005>" + txtaae005.Text.Trim() + "</aae005>" + "<aae013>" + txtaae013.Text.Trim() + "</aae013>" + "</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 transid = res.SelectSingleNode("transid").InnerText; DBConn db = new DBConn(); string gxsql = "INSERT INTO [ydjs_zyy].[dbo].[gxjzdj]([sign],[transid],[aab299],[yab600],[akb026],[akb021],[aab301],[ykc700],[yab060],[aac002]," + "[aac043],[aac044],[aka130],[ykc009],[akc190],[akf001],[yzz018],[yzz019],[ykc012],[akc050],[ykc679],[ykc680]," + "[akc193],[ykc601],[ykc602],[akc056],[ake022],[ykc701],[aae011],[aae036],[aae004],[aae005],[aae013],[id])" + "VALUES('" + s.sign + "','" + transid + "','440800','440825','4400001159975','湛江市赤坎区中医医院','" + s.aab301 + "','" + txtykc700.Text.Trim() + "'," + "'" + s.yab060 + "','" + s.aac002 + "','" + s.aac043 + "','" + s.aac044 + "','" + s.aka130 + "','" + txtykc009.Text.Trim() + "'," + "'" + txtakc190.Text.Trim() + "','" + ryks + "','" + txtyzz018.Text.Trim() + "','" + txtyzz019.Text.Trim() + "'," + "'" + txtykc012.Text.Trim() + "','" + txtakc050.Text.Trim() + "','" + ryyy + "','" + bzlx + "'," + "'" + txtakc193.Text.Trim() + "','" + txtykc601.Text.Trim() + "','" + txtykc602.Text.Trim() + "','" + txtakc056.Text.Trim() + "'," + "'" + txtake022.Text.Trim() + "','" + dtpykc701.Text.Trim() + "','" + txtaae011.Text.Trim() + "','" + txtaae036.Text.Trim() + "'," + "'" + txtaae004.Text.Trim() + "','" + txtaae005.Text.Trim() + "','" + txtaae013.Text.Trim() + "'," + str_id + ")"; string sql = "DELETE FROM [gxjzdj] WHERE aac044 = '" + s.aac044 + "' AND id=" + str_id; db.GetSqlCmd(sql); int f = db.GetSqlCmd(gxsql); if (f > 0) { MessageBox.Show("更新就诊登记成功"); } } }
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(); } } }
public void cydj() { string cyks = ""; var lryks = (from r in qj.akf002 where r.Value == txtakf002.Text.Trim() select r.Key).ToList <string>(); if (lryks.Count > 0) { cyks = lryks[0]; } string cyyy = (from r in qj.ykc195 where r.Value == comykc195.SelectedItem.ToString() select r.Key).ToList <string>()[0]; string xml = "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<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>" + "<akf002>" + cyks + "</akf002>" + "<yzz088>" + txtyzz088.Text.Trim() + "</yzz088>" + "<yzz089>" + txtyzz089.Text.Trim() + "</yzz089>" + "<ykc016>" + txtykc016.Text.Trim() + "</ykc016>" + "<akc185>" + txtakc185.Text.Trim() + "</akc185>" + "<akc196>" + txtakc196.Text.Trim() + "</akc196>" + "<akc188>" + txtakc188.Text.Trim() + "</akc188>" + "<akc189>" + txtakc189.Text.Trim() + "</akc189>" + "<akc056>" + txtakc056.Text.Trim() + "</akc056>" + "<ake021>" + txtake021.Text.Trim() + "</ake021>" + "<ykc195>" + cyyy + "</ykc195>" + "<ykc683>" + txtykc683.Text.Trim() + "</ykc683>" + "<ykc702>" + dtpykc702.Text.Trim() + "</ykc702>" + "<akb063>" + txtakb063.Text.Trim() + "</akb063>" + "<yzz020>" + txtyzz020.Text.Trim() + "</yzz020>" + "<aae011>" + txtaae011.Text.Trim() + "</aae011>" + "<ykc018>" + dtpykc018.Text.Trim() + "</ykc018>" + "</input>"; string resultxml = qj.cscf("0215", xml); 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 errormsg = res.SelectSingleNode("errormsg").InnerText; string sign = res.SelectSingleNode("sign").InnerText; string transid = res.SelectSingleNode("transid").InnerText; cydj cy = new cydj(); var pros = cy.GetType().GetProperties(); XmlDocument ixd = new XmlDocument(); ixd.LoadXml(xml); XmlNode ipt = ixd.SelectSingleNode("//input"); for (int i = 0; i < pros.Length; i++) { if (pros[i].Name == "sign" || pros[i].Name == "transid") { continue; } pros[i].SetValue(cy, ipt.SelectSingleNode(pros[i].Name).InnerText, null); } cy.transid = transid; cy.sign = sign; string sql = qj.getSql(cy, "cydj", str_id, null); DBConn db = new DBConn(); db.GetSqlCmd(sql); MessageBox.Show("出院登记操作成功"); qj.gxStatus(3, s.aac044, str_id); } }