private SqlParamInfo[] GetDepartmentInfoPars(DepartmentInfoData departmentInfo)
{
return(new SqlParamInfo[] {
new SqlParamInfo("科室ID", DbType.String, departmentInfo.科室ID),
new SqlParamInfo("科室名称", DbType.String, departmentInfo.科室名称),
new SqlParamInfo("附加数据", DbType.String, departmentInfo.附加数据.ToString())
});
}
/// <summary>
/// 更新科室信息
/// </summary>
/// <param name="departmentInfo"></param>
public void UpdateDepartmentInfo(DepartmentInfoData departmentInfo)
{
string sql = "Update 影像科室信息 " +
" Set 科室名称=:科室名称, 附加数据=:附加数据 where 科室ID=:科室ID";
sql = SqlHelper.GetSqlBiz().GetSqlContext("更新影像科室信息", sql);
SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("科室名称", DbType.String, departmentInfo.科室名称),
new SqlParamInfo("附加数据", DbType.String, departmentInfo.附加数据.ToString()),
new SqlParamInfo("科室ID", DbType.String, departmentInfo.科室ID) };
_dbHelper.ExecuteSQL(sql, sqlPars);
}
/// <summary>
/// 新增科室信息
/// </summary>
/// <param name="departmentInfo"></param>
/// <returns></returns>
public bool NewDepartmentInfo(DepartmentInfoData departmentInfo)
{
string sql = "insert into " +
" 影像科室信息(科室ID, 科室名称, 附加数据) " +
" values " +
" (:科室ID,:科室名称, :附加数据)";
sql = SqlHelper.GetSqlBiz().GetSqlContext("插入影像科室信息", sql);
SqlParamInfo[] sqlPars = GetDepartmentInfoPars(departmentInfo);
DataTable dtResult = _dbHelper.ExecuteSQL(sql, sqlPars);
return(true);
}
