public void UpdateApply(ApplyData apply)
{
SQL sql = SqlHelper.CreateSQL("修改申请信息", @"update 影像检查申请 a set a.患者id = :患者id ,
a.执行院区=:执行院区,a.执行科室id=:执行科室id,a.检查号=:检查号,a.就诊卡号=:就诊卡号,
a.门诊号=:门诊号,a.住院号=:住院号,a.影像类别=:影像类别,a.申请日期=:申请日期,a.报到日期=:报到日期,
a.申请状态=:申请状态,a.申请信息=:申请信息,a.申请关联id=:申请关联id,
a.申请识别码=:申请识别码 where a.申请id=:申请id");
SqlParamInfo[] sqlPars = GetApplyPars(apply);
sql.AddParameterRange(sqlPars);
_dbHelper.ExecuteSQL(sql);
}
public bool NewApply(ApplyData apply)
{
SQL sql = CreateSQL("新增申请信息", "insert into " +
" 影像检查申请(申请ID, DcmUID, 患者ID, 申请识别码, 执行院区, 执行科室ID, 检查号, 就诊卡号, 门诊号, 住院号, 影像类别, 申请项目ID, 申请日期, :报到日期, 申请状态, 申请信息) " +
" values " +
" (:申请ID,:DcmUID,:患者ID,:申请识别码,:执行院区,:执行科室ID,:检查号,:就诊卡号,:门诊号,:住院号,:影像类别,:申请项目ID,:申请日期, 报到日期, :申请状态,:申请信息)");
SqlParamInfo[] sqlPars = GetApplyPars(apply);
sql.AddParameterRange(sqlPars);
DataTable dtResult = sql.ExecuteSql();
return(true);
}
/// <summary>
/// 获取报告申请
/// </summary>
/// <param name="applyId"></param>
/// <returns></returns>
public ApplyData GetReportApply(string applyId)
{
SQL sql = CreateSQL("查询报告申请信息", "select * from 影像检查申请 where 申请ID=:申请ID");
sql.AddParameter("申请ID", applyId);
DataTable dtApply = sql.ExecuteSql();
if (dtApply == null || dtApply.Rows.Count <= 0)
{
return(null);
}
ApplyData applyData = new ApplyData();
applyData.BindRowData(dtApply.Rows[0]);
return(applyData);
}
private SqlParamInfo[] GetApplyPars(ApplyData apply)
{
return(new SqlParamInfo[] {
new SqlParamInfo("申请ID", DbType.String, apply.申请ID),
new SqlParamInfo("DcmUID", DbType.String, apply.DcmUID),
new SqlParamInfo("申请识别码", DbType.String, apply.申请识别码),
new SqlParamInfo("患者ID", DbType.String, apply.患者ID),
new SqlParamInfo("执行院区", DbType.String, apply.执行院区),
new SqlParamInfo("执行科室ID", DbType.String, apply.执行科室ID),
new SqlParamInfo("检查号", DbType.String, apply.检查号),
new SqlParamInfo("就诊卡号", DbType.String, apply.就诊卡号),
new SqlParamInfo("门诊号", DbType.String, apply.门诊号),
new SqlParamInfo("住院号", DbType.String, apply.住院号),
new SqlParamInfo("影像类别", DbType.String, apply.影像类别),
new SqlParamInfo("申请项目ID", DbType.String, apply.申请项目ID),
new SqlParamInfo("申请日期", DbType.DateTime, apply.申请日期),
new SqlParamInfo("报到日期", DbType.DateTime, apply.报到日期),
new SqlParamInfo("申请状态", DbType.Int16, apply.申请状态),
new SqlParamInfo("申请信息", DbType.String, apply.申请信息.ToString()),
new SqlParamInfo("申请关联ID", DbType.String, apply.申请关联ID)
});
}
public void DelApply(ApplyData apply)
{
}