//出院登记回退
public void cydjht()
{
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 otransid = "4408001905061000101490";
string aae011 = dt.Rows[0]["aae011"].ToString();
//string aae011 = "l";
DialogResult dr = MessageBox.Show("该病号已做出院登记，是否回退？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
string resultxml = qj.cscf("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
{
qj.dHuitui("cydj", s.aac044, str_id);
MessageBox.Show("身份证为：" + s.aac044 + " 的病人出院登记回退成功");
qj.gxStatus(2, s.aac044, str_id);
}
}
}
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 + " 的病人出院登记回退成功");
}
}
}
//新增身份识别
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("身份验证已存在");
}
}
public void init()
{
DBConn db = new DBConn();
string sql1 = "select * from cydj where aac044 = '" + s.aac044 + "' and id = " + str_id;
DataTable dt1 = db.GetDataSet(sql1).Tables[0];
foreach (var y in qj.ykc195)
{
comykc195.Items.Add(y.Value);
}
var bm = new AutoCompleteStringCollection();
bm.AddRange(qj.icd.Keys.ToArray <string>());
txtakc196.AutoCompleteCustomSource = bm;
txtakc196.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtakc196.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtakc189.AutoCompleteCustomSource = bm;
txtakc189.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtakc189.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtakc188.AutoCompleteCustomSource = bm;
txtakc188.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtakc188.AutoCompleteSource = AutoCompleteSource.CustomSource;
var jb = new AutoCompleteStringCollection();
jb.AddRange(qj.icd.Values.ToArray <string>());
txtakc185.AutoCompleteCustomSource = jb;
txtakc185.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtakc185.AutoCompleteSource = AutoCompleteSource.CustomSource;
var ks = new AutoCompleteStringCollection();
ks.AddRange(qj.akf002.Values.ToArray <string>());
txtakf002.AutoCompleteCustomSource = ks;
txtakf002.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtakf002.AutoCompleteSource = AutoCompleteSource.CustomSource;
if (dt1.Rows.Count > 0)
{
button1.Text = "出院登记回退"; return;
}
txtaac002.Text = s.aac002;
txtaac043.Text = (from a in qj.aac043 where a.Key == s.aac043 select a.Value).ToList <string>()[0];
txtaac044.Text = s.aac044;
comykc195.SelectedIndex = 0;
}
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();
}
}
}
public void init()
{
DBConn db = new DBConn();
string sql = "select * from gxjzdj where aac044 = '" + s.aac044 + "' and id=" + str_id;
DataTable dt = db.GetDataSet(sql).Tables[0];
gx = new gxjzdj();
var pros = gx.GetType().GetProperties();
foreach (var p in pros)
{
p.SetValue(gx, dt.Rows[0][p.Name].ToString(), null);
}
}
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 = "";
}
public void sfyz()
{
string sql = "select * from sfsb where aac044 = '" + aac044 + "' and id=" + str_id;
DBConn db = new DBConn();
DataSet ds = db.GetDataSet(sql);
DataTable dt = ds.Tables[0];
s = new Sfyz();
var fss = s.GetType().GetProperties();
foreach (var f in fss)
{
f.SetValue(s, dt.Rows[0][f.Name].ToString(), null);
}
Addkj(s);
}
// 参数1 身份证 ，，，参数2 类的名称
public Form9(string aac044, string leiming, string str_id)
{
InitializeComponent();
this.aac044 = aac044;
Type type = Type.GetType(leiming);
dynamic obj = type.Assembly.CreateInstance(leiming);
var pros = type.GetProperties();
string sql = "select * from " + type.Name + " where aac044 = '" + aac044 + "' and id =" + str_id;
DBConn con = new DBConn();
DataTable dt = con.GetDataSet(sql).Tables[0];
for (int i = 0; i < pros.Length; i++)
{
pros[i].SetValue(obj, dt.Rows[0][pros[i].Name].ToString(), null);
}
Addkj(obj);
}
public FrmTab(string aac044, Form3 frm, string id)
{
str_id = id;
this.frm = frm;
this.aac044 = aac044;
InitializeComponent();
string sql = "select * from sfsb where id='" + str_id + "'and aac044 = '" + aac044 + "'";
DBConn db = new DBConn();
DataSet ds = db.GetDataSet(sql);
DataTable dt = ds.Tables[0];
sf = new Sfyz();
var fss = sf.GetType().GetProperties();
foreach (var f in fss)
{
f.SetValue(sf, dt.Rows[0][f.Name].ToString(), null);
}
}
private void Form7_Load(object sender, EventArgs e)
{
string cysql = "select * from cydj where aac044 = '" + s.aac044 + "' and id = " + str_id;
DBConn db = new DBConn();
DataTable dt = db.GetDataSet(cysql).Tables[0];
if (dt.Rows.Count < 1)
{
return;
}
cydj c = new cydj();
var pros = c.GetType().GetProperties();
foreach (var p in pros)
{
p.SetValue(c, dt.Rows[0][p.Name].ToString(), null);
}
groupBox1 = (GroupBox)qj.kjdq(groupBox1, c);
}
//更新就诊登记初始化
public void gxinit()
{
DBConn db = new DBConn();
string sql = "select * from gxjzdj where aac044 = '" + s.aac044 + "' and id = " + str_id;
DataTable dt = db.GetDataSet(sql).Tables[0];
init();
if (dt.Rows.Count == 0)
{
button5.Visible = false;
button6.Visible = false;
label37.Visible = false;
label38.Visible = false;
txttransid.Visible = false;
txtykc700.Visible = false;
button1.Text = "提交就诊登记";
return;
}
button5.Visible = true;
button6.Visible = true;
label37.Visible = true;
label38.Visible = true;
txttransid.Visible = true;
txtykc700.Visible = true;
button1.Text = "更新就诊登记";
gj = new gxjzdj();
var pros = gj.GetType().GetProperties();
foreach (var p in pros)
{
p.SetValue(gj, dt.Rows[0][p.Name].ToString(), null);
}
panel1 = (Panel)qj.kjdq(this.panel1, gj);
}
//身份识别列表查询
public void sfsbcx()
{
string sql = "select s.id as id,s.transid as '交易流水号', s.aac003 as '姓名',s.aac044 as '证件号码',s.aac002 as '社会保障卡' ,s.aac043 as '证件类型',s.status as '状态' from sfsb s";
DBConn conn = new DBConn();
DataSet ds = conn.GetDataSet(sql);
dt = ds.Tables[0];
DataTable ztdt = dt.Clone();
ztdt.Columns["状态"].DataType = typeof(string);
foreach (DataRow d in dt.Rows)
{
DataRow rowNew = ztdt.NewRow();
rowNew["id"] = d["id"];
rowNew["交易流水号"] = d["交易流水号"];
//修改记录值
rowNew["姓名"] = d["姓名"];
rowNew["证件号码"] = d["证件号码"];
rowNew["社会保障卡"] = d["社会保障卡"];
rowNew["证件类型"] = d["证件类型"];
rowNew["状态"] = d["状态"];
ztdt.Rows.Add(rowNew);
}
foreach (DataRow d in ztdt.Rows)
{
foreach (var q in qj.status)
{
if (q.Key == d["状态"].ToString())
{
d["状态"] = q.Value;
}
}
}
dataGridView1.DataSource = ztdt;
}
/// <summary>
/// 通用按钮点击选项卡 在选项卡上显示对应的窗体
/// </summary>
private void btnX_Click(object sender, EventArgs e)
{
string formClass = ((TabControl)sender).SelectedTab.Tag.ToString();
//string form = tabControl1.SelectedTab.Tag.ToString();
Form fm = null;
DBConn db = null;
DataTable dt = null;
string sql = "";
switch (formClass)
{
case "Form5": //身份验证信息
fm = new Form5(aac044, frm, str_id);
break;
case "Form6": //就诊登记
fm = new Form6(sf, str_id);
break;
case "Form10": //费用明细录入
db = new DBConn();
sql = "select * from gxjzdj where aac044 = '" + sf.aac044 + "'and id =" + str_id;
dt = db.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
gxjzdj gx = new gxjzdj();
var pros = gx.GetType().GetProperties();
foreach (var p in pros)
{
p.SetValue(gx, dt.Rows[0][p.Name].ToString(), null);
}
fm = new Form10(gx, str_id);
}
break;
case "Form7": //出院登记
DBConn con = new DBConn();
sql = "select * from fymxjl where aac044 = '" + sf.aac044 + "' and id = " + str_id;
dt = con.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
sql = "select * from fhjzdj where aac044 = '" + sf.aac044 + "' and id = " + str_id;
dt = con.GetDataSet(sql).Tables[0];
string ykc700 = dt.Rows[0]["ykc700"].ToString();
fm = new Form7(sf, ykc700, str_id);
}
break;
case "Form12": //模拟结算
db = new DBConn();
sql = "select * from cydj where aac044 = '" + sf.aac044 + "' and id = " + str_id;
dt = db.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
fm = new Form12(this.sf, str_id);
}
break;
case "Form14": //费用结算
db = new DBConn();
sql = "select * from cydj where aac044 = '" + sf.aac044 + "' and id = " + str_id;
dt = db.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
fm = new Form14(sf, str_id);;;
}
break;
case "Form15":
db = new DBConn();
sql = "select * from gxjzdj where aac044 = '" + sf.aac044 + "' and id = " + str_id;
dt = db.GetDataSet(sql).Tables[0];
if (dt.Rows.Count > 0)
{
gxjzdj gx = new gxjzdj();
var pros = gx.GetType().GetProperties();
foreach (var p in pros)
{
p.SetValue(gx, dt.Rows[0][p.Name].ToString(), null);
}
fm = new Form15(gx, str_id);
}
break;
default:
break;
}
if (fm == null)
{
int zt = int.Parse(qj.getGxStatus(aac044, str_id));
foreach (var q in qj.status)
{
if (int.Parse(q.Key) == zt + 1)
{
((TabControl)sender).SelectedTab.Controls.Clear();
MessageBox.Show("请先完成：" + q.Value);
return;
}
}
}
((TabControl)sender).SelectedTab.Controls.Clear();
fm.FormBorderStyle = FormBorderStyle.None;
fm.TopLevel = false;
fm.Parent = ((TabControl)sender).SelectedTab;
fm.ControlBox = false;
fm.Dock = DockStyle.Fill;
fm.Anchor = AnchorStyles.None;
fm.Show();
//s[((TabControl)sender).SelectedIndex] = 1;
}
public void init()
{
textBox1.Text = zyhm;
fl = new fymxlr();
hisDBConn hdb = new hisDBConn();
string zyhsql = "select zyh from ZY_BRRY where ZYHM = '" + zyhm.Trim() + "'";
DataTable dt = hdb.GetDataSet(zyhsql).Tables[0];
if (dt.Rows.Count < 1)
{
MessageBox.Show("查询不到该病号的费用明细");
return;
}
zyh = dt.Rows[0]["zyh"].ToString();
string fymxsql = " SELECT f.yzxh as 'akc220',f.rowid as 'ykc610', s.SFXM as 'yka111',s.SFMC as 'yka112',"
+ "( case when fyxm = 2 or fyxm = 3 or fyxm = 4 or fyxm = 21 or fyxm = 22 or fyxm = 23 or fyxm = 24 then case when f.yplx = 1 or f.yplx = 3 or f.yplx = 0 or f.yplx = 2"
+ "then(select distinct ISNULL( ybdm,sbdm) from yk_typk where yk_typk.ypxh = f.fyxh) end ELSE(select distinct ISNULL( ybdm,sbdm) from gy_ylsf where gy_ylsf.fyxh"
+ "= f.fyxh ) END) as 'ake001', "
+ "( case when fyxm = 2 or fyxm = 3 or fyxm = 4 or fyxm = 21 or fyxm = 22 or fyxm = 23 or fyxm = 24 then case when f.yplx = 1 or f.yplx = 3 or f.yplx = 0 or f.yplx = 2"
+ "then(select distinct fymc from yk_typk where yk_typk.ypxh = f.fyxh) end ELSE(select distinct fymc from gy_ylsf where gy_ylsf.fyxh"
+ "= f.fyxh) END) as 'ake002',"
+ "( case when fyxm = 2 or fyxm = 3 or fyxm = 4 or fyxm = 21 or fyxm = 22 or fyxm = 23 or fyxm = 24 then case when f.yplx = 1 or f.yplx = 3 or f.yplx = 0 or f.yplx = 2"
+ " then(select MESS from yk_typk where yk_typk.ypxh = f.fyxh) end ELSE('') END) as 'mess' ,"
+ "'' as 'ake114','0' as 'aka185','' as 'yke230','' as 'yke231',"
+ "( case when fyxm = 2 or fyxm = 3 or fyxm = 4 or fyxm = 21 or fyxm = 22 or fyxm = 23 or fyxm = 24 then case when f.yplx = 1 or f.yplx = 3 or f.yplx = 0 or f.yplx = 2"
+ "then(select distinct sbdm from yk_typk where yk_typk.ypxh = f.fyxh) end ELSE(select distinct sbdm from gy_ylsf where gy_ylsf.fyxh"
+ "= f.fyxh) END) as 'ake005',f.FYMC as 'ake006' , f.FYSL as 'akc226',f.FYDJ as 'akc225', f.ZJJE as 'akc264',yc.CDMC as 'ykc611', '' as 'ykc615','' as 'aka074',"
+ " '' as 'aka067' , '' as 'aka070','' as 'akc056','' as 'akc273' ,k.KSMC as 'aae386' ,CONVERT(varchar(12) , f.fyrq, 112 ) as 'akc221','" + aae011 + "' as 'aae011','' as 'aae036'"
+ " FROM ZY_FYMX f join GY_SFXM s on s.SFXM = f.FYXM left join YK_CDDZ yc on yc.YPCD = f.YPCD join GY_KSDM k on k.KSDM = f.FYKS WHERE 1 = 1 AND(f.ZYH = '" + zyh + "') ";
mxdt = hdb.GetDataSet(fymxsql).Tables[0];
Form2 frm = new Form2(this);
string path = System.AppDomain.CurrentDomain.BaseDirectory + "//dlwh.xml";
frm.ReadXml(path);
List <string> mesls = new List <string>();
foreach (DataRow r in mxdt.Rows)
{
if (r["mess"].ToString() != "" && r["mess"] != null)
{
mesls.Add(r["ykc610"].ToString());
}
foreach (var v in qj.dlwh)
{
if (v.odlmc == r["yka112"].ToString())
{
if (v.dlmc != "-")
{
r["yka111"] = (from y in qj.yka111 where y.Value == v.dlmc select y.Key).ToList <string>()[0];
r["yka112"] = v.dlmc;
}
}
}
fymx fy = new fymx();
var pros = fy.GetType().GetProperties();
foreach (var p in pros)
{
if (p.Name == "yka111")
{
if (r[p.Name].ToString().Length < 2)
{
p.SetValue(fy, "0" + r[p.Name].ToString().Trim(), null);
continue;
}
}
if (p.Name == "aae036")
{
p.SetValue(fy, DateTime.Now.ToString("yyyyMMdd"), null);
continue;
}
p.SetValue(fy, r[p.Name].ToString().Trim(), null);
}
fl.fyls.Add(fy);
}
dataGridView1.DataSource = mxdt;
DBConn db = new DBConn();
string fyczsql = "select * from fymxjl where aac044 = '" + gx.aac044 + "'and id = " + str_id;
DataTable dt2 = db.GetDataSet(fyczsql).Tables[0];
if (dt2.Rows.Count != 0)
{
button1.Text = "费用明细回退"; return;
}
else
{
List <DataRow> lsd = new List <DataRow>();
foreach (var l in mesls)
{
DataRow d = mxdt.Select("ykc610 = " + l + "")[0];
DialogResult dr = MessageBox.Show(d["ake006"].ToString() + ",该药品为（" + d["mess"].ToString() + "）使用药品！是[可报销]，否[自费]?", "提示：医保限制用药", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
d["aka185"] = "1";
}
}
}
}
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();
}
}
}
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);
}
}
}
