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