/// <summary>
/// 右键删除事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItemDeleteApplySave_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (MessageBox.Show("是否删除会诊记录？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DataRowView drv = gridViewConsultation.GetRow(gridViewConsultation.FocusedRowHandle) as DataRowView;
if (drv != null)
{
string consultationApplySn = drv["consultapplysn"].ToString();
ConsultStatus state = GetConsultationState(consultationApplySn);
//只能删除会诊申请草稿、会诊否决、会诊撤销
if (state == ConsultStatus.ApplySave || state == ConsultStatus.Reject || state == ConsultStatus.CallBackConsultation)
{
CancelConsultationRecord(consultationApplySn);
drv.Delete();
MyMessageBox.Show("删除成功！", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.InformationIcon);
}
else
{
MyMessageBox.Show("此记录的状态已变更，不能进行删除操作！", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.WarningIcon);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Save(ConsultStatus status)
{
if (CheckData())
{
try
{
m_App.SqlHelper.BeginTransaction();
SaveConsultationApply(SaveType.RecordModify, m_ConsultApplySN, status);
SaveConsultationRecordDept(m_ConsultApplySN);
m_App.SqlHelper.CommitTransaction();
m_App.CustomMessageBox.MessageShow("保存成功!", CustomMessageBoxKind.InformationOk);
//点击“会诊完成”后关闭界面
if (status == ConsultStatus.RecordeComplete)
{
XtraForm form = this.FindForm() as XtraForm;
form.Close();
}
}
catch (Exception ex)
{
m_App.SqlHelper.RollbackTransaction();
m_App.CustomMessageBox.MessageShow("保存失败!" + ex.Message, CustomMessageBoxKind.InformationOk);
}
}
}
/// <summary>
/// 更新会诊申请相关信息的方法
/// Add xlb 2013-03-01
/// </summary>
/// <param name="consultStatus"></param>
private void UpdateConsultApply(ConsultStatus consultStatus)
{
try
{
string sql = @"UPDATE consultapply set consultsuggestion = @consultsuggestion,
finishtime=@finishtime,stateid =@stateid,modifieduser=@modifiedUser,modifiedtime=@modifiedtime WHERE consultapplysn = @consultapplysn";
string consultSuggestion = memoEditSuggestion.Text.Trim();
string finishTime = dateEditConsultationDate.Text + " " + timeEditConsultationTime.Text;
string stateId = Convert.ToString((int)consultStatus);
SqlParameter[] sps =
{
new SqlParameter("@consultsuggestion", consultSuggestion),
new SqlParameter("@finishtime", finishTime),
new SqlParameter("@stateid", stateId),
new SqlParameter("@modifiedUser", m_app.User.Id),
new SqlParameter("@modifiedtime", DateTime.Now.ToString("yyyy-MM-dd HH;mm:ss")),
new SqlParameter("@consultapplysn", mconsultApplySn)
};
DS_SqlHelper.ExecuteNonQuery(sql, sps, CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 校验通过或否决时是否填写了相应的原因
/// Add xlb 2013-02-21
/// </summary>
private bool CheckControl(ref string message, bool isOk)//isOk 表示是否通过 false则必须填写意见
{
try
{
if (string.IsNullOrEmpty(memoEditSuggestion.Text.Trim()) && !isOk)
{
message = "否决时请填写审核意见";
memoEditSuggestion.Focus();
return(false);
}
else if (memoEditSuggestion.Text.Trim().Length > 1500)
{
message = "审核意见不能超过1500字";
return(false);
}
string status = GetConsultSate();
ConsultStatus constatus = (ConsultStatus)Enum.Parse(typeof(ConsultStatus), status);
string info = constatus == ConsultStatus.CallBackConsultation ? "撤销" : "取消";
if (status == Convert.ToString((int)ConsultStatus.CancelConsultion) ||
status == Convert.ToString((int)ConsultStatus.CallBackConsultation))
{
message = "该会诊申请已被" + info + "";
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 保存多科会诊信息
/// </summary>
/// <param name="status"></param>
public void SaveForMultiply(ConsultStatus status)
{
if (m_UCConsultationMultiply == null)
return;
else
m_UCConsultationMultiply.Save();
}
/// <summary>
/// 右键撤销事件
/// Modify by xlb 2013-03-27
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItemCallBack_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (MessageBox.Show("是否撤销此次会诊申请？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DataRowView drv = gridViewConsultation.GetRow(gridViewConsultation.FocusedRowHandle) as DataRowView;
if (drv != null)
{
string consultationApplySn = drv["consultapplysn"].ToString();
ConsultStatus state = GetConsultationState(consultationApplySn);
if (state == ConsultStatus.WaitApprove)//待审核的记录可以撤销
{
UpdateConsultationState(Convert.ToString((int)ConsultStatus.CallBackConsultation), consultationApplySn);
//drv["stateid"] = (int)ConsultStatus.CallBackConsultation;
//drv["consultstatus"] = "已撤销";
//gridViewConsultation.RefreshData();
MyMessageBox.Show("撤销成功", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.InformationIcon);
}
else if (state == ConsultStatus.WaitConsultation)//待会诊且未审核过的可以撤销
{
//检查是否有已经签到的医师，否则不能撤销
if (CheckIsSign(consultationApplySn))
{
MyMessageBox.Show("此记录已经有医师签到，不能进行撤销操作", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.WarningIcon);
return;
}
else if (drv["ispassed"].ToString() == "1")
{
MyMessageBox.Show("此记录已经审核过，不能进行撤销操作", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.WarningIcon);
return;
}
else
{
UpdateConsultationState(Convert.ToString((int)ConsultStatus.CallBackConsultation), consultationApplySn);
//drv["stateid"] = (int)ConsultStatus.CallBackConsultation;
//drv["consultstatus"] = "已撤销";
//gridViewConsultation.RefreshData();
MyMessageBox.Show("撤销成功", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.InformationIcon);
}
}
else
{
MyMessageBox.Show("此记录的状态已变更，不能进行撤销操作", "提示", MyMessageBoxButtons.Ok, DrectSoft.Common.Ctrs.DLG.MessageBoxIcon.WarningIcon);
}
BindConsultion();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Save(ConsultStatus status)
{
if (CheckData())
{
try
{
m_App.SqlHelper.BeginTransaction();
SaveConsultationApply(SaveType.RecordModify, m_ConsultApplySN, status);
SaveConsultationRecordDept(m_ConsultApplySN);
m_App.SqlHelper.CommitTransaction();
m_App.CustomMessageBox.MessageShow("保存成功!", CustomMessageBoxKind.InformationOk);
}
catch (Exception ex)
{
m_App.SqlHelper.RollbackTransaction();
m_App.CustomMessageBox.MessageShow("保存失败!" + ex.Message, CustomMessageBoxKind.InformationOk);
}
}
}
/// <summary>
/// 修改审核状态通过则为待会诊否则为否决
/// Add xlb 2013-02-21
/// </summary>
private void ModitifyConsultation(ConsultStatus consultStatus, string rejectReason, string consultapplySn)
{
try
{
string stateId = Convert.ToString((int)consultStatus);
DS_SqlHelper.CreateSqlHelper();
string isPassed = consultStatus == ConsultStatus.WaitConsultation ? "1" : "0";
string sql = @"update consultapply set stateid=@stateId,rejectreason=@rejectReason,ispassed=@ispassed where consultapplysn=@consultapplySn";
SqlParameter[] sps =
{
new SqlParameter("@stateId", stateId),
new SqlParameter("@rejectReason", rejectReason),
new SqlParameter("@ispassed", isPassed),
new SqlParameter("@consultapplysn", consultapplySn)
};
DS_SqlHelper.ExecuteNonQuery(sql, sps, CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 保存会诊相关信息的方法
/// Add xlb 2013-02-28
/// </summary>
private void SaveConsultRecord(ConsultStatus consultStatus)
{
try
{
DataTable dtSource = (DataTable)gridControlDepartment.DataSource;
foreach (DataRow row in dtSource.Rows)
{
//行当前状态为修改状态则修改该行数据
if (row.RowState == DataRowState.Modified)
{
SaveConsultRecordDepartment(2, row);
}
else if (row.RowState == DataRowState.Added)//行状态为新增则插入
{
SaveConsultRecordDepartment(3, row);
}
else if (row.RowState == DataRowState.Deleted)//视图中状态为删除的行
{
SaveConsultRecordDepartment(1, row);
}
}
UpdateConsultApply(consultStatus);
//更新行状态
dtSource.AcceptChanges();
MessageBox.Show("保存成功");
if (consultStatus == ConsultStatus.RecordeComplete)
{
Form form = this.FindForm() as Form;
form.Close();
}
}
catch (Exception ex)
{
throw ex;
}
}
private string SaveConsultationApply(SaveType saveType, string consultApplySN, ConsultStatus status)
{
string typeID = Convert.ToString((int)saveType);
string consultSuggestion = memoEditSuggestion.Text.Trim();
string finishTime = dateEditConsultationDate.Text + " " + timeEditConsultationTime.Text;
return(DataAccess.InsertConsultationApply(typeID, consultApplySN, m_NoOfFirstPage, consultSuggestion, finishTime, Convert.ToString((int)status)));
}
