/// <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); }