private void 医嘱查询ToolStripMenuItem_Click(object sender, EventArgs e) { try { //comment by wangzhi 2010-11-16 //DataTable tb = (DataTable)dgvyjsq.DataSource; //if ( dataGridView1.CurrentCell == null ) // return; //if ( tb.Rows.Count <= 0 ) // return; //int nrow = dgvyjsq.CurrentCell.RowIndex; //Guid yzid = new Guid( tb.Rows[nrow]["yzid"].ToString() ); //end comment // add by wangzhi 2010-11-16 if (dgvyjsq.DataSource == null) { return; } if (dgvyjsq.Rows.Count == 0) { return; } DataView dv = (DataView)dgvyjsq.DataSource; int nrow = dgvyjsq.CurrentCell.RowIndex; Guid yzid = new Guid(dv[nrow]["yzid"].ToString()); //end add string ssql = " select a.inpatient_id,a.baby_id,a.ward_id,a.dept_br,0 dept_ly,flag, " + " CAST(A.INPATIENT_ID AS CHAR(40)) + CAST(A.BABY_id AS CHAR(10)) + CAST(0 AS CHAR(10)) + CAST(A.dept_br AS CHAR(10)) + CAST(A.WARD_ID AS CHAR(10)) AS STAG " + "from zy_orderrecord a inner join VI_ZY_VINPATIENT b " + " on a.inpatient_id=b.inpatient_id " + " where order_id='" + yzid + "' "; DataTable tbmx = InstanceForm.BDatabase.GetDataTable(ssql); if (tbmx.Rows.Count == 0) { return; } int _flag = Convert.ToInt32(tbmx.Rows[0]["flag"]); if (_flag == 2 || _flag == 4 || _flag == 5 || _flag == 6) { MessageBox.Show("该病人已经出院!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } object[] communicateValue = new object[3]; //这个是废参数,无所谓 communicateValue[0] = ""; communicateValue[1] = 0; //病人ID communicateValue[2] = tbmx.Rows[0]["inpatient_id"].ToString(); WorkStaticFun.InstanceFormEx("ts_zyhs_yzgl", "Fun_ts_zyhs_yzgl_inpatient", "医嘱查询", InstanceForm.BCurrentUser, InstanceForm.BCurrentDept, new MenuTag(), -1, this.MdiParent, InstanceForm.BDatabase, ref communicateValue); } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 医嘱查询_麻醉,信息查询 /// </summary> /// <param name="userid">开嘱医生userId</param> /// <param name="deptid">开嘱医生的科室ID</param> /// <param name="dept_br">病人所在科室ID</param> private void ShowFrmYZCX_MZ(long userid, long deptid, string ssNo) { if (this.txtPatID.Text == "") { MessageBox.Show("请输入住院号", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } object[] communicateValue = new object[3]; User _userid = new User(userid, FrmMdiMain.Database); Department _deptid = new Department(deptid, FrmMdiMain.Database); //add by zouchihua 2012-5-24 医生工作站 手术麻醉进入是否对婴儿记账 0=否,1=是 SystemCfg cfg6034 = new SystemCfg(6034); string ssql = ""; if (cfg6034.Config.Trim() == "0") { ssql = "select INPATIENT_NO AS 住院号,NAME AS 姓名,INPATIENT_ID,0 as Baby_ID,DEPT_ID,0 as isMY " + "from vi_zy_vinpatient " + "where inpatient_no='" + ssNo + "' and flag<>10"; } else { ssql = "select INPATIENT_NO AS 住院号,NAME AS 姓名,INPATIENT_ID,Baby_ID,DEPT_ID,0 as isMY " + "from VI_ZY_VINPATIENT_BED " + "where inpatient_no='" + ssNo + "' and flag<>10"; } if (type == 0) { //Modify By Tany 2011-03-03 //9003是否允许对未开手术申请的病人录入医嘱 0=是 1=不是 if (new SystemCfg(9003).Config == "1") { ssql += " and inpatient_id in (select inpatient_id from ss_apprecord where (jzss=1 or shbj=1) and bdelete=0)"; } } else//特殊治疗 { ssql = "select INPATIENT_NO AS 住院号,NAME AS 姓名,INPATIENT_ID,0 as Baby_ID,DEPT_ID,0 as isMY " + "from vi_zy_vinpatient_bed " + "where inpatient_no='" + ssNo + "' and flag<>10"; } DataTable tb = FrmMdiMain.Database.GetDataTable(ssql); if (tb.Rows.Count == 0) { MessageBox.Show("不能查询该住院号的病人,请重新输入住院号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ClassStatic.Current_BinID = new Guid(tb.Rows[0]["INPATIENT_ID"].ToString()); ClassStatic.Current_DeptID = Convert.ToInt64(tb.Rows[0]["DEPT_ID"]); ClassStatic.Current_BabyID = 0; communicateValue[0] = ssql; communicateValue[1] = 1; //Modify by zouchihua 2012-3-19 if (type == 0) { //Modify By Tany 2015-05-11 手术和麻醉要根据科室来 DataTable ssmzTb = FrmMdiMain.Database.GetDataTable("select * from ss_dept where deptid=" + FrmMdiMain.CurrentDept.DeptId); if (ssmzTb != null && ssmzTb.Rows.Count > 0) { int ssmzType = Convert.ToInt32(ssmzTb.Rows[0]["type"]); communicateValue[1] = ssmzType; //0=手术 1=麻醉 } WorkStaticFun.InstanceFormEx("ts_zyhs_yzgl", "Fun_ts_zyhs_yzgl_ssmz", "医嘱管理", _userid, _deptid, InstanceForm._functions, InstanceForm._menuId, this.MdiParent, FrmMdiMain.Database, ref communicateValue); } if (type == 1) { communicateValue[2] = tb.Rows[0]["INPATIENT_ID"].ToString(); WorkStaticFun.InstanceFormEx("ts_zyhs_yzgl", "Fun_ts_zyhs_yzgl_inpatient", "医嘱管理", _userid, _deptid, InstanceForm._functions, InstanceForm._menuId, this.MdiParent, FrmMdiMain.Database, ref communicateValue); } }