/// <summary>
/// 保存报告内容
/// </summary>
/// <param name="reportData"></param>
public void SaveReportContext(ReportContextData reportData)
{
SQL sql = SqlHelper.CreateSQL("保存报告内容", "update 影像检查报告 set 报告信息=:报告信息 where 报告ID=:报告ID");
sql.AddParameter("报告ID", DbType.String, reportData.报告ID);
sql.AddParameter("报告信息", DbType.String, reportData.报告信息.ToString());
_dbHelper.ExecuteSQL(sql);
}
///// <summary>
///// 更新修订状态
///// </summary>
///// <param name="reportId"></param>
///// <param name="state"></param>
//public void UpdateReviseState(string reportId, int state)
//{
// SQL sql = SqlHelper.CreateSQL("更新报告修订状态", "Update 影像检查报告 Set 状态信息=:状态信息 where 报告ID=:报告ID ");
// sql.AddParameter("报告ID", DbType.String, reportId);
// sql.AddParameter("状态信息", DbType.String, state);
// _dbHelper.ExecuteSQL(sql);
//}
/// <summary>
/// 更新报告状态信息
/// </summary>
/// <param name="reportData"></param>
public void UpdateReportStateInfo(ReportContextData reportData)
{
SQL sql = SqlHelper.CreateSQL("更新报告状态信息", "Update 影像检查报告 Set 报告信息=:报告信息,状态信息=:状态信息 where 报告ID=:报告ID ");
sql.AddParameter("报告ID", DbType.String, reportData.报告ID);
sql.AddParameter("报告信息", DbType.String, reportData.报告信息.ToString());
sql.AddParameter("状态信息", DbType.String, reportData.状态信息.ToString());
_dbHelper.ExecuteSQL(sql);
}
/// <summary>
/// 驳回报告
/// </summary>
/// <param name="reportData"></param>
public void RejectReport(ReportContextData reportData)
{
SQL sql = SqlHelper.CreateSQL("驳回报告", "update 影像检查报告 set 状态信息=:状态信息, 驳回信息=:驳回信息 where 报告ID=:报告ID");
sql.AddParameter("报告ID", DbType.String, reportData.报告ID);
sql.AddParameter("状态信息", DbType.String, reportData.状态信息.ToString());
sql.AddParameter("驳回信息", DbType.String, reportData.驳回信息.ToString());
_dbHelper.ExecuteSQL(sql);
}
/// <summary>
/// 回退报告签名
/// </summary>
/// <param name="reportData"></param>
public void BackReportSign(ReportContextData reportData)
{
SQL sql = SqlHelper.CreateSQL("保存报告内容", "update 影像检查报告 set 状态信息=:状态信息, 报告信息=:报告信息, 签名信息=:签名信息, 回退信息=:回退信息 where 报告ID=:报告ID");
sql.AddParameter("报告ID", DbType.String, reportData.报告ID);
sql.AddParameter("状态信息", DbType.String, reportData.状态信息.ToString());
sql.AddParameter("报告信息", DbType.String, reportData.报告信息.ToString());
sql.AddParameter("签名信息", DbType.String, reportData.签名信息.ToString());
sql.AddParameter("回退信息", DbType.String, reportData.回退信息.ToString());
_dbHelper.ExecuteSQL(sql);
}
/// <summary>
/// 新增报告
/// </summary>
/// <param name="reportData"></param>
public void NewReport(ReportContextData reportData)
{
SQL sql = SqlHelper.CreateSQL("新增报告", "Insert into 影像检查报告(报告ID,申请ID,报告名称,部位名称,测量信息,状态信息,报告信息,签名信息,驳回信息,打印信息,附件信息)" +
" Values(:报告ID,:申请ID,:报告名称,:部位名称,:测量信息,:状态信息,:报告信息,:签名信息,:驳回信息,:打印信息,:附件信息)");
sql.AddParameter("报告ID", DbType.String, reportData.报告ID);
sql.AddParameter("申请ID", DbType.String, reportData.申请ID);
sql.AddParameter("报告名称", DbType.String, reportData.报告名称);
sql.AddParameter("部位名称", DbType.String, reportData.部位名称);
sql.AddParameter("测量信息", DbType.String, reportData.测量信息.ToString());
sql.AddParameter("状态信息", DbType.String, reportData.状态信息.ToString());
sql.AddParameter("报告信息", DbType.String, reportData.报告信息.ToString());
sql.AddParameter("签名信息", DbType.String, reportData.签名信息.ToString());
sql.AddParameter("驳回信息", DbType.String, reportData.驳回信息.ToString());
sql.AddParameter("打印信息", DbType.String, reportData.打印信息.ToString());
sql.AddParameter("附件信息", DbType.String, reportData.附件信息.ToString());
_dbHelper.ExecuteSQL(sql);
}