///<summary>
///删除手术室正台分配信息
///</summary>
///<param name="thisAllot">手术分配信息对象(Neusoft.HISFC.Models.Operation.OpsTableAllot类型)</param>
///<returns>0成功 -1失败</returns>
public int DelAllotInfo(Neusoft.HISFC.Models.Operation.OpsTableAllot thisAllot)
{
string strSql = string.Empty;
if (this.Sql.GetSql("Operator.OpsTableAlloc.DelAllotInfo.1", ref strSql) == -1)
{
return(-1);
}
try
{
//手术正台分配表中删除记录
strSql = string.Format(strSql, thisAllot.OpsRoom.ID.ToString(),
thisAllot.Dept.ID.ToString(), thisAllot.Week.ID.ToString());
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
if (strSql == null)
{
return(-1);
}
return(this.ExecNoQuery(strSql));
}
private void btDel_Click(object sender, EventArgs e)
{
string sOldNode;
this.btDel.Enabled = false;
//只能删除叶节点
if (this.tvShow.SelectedNode != null && this.tvShow.Nodes.Count != 0 && this.tvShow.Parent != null)
{
//将选中的节点信息置为对象
Neusoft.HISFC.Models.Operation.OpsTableAllot thisAllot = new Neusoft.HISFC.Models.Operation.OpsTableAllot();
thisAllot.OpsRoom.ID = this.OpsObj.OpsRoom.ID;
thisAllot.Dept.ID = this.tvShow.SelectedNode.Tag.ToString().Substring(0, 4);
thisAllot.Week.ID = Convert.ToString(this.tvShow.SelectedNode.Parent.Index + 1);
thisAllot.Qty = Convert.ToInt16(this.tvShow.SelectedNode.Tag.ToString().Substring(5));
string sWeekDay = "";
switch (thisAllot.Week.ID.ToString())
{
case "1":
sWeekDay = "星期一";
break;
case "2":
sWeekDay = "星期二";
break;
case "3":
sWeekDay = "星期三";
break;
case "4":
sWeekDay = "星期四";
break;
case "5":
sWeekDay = "星期五";
break;
case "6":
sWeekDay = "星期六";
break;
case "7":
sWeekDay = "星期日";
break;
}
//Delete数据库中该对象所对应的数据
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction Trans = new Neusoft.FrameWork.Management.Transaction(this.OpsMana.Connection);
//Trans.BeginTransaction();
this.OpsMana.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.OpsMana.DelAllotInfo(thisAllot) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
this.btDel.Enabled = true;
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
//删除节点后刷新显示根节点信息
//分配数 = 原总数 - 被移除的科室分配数
sOldNode = this.tvShow.SelectedNode.Tag.ToString().Substring(0, 4);
this.tvShow.SelectedNode.Parent.Tag = Convert.ToString(Convert.ToInt16(this.tvShow.SelectedNode.Parent.Tag) -
Convert.ToInt16(this.tvShow.SelectedNode.Tag.ToString().Substring(5))
);
this.tvShow.SelectedNode.Parent.Text = sWeekDay + "【共" + this.tvShow.SelectedNode.Parent.Tag.ToString() + "台】";
this.tvShow.SelectedNode.Remove();
this.tvShow.SelectedNode = this.tvShow.Nodes[0];
//如果正台分配选择了该科室则刷新
if (this.ncbDept.Tag.ToString() == sOldNode)
{
switch (thisAllot.Week.ID.ToString())
{
case "1":
this.nnudMon.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudMon.Text) - thisAllot.Qty);
this.iOpsNum[0] = Convert.ToInt16(this.nnudMon.Text);
break;
case "2":
this.nnudTues.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudTues.Text) - thisAllot.Qty);
this.iOpsNum[1] = Convert.ToInt16(this.nnudTues.Text);
break;
case "3":
this.nnudWed.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudWed.Text) - thisAllot.Qty);
this.iOpsNum[2] = Convert.ToInt16(this.nnudWed.Text);
break;
case "4":
this.nnudThur.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudThur.Text) - thisAllot.Qty);
this.iOpsNum[3] = Convert.ToInt16(this.nnudThur.Text);
break;
case "5":
this.nnudFri.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudFri.Text) - thisAllot.Qty);
this.iOpsNum[4] = Convert.ToInt16(this.nnudFri.Text);
break;
case "6":
this.nnudSat.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudSat.Text) - thisAllot.Qty);
this.iOpsNum[5] = Convert.ToInt16(this.nnudSat.Text);
break;
case "7":
this.nnudSun.Text = Convert.ToString(Neusoft.FrameWork.Function.NConvert.ToInt32(this.nnudSun.Text) - thisAllot.Qty);
this.iOpsNum[6] = Convert.ToInt16(this.nnudSun.Text);
break;
}
this.SumQtyToShow();
}
}
this.btDel.Enabled = true;
}
/// <summary>
/// 获得手术室的正台分配信息 （重载）
/// </summary>
/// <param name="AllotInfoAl">
/// （引用，存有手术分配信息的数组，
/// 元素为Neusoft.HISFC.Models.Operation.OpsTableAllot类型,传入时没有元素）</param>
/// <param name="OpsRoom">（手术室实体）</param>
/// <param name="Dept">（临床科室实体）</param>
/// <returns>0成功 -1失败 </returns>
public int GetAllotInfo(ref ArrayList AllotInfoAl, Neusoft.FrameWork.Models.NeuObject OpsRoom, Neusoft.FrameWork.Models.NeuObject Dept)
{
string strSql = string.Empty;
if (this.Sql.GetSql("Operator.OpsTableAlloc.GetAllotInfo.2", ref strSql) == -1)
{
return(-1);
}
try
{
//获取手术室正台分配信息
strSql = string.Format(strSql, OpsRoom.ID.ToString(), Dept.ID.ToString());
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
if (strSql == null)
{
return(-1);
}
this.ExecQuery(strSql);
try
{
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Operation.OpsTableAllot thisAllot = new Neusoft.HISFC.Models.Operation.OpsTableAllot();
try
{
thisAllot.OpsRoom.ID = Reader[0].ToString(); //手术科室代码
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
thisAllot.Dept.ID = Reader[1].ToString(); //临床科室代码
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
thisAllot.Dept.Name = Reader[4].ToString(); //临床科室名称
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
thisAllot.Week.ID = Reader[2].ToString(); //星期
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
try
{
thisAllot.Qty = System.Convert.ToInt16(Reader[3]); //正台数
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
}
AllotInfoAl.Add(thisAllot);
}
}
catch (Exception ex)
{
this.Err = "获得手术正台分配信息出错！" + ex.Message;
this.ErrCode = "-1";
this.WriteErr();
return(-1);
}
this.Reader.Close();
return(0);
}
