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("添加成功"); } }