private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
//string strZXName = dataGridView1.["医保项目名称"].Value.ToString();
try
{
DataGridViewRow dgrZX = this.dataGridView1.Rows[this.dataGridView1.CurrentRow.Index];
string autoID = dgrZX.Cells["AUTO_ID"].Value.ToString();
string strZXName = dgrZX.Cells["医院项目名称"].Value.ToString();
string strZXCode = dgrZX.Cells["医保项目编码"].Value.ToString();
string strhiscode = dgrZX.Cells["HIS_ITEM_CODE"].Value.ToString();
if (e.ColumnIndex == 2 || e.ColumnIndex == 1)
{
if (e.ColumnIndex == 2)
{
StringBuilder strip = new StringBuilder();
strip.Append("update COMM.COMM.NETWORKING_ITEM_VS_HIS set NETWORK_ITEM_CODE='" + strZXCode + "' where HIS_ITEM_CODE='" + strhiscode + "' and AUTO_ID='" + autoID + "'");
SQLHelper.ExecSqlReInt(strip.ToString());
gb();
frmTip ti = new frmTip();
ti.ShowDialog();
}
if (e.ColumnIndex == 1)
{
StringBuilder strip = new StringBuilder();
strip.Append("update COMM.COMM.NETWORKING_ITEM_VS_HIS set HIS_ITEM_NAME='" + strZXName + "' where HIS_ITEM_CODE='" + strhiscode + "' and AUTO_ID='" + autoID + "'");
SQLHelper.ExecSqlReInt(strip.ToString());
gb();
frmTip ti = new frmTip();
ti.ShowDialog();
}
return;
}
else
{
MessageBox.Show("只可修改医院项目名称或医保项目编码！其他修改无效");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
Environment.Exit(0);
throw ex;
}
finally
{
gb();
}
}
private void button2_Click(object sender, EventArgs e)
{
DataGridViewRow dgrHis = this.dgv_his.Rows[this.dgv_his.CurrentRow.Index];
string strHisNAME = dgrHis.Cells["HIS_ITEM_NAME"].Value.ToString();
string STRHISCODE = dgrHis.Cells["HIS_ITEM_CODE"].Value.ToString();
string strnetworkCode = dgrHis.Cells["NETWORK_ITEM_CODE"].Value.ToString();
StringBuilder Sqlstring = new StringBuilder();
/// Sqlstring.Append(" DELETE FROM COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE AUTO_ID='" + strHisID + "' AND NETWORKING_PAT_CLASS_ID='3 ' AND HIS_ITEM_CODE='" + STRHISCODE + "' AND ");
//Sqlstring.Append(" SELECT * FROM COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE NETWORKING_PAT_CLASS_ID='3 ' AND HIS_ITEM_CODE='" + STRHISCODE + "' AND NETWORK_ITEM_CODE='" + strnetworkCode + "' AND HIS_ITEM_NAME='" + strHisNAME + "'");
////Sqlstring.Append(" SELECT * FROM COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE NETWORKING_PAT_CLASS_ID='3 ' AND HIS_ITEM_CODE='" + STRHISCODE + "' AND NETWORK_ITEM_CODE=" + strnetworkCode);
//DataSet dt = SQLHelper.ExecSqlReDs(Sqlstring.ToString());
Sqlstring.Append(" DELETE FROM COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE NETWORKING_PAT_CLASS_ID='3 ' AND HIS_ITEM_CODE='" + STRHISCODE + "' AND NETWORK_ITEM_CODE='" + strnetworkCode + "' AND HIS_ITEM_NAME='" + strHisNAME + "'");
yjqch.Add(Sqlstring.ToString());
int Num = SQLHelper.ExecSqlReInt(Sqlstring.ToString());
if (Num > 0)
{
MessageBox.Show("取消对照成功！");
this.dgv_his.Rows.RemoveAt(this.dgv_his.CurrentRow.Index);
GX();
return;
}
}
/// <summary>
/// 修改方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
try
{
//string Zfblxg = dataGridView1.CurrentRow.Cells["自付比例"].Value.ToString();
string hisCode = Uphiscode;
string fylbxg = Updylb;
string Yxgzfbl = txtYxgzfbl.Text;
if (string.IsNullOrEmpty(hisCode) || string.IsNullOrEmpty(fylbxg) || string.IsNullOrEmpty(Yxgzfbl))
{
MessageBox.Show("未选中要修改的数据，请单击选中！");
return;
}
StringBuilder strUpdate = new StringBuilder();
strUpdate.Append("UPDATE COMM.COMM.NETWORKING_ITEM_VS_HIS SET SELF_BURDEN_RATIO='" + Yxgzfbl + "' WHERE (HOSPITAL_ID='" + hosid + "') AND NETWORKING_PAT_CLASS_ID='" + fylbxg + "' AND HIS_ITEM_CODE='" + hisCode + "' ");
int success = sqlHelper.ExecSqlReInt(strUpdate.ToString());
if (success > 0)
{
MessageBox.Show("修改成功");
}
}
catch (Exception)
{
throw new Exception("修改出错，请重新操作");
}
}
/// <summary>
/// 删除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string hiscode = Uphiscode;
string Deletefylb = Upfylb;
if (string.IsNullOrEmpty(Uphiscode) || string.IsNullOrEmpty(Upfylb))
{
MessageBox.Show("请单击选中删除的数据");
return;
}
try
{
StringBuilder strDelete = new StringBuilder();
//strDelete.Append(" DELETE FROM COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE NETWORKING_PAT_CLASS_ID='" + Deletefylb + "' AND HIS_ITEM_CODE='" + hiscode + "' ");
strDelete.Append(" DELETE FROM COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE HIS_ITEM_CODE='" + hiscode + "' and HOSPITAL_ID = '" + MainForm.HOSPITAL_ID + "'");
int deleteSuccess = sqlHelper.ExecSqlReInt(strDelete.ToString());
if (deleteSuccess > 0)
{
MessageBox.Show("删除成功");
}
}
catch (Exception ex)
{
throw new Exception("删除出错，请重新操作" + ex.ToString());
}
}
private void timer1_Tick(object sender, EventArgs e)
{
int up_num = 0;
int invalid_num = 0;
string now = DateTime.Now.ToString("HH:mm:ss");
Dictionary <string, string> result = new Dictionary <string, string>();
StringBuilder err_info = new StringBuilder();
DataTable ds_info = get_maininfo();
dgv_main.DataSource = ds_info;
progressBar1.Value = 0;
progressBar1.Visible = true;
labinfo.Visible = true;
DareWayInit();
foreach (DataRow dr in ds_info.Rows)
{
///住院初始化
ZyInit(dr["病例号"].ToString());
///病历首页初始化
zyInitCase(dr["病例号"].ToString());
//此服务在文档中没有 地维没有回复
deleteCase(dr["病例号"].ToString());//删除上传病历号
//获取诊断和手术信息的数据集合
DataTable tb_diagnosis = get_diagnosis(dr["病例号"].ToString());
DataTable tb_SURGERIES = get_SURGERIES(dr["病例号"].ToString());
if (tb_diagnosis.Rows.Count > 0)
{
upDiagnosis(tb_diagnosis);
}
if (tb_SURGERIES.Rows.Count > 0)
{
upOper(tb_SURGERIES);
}
handelModel.ClearInPara();
string s = DateTime.Parse(dr["住院日期"].ToString()).ToShortDateString();
//handelModel.SetInParaString("blh", dr["病例号"].ToString());
handelModel.SetInParaDate("zyrq", DateTime.Parse(dr["住院日期"].ToString()).ToString("yyyy-MM-dd hh:mm:ss"));
handelModel.SetInParaDate("cyrq", DateTime.Parse(dr["出院日期"].ToString()).ToString("yyyy-MM-dd hh:mm:ss"));
handelModel.SetInParaDate("qzrq", DateTime.Parse(dr["确诊日期"].ToString()).ToString("yyyy-MM-dd hh:mm:ss"));
handelModel.SetInParaString("ryks", dr["入院科室"].ToString());
handelModel.SetInParaString("cyks", dr["出院科室"].ToString());
handelModel.SetInParaString("xx", dr["血型"].ToString());
handelModel.SetInParaString("rhxx", dr["RH血型"].ToString());
handelModel.SetInParaString("lyfs", dr["离院方式"].ToString());
handelModel.SetInParaString("cyxj", dr["出院小结"].ToString());
handelModel.SetInParaString("zzysbm", dr["主治医师"].ToString());
handelModel.SetInParaString("zyysbm", dr["住院医师"].ToString());
handelModel.SetInParaString("lxr", dr["联系人"].ToString());
handelModel.SetInParaString("lxrgx", dr["联系人关系"].ToString());
handelModel.SetInParaString("lxrdh", dr["联系人电话"].ToString());
handelModel.SetInParaString("brlxdh", dr["病人电话"].ToString());
//handelModel.AddInPara("p_zrhsysbm", dr["责任护士"].ToString());
handelModel.SetInParaString("kzrysbm", dr["科室主任"].ToString());
handelModel.SetInParaString("zrysbm", dr["主任医师"].ToString());
handelModel.SetInParaString("jxysbm", dr["进修医师"].ToString());
handelModel.SetInParaString("sxysbm", dr["实习医师"].ToString());
handelModel.SetInParaString("zcyybm", dr["转出医疗机构编码"].ToString());
try
{
if (tb_diagnosis.Rows.Count > 0)
{
//上传病案首页信息
decimal iRe = handelModel.ExecService("save_case");
if (iRe != 0)
{
throw new Exception("上传病案首页失败,医保返回提示：" + handelModel.ExeFuncReStr("get_errtext", null));
}
up_num += 1;
//写入本地记录
SSS.ExecSqlReInt("INSERT INTO REPORT.dbo.lszy_basc_dw( pat_in_hos_id ,bah ,cs ,ybscrq,hos_id)VALUES('" + dr["PAT_IN_HOS_ID"].ToString() + "','" + dr["病例号"].ToString() + "','1','" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "','" + _hosId + "')");
}
else
{
err_info.Append(dr["病例号"].ToString() + "\n");
err_info.Append("没有填写医保诊断信息 不予以上传首页信息" + "\n");
invalid_num += 1;
}
labinfo.Text = (up_num + invalid_num).ToString() + "/" + ds_info.Rows.Count.ToString();
progressBar1.Value = up_num + invalid_num;
// handelModel.InitHandle();
}
catch (Exception ex)
{
err_info.Append(dr["病例号"].ToString() + "\n");
err_info.Append(ex + "\n");
invalid_num += 1;
labinfo.Text = (up_num + invalid_num).ToString() + "/" + ds_info.Rows.Count.ToString();
progressBar1.Value = up_num + invalid_num;
//handelModel.InitHandle();
//throw new Exception(ex.Message );
}
}
if (err_info.Length == 0)
{
MessageBox.Show("传送完毕!\n上传成功" + up_num + "人次\n上传失败" + invalid_num + "人次");
progressBar1.Value = 0;
progressBar1.Visible = false;
labinfo.Visible = false;
}
else
{
MessageBox.Show("传送完毕!\n上传成功" + up_num + "人次\n上传失败" + invalid_num + "人次");
err_info.Replace("在 MED_UPLOAD_INFO.Form1.timer1_Tick(Object sender, EventArgs e) 位置 e:\\郑友峰\\事后报销程序源码\\MED_UPLOAD_INFO\\MED_UPLOAD_INFO\\Form1.cs:行号 81", "");
err_info.Replace("在 IRCInterfaceHandle.ZIBO.ZBDareWayInterfaceHandle2016.Handle(String method, Boolean isCheckSuc) 位置 e:\\郑友峰\\事后报销程序源码\\MED_UPLOAD_INFO\\MED_UPLOAD_INFO\\ZBDareWayInterfaceHandle2016.cs:行号 195", "");
err_info.Replace("在 MED_UPLOAD_INFO.Form1.timer1_Tick(Object sender, EventArgs e) 位置 e:\\郑友峰\\事后报销程序源码\\MED_UPLOAD_INFO\\MED_UPLOAD_INFO\\Form1.cs:行号 86", "");
progressBar1.Value = 0;
progressBar1.Visible = false;
labinfo.Visible = false;
rtb_log.Text = err_info.ToString();
}
}
private void button1_Click(object sender, EventArgs e)
{
string strHisCode = this.tbxyyxmbm.Text.Trim();
string strHisName = this.tbxyyxmm.Text.Trim();
string strZXCode = this.tbxCenterbm.Text.Trim();
string strZXName = this.tbxcenterName.Text.Trim();
string strTypeMemoCgHIScode = "";
string crcgName = "";
// SELECT * FROM [COMM].[COMM].[NETWORKING_ITEM_VS_HIS] WHERE [HIS_ITEM_CODE]=''
StringBuilder SqlstringQc = new StringBuilder();
SqlstringQc.Append("SELECT * FROM [COMM].[COMM].[NETWORKING_ITEM_VS_HIS] WHERE HIS_ITEM_CODE='"+ strHisCode + "'");
DataSet dtc = SQLHelper.ExecSqlReDs(SqlstringQc.ToString());
if (dtc.Tables[0].Rows.Count >= 1)
{
MessageBox.Show("该编码已存在！");
return;
}
StringBuilder Sqlstring = new StringBuilder();
Sqlstring.Append("INSERT INTO COMM.COMM.NETWORKING_ITEM_VS_HIS");
Sqlstring.Append("(NETWORKING_PAT_CLASS_ID,");
Sqlstring.Append("ITEM_PROP,");
Sqlstring.Append("HIS_ITEM_CODE,");
Sqlstring.Append("HIS_ITEM_NAME,");
Sqlstring.Append("NETWORK_ITEM_CODE,");
Sqlstring.Append("NETWORK_ITEM_NAME,");
Sqlstring.Append("SELF_BURDEN_RATIO,");
Sqlstring.Append("MEMO,");
Sqlstring.Append("START_TIME,");
Sqlstring.Append("STOP_TIME,");
Sqlstring.Append("TYPE_MEMO,");
Sqlstring.Append("NETWORK_ITEM_PROP,");
Sqlstring.Append("NETWORK_ITEM_CHARGE_CLASS,");
Sqlstring.Append("HOSPITAL_ID,");
Sqlstring.Append("NETWORK_ITEM_PRICE,");
Sqlstring.Append("FLAG_DISABLED,");
Sqlstring.Append("NETWORK_ITEM_FLAG_UP");
Sqlstring.Append(")");
Sqlstring.Append("VALUES( 3,");
Sqlstring.Append(" '" + 9 + "',");
Sqlstring.Append(" '" + strHisCode + "',");
Sqlstring.Append(" '" + strHisName + "',");
if (string.IsNullOrEmpty(this.cbotype.Text) || string.IsNullOrEmpty(strHisCode) || string.IsNullOrEmpty(strHisName))
{
// strHisCode = this.cbotype.SelectedValue.ToString();
MessageBox.Show("请选择项目类型!医院项目码医院项目名必填!");
return;
}
//此处篡改中心码
if (this.cbotype.SelectedValue.ToString() == "1017-4")
{
strZXCode = "210485";
strZXName = "自费诊疗项目";
Sqlstring.Append(" '" + strZXCode + "',");
//中心名无所谓
Sqlstring.Append(" '" + strZXName + "',");
strTypeMemoCgHIScode = "1017-4";
// crcgName = "锂测定（离子选择电极法）";
}
if (this.cbotype.SelectedValue.ToString() == "30401")
{
strZXCode = "206024";
strZXName = "（新）自费一次性材料";
Sqlstring.Append(" '" + strZXCode + "',");
//中心名无所谓
Sqlstring.Append(" '" + strZXName + "',");
strTypeMemoCgHIScode = "30401";
// crcgName = "C高频手术电刀柄";
}
if (this.cbotype.SelectedValue.ToString() == "999")
{
Frmaddfalg fflag = new Frmaddfalg();
fflag.ShowDialog();
strZXCode = fflag.thzxbm;
strZXName = fflag.thzxbmc;
Sqlstring.Append(" '" + strZXCode + "',");
//中心名无所谓
Sqlstring.Append(" '" + strZXName + "',");
strTypeMemoCgHIScode = fflag.thhisbm;
}
Sqlstring.Append(" '" + 100 + "',");
Sqlstring.Append(" '审批已通过',"); //国药
Sqlstring.Append(" GETDATE(),");
Sqlstring.Append(" GETDATE(),");
Sqlstring.Append(" '" + strTypeMemoCgHIScode + "',");//此处写入篡改的编码 对应his
Sqlstring.Append(" '" + 0 + "',");
//此处写入篡改的名称
Sqlstring.Append("'" + crcgName + "',");
Sqlstring.Append(" 1,");
Sqlstring.Append(" '" + 0.0000 + "',");
Sqlstring.Append(" 1, ");
Sqlstring.Append(" 1 ");
Sqlstring.Append(" ) ");
int Num = SQLHelper.ExecSqlReInt(Sqlstring.ToString());
if (Num > 0)
{
MessageBox.Show("添加成功！");
return;
}
}
/// <summary>
/// 添加按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (cmbfylb.Text == "居民统筹")
{
fylb = "2";
}
else if (cmbfylb.Text == "居民门规")
{
fylb = "1";
}
else if (cmbfylb.Text == "普通门诊")
{
fylb = "3";
}
else if (cmbfylb.Text == "职工门规")
{
fylb = "4";
}
else if (cmbfylb.Text == "免费药品")
{
fylb = "5";
}
else if (cmbfylb.Text == "职工统筹")
{
fylb = "6";
}
string networktypeprop = "";
//if (cmbfylb.Text == "测试")
//{
// fylb = "10004";
//}
string networkchargeClass = "";
if (cmbxmlx.Text == "药品")
{
xmlb = "1";
networktypeprop = "1";
networkchargeClass = "1";
}
else if (cmbxmlx.Text == "诊疗")
{
xmlb = "2";
networktypeprop = "2";
networkchargeClass = "";
}
else if (cmbxmlx.Text == "材料")
{
xmlb = "1";
networktypeprop = "1";
networkchargeClass = "3";
}
if (txtzfbl.Text == "0")
{
memo = "甲";
}
else if (txtzfbl.Text != "0" && txtzfbl.Text != "100")
{
memo = "乙";
}
else if (txtzfbl.Text == "100")
{
memo = "丙";
}
if (string.IsNullOrEmpty(txtHiscode.Text) || string.IsNullOrEmpty(txtHisname.Text) || string.IsNullOrEmpty(txtZxCode.Text) || string.IsNullOrEmpty(MainForm.HOSPITAL_ID))
{
MessageBox.Show("不能添加或插入空值！");
return;
}
//插入之前判断重复
StringBuilder strquchong = new StringBuilder();
strquchong.Append("select * from COMM.COMM.NETWORKING_ITEM_VS_HIS WHERE NETWORKING_PAT_CLASS_ID=" + fylb + " and HIS_ITEM_CODE= '" + txtHiscode.Text + "' and HOSPITAL_ID= " + MainForm.HOSPITAL_ID);
//WHERE NETWORKING_PAT_CLASS_ID='4' AND HIS_ITEM_CODE='110900001c' and HOSPITAL_ID ='8001'
if (sqlHelper.ExecSqlReDs(strquchong.ToString()).Tables[0].Rows.Count > 0)
{
MessageBox.Show("该类别的HIS编码已有一条对应关系，无法添加");
return;
}
StringBuilder strAdd = new StringBuilder();
strAdd.Append(" INSERT INTO COMM.COMM.NETWORKING_ITEM_VS_HIS ");
strAdd.Append("( NETWORKING_PAT_CLASS_ID, ");
strAdd.Append(" ITEM_PROP, ");
strAdd.Append(" HIS_ITEM_CODE, ");
strAdd.Append(" HIS_ITEM_NAME, ");
strAdd.Append(" NETWORK_ITEM_CODE, ");
strAdd.Append(" NETWORK_ITEM_NAME, ");
strAdd.Append(" SELF_BURDEN_RATIO, ");
strAdd.Append(" MEMO, ");
strAdd.Append(" START_TIME, ");
strAdd.Append(" STOP_TIME, ");
strAdd.Append(" TYPE_MEMO, ");
strAdd.Append(" NETWORK_ITEM_PROP, ");
strAdd.Append(" NETWORK_ITEM_CHARGE_CLASS, ");
strAdd.Append(" HOSPITAL_ID, ");
strAdd.Append(" NETWORK_ITEM_PRICE, ");
strAdd.Append(" FLAG_DISABLED, ");
strAdd.Append(" NETWORK_ITEM_FLAG_UP ");
strAdd.Append(" ) ");
strAdd.Append(" VALUES( ");
strAdd.Append(" '" + fylb + "', ");
strAdd.Append(" '" + xmlb + "', ");
strAdd.Append(" '" + txtHiscode.Text + "', ");
strAdd.Append(" '" + txtHisname.Text + "', ");
strAdd.Append(" '" + txtZxCode.Text + "', ");
strAdd.Append(" '" + txtZxname.Text + "', ");
strAdd.Append(" '" + txtzfbl.Text + "', ");
strAdd.Append(" '" + memo + "', ");
strAdd.Append(" '" + DateTime.Now + "', ");
strAdd.Append(" '" + DateTime.Now + "', ");
strAdd.Append(" '" + memo + "', ");
strAdd.Append(" '" + networktypeprop + "', ");
strAdd.Append(" '" + networkchargeClass + "', ");
strAdd.Append(" '" + MainForm.HOSPITAL_ID + "', ");
strAdd.Append(" '" + txtPrice.Text + "', ");
strAdd.Append(" '0', ");
strAdd.Append(" '1' ");
strAdd.Append(" ) ");
int suuccess = sqlHelper.ExecSqlReInt(strAdd.ToString());
if (suuccess > 0)
{
MessageBox.Show("添加成功");
}
}
