/// <summary> /// 特殊检查列表中双击事件的处理方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void neuSpreadCheck_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { //if (tvDoctor.SelectedNode.ToolTipText != "医生") //{ // MessageBox.Show("没有选择医生!"); // return; //} if (CheckDoctTreeValid() == false) { return; } //填充数组 Neusoft.HISFC.Models.Order.Medical.Popedom popedomOne = new Neusoft.HISFC.Models.Order.Medical.Popedom(); popedomOne.EmplCode = tvDoctor.SelectedNode.Tag.ToString(); popedomOne.EmplName = tvDoctor.SelectedNode.Text; popedomOne.PopedomType.ID = "9"; popedomOne.PopedomType.Name = "特殊检查"; popedomOne.Popedoms.ID = this.SpreadCheck_Sheet1.Cells[e.Row, 0].Text; popedomOne.Popedoms.Name = this.SpreadCheck_Sheet1.Cells[e.Row, 1].Text; for (int i = 0; i < fpPopedom.RowCount; i++) { if ((popedomOne.PopedomType.ID == fpPopedom.Cells[i, 7].Text.Trim()) && (popedomOne.Popedoms.ID == fpPopedom.Cells[i, 6].Text.Trim())) { MessageBox.Show("该权限已经添加"); return; } } fpPopedom.Rows[fpPopedom.RowCount - 1].Tag = popedomOne; //popAdd.Add(popedomOne); //填充farPoint控件 fpPopedom.RowCount = fpPopedom.RowCount + 1; fpPopedom.Cells[fpPopedom.RowCount - 1, 0].Text = tvDoctor.SelectedNode.Tag.ToString(); fpPopedom.Cells[fpPopedom.RowCount - 1, 1].Text = tvDoctor.SelectedNode.Text; fpPopedom.Cells[fpPopedom.RowCount - 1, 2].Text = "特殊检查"; fpPopedom.Cells[fpPopedom.RowCount - 1, 3].Text = this.SpreadCheck_Sheet1.Cells[e.Row, 1].Text; fpPopedom.Cells[fpPopedom.RowCount - 1, 4].Text = "否"; fpPopedom.Cells[fpPopedom.RowCount - 1, 6].Text = this.SpreadCheck_Sheet1.Cells[e.Row, 0].Text; fpPopedom.Cells[fpPopedom.RowCount - 1, 7].Text = "9"; fpPopedom.Cells[fpPopedom.RowCount - 1, 8].Text = "1"; }
/// <summary> /// 通过人员代码查询医疗权限 /// </summary> /// <param name="emplID">人员代码</param> /// <returns>成功 权限实体列表 失败 null</returns> public List <Neusoft.HISFC.Models.Order.Medical.Popedom> QueryPopedomByEmplID(string emplID) { string sql = string.Empty; if (this.Sql.GetSql("Medical.Ability.QueryPopedom", ref sql) == -1) { this.Err = "没有找到索引为:Medical.Ability.QueryPopedom的SQL语句"; return(null); } if (this.ExecQuery(sql, emplID) == -1) { this.Err = "执行SQL语句出错!" + this.Err; this.ErrCode = "-1"; return(null); } List <Neusoft.HISFC.Models.Order.Medical.Popedom> al = new List <Neusoft.HISFC.Models.Order.Medical.Popedom>(); try { while (this.Reader.Read()) { Neusoft.HISFC.Models.Order.Medical.Popedom fection = new Neusoft.HISFC.Models.Order.Medical.Popedom(); fection.ID = this.Reader[0].ToString(); fection.EmplCode = this.Reader[1].ToString(); fection.PopedomType.ID = this.Reader[2].ToString(); fection.Popedoms.ID = this.Reader[3].ToString(); fection.CheckFlag = this.Reader[4].ToString(); al.Add(fection); } } catch (System.Exception ex) { this.Err = "获得权限信息时出错!" + ex.Message; this.ErrCode = "-1"; return(null); } finally { this.Reader.Close(); } return(al); }
/// <summary> /// 把选择好的权限数据加入到准备保存的数据列表中 /// {EC320C77-250E-4f44-863D-2E47B9F2FA22} /// </summary> /// <param name="node"></param> /// <returns></returns> private int AddDataOfChildDoctToSaveList(TreeNode node) { if (node.ToolTipText == "医生") { for (int i = 0; i < fpPopedom.RowCount; i++) { Neusoft.HISFC.Models.Order.Medical.Popedom spo = new Neusoft.HISFC.Models.Order.Medical.Popedom(); spo.EmplCode = node.Tag.ToString(); spo.EmplName = node.Text; spo.PopedomType.Name = fpPopedom.Cells[i, 2].Text; spo.Popedoms.Name = fpPopedom.Cells[i, 3].Text; if (fpPopedom.Cells[i, 4].Text == "是") { spo.CheckFlag = "1"; } else { spo.CheckFlag = "0"; } spo.ID = fpPopedom.Cells[i, 5].Text; spo.Popedoms.ID = fpPopedom.Cells[i, 6].Text; spo.PopedomType.ID = fpPopedom.Cells[i, 7].Text; spo.User03 = fpPopedom.Cells[i, 8].Text; popAdd.Add(spo); } } else { foreach (TreeNode childNode in node.Nodes) { AddDataOfChildDoctToSaveList(childNode); } } return(1); }
/// <summary> /// 修改医疗权限审核标志 /// </summary> /// <param name="ppd">权限实体</param> /// <returns>成功 1 失败 -1</returns> public int UpdatePopedom(Neusoft.HISFC.Models.Order.Medical.Popedom ppd) { return(this.UpdateSingleTable("Medical.Ability.UpdatePopedom", ppd.ID, ppd.CheckFlag)); }
/// <summary> /// 插入医疗权限 /// </summary> /// <param name="ppd">权限实体</param> /// <returns>成功 1 失败 -1</returns> public int InsertPopedom(Neusoft.HISFC.Models.Order.Medical.Popedom ppd) { return(this.UpdateSingleTable("Medical.Ability.InsertPopedom", ppd.EmplCode, ppd.PopedomType.ID, ppd.Popedoms.ID, ppd.CheckFlag)); }
private void tvPopedom_DoubleClick(object sender, EventArgs e) { //原代码 //if (tvDoctor.SelectedNode.ToolTipText != "医生") //{ // MessageBox.Show("没有选择医生!"); // return; //} #region 于洋修改的代码 if (CheckDoctTreeValid() == false) { return; } #endregion if (tvPopedom.SelectedNode.ToolTipText == "权限") { //填充数组 Neusoft.HISFC.Models.Order.Medical.Popedom popedomOne = new Neusoft.HISFC.Models.Order.Medical.Popedom(); popedomOne.EmplCode = tvDoctor.SelectedNode.Tag.ToString(); popedomOne.EmplName = tvDoctor.SelectedNode.Text; popedomOne.Popedoms.Name = tvPopedom.SelectedNode.Text; if (tvPopedom.SelectedNode.Tag == null) { popedomOne.PopedomType.Name = tvPopedom.SelectedNode.Text; popedomOne.Popedoms.ID = tvPopedom.SelectedNode.Index.ToString(); popedomOne.PopedomType.ID = tvPopedom.SelectedNode.Index.ToString(); } else { popedomOne.PopedomType.Name = tvPopedom.SelectedNode.Parent.Text; popedomOne.PopedomType.ID = tvPopedom.SelectedNode.Parent.Index.ToString(); popedomOne.Popedoms.ID = tvPopedom.SelectedNode.Tag.ToString(); } for (int i = 0; i < fpPopedom.RowCount; i++) { if ((popedomOne.PopedomType.ID == fpPopedom.Cells[i, 7].Text.Trim()) && (popedomOne.Popedoms.ID == fpPopedom.Cells[i, 6].Text.Trim())) { MessageBox.Show("该权限已经添加"); return; } } fpPopedom.Rows[fpPopedom.RowCount - 1].Tag = popedomOne; //popAdd.Add(popedomOne); //填充farPoint控件 fpPopedom.RowCount = fpPopedom.RowCount + 1; fpPopedom.Cells[fpPopedom.RowCount - 1, 0].Text = tvDoctor.SelectedNode.Tag.ToString(); fpPopedom.Cells[fpPopedom.RowCount - 1, 1].Text = tvDoctor.SelectedNode.Text; if (tvPopedom.SelectedNode.Tag == null) { fpPopedom.Cells[fpPopedom.RowCount - 1, 2].Text = tvPopedom.SelectedNode.Text; fpPopedom.Cells[fpPopedom.RowCount - 1, 6].Text = tvPopedom.SelectedNode.Index.ToString(); fpPopedom.Cells[fpPopedom.RowCount - 1, 7].Text = tvPopedom.SelectedNode.Index.ToString(); } else { fpPopedom.Cells[fpPopedom.RowCount - 1, 2].Text = tvPopedom.SelectedNode.Parent.Text; fpPopedom.Cells[fpPopedom.RowCount - 1, 6].Text = tvPopedom.SelectedNode.Tag.ToString(); fpPopedom.Cells[fpPopedom.RowCount - 1, 7].Text = tvPopedom.SelectedNode.Parent.Index.ToString(); } fpPopedom.Cells[fpPopedom.RowCount - 1, 3].Text = tvPopedom.SelectedNode.Text; fpPopedom.Cells[fpPopedom.RowCount - 1, 4].Text = "否"; fpPopedom.Cells[fpPopedom.RowCount - 1, 8].Text = "1"; } }