/// <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";
}
}
