// 患者预约 private void searchLookUpEdit1_EditValueChanged(object sender, EventArgs e) { if (XtraMessageBox.Show("是否保存新的预约信息.", "操作确认", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { DateTime dt = DateTime.Now; if (searchLookUpEdit1.EditValue != null) { var o = db.FirstOrDefault<MACHINE_SCHEDULE>("where SCHEDULE_TIME = @0 and pt_id = @1", new object[] { _dt, Convert.ToDecimal(searchLookUpEdit1.EditValue) }); if (o != null) { XtraMessageBox.Show("该患者在 " + dt.ToString("yyyy-MM-dd") + string.Format(" 已预定了床位 . 楼层ID: {0}, 区域ID: {1}, 床位号: {2}, 患者ID: {3}", o.FLOOR_ID, o.AREA_ID, o.BED_NO, o.PT_ID), "错误提示"); searchLookUpEdit1.EditValueChanged -= searchLookUpEdit1_EditValueChanged; searchLookUpEdit1.EditValue = null; searchLookUpEdit1.EditValueChanged += searchLookUpEdit1_EditValueChanged; return; } } //Int64 regId = -1; MACHINE_SCHEDULE ms = new MACHINE_SCHEDULE(); if (searchLookUpEdit1View.GetFocusedRow() != null) { object o1 = searchLookUpEdit1View.GetFocusedRow(); //ms.REG_ID = (Int64)((PATIENT_REGIST)o1).ID; //ms.PT_ID = (Int64)((PATIENT_BASEINFO)o1).ID; } ms.SCHEDULE_TIME = _dt; ms.FLOOR_ID = _floorId; ms.AREA_ID = _areaId; ms.SCHEEDULE_PERIOD = _peroid; ms.RESERVATION = dt; ms.MACHINE_INFO_ID = _info_ID; ms.BED_NO = No; Status = 76; ms.MACHINE_STATUS = 76; if (searchLookUpEdit1.EditValue != null) ms.PT_ID = Convert.ToDecimal(searchLookUpEdit1.EditValue); else { ms.PT_ID = null; Status = 74; ms.MACHINE_STATUS = 74; ms.RESERVATION = new DateTime(); } if (ScheduleID == 0) { ScheduleID = Convert.ToDecimal(ms.Insert()); //ScheduleID = db.ExecuteScalar<decimal>("select ID from MACHINE_SCHEDULE where floor_id = @0 and area_id = @1 and SCHEDULE_TIME = @2 and SCHEEDULE_PERIOD = @3 and MACHINE_NO = @4 ", // new object[] { _floorId, _areaId, _dt, _peroid, No }); } else { ms.ID = ScheduleID; ms.Update(); } if (searchLookUpEdit1.EditValue != null && searchLookUpEdit1.EditValue.ToString() != "") PtNo = Convert.ToDecimal(searchLookUpEdit1.EditValue); else PtNo = null; lblResevTm.Text = dt.ToString("MM-dd HH:mm"); if (ChangeEvt != null) { ChangeEvt(_dt, _peroid, _floorId, _areaId, searchLookUpEdit1.EditValue, Status); } } else { searchLookUpEdit1.EditValueChanged -= searchLookUpEdit1_EditValueChanged; searchLookUpEdit1.EditValue = null; searchLookUpEdit1.EditValueChanged += searchLookUpEdit1_EditValueChanged; } }
private void btnMaintence_Click(object sender, EventArgs e) { if (Status == 77) { XtraMessageBox.Show("目前状态已经是维护状态."); return; } if (XtraMessageBox.Show("是否将状态修改为[维护] ?", "操作确认", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { if ( Status != 76 || ( Status == 76 && XtraMessageBox.Show("该设备在该时段已被预定, 确实要将状态置为 [维护] 吗 ?", "操作确认", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)) { try { if (ScheduleID == 0) { MACHINE_SCHEDULE ms = new MACHINE_SCHEDULE(); ms.SCHEDULE_TIME = _dt; ms.FLOOR_ID = _floorId; ms.AREA_ID = _areaId; ms.SCHEEDULE_PERIOD = _peroid; ms.BED_NO = No; ms.MACHINE_INFO_ID = _info_ID; ms.MACHINE_STATUS = 77; ms.Insert(); ScheduleID = db.ExecuteScalar<decimal>("select ID from MACHINE_SCHEDULE where floor_id = @0 and area_id = @1 and SCHEDULE_TIME = @2 and SCHEEDULE_PERIOD = @3 and BED_NO = @4 ", new object[] { _floorId, _areaId, _dt, _peroid, No }); } else db.Execute("update MACHINE_SCHEDULE set MACHINE_STATUS = 77 where ID = @0", new object[] { ScheduleID }); Status = 77; } catch (Exception err) { XtraMessageBox.Show("未知异常: " + err.Message); } } } }