class CaseNumber < Comm::BaseModel::Master

  def validate
    emsg = ''
    ars = CaseNumber.find(:all,
                          :conditions => ["warehouse_id=? AND target_year=? AND target_case_id=? AND #{get_sql_cond_null("id", "!=")}",self.warehouse_id, self.target_year, self.target_case_id])
    Rails.logger.debug("□DEBUG:ars:"+ars.inspect)
    record_num = ars.length
    if record_num > 0
       ids = ars.collect{|ar| ar.id}
       emsg << EMJ0005
       emsg << "指定の納品先・年度・症例区分の組み合わせは既に登録されています。"
       emsg << "ID:"+ids.inspect
       raise UserOperationError, emsg
    end
  end

end