/// <summary>
/// 插入一条
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int InsertRoomInfo(Neusoft.HISFC.Models.Nurse.Room obj)
{
string strSQL = "";
//取插入操作的SQL语句
string[] strParam;
if (this.Sql.GetSql("Nurse.Room.GetRoomInfo.Insert", ref strSQL) == -1)
{
this.Err = "没有找到字段!";
return(-1);
}
try
{
if (obj.ID == null)
{
return(-1);
}
strParam = this.myGetParmRoomInfo(obj);
}
catch (Exception ex)
{
this.Err = "格式化SQL语句时出错:" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(strSQL, strParam));
}
/// <summary>
/// 更新登记信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Update(Neusoft.HISFC.Models.Nurse.Room info)
{
string sql = "";
string[] strParam;
if (this.Sql.GetSql("Nurse.Room.Update.1", ref sql) == -1)
{
return(-1);
}
try
{
if (info.ID == null)
{
return(-1);
}
strParam = this.myGetParmRoomInfo(info);
}
catch (Exception ex)
{
this.Err = "格式化SQL语句时出错:" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(sql, strParam));
}
/// <summary>
/// 修改诊室
/// </summary>
private void ModifyRoom()
{
TreeNode node = this.neuTreeView1.SelectedNode;
if (node == null || node.Tag == null)
{
MessageBox.Show("请选择一个诊室", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (node.Tag.GetType() != typeof(Neusoft.HISFC.Models.Nurse.Room))
{
return;
}
Neusoft.HISFC.Models.Nurse.Room info = node.Tag as Neusoft.HISFC.Models.Nurse.Room;
Nurse.ucRoom ucRoom1 = new ucRoom();
ucRoom1.StateFlag = "EDIT";
ucRoom1.RoomInfo = info;
ucRoom1.init();
if (Neusoft.FrameWork.WinForms.Classes.Function.PopShowControl(ucRoom1) == System.Windows.Forms.DialogResult.OK)
{
//this.RefreshRooms();
//this.neuTreeView1.SelectedNode = node;
//node.Expand();
node.Text = ucRoom1.RoomInfo.Name;
if (ucRoom1.RoomInfo.IsValid == "0")
{
this.SetFp("停用");
}
}
this.SetFp();
}
private void neuTreeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
this.neuTreeView1.SelectedNode = e.Node;
}
if (this.neuSpread1_Sheet1.RowCount > 0)
{
this.neuSpread1_Sheet1.RemoveRows(0, this.neuSpread1_Sheet1.RowCount);
}
if (e.Node.Tag == null)
{
return;
}
//没有放在诊室上面
if (e.Node.Tag.GetType() != typeof(Neusoft.HISFC.Models.Nurse.Room))
{
return;
}
Neusoft.HISFC.Models.Nurse.Room room = (Neusoft.HISFC.Models.Nurse.Room)e.Node.Tag;
ArrayList al = new ArrayList();
al = this.seatMgr.Query(room.ID);
if (al == null || al.Count <= 0)
{
return;
}
foreach (Neusoft.HISFC.Models.Nurse.Seat seat in al)
{
this.neuSpread1_Sheet1.AddRows(this.neuSpread1_Sheet1.RowCount, 1);
int row = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.Cells[row, 0].Tag = seat.ID;
this.neuSpread1_Sheet1.SetValue(row, 0, seat.Name);
this.neuSpread1_Sheet1.SetValue(row, 1, seat.PRoom.InputCode);
this.neuSpread1_Sheet1.SetValue(row, 2, room.Name);
this.neuSpread1_Sheet1.Cells[row, 2].Tag = room.ID;
if (seat.PRoom.IsValid == "1")
{
this.neuSpread1_Sheet1.Cells[row, 3].Value = "在用";
}
else
{
this.neuSpread1_Sheet1.Cells[row, 3].Value = "停用";
}
this.neuSpread1_Sheet1.SetValue(row, 4, seat.PRoom.Memo);
}
}
/// <summary>
/// 增加诊台记录
/// </summary>
private void AddRecord()
{
TreeNode node = this.neuTreeView1.SelectedNode;
if (node == null || node.Tag == null)
{
return;
}
if (node.Tag.GetType() != typeof(Neusoft.HISFC.Models.Nurse.Room))
{
return;
}
Neusoft.HISFC.Models.Nurse.Room room = node.Tag as Neusoft.HISFC.Models.Nurse.Room;
if (room.IsValid.Trim().Equals("0"))
{
if (MessageBox.Show("【" + room.Name + "】已经停用," + "是否继续添加诊台?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No)
{
return;
}
}
this.neuSpread1.StopCellEditing();
string strNewNo = this.seatMgr.GetSequence("Nurse.Seat.GetSeq");
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 1);
int row = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.ActiveRowIndex = row;
this.neuSpread1_Sheet1.Cells[row, 0].Tag = strNewNo;
this.neuSpread1_Sheet1.Cells[row, 2].Value = room.Name;
this.neuSpread1_Sheet1.Cells[row, 2].Tag = room.ID;
this.neuSpread1_Sheet1.Rows[row].Tag = room.Nurse.ID;
if (room.IsValid.Trim().Equals("1"))
{
this.neuSpread1_Sheet1.Cells[row, 3].Value = "在用";
}
else
{
this.neuSpread1_Sheet1.Cells[row, 3].Value = "停用";
}
FarPoint.Win.Spread.CellType.TextCellType txt = new FarPoint.Win.Spread.CellType.TextCellType();
txt.ReadOnly = true;
txt.StringTrim = System.Drawing.StringTrimming.EllipsisCharacter;
this.neuSpread1_Sheet1.Cells[row, 2].CellType = txt;
this.IsModified = true;
this.neuSpread1.Focus();
}
/// <summary>
/// 转化为实体
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
private ArrayList GetRoomInfo(string strSql)
{
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.Nurse.Room objRoom;
this.ExecQuery(strSql);
while (this.Reader.Read())
{
#region
// DEPT_CODE --VARCHAR2(4) N 分诊科室
// ROOM_ID --VARCHAR2(4) N 诊室代码
// ROOM_NAME --VARCHAR2(20) Y 诊室名称
// INPUT_CODE --VARCHAR2(8) Y 助记码
// VALID_FLAG --VARCHAR2(1) Y 1有效/0无效
// SORT_ID --NUMBER(4) Y 显示顺序
// OPER_CODE --VARCHAR2(6) Y 操作员
// OPER_DATE --DATE Y 操作时间
#endregion
objRoom = new Neusoft.HISFC.Models.Nurse.Room();
try
{
objRoom.Nurse.ID = this.Reader[0].ToString(); //RECIPE_NO, -- 发票号
objRoom.ID = this.Reader[1].ToString(); //诊室代码
objRoom.Name = this.Reader[2].ToString(); //诊室名称
objRoom.InputCode = this.Reader[3].ToString(); //助记码
objRoom.IsValid = this.Reader[4].ToString(); //是否有效
objRoom.Sort = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[5].ToString()); //序号
objRoom.User01 = this.Reader[6].ToString(); //操作员
objRoom.User02 = this.Reader[7].ToString(); //操作时间
}
catch (Exception ex)
{
this.Err = "查询处方明细赋值错误" + ex.Message;
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
al.Add(objRoom);
}
this.Reader.Close();
return(al);
}
protected string[] myGetParmRoomInfo(Neusoft.HISFC.Models.Nurse.Room obj)
{
string[] strParm =
{
obj.Nurse.ID,
obj.ID,
obj.Name,
obj.InputCode,
obj.IsValid,
obj.Sort.ToString(),
obj.User01,
obj.User02
};
return(strParm);
}
/// <summary>
/// 保存
/// </summary>
private void SaveData()
{
this.fpEnter1.StopCellEditing();
if (this.fpEnter1_Sheet1.Tag == null)
{
MessageBox.Show("请先选择病区!", "提示");
return;
}
//验证数据
if (!this.ValidData())
{
this.fpEnter1.Focus();
return;
}
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction tran = new Neusoft.FrameWork.Management.Transaction(this.nurseRoom.Connection);
//开始事务
try
{
//tran.BeginTransaction();
this.nurseRoom.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.nurseRoom.DelRoomInfo((this.fpEnter1_Sheet1.Tag as Neusoft.FrameWork.Models.NeuObject).ID) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.nurseRoom.Err, "提示");
return;
}
//循环插入
for (int i = 0; i < this.fpEnter1_Sheet1.RowCount; i++)
{
Neusoft.HISFC.Models.Nurse.Room obj = new Neusoft.HISFC.Models.Nurse.Room();
//病区代码
obj.Nurse.ID = (this.fpEnter1_Sheet1.Tag as Neusoft.FrameWork.Models.NeuObject).ID;
//诊室标识
obj.ID = this.fpEnter1_Sheet1.Cells[i, 0].Text.ToString();
//诊室名称
obj.Name = this.fpEnter1_Sheet1.Cells[i, 1].Text.ToString();
//助剂码
obj.InputCode = this.fpEnter1_Sheet1.Cells[i, 2].Text.ToString();
//显示顺序
obj.Sort = Neusoft.FrameWork.Function.NConvert.ToInt32(this.fpEnter1_Sheet1.Cells[i, 3].Text.ToString());
//是否有效
if (this.fpEnter1_Sheet1.Cells[i, 4].Text.ToString() == "有效")
{
obj.IsValid = "1";
}
else
{
obj.IsValid = "0";
}
//操作员
obj.User01 = this.nurseRoom.Operator.ID;
//操作时间
obj.User02 = this.nurseRoom.GetSysDateTime();
if (this.nurseRoom.InsertRoomInfo(obj) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.nurseRoom.Err, "提示");
return;
}
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
}
catch (Exception e)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(e.Message, "提示");
return;
}
MessageBox.Show("保存成功!", "提示");
}
/// <summary>
/// 删除诊室
/// </summary>
private void DelRoom()
{
TreeNode node = this.neuTreeView1.SelectedNode;
if (node == null || node.Tag == null || node.Tag.GetType() != typeof(Neusoft.HISFC.Models.Nurse.Room))
{
MessageBox.Show("请选择一个诊室", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Neusoft.HISFC.Models.Nurse.Room info = node.Tag as Neusoft.HISFC.Models.Nurse.Room;
if (MessageBox.Show("删除诊室将同时删除其下面的诊台,是否确认删除:" + info.Name + "?",
"提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question,
MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction SQLCA = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//SQLCA.BeginTransaction();
roomMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
seatMgr.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
try
{
//判断诊室是否被排班
int result = roomMgr.QueryRoom(info.ID, roomMgr.GetSysDate());
if (result < 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("查询诊室失败" + roomMgr.Err);
return;
}
if (result >= 1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("在以后的时间里，该诊室在队列维护中已经被维护，不能删除");
return;
}
//
if (roomMgr.DelRoomInfo(info.ID) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("删除诊室失败！\n请与系统管理员联系。" + roomMgr.Err, "提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.seatMgr.DeleteByRoom(info.ID) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("删除诊台失败！\n请与系统管理员联系。" + this.seatMgr.Err, "提示",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
}
catch (Exception e)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("删除诊室失败！" + e.Message, "提示");
return;
}
this.neuTreeView1.Nodes.Remove(node);
MessageBox.Show("删除成功!", "提示");
}
